From: john <john@roojs.com>
Date: Wed, 27 Sep 2017 09:13:19 +0000 (+0800)
Subject: sql/core_enum.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=f036fcd7404a5be265ac9f7cc74b0f1756afaea8

sql/core_enum.sql
---

diff --git a/sql/core_enum.sql b/sql/core_enum.sql
index 90c97445..54cce4f8 100644
--- a/sql/core_enum.sql
+++ b/sql/core_enum.sql
@@ -1,10 +1,12 @@
 CREATE TABLE   core_enum (
   id int(11)  NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (id)
- 
+
 );
- 
+
 alter table  core_enum ADD COLUMN  etype varchar(32)  NOT NULL DEFAULT '';
+alter table core_enum CHANGE COLUMN etype varchar(64)  NOT NULL DEFAULT '';
+
 alter table  core_enum ADD COLUMN  name varchar(255)  NOT NULL DEFAULT '';
 alter table  core_enum ADD COLUMN  active int(2)  NOT NULL DEFAULT 1;
 alter table  core_enum ADD COLUMN  seqid int(11)  NOT NULL DEFAULT 0;
@@ -20,5 +22,3 @@ alter table  core_enum ADD  INDEX lookup_etype_active(etype, active);
 
 
 UPDATE core_enum SET display_name = name WHERE display_name = '';
-
- 
\ No newline at end of file