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

Lukas Fleischer lfleischer at archlinux.org
Wed Mar 1 19:20:00 UTC 2017


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 at archlinux.org>
---
 schema/aur-schema.sql | 3 ---
 1 file changed, 3 deletions(-)

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.
 --
-- 
2.12.0


More information about the aur-dev mailing list