CREATE TABLE `activityContractor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activityId` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `contact` varchar(45) DEFAULT NULL,
  `phone` varchar(45) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `nature` varchar(45) DEFAULT NULL,
  `experienceYear` varchar(20) DEFAULT NULL,
  `intro` text DEFAULT NULL,
  `addTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


CREATE TABLE `serviceorg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orgType` varchar(45) DEFAULT NULL,
  `orgName` varchar(45) DEFAULT NULL,
  `orgIntroduce` text DEFAULT NULL,
  `orgExperience` text DEFAULT NULL,
  `orgExperts` text DEFAULT NULL,
  `orgContactName` varchar(50) DEFAULT NULL,
  `orgContactPhone` varchar(100) DEFAULT NULL,
	`orgContactAddress` varchar(255) DEFAULT NULL,
  `registerTime` datetime DEFAULT NULL,
  `addTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `activityDetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activityId` int(11) NOT NULL,
  `hdnr` text DEFAULT NULL,
  `bags` varchar(45) DEFAULT NULL,
  `baryzs` varchar(45) DEFAULT NULL,
  `cdrl` varchar(100) DEFAULT NULL,
  `addTime` datetime DEFAULT NULL,
  `updateTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;