Changeset 288 for ZMS/trunk/import/zmssqldb/zgadfly.cd.sql

Timestamp:

12.11.2008 19:02:38 (4 years ago)

Author:

chris

Message:

zms-2.11.1-150

File:

• ZMS/trunk/import/zmssqldb/zgadfly.cd.sql (modified) (1 diff)

ZMS/trunk/import/zmssqldb/zgadfly.cd.sql

@@ -14 +14 @@
 insert into cdtracks (cd_id, track_id, track_title, track_duration, track_info, sort_id) values ( 4712, 8, 'Rain Fall Down', '4:54', '', 40);
 insert into cdtracks (cd_id, track_id, track_title, track_duration, track_info, sort_id) values ( 4712, 9, 'Streets of Love', '5:10', '', 50);
+create table cdreviews (cd_id integer, review_id integer, review_author varchar, review_timestamp varchar, review_title varchar, review_content varchar);
+insert into cdreviews (cd_id, review_id, review_author, review_timestamp, review_title, review_content) values ( 4711, 1, 'F. Lieberman', '2005-01-01.12.00.00', 'Excellent!', 'Excellent sound, the best Pink Floyd record ever!');