aboutsummaryrefslogblamecommitdiffstats
path: root/vendor/examples/sql/pgsql.propertystorage.sql
blob: d1463faae55c9907709700335f92d4c0cd771e39 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
13












                                                         
CREATE TABLE propertystorage (
    id SERIAL NOT NULL,
    path VARCHAR(1024) NOT NULL,
    name VARCHAR(100) NOT NULL,
    valuetype INT,
    value BYTEA
);

ALTER TABLE ONLY propertystorage
    ADD CONSTRAINT propertystorage_pkey PRIMARY KEY (id);

CREATE UNIQUE INDEX propertystorage_ukey
    ON propertystorage (path, name);