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
206
attachment: db-setup.pgsql
(916 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
46
47
48
49
--
-- 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.
--
--
-- registration table
--
CREATE TABLE pyicqt.register (
owner TEXT NOT NULL,
username VARCHAR,
password VARCHAR,
encryptedpassword VARCHAR
);
--
-- settings table
--
CREATE TABLE pyicqt.settings (
owner TEXT NOT NULL,
variable VARCHAR,
value VARCHAR
);
--
-- lists table
--
CREATE TABLE pyicqt.lists (
owner TEXT NOT NULL,
type VARCHAR NOT NULL,
jid VARCHAR
);
--
-- list attributes table
--
CREATE TABLE pyicqt.list_attributes (
owner TEXT NOT NULL,
type VARCHAR NOT NULL,
jid VARCHAR,
attribute VARCHAR,
value VARCHAR
);
Powered by
Google Project Hosting