Index: lams_contentrepository/db/sql/create_content_repository_tables.sql =================================================================== RCS file: /usr/local/cvsroot/lams_contentrepository/db/sql/Attic/create_content_repository_tables.sql,v diff -u -r1.6 -r1.7 --- lams_contentrepository/db/sql/create_content_repository_tables.sql 11 Jan 2005 10:47:08 -0000 1.6 +++ lams_contentrepository/db/sql/create_content_repository_tables.sql 12 Jan 2005 01:46:26 -0000 1.7 @@ -63,6 +63,7 @@ path varchar(255), type varchar(255) NOT NULL, created_date_time timestamp(14) NOT NULL, + next_version_id bigint(20) unsigned NOT NULL default '1', PRIMARY KEY (node_id), UNIQUE KEY node_id (node_id), KEY workspace_id (workspace_id), Index: lams_contentrepository/db/sql/insert_test_data.sql =================================================================== RCS file: /usr/local/cvsroot/lams_contentrepository/db/sql/Attic/insert_test_data.sql,v diff -u -r1.7 -r1.8 --- lams_contentrepository/db/sql/insert_test_data.sql 11 Jan 2005 10:47:08 -0000 1.7 +++ lams_contentrepository/db/sql/insert_test_data.sql 12 Jan 2005 01:46:26 -0000 1.8 @@ -14,7 +14,7 @@ INSERT INTO lams_cr_workspace (workspace_id, name) VALUES (1, 'atoolWorkspace'); INSERT INTO lams_cr_workspace_credential (wc_id, workspace_id, credential_id) VALUES (1, 1,1); -INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path) VALUES (1, 1, 'DATANODE', 20050106103100, "/test"); +INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path, next_version_id) VALUES (1, 1, 'DATANODE', 20050106103100, "/test",3); INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time) VALUES (1, 1, 1, 20050106103100); INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time) @@ -26,7 +26,7 @@ INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (4,2,"VERSIONDESC","The second version.","STRING"); -- Note : this file node is missing its file as can't setup the repository -INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path) VALUES (2, 1, 'FILENODE', 20050106103100, ""); +INSERT INTO lams_cr_node (node_id, workspace_id, type, created_date_time, path, next_version_id) VALUES (2, 1, 'FILENODE', 20050106103100, "", 2); INSERT INTO lams_cr_node_version (nv_id, node_id, version_id, created_date_time) VALUES (3, 2, 1, 20050106103100); INSERT INTO lams_cr_node_version_property( id, nv_id, name, value, type) VALUES (5,3,"VERSIONDESC","Initial Version.","STRING");