From f036fcd7404a5be265ac9f7cc74b0f1756afaea8 Mon Sep 17 00:00:00 2001 From: john Date: Wed, 27 Sep 2017 17:13:19 +0800 Subject: [PATCH] sql/core_enum.sql --- sql/core_enum.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) 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 -- 2.39.2