Index: lams_webct_integration/db/sql/createTable_MySql.sql =================================================================== diff -u -rcf736e782de985fb389edc999a1588ea9d8893f6 -r14d46b3314d205f74c8e8752c84e44b74219c9cd --- lams_webct_integration/db/sql/createTable_MySql.sql (.../createTable_MySql.sql) (revision cf736e782de985fb389edc999a1588ea9d8893f6) +++ lams_webct_integration/db/sql/createTable_MySql.sql (.../createTable_MySql.sql) (revision 14d46b3314d205f74c8e8752c84e44b74219c9cd) @@ -1,5 +1,5 @@ -DROP TABLE IF EXISTS ${dbTable}; -CREATE TABLE ${dbTable} +DROP TABLE IF EXISTS webct_lams_lesson; +CREATE TABLE webct_lams_lesson ( id bigint NOT NULL auto_increment, pt_id bigint NOT NULL, @@ -18,5 +18,5 @@ PRIMARY KEY (id), UNIQUE KEY (lesson_id) ); -CREATE UNIQUE INDEX ${dbTable}_lesson_id ON ${dbTable} (lesson_id ASC, pt_id ASC); +CREATE UNIQUE INDEX webct_lams_lesson_lesson_id ON webct_lams_lesson (lesson_id ASC, pt_id ASC); COMMIT; \ No newline at end of file