CREATE TABLE  money_detail (
  id int(11) NOT NULL AUTO_INCREMENT,
  shopper_id int(11) DEFAULT NULL,
  quarter tinyint(1) DEFAULT NULL,
  serial_no char(10) DEFAULT NULL,
  client_open tinyint(1) DEFAULT '0',
  interviewer_no char(10) DEFAULT NULL,
  approved tinyint(1) DEFAULT NULL,
  approved_date datetime DEFAULT NULL,
  comment text CHARACTER SET utf8 COLLATE utf8_bin,
  date_Insert datetime DEFAULT NULL,
  lang char(5) DEFAULT NULL,
  bankvisited int(11) DEFAULT NULL,
  bankvisited_other varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  branchname int(11) DEFAULT NULL,
  brancharea int(11) DEFAULT NULL,
  branchcity int(11) DEFAULT NULL,
  branchregion int(11) DEFAULT NULL,
  day int(2) DEFAULT NULL,
  month int(2) DEFAULT NULL,
  year int(4) DEFAULT NULL,
  starttime_hr int(2) DEFAULT NULL,
  starttime_min int(2) DEFAULT NULL,
  vduration_hr int(2) DEFAULT NULL,
  vduration_min int(2) DEFAULT NULL,
  time_in datetime DEFAULT NULL,
  date date DEFAULT NULL,
  b1 int(2) DEFAULT NULL,
  b2 int(2) DEFAULT NULL,
  b3 int(2) DEFAULT NULL,
  c4_1 int(2) DEFAULT NULL,
  c4_1_sp1 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_1_sp2 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_2a int(2) DEFAULT NULL,
  c4_2a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_2b int(2) DEFAULT NULL,
  c4_2b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_3 int(2) DEFAULT NULL,
  c4_3_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_4a int(2) DEFAULT NULL,
  c4_4a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_4b int(2) DEFAULT NULL,
  c4_4b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_4c int(2) DEFAULT NULL,
  c4_4c_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_5a int(2) DEFAULT NULL,
  c4_5a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_5b int(2) DEFAULT NULL,
  c4_5b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_5c int(2) DEFAULT NULL,
  c4_5c_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_6a int(2) DEFAULT NULL,
  c4_6a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_6b int(2) DEFAULT NULL,
  c4_6b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_6c int(2) DEFAULT NULL,
  c4_6c_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_7a int(2) DEFAULT NULL,
  c4_7a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_7b int(2) DEFAULT NULL,
  c4_7b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_7c int(2) DEFAULT NULL,
  c4_7c_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c4_7d int(2) DEFAULT NULL,
  c4_7d_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c5_1a int(2) DEFAULT NULL,
  c5_1b int(2) DEFAULT NULL,
  c5_1c int(2) DEFAULT NULL,
  c5_1d int(2) DEFAULT NULL,
  c5_2a int(2) DEFAULT NULL,
  c5_2b int(2) DEFAULT NULL,
  c5_2c int(2) DEFAULT NULL,
  c5_2d_name1 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c5_2d_name2 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c5_2d_name3 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  c5_2d_name4 varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_1a int(2) DEFAULT NULL,
  e6_1a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_1b int(2) DEFAULT NULL,
  e6_1b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_1c int(2) DEFAULT NULL,
  e6_1c_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_1d int(2) DEFAULT NULL,
  e6_1d_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_1e int(2) DEFAULT NULL,
  e6_1e_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_2a int(2) DEFAULT NULL,
  e6_2b int(2) DEFAULT NULL,
  e6_2c int(2) DEFAULT NULL,
  e6_2d int(2) DEFAULT NULL,
  e6_2d_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e6_2e int(2) DEFAULT NULL,
  e6_2f int(2) DEFAULT NULL,
  e6_2g int(2) DEFAULT NULL,
  e6_2g_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e7_1a int(2) DEFAULT NULL,
  e7_1b int(2) DEFAULT NULL,
  e7_1c int(4) DEFAULT NULL,
  e7_2a1 varchar(80) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e7_2a2 varchar(80) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e7_2a3 int(4) DEFAULT NULL,
  e7_2a3_a char(6) DEFAULT NULL,
  e7_2a_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e7_2b1 varchar(80) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e7_2b2 varchar(80) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  e7_2b3 int(4) DEFAULT NULL,
  e7_2b3_a char(6) DEFAULT NULL,
  e7_2b_sp varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  score_c_point int(4) DEFAULT NULL,
  score_c_allot int(4) DEFAULT NULL,
  score_d_point int(4) DEFAULT NULL,
  score_d_allot int(4) DEFAULT NULL,
  score_e_point int(4) DEFAULT NULL,
  score_e_allot int(4) DEFAULT NULL,
  score_f_point int(4) DEFAULT NULL,
  score_f_allot int(4) DEFAULT NULL,
  remote_ip varchar(50) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE  money_failed_sql (
  id int(11) NOT NULL AUTO_INCREMENT,
  msql text,
  updt_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE  money_qtr (
  id int(11) NOT NULL AUTO_INCREMENT,
  qrt_desc varchar(30) DEFAULT NULL,
  sdate date DEFAULT NULL,
  edate date DEFAULT NULL,
  active tinyint(3) unsigned DEFAULT '0',
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE  money_visit_plan_master (
  row_id int(10) NOT NULL AUTO_INCREMENT,
  shopper_id int(11) DEFAULT NULL,
  link varchar(100) DEFAULT NULL,
  quarter_id int(11) NOT NULL,
  status int(1) DEFAULT '0',
  PRIMARY KEY (row_id),
  UNIQUE KEY shopper_id (quarter_id,shopper_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `money_bank` (
  `bank_code` int(11) NOT NULL DEFAULT '0',
  `bank_desc` char(80) DEFAULT NULL,
  PRIMARY KEY (`bank_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `money_bank_branch` (
  `bank_code` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `region` char(40) DEFAULT NULL,
  `city` char(40) DEFAULT NULL,
  `area` char(40) DEFAULT NULL,
  `branch_name` char(80) DEFAULT NULL,
  `word` char(8) DEFAULT NULL,
  `staff_no` char(10) DEFAULT NULL,
  `br_size` char(8) DEFAULT NULL,
  UNIQUE KEY `bank_code_branch_id_region_area_city_branch_name` (`bank_code`,`branch_id`,`region`,`area`,`city`,`branch_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;