sql/metadb.sql
author Radek Brich <radek.brich@devl.cz>
Sat, 13 Apr 2013 15:22:05 +0200
changeset 83 515fadd3d286
permissions -rw-r--r--
Add dependency on pycolib. Move common modules to pycolib. Add example table schema for meta DB.

CREATE SCHEMA config;

CREATE TABLE config.databases
(
    id serial NOT NULL,
    name varchar NOT NULL,
    host varchar,
    port smallint,
    dbname varchar,
    "user" varchar,
    password varchar,

    PRIMARY KEY (id),
    UNIQUE (name)
);