6 CREATE TABLE builder_modules (
7 id int(11) NOT NULL AUTO_INCREMENT,
11 ALTER TABLE builder_modules ADD COLUMN name varchar(128) NOT NULL;
12 ALTER TABLE builder_modules ADD COLUMN path varchar(254) NOT NULL;
13 ALTER TABLE builder_modules ADD COLUMN public int(11) NOT NULL DEFAULT '0';
14 ALTER TABLE builder_modules ADD COLUMN database_dsn VARCHAR(254) NOT NULL DEFAULT '';
17 CREATE TABLE builder_part (
18 id int(11) NOT NULL AUTO_INCREMENT,
22 ALTER TABLE builder_part ADD COLUMN module_id int(11) NOT NULL;
23 ALTER TABLE builder_part ADD COLUMN name varchar(254) NOT NULL;
24 ALTER TABLE builder_part ADD COLUMN json longtext NOT NULL DEFAULT '';
25 ALTER TABLE builder_part ADD COLUMN jsource longtext NOT NULL DEFAULT '';
26 ALTER TABLE builder_part ADD COLUMN updated DATETIME ;
29 -- ALTER TABLE builder_part ALTER COLUMN json SET DEFAULT '';
32 CREATE TABLE builder_tables (
33 id int(11) NOT NULL AUTO_INCREMENT,
37 ALTER TABLE builder_tables ADD COLUMN name varchar(128) NOT NULL DEFAULT '';
38 ALTER TABLE builder_tables ADD COLUMN descrip text NOT NULL DEFAULT '';
39 ALTER TABLE builder_tables ADD COLUMN parent_id int(11) NOT NULL DEFAULT '';
40 ALTER TABLE builder_tables ADD COLUMN dbschema text NOT NULL DEFAULT '';
42 ALTER TABLE builder_tables CHANGE COLUMN descrip text NOT NULL DEFAULT '';
43 -- ALTER TABLE builder_tables ALTER COLUMN descrip TYPE text;
44 -- ALTER TABLE builder_tables ALTER COLUMN descrip SET DEFAULT '';
45 -- ALTER TABLE builder_tables ALTER COLUMN name SET DEFAULT '';
46 -- ALTER TABLE builder_tables ALTER COLUMN dbschema SET DEFAULT '';
49 ALTER TABLE builder_tables ADD INDEX lookup(parent_id, name);
51 -- ALTER TABLE builder_tables COMMENT = 'list of tables (with relations ships and grouping)';
52 -- COMMENT ON TABLE builder_tables IS 'list of tables (with relations ships and grouping)';