File: pgsql-8.3_01_create_db_and_user.sql

package info (click to toggle)
torrentflux 2.4-3
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 6,028 kB
  • ctags: 13,559
  • sloc: php: 36,501; python: 12,563; sh: 1,139; sql: 340; makefile: 44; xml: 22
file content (13 lines) | stat: -rw-r--r-- 290 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
/* 
Run this script as the database superuser.
This should be postgres.

Run it thusly:
psql -d template1 -f pgsql_01_create_db_and_user.sql 
*/

/* create the database */
create database torrentflux;

/* This will prompt for a password */
create user tf_user password 'tfdefaultpassword';