gaim/www
Clone
Summary
Browse
Changes
Graph
Make a note of the Glib 2.8.x problems. Also add a link to the gnome bugzilla for the window obscured detection not working.
2006-01-10, Daniel Atallah
a6049f693d90
Make a note of the Glib 2.8.x problems. Also add a link to the gnome bugzilla for the window obscured detection not working.
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
)
);