Index: lams_tool_larsrc/db/sql/table-schema.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/table-schema.sql,v diff -u -r1.8 -r1.9 --- lams_tool_larsrc/db/sql/table-schema.sql 27 Apr 2006 02:37:45 -0000 1.8 +++ lams_tool_larsrc/db/sql/table-schema.sql 2 May 2006 06:34:01 -0000 1.9 @@ -38,18 +38,18 @@ update_date datetime, create_by bigint, title varchar(255), - run_offline bit, + run_offline tinyint, lock_on_finished bit, instructions text, online_instructions text, offline_instructions text, - content_in_use bit, - define_later bit, + content_in_use tinyint, + define_later tinyint, content_id bigint unique, - allow_add_files bit, - allow_add_urls bit, + allow_add_files tinyint, + allow_add_urls tinyint, mini_view_resource_number integer, - allow_auto_run bit, + allow_auto_run tinyint, primary key (uid) ); create table tl_larsrc11_resource_item ( @@ -64,8 +64,8 @@ url text, create_by bigint, create_date datetime, - create_by_author bit, - is_hide bit, + create_by_author tinyint, + is_hide tinyint, item_type smallint, file_type varchar(255), file_name varchar(255), @@ -78,7 +78,7 @@ access_date datetime, resource_item_uid bigint, user_uid bigint, - complete bit, + complete tinyint, session_id bigint, primary key (uid) );