From 3577326b2b32bad2765cdacd2959dd4fea48c2f8 Mon Sep 17 00:00:00 2001 From: Loui Chang Date: Thu, 28 Feb 2008 11:37:39 -0500 Subject: Make all references to AUR database consistent Signed-off-by: Loui Chang Signed-off-by: Simo Leone --- support/schema/aur-schema.sql | 6 +++--- web/README.txt | 8 ++++---- web/lib/config.inc.proto | 2 +- 3 files changed, 8 insertions(+), 8 deletions(-) diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 371f140a..d123595a 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -1,9 +1,9 @@ -- The MySQL database layout for the AUR. Certain data -- is also included such as AccountTypes, PackageLocations, etc. -- -DROP DATABASE aur; -CREATE DATABASE aur; -use aur; +DROP DATABASE AUR; +CREATE DATABASE AUR; +USE AUR; -- Define the Account Types for the AUR. -- diff --git a/web/README.txt b/web/README.txt index 09a0c286..1c4dfa5f 100644 --- a/web/README.txt +++ b/web/README.txt @@ -40,14 +40,14 @@ Setup on ArchLinux: # mysql -uroot - Issue the following commands to the mysql client - mysql> create database aur; - mysql> grant all privileges on aur.* to aur@localhost + mysql> CREATE DATABASE AUR; + mysql> GRANT ALL PRIVILEGES ON AUR.* to aur@localhost > identified by 'aur'; - mysql> flush privileges; + mysql> FLUSH PRIVILEGES; mysql> quit - Load the schema file - # mysql -uaur -p aur < ~/aur/support/schema/aur-schema.sql + # mysql -uaur -p AUR < ~/aur/support/schema/aur-schema.sql (give password 'aur' at the prompt) - Optionally load some test data for development purposes. diff --git a/web/lib/config.inc.proto b/web/lib/config.inc.proto index b0f7615f..80eba6e5 100644 --- a/web/lib/config.inc.proto +++ b/web/lib/config.inc.proto @@ -2,7 +2,7 @@ # NOTE: modify these variables if your MySQL setup is different # define( "AUR_db_host", "localhost:/tmp/mysql.sock" ); -define( "AUR_db_name", "aur" ); +define( "AUR_db_name", "AUR" ); define( "AUR_db_user", "aur" ); define( "AUR_db_pass", "aur" ); -- cgit v1.2.3-24-g4f1b