[1/2] aur-schema.sql: Do not recreate the database

Message ID 20170301192001.8184-1-lfleischer@archlinux.org
State Accepted, archived
Headers show
Series [1/2] aur-schema.sql: Do not recreate the database | expand

Commit Message

Lukas Fleischer March 1, 2017, 7:20 p.m. UTC
Modify the schema such that it only creates the necessary tables,
indices and predefined data. This makes it easier to import the schema
into a database with a name other than "AUR".

Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
---
 schema/aur-schema.sql | 3 ---
 1 file changed, 3 deletions(-)

Patch

diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index b75a257..418e532 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -1,9 +1,6 @@ 
 -- The MySQL database layout for the AUR.  Certain data
 -- is also included such as AccountTypes, etc.
 --
-DROP DATABASE IF EXISTS AUR;
-CREATE DATABASE AUR DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-USE AUR;
 
 -- Define the Account Types for the AUR.
 --