-
Notifications
You must be signed in to change notification settings - Fork 14
/
README
65 lines (53 loc) · 2.95 KB
/
README
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
56
57
58
59
60
61
62
63
64
65
rash-qdb-fork - IRC Quote Database System
This is a fork of the Rash Quote Management System (v 2.0 beta).
Rash is Copyright (C) 2003 Tom Cuchta ([email protected]) and
Instable Network ([email protected] / http://www.instable.net),
and can be found at http://rqms.sourceforge.net
Notes:
* PEAR::DB is needed, still.
* The database schema is different from the Rash 2.0 beta schema; The installer
should be able to update your old database to the new format.
Current database schema:
mysql> describe rash_news;
+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| news | text | NO | | NULL | |
| date | int(10) | NO | | NULL | |
+-------+---------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> describe rash_users;
+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user | varchar(20) | NO | | NULL | |
| password | varchar(255) | NO | | NULL | |
| level | int(1) | NO | | NULL | |
| salt | text | YES | | NULL | |
+----------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> describe rash_quotes;
+--------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| quote | text | NO | | NULL | |
| rating | int(7) | NO | | NULL | |
| flag | int(1) | NO | | NULL | |
| date | int(10) | NO | | NULL | |
| queue | int(1) | NO | | NULL | |
+--------+---------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
mysql> describe rash_tracking;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_ip | varchar(15) | NO | | NULL | |
| user_id | int(11) | YES | | NULL | |
| quote_id | int(11) | NO | | NULL | |
| vote | int(11) | NO | | NULL | |
+----------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)