Updates populate file with correct set up

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. */