-- Grants for 'mediawiki'@''

GRANT USAGE
    ON *.* TO 'mediawiki'@'%'
    IDENTIFIED BY '<%= @mediawiki_password %>'
    WITH MAX_STATEMENT_TIME 600;

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES, CREATE TEMPORARY TABLES
    ON `%wiki%`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE VIEW, LOCK TABLES
    ON `centralauth`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `cargodb`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `mhglobal`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `testglobal`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `parsercache`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `testparsercache`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `mainstash`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `testmainstash`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER
    ON `incidents`.* TO 'mediawiki'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER
    ON `survey`.* TO 'mediawiki'@'%';

-- Grants for 'cargouser'@''

GRANT USAGE
    ON *.* TO 'cargouser'@'%'
    IDENTIFIED BY '<%= @mediawiki_password %>'
    WITH MAX_STATEMENT_TIME 600;

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    on `%cargo`.* TO 'cargouser'@'%';

-- Grants for 'wikiadmin'@''

GRANT USAGE
    ON *.* TO 'wikiadmin'@'%'
    IDENTIFIED BY '<%= @wikiadmin_password %>';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `%wiki%`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `centralauth`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `cargodb`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `mhglobal`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `testglobal`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `parsercache`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `testparsercache`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `mainstash`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, CREATE, ALTER, INDEX, CREATE VIEW, LOCK TABLES
    ON `testmainstash`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER
    ON `incidents`.* TO 'wikiadmin'@'%';

GRANT SELECT, INSERT, UPDATE, DELETE, DROP, ALTER
    ON `survey`.* TO 'wikiadmin'@'%';