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 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