Index: lams_tool_larsrc/db/sql/table-schema.sql =================================================================== diff -u -rf44c4b85fd2563394f045ad28218d3c0b5cbb9da -rdd8218cfa50710015a253505c93a4070e6b29435 --- lams_tool_larsrc/db/sql/table-schema.sql (.../table-schema.sql) (revision f44c4b85fd2563394f045ad28218d3c0b5cbb9da) +++ lams_tool_larsrc/db/sql/table-schema.sql (.../table-schema.sql) (revision dd8218cfa50710015a253505c93a4070e6b29435) @@ -38,18 +38,18 @@ update_date datetime, create_by bigint, title varchar(255), - run_offline tinyint, + run_offline bit, lock_on_finished bit, instructions text, online_instructions text, offline_instructions text, - content_in_use tinyint, - define_later tinyint, + content_in_use bit, + define_later bit, content_id bigint unique, - allow_add_files tinyint, - allow_add_urls tinyint, + allow_add_files bit, + allow_add_urls bit, mini_view_resource_number integer, - allow_auto_run tinyint, + allow_auto_run bit, primary key (uid) ); create table tl_larsrc11_resource_item ( @@ -64,11 +64,12 @@ url text, create_by bigint, create_date datetime, - create_by_author tinyint, - is_hide tinyint, + create_by_author bit, + is_hide bit, item_type smallint, file_type varchar(255), file_name varchar(255), + open_url_new_window bit, resource_uid bigint, session_uid bigint, primary key (uid) @@ -78,7 +79,7 @@ access_date datetime, resource_item_uid bigint, user_uid bigint, - complete tinyint, + complete bit, session_id bigint, primary key (uid) );