Changeset 7b411d3b64a0cefe7a6ad99c78edfe85c96f3835

Show
Ignore:
Timestamp:
10/20/09 19:54:47 (4 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1256068487 +0000
git-parent:

[4a0968d07bb3e70d2212cb2ef9d79b6b1bc02b49]

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

update for mns trigger bits

Files:

Legend:

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

    r35417f1 r7b411d3  
    4545-- 
    4646 
    47 CREATE UNIQUE INDEX ucheck_currently_id_uidx ON check_currently USING btree (id); 
     47CREATE UNIQUE INDEX check_currently_id_uidx ON check_currently USING btree (id); 
    4848 
    4949 
     
    5252-- 
    5353 
    54 CREATE TRIGGER update_metric_summary_fulltext  
     54CREATE TRIGGER update_mns_via_check_currently 
    5555    AFTER INSERT OR UPDATE ON check_currently 
    5656    FOR EACH ROW 
    57     EXECUTE PROCEDURE update_metric_summary_fulltext(); 
     57    EXECUTE PROCEDURE update_mns_via_check_currently(); 
    5858 
    5959 
     
    6363 
    6464REVOKE ALL ON TABLE check_currently FROM PUBLIC; 
    65 REVOKE ALL ON TABLE check_currently FROM reconnoiter; 
    66 GRANT ALL ON TABLE check_currently TO reconnoiter; 
    6765GRANT SELECT ON TABLE check_currently TO prism; 
    6866GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE check_currently TO stratcon;