22 行
661 B
Plaintext
22 行
661 B
Plaintext
DROP DATABASE IF EXISTS `kensaku`;
|
|
CREATE DATABASE `kensaku` CHARACTER SET `utf8` COLLATE `utf8_unicode_ci`;
|
|
|
|
USE `kensaku`;
|
|
|
|
DROP TABLE IF EXISTS `website`;
|
|
CREATE TABLE `website` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`url` varchar(100) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|
|
|
|
DROP TABLE IF EXISTS `website_page`;
|
|
CREATE TABLE `website_page` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`website_id` int(10) NOT NULL,
|
|
`url` varchar(100) NOT NULL,
|
|
`title` varchar(100),
|
|
`body` text,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
|