ddl.GrouperDdl_Grouper_createDdlWorker_postgres.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of grouper Show documentation

Internet2 Groups Management Toolkit

There is a newer version: 5.12.2

CREATE TABLE grouper_ddl_worker
(
    id VARCHAR(40) NOT NULL,
    grouper VARCHAR(40) NOT NULL,
    worker_uuid VARCHAR(40) NOT NULL,
    heartbeat TIMESTAMP,
    last_updated TIMESTAMP NOT NULL,
    PRIMARY KEY (id)
);

CREATE UNIQUE INDEX grouper_ddl_worker_grp_idx ON grouper_ddl_worker (grouper);

COMMENT ON TABLE grouper_ddl_worker IS 'JVMs register a uuid so only one JVM does the DDL upgrades at a time';

COMMENT ON COLUMN grouper_ddl_worker.grouper IS 'this just holds the word grouper, so there is only one row here';

COMMENT ON COLUMN grouper_ddl_worker.worker_uuid IS 'random uuid from a jvm to do work on the database';

COMMENT ON COLUMN grouper_ddl_worker.heartbeat IS 'while the ddl is running, keep a heartbeat updated';

COMMENT ON COLUMN grouper_ddl_worker.last_updated IS 'when this record was last updated';