JSOC/proj/replication/etc/auditing_ddl.sql - view

Return to auditing_ddl.sql CVS log

Up to [Development] / JSOC / proj / replication / etc

File: [Development] / JSOC / proj / replication / etc / auditing_ddl.sql (download)
Revision: 1.1, Fri Jul 23 17:06:05 2010 UTC (12 years, 6 months ago) by arta
Branch: MAIN
CVS Tags: Ver_LATEST, Ver_9-5, Ver_9-41, Ver_9-4, Ver_9-3, Ver_9-2, Ver_9-1, Ver_9-0, Ver_8-8, Ver_8-7, Ver_8-6, Ver_8-5, Ver_8-4, Ver_8-3, Ver_8-2, Ver_8-12, Ver_8-11, Ver_8-10, Ver_8-1, Ver_8-0, Ver_7-1, Ver_7-0, Ver_6-4, Ver_6-3, Ver_6-2, Ver_6-1, Ver_6-0, Ver_5-14, Ver_5-13, Ver_5-12, Ver_5-11, Ver_5-10, HEAD

Put consistent-state auditing code into our CVS tree.

SET search_path to su_production;

CREATE TABLE slony_auditing_metadata (
    id integer NOT NULL,
    schema_table character varying(200) NOT NULL,
    master_count integer NOT NULL,
    slave_count integer NOT NULL,
    match_flag boolean NOT NULL,
    lag_events integer NOT NULL,
    snap_dt timestamp with time zone DEFAULT now()
);


CREATE SEQUENCE slony_auditing_metadata_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER SEQUENCE slony_auditing_metadata_id_seq OWNED BY slony_auditing_metadata.id;



CREATE TABLE slony_auditing_status_history (
    id integer NOT NULL,
    st_origin integer NOT NULL,
    st_received integer NOT NULL,
    st_last_event bigint NOT NULL,
    st_last_event_ts timestamp without time zone NOT NULL,
    st_last_received bigint NOT NULL,
    st_last_received_ts timestamp without time zone NOT NULL,
    st_last_received_event_ts timestamp without time zone NOT NULL,
    st_lag_num_events bigint NOT NULL,
    st_lag_time interval NOT NULL,
    snap_dt timestamp with time zone DEFAULT now()
);

CREATE SEQUENCE slony_auditing_status_history_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER SEQUENCE slony_auditing_status_history_id_seq OWNED BY slony_auditing_status_history.id;


ALTER TABLE slony_auditing_metadata ALTER COLUMN id SET DEFAULT nextval('slony_auditing_metadata_id_seq'::regclass);


ALTER TABLE slony_auditing_status_history ALTER COLUMN id SET DEFAULT nextval('slony_auditing_status_history_id_seq'::regclass);

Karen Tian