seadog / ybttre
watch download tarball
public
Forks0Right
Watchers1Right
Description: An IRC bot that keeps track of who is who and makes links between users.
Homepage:
Clone URL: git://github.com/seadog/ybttre.git
Click here to lend your support to: ybttre and make a donation at www.pledgie.com !
ybttre / db.sql
100644 46 lines (40 sloc) 1.101 kb
raw blame history 
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

DROP TABLE IF EXISTS users, message_log, link, stats, servers;
 
CREATE TABLE servers (
	id INT AUTO_INCREMENT PRIMARY KEY,
	hostname VARCHAR(128)
);
 
CREATE TABLE users (
	id INT AUTO_INCREMENT PRIMARY KEY,
	nick VARCHAR(64),
	host VARCHAR(64),
	ident VARCHAR(64),
	realname VARCHAR(64),
	sid INT,
	FOREIGN KEY (sid) REFERENCES servers(id) ON DELETE CASCADE
);
 
CREATE TABLE message_log (
	id INT AUTO_INCREMENT PRIMARY KEY,
	message TEXT,
	uid INT,
	FOREIGN KEY (uid) REFERENCES users(id) ON DELETE CASCADE,
	sid INT,
	FOREIGN KEY (sid) REFERENCES servers(id) ON DELETE CASCADE
);
 
CREATE TABLE link (
	id INT AUTO_INCREMENT PRIMARY KEY,
	match_percent INT,
	uid1 INT,
	FOREIGN KEY (uid1) REFERENCES users(id) ON DELETE CASCADE,
	uid2 INT,
	FOREIGN KEY (uid2) REFERENCES users(id) ON DELETE CASCADE,
	sid INT,
	FOREIGN KEY (sid) REFERENCES servers(id) ON DELETE CASCADE
);
 
CREATE TABLE stats (
	id INT AUTO_INCREMENT PRIMARY KEY,
	uid INT,
	FOREIGN KEY (uid) REFERENCES users(id) ON DELETE CASCADE,
	sid INT,
	FOREIGN KEY (sid) REFERENCES servers(id) ON DELETE CASCADE
	/* add more stats here */
);