--liquibase formatted sql

--changeset cyril:create currency table
CREATE TABLE `currency`
(
    `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(30)  NOT NULL,
    `name`              VARCHAR(30)  NOT NULL,
    `description`       VARCHAR(100) NOT NULL DEFAULT '0',
    `m18Id`             INT NULL,
    `m18LastModifyDate` DATETIME NULL,
    CONSTRAINT pk_currency PRIMARY KEY (id)
);