My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
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