-
Notifications
You must be signed in to change notification settings - Fork 0
/
init.sql
43 lines (43 loc) · 914 Bytes
/
init.sql
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
--drop database IF EXISTS homework;
--创建数据库
create database homework;
--使用数据库
use homework;
create table HW_user(
username varchar(20),
name varchar(20),
password varchar(20),
email varchar(20),
phone varchar(20)
);
create table HW_blog(
number int primary key auto_increment,
title varchar(20),
author varchar(20),
type varchar(20),
decoration varchar(500),
create_time varchar(20),
alter_time varchar(20),
text varchar(5000)
);
create table HW_comment(
number int primary key auto_increment,
blognumber int,
username varchar(20),
content varchar(100),
time varchar(20)
);
create table HW_picture(
number int primary key auto_increment,
name varchar(20),
picture longblob,
type varchar(20),
create_time varchar(20),
author varchar(20)
);
create table HW_message(
number int primary key auto_increment,
username varchar(20),
content varchar(100),
time varchar(20)
);