1 |
|
-- Plase note that the flisfyr database must be created with iso-8859-1 encoding like this |
2 |
|
-- CREATE DATABASE flisfyr ENCODING 'LATIN1'; |
3 |
|
|
4 |
|
|
5 |
CREATE TABLE customer |
CREATE TABLE customer |
6 |
( |
( |
7 |
id serial, |
id serial, |
90 |
GRANT select,insert,update,delete ON command TO serrenab; |
GRANT select,insert,update,delete ON command TO serrenab; |
91 |
GRANT select,insert,update,delete ON installation TO serrenab; |
GRANT select,insert,update,delete ON installation TO serrenab; |
92 |
GRANT select,insert,update,delete ON customer TO serrenab; |
GRANT select,insert,update,delete ON customer TO serrenab; |
|
GRANT select,insert,update,delete ON logtable TO serrenab; |
|
93 |
|
GRANT select,insert,update,delete ON logtable TO serrenab; |
94 |
|
|
95 |
|
-- these sequences are auto created by postgresql |
96 |
|
GRANT ALL ON customer_id_seq TO serrenab; |
97 |
|
GRANT ALL ON command_id_seq TO serrenab; |
98 |
|
GRANT ALL ON installation_id_seq TO serrenab; |
99 |
|
GRANT ALL ON logtable_id_seq TO serrenab; |
100 |
|
GRANT ALL ON users_id_seq TO serrenab; |
101 |
|
|
102 |
|
REVOKE create ON SCHEMA public FROM public; |
103 |
|
|
104 |
|
INSERT INTO users (realname,username,password,enabled,useradmin) VALUES ('Admin User','admin',md5('admin'),true,true); |