From bc0e1825981dd2b88a316ad4bc36e3e4311f2ac8 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 20 Aug 2013 16:18:22 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 3d41456e..a17900f8 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -341,10 +341,10 @@ ALTER TABLE core_locking ADD COLUMN person_id int(11) NOT NULL DEFAULT 0; ALTER TABLE core_locking ADD COLUMN created datetime ; alter table core_locking ADD INDEX lookup(on_table, on_id, person_id, created); -# -- oops... - wrong name of pid. +-- oops... - wrong name of pid. alter table core_locking change column `int` id int(11) auto_increment not null; -# -- a generic enumeraction +-- a generic enumeraction CREATE TABLE core_enum ( id int(11) NOT NULL AUTO_INCREMENT, @@ -359,13 +359,17 @@ alter table core_enum ADD COLUMN seqid int(11) NOT NULL DEFAULT 0; alter table core_enum ADD COLUMN seqmax int(11) NOT NULL DEFAULT 0; alter table core_enum ADD COLUMN display_name varchar(255) NOT NULL DEFAULT ''; + +ALTER TABLE core_enum ADD COLUMN is_system_enum INT(2) NOT NULL DEFAULT 0; +ALTER TABLE core_enum CHANGE COLUMN display_name display_name TEXT NOT NULL DEFAULT ''; + alter table core_enum ADD INDEX lookup(seqid, active, name, etype); + UPDATE core_enum SET display_name = name WHERE display_name = ''; -ALTER TABLE core_enum ADD COLUMN is_system_enum INT(2) NOT NULL DEFAULT 0; -ALTER TABLE core_enum CHANGE COLUMN display_name display_name TEXT NOT NULL DEFAULT ''; +-- ---------------------------- CREATE TABLE translations ( id int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2