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 DEFAULT '0' NOT NULL,
screenid bigint DEFAULT '0' NOT NULL,
resourcetype integer DEFAULT '0' NOT NULL,
resourceid bigint 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 to screens_items;
CREATE TABLE screens_items_tmp (
screenitemid bigint DEFAULT '0' NOT NULL,
screenid bigint DEFAULT '0' NOT NULL,
resourcetype integer DEFAULT '0' NOT NULL,
resourceid bigint 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 to screens_items;
|