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;
UPDATE core_enum SET display_name = name WHERE display_name = '';
-
-
\ No newline at end of file