jenkins-bot has submitted this change and it was merged.
Change subject: Add campaign column to proposals table
......................................................................
Add campaign column to proposals table
Bug: T87306
Change-Id: I000ed00b8a0444df443d7c09ebd43d187e8f6927
---
A data/db/migrations/20152101-add-campaignid-to-proposals.sql
M data/db/migrations/20152101-add-campaigns-table.sql
M data/db/schema.mysql
3 files changed, 27 insertions(+), 13 deletions(-)
Approvals:
BryanDavis: Looks good to me, approved
jenkins-bot: Verified
diff --git a/data/db/migrations/20152101-add-campaignid-to-proposals.sql
b/data/db/migrations/20152101-add-campaignid-to-proposals.sql
new file mode 100644
index 0000000..ed6f11a
--- /dev/null
+++ b/data/db/migrations/20152101-add-campaignid-to-proposals.sql
@@ -0,0 +1,8 @@
+-- Add a campaign id to proposals table.
+-- Bug: T87306
+
+SET foreign_key_checks = 0;
+ALTER TABLE proposals
+ ADD COLUMN campaign INT(11) NOT NULL AFTER id,
+ ADD FOREIGN KEY (campaign) REFERENCES campaigns(id) ON DELETE CASCADE;
+SET foreign_key_checks = 1;
diff --git a/data/db/migrations/20152101-add-campaigns-table.sql
b/data/db/migrations/20152101-add-campaigns-table.sql
index c40ab9c..6d1cf91 100644
--- a/data/db/migrations/20152101-add-campaigns-table.sql
+++ b/data/db/migrations/20152101-add-campaigns-table.sql
@@ -5,11 +5,13 @@
CREATE TABLE IF NOT EXISTS campaigns (
id INT(11) NOT NULL AUTO_INCREMENT
- , name VARCHAR(255) NOT NULL UNIQUE
+ , name VARCHAR(255) NOT NULL
, created_by INT(11)
, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
, status TINYINT(1) DEFAULT 0
, start_date TIMESTAMP NOT NULL
, end_date TIMESTAMP NOT NULL
, PRIMARY KEY (id)
-) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ;
\ No newline at end of file
+ , UNIQUE KEY name (name)
+ , CONSTRAINT FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ;
diff --git a/data/db/schema.mysql b/data/db/schema.mysql
index c5b0081..fe799d0 100644
--- a/data/db/schema.mysql
+++ b/data/db/schema.mysql
@@ -23,8 +23,22 @@
, UNIQUE (setting_name)
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8;
+CREATE TABLE IF NOT EXISTS campaigns (
+ id INT(11) NOT NULL AUTO_INCREMENT
+ , name VARCHAR(255) NOT NULL
+ , created_by INT(11)
+ , created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+ , status TINYINT(1) DEFAULT 0
+ , start_date TIMESTAMP NOT NULL
+ , end_date TIMESTAMP NOT NULL
+ , PRIMARY KEY (id)
+ , UNIQUE KEY name (name)
+ , CONSTRAINT FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET NULL
+) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ;
+
CREATE TABLE IF NOT EXISTS proposals (
id INT(11) NOT NULL AUTO_INCREMENT
+ , campaign INT(11) NOT NULL
, title VARCHAR(255) BINARY NOT NULL
, description BLOB
, url VARCHAR(1023) BINARY
@@ -37,6 +51,7 @@
, modified_by INT(11)
, modified_at TIMESTAMP
, PRIMARY KEY (id)
+ , CONSTRAINT FOREIGN KEY (campaign) REFERENCES campaigns(id) ON DELETE
CASCADE
, CONSTRAINT FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET NULL
, CONSTRAINT FOREIGN KEY (modified_by) REFERENCES users(id) ON DELETE SET
NULL
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ;
@@ -61,14 +76,3 @@
, CONSTRAINT FOREIGN KEY (proposal) REFERENCES proposals(id) ON DELETE
CASCADE
, CONSTRAINT FOREIGN KEY (reviewer) REFERENCES users(id) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ;
-
-CREATE TABLE IF NOT EXISTS campaigns (
- id INT(11) NOT NULL AUTO_INCREMENT
- , name VARCHAR(255) NOT NULL UNIQUE
- , created_by INT(11)
- , created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
- , status TINYINT(1) DEFAULT 0
- , start_date TIMESTAMP NOT NULL
- , end_date TIMESTAMP NOT NULL
- , PRIMARY KEY (id)
-) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 ;
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/186144
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I000ed00b8a0444df443d7c09ebd43d187e8f6927
Gerrit-PatchSet: 6
Gerrit-Project: wikimedia/iegreview
Gerrit-Branch: master
Gerrit-Owner: Niharika29 <[email protected]>
Gerrit-Reviewer: BryanDavis <[email protected]>
Gerrit-Reviewer: Springle <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
