| author | Radek Brich <brich.radek@ifortuna.cz> |
| Wed, 07 May 2014 18:33:50 +0200 | |
| changeset 102 | fda45bdfd68d |
| parent 83 | 515fadd3d286 |
| permissions | -rw-r--r-- |
|
83
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
1 |
CREATE SCHEMA config; |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
2 |
|
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
3 |
CREATE TABLE config.databases |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
4 |
( |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
5 |
id serial NOT NULL, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
6 |
name varchar NOT NULL, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
7 |
host varchar, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
8 |
port smallint, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
9 |
dbname varchar, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
10 |
"user" varchar, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
11 |
password varchar, |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
12 |
|
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
13 |
PRIMARY KEY (id), |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
14 |
UNIQUE (name) |
|
515fadd3d286
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.
Radek Brich <radek.brich@devl.cz>
parents:
diff
changeset
|
15 |
); |