File: pgsql_create.sql.in

package info (click to toggle)
imp 3%3A2.2.6-5.2
  • links: PTS
  • area: main
  • in suites: woody
  • size: 5,476 kB
  • ctags: 766
  • sloc: php: 4,253; sh: 831; makefile: 98; perl: 50; pascal: 15
file content (19 lines) | stat: -rw-r--r-- 326 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
\connect @dbname@

CREATE TABLE imp_pref (
username	text,
sig		text,
fullname	text,
replyto		text,
lang            varchar(30)
);

CREATE TABLE imp_addr (
username	text,
address		text,
nickname	text,
fullname	text
);

GRANT SELECT, INSERT, UPDATE ON active_sessions, auth_user,auth_user_md5, imp_pref, imp_addr TO @dbuser@ ;