-- liquibase formatted sql
-- changeset cyril:company

CREATE TABLE `company`
(
    `id`         INT          NOT NULL AUTO_INCREMENT,
    `created`    DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `createdBy`  VARCHAR(30)  NULL     DEFAULT NULL,
    `version`    INT          NOT NULL DEFAULT '0',
    `modified`   DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `modifiedBy` VARCHAR(30)  NULL     DEFAULT NULL,
    `deleted`    TINYINT(1)   NOT NULL DEFAULT '0',
    `code`       VARCHAR(100) NOT NULL,
    `name`       VARCHAR(100) NOT NULL,
    `brNo`       VARCHAR(100) NULL,
    `contactNo`  VARCHAR(100) NULL,
    `email`      VARCHAR(100) NULL,
    `addr1`      VARCHAR(500) NULL,
    `addr2`      VARCHAR(500) NULL,
    `addr3`      VARCHAR(500) NULL,
    `addr4`      VARCHAR(500) NULL,
    CONSTRAINT pk_company PRIMARY KEY (id)
);