diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-03-27 08:40:50 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-03-27 08:40:50 +0000 |
| commit | 49110c625d5aafe8a6927a98801c456ce211cda2 (patch) | |
| tree | 04e76cf212e316559afa893583fdbde26d4180ad /upgrades | |
| parent | 959e63ff54c6c636bd93111e2ab57cf77e3c2249 (diff) | |
| download | zabbix-49110c625d5aafe8a6927a98801c456ce211cda2.tar.gz zabbix-49110c625d5aafe8a6927a98801c456ce211cda2.tar.xz zabbix-49110c625d5aafe8a6927a98801c456ce211cda2.zip | |
Misc fixed for make dist.
git-svn-id: svn://svn.zabbix.com/trunk@3937 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/dbpatches/1.3/oracle/patch.sql | 35 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.3/oracle/patch/patch.sql | 0 |
2 files changed, 0 insertions, 35 deletions
diff --git a/upgrades/dbpatches/1.3/oracle/patch.sql b/upgrades/dbpatches/1.3/oracle/patch.sql deleted file mode 100644 index 159b427e..00000000 --- a/upgrades/dbpatches/1.3/oracle/patch.sql +++ /dev/null @@ -1,35 +0,0 @@ - -alter table graphs add graphtype number(2) DEFAULT '0' NOT NULL; -alter table items add delay_flex varchar(255) DEFAULT NULL; - --- --- Table structure for table 'services_times' --- - -CREATE TABLE services_times ( - timeid number(10) NOT NULL auto_increment, - serviceid number(10) DEFAULT '0' NOT NULL, - type number(3) DEFAULT '0' NOT NULL, - ts_from number(10) DEFAULT '0' NOT NULL, - ts_to number(10) DEFAULT '0' NOT NULL, - note varchar(255) DEFAULT NULL, - CONSTRAINT services_times_pk PRIMARY KEY (timeid) -) type=InnoDB; - -CREATE INDEX services_times_servicid on services_times (serviceid); -CREATE UNIQUE INDEX services_times_uniq on services_times (serviceid,type,ts_from,ts_to); - -create sequence services_times_timeid -start with 20000 -increment by 1 -nomaxvalue; - -create trigger services_times -before insert on services_times -for each row -begin - if (:new.timeid is null or :new.timeid = 0) then - select services_times_timeid.nextval into :new.timeid from dual; - end if; -end; -/ diff --git a/upgrades/dbpatches/1.3/oracle/patch/patch.sql b/upgrades/dbpatches/1.3/oracle/patch/patch.sql new file mode 100644 index 00000000..e69de29b --- /dev/null +++ b/upgrades/dbpatches/1.3/oracle/patch/patch.sql |