From ca454eeada6ee3960010c05a2786b12c76549697 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 26 Jul 2016 11:17:41 +0800 Subject: [PATCH] DataObjects/builder.sql --- DataObjects/builder.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/DataObjects/builder.sql b/DataObjects/builder.sql index bb5f382..79fc4a1 100644 --- a/DataObjects/builder.sql +++ b/DataObjects/builder.sql @@ -40,10 +40,10 @@ ALTER TABLE builder_tables ADD COLUMN parent_id int(11) NOT NULL DEFAULT ''; ALTER TABLE builder_tables ADD COLUMN dbschema text NOT NULL DEFAULT ''; ALTER TABLE builder_tables CHANGE COLUMN descrip text NOT NULL DEFAULT ''; -ALTER TABLE builder_tables ALTER COLUMN descrip TYPE text; -ALTER TABLE builder_tables ALTER COLUMN descrip SET DEFAULT ''; -ALTER TABLE builder_tables ALTER COLUMN name SET DEFAULT ''; -ALTER TABLE builder_tables ALTER COLUMN dbschema SET DEFAULT ''; +-- ALTER TABLE builder_tables ALTER COLUMN descrip TYPE text; +-- ALTER TABLE builder_tables ALTER COLUMN descrip SET DEFAULT ''; +-- ALTER TABLE builder_tables ALTER COLUMN name SET DEFAULT ''; +-- ALTER TABLE builder_tables ALTER COLUMN dbschema SET DEFAULT ''; ALTER TABLE builder_tables ADD INDEX lookup(parent_id, name); -- 2.39.2