Yuvipanda has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/326076 )
Change subject: labsdb: Fixup maintain-dbusers.sql
......................................................................
labsdb: Fixup maintain-dbusers.sql
- Remove trailing comma (AGAIN)
- Call the table 'account' and not accounts (using singular than
plural)
Change-Id: Ife2c95a8e3a7259fb35f197b7cbdae1d3861b1a1
---
M modules/role/files/labs/db/maintain-dbusers.sql
1 file changed, 3 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/puppet
refs/changes/76/326076/1
diff --git a/modules/role/files/labs/db/maintain-dbusers.sql
b/modules/role/files/labs/db/maintain-dbusers.sql
index aed2265..afb5a32 100644
--- a/modules/role/files/labs/db/maintain-dbusers.sql
+++ b/modules/role/files/labs/db/maintain-dbusers.sql
@@ -3,14 +3,14 @@
-- Schema is set up to be able to trivially query the following things:
-- 1. What labsdb hosts does this tool / user *not* have an account on.
-- 2. What's the mysql username / password for this tool / user.
-CREATE TABLE accounts(
+CREATE TABLE account(
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
mysql_username VARCHAR(255) NOT NULL,
type enum('tool', 'user') NOT NULL,
username VARCHAR(255) NOT NULL,
- password_hash BINARY(41) NOT NULL, -- MySQL password hash format
+ password_hash BINARY(41) NOT NULL -- MySQL password hash format
) ENGINE=InnoDB ROW_FORMAT=Dynamic CHARSET=utf8mb4;
-CREATE UNIQUE INDEX account_type ON accounts(type, username);
+CREATE UNIQUE INDEX account_type ON account(type, username);
CREATE TABLE account_hosts(
id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
--
To view, visit https://gerrit.wikimedia.org/r/326076
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ife2c95a8e3a7259fb35f197b7cbdae1d3861b1a1
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Yuvipanda <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
