|
Revision 113, 0.8 kB
(checked in by Mircea Amarascu <mircea@ag-projects.com>, 13 months ago)
|
|
Updated MySQL xcap table structure.
|
| Line | |
|---|
| 1 | CREATE TABLE subscriber ( |
|---|
| 2 | id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, |
|---|
| 3 | username VARCHAR(64) NOT NULL DEFAULT '', |
|---|
| 4 | domain VARCHAR(64) NOT NULL DEFAULT '', |
|---|
| 5 | password VARCHAR(25) NOT NULL DEFAULT '', |
|---|
| 6 | ha1 VARCHAR(64) NOT NULL DEFAULT '', |
|---|
| 7 | UNIQUE KEY user_id (username, domain), |
|---|
| 8 | KEY username_id (username) |
|---|
| 9 | ) ENGINE=InnoDB; |
|---|
| 10 | |
|---|
| 11 | CREATE TABLE `xcap` ( |
|---|
| 12 | `id` int(10) NOT NULL auto_increment, |
|---|
| 13 | `username` varchar(66) NOT NULL, |
|---|
| 14 | `domain` varchar(128) NOT NULL, |
|---|
| 15 | `doc` blob NOT NULL, |
|---|
| 16 | `doc_type` int(11) NOT NULL, |
|---|
| 17 | `etag` varchar(64) NOT NULL, |
|---|
| 18 | `source` int(11) NOT NULL, |
|---|
| 19 | `doc_uri` varchar(128) NOT NULL, |
|---|
| 20 | `port` int(11) NOT NULL, |
|---|
| 21 | PRIMARY KEY (`id`), |
|---|
| 22 | UNIQUE KEY `udd_xcap` (`username`,`domain`,`doc_type`,`doc_uri`) |
|---|
| 23 | ) ENGINE=InnoDB; |
|---|
