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.diff (564 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
19c19,20
< `owner` TEXT NOT NULL,
---
> `id` INT NOT NULL AUTO_INCREMENT,
> `owner` VARCHAR(255) NOT NULL,
21,22c22,24
< `password` TINYTEXT,
< `encryptedpassword` TINYTEXT
---
> `password` VARCHAR(511),
> `salt` CHAR(6),
> PRIMARY KEY (`id`)
29c31
< `owner` TEXT NOT NULL,
---
> `ownerID` INT NOT NULL,
35,43d36
< -- lists table
< --
< CREATE TABLE `lists` (
< `owner` TEXT NOT NULL,
< `type` TINYTEXT NOT NULL,
< `jid` TINYTEXT
< );
<
< --
47c40
< `owner` TEXT NOT NULL,
---
> `ownerID` INT NOT NULL,
Powered by Google Project Hosting