Page MenuHomeWickedGov Phorge
Files F4071072

tables-generated.sql
No OneTemporary
Actions

Size
8 KB
Referenced Files
None
Subscribers
None

tables-generated.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaSql.php.
-- Source: sql/tables.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TABLE cn_notices (
not_id SERIAL NOT NULL,
not_name VARCHAR(255) NOT NULL,
not_start TIMESTAMPTZ NOT NULL,
not_end TIMESTAMPTZ NOT NULL,
not_enabled SMALLINT DEFAULT 0 NOT NULL,
not_preferred SMALLINT DEFAULT 0 NOT NULL,
not_throttle INT DEFAULT 100 NOT NULL,
not_locked SMALLINT DEFAULT 0 NOT NULL,
not_geo SMALLINT DEFAULT 0 NOT NULL,
not_buckets SMALLINT DEFAULT 1 NOT NULL,
not_weight INT DEFAULT 100 NOT NULL,
not_mobile_carrier SMALLINT DEFAULT 0 NOT NULL,
not_archived SMALLINT DEFAULT 0 NOT NULL,
not_type VARCHAR(255) DEFAULT NULL,
PRIMARY KEY(not_id)
);
CREATE TABLE cn_assignments (
asn_id SERIAL NOT NULL,
not_id INT NOT NULL,
tmp_id INT NOT NULL,
tmp_weight INT NOT NULL,
asn_bucket SMALLINT DEFAULT 0,
PRIMARY KEY(asn_id)
);
CREATE INDEX asn_not ON cn_assignments (not_id);
CREATE INDEX asn_tmp ON cn_assignments (tmp_id);
CREATE INDEX asn_bucket ON cn_assignments (asn_bucket);
CREATE TABLE cn_templates (
tmp_id SERIAL NOT NULL,
tmp_name VARCHAR(255) DEFAULT NULL,
tmp_display_anon SMALLINT DEFAULT 1 NOT NULL,
tmp_display_account SMALLINT DEFAULT 1 NOT NULL,
tmp_fundraising SMALLINT DEFAULT 0 NOT NULL,
tmp_autolink SMALLINT DEFAULT 0 NOT NULL,
tmp_landing_pages VARCHAR(255) DEFAULT NULL,
tmp_archived SMALLINT DEFAULT 0 NOT NULL,
tmp_category VARCHAR(255) DEFAULT NULL,
tmp_preview_sandbox SMALLINT DEFAULT 0 NOT NULL,
tmp_is_template SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY(tmp_id)
);
CREATE INDEX tmp_name ON cn_templates (tmp_name);
CREATE INDEX tmp_category ON cn_templates (tmp_category);
CREATE TABLE cn_notice_languages (
nl_notice_id INT NOT NULL,
nl_language VARCHAR(32) NOT NULL,
PRIMARY KEY(nl_notice_id, nl_language)
);
CREATE TABLE cn_notice_projects (
np_notice_id INT NOT NULL,
np_project VARCHAR(32) NOT NULL,
PRIMARY KEY(np_notice_id, np_project)
);
CREATE TABLE cn_notice_countries (
nc_notice_id INT NOT NULL,
nc_country VARCHAR(2) NOT NULL,
PRIMARY KEY(nc_notice_id, nc_country)
);
CREATE TABLE cn_notice_regions (
nr_notice_id INT NOT NULL,
nr_region VARCHAR(6) NOT NULL,
PRIMARY KEY(nr_notice_id, nr_region)
);
CREATE TABLE cn_template_mixins (
tmxn_id SERIAL NOT NULL,
tmp_id INT NOT NULL,
page_id INT NOT NULL,
mixin_name VARCHAR(255) NOT NULL,
PRIMARY KEY(tmxn_id)
);
CREATE INDEX tmxn_tmp_id ON cn_template_mixins (tmp_id);
CREATE INDEX tmxn_page_id ON cn_template_mixins (page_id);
CREATE INDEX tmxn_mixin_name ON cn_template_mixins (mixin_name);
CREATE TABLE cn_notice_mixins (
nmxn_id SERIAL NOT NULL,
nmxn_not_id INT NOT NULL,
nmxn_mixin_name VARCHAR(255) NOT NULL,
nmxn_enabled SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY(nmxn_id)
);
CREATE INDEX nmxn_not_id_idx ON cn_notice_mixins (nmxn_not_id);
CREATE INDEX nmxn_mixin_name_idx ON cn_notice_mixins (nmxn_mixin_name);
CREATE UNIQUE INDEX nmxn_not_id_mixin_name ON cn_notice_mixins (nmxn_not_id, nmxn_mixin_name);
CREATE TABLE cn_notice_mixin_params (
nmxnp_id SERIAL NOT NULL,
nmxnp_notice_mixin_id INT NOT NULL,
nmxnp_param_name VARCHAR(255) NOT NULL,
nmxnp_param_value TEXT NOT NULL,
PRIMARY KEY(nmxnp_id)
);
CREATE INDEX nmxnp_notice_mixin_id_idx ON cn_notice_mixin_params (nmxnp_notice_mixin_id);
CREATE INDEX nmxnp_param_name_value_idx ON cn_notice_mixin_params (
nmxnp_param_name, nmxnp_param_value
);
CREATE UNIQUE INDEX nmxn_notice_mixin_id_param_name ON cn_notice_mixin_params (
nmxnp_notice_mixin_id, nmxnp_param_name
);
CREATE TABLE cn_known_devices (
dev_id SERIAL NOT NULL,
dev_name VARCHAR(255) NOT NULL,
dev_display_label TEXT NOT NULL,
PRIMARY KEY(dev_id)
);
CREATE INDEX dev_name ON cn_known_devices (dev_name);
CREATE TABLE cn_template_devices (
tdev_id SERIAL NOT NULL,
tmp_id INT NOT NULL,
dev_id INT NOT NULL,
PRIMARY KEY(tdev_id)
);
CREATE INDEX tdev_template_id ON cn_template_devices (tmp_id);
CREATE TABLE cn_known_mobile_carriers (
mc_id SERIAL NOT NULL,
mc_name VARCHAR(255) NOT NULL,
mc_display_label TEXT NOT NULL,
PRIMARY KEY(mc_id)
);
CREATE INDEX mc_name ON cn_known_mobile_carriers (mc_name);
CREATE TABLE cn_notice_mobile_carriers (
nmc_id SERIAL NOT NULL,
not_id INT NOT NULL,
mc_id INT NOT NULL,
PRIMARY KEY(nmc_id)
);
CREATE INDEX nmc_not_id ON cn_notice_mobile_carriers (not_id);
CREATE INDEX nmc_carrier_id ON cn_notice_mobile_carriers (mc_id);
CREATE TABLE cn_notice_log (
notlog_id SERIAL NOT NULL,
notlog_timestamp TIMESTAMPTZ NOT NULL,
notlog_user_id INT NOT NULL,
notlog_action TEXT DEFAULT 'modified' NOT NULL,
notlog_not_id INT NOT NULL,
notlog_not_name VARCHAR(255) DEFAULT NULL,
notlog_begin_projects VARCHAR(255) DEFAULT NULL,
notlog_end_projects VARCHAR(255) DEFAULT NULL,
notlog_begin_languages TEXT DEFAULT NULL,
notlog_end_languages TEXT DEFAULT NULL,
notlog_begin_countries TEXT DEFAULT NULL,
notlog_end_countries TEXT DEFAULT NULL,
notlog_begin_regions TEXT DEFAULT NULL,
notlog_end_regions TEXT DEFAULT NULL,
notlog_begin_start TIMESTAMPTZ DEFAULT NULL,
notlog_end_start TIMESTAMPTZ DEFAULT NULL,
notlog_begin_end TIMESTAMPTZ DEFAULT NULL,
notlog_end_end TIMESTAMPTZ DEFAULT NULL,
notlog_begin_enabled SMALLINT DEFAULT NULL,
notlog_end_enabled SMALLINT DEFAULT NULL,
notlog_begin_preferred SMALLINT DEFAULT NULL,
notlog_end_preferred SMALLINT DEFAULT NULL,
notlog_begin_throttle INT DEFAULT NULL,
notlog_end_throttle INT DEFAULT NULL,
notlog_begin_locked SMALLINT DEFAULT NULL,
notlog_end_locked SMALLINT DEFAULT NULL,
notlog_begin_geo SMALLINT DEFAULT NULL,
notlog_end_geo SMALLINT DEFAULT NULL,
notlog_begin_banners TEXT DEFAULT NULL,
notlog_end_banners TEXT DEFAULT NULL,
notlog_begin_buckets SMALLINT DEFAULT NULL,
notlog_end_buckets SMALLINT DEFAULT NULL,
notlog_begin_mobile_carrier INT DEFAULT NULL,
notlog_end_mobile_carrier INT DEFAULT NULL,
notlog_begin_weight INT DEFAULT NULL,
notlog_end_weight INT DEFAULT NULL,
notlog_begin_archived SMALLINT DEFAULT NULL,
notlog_end_archived SMALLINT DEFAULT NULL,
notlog_begin_mixins TEXT DEFAULT NULL,
notlog_end_mixins TEXT DEFAULT NULL,
notlog_comment VARCHAR(255) DEFAULT NULL,
notlog_begin_type VARCHAR(255) DEFAULT NULL,
notlog_end_type VARCHAR(255) DEFAULT NULL,
PRIMARY KEY(notlog_id)
);
CREATE INDEX notlog_timestamp ON cn_notice_log (notlog_timestamp);
CREATE INDEX notlog_user_id ON cn_notice_log (
notlog_user_id, notlog_timestamp
);
CREATE INDEX notlog_not_id ON cn_notice_log (notlog_not_id, notlog_timestamp);
CREATE TABLE cn_template_log (
tmplog_id SERIAL NOT NULL,
tmplog_timestamp TIMESTAMPTZ NOT NULL,
tmplog_user_id INT NOT NULL,
tmplog_action TEXT DEFAULT 'modified' NOT NULL,
tmplog_template_id INT NOT NULL,
tmplog_template_name VARCHAR(255) DEFAULT NULL,
tmplog_begin_anon SMALLINT DEFAULT NULL,
tmplog_end_anon SMALLINT DEFAULT NULL,
tmplog_begin_account SMALLINT DEFAULT NULL,
tmplog_end_account SMALLINT DEFAULT NULL,
tmplog_begin_fundraising SMALLINT DEFAULT NULL,
tmplog_end_fundraising SMALLINT DEFAULT NULL,
tmplog_begin_autolink SMALLINT DEFAULT NULL,
tmplog_end_autolink SMALLINT DEFAULT NULL,
tmplog_begin_landingpages VARCHAR(255) DEFAULT NULL,
tmplog_end_landingpages VARCHAR(255) DEFAULT NULL,
tmplog_content_change SMALLINT DEFAULT 0,
tmplog_begin_prioritylangs TEXT DEFAULT NULL,
tmplog_end_prioritylangs TEXT DEFAULT NULL,
tmplog_begin_archived SMALLINT DEFAULT NULL,
tmplog_end_archived SMALLINT DEFAULT NULL,
tmplog_begin_category VARCHAR(255) DEFAULT NULL,
tmplog_end_category VARCHAR(255) DEFAULT NULL,
tmplog_begin_preview_sandbox SMALLINT DEFAULT NULL,
tmplog_end_preview_sandbox SMALLINT DEFAULT NULL,
tmplog_begin_controller_mixin TEXT DEFAULT NULL,
tmplog_end_controller_mixin TEXT DEFAULT NULL,
tmplog_begin_devices TEXT DEFAULT NULL,
tmplog_end_devices TEXT DEFAULT NULL,
tmplog_comment VARCHAR(255) DEFAULT NULL,
PRIMARY KEY(tmplog_id)
);
CREATE INDEX tmplog_timestamp ON cn_template_log (tmplog_timestamp);
CREATE INDEX tmplog_user_id ON cn_template_log (
tmplog_user_id, tmplog_timestamp
);
CREATE INDEX tmplog_template_id ON cn_template_log (
tmplog_template_id, tmplog_timestamp
);

File Metadata

Mime Type
text/plain
Expires
Aug 17 2026, 02:50 (12 w, 17 h ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
dc/54/2881338b1245137a0af6ac4df020
Default Alt Text
tables-generated.sql (8 KB)

Event Timeline