DataObjects/core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 10b5338..c2f4a9b 100644 (file)
--- 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,