Last change
on this file since 26899 was 26899, checked in by davidb, 11 years ago |
Tipple reborn after Chris's Summer of Code 2013
|
File size:
632 bytes
|
Line | |
---|
1 | -- Add an action table for the purpose of capturing all actions applied to a database.
|
---|
2 | -- The table is populated during application of a changeset, then osmosisUpdate is called,
|
---|
3 | -- then the table is cleared all within a single database transaction.
|
---|
4 | -- The contents of this table can be used to update derivative tables by customising the
|
---|
5 | -- osmosisUpdate stored procedure.
|
---|
6 |
|
---|
7 | -- Create a table for actions.
|
---|
8 | CREATE TABLE actions (
|
---|
9 | data_type character(1) NOT NULL,
|
---|
10 | action character(1) NOT NULL,
|
---|
11 | id bigint NOT NULL
|
---|
12 | );
|
---|
13 |
|
---|
14 | -- Add primary key.
|
---|
15 | ALTER TABLE ONLY actions ADD CONSTRAINT pk_actions PRIMARY KEY (data_type, id);
|
---|
Note:
See
TracBrowser
for help on using the repository browser.