1477 |
19 Oct 05 |
nicklas |
1 |
/* |
1477 |
19 Oct 05 |
nicklas |
$Id$ |
1477 |
19 Oct 05 |
nicklas |
3 |
|
3675 |
16 Aug 07 |
jari |
Copyright (C) 2005 Nicklas Nordborg |
4889 |
06 Apr 09 |
nicklas |
Copyright (C) 2006 Jari Häkkinen |
1477 |
19 Oct 05 |
nicklas |
6 |
|
2304 |
22 May 06 |
jari |
This file is part of BASE - BioArray Software Environment. |
2304 |
22 May 06 |
jari |
Available at http://base.thep.lu.se/ |
1477 |
19 Oct 05 |
nicklas |
9 |
|
1477 |
19 Oct 05 |
nicklas |
BASE is free software; you can redistribute it and/or |
1477 |
19 Oct 05 |
nicklas |
modify it under the terms of the GNU General Public License |
4475 |
05 Sep 08 |
jari |
as published by the Free Software Foundation; either version 3 |
1477 |
19 Oct 05 |
nicklas |
of the License, or (at your option) any later version. |
1477 |
19 Oct 05 |
nicklas |
14 |
|
1477 |
19 Oct 05 |
nicklas |
BASE is distributed in the hope that it will be useful, |
1477 |
19 Oct 05 |
nicklas |
but WITHOUT ANY WARRANTY; without even the implied warranty of |
1477 |
19 Oct 05 |
nicklas |
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
1477 |
19 Oct 05 |
nicklas |
GNU General Public License for more details. |
1477 |
19 Oct 05 |
nicklas |
19 |
|
1477 |
19 Oct 05 |
nicklas |
You should have received a copy of the GNU General Public License |
4509 |
11 Sep 08 |
jari |
along with BASE. If not, see <http://www.gnu.org/licenses/>. |
1477 |
19 Oct 05 |
nicklas |
22 |
|
1477 |
19 Oct 05 |
nicklas |
23 |
============================================================== |
1477 |
19 Oct 05 |
nicklas |
24 |
|
1477 |
19 Oct 05 |
nicklas |
A simple sequence of SQL commands that create a Base2 database |
1477 |
19 Oct 05 |
nicklas |
for the PostgreSQL database. |
1477 |
19 Oct 05 |
nicklas |
27 |
|
1477 |
19 Oct 05 |
nicklas |
This file should be executed by the psql command-line tool: |
1477 |
19 Oct 05 |
nicklas |
29 |
|
1477 |
19 Oct 05 |
nicklas |
psql -f createdb.postgres.sql template1 |
1477 |
19 Oct 05 |
nicklas |
31 |
|
1477 |
19 Oct 05 |
nicklas |
Before executing this file it is a good idea to change the |
1477 |
19 Oct 05 |
nicklas |
default password to something else. Do not forget to |
1477 |
19 Oct 05 |
nicklas |
make the corresponding change in your base.config file. |
1477 |
19 Oct 05 |
nicklas |
35 |
|
1477 |
19 Oct 05 |
nicklas |
It is also possible to change the username (base2user) |
1477 |
19 Oct 05 |
nicklas |
database name (base2) and schema name (dynamic) to something |
1477 |
19 Oct 05 |
nicklas |
else. If yo do, do not forget to make the corresponding changes |
1477 |
19 Oct 05 |
nicklas |
in your base.config file. |
1477 |
19 Oct 05 |
nicklas |
40 |
*/ |
1477 |
19 Oct 05 |
nicklas |
CREATE USER "base2user" PASSWORD 'password'; |
4637 |
17 Nov 08 |
nicklas |
CREATE DATABASE "base2" OWNER "base2user" ENCODING 'UTF8'; |
1477 |
19 Oct 05 |
nicklas |
\c "base2" |
1477 |
19 Oct 05 |
nicklas |
CREATE SCHEMA "dynamic" AUTHORIZATION "base2user"; |