git.freeside.biz Git - freeside.git/blob - rt/etc/upgrade/4.1.8/schema.Oracle

projects / freeside.git / blob

summary | shortlog | log | commit | commitdiff | tree
history | raw | HEAD

[freeside.git] / rt / etc / upgrade / 4.1.8 / schema.Oracle

1 ALTER TABLE Tickets ADD IsMerged NUMBER(11,0) DEFAULT NULL NULL;

2 UPDATE Tickets SET IsMerged = 1 WHERE id != EffectiveId;

Freeside billing, trouble ticketing, network monitoring and provisioning