fix #8131 - chinese translations

[Pman.Core] / sql / core_company.sql

diff --git a/sql/core_company.sql b/sql/core_company.sql
index ad5c518..1df8d9f 100644 (file)
--- a/sql/core_company.sql
+++ b/sql/core_company.sql
@@ -4,8 +4,11 @@ CREATE TABLE core_company (
 );
 
 
-ALTER TABLE core_company ADD COLUMN    code varchar(32)  NOT NULL DEFAULT '';;
-ALTER TABLE core_company ADD COLUMN    name varchar(128)  default NULL ;
+ALTER TABLE core_company CHANGE COLUMN  code  code varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_company ADD COLUMN    code varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE core_company CHANGE COLUMN    name name varchar(254)  default NULL ;
+
+ALTER TABLE core_company ADD COLUMN    name varchar(254)  default NULL ;
 ALTER TABLE core_company ADD COLUMN    remarks text ;
 ALTER TABLE core_company ADD COLUMN    owner_id int(11) NOT NULL DEFAULT 0 ;
 ALTER TABLE core_company ADD COLUMN    address text ;
@@ -31,24 +34,36 @@ ALTER TABLE core_company ADD COLUMN    comptype varchar(32)  NOT NULL DEFAULT ''
 -- not sure if this needs to change.. << there is code in core/update that fills this in??
 ALTER TABLE core_company ADD COLUMN    comptype_id INT(11) DEFAULT 0;
 
+ALTER TABLE core_company ADD COLUMN  parent_id INT NOT NULL DEFAULT 0;
+
 
+ 
 ALTER TABLE core_company CHANGE COLUMN isOwner isOwner int(11);
+
 ALTER TABLE core_company CHANGE COLUMN comptype comptype  VARCHAR(32) DEFAULT '';
+
 -- postres
 -- ALTER TABLE core_company ALTER isOwner TYPE int(11);
 ALTER TABLE core_company ALTER owner_id SET DEFAULT 0;
 ALTER TABLE core_company ALTER url SET DEFAULT '';
 
+ 
+
 ALTER TABLE core_company ADD COLUMN    address1 text ;
 ALTER TABLE core_company ADD COLUMN    address2 text ;
 ALTER TABLE core_company ADD COLUMN    address3 text ;
 ALTER TABLE core_company ADD COLUMN is_system INT(2) NOT NULL DEFAULT 0;-- #2028
 
-ALTER TABLE core_company ADD INDEX name_lookup (name);
 
 ALTER TABLE core_company ADD COLUMN deleted_by INT(11)  NOT NULL DEFAULT 0;
+alter table core_company CHANGE COLUMN  deleted_dt deleted_dt datetime NOT NULL DEFAULT '1000-01-01 00:00:00';
+ALTER TABLE core_company ADD COLUMN deleted_dt DATETIME  NOT NULL DEFAULT '1000-00-00'; 
+
+-- indexs
 
-ALTER TABLE core_company ADD COLUMN deleted_dt DATETIME  NOT NULL DEFAULT '0000-00-00'; 
+
+ALTER TABLE core_company ADD INDEX name_lookup (name);
+ALTER TABLE core_company ADD INDEX lookup_owner_id (owner_id);
 
 -- our new code should have this fixed now..
 -- UPDATE core_company set comptype='OWNER' where isOwner=1;