Index: lams_common/properties.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_common/Attic/properties.xml,v
diff -u -r1.11 -r1.12
--- lams_common/properties.xml	9 Feb 2005 03:57:19 -0000	1.11
+++ lams_common/properties.xml	28 Feb 2005 06:03:25 -0000	1.12
@@ -59,7 +59,7 @@
 	<property name="package.usermanagement.name"   value="${package}.usermanagement"/>
 	
 	<!--  database related properties -->
-	<property name="database.driver.file"          value="${lib}/mysql/mysql-connector-java-3.0.16-ga-bin.jar"/>   
+	<property name="database.driver.file"          value="${lib}/mysql/mysql-connector-java-3.1.7-bin.jar"/>   
 	<property name="database.driver.classpath"     value="${database.driver.file}"/>
 	<property name="database.driver"               value="org.gjt.mm.mysql.Driver"/>
 	<property name="database.url"                  value="jdbc:mysql://localhost/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.31 -r1.32
--- lams_common/db/sql/create_lams_11_tables.sql	27 Feb 2005 23:47:37 -0000	1.31
+++ lams_common/db/sql/create_lams_11_tables.sql	28 Feb 2005 06:01:18 -0000	1.32
@@ -36,7 +36,7 @@
        role_id INT(6) NOT NULL DEFAULT 0
      , name VARCHAR(64) NOT NULL
      , description TEXT
-     , create_date BIGINT(20)
+     , create_date DATETIME 
      , PRIMARY KEY (role_id)
 )TYPE=InnoDB;
 CREATE INDEX gname ON lams_role (name ASC);
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.26 -r1.27
--- lams_common/db/sql/insert_test_data.sql	27 Feb 2005 23:52:19 -0000	1.26
+++ lams_common/db/sql/insert_test_data.sql	28 Feb 2005 06:03:02 -0000	1.27
@@ -37,10 +37,10 @@
 INSERT INTO lams_authentication_method VALUES (3, 3, 'MQ-LDAP');
 
 INSERT INTO lams_activity_category VALUES (1 ,'SYSTEM');
-INSERT INTO lams_activity_category VALUES (1 ,'COLLABORATION');
-INSERT INTO lams_activity_category VALUES (1 ,'ASSESSMENT');
-INSERT INTO lams_activity_category VALUES (1 ,'CONTENT');
-INSERT INTO lams_activity_category VALUES (1 ,'SPLIT');
+INSERT INTO lams_activity_category VALUES (2 ,'COLLABORATION');
+INSERT INTO lams_activity_category VALUES (3 ,'ASSESSMENT');
+INSERT INTO lams_activity_category VALUES (4 ,'CONTENT');
+INSERT INTO lams_activity_category VALUES (5 ,'SPLIT');
 
 insert into lams_workspace_folder (parent_folder_id,name,workspace_id) values(null,'Trial',1);
 
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.12 -r1.13
--- lams_common/db/sql/insert_types_data.sql	16 Feb 2005 21:58:24 -0000	1.12
+++ lams_common/db/sql/insert_types_data.sql	28 Feb 2005 06:01:18 -0000	1.13
@@ -5,7 +5,7 @@
 # Connection: ROOT LOCAL
 # Host: localhost
 # Saved: 2005-02-15 11:44:49
-# 
+ 
 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());
@@ -55,12 +55,12 @@
 INSERT INTO lams_lesson_state VALUES (5, 'FINISHED');
 INSERT INTO lams_lesson_state VALUES (6, 'ARCHIVED');
 
-INSERT into lams_license VALUES (1, 'Attribution-Noncommercial-ShareAlike', 'by-nc-sa', 'http://creativecommons.org/licenses/by-nc-sa/2.0/', 'true', '');
-INSERT into lams_license VALUES (2, 'Other Licensing Agreement', 'other', '','false', '');
-INSERT into lams_license VALUES (3, 'Attribution-No Derivatives', 'by-nd', 'http://creativecommons.org/licenses/by-nd/2.0/','false','');
-INSERT into lams_license VALUES (4, 'Attribution-Noncommercial-No Derivatives', 'by-nc-nd', 'http://creativecommons.org/licenses/by-nc-nd/2.0/','false', '');
-INSERT into lams_license VALUES (5, 'Attribution-Noncommercial', 'by-nc', 'http://creativecommons.org/licenses/by-nc/2.0/','false','');
-INSERT into lams_license VALUES (6, 'Attribution-ShareAlike', 'by-sa', 'http://creativecommons.org/licenses/by-sa/2.0/','false',''); 
+INSERT into lams_license VALUES (1, 'Attribution-Noncommercial-ShareAlike', 'by-nc-sa', 'http://creativecommons.org/licenses/by-nc-sa/2.0/', 1, '');
+INSERT into lams_license VALUES (2, 'Other Licensing Agreement', 'other', '',0, '');
+INSERT into lams_license VALUES (3, 'Attribution-No Derivatives', 'by-nd', 'http://creativecommons.org/licenses/by-nd/2.0/',0,'');
+INSERT into lams_license VALUES (4, 'Attribution-Noncommercial-No Derivatives', 'by-nc-nd', 'http://creativecommons.org/licenses/by-nc-nd/2.0/',0, '');
+INSERT into lams_license VALUES (5, 'Attribution-Noncommercial', 'by-nc', 'http://creativecommons.org/licenses/by-nc/2.0/',0,'');
+INSERT into lams_license VALUES (6, 'Attribution-ShareAlike', 'by-sa', 'http://creativecommons.org/licenses/by-sa/2.0/',0,''); 
 
 INSERT into lams_copy_type VALUES(1,'NONE');
 INSERT into lams_copy_type VALUES(2,'LESSON');
Index: lams_common/lib/mysql/mysql-connector-java-3.1.7-bin.jar
===================================================================
RCS file: /usr/local/cvsroot/lams_common/lib/mysql/Attic/mysql-connector-java-3.1.7-bin.jar,v
diff -u
Binary files differ