--liquibase formatted sql

--changeset kelvin:add template table

CREATE TABLE `template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `createdBy` int DEFAULT NULL,
  `version` int NOT NULL DEFAULT '0',
  `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedBy` int DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',

  `name` VARCHAR(500) NOT NULL,
  `fileId` int(11) NOT NULL,
  `remarks` VARCHAR(600),
  
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;