My favorites
▼
|
Sign in
pyicqt
ICQ transport for XMPP
Project Home
Downloads
Wiki
Issues
Source
READ-ONLY: This project has been
archived
. For more information see
this post
.
Search
Search within:
All issues
Open issues
New issues
Issues to verify
for
Advanced search
Search tips
Subscriptions
Issue
200
attachment: db-setup.mysql
(912 bytes)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
--
-- This is the required schema for MySQL. Load this into the database
-- using the mysql interactive terminal:
--
-- mysql> \. db-setup.mysql
--
-- Then make sure you create a user in MySQL and grant it full access
-- to the pyicqt database. You will need to enter this information
-- into your PyICQt config file.
--
CREATE DATABASE pyicqt;
USE pyicqt;
--
-- registration table
--
CREATE TABLE `register` (
`id` INT NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(255) NOT NULL,
`username` TINYTEXT,
`password` VARCHAR(511),
`salt` CHAR(6),
PRIMARY KEY (`id`)
);
--
-- settings table
--
CREATE TABLE `settings` (
`ownerID` INT NOT NULL,
`variable` TINYTEXT,
`value` TINYTEXT
);
--
-- list attributes table
--
CREATE TABLE `list_attributes` (
`ownerID` INT NOT NULL,
`type` TINYTEXT NOT NULL,
`jid` TINYTEXT,
`attribute` TINYTEXT,
`value` TINYTEXT
);
Powered by
Google Project Hosting