--liquibase formatted sql

--changeset Vin:add cliecommon_fieldnt table

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

  `clientId` bigint NOT NULL,
  `name` VARCHAR(200),
  `dateOfBirth` VARCHAR(200),
  `idCard` VARCHAR(100),
  `occupation` VARCHAR(100),
  `firstName` VARCHAR(100),
  `givenName` VARCHAR(100),
  `genderMale` VARCHAR(30),
  `genderFemale` VARCHAR(30),
  `ddDateOfBirth` VARCHAR(10),
  `mmDateOfBirth` VARCHAR(10),
  `yyyyDateOfBirth` VARCHAR(10),
  
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
