diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/screens_items.sql')
-rw-r--r-- | upgrades/dbpatches/1.3/mysql/patch/screens_items.sql | 45 |
1 files changed, 0 insertions, 45 deletions
diff --git a/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql b/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql deleted file mode 100644 index 2dabadae..00000000 --- a/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql +++ /dev/null @@ -1,45 +0,0 @@ -CREATE TABLE screens_items_tmp ( - screenitemid bigint unsigned NOT NULL auto_increment, - screenid bigint unsigned DEFAULT '0' NOT NULL, - resourcetype integer DEFAULT '0' NOT NULL, - resourceid bigint unsigned DEFAULT '0' NOT NULL, - width integer DEFAULT '320' NOT NULL, - height integer DEFAULT '200' NOT NULL, - x integer DEFAULT '0' NOT NULL, - y integer DEFAULT '0' NOT NULL, - colspan integer DEFAULT '0' NOT NULL, - rowspan integer DEFAULT '0' NOT NULL, - elements integer DEFAULT '25' NOT NULL, - valign integer DEFAULT '0' NOT NULL, - halign integer DEFAULT '0' NOT NULL, - style integer DEFAULT '0' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (screenitemid) -) ENGINE=InnoDB; - -insert into screens_items_tmp select NULL,screenid,resourcetype,resourceid,width,height,x,y,colspan,rowspan,elements,valign,halign,style,url from screens_items; -drop table screens_items; -alter table screens_items_tmp rename screens_items; - -CREATE TABLE screens_items_tmp ( - screenitemid bigint unsigned DEFAULT '0' NOT NULL, - screenid bigint unsigned DEFAULT '0' NOT NULL, - resourcetype integer DEFAULT '0' NOT NULL, - resourceid bigint unsigned DEFAULT '0' NOT NULL, - width integer DEFAULT '320' NOT NULL, - height integer DEFAULT '200' NOT NULL, - x integer DEFAULT '0' NOT NULL, - y integer DEFAULT '0' NOT NULL, - colspan integer DEFAULT '0' NOT NULL, - rowspan integer DEFAULT '0' NOT NULL, - elements integer DEFAULT '25' NOT NULL, - valign integer DEFAULT '0' NOT NULL, - halign integer DEFAULT '0' NOT NULL, - style integer DEFAULT '0' NOT NULL, - url varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (screenitemid) -) ENGINE=InnoDB; - -insert into screens_items_tmp select * from screens_items; -drop table screens_items; -alter table screens_items_tmp rename screens_items; |