summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.3/mysql/patch/screens_items.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.3/mysql/patch/screens_items.sql')
-rw-r--r--upgrades/dbpatches/1.3/mysql/patch/screens_items.sql45
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;