diff options
| author | Yorhel <git@yorhel.nl> | 2011-02-16 19:24:13 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2011-02-16 19:24:13 +0100 |
| commit | 49a2516e6b076667e163aaff2ae2e94ed52fa083 (patch) | |
| tree | 46d864db6670f8304353027ad2ea6eec36cff23a /util/updates | |
| parent | cd7b3f34173dfeceec03691957c95f4d4ab9cf47 (diff) | |
chardb: Added image to character entries
Diffstat (limited to 'util/updates')
| -rw-r--r-- | util/updates/update_2.19.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql index 0360feda..462e4eed 100644 --- a/util/updates/update_2.19.sql +++ b/util/updates/update_2.19.sql @@ -75,6 +75,8 @@ CREATE TABLE chars_vns ( PRIMARY KEY(cid, vid, rid) ); +CREATE SEQUENCE charimg_seq; + -- allow characters to be versioned using the changes table @@ -86,6 +88,7 @@ DROP TYPE dbentry_type; ALTER TYPE dbentry_type_tmp RENAME TO dbentry_type; CREATE TRIGGER hidlock_update BEFORE UPDATE ON chars FOR EACH ROW WHEN (OLD.latest IS DISTINCT FROM NEW.latest) EXECUTE PROCEDURE update_hidlock(); +CREATE TRIGGER chars_rev_image_notify AFTER INSERT OR UPDATE ON chars_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE chars_rev_image_notify(); -- load the updated functions |