Niharika29 has uploaded a new change for review.
https://gerrit.wikimedia.org/r/186144
Change subject: Add campaign_id column to proposals table
......................................................................
Add campaign_id column to proposals table
Bug: T87306
Change-Id: I000ed00b8a0444df443d7c09ebd43d187e8f6927
---
A data/db/migrations/20152101-add-campaignid-to-proposals.sql
M data/db/schema.mysql
2 files changed, 7 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/iegreview
refs/changes/44/186144/1
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..cf03404
--- /dev/null
+++ b/data/db/migrations/20152101-add-campaignid-to-proposals.sql
@@ -0,0 +1,6 @@
+-- Add a campaign id to proposals table.
+-- Bug: T87306
+
+ALTER TABLE proposals
+ ADD COLUMN campaign_id INT(11) NOT NULL
+ AFTER id;
diff --git a/data/db/schema.mysql b/data/db/schema.mysql
index 68ad91b..e79eb89 100644
--- a/data/db/schema.mysql
+++ b/data/db/schema.mysql
@@ -25,6 +25,7 @@
CREATE TABLE IF NOT EXISTS proposals (
id INT(11) NOT NULL AUTO_INCREMENT
+ , campaign_id INT(11) NOT NULL
, title VARCHAR(255) BINARY NOT NULL
, description BLOB
, url VARCHAR(1023) BINARY
--
To view, visit https://gerrit.wikimedia.org/r/186144
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I000ed00b8a0444df443d7c09ebd43d187e8f6927
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/iegreview
Gerrit-Branch: master
Gerrit-Owner: Niharika29 <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
