diff options
| -rw-r--r-- | populate.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/populate.sql b/populate.sql index f23edcc..f94da2f 100644 --- a/populate.sql +++ b/populate.sql @@ -1,12 +1,16 @@ /* CREATE OR REPLACE DATABASE ded CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; */ +/* CREATE USER 'web'@'localhost'; */ +/* GRANT SELECT, INDEX, INSERT, UPDATE, DELETE, CREATE, DROP ON ded.* TO 'web'@'localhost'; */ +/* ALTER USER 'web'@'localhost' IDENTIFIED BY 'dedpassword'; */ + /* Switch to using it. */ USE ded; /* Create the Operations table */ SET FOREIGN_KEY_CHECKS = 0; -DROP TABLE organisations; -DROP TABLE operations; +DROP TABLE IF EXISTS organisations; +DROP TABLE IF EXISTS operations; SET FOREIGN_KEY_CHECKS = 1; /* Create the Organisations table. */ |