SET FOREIGN_KEY_CHECKS=0;

USE `iCustomer`;

#
# Structure for the `account` table : 
#

DROP TABLE IF EXISTS `account`;

CREATE TABLE `account` (
  `ACCT_ID` int(11) NOT NULL auto_increment,
  `ACCT_NAME` varchar(50) NOT NULL,
  `PHONE_WORK` varchar(50) default NULL,
  `PHONE_HOME` varchar(50) default NULL,
  `PHONE_MOBILE` varchar(50) default NULL,
  `EMAIL` varchar(255) default NULL,
  `MSN` varchar(255) default NULL,
  `QQ` varchar(20) default NULL,
  `DEPARTMENT` varchar(50) default NULL,
  `DUTY` varchar(50) default NULL,
  `REMARKS` text,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`ACCT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `activity` table : 
#

DROP TABLE IF EXISTS `activity`;

CREATE TABLE `activity` (
  `ACTI_ID` int(11) NOT NULL auto_increment,
  `ACCT_ID` int(11) NOT NULL,
  `CUST_ID` int(11) default NULL,
  `CONT_ID` int(11) default NULL,
  `ACTI_TYPE` varchar(20) default NULL,
  `SUMMARY` varchar(1024) NOT NULL,
  `REMARKS` text,
  `START_DTTM` datetime default NULL,
  `END_DTTM` datetime default NULL,
  `PRIORITY` varchar(20) default NULL,
  `COMPLETED` tinyint(4) default NULL,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`ACTI_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `code` table : 
#

DROP TABLE IF EXISTS `code`;

CREATE TABLE `code` (
  `CODE_TYPE_ID` varchar(20) NOT NULL,
  `CODE_ID` varchar(20) NOT NULL,
  `CODE_DESC` varchar(255) default NULL,
  `CODE_SEQ` int(11) NOT NULL default '0',
  `STATUS` char(1) NOT NULL,
  `CREATE_BY` varchar(32) NOT NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) NOT NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`CODE_TYPE_ID`,`CODE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `code_type` table : 
#

DROP TABLE IF EXISTS `code_type`;

CREATE TABLE `code_type` (
  `CODE_TYPE_ID` varchar(20) NOT NULL,
  `CODE_TYPE_DESC` varchar(255) default NULL,
  `CREATE_BY` varchar(32) NOT NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) NOT NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`CODE_TYPE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `contact` table : 
#

DROP TABLE IF EXISTS `contact`;

CREATE TABLE `contact` (
  `CONT_ID` int(11) NOT NULL auto_increment,
  `CUST_ID` int(11) default NULL,
  `CONT_NAME` varchar(50) NOT NULL,
  `SEX` char(1) default NULL,
  `DUTY` varchar(50) default NULL,
  `PHONE_WORK` varchar(50) default NULL,
  `PHONE_HOME` varchar(50) default NULL,
  `PHONE_MOBILE` varchar(50) default NULL,
  `EMAIL` varchar(255) default NULL,
  `MSN` varchar(255) default NULL,
  `QQ` varchar(20) default NULL,
  `REMARKS` text,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`CONT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `customer` table : 
#

DROP TABLE IF EXISTS `customer`;

CREATE TABLE `customer` (
  `CUST_ID` int(11) NOT NULL auto_increment,
  `CUST_NAME` varchar(1024) NOT NULL,
  `CUST_TYPE` varchar(20) default NULL,
  `ADDRESS` varchar(1024) default NULL,
  `POSTCODE` varchar(6) default NULL,
  `FAX` varchar(50) default NULL,
  `PROVINCE` varchar(50) default NULL,
  `CITY` varchar(50) default NULL,
  `COUNTY` varchar(50) default NULL,
  `INDUSTRY` varchar(50) default NULL,
  `WEBSITE` varchar(1024) default NULL,
  `ATTACHMENT` varchar(1024) default NULL,
  `NET_DESC` text,
  `APP_DESC` text,
  `REMARKS` text,
  `ASSIGNED_ACCT_ID` varchar(32) default NULL,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`CUST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `cust_acct` table : 
#

DROP TABLE IF EXISTS `cust_acct`;

CREATE TABLE `cust_acct` (
  `CUST_ID` int(11) NOT NULL,
  `ACCT_ID` int(11) NOT NULL,
  KEY `CUST_ID` (`CUST_ID`,`ACCT_ID`),
  KEY `ACCT_ID` (`ACCT_ID`,`CUST_ID`),
  KEY `CUST_ID_2` (`CUST_ID`),
  KEY `ACCT_ID_2` (`ACCT_ID`),
  CONSTRAINT `cust_acct_fk1` FOREIGN KEY (`ACCT_ID`) REFERENCES `account` (`ACCT_ID`),
  CONSTRAINT `cust_acct_fk` FOREIGN KEY (`CUST_ID`) REFERENCES `customer` (`CUST_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `issue` table : 
#

DROP TABLE IF EXISTS `issue`;

CREATE TABLE `issue` (
  `ISSUE_ID` int(11) NOT NULL auto_increment,
  `SPT_ID` int(11) default NULL,
  `PROD_ID` int(11) default NULL,
  `ISSUE_TYPE` varchar(255) default NULL,
  `SUMMARY` varchar(1024) NOT NULL,
  `DESCRIPTION` text,
  `RESOLUTION` text,
  `STATUS` varchar(50) default NULL,
  `DUE_DATE` datetime default NULL,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`ISSUE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `order_form` table : 
#

DROP TABLE IF EXISTS `order_form`;

CREATE TABLE `order_form` (
  `ORDER_ID` int(11) NOT NULL auto_increment,
  `CUST_ID` int(11) default NULL,
  `CONT_ID` int(11) default NULL,
  `ACCT_ID` int(11) default NULL,
  `PROJ_NAME` varchar(255) default NULL,
  `ADDRESS` varchar(1024) default NULL,
  `ACCT_NUM` varchar(255) default NULL,
  `TAX_NUM` varchar(255) default NULL,
  `ORDER_DATE` date default NULL,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`ORDER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `order_item` table : 
#

DROP TABLE IF EXISTS `order_item`;

CREATE TABLE `order_item` (
  `ORDER_ID` int(11) default NULL,
  `PROD_ID` int(11) NOT NULL,
  `SEQUENCE` int(11) default NULL,
  `AMOUNT` int(11) NOT NULL,
  `START_DATE` date default NULL,
  `USE_END_DATE` date default NULL,
  `SERV_END_DATE` date default NULL,
  `USE_REMIND_EMAIL_CD` varchar(2) default NULL,
  `SERV_REMIND_EMAIL_CD` varchar(2) default NULL,
  KEY `ORDER_ID` (`ORDER_ID`,`SEQUENCE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `permission` table : 
#

DROP TABLE IF EXISTS `permission`;

CREATE TABLE `permission` (
  `PERMS_ID` int(11) NOT NULL auto_increment,
  `PERMS_NAME` varchar(50) NOT NULL,
  `PERMS_DESC` varchar(1024) default NULL,
  `OPERATION` varchar(255) default NULL,
  `STATUS` varchar(50) default NULL,
  PRIMARY KEY  (`PERMS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `resources` table : 
#

DROP TABLE IF EXISTS `resources`;

CREATE TABLE `resources` (
  `RESRC_ID` int(11) NOT NULL auto_increment,
  `RESRC_NAME` varchar(255) NOT NULL,
  `RESRC_TYPE` varchar(50) NOT NULL,
  `RESRC_STRING` varchar(255) NOT NULL,
  `RESRC_DESC` varchar(255) default NULL,
  PRIMARY KEY  (`RESRC_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `perms_resrc` table : 
#

DROP TABLE IF EXISTS `perms_resrc`;

CREATE TABLE `perms_resrc` (
  `PERMS_ID` int(11) NOT NULL,
  `RESRC_ID` int(11) NOT NULL,
  KEY `PERMS_ID` (`PERMS_ID`),
  KEY `RESRC_ID` (`RESRC_ID`),
  CONSTRAINT `perms_resrc_fk1` FOREIGN KEY (`RESRC_ID`) REFERENCES `resources` (`RESRC_ID`),
  CONSTRAINT `perms_resrc_fk` FOREIGN KEY (`PERMS_ID`) REFERENCES `permission` (`PERMS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `product` table : 
#

DROP TABLE IF EXISTS `product`;

CREATE TABLE `product` (
  `PROD_ID` int(11) NOT NULL auto_increment,
  `MANUFACTURER` varchar(255) default NULL,
  `PROD_NAME` varchar(255) NOT NULL,
  `PROD_TYPE` varchar(255) default NULL,
  `PROD_MODEL` varchar(255) default NULL,
  `PROD_SPEC` varchar(255) default NULL,
  `PROD_STATUS` varchar(20) default NULL,
  `REMARKS` text,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`PROD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `role` table : 
#

DROP TABLE IF EXISTS `role`;

CREATE TABLE `role` (
  `ROLE_ID` int(11) NOT NULL auto_increment,
  `ROLE_NAME` varchar(50) NOT NULL,
  `ROLE_DESC` varchar(1024) default NULL,
  PRIMARY KEY  (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `role_perms` table : 
#

DROP TABLE IF EXISTS `role_perms`;

CREATE TABLE `role_perms` (
  `ROLE_ID` int(11) NOT NULL,
  `PERMS_ID` int(11) NOT NULL,
  KEY `ROLE_ID` (`ROLE_ID`),
  KEY `PERMS_ID` (`PERMS_ID`),
  CONSTRAINT `role_perms_fk1` FOREIGN KEY (`PERMS_ID`) REFERENCES `permission` (`PERMS_ID`),
  CONSTRAINT `role_perms_fk` FOREIGN KEY (`ROLE_ID`) REFERENCES `role` (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `support` table : 
#

DROP TABLE IF EXISTS `support`;

CREATE TABLE `support` (
  `SPT_ID` int(11) NOT NULL auto_increment,
  `ACCT_ID` int(11) NOT NULL,
  `CUST_ID` int(11) default NULL,
  `CONT_ID` int(11) default NULL,
  `SPT_TYPE` varchar(100) default NULL,
  `SUMMARY` varchar(1024) NOT NULL,
  `REMARKS` text,
  `START_DTTM` datetime default NULL,
  `END_DTTM` datetime default NULL,
  `PRIORITY` varchar(50) default NULL,
  `COMPLETED` tinyint(4) default NULL,
  `CREATE_BY` varchar(32) default NULL,
  `CREATE_DTTM` datetime NOT NULL,
  `LAST_UPDATE_BY` varchar(32) default NULL,
  `LAST_UPDATE_DTTM` datetime NOT NULL,
  PRIMARY KEY  (`SPT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `user` table : 
#

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `USER_ID` int(11) NOT NULL auto_increment,
  `USER_NAME` varchar(50) NOT NULL,
  `USER_PASSWORD` varchar(50) NOT NULL,
  `STATUS` int(11) default NULL,
  `LAST_LOGIN_TIME` datetime default NULL,
  `LAST_LOGIN_IP` varchar(50) default NULL,
  PRIMARY KEY  (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Structure for the `user_role` table : 
#

DROP TABLE IF EXISTS `user_role`;

CREATE TABLE `user_role` (
  `USER_ID` int(11) NOT NULL,
  `ROLE_ID` int(11) NOT NULL,
  KEY `USER_ID` (`USER_ID`),
  KEY `ROLE_ID` (`ROLE_ID`),
  CONSTRAINT `user_role_fk1` FOREIGN KEY (`ROLE_ID`) REFERENCES `role` (`ROLE_ID`),
  CONSTRAINT `user_role_fk` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for the `account` table  (LIMIT 0,500)
#

INSERT INTO `account` (`ACCT_ID`, `ACCT_NAME`, `PHONE_WORK`, `PHONE_HOME`, `PHONE_MOBILE`, `EMAIL`, `MSN`, `QQ`, `DEPARTMENT`, `DUTY`, `REMARKS`, `CREATE_BY`, `CREATE_DTTM`, `LAST_UPDATE_BY`, `LAST_UPDATE_DTTM`) VALUES 
  (1,'admin',NULL,'','','admin@admin.com','','','','','',NULL,'2006-05-31 19:30:10',NULL,'2006-05-31 19:30:10');

COMMIT;

#
# Data for the `code` table  (LIMIT 0,500)
#

INSERT INTO `code` (`CODE_TYPE_ID`, `CODE_ID`, `CODE_DESC`, `CODE_SEQ`, `STATUS`, `CREATE_BY`, `CREATE_DTTM`, `LAST_UPDATE_BY`, `LAST_UPDATE_DTTM`) VALUES 
  ('ACTI_TYPE','FIRST_TEL','初次电话访问',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-05-27 20:13:28'),
  ('CUSTOMER_TYPE','AGENT','代理商',1,'A','SYSTEM','2006-03-15 19:11:40','SYSTEM','2006-05-13 14:38:09'),
  ('INDUSTRY','BUSINESS','工商',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','EDU','教育',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','ELECTRIC','电力',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','ELECTRON','电子家电',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','ENERGY','其他能源',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','FINANCE','金融',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','GOVERNMENT','政府',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08'),
  ('INDUSTRY','HOSPITAL','医院',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','INSURANCE','保险',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','MANUFACTURE','制造',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','MILITARY_AREA','军区',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','NAT_REVENUE','国税',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08'),
  ('INDUSTRY','POST','邮政',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','PUBLIC','公共事业',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','QUALITY_CONTROL','质检',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','REGION_REVENUE','地税',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08'),
  ('INDUSTRY','STEEL','钢铁冶金',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','TOBACCO','烟草',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','TRAFFIC','交通',0,'A','SYSTEM','2006-03-15 19:01:09','SYSTEM','2006-03-15 19:01:09'),
  ('INDUSTRY','TRAFFIC_POLICE','交警',0,'A','SYSTEM','2006-03-15 19:01:08','SYSTEM','2006-03-15 19:01:08'),
  ('ISSUE_STATUS','NEW','新问题',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23'),
  ('ISSUE_TYPE','CONFIG','配置问题',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23'),
  ('MANUFACTURER','MICROSOFT','MICROSOFT',1,'A','SYSTEM','2006-03-20','SYSTEM','2006-03-20 20:42:46'),
  ('PRIORITY','HIGH','高',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23'),
  ('PRIORITY','LOW','低',5,'A','SYSTEM','2006-05-14 17:27:58','SYSTEM','2006-05-14 17:27:58'),
  ('PRIORITY','MEDIUM','中',4,'A','SYSTEM','2006-05-14 17:27:39','SYSTEM','2006-05-14 17:27:39'),
  ('PROD_STATUS','NOT_SALE','未销售',1,'A','SYSTEM','2006-03-20','SYSTEM','2006-03-20'),
  ('PROD_STATUS','ON_SALE','销售中',2,'A','SYSTEM','2006-03-20 18:03:52','SYSTEM','2006-03-20 18:03:52'),
  ('PROD_STATUS','STOP_SALE','停止销售',3,'A','SYSTEM','2006-03-20 18:04:02','SYSTEM','2006-03-20 18:04:02'),
  ('PROD_TYPE','FIREWALL','防火墙',1,'A','SYSTEM','2006-03-20','SYSTEM','2006-05-27 20:11:16'),
  ('SPT_TYPE','IMPLEMENT','项目实施',6,'A','SYSTEM','2006-05-14 17:31:11','SYSTEM','2006-05-14 17:31:11'),
  ('SPT_TYPE','TEL_SUPPORT','电话支持',1,'A','SYSTEM','2006-04-23','SYSTEM','2006-04-23');

COMMIT;

#
# Data for the `code_type` table  (LIMIT 0,500)
#

INSERT INTO `code_type` (`CODE_TYPE_ID`, `CODE_TYPE_DESC`, `CREATE_BY`, `CREATE_DTTM`, `LAST_UPDATE_BY`, `LAST_UPDATE_DTTM`) VALUES 
  ('ACTI_TYPE','活动类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('CUSTOMER_TYPE','客户类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('INDUSTRY','行业','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('ISSUE_STATUS','问题状态','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('ISSUE_TYPE','问题类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('MANUFACTURER','制造商','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('PRIORITY','优先级','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('PROD_STATUS','产品状态','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('PROD_TYPE','产品类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('SPT_TYPE','客户服务类型','SYSTEM','2006-05-11','SYSTEM','2006-05-11'),
  ('USER_STATUS','用户帐号状态','SYSTEM','2006-05-14','SYSTEM','2006-05-14');

COMMIT;

#
# Data for the `role` table  (LIMIT 0,500)
#

INSERT INTO `role` (`ROLE_ID`, `ROLE_NAME`, `ROLE_DESC`) VALUES 
  (1,'ROLE_USER','普通用户'),
  (2,'ROLE_ORDER_ADMIN','定单管理员'),
  (3,'ROLE_SALES','销售'),
  (4,'ROLE_SUPPORT','技术支持人员'),
  (5,'ROLE_ADMIN','管理员'),
  (6,'ROLE_PROD_ADMIN','产品管理员');

COMMIT;

#
# Data for the `user` table  (LIMIT 0,500)
#

INSERT INTO `user` (`USER_ID`, `USER_NAME`, `USER_PASSWORD`, `STATUS`, `LAST_LOGIN_TIME`, `LAST_LOGIN_IP`) VALUES 
  (1,'admin','202cb962ac59075b964b07152d234b70',NULL,NULL,NULL);

COMMIT;

#
# Data for the `user_role` table  (LIMIT 0,500)
#

INSERT INTO `user_role` (`USER_ID`, `ROLE_ID`) VALUES 
  (1,4),
  (1,6),
  (1,3),
  (1,1),
  (1,5),
  (1,2);

COMMIT;