gaim/www

News posting for beta 3. Feel free to editorize this if you think

2006-03-29, Mark Doliner
3c0f8846df69
News posting for beta 3. Feel free to editorize this if you think
it makes us all look insane.
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)
);