From 00ba8a1f862e1c2fcf4cde358600396a3edc837a Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 26 Jul 2016 11:18:37 +0800 Subject: [PATCH] DataObjects/builder.sql --- DataObjects/builder.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/DataObjects/builder.sql b/DataObjects/builder.sql index b296fdc..76378a3 100644 --- a/DataObjects/builder.sql +++ b/DataObjects/builder.sql @@ -39,7 +39,7 @@ ALTER TABLE builder_tables ADD COLUMN descrip text NOT NULL DEFAULT ''; 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 CHANGE COLUMN descrip text ; -- 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 ''; -- 2.39.2