Index: lams_contentrepository/db/sql/create_content_repository_tables.sql =================================================================== diff -u -r74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7 -rce142bc43a9462537c3c578e9ed2bac72d600375 --- lams_contentrepository/db/sql/create_content_repository_tables.sql (.../create_content_repository_tables.sql) (revision 74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7) +++ lams_contentrepository/db/sql/create_content_repository_tables.sql (.../create_content_repository_tables.sql) (revision ce142bc43a9462537c3c578e9ed2bac72d600375) @@ -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 =================================================================== diff -u -r74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7 -rce142bc43a9462537c3c578e9ed2bac72d600375 --- lams_contentrepository/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision 74b2a31b3cbb7e2d019a2b505a2c3e7f882a19a7) +++ lams_contentrepository/db/sql/insert_test_data.sql (.../insert_test_data.sql) (revision ce142bc43a9462537c3c578e9ed2bac72d600375) @@ -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");