-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathscript.sql
55 lines (55 loc) · 3.34 KB
/
script.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
44
45
46
47
48
49
50
51
52
53
54
55
--CREATE DATABASE debato default CHARACTER SET UTF8;
use debato;
CREATE TABLE usertbl(
userid VARCHAR(300) PRIMARY KEY NOT NULL,
userpw VARCHAR(300) NOT NULL,
useremail VARCHAR(300),
username VARCHAR(300) NOT NULL,
ua VARCHAR(300) NOT NULL,
ip VARCHAR(300) NOT NULL,
userdate DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=INNODB;
CREATE TABLE posttbl(
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
boardname VARCHAR(300) NOT NULL,
userid VARCHAR(300) NOT NULL,
username VARCHAR(300),
title VARCHAR(300) NOT NULL,
content VARCHAR(300) NOT NULL,
likecount INT NOT NULL,
ua VARCHAR(300) NOT NULL,
ip VARCHAR(300) NOT NULL,
posttime DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=INNODB;
CREATE TABLE commenttbl(
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
postid VARCHAR(300) NOT NULL,
userid VARCHAR(300) NOT NULL,
username VARCHAR(300),
content VARCHAR(300) NOT NULL,
ua VARCHAR(300) NOT NULL,
ip VARCHAR(300) NOT NULL,
commenttime DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=INNODB;
CREATE TABLE boardtbl(
id VARCHAR(300) PRIMARY KEY NOT NULL AUTO_INCREMENT,
board VARCHAR(300) NOT NULL,
) ENGINE=INNODB;
CREATE TABLE siteinfo(
sitename VARCHAR(300) PRIMARY KEY NOT NULL,
footer VARCHAR(300),
adminid VARCHAR(300) NOT NULL,
adminpw VARCHAR(300) NOT NULL,
) ENGINE=INNODB;
INSERT INTO siteinfo(sitename, footer, adminid, adminpw) VALUE(1,1,1,1);
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");
INSERT INTO posttbl(boardname, userid, username, title, content, likecount, ip, ua) VALUE("free", "dd", "dd", "게시물테스트", "테스트입니다.", "12", "1.1.1.1", "1");