Index: lams_tool_larsrc/db/sql/table-schema.sql
===================================================================
diff -u -r2116db454fd0ec719a6deeaacd9d10306d341b93 -rf3709b5af90ca8439a64e65b0c971bc547b1eb3a
--- lams_tool_larsrc/db/sql/table-schema.sql	(.../table-schema.sql)	(revision 2116db454fd0ec719a6deeaacd9d10306d341b93)
+++ lams_tool_larsrc/db/sql/table-schema.sql	(.../table-schema.sql)	(revision f3709b5af90ca8439a64e65b0c971bc547b1eb3a)
@@ -1,7 +1,9 @@
 alter table tl_larsrc11_attachment drop foreign key FK1E7009430E79035;
 alter table tl_larsrc11_item_instruction drop foreign key FKA5665013980570ED;
 alter table tl_larsrc11_resource drop foreign key FK89093BF758092FB;
+alter table tl_larsrc11_resource_item drop foreign key FKF52D1F93758092FB;
 alter table tl_larsrc11_resource_item drop foreign key FKF52D1F9330E79035;
+alter table tl_larsrc11_resource_item drop foreign key FKF52D1F93EC0D3147;
 alter table tl_larsrc11_session drop foreign key FK24AA78C530E79035;
 alter table tl_larsrc11_user drop foreign key FK30113BFC506CD584;
 drop table if exists tl_larsrc11_attachment;
@@ -56,7 +58,14 @@
    init_item varchar(255),
    organization_xml text,
    title varchar(255),
+   url text,
+   create_by bigint,
+   create_date datetime,
+   create_by_author bit,
+   is_hide bit,
+   item_type smallint,
    resource_uid bigint,
+   session_uid bigint,
    primary key (uid)
 );
 create table tl_larsrc11_session (
@@ -81,6 +90,8 @@
 alter table tl_larsrc11_attachment add index FK1E7009430E79035 (resource_uid), add constraint FK1E7009430E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
 alter table tl_larsrc11_item_instruction add index FKA5665013980570ED (item_uid), add constraint FKA5665013980570ED foreign key (item_uid) references tl_larsrc11_resource_item (uid);
 alter table tl_larsrc11_resource add index FK89093BF758092FB (create_by), add constraint FK89093BF758092FB foreign key (create_by) references tl_larsrc11_user (uid);
+alter table tl_larsrc11_resource_item add index FKF52D1F93758092FB (create_by), add constraint FKF52D1F93758092FB foreign key (create_by) references tl_larsrc11_user (uid);
 alter table tl_larsrc11_resource_item add index FKF52D1F9330E79035 (resource_uid), add constraint FKF52D1F9330E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
+alter table tl_larsrc11_resource_item add index FKF52D1F93EC0D3147 (session_uid), add constraint FKF52D1F93EC0D3147 foreign key (session_uid) references tl_larsrc11_session (uid);
 alter table tl_larsrc11_session add index FK24AA78C530E79035 (resource_uid), add constraint FK24AA78C530E79035 foreign key (resource_uid) references tl_larsrc11_resource (uid);
 alter table tl_larsrc11_user add index FK30113BFC506CD584 (session_id), add constraint FK30113BFC506CD584 foreign key (session_id) references tl_larsrc11_session (uid);
