source: trunk/misc/sql/createdb.postgres.sql @ 3679

Last change on this file since 3679 was 3679, checked in by Jari Häkkinen, 15 years ago

Changing the pesky "a (ä) character to a.

File size: 1.6 KB
Line 
1/*
2  $Id$
3
4  Copyright (C) 2005 Nicklas Nordborg
5  Copyright (C) 2006 Jari Hakkinen
6
7  This file is part of BASE - BioArray Software Environment.
8  Available at http://base.thep.lu.se/
9
10  BASE is free software; you can redistribute it and/or
11  modify it under the terms of the GNU General Public License
12  as published by the Free Software Foundation; either version 2
13  of the License, or (at your option) any later version.
14
15  BASE is distributed in the hope that it will be useful,
16  but WITHOUT ANY WARRANTY; without even the implied warranty of
17  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18  GNU General Public License for more details.
19
20  You should have received a copy of the GNU General Public License
21  along with this program; if not, write to the Free Software
22  Foundation, Inc., 59 Temple Place - Suite 330,
23  Boston, MA  02111-1307, USA.
24
25  ==============================================================
26 
27  A simple sequence of SQL commands that create a Base2 database
28  for the PostgreSQL database.
29 
30  This file should be executed by the psql command-line tool:
31 
32  psql -f createdb.postgres.sql template1
33
34  Before executing this file it is a good idea to change the
35  default password to something else. Do not forget to
36  make the corresponding change in your base.config file.
37
38  It is also possible to change the username (base2user)
39  database name (base2) and schema name (dynamic) to something
40  else. If yo do, do not forget to make the corresponding changes
41  in your base.config file.
42*/
43CREATE USER "base2user" PASSWORD 'password';
44CREATE DATABASE "base2" OWNER "base2user" ENCODING 'UNICODE';
45\c "base2"
46CREATE SCHEMA "dynamic" AUTHORIZATION "base2user";
Note: See TracBrowser for help on using the repository browser.