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

/*
  $Id$

  Copyright (C) 2005 Nicklas Nordborg
  Copyright (C) 2006 Jari Hakkinen

  This file is part of BASE - BioArray Software Environment.
  Available at http://base.thep.lu.se/

  BASE is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  as published by the Free Software Foundation; either version 3
  of the License, or (at your option) any later version.

  BASE is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place - Suite 330,
  Boston, MA  02111-1307, USA.

  ==============================================================
  
  A simple sequence of SQL commands that create a Base2 database
  for the PostgreSQL database.
  
  This file should be executed by the psql command-line tool:
  
  psql -f createdb.postgres.sql template1

  Before executing this file it is a good idea to change the
  default password to something else. Do not forget to
  make the corresponding change in your base.config file.

  It is also possible to change the username (base2user)
  database name (base2) and schema name (dynamic) to something
  else. If yo do, do not forget to make the corresponding changes
  in your base.config file.
*/
CREATE USER "base2user" PASSWORD 'password';
CREATE DATABASE "base2" OWNER "base2user" ENCODING 'UNICODE';
\c "base2"
CREATE SCHEMA "dynamic" AUTHORIZATION "base2user";