· 7 years ago · Dec 07, 2018, 02:26 AM
1-- MySQL Script generated by MySQL Workbench
2-- Fri Dec 7 10:00:31 2018
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `mydb` ;
14
15-- -----------------------------------------------------
16-- Schema mydb
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
19USE `mydb` ;
20
21-- -----------------------------------------------------
22-- Table `mydb`.`service`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `mydb`.`service` ;
25
26CREATE TABLE IF NOT EXISTS `mydb`.`service` (
27 `serviceID` INT(11) NOT NULL,
28 `OS` VARCHAR(64) NULL,
29 `application` VARCHAR(64) NOT NULL,
30 `protocol` VARCHAR(64) NOT NULL,
31 `description` TEXT NOT NULL,
32 PRIMARY KEY (`serviceID`))
33ENGINE = InnoDB
34DEFAULT CHARACTER SET = latin1;
35
36
37-- -----------------------------------------------------
38-- Table `mydb`.`tocrawl`
39-- -----------------------------------------------------
40DROP TABLE IF EXISTS `mydb`.`tocrawl` ;
41
42CREATE TABLE IF NOT EXISTS `mydb`.`tocrawl` (
43 `crawlID` INT(11) NOT NULL,
44 `priority` INT(1) NOT NULL,
45 `ptc_portNumber` INT(5) NOT NULL,
46 `ptc_ipAddress` VARCHAR(38) NOT NULL,
47 `status` VARCHAR(16) NOT NULL,
48 `dateCrawled` DATETIME NOT NULL,
49 PRIMARY KEY (`crawlID`))
50ENGINE = InnoDB
51DEFAULT CHARACTER SET = latin1;
52
53
54-- -----------------------------------------------------
55-- Table `mydb`.`site`
56-- -----------------------------------------------------
57DROP TABLE IF EXISTS `mydb`.`site` ;
58
59CREATE TABLE IF NOT EXISTS `mydb`.`site` (
60 `siteID` INT(11) NOT NULL,
61 `serviceID` INT(11) NOT NULL,
62 `crawlDate` VARCHAR(45) NOT NULL,
63 `endDate` DATE NULL,
64 PRIMARY KEY (`siteID`),
65 INDEX `serviceID_idx` (`serviceID` ASC) VISIBLE)
66ENGINE = InnoDB
67DEFAULT CHARACTER SET = latin1;
68
69
70-- -----------------------------------------------------
71-- Table `mydb`.`CMS`
72-- -----------------------------------------------------
73DROP TABLE IF EXISTS `mydb`.`CMS` ;
74
75CREATE TABLE IF NOT EXISTS `mydb`.`CMS` (
76 `cmsID` INT(11) NOT NULL,
77 `siteID` INT(11) NOT NULL,
78 `name` VARCHAR(16) NOT NULL,
79 `version` VARCHAR(16) NOT NULL,
80 `crawldate` DATE NOT NULL,
81 `enddate` DATE NULL,
82 PRIMARY KEY (`cmsID`),
83 INDEX `siteID_idx` (`siteID` ASC) VISIBLE)
84ENGINE = InnoDB;
85
86
87-- -----------------------------------------------------
88-- Table `mydb`.`portID`
89-- -----------------------------------------------------
90DROP TABLE IF EXISTS `mydb`.`portID` ;
91
92CREATE TABLE IF NOT EXISTS `mydb`.`portID` (
93 `portID` INT(11) NOT NULL,
94 `serviceID` INT(11) NOT NULL,
95 `portNumber` INT(11) NOT NULL,
96 `status` VARCHAR(16) NOT NULL,
97 `crawlDate` DATE NOT NULL,
98 `endDate` DATE NULL,
99 PRIMARY KEY (`portID`),
100 INDEX `serviceID_idx` (`serviceID` ASC) VISIBLE)
101ENGINE = InnoDB;
102
103
104-- -----------------------------------------------------
105-- Table `mydb`.`ipAddressID`
106-- -----------------------------------------------------
107DROP TABLE IF EXISTS `mydb`.`ipAddressID` ;
108
109CREATE TABLE IF NOT EXISTS `mydb`.`ipAddressID` (
110 `ipAddressID` INT(11) NOT NULL,
111 `serviceID` INT(11) NOT NULL,
112 `ipAddress` VARCHAR(39) NOT NULL,
113 `crawlDate` DATE NOT NULL,
114 `endDate` DATE NULL,
115 PRIMARY KEY (`ipAddressID`),
116 INDEX `serviceID_idx` (`serviceID` ASC) VISIBLE)
117ENGINE = InnoDB;
118
119
120-- -----------------------------------------------------
121-- Table `mydb`.`subdomain`
122-- -----------------------------------------------------
123DROP TABLE IF EXISTS `mydb`.`subdomain` ;
124
125CREATE TABLE IF NOT EXISTS `mydb`.`subdomain` (
126 `subdomainID` INT(11) NOT NULL,
127 `siteID` INT(11) NOT NULL,
128 `subdomain` VARCHAR(256) NOT NULL,
129 `crawldate` DATE NOT NULL,
130 `enddate` DATE NULL,
131 PRIMARY KEY (`subdomainID`),
132 INDEX `siteID_idx` (`siteID` ASC) VISIBLE)
133ENGINE = InnoDB;
134
135
136-- -----------------------------------------------------
137-- Table `mydb`.`domain`
138-- -----------------------------------------------------
139DROP TABLE IF EXISTS `mydb`.`domain` ;
140
141CREATE TABLE IF NOT EXISTS `mydb`.`domain` (
142 `domainID` INT(11) NOT NULL,
143 `siteID` INT(11) NOT NULL,
144 `domain` VARCHAR(256) NOT NULL,
145 `crawldate` DATE NOT NULL,
146 `enddate` DATE NULL,
147 PRIMARY KEY (`domainID`),
148 INDEX `siteID_idx` (`siteID` ASC) VISIBLE)
149ENGINE = InnoDB;
150
151
152-- -----------------------------------------------------
153-- Table `mydb`.`tld`
154-- -----------------------------------------------------
155DROP TABLE IF EXISTS `mydb`.`tld` ;
156
157CREATE TABLE IF NOT EXISTS `mydb`.`tld` (
158 `tldID` INT(11) NOT NULL,
159 `siteID` INT(11) NOT NULL,
160 `tld` VARCHAR(256) NOT NULL,
161 `crawldate` DATE NOT NULL,
162 `enddate` DATE NULL,
163 PRIMARY KEY (`tldID`),
164 INDEX `siteID_idx` (`siteID` ASC) VISIBLE)
165ENGINE = InnoDB;
166
167
168SET SQL_MODE=@OLD_SQL_MODE;
169SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
170SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;