From 695df4bdda6962c3152602e7007e38260a5fa1a7 Mon Sep 17 00:00:00 2001
From: Matthew Lemon <y@yulqen.org>
Date: Mon, 12 Feb 2024 10:06:30 +0000
Subject: Updates populate file with correct set up

---
 populate.sql | 8 ++++++--
 1 file 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. */
-- 
cgit v1.2.3