Changeset 2b8f8c20cf8db128b58a867bceb25006514a662e

Show
Ignore:
Timestamp:
10/02/09 16:26:44 (5 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1254500804 +0000
git-parent:

[6bf36f96f69a29ee3b0fe2ce43262b4898eabc65]

git-author:
Robert Treat <robert@omniti.com> 1254500804 +0000
Message:

fix up bugs now that it's tested

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/tables/noit.check_tag.sql

    r3278b4e r2b8f8c2  
    1111SET escape_string_warning = off; 
    1212 
    13 SET search_path = stratcon, pg_catalog; 
     13SET search_path = noit, pg_catalog; 
    1414 
    1515SET default_tablespace = ''; 
     
    1818 
    1919-- 
    20 -- Name: check_tag; Type: TABLE; Schema: stratcon; Owner: reconnoiter; Tablespace:  
     20-- Name: check_tag; Type: TABLE; Schema: noit; Owner: reconnoiter; Tablespace:  
    2121-- 
    2222 
     
    2727 
    2828 
    29 ALTER TABLE stratcon.check_tag OWNER TO reconnoiter; 
     29ALTER TABLE noit.check_tag OWNER TO reconnoiter; 
    3030 
    3131-- 
    32 -- Name: check_tag_pkey; Type: CONSTRAINT; Schema: stratcon; Owner: reconnoiter; Tablespace:  
     32-- Name: check_tag_pkey; Type: CONSTRAINT; Schema: noit; Owner: reconnoiter; Tablespace:  
    3333-- 
    3434 
     
    3838 
    3939-- 
    40 -- Name: update_metric_name_summary_fulltext; Type: TRIGGER; Schema: stratcon; Owner: reconnoiter 
     40-- Name: update_metric_name_summary_fulltext; Type: TRIGGER; Schema: noit; Owner: reconnoiter 
    4141-- 
    4242 
     
    4848 
    4949-- 
    50 -- Name: check_tag_sid_fkey; Type: FK CONSTRAINT; Schema: stratcon; Owner: reconnoiter 
    51 -- 
     50-- Name: check_tag_sid_fkey; Type: FK CONSTRAINT; Schema: noit; Owner: reconnoiter 
     51-- NOTE: this FK reference is only valid on single database installations  
     52--  
    5253 
    5354ALTER TABLE ONLY check_tag 
    54     ADD CONSTRAINT check_tag_sid_fkey FOREIGN KEY (sid) REFERENCES map_uuid_to_sid(sid); 
     55    ADD CONSTRAINT check_tag_sid_fkey FOREIGN KEY (sid) REFERENCES stratcon.map_uuid_to_sid(sid); 
    5556 
    5657 
    5758-- 
    58 -- Name: check_tag; Type: ACL; Schema: stratcon; Owner: reconnoiter 
     59-- Name: check_tag; Type: ACL; Schema: noit; Owner: reconnoiter 
    5960-- 
    6061 
  • sql/tables/noit.metric_name_summary.sql

    r3e3863d r2b8f8c2  
    4444-- 
    4545 
    46 CREATE INDEX metric_name_summary_fts_data_idx ON metric_name_summary USING gin (ts_search_all); 
     46CREATE INDEX metric_name_summary_fts_data_idx ON metric_name_summary USING gin (fts_data); 
    4747 
    4848 
  • sql/tables/noit.metric_numeric_rollup_queue.sql

    re0b4c4b r2b8f8c2  
    2222CREATE TABLE metric_numeric_rollup_queue ( 
    2323    whence timestamp with time zone NOT NULL, 
    24     "interval" character text NOT NULL 
     24    "interval" text NOT NULL 
    2525); 
    2626 
  • sql/tables/noit.metric_tag.sql

    r3278b4e r2b8f8c2  
    4949-- 
    5050-- Name: metric_tag_sid_fkey; Type: FK CONSTRAINT; Schema: noit; Owner: reconnoiter 
     51-- NOTE: this FK reference is only valid on single database installations  
    5152-- 
    5253 
    5354ALTER TABLE ONLY metric_tag 
    54     ADD CONSTRAINT metric_tag_sid_fkey FOREIGN KEY (sid) REFERENCES map_uuid_to_sid(sid); 
     55    ADD CONSTRAINT metric_tag_sid_fkey FOREIGN KEY (sid) REFERENCES stratcon.map_uuid_to_sid(sid); 
    5556 
    5657 
  • sql/tables/noit.tasklock.sql

    r81f7001 r2b8f8c2  
    5151REVOKE ALL ON TABLE tasklock FROM reconnoiter; 
    5252GRANT ALL ON TABLE tasklock TO reconnoiter; 
    53 GRANT SELECT,INSERT ON TABLE tasklock TO noit
     53GRANT SELECT,INSERT ON TABLE tasklock TO stratcon
    5454 
    5555--