]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/YYYY.schema.staging-user-setting.sql
forward-port 2.10.5-2.10.6 schema update script
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / YYYY.schema.staging-user-setting.sql
1 BEGIN;
2
3 CREATE TABLE staging.setting_stage (
4         row_id          BIGSERIAL PRIMARY KEY,
5         row_date        TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
6         usrname         TEXT NOT NULL,
7         setting         TEXT NOT NULL,
8         value           TEXT NOT NULL,
9         complete        BOOL DEFAULT FALSE
10 );
11
12 COMMIT;