· 9 years ago · Jan 13, 2017, 09:34 AM
1CREATE TABLE IF NOT EXISTS public.namespace
2(
3 id INTEGER PRIMARY KEY DEFAULT NEXTVAL('serial'),
4 label VARCHAR,
5 user_id INTEGER NOT NULL REFERENCES users(user_id),
6 created TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT STATEMENT_TIMESTAMP(),
7 active BOOLEAN NOT NULL DEFAULT FALSE,
8 removed BOOLEAN NOT NULL DEFAULT FALSE,
9 kube_exist BOOLEAN NOT NULL DEFAULT FALSE,
10);