-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathzicheng ruikai.txt
21 lines (21 loc) · 5.08 KB
/
zicheng ruikai.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
SQLite format 3 @ -�
9 � �h�� 9� �L�otablemessagemessageCREATE TABLE message(
message_ID integer PRIMARY KEY ASC autoincrement,
receiver_ID varchar(30) NOT NULL,
sender_ID varchar(30) NOT NULL,
title varchar(30),
content text NOT NULL,
timestamp date NOL NULL,
FOREIGN KEY(receiver_ID) REFERENCES user(user_ID),
FOREIGN KEY(sender_ID) REFERENCES user(user_ID)
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)� / � i�5tableuseruserCREATE TABLE user(
user_ID varchar(30) PRIMARY KEY,
password varchar(30) NOT NULL
)'; indexsqlite_autoindex_user_1user