Page MenuHomeWickedGov Phorge
Files F4105146

patch-notice_regions.sql
No OneTemporary
Actions

Size
457 B
Referenced Files
None
Subscribers
None

patch-notice_regions.sql
View Options

-- Adds geotargeted regions for notices.
CREATE TABLE IF NOT EXISTS /*_*/cn_notice_regions (
nr_notice_id int(10) unsigned NOT NULL,
nr_region varchar(6) NOT NULL
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/nr_notice_id_region ON /*_*/cn_notice_regions (nr_notice_id, nr_region);
-- Add a regions field to cn_notice_log
ALTER TABLE /*_*/cn_notice_log ADD `notlog_begin_regions` text;
ALTER TABLE /*_*/cn_notice_log ADD `notlog_end_regions` text;

File Metadata

Mime Type
text/plain
Expires
Tue, Aug 18, 18:50 (2 w, 6 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
c2/31/f8c6183ff7eb774e4aa8bd981377
Default Alt Text
patch-notice_regions.sql (457 B)

Event Timeline