"id" INTEGER PRIMARY KEY NOT NULL,
"bytea" blob,
"blob" blob,
- "blob2" blob,
"clob" clob,
- "clob2" clob,
"a_memo" memo
);
CREATE INDEX "fourkeys_to_twokeys_idx_t_artist_t_cd" ON "fourkeys_to_twokeys" ("t_artist", "t_cd");
CREATE VIEW "year2000cds" AS
- SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = "2000";
+ SELECT cdid, artist, title, year, genreid, single_track FROM cd WHERE year = '2000';