diff options
Diffstat (limited to 'upgrades/dbpatches/1.3/postgresql/patch.sql')
| -rw-r--r-- | upgrades/dbpatches/1.3/postgresql/patch.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/upgrades/dbpatches/1.3/postgresql/patch.sql b/upgrades/dbpatches/1.3/postgresql/patch.sql new file mode 100644 index 00000000..b705ba6c --- /dev/null +++ b/upgrades/dbpatches/1.3/postgresql/patch.sql @@ -0,0 +1,20 @@ + +alter table graphs add graphtype int2 DEFAULT '0' NOT NULL; +alter table items add delay_flex varchar(255) DEFAULT "" NOT NULL; + +-- +-- Table structure for table 'services_times' +-- + +CREATE TABLE services_times ( + timeid serial, + serviceid int4 DEFAULT '0' NOT NULL, + type int2 DEFAULT '0' NOT NULL, + ts_from int4 DEFAULT '0' NOT NULL, + ts_to int4 DEFAULT '0' NOT NULL, + note varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (timeid) +) type=InnoDB; + +CREATE UNIQUE INDEX services_times_uniq on services_times (serviceid,type,ts_from,ts_to); + |