Files
paralus/persistence/migrations/admindb/000036_cluster_namespaces.up.sql
nirav-rafay c66bdc25cd restructure rcloud-base as a single base controller (#37)
* restructure rcloud-base as a single base controller
* updated master.rest
* moved sentry from internal to pkg as it is used by relay
* removing unused rpc and it's dependencies
* Fix usermgmt tests
* Don't redefine variables in rest file
Co-authored-by: Abin Simon <abin.simon@rafay.co>
2022-03-03 17:59:06 +05:30

18 lines
680 B
SQL

CREATE TABLE IF NOT EXISTS cluster_namespaces (
cluster_id uuid NOT NULL,
name varchar NOT NULL,
hash varchar NOT NULL,
deleted_at timestamp WITH time zone,
type varchar not null,
namespace jsonb not null,
conditions jsonb not null default '[]'::jsonb,
status jsonb not null default '{}'::jsonb
);
ALTER TABLE cluster_namespaces OWNER TO admindbuser;
ALTER TABLE ONLY cluster_namespaces ADD CONSTRAINT cluster_namespaces_pkey PRIMARY KEY (cluster_id, name);
ALTER TABLE ONLY cluster_namespaces
ADD CONSTRAINT cluster_project_cluster_cluster_id_fkey FOREIGN KEY (cluster_id)
REFERENCES cluster_clusters(id) DEFERRABLE INITIALLY DEFERRED;