|
From: Benjamin C. <bc...@us...> - 2001-08-17 03:03:00
|
Update of /cvsroot/phpbt/phpbt In directory usw-pr-cvs1:/tmp/cvs-serv5249 Modified Files: dbchanges.sql Log Message: Tinyints for booleans instead of chars Index: dbchanges.sql =================================================================== RCS file: /cvsroot/phpbt/phpbt/dbchanges.sql,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- dbchanges.sql 2001/08/16 13:37:27 1.1 +++ dbchanges.sql 2001/08/17 03:02:57 1.2 @@ -60,7 +60,7 @@ `component_name` varchar(30) NOT NULL default '', `component_desc` text NOT NULL, `owner` int(10) unsigned NOT NULL default '0', - `active` char(1) binary NOT NULL default '1', + `active` tinyint(1) NOT NULL default '1', `created_by` int(10) unsigned NOT NULL default '0', `created_date` bigint(20) unsigned NOT NULL default '0', `last_modified_by` int(10) unsigned NOT NULL default '0', @@ -82,7 +82,7 @@ `project_id` int(10) unsigned NOT NULL default '0', `project_name` varchar(30) NOT NULL default '', `project_desc` text NOT NULL, - `active` char(1) binary NOT NULL default '1', + `active` tinyint(1) NOT NULL default '1', `created_by` int(10) unsigned NOT NULL default '0', `created_date` bigint(20) unsigned NOT NULL default '0', `last_modified_by` int(10) unsigned NOT NULL default '0', @@ -146,7 +146,7 @@ `version_id` int(10) unsigned NOT NULL default '0', `project_id` int(10) unsigned NOT NULL default '0', `version_name` char(10) NOT NULL default '', - `active` char(1) binary NOT NULL default '', + `active` tinyint(1) NOT NULL default '1', `created_by` int(10) unsigned NOT NULL default '0', `created_date` bigint(20) unsigned NOT NULL default '0', `last_modified_by` int(10) unsigned NOT NULL default '0', |