Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
23 lines (19 sloc) 677 Bytes
--
-- Name: search_user_settings; Type: TABLE; Schema: searchapp; Owner: -
--
CREATE TABLE search_user_settings (
id bigint NOT NULL,
setting_name character varying(255) NOT NULL,
user_id bigint NOT NULL,
setting_value character varying(1024) NOT NULL
);
--
-- Name: search_user_settings_pkey; Type: CONSTRAINT; Schema: searchapp; Owner: -
--
ALTER TABLE ONLY search_user_settings
ADD CONSTRAINT search_user_settings_pkey PRIMARY KEY (id);
--
-- Name: search_user_settings_uk; Type: CONSTRAINT; Schema: searchapp; Owner: -
--
ALTER TABLE ONLY search_user_settings
ADD CONSTRAINT search_user_settings_uk UNIQUE (user_id, setting_name, setting_value);