/*
Navicat SQLite Data Transfer

Source Server         : aibatis_test_db
Source Server Version : 30714
Source Host           : :0

Target Server Type    : SQLite
Target Server Version : 30714
File Encoding         : 65001

Date: 2017-07-20 12:34:55
*/

PRAGMA foreign_keys = OFF;

-- ----------------------------
-- Table structure for offline_visitor_register
-- ----------------------------
DROP TABLE IF EXISTS "main"."offline_visitor_register";
CREATE TABLE "offline_visitor_register" (
"visitor_id"  INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"username"  TEXT,
"mobile_phone"  TEXT,
"gender_id"  TEXT,
"identity_type_id"  TEXT,
"country_id"  TEXT,
"visitor_type_id"  TEXT,
"identify_num"  TEXT,
"company_id"  TEXT,
"birthday"  TEXT,
"remark"  TEXT,
"raw_surveillance_photo_path"  TEXT,
"raw_surveillance_photo_width"  TEXT,
"raw_surveillance_photo_height"  TEXT,
"surveillance_photo_path"  TEXT,
"upload_custom_photo_path"  TEXT,
"id_card_photo_path"  TEXT,
"create_time"  TEXT
);