Index: lams_common/db/sql/create_lams_11_db.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_db.sql,v diff -u -r1.5 -r1.6 --- lams_common/db/sql/create_lams_11_db.sql 14 Mar 2006 06:02:27 -0000 1.5 +++ lams_common/db/sql/create_lams_11_db.sql 21 Mar 2006 04:59:04 -0000 1.6 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v diff -u -r1.56 -r1.57 --- lams_common/db/sql/create_lams_11_tables.sql 21 Mar 2006 01:12:58 -0000 1.56 +++ lams_common/db/sql/create_lams_11_tables.sql 21 Mar 2006 04:59:04 -0000 1.57 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/create_quartz_table.sql,v diff -u -r1.1 -r1.2 --- lams_common/db/sql/create_quartz_table.sql 13 Mar 2006 05:51:10 -0000 1.1 +++ lams_common/db/sql/create_quartz_table.sql 21 Mar 2006 04:59:04 -0000 1.2 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/drop_lams_11_tables.sql,v diff -u -r1.26 -r1.27 --- lams_common/db/sql/drop_lams_11_tables.sql 14 Mar 2006 06:02:54 -0000 1.26 +++ lams_common/db/sql/drop_lams_11_tables.sql 21 Mar 2006 04:59:04 -0000 1.27 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_survey_design.sql,v diff -u -r1.3 -r1.4 --- lams_common/db/sql/insert_survey_design.sql 21 Aug 2005 23:47:24 -0000 1.3 +++ lams_common/db/sql/insert_survey_design.sql 21 Mar 2006 04:59:04 -0000 1.4 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_test_data.sql,v diff -u -r1.59 -r1.60 --- lams_common/db/sql/insert_test_data.sql 9 Mar 2006 23:15:59 -0000 1.59 +++ lams_common/db/sql/insert_test_data.sql 21 Mar 2006 04:59:04 -0000 1.60 @@ -1,3 +1,5 @@ +-- CVS ID: $Id$ + SET FOREIGN_KEY_CHECKS=0; Index: lams_common/db/sql/insert_types_data.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_types_data.sql,v diff -u -r1.22 -r1.23 --- lams_common/db/sql/insert_types_data.sql 24 Jan 2006 23:53:34 -0000 1.22 +++ lams_common/db/sql/insert_types_data.sql 21 Mar 2006 04:59:04 -0000 1.23 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_users.sql,v diff -u -r1.5 -r1.6 --- lams_common/db/sql/insert_users.sql 21 Mar 2006 01:12:58 -0000 1.5 +++ lams_common/db/sql/insert_users.sql 21 Mar 2006 04:59:04 -0000 1.6 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_contentrepository/db/sql/useful.sql,v diff -u -r1.1 -r1.2 --- lams_contentrepository/db/sql/useful.sql 6 Jan 2005 23:45:36 -0000 1.1 +++ lams_contentrepository/db/sql/useful.sql 21 Mar 2006 04:57:22 -0000 1.2 @@ -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