WorkerNode.sql

DROP TABLE IF EXISTS worker_node;
CREATE TABLE worker_node
(
    id             bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'auto increment id',
    host_name      varchar(128) NOT NULL COMMENT 'host name',
    port           varchar(64)  NOT NULL COMMENT 'port',
    type           int unsigned NOT NULL COMMENT 'node type: ACTUAL or CONTAINER',
    use_version    int unsigned NOT NULL DEFAULT '0' COMMENT 'use version',
    renewal_date   DATETIME     NOT NULL COMMENT 'renewal date',
    heartbeat_date DATETIME     NOT NULL COMMENT 'heartbeat date',
    launch_date    DATETIME     NOT NULL COMMENT 'launch date',
    modified       DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'modified time',
    created        DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created time',
    PRIMARY KEY (id),
    KEY            `idx_renewal_date` (`renewal_date`)
) COMMENT='DB WorkerID Assigner for UID Generator',ENGINE = INNODB;