Message ID | 20170301192001.8184-1-lfleischer@archlinux.org |
---|---|
State | Accepted, archived |
Headers | show
Return-Path: <aur-dev-bounces@archlinux.org> Delivered-To: patchwork@archlinux.org Received: from nymeria.archlinux.org by nymeria.archlinux.org (Dovecot) with LMTP id qcugE+ket1hTYwAAtiB/HQ for <patchwork@archlinux.org>; Wed, 01 Mar 2017 20:20:09 +0100 Received: from nymeria.archlinux.org (localhost.localdomain [127.0.0.1]) by nymeria.archlinux.org (Postfix) with ESMTP id 333FA402F4; Wed, 1 Mar 2017 20:20:07 +0100 (CET) X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on nymeria.archlinux.org X-Spam-Level: X-Spam-Status: No, score=-4.3 required=2.5 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,RCVD_IN_DNSWL_MED shortcircuit=no autolearn=unavailable autolearn_force=no version=3.4.1 Received: from luna.archlinux.org (luna.archlinux.org [5.9.250.164]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by nymeria.archlinux.org (Postfix) with ESMTPS; Wed, 1 Mar 2017 20:20:07 +0100 (CET) Received: from luna.archlinux.org (luna.archlinux.org [127.0.0.1]) by luna.archlinux.org (Postfix) with ESMTP id CDE2E2CC6E; Wed, 1 Mar 2017 19:20:06 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=archlinux.org; s=luna2; t=1488396006; bh=mYESK+BFJUjKiVDw3q+F8JVwfTUMgcOCiXtwkVZ0Qsw=; h=From:To:Date:Subject:List-Id:List-Unsubscribe:List-Archive: List-Post:List-Help:List-Subscribe:Reply-To; b=F7hdE4/KiSH5nsajOcN1cqGvzQklh7tbrbY8+VGREONExeJingRJMEetFhcblnEhM dlLLqDyIlYhnPchHoRHSYBjUNYAMZeH+agr+e9SV4tzhUvDkE9Bnru7U3pIHEfrX0V h/QvYZ/i1RgWeRq5nKPciOiI0YOl9bmAqrUP4EYRGgqEnAxqqsXEsxSG7rx8Hyl59x XBAewRUWyQUqJ22RkJStNiPPsRx6JqosBapArVC35JvX8QKMF2FE2fzDhE6KIZfdCr ogtwOoLQQRRZpYBr6Lymt9UMX9W0w9VxBKmovOZtdq0PF6tw2FLK6Edl1W/1k+O+Mm PLBL0UCVKZ0yZcdPCCXXAZJHEtsYYrpagk+JUG78nw/EqMxH+kqkk350mCceQPjTmX tI/5/o90SLNnnpW/+EMMfaivBmWKblKls9fHnmjZ5/vmFN5Nae4cCF+chD5GxH9+i+ lcoBCt0Hiwo+I4d9eU/SE6qIwm/ERyuReuAuBADNrepNha26l1Uopy3lpqWA9t5iEC SBlrsLUvyNmquTR+1PevCSn6qkGXAsiD3en22OQn96V6VrsZqKoPdSMIEQXTNpTKRv 6RUKo9O9yTNFkQIn5/D+xZGgosHUZ7sEVnrlh0Gt14Y0acKFz8WgUlgPvRGePtJBn6 o+hcXrSn8DDl2I5ROHk2R7PE= Received: from luna.archlinux.org (luna.archlinux.org [127.0.0.1]) by luna.archlinux.org (Postfix) with ESMTP id E011D2365A for <aur-dev@lists.archlinux.org>; Wed, 1 Mar 2017 19:20:02 +0000 (UTC) Received: from nymeria.archlinux.org (nymeria.archlinux.org [IPv6:2a00:1828:2000:547::2]) by luna.archlinux.org (Postfix) with ESMTPS for <aur-dev@lists.archlinux.org>; Wed, 1 Mar 2017 19:20:02 +0000 (UTC) Received: from nymeria.archlinux.org (localhost.localdomain [127.0.0.1]) by nymeria.archlinux.org (Postfix) with ESMTP id A8A16402D6 for <aur-dev@lists.archlinux.org>; Wed, 1 Mar 2017 20:20:01 +0100 (CET) Received: from localhost (unknown [IPv6:2a02:8070:2499:e800:8e70:5aff:fe40:1d18]) (using TLSv1.2 with cipher DHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) (Authenticated sender: lfleischer) by nymeria.archlinux.org (Postfix) with ESMTPSA id 512AA40060 for <aur-dev@archlinux.org>; Wed, 1 Mar 2017 20:20:01 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=archlinux.org; s=nymeria2; t=1488396001; bh=mYESK+BFJUjKiVDw3q+F8JVwfTUMgcOCiXtwkVZ0Qsw=; h=From:To:Subject:Date; b=LiNOhtFRxAmMQ0WJXVWroxa1Anivh+02fQE0ARr9kVl8f4svbpDpIQrgRt4fV3iXV 2q7X4Nji83wNNND/pa8IJzoQ3tMSbFSLo+pHVBqCJAoDx0x0qqw2EjwODKrYLb6NEc aB6cJge4nxAJgZHoMzLipzeROQKL2HbGHvWRc4lYaT/vALmfog+o8P+h5NQRKJ9PCs uz4JASUeSVjmpsyWMThuDj9EwRERvtbJIuRZS3Hd/5I/KcRYAQUBtle69M6871d6y0 DUwkWJoFVNpO9ysv2yS2ArudlFpeHeTPz5AyN/9o5rwXY/lkE16e4oXkGsRPhQh+F2 fNRmexSY/cLxQu4Va2x+FMUXiTUQgLP4Dp5j4ZvF+M4MovkMD39ExR19KAmVQh7s0C CSkJBtKNeKi0GWBSHDi9NW1VN17k00jDzTdkJNjQ7d23xy5JEVr8hl/Gx6zwJt9nFs wb8h/i+YVguHKLim4/aNRW2730gl5Gf9pa08mp2O80juoPz4tHsD9PuMYsTzI2qKD4 K2HCs/wLsYnl/7AkrlihBsmB9ypGZ96hR9ME2GynbXkLRQN2uMSQd52mi+8ObWl0ak lFGqI0Gn7PqGyNEQ6GQXb1FksFhfFAWhRwmU0BHZnktF21STiB4dZM975VlcwTubhP M2ot+pMEltwQ4DuJ0cntKTtQ= From: Lukas Fleischer <lfleischer@archlinux.org> To: aur-dev@archlinux.org Date: Wed, 1 Mar 2017 20:20:00 +0100 Message-Id: <20170301192001.8184-1-lfleischer@archlinux.org> X-Mailer: git-send-email 2.12.0 Subject: [aur-dev] [PATCH 1/2] aur-schema.sql: Do not recreate the database X-BeenThere: aur-dev@archlinux.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "Arch User Repository \(AUR\) Development" <aur-dev.archlinux.org> List-Unsubscribe: <https://lists.archlinux.org/options/aur-dev>, <mailto:aur-dev-request@archlinux.org?subject=unsubscribe> List-Archive: <https://lists.archlinux.org/pipermail/aur-dev/> List-Post: <mailto:aur-dev@archlinux.org> List-Help: <mailto:aur-dev-request@archlinux.org?subject=help> List-Subscribe: <https://lists.archlinux.org/listinfo/aur-dev>, <mailto:aur-dev-request@archlinux.org?subject=subscribe> Reply-To: "Arch User Repository \(AUR\) Development" <aur-dev@archlinux.org> Errors-To: aur-dev-bounces@archlinux.org Sender: "aur-dev" <aur-dev-bounces@archlinux.org> X-UID: 113 Status: X-Keywords: Content-Length: 752 |
Series |
[1/2] aur-schema.sql: Do not recreate the database
|
expand
|
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. --
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(-)