gaim/www
Clone
Summary
Browse
Changes
Graph
Add Sametime to the list of supported protocols, add 'Novell' in front of GroupWise to match the About box, remove 'MSN window closing notification' from the feature list.
2006-03-20, Richard Laager
bb70bdbaeb5e
Add Sametime to the list of supported protocols, add 'Novell' in front of GroupWise to match the About box, remove 'MSN window closing notification' from the feature list.
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
)
);