Sql File

CREATE TABLE IF NOT EXISTS `cardability` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `text` longtext CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `cardbook` (
  `id` varchar(50) CHARACTER SET ucs2 DEFAULT NULL,
  `data` longtext CHARACTER SET utf8 DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS `cardphoto` (
  `citizenid` varchar(255) DEFAULT NULL,
  `url` longtext DEFAULT NULL,
  KEY `citizenid` (`citizenid`)
);