frumiousbandersnatch / rash-qdb-fork Goto Github PK

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)