Changeset be06d4c772959d7f67b61729ed0fcfa446eb59a4

Show
Ignore:
Timestamp:
10/16/08 16:17:38 (6 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1224173858 +0000
git-parent:

[715840d4b421a0aa705ef456cbf153bd32651a40]

git-author:
Denish Patel <denish@omniti.com> 1224173858 +0000
Message:

fixed ownership of tables

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/reconnoiter_ddl_dump.sql

    rc256764 rbe06d4c  
    7373ALTER TABLE prism.saved_graphs_dep OWNER TO reconnoiter; 
    7474 
     75-- 
     76-- Name: saved_worksheets; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace:  
     77-- 
     78 
     79CREATE TABLE saved_worksheets ( 
     80    sheetid uuid NOT NULL, 
     81    title text, 
     82    saved boolean DEFAULT false, 
     83    ts_search_all tsvector, 
     84    tags text[], 
     85    last_update timestamp with time zone DEFAULT now() NOT NULL 
     86); 
     87 
     88 
     89ALTER TABLE prism.saved_worksheets OWNER TO reconnoiter; 
     90 
     91-- 
     92-- Name: saved_worksheets_dep; Type: TABLE; Schema: prism; Owner: reconnoiter; Tablespace:  
     93-- 
     94 
     95CREATE TABLE saved_worksheets_dep ( 
     96    sheetid uuid NOT NULL, 
     97    ordering integer NOT NULL, 
     98    graphid uuid NOT NULL 
     99); 
     100 
     101 
     102ALTER TABLE prism.saved_worksheets_dep OWNER TO reconnoiter; 
     103 
    75104SET search_path = public, pg_catalog; 
     105 
     106-- 
     107-- Name: foo; Type: TABLE; Schema: public; Owner: omniti; Tablespace:  
     108-- 
     109 
     110CREATE TABLE foo ( 
     111    a timestamp with time zone 
     112); 
     113 
     114 
     115ALTER TABLE public.foo OWNER TO omniti; 
    76116 
    77117SET default_with_oids = true; 
     
    21422182 
    21432183 
     2184-- 
     2185-- Name: saved_worksheets_pkey; Type: CONSTRAINT; Schema: prism; Owner: reconnoiter; Tablespace:  
     2186-- 
     2187 
     2188ALTER TABLE ONLY saved_worksheets 
     2189    ADD CONSTRAINT saved_worksheets_pkey PRIMARY KEY (sheetid); 
     2190 
     2191 
    21442192SET search_path = public, pg_catalog; 
    21452193 
     
    25472595ALTER TABLE ONLY saved_graphs_dep 
    25482596    ADD CONSTRAINT saved_graphs_dep_sid_fkey FOREIGN KEY (sid, metric_name, metric_type) REFERENCES stratcon.metric_name_summary(sid, metric_name, metric_type); 
     2597 
     2598 
     2599-- 
     2600-- Name: saved_worksheets_dep_graphid_fkey; Type: FK CONSTRAINT; Schema: prism; Owner: reconnoiter 
     2601-- 
     2602 
     2603ALTER TABLE ONLY saved_worksheets_dep 
     2604    ADD CONSTRAINT saved_worksheets_dep_graphid_fkey FOREIGN KEY (graphid) REFERENCES saved_graphs(graphid); 
     2605 
     2606 
     2607-- 
     2608-- Name: saved_worksheets_dep_sheetid_fkey; Type: FK CONSTRAINT; Schema: prism; Owner: reconnoiter 
     2609-- 
     2610 
     2611ALTER TABLE ONLY saved_worksheets_dep 
     2612    ADD CONSTRAINT saved_worksheets_dep_sheetid_fkey FOREIGN KEY (sheetid) REFERENCES saved_worksheets(sheetid); 
    25492613 
    25502614