From 77787863772c3629185c16d471c449116c24178f Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Sun, 13 Feb 2011 20:36:14 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 10b53382..c2f4a9bd 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -113,24 +113,24 @@ ALTER TABLE Groups CHANGE COLUMN type type int(11) default 0; CREATE TABLE `Office` ( `id` int(11) NOT NULL auto_increment, `company_id` int(11) NOT NULL default '0', - `name` varchar(64) character set latin1 NOT NULL, - `address` text character set latin1 NOT NULL, - `phone` varchar(32) character set latin1 NOT NULL, - `fax` varchar(32) character set latin1 NOT NULL, - `email` varchar(128) character set latin1 NOT NULL, - `role` varchar(32) character set latin1 NOT NULL, + `name` varchar(64) NOT NULL, + `address` text NOT NULL, + `phone` varchar(32) NOT NULL, + `fax` varchar(32) NOT NULL, + `email` varchar(128) NOT NULL, + `role` varchar(32) NOT NULL, PRIMARY KEY (`id`) ); CREATE TABLE `Person` ( `id` int(11) NOT NULL auto_increment, `office_id` int(11) default '0', - `name` varchar(128) character set latin1 NOT NULL, - `phone` varchar(32) character set latin1 NOT NULL, - `fax` varchar(32) character set latin1 NOT NULL, - `email` varchar(128) character set latin1 NOT NULL, + `name` varchar(128) NOT NULL, + `phone` varchar(32) NOT NULL, + `fax` varchar(32) NOT NULL, + `email` varchar(128) NOT NULL, `company_id` int(11) default '0', - `role` varchar(32) character set latin1 NOT NULL, + `role` varchar(32) NOT NULL, `active` int(11) default NULL, `remarks` text NOT NULL, `passwd` varchar(64) NOT NULL, -- 2.39.2