img_media_type varchar(16) default null,
-- major part of a MIME media type as defined by IANA
- -- see http://www.iana.org/assignments/media-types/
+ -- see https://www.iana.org/assignments/media-types/
img_major_mime varchar(16) not null default 'unknown',
-- minor part of a MIME media type as defined by IANA
-- the minor parts are not required to adher to any standard
-- but should be consistent throughout the database
- -- see http://www.iana.org/assignments/media-types/
+ -- see https://www.iana.org/assignments/media-types/
img_minor_mime nvarchar(100) NOT NULL default 'unknown',
-- Description field as entered by the uploader.
-- A table to track tags for revisions, logs and recent changes.
CREATE TABLE /*_*/change_tag (
+ ct_id int NOT NULL PRIMARY KEY IDENTITY,
-- RCID for the change
ct_rc_id int NULL REFERENCES /*_*/recentchanges(rc_id),
-- LOGID for the change
-- Rollup table to pull a LIST of tags simply without ugly GROUP_CONCAT
-- that only works on MySQL 4.1+
CREATE TABLE /*_*/tag_summary (
+ ts_id int NOT NULL PRIMARY KEY IDENTITY,
-- RCID for the change
ts_rc_id int NULL REFERENCES /*_*/recentchanges(rc_id),
-- LOGID for the change