CREATE TABLE `auditEmail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT '' NOT NULL,
  `verifyCode` varchar(6) DEFAULT '' NOT NULL,
  `isOk` boolean DEFAULT '0' NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_index` (`email`)
) Engine=InnoDB;

CREATE TABLE `auditRegistrant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uniId` varchar(32) DEFAULT '' NOT NULL,
  `name` varchar(255) DEFAULT '' NOT NULL,
  `org` varchar(255) DEFAULT '' NOT NULL,
  `email` varchar(255) DEFAULT '' NOT NULL,
  `json` MEDIUMTEXT DEFAULT '' NOT NULL,
  `status` enum('','data','auditing','pass','unpass') DEFAULT '' NOT NULL,
  `description` varchar(255) DEFAULT '' NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniId_index` (`uniId`)
) ENGINE=InnoDB;

CREATE TABLE `auditContact` (
  `contactId` varchar(16) default '' not null,
  `wang`     enum('data','auditing','pass','unpass') DEFAULT 'data' NOT NULL,
  `商城`     enum('data','auditing','pass','unpass') DEFAULT 'data' NOT NULL,
  `网店`     enum('data','auditing','pass','unpass') DEFAULT 'data' NOT NULL,
  `八卦`     enum('data','auditing','pass','unpass') DEFAULT 'data' NOT NULL,
  `hdaotest` enum('data','auditing','pass','unpass') DEFAULT 'data' NOT NULL,
  primary key (`contactId`)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_unicode_ci;
