gaim/www

(15:54:57) rlaager: LSchiere: I think we're going to need a note about

2006-01-05, Luke Schierer
4b94e9d9da3f
(15:54:57) rlaager: LSchiere: I think we're going to need a note about
this in the release notes or at least the FAQ, but probably the release
notes.
(15:55:18) Luke: we have Release Notes?
(15:55:46) rlaager: People seem to be quite touchy about their timestamps
and we broke with what we've been doing forever.
(15:55:58) Luke: oh I agree it'll need a faq entry
(15:56:12) Luke: lemme do that now before I forget
CREATE TABLE IF NOT EXISTS Users (
USER_ID INT NOT NULL AUTO_INCREMENT,
USERNAME VARCHAR(15) NOT NULL,
PASSWORD VARCHAR(15) NOT NULL,
FIRSTNAME VARCHAR(20),
LASTNAME VARCHAR(20),
EMAIL VARCHAR(85) NOT NULL,
ICQUIN VARCHAR(20),
AIMNAME VARCHAR(40),
YAHOONAME VARCHAR(40),
JABBERNAME VARCHAR(40),
MSNNAME VARCHAR(40),
GGNAME VARCHAR(20),
SESSION_ID VARCHAR(255) NOT NULL,
ADMIN CHAR(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (USER_ID),
UNIQUE (USERNAME)
);
CREATE TABLE IF NOT EXISTS Plugins (
PLUGIN_ID INT NOT NULL AUTO_INCREMENT,
USER_ID INT NOT NULL,
NAME VARCHAR(128) NOT NULL,
VERSION VARCHAR(16) NOT NULL,
URL VARCHAR(255) NOT NULL,
HOMEPAGE VARCHAR(255),
FILESIZE INT NOT NULL,
BRIEF VARCHAR(255) NOT NULL,
DESCRIPTION BLOB NOT NULL,
CREATED DATETIME NOT NULL,
UPDATED DATETIME NOT NULL,
VIEW_COUNT INT,
DOWNLOAD_COUNT INT,
PRIMARY KEY (PLUGIN_ID)
);
CREATE TABLE IF NOT EXISTS Themes (
THEME_ID INT NOT NULL AUTO_INCREMENT,
TYPE_ID INT NOT NULL,
USER_ID INT NOT NULL,
NAME VARCHAR(128) NOT NULL,
VERSION VARCHAR(16) NOT NULL,
URL VARCHAR(255) NOT NULL,
HOMEPAGE VARCHAR(255),
FILESIZE INT NOT NULL,
BRIEF VARCHAR(255) NOT NULL,
DESCRIPTION BLOB NOT NULL,
CREATED DATETIME NOT NULL,
UPDATED DATETIME NOT NULL,
VIEW_COUNT INT,
DOWNLOAD_COUNT INT,
PRIMARY KEY (THEME_ID)
);