1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
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)
);
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)
);
insert into screens_items_tmp select * from screens_items;
drop table screens_items;
alter table screens_items_tmp rename screens_items;
|
