blob: 03bb2fb0c52fdbee857fac29a62fcb464654a4aa (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
CREATE TABLE graphs_tmp (
graphid bigint unsigned DEFAULT '0' NOT NULL,
name varchar(128) DEFAULT '' NOT NULL,
width integer DEFAULT '0' NOT NULL,
height integer DEFAULT '0' NOT NULL,
yaxistype integer DEFAULT '0' NOT NULL,
yaxismin double(16,4) DEFAULT '0' NOT NULL,
yaxismax double(16,4) DEFAULT '0' NOT NULL,
templateid bigint unsigned DEFAULT '0' NOT NULL,
show_work_period integer DEFAULT '1' NOT NULL,
show_triggers integer DEFAULT '1' NOT NULL,
graphtype integer DEFAULT '0' NOT NULL,
PRIMARY KEY (graphid)
) ENGINE=InnoDB;
CREATE INDEX graphs_graphs_1 on graphs_tmp (name);
insert into graphs_tmp select *,0 from graphs;
drop table graphs;
alter table graphs_tmp rename graphs;
|
