Index: lams_common/db/sql/create_lams_11_db.sql =================================================================== diff -u -rfba4690045e6c2de4688618f0a7eb17575068bf3 -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/create_lams_11_db.sql (.../create_lams_11_db.sql) (revision fba4690045e6c2de4688618f0a7eb17575068bf3) +++ lams_common/db/sql/create_lams_11_db.sql (.../create_lams_11_db.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,8 +1,4 @@ --- MySQL Script --- Modify your server name --- Modify username and password for the lams db --- Create lams database for LAMS --- 13/DEC/2004 +-- CVS ID: $Id$ SET FOREIGN_KEY_CHECKS=0; DROP DATABASE IF EXISTS lams; Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -rc70a627b8b3db554d8990ae30f43ae87047abea6 -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision c70a627b8b3db554d8990ae30f43ae87047abea6) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + CREATE TABLE lams_gate_activity_level ( gate_activity_level_id INT(11) NOT NULL DEFAULT 0 , description VARCHAR(128) NOT NULL Index: lams_common/db/sql/create_quartz_table.sql =================================================================== diff -u -rd5e8d7001b9fb1f67ee7216ac92ea3d9012165dd -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision d5e8d7001b9fb1f67ee7216ac92ea3d9012165dd) +++ lams_common/db/sql/create_quartz_table.sql (.../create_quartz_table.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + # LAMS1.1: quartz 1.5.2 table definition # # Quartz seems to work best with the driver mm.mysql-2.0.7-bin.jar Index: lams_common/db/sql/drop_lams_11_tables.sql =================================================================== diff -u -r5466446bd5b33f33336442f717900b7bf46f35cc -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision 5466446bd5b33f33336442f717900b7bf46f35cc) +++ lams_common/db/sql/drop_lams_11_tables.sql (.../drop_lams_11_tables.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + SET FOREIGN_KEY_CHECKS=0; DROP TABLE IF EXISTS lams_activity_category; Index: lams_common/db/sql/insert_survey_design.sql =================================================================== diff -u -r4206c2b9c81db55b984029d55c41bef5abcb4788 -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/insert_survey_design.sql (.../insert_survey_design.sql) (revision 4206c2b9c81db55b984029d55c41bef5abcb4788) +++ lams_common/db/sql/insert_survey_design.sql (.../insert_survey_design.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + insert into lams_learning_design(learning_design_ui_id,description,title,first_activity_id,max_id,valid_design_flag, read_only_flag,user_id,help_text,copy_type_id,create_date_time,version, parent_learning_design_id,workspace_folder_id) Index: lams_common/db/sql/insert_test_data.sql =================================================================== diff -u -r1f475f1357aa1248cd4c31dc6dae4b3473142511 -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 1f475f1357aa1248cd4c31dc6dae4b3473142511) +++ lams_common/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + SET FOREIGN_KEY_CHECKS=0; Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -rbbf487c8bd51b501d9d179415d9c1c73d103fdeb -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision bbf487c8bd51b501d9d179415d9c1c73d103fdeb) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + INSERT INTO lams_role VALUES (1, 'SYSADMIN', 'LAMS System Adminstrator', NOW()); INSERT INTO lams_role VALUES (2, 'ADMIN', 'Organization Adminstrator', NOW()); INSERT INTO lams_role VALUES (3, 'AUTHOR', 'Authors Learning Designs', NOW()); Index: lams_common/db/sql/insert_users.sql =================================================================== diff -u -rc70a627b8b3db554d8990ae30f43ae87047abea6 -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_common/db/sql/insert_users.sql (.../insert_users.sql) (revision c70a627b8b3db554d8990ae30f43ae87047abea6) +++ lams_common/db/sql/insert_users.sql (.../insert_users.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + -- this is similar to insert test data except that it only load -- user/organisation and workspace data. it does not load learning design -- or tool related details. Index: lams_contentrepository/db/sql/useful.sql =================================================================== diff -u -r0a2c5ee66a400c541950f989059eec858b321ac5 -raff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958 --- lams_contentrepository/db/sql/useful.sql (.../useful.sql) (revision 0a2c5ee66a400c541950f989059eec858b321ac5) +++ lams_contentrepository/db/sql/useful.sql (.../useful.sql) (revision aff8cacb06ef0ae5ee1c3ac0559b805e7e1a5958) @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + -- List all nodes, their versions and properties select * from lams_cr_node node left join lams_cr_node_version nv on node.node_id = nv.node_id