· 6 years ago · May 22, 2019, 03:56 AM
1CREATE database IF NOT EXISTS homework default charset utf8;
2use homework;
3create table info(
4 href varchar(255),
5 type int,
6 PRIMARY KEY(href)
7);
8
9create table entry(
10 href varchar(255),
11 title varchar(255),
12 txt varchar(2000),
13 PRIMARY KEY(href),
14 FOREIGN KEY(href) REFERENCES info(href) on delete cascade
15);