diff options
Diffstat (limited to 'www/wiki/extensions/UploadWizard/UploadWizard.postgres.sql')
-rw-r--r-- | www/wiki/extensions/UploadWizard/UploadWizard.postgres.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/extensions/UploadWizard/UploadWizard.postgres.sql b/www/wiki/extensions/UploadWizard/UploadWizard.postgres.sql new file mode 100644 index 00000000..0984d9e1 --- /dev/null +++ b/www/wiki/extensions/UploadWizard/UploadWizard.postgres.sql @@ -0,0 +1,18 @@ +-- PostgreSQL version of the database schema for the Upload Wizard extension. +-- Licence: GNU GPL v2+ +-- Author: Jeroen De Dauw < jeroendedauw@gmail.com >, Jeff Janes < jeff.janes@gmail.com > + +-- Upload wizard campaigns +-- This is *not* the primary storage for campaigns. +-- Just stores a copy of information that is already present in the +-- appropriate wikipages, for easier indexing / querying +CREATE SEQUENCE uw_campaigns_campaign_id_seq; +CREATE TABLE uw_campaigns ( + campaign_id INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('uw_campaigns_campaign_id_seq'), + campaign_name VARCHAR(255) NOT NULL, + campaign_enabled INTEGER NOT NULL default '0' +); + +CREATE UNIQUE INDEX uw_campaigns_name ON uw_campaigns (campaign_name); +-- Since we sort on campaign_id for pagination +CREATE INDEX uw_campaigns_enabled ON uw_campaigns (campaign_enabled, campaign_id); |