1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
CREATE TABLE `website0001` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`siteBigType` int(11) DEFAULT NULL,
`siteSmallType` int(11) DEFAULT NULL,
`siteWorth` varchar(15) COLLATE utf8_unicode_ci DEFAULT '0' COMMENT '网站价值',
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
CREATE TABLE `website0002` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`siteBigType` int(11) DEFAULT NULL,
`siteSmallType` int(11) DEFAULT NULL,
`siteWorth` varchar(15) COLLATE utf8_unicode_ci DEFAULT '0' COMMENT '网站价值',
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
CREATE TABLE `websiteall` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`siteBigType` int(11) DEFAULT NULL,
`siteSmallType` int(11) DEFAULT NULL,
`siteWorth` varchar(15) COLLATE utf8_unicode_ci DEFAULT '0' COMMENT '网站价值',
`date` date DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci INSERT_METHOD=LAST UNION=(`website0001`,`website0002`);
|