115 lines
3.7 KiB
SQL
115 lines
3.7 KiB
SQL
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
DROP TABLE IF EXISTS `project`;
|
|
CREATE TABLE `project` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`uuid` varchar(200) NOT NULL,
|
|
`name` varchar(20) NOT NULL,
|
|
`programmingLanguage` varchar(10) NOT NULL,
|
|
`description` varchar(1000) NOT NULL,
|
|
`hostUrl` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `uuid` (`uuid`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `resourceMetaData`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `resourceMetaData`;
|
|
CREATE TABLE `resourceMetaData` (
|
|
`projectuuid` varchar(50) NOT NULL,
|
|
`type` varchar(20) NOT NULL,
|
|
`urlListString` varchar(1000) DEFAULT NULL,
|
|
`crawler` varchar(20) DEFAULT NULL,
|
|
`id` int(50) NOT NULL AUTO_INCREMENT,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `crawlerTask`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `crawlerTask`;
|
|
CREATE TABLE `crawlerTask` (
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`uuid` varchar(200) NOT NULL,
|
|
`projectUuid` varchar(200) NOT NULL,
|
|
`crawlerNode` varchar(100) NOT NULL,
|
|
`resourceType` varchar(50) NOT NULL,
|
|
`startTime` datetime NOT NULL,
|
|
`finishTime` datetime DEFAULT NULL,
|
|
`status` int(5) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `mail`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `mail`;
|
|
CREATE TABLE `mail` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`mailID` varchar(200) NOT NULL,
|
|
`projectID` varchar(200) NOT NULL,
|
|
`fromMail` varchar(2000) NOT NULL,
|
|
`toMail` varchar(2000) NOT NULL,
|
|
`sendDate` date DEFAULT NULL,
|
|
`content` longtext NOT NULL,
|
|
`subject` varchar(2000) NOT NULL,
|
|
`fromName` varchar(255) DEFAULT NULL,
|
|
`toName` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `projectID` (`projectID`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `Documentation`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `Documentation`;
|
|
CREATE TABLE `Documentation` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`Uuid` varchar(200) NOT NULL DEFAULT '',
|
|
`ProjectUuid` varchar(200) NOT NULL,
|
|
`subType` int(11) DEFAULT NULL,
|
|
`url` varchar(200) DEFAULT NULL,
|
|
`docname` varchar(200) DEFAULT NULL,
|
|
`filePath` varchar(200) DEFAULT NULL,
|
|
`Updatetime` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `uuid` (`Uuid`) USING BTREE
|
|
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `issueTracker`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `issueTracker`;
|
|
CREATE TABLE `issueTracker` (
|
|
`projectuuid` char(50) DEFAULT NULL,
|
|
`uuid` char(50) DEFAULT NULL,
|
|
`type` char(20) DEFAULT NULL,
|
|
`keyname` char(20) DEFAULT NULL,
|
|
`summary` text,
|
|
`assignee` char(50) DEFAULT NULL,
|
|
`priority` char(20) DEFAULT NULL,
|
|
`status` char(20) DEFAULT NULL,
|
|
`resolution` char(50) DEFAULT NULL,
|
|
`created` char(50) DEFAULT NULL,
|
|
`updated` char(50) DEFAULT NULL,
|
|
`description` longtext
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for `RelativeWeb`
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `RelativeWeb`;
|
|
CREATE TABLE `RelativeWeb` (
|
|
`id` bigint(64) NOT NULL AUTO_INCREMENT,
|
|
`uuid` varchar(200) NOT NULL,
|
|
`projectuuid` varchar(200) NOT NULL,
|
|
`url` varchar(200) NOT NULL,
|
|
`title` varchar(200) DEFAULT NULL,
|
|
`updateTime` datetime NOT NULL,
|
|
`filepath` varchar(200) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uuid_UNIQUE` (`uuid`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
|