![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
![]() |
Reported By: Richard Harding Reported On: 7/22/2010 For: Version 2.03 Build 17 |
CREATE TABLE "ClientEpisode" ( "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 281, INCREMENT BY 1) NOT NULL, "ClientID" INTEGER NOT NULL, "EpisodeDate" TIMESTAMP NOT NULL, <more stuff> CONSTRAINT "cePrimaryKey" PRIMARY KEY ("ID") ) CREATE INDEX "ceClientDateIND" ON "ClientEpisode" ("ClientID", "EpisodeDate" DESC) CREATE INDEX "ceClientIND" ON "ClientEpisode" ("ClientID", "EpisodeDate") SELECT * FROM ClientEpisode ORDER BY ClientID, EpisodeDate ASC SELECT * FROM ClientEpisode ORDER BY ClientID, EpisodeDate DESC
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |