blob: 5236f0a46314f9c567f0a21bc2a52e538a6a0df9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
CREATE TABLE graphs_items_tmp (
gitemid bigint DEFAULT '0' NOT NULL,
graphid bigint DEFAULT '0' NOT NULL,
itemid bigint DEFAULT '0' NOT NULL,
drawtype integer DEFAULT '0' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
color varchar(32) DEFAULT 'Dark Green' NOT NULL,
yaxisside integer DEFAULT '1' NOT NULL,
calc_fnc integer DEFAULT '2' NOT NULL,
type integer DEFAULT '0' NOT NULL,
periods_cnt integer DEFAULT '5' NOT NULL,
PRIMARY KEY (gitemid)
);
insert into graphs_items_tmp select * from graphs_items;
drop table graphs_items;
alter table graphs_items_tmp rename to graphs_items;
|