1 -- ------------------------------------------
2 -- Friendica 3.4.2 (Lily of the valley)
3 -- DB_UPDATE_VERSION 1190
4 -- ------------------------------------------
10 CREATE TABLE IF NOT EXISTS `addon` (
11 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
12 `name` varchar(255) NOT NULL DEFAULT '',
13 `version` varchar(255) NOT NULL DEFAULT '',
14 `installed` tinyint(1) NOT NULL DEFAULT 0,
15 `hidden` tinyint(1) NOT NULL DEFAULT 0,
16 `timestamp` bigint(20) NOT NULL DEFAULT 0,
17 `plugin_admin` tinyint(1) NOT NULL DEFAULT 0
18 ) DEFAULT CHARSET=utf8;
23 CREATE TABLE IF NOT EXISTS `attach` (
24 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
25 `uid` int(11) NOT NULL DEFAULT 0,
26 `hash` varchar(64) NOT NULL DEFAULT '',
27 `filename` varchar(255) NOT NULL DEFAULT '',
28 `filetype` varchar(64) NOT NULL DEFAULT '',
29 `filesize` int(11) NOT NULL DEFAULT 0,
30 `data` longblob NOT NULL,
31 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
32 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
33 `allow_cid` mediumtext NOT NULL,
34 `allow_gid` mediumtext NOT NULL,
35 `deny_cid` mediumtext NOT NULL,
36 `deny_gid` mediumtext NOT NULL
37 ) DEFAULT CHARSET=utf8;
42 CREATE TABLE IF NOT EXISTS `auth_codes` (
43 `id` varchar(40) NOT NULL PRIMARY KEY,
44 `client_id` varchar(20) NOT NULL DEFAULT '',
45 `redirect_uri` varchar(200) NOT NULL DEFAULT '',
46 `expires` int(11) NOT NULL DEFAULT 0,
47 `scope` varchar(250) NOT NULL DEFAULT ''
48 ) DEFAULT CHARSET=utf8;
53 CREATE TABLE IF NOT EXISTS `cache` (
54 `k` varchar(255) NOT NULL PRIMARY KEY,
56 `expire_mode` int(11) NOT NULL DEFAULT 0,
57 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
58 INDEX `updated` (`updated`)
59 ) DEFAULT CHARSET=utf8;
64 CREATE TABLE IF NOT EXISTS `challenge` (
65 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
66 `challenge` varchar(255) NOT NULL DEFAULT '',
67 `dfrn-id` varchar(255) NOT NULL DEFAULT '',
68 `expire` int(11) NOT NULL DEFAULT 0,
69 `type` varchar(255) NOT NULL DEFAULT '',
70 `last_update` varchar(255) NOT NULL DEFAULT ''
71 ) DEFAULT CHARSET=utf8;
76 CREATE TABLE IF NOT EXISTS `clients` (
77 `client_id` varchar(20) NOT NULL PRIMARY KEY,
78 `pw` varchar(20) NOT NULL DEFAULT '',
79 `redirect_uri` varchar(200) NOT NULL DEFAULT '',
82 `uid` int(11) NOT NULL DEFAULT 0
83 ) DEFAULT CHARSET=utf8;
88 CREATE TABLE IF NOT EXISTS `config` (
89 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
90 `cat` varchar(255) NOT NULL DEFAULT '',
91 `k` varchar(255) NOT NULL DEFAULT '',
93 INDEX `cat_k` (`cat`(30),`k`(30))
94 ) DEFAULT CHARSET=utf8;
99 CREATE TABLE IF NOT EXISTS `contact` (
100 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
101 `uid` int(11) NOT NULL DEFAULT 0,
102 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
103 `self` tinyint(1) NOT NULL DEFAULT 0,
104 `remote_self` tinyint(1) NOT NULL DEFAULT 0,
105 `rel` tinyint(1) NOT NULL DEFAULT 0,
106 `duplex` tinyint(1) NOT NULL DEFAULT 0,
107 `network` varchar(255) NOT NULL DEFAULT '',
108 `name` varchar(255) NOT NULL DEFAULT '',
109 `nick` varchar(255) NOT NULL DEFAULT '',
110 `location` varchar(255) NOT NULL DEFAULT '',
111 `about` text NOT NULL,
112 `keywords` text NOT NULL,
113 `gender` varchar(32) NOT NULL DEFAULT '',
114 `attag` varchar(255) NOT NULL DEFAULT '',
115 `photo` text NOT NULL,
116 `thumb` text NOT NULL,
117 `micro` text NOT NULL,
118 `site-pubkey` text NOT NULL,
119 `issued-id` varchar(255) NOT NULL DEFAULT '',
120 `dfrn-id` varchar(255) NOT NULL DEFAULT '',
121 `url` varchar(255) NOT NULL DEFAULT '',
122 `nurl` varchar(255) NOT NULL DEFAULT '',
123 `addr` varchar(255) NOT NULL DEFAULT '',
124 `alias` varchar(255) NOT NULL DEFAULT '',
125 `pubkey` text NOT NULL,
126 `prvkey` text NOT NULL,
127 `batch` varchar(255) NOT NULL DEFAULT '',
128 `request` text NOT NULL,
129 `notify` text NOT NULL,
130 `poll` text NOT NULL,
131 `confirm` text NOT NULL,
132 `poco` text NOT NULL,
133 `aes_allow` tinyint(1) NOT NULL DEFAULT 0,
134 `ret-aes` tinyint(1) NOT NULL DEFAULT 0,
135 `usehub` tinyint(1) NOT NULL DEFAULT 0,
136 `subhub` tinyint(1) NOT NULL DEFAULT 0,
137 `hub-verify` varchar(255) NOT NULL DEFAULT '',
138 `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
139 `success_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
140 `failure_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
141 `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
142 `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
143 `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
144 `term-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
145 `last-item` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
146 `priority` tinyint(3) NOT NULL DEFAULT 0,
147 `blocked` tinyint(1) NOT NULL DEFAULT 1,
148 `readonly` tinyint(1) NOT NULL DEFAULT 0,
149 `writable` tinyint(1) NOT NULL DEFAULT 0,
150 `forum` tinyint(1) NOT NULL DEFAULT 0,
151 `prv` tinyint(1) NOT NULL DEFAULT 0,
152 `hidden` tinyint(1) NOT NULL DEFAULT 0,
153 `archive` tinyint(1) NOT NULL DEFAULT 0,
154 `pending` tinyint(1) NOT NULL DEFAULT 1,
155 `rating` tinyint(1) NOT NULL DEFAULT 0,
156 `reason` text NOT NULL,
157 `closeness` tinyint(2) NOT NULL DEFAULT 99,
158 `info` mediumtext NOT NULL,
159 `profile-id` int(11) NOT NULL DEFAULT 0,
160 `bdyear` varchar(4) NOT NULL DEFAULT '',
161 `bd` date NOT NULL DEFAULT '0000-00-00',
162 `notify_new_posts` tinyint(1) NOT NULL DEFAULT 0,
163 `fetch_further_information` tinyint(1) NOT NULL DEFAULT 0,
164 `ffi_keyword_blacklist` mediumtext NOT NULL,
166 ) DEFAULT CHARSET=utf8;
171 CREATE TABLE IF NOT EXISTS `conv` (
172 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
173 `guid` varchar(64) NOT NULL DEFAULT '',
174 `recips` mediumtext NOT NULL,
175 `uid` int(11) NOT NULL DEFAULT 0,
176 `creator` varchar(255) NOT NULL DEFAULT '',
177 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
178 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
179 `subject` mediumtext NOT NULL,
181 ) DEFAULT CHARSET=utf8;
186 CREATE TABLE IF NOT EXISTS `deliverq` (
187 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
188 `cmd` varchar(32) NOT NULL DEFAULT '',
189 `item` int(11) NOT NULL DEFAULT 0,
190 `contact` int(11) NOT NULL DEFAULT 0
191 ) DEFAULT CHARSET=utf8;
196 CREATE TABLE IF NOT EXISTS `dsprphotoq` (
197 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
198 `uid` int(11) NOT NULL DEFAULT 0,
199 `msg` mediumtext NOT NULL,
200 `attempt` tinyint(4) NOT NULL DEFAULT 0
201 ) DEFAULT CHARSET=utf8;
206 CREATE TABLE IF NOT EXISTS `event` (
207 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
208 `uid` int(11) NOT NULL DEFAULT 0,
209 `cid` int(11) NOT NULL DEFAULT 0,
210 `uri` varchar(255) NOT NULL DEFAULT '',
211 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
212 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
213 `start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
214 `finish` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
215 `summary` text NOT NULL,
216 `desc` text NOT NULL,
217 `location` text NOT NULL,
218 `type` varchar(255) NOT NULL DEFAULT '',
219 `nofinish` tinyint(1) NOT NULL DEFAULT 0,
220 `adjust` tinyint(1) NOT NULL DEFAULT 1,
221 `ignore` tinyint(1) unsigned NOT NULL DEFAULT 0,
222 `allow_cid` mediumtext NOT NULL,
223 `allow_gid` mediumtext NOT NULL,
224 `deny_cid` mediumtext NOT NULL,
225 `deny_gid` mediumtext NOT NULL,
227 ) DEFAULT CHARSET=utf8;
232 CREATE TABLE IF NOT EXISTS `fcontact` (
233 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
234 `url` varchar(255) NOT NULL DEFAULT '',
235 `name` varchar(255) NOT NULL DEFAULT '',
236 `photo` varchar(255) NOT NULL DEFAULT '',
237 `request` varchar(255) NOT NULL DEFAULT '',
238 `nick` varchar(255) NOT NULL DEFAULT '',
239 `addr` varchar(255) NOT NULL DEFAULT '',
240 `batch` varchar(255) NOT NULL DEFAULT '',
241 `notify` varchar(255) NOT NULL DEFAULT '',
242 `poll` varchar(255) NOT NULL DEFAULT '',
243 `confirm` varchar(255) NOT NULL DEFAULT '',
244 `priority` tinyint(1) NOT NULL DEFAULT 0,
245 `network` varchar(32) NOT NULL DEFAULT '',
246 `alias` varchar(255) NOT NULL DEFAULT '',
247 `pubkey` text NOT NULL,
248 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
249 INDEX `addr` (`addr`)
250 ) DEFAULT CHARSET=utf8;
255 CREATE TABLE IF NOT EXISTS `ffinder` (
256 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
257 `uid` int(10) unsigned NOT NULL DEFAULT 0,
258 `cid` int(10) unsigned NOT NULL DEFAULT 0,
259 `fid` int(10) unsigned NOT NULL DEFAULT 0
260 ) DEFAULT CHARSET=utf8;
265 CREATE TABLE IF NOT EXISTS `fserver` (
266 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
267 `server` varchar(255) NOT NULL DEFAULT '',
268 `posturl` varchar(255) NOT NULL DEFAULT '',
270 INDEX `server` (`server`)
271 ) DEFAULT CHARSET=utf8;
276 CREATE TABLE IF NOT EXISTS `fsuggest` (
277 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
278 `uid` int(11) NOT NULL DEFAULT 0,
279 `cid` int(11) NOT NULL DEFAULT 0,
280 `name` varchar(255) NOT NULL DEFAULT '',
281 `url` varchar(255) NOT NULL DEFAULT '',
282 `request` varchar(255) NOT NULL DEFAULT '',
283 `photo` varchar(255) NOT NULL DEFAULT '',
284 `note` text NOT NULL,
285 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
286 ) DEFAULT CHARSET=utf8;
291 CREATE TABLE IF NOT EXISTS `gcign` (
292 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
293 `uid` int(11) NOT NULL DEFAULT 0,
294 `gcid` int(11) NOT NULL DEFAULT 0,
296 INDEX `gcid` (`gcid`)
297 ) DEFAULT CHARSET=utf8;
302 CREATE TABLE IF NOT EXISTS `gcontact` (
303 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
304 `name` varchar(255) NOT NULL DEFAULT '',
305 `nick` varchar(255) NOT NULL DEFAULT '',
306 `url` varchar(255) NOT NULL DEFAULT '',
307 `nurl` varchar(255) NOT NULL DEFAULT '',
308 `photo` varchar(255) NOT NULL DEFAULT '',
309 `connect` varchar(255) NOT NULL DEFAULT '',
310 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
311 `updated` datetime DEFAULT '0000-00-00 00:00:00',
312 `last_contact` datetime DEFAULT '0000-00-00 00:00:00',
313 `last_failure` datetime DEFAULT '0000-00-00 00:00:00',
314 `location` varchar(255) NOT NULL DEFAULT '',
315 `about` text NOT NULL,
316 `keywords` text NOT NULL,
317 `gender` varchar(32) NOT NULL DEFAULT '',
318 `community` tinyint(1) NOT NULL DEFAULT 0,
319 `network` varchar(255) NOT NULL DEFAULT '',
320 `addr` varchar(255) NOT NULL DEFAULT '',
321 `generation` tinyint(3) NOT NULL DEFAULT 0,
322 `server_url` varchar(255) NOT NULL DEFAULT '',
323 INDEX `nurl` (`nurl`),
324 INDEX `updated` (`updated`)
325 ) DEFAULT CHARSET=utf8;
330 CREATE TABLE IF NOT EXISTS `glink` (
331 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
332 `cid` int(11) NOT NULL DEFAULT 0,
333 `uid` int(11) NOT NULL DEFAULT 0,
334 `gcid` int(11) NOT NULL DEFAULT 0,
335 `zcid` int(11) NOT NULL DEFAULT 0,
336 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
337 INDEX `cid_uid_gcid_zcid` (`cid`,`uid`,`gcid`,`zcid`),
338 INDEX `gcid` (`gcid`),
339 INDEX `zcid` (`zcid`)
340 ) DEFAULT CHARSET=utf8;
345 CREATE TABLE IF NOT EXISTS `group` (
346 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
347 `uid` int(10) unsigned NOT NULL DEFAULT 0,
348 `visible` tinyint(1) NOT NULL DEFAULT 0,
349 `deleted` tinyint(1) NOT NULL DEFAULT 0,
350 `name` varchar(255) NOT NULL DEFAULT '',
352 ) DEFAULT CHARSET=utf8;
355 -- TABLE group_member
357 CREATE TABLE IF NOT EXISTS `group_member` (
358 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
359 `uid` int(10) unsigned NOT NULL DEFAULT 0,
360 `gid` int(10) unsigned NOT NULL DEFAULT 0,
361 `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
362 INDEX `uid_gid_contactid` (`uid`,`gid`,`contact-id`)
363 ) DEFAULT CHARSET=utf8;
368 CREATE TABLE IF NOT EXISTS `gserver` (
369 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
370 `url` varchar(255) NOT NULL DEFAULT '',
371 `nurl` varchar(255) NOT NULL DEFAULT '',
372 `version` varchar(255) NOT NULL DEFAULT '',
373 `site_name` varchar(255) NOT NULL DEFAULT '',
374 `info` text NOT NULL,
375 `register_policy` tinyint(1) NOT NULL DEFAULT 0,
376 `poco` varchar(255) NOT NULL DEFAULT '',
377 `noscrape` varchar(255) NOT NULL DEFAULT '',
378 `network` varchar(32) NOT NULL DEFAULT '',
379 `platform` varchar(255) NOT NULL DEFAULT '',
380 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
381 `last_poco_query` datetime DEFAULT '0000-00-00 00:00:00',
382 `last_contact` datetime DEFAULT '0000-00-00 00:00:00',
383 `last_failure` datetime DEFAULT '0000-00-00 00:00:00',
384 INDEX `nurl` (`nurl`)
385 ) DEFAULT CHARSET=utf8;
390 CREATE TABLE IF NOT EXISTS `guid` (
391 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
392 `guid` varchar(255) NOT NULL DEFAULT '',
393 `plink` varchar(255) NOT NULL DEFAULT '',
394 `uri` varchar(255) NOT NULL DEFAULT '',
395 `network` varchar(32) NOT NULL DEFAULT '',
396 INDEX `guid` (`guid`),
397 INDEX `plink` (`plink`),
399 ) DEFAULT CHARSET=utf8;
404 CREATE TABLE IF NOT EXISTS `hook` (
405 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
406 `hook` varchar(255) NOT NULL DEFAULT '',
407 `file` varchar(255) NOT NULL DEFAULT '',
408 `function` varchar(255) NOT NULL DEFAULT '',
409 `priority` int(11) unsigned NOT NULL DEFAULT 0,
410 INDEX `hook_file_function` (`hook`(30),`file`(60),`function`(30))
411 ) DEFAULT CHARSET=utf8;
416 CREATE TABLE IF NOT EXISTS `intro` (
417 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
418 `uid` int(10) unsigned NOT NULL DEFAULT 0,
419 `fid` int(11) NOT NULL DEFAULT 0,
420 `contact-id` int(11) NOT NULL DEFAULT 0,
421 `knowyou` tinyint(1) NOT NULL DEFAULT 0,
422 `duplex` tinyint(1) NOT NULL DEFAULT 0,
423 `note` text NOT NULL,
424 `hash` varchar(255) NOT NULL DEFAULT '',
425 `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
426 `blocked` tinyint(1) NOT NULL DEFAULT 1,
427 `ignore` tinyint(1) NOT NULL DEFAULT 0
428 ) DEFAULT CHARSET=utf8;
433 CREATE TABLE IF NOT EXISTS `item` (
434 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
435 `guid` varchar(255) NOT NULL DEFAULT '',
436 `uri` varchar(255) NOT NULL DEFAULT '',
437 `uid` int(10) unsigned NOT NULL DEFAULT 0,
438 `contact-id` int(11) NOT NULL DEFAULT 0,
439 `type` varchar(255) NOT NULL DEFAULT '',
440 `wall` tinyint(1) NOT NULL DEFAULT 0,
441 `gravity` tinyint(1) NOT NULL DEFAULT 0,
442 `parent` int(10) unsigned NOT NULL DEFAULT 0,
443 `parent-uri` varchar(255) NOT NULL DEFAULT '',
444 `extid` varchar(255) NOT NULL DEFAULT '',
445 `thr-parent` varchar(255) NOT NULL DEFAULT '',
446 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
447 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
448 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
449 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
450 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
451 `owner-name` varchar(255) NOT NULL DEFAULT '',
452 `owner-link` varchar(255) NOT NULL DEFAULT '',
453 `owner-avatar` varchar(255) NOT NULL DEFAULT '',
454 `author-name` varchar(255) NOT NULL DEFAULT '',
455 `author-link` varchar(255) NOT NULL DEFAULT '',
456 `author-avatar` varchar(255) NOT NULL DEFAULT '',
457 `title` varchar(255) NOT NULL DEFAULT '',
458 `body` mediumtext NOT NULL,
459 `app` varchar(255) NOT NULL DEFAULT '',
460 `verb` varchar(255) NOT NULL DEFAULT '',
461 `object-type` varchar(255) NOT NULL DEFAULT '',
462 `object` text NOT NULL,
463 `target-type` varchar(255) NOT NULL DEFAULT '',
464 `target` text NOT NULL,
465 `postopts` text NOT NULL,
466 `plink` varchar(255) NOT NULL DEFAULT '',
467 `resource-id` varchar(255) NOT NULL DEFAULT '',
468 `event-id` int(11) NOT NULL DEFAULT 0,
469 `tag` mediumtext NOT NULL,
470 `attach` mediumtext NOT NULL,
471 `inform` mediumtext NOT NULL,
472 `file` mediumtext NOT NULL,
473 `location` varchar(255) NOT NULL DEFAULT '',
474 `coord` varchar(255) NOT NULL DEFAULT '',
475 `allow_cid` mediumtext NOT NULL,
476 `allow_gid` mediumtext NOT NULL,
477 `deny_cid` mediumtext NOT NULL,
478 `deny_gid` mediumtext NOT NULL,
479 `private` tinyint(1) NOT NULL DEFAULT 0,
480 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
481 `moderated` tinyint(1) NOT NULL DEFAULT 0,
482 `visible` tinyint(1) NOT NULL DEFAULT 0,
483 `spam` tinyint(1) NOT NULL DEFAULT 0,
484 `starred` tinyint(1) NOT NULL DEFAULT 0,
485 `bookmark` tinyint(1) NOT NULL DEFAULT 0,
486 `unseen` tinyint(1) NOT NULL DEFAULT 1,
487 `deleted` tinyint(1) NOT NULL DEFAULT 0,
488 `origin` tinyint(1) NOT NULL DEFAULT 0,
489 `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
490 `last-child` tinyint(1) unsigned NOT NULL DEFAULT 1,
491 `mention` tinyint(1) NOT NULL DEFAULT 0,
492 `network` varchar(32) NOT NULL DEFAULT '',
493 `rendered-hash` varchar(32) NOT NULL DEFAULT '',
494 `rendered-html` mediumtext NOT NULL,
495 `global` tinyint(1) NOT NULL DEFAULT 0,
496 INDEX `guid` (`guid`),
498 INDEX `parent` (`parent`),
499 INDEX `parent-uri` (`parent-uri`),
500 INDEX `extid` (`extid`),
501 INDEX `uid_id` (`uid`,`id`),
502 INDEX `uid_created` (`uid`,`created`),
503 INDEX `uid_unseen` (`uid`,`unseen`),
504 INDEX `uid_network_received` (`uid`,`network`,`received`),
505 INDEX `uid_received` (`uid`,`received`),
506 INDEX `uid_network_commented` (`uid`,`network`,`commented`),
507 INDEX `uid_commented` (`uid`,`commented`),
508 INDEX `uid_title` (`uid`,`title`),
509 INDEX `uid_thrparent` (`uid`,`thr-parent`),
510 INDEX `uid_parenturi` (`uid`,`parent-uri`),
511 INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
512 INDEX `wall_body` (`wall`,`body`(6)),
513 INDEX `uid_visible_moderated_created` (`uid`,`visible`,`moderated`,`created`),
514 INDEX `uid_uri` (`uid`,`uri`),
515 INDEX `uid_wall_created` (`uid`,`wall`,`created`),
516 INDEX `resource-id` (`resource-id`),
517 INDEX `uid_type` (`uid`,`type`),
518 INDEX `uid_starred` (`uid`,`starred`),
519 INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)),
520 INDEX `uid_wall_parent_created` (`uid`,`wall`,`parent`,`created`),
521 INDEX `uid_type_changed` (`uid`,`type`,`changed`),
522 INDEX `contactid_verb` (`contact-id`,`verb`),
523 INDEX `deleted_changed` (`deleted`,`changed`),
524 INDEX `uid_wall_changed` (`uid`,`wall`,`changed`),
525 INDEX `uid_eventid` (`uid`,`event-id`),
526 INDEX `uid_authorlink` (`uid`,`author-link`),
527 INDEX `uid_ownerlink` (`uid`,`owner-link`)
528 ) DEFAULT CHARSET=utf8;
533 CREATE TABLE IF NOT EXISTS `item_id` (
534 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
535 `iid` int(11) NOT NULL DEFAULT 0,
536 `uid` int(11) NOT NULL DEFAULT 0,
537 `sid` varchar(255) NOT NULL DEFAULT '',
538 `service` varchar(255) NOT NULL DEFAULT '',
541 INDEX `service` (`service`),
543 ) DEFAULT CHARSET=utf8;
548 CREATE TABLE IF NOT EXISTS `locks` (
549 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
550 `name` varchar(128) NOT NULL DEFAULT '',
551 `locked` tinyint(1) NOT NULL DEFAULT 0,
552 `created` datetime DEFAULT '0000-00-00 00:00:00'
553 ) DEFAULT CHARSET=utf8;
558 CREATE TABLE IF NOT EXISTS `mail` (
559 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
560 `uid` int(10) unsigned NOT NULL DEFAULT 0,
561 `guid` varchar(64) NOT NULL DEFAULT '',
562 `from-name` varchar(255) NOT NULL DEFAULT '',
563 `from-photo` varchar(255) NOT NULL DEFAULT '',
564 `from-url` varchar(255) NOT NULL DEFAULT '',
565 `contact-id` varchar(255) NOT NULL DEFAULT '',
566 `convid` int(11) unsigned NOT NULL DEFAULT 0,
567 `title` varchar(255) NOT NULL DEFAULT '',
568 `body` mediumtext NOT NULL,
569 `seen` tinyint(1) NOT NULL DEFAULT 0,
570 `reply` tinyint(1) NOT NULL DEFAULT 0,
571 `replied` tinyint(1) NOT NULL DEFAULT 0,
572 `unknown` tinyint(1) NOT NULL DEFAULT 0,
573 `uri` varchar(255) NOT NULL DEFAULT '',
574 `parent-uri` varchar(255) NOT NULL DEFAULT '',
575 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
577 INDEX `guid` (`guid`),
578 INDEX `convid` (`convid`),
579 INDEX `reply` (`reply`),
581 INDEX `parent-uri` (`parent-uri`)
582 ) DEFAULT CHARSET=utf8;
587 CREATE TABLE IF NOT EXISTS `mailacct` (
588 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
589 `uid` int(11) NOT NULL DEFAULT 0,
590 `server` varchar(255) NOT NULL DEFAULT '',
591 `port` int(11) NOT NULL DEFAULT 0,
592 `ssltype` varchar(16) NOT NULL DEFAULT '',
593 `mailbox` varchar(255) NOT NULL DEFAULT '',
594 `user` varchar(255) NOT NULL DEFAULT '',
595 `pass` text NOT NULL,
596 `reply_to` varchar(255) NOT NULL DEFAULT '',
597 `action` int(11) NOT NULL DEFAULT 0,
598 `movetofolder` varchar(255) NOT NULL DEFAULT '',
599 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
600 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
601 ) DEFAULT CHARSET=utf8;
606 CREATE TABLE IF NOT EXISTS `manage` (
607 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
608 `uid` int(11) NOT NULL DEFAULT 0,
609 `mid` int(11) NOT NULL DEFAULT 0,
610 INDEX `uid_mid` (`uid`,`mid`)
611 ) DEFAULT CHARSET=utf8;
616 CREATE TABLE IF NOT EXISTS `notify` (
617 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
618 `hash` varchar(64) NOT NULL DEFAULT '',
619 `type` int(11) NOT NULL DEFAULT 0,
620 `name` varchar(255) NOT NULL DEFAULT '',
621 `url` varchar(255) NOT NULL DEFAULT '',
622 `photo` varchar(255) NOT NULL DEFAULT '',
623 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
624 `msg` mediumtext NOT NULL,
625 `uid` int(11) NOT NULL DEFAULT 0,
626 `link` varchar(255) NOT NULL DEFAULT '',
627 `iid` int(11) NOT NULL DEFAULT 0,
628 `parent` int(11) NOT NULL DEFAULT 0,
629 `seen` tinyint(1) NOT NULL DEFAULT 0,
630 `verb` varchar(255) NOT NULL DEFAULT '',
631 `otype` varchar(16) NOT NULL DEFAULT '',
633 ) DEFAULT CHARSET=utf8;
636 -- TABLE notify-threads
638 CREATE TABLE IF NOT EXISTS `notify-threads` (
639 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
640 `notify-id` int(11) NOT NULL DEFAULT 0,
641 `master-parent-item` int(10) unsigned NOT NULL DEFAULT 0,
642 `parent-item` int(10) unsigned NOT NULL DEFAULT 0,
643 `receiver-uid` int(11) NOT NULL DEFAULT 0,
644 INDEX `master-parent-item` (`master-parent-item`),
645 INDEX `receiver-uid` (`receiver-uid`)
646 ) DEFAULT CHARSET=utf8;
651 CREATE TABLE IF NOT EXISTS `pconfig` (
652 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
653 `uid` int(11) NOT NULL DEFAULT 0,
654 `cat` varchar(255) NOT NULL DEFAULT '',
655 `k` varchar(255) NOT NULL DEFAULT '',
656 `v` mediumtext NOT NULL,
657 INDEX `uid_cat_k` (`uid`,`cat`(30),`k`(30))
658 ) DEFAULT CHARSET=utf8;
663 CREATE TABLE IF NOT EXISTS `photo` (
664 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
665 `uid` int(10) unsigned NOT NULL DEFAULT 0,
666 `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
667 `guid` varchar(64) NOT NULL DEFAULT '',
668 `resource-id` varchar(255) NOT NULL DEFAULT '',
669 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
670 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
671 `title` varchar(255) NOT NULL DEFAULT '',
672 `desc` text NOT NULL,
673 `album` varchar(255) NOT NULL DEFAULT '',
674 `filename` varchar(255) NOT NULL DEFAULT '',
675 `type` varchar(128) NOT NULL DEFAULT 'image/jpeg',
676 `height` smallint(6) NOT NULL DEFAULT 0,
677 `width` smallint(6) NOT NULL DEFAULT 0,
678 `datasize` int(10) unsigned NOT NULL DEFAULT 0,
679 `data` mediumblob NOT NULL,
680 `scale` tinyint(3) NOT NULL DEFAULT 0,
681 `profile` tinyint(1) NOT NULL DEFAULT 0,
682 `allow_cid` mediumtext NOT NULL,
683 `allow_gid` mediumtext NOT NULL,
684 `deny_cid` mediumtext NOT NULL,
685 `deny_gid` mediumtext NOT NULL,
687 INDEX `resource-id` (`resource-id`),
688 INDEX `guid` (`guid`)
689 ) DEFAULT CHARSET=utf8;
694 CREATE TABLE IF NOT EXISTS `poll` (
695 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
696 `uid` int(11) NOT NULL DEFAULT 0,
697 `q0` mediumtext NOT NULL,
698 `q1` mediumtext NOT NULL,
699 `q2` mediumtext NOT NULL,
700 `q3` mediumtext NOT NULL,
701 `q4` mediumtext NOT NULL,
702 `q5` mediumtext NOT NULL,
703 `q6` mediumtext NOT NULL,
704 `q7` mediumtext NOT NULL,
705 `q8` mediumtext NOT NULL,
706 `q9` mediumtext NOT NULL,
708 ) DEFAULT CHARSET=utf8;
713 CREATE TABLE IF NOT EXISTS `poll_result` (
714 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
715 `poll_id` int(11) NOT NULL DEFAULT 0,
716 `choice` int(11) NOT NULL DEFAULT 0,
717 INDEX `poll_id` (`poll_id`),
718 INDEX `choice` (`choice`)
719 ) DEFAULT CHARSET=utf8;
724 CREATE TABLE IF NOT EXISTS `profile` (
725 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
726 `uid` int(11) NOT NULL DEFAULT 0,
727 `profile-name` varchar(255) NOT NULL DEFAULT '',
728 `is-default` tinyint(1) NOT NULL DEFAULT 0,
729 `hide-friends` tinyint(1) NOT NULL DEFAULT 0,
730 `name` varchar(255) NOT NULL DEFAULT '',
731 `pdesc` varchar(255) NOT NULL DEFAULT '',
732 `dob` varchar(32) NOT NULL DEFAULT '0000-00-00',
733 `address` varchar(255) NOT NULL DEFAULT '',
734 `locality` varchar(255) NOT NULL DEFAULT '',
735 `region` varchar(255) NOT NULL DEFAULT '',
736 `postal-code` varchar(32) NOT NULL DEFAULT '',
737 `country-name` varchar(255) NOT NULL DEFAULT '',
738 `hometown` varchar(255) NOT NULL DEFAULT '',
739 `gender` varchar(32) NOT NULL DEFAULT '',
740 `marital` varchar(255) NOT NULL DEFAULT '',
741 `with` text NOT NULL,
742 `howlong` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
743 `sexual` varchar(255) NOT NULL DEFAULT '',
744 `politic` varchar(255) NOT NULL DEFAULT '',
745 `religion` varchar(255) NOT NULL DEFAULT '',
746 `pub_keywords` text NOT NULL,
747 `prv_keywords` text NOT NULL,
748 `likes` text NOT NULL,
749 `dislikes` text NOT NULL,
750 `about` text NOT NULL,
751 `summary` varchar(255) NOT NULL DEFAULT '',
752 `music` text NOT NULL,
753 `book` text NOT NULL,
755 `film` text NOT NULL,
756 `interest` text NOT NULL,
757 `romance` text NOT NULL,
758 `work` text NOT NULL,
759 `education` text NOT NULL,
760 `contact` text NOT NULL,
761 `homepage` varchar(255) NOT NULL DEFAULT '',
762 `photo` varchar(255) NOT NULL DEFAULT '',
763 `thumb` varchar(255) NOT NULL DEFAULT '',
764 `publish` tinyint(1) NOT NULL DEFAULT 0,
765 `net-publish` tinyint(1) NOT NULL DEFAULT 0,
766 INDEX `hometown` (`hometown`)
767 ) DEFAULT CHARSET=utf8;
770 -- TABLE profile_check
772 CREATE TABLE IF NOT EXISTS `profile_check` (
773 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
774 `uid` int(10) unsigned NOT NULL DEFAULT 0,
775 `cid` int(10) unsigned NOT NULL DEFAULT 0,
776 `dfrn_id` varchar(255) NOT NULL DEFAULT '',
777 `sec` varchar(255) NOT NULL DEFAULT '',
778 `expire` int(11) NOT NULL DEFAULT 0
779 ) DEFAULT CHARSET=utf8;
782 -- TABLE push_subscriber
784 CREATE TABLE IF NOT EXISTS `push_subscriber` (
785 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
786 `uid` int(11) NOT NULL DEFAULT 0,
787 `callback_url` varchar(255) NOT NULL DEFAULT '',
788 `topic` varchar(255) NOT NULL DEFAULT '',
789 `nickname` varchar(255) NOT NULL DEFAULT '',
790 `push` int(11) NOT NULL DEFAULT 0,
791 `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
792 `secret` varchar(255) NOT NULL DEFAULT ''
793 ) DEFAULT CHARSET=utf8;
798 CREATE TABLE IF NOT EXISTS `queue` (
799 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
800 `cid` int(11) NOT NULL DEFAULT 0,
801 `network` varchar(32) NOT NULL DEFAULT '',
802 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
803 `last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
804 `content` mediumtext NOT NULL,
805 `batch` tinyint(1) NOT NULL DEFAULT 0,
807 INDEX `created` (`created`),
808 INDEX `last` (`last`),
809 INDEX `network` (`network`),
810 INDEX `batch` (`batch`)
811 ) DEFAULT CHARSET=utf8;
816 CREATE TABLE IF NOT EXISTS `register` (
817 `id` int(11) unsigned NOT NULL auto_increment PRIMARY KEY,
818 `hash` varchar(255) NOT NULL DEFAULT '',
819 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
820 `uid` int(11) unsigned NOT NULL DEFAULT 0,
821 `password` varchar(255) NOT NULL DEFAULT '',
822 `language` varchar(16) NOT NULL DEFAULT ''
823 ) DEFAULT CHARSET=utf8;
828 CREATE TABLE IF NOT EXISTS `search` (
829 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
830 `uid` int(11) NOT NULL DEFAULT 0,
831 `term` varchar(255) NOT NULL DEFAULT '',
833 INDEX `term` (`term`)
834 ) DEFAULT CHARSET=utf8;
839 CREATE TABLE IF NOT EXISTS `session` (
840 `id` bigint(20) unsigned NOT NULL auto_increment PRIMARY KEY,
841 `sid` varchar(255) NOT NULL DEFAULT '',
842 `data` text NOT NULL,
843 `expire` int(10) unsigned NOT NULL DEFAULT 0,
845 INDEX `expire` (`expire`)
846 ) DEFAULT CHARSET=utf8;
851 CREATE TABLE IF NOT EXISTS `sign` (
852 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
853 `iid` int(10) unsigned NOT NULL DEFAULT 0,
854 `retract_iid` int(10) unsigned NOT NULL DEFAULT 0,
855 `signed_text` mediumtext NOT NULL,
856 `signature` text NOT NULL,
857 `signer` varchar(255) NOT NULL DEFAULT '',
859 INDEX `retract_iid` (`retract_iid`)
860 ) DEFAULT CHARSET=utf8;
865 CREATE TABLE IF NOT EXISTS `spam` (
866 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
867 `uid` int(11) NOT NULL DEFAULT 0,
868 `spam` int(11) NOT NULL DEFAULT 0,
869 `ham` int(11) NOT NULL DEFAULT 0,
870 `term` varchar(255) NOT NULL DEFAULT '',
871 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
873 INDEX `spam` (`spam`),
875 INDEX `term` (`term`)
876 ) DEFAULT CHARSET=utf8;
881 CREATE TABLE IF NOT EXISTS `term` (
882 `tid` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
883 `oid` int(10) unsigned NOT NULL DEFAULT 0,
884 `otype` tinyint(3) unsigned NOT NULL DEFAULT 0,
885 `type` tinyint(3) unsigned NOT NULL DEFAULT 0,
886 `term` varchar(255) NOT NULL DEFAULT '',
887 `url` varchar(255) NOT NULL DEFAULT '',
888 `guid` varchar(255) NOT NULL DEFAULT '',
889 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
890 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
891 `global` tinyint(1) NOT NULL DEFAULT 0,
892 `aid` int(10) unsigned NOT NULL DEFAULT 0,
893 `uid` int(10) unsigned NOT NULL DEFAULT 0,
894 INDEX `oid_otype_type_term` (`oid`,`otype`,`type`,`term`),
895 INDEX `uid_term_tid` (`uid`,`term`,`tid`),
896 INDEX `type_term` (`type`,`term`),
897 INDEX `uid_otype_type_term_global_created` (`uid`,`otype`,`type`,`term`,`global`,`created`),
898 INDEX `otype_type_term_tid` (`otype`,`type`,`term`,`tid`),
899 INDEX `guid` (`guid`)
900 ) DEFAULT CHARSET=utf8;
905 CREATE TABLE IF NOT EXISTS `thread` (
906 `iid` int(10) unsigned NOT NULL DEFAULT 0 PRIMARY KEY,
907 `uid` int(10) unsigned NOT NULL DEFAULT 0,
908 `contact-id` int(11) unsigned NOT NULL DEFAULT 0,
909 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
910 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
911 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
912 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
913 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
914 `wall` tinyint(1) NOT NULL DEFAULT 0,
915 `private` tinyint(1) NOT NULL DEFAULT 0,
916 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
917 `moderated` tinyint(1) NOT NULL DEFAULT 0,
918 `visible` tinyint(1) NOT NULL DEFAULT 0,
919 `spam` tinyint(1) NOT NULL DEFAULT 0,
920 `starred` tinyint(1) NOT NULL DEFAULT 0,
921 `ignored` tinyint(1) NOT NULL DEFAULT 0,
922 `bookmark` tinyint(1) NOT NULL DEFAULT 0,
923 `unseen` tinyint(1) NOT NULL DEFAULT 1,
924 `deleted` tinyint(1) NOT NULL DEFAULT 0,
925 `origin` tinyint(1) NOT NULL DEFAULT 0,
926 `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
927 `mention` tinyint(1) NOT NULL DEFAULT 0,
928 `network` varchar(32) NOT NULL DEFAULT '',
929 INDEX `created` (`created`),
930 INDEX `commented` (`commented`),
931 INDEX `uid_network_commented` (`uid`,`network`,`commented`),
932 INDEX `uid_network_created` (`uid`,`network`,`created`),
933 INDEX `uid_contactid_commented` (`uid`,`contact-id`,`commented`),
934 INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
935 INDEX `wall_private_received` (`wall`,`private`,`received`),
936 INDEX `uid_created` (`uid`,`created`),
937 INDEX `uid_commented` (`uid`,`commented`)
938 ) DEFAULT CHARSET=utf8;
943 CREATE TABLE IF NOT EXISTS `tokens` (
944 `id` varchar(40) NOT NULL PRIMARY KEY,
945 `secret` text NOT NULL,
946 `client_id` varchar(20) NOT NULL DEFAULT '',
947 `expires` int(11) NOT NULL DEFAULT 0,
948 `scope` varchar(200) NOT NULL DEFAULT '',
949 `uid` int(11) NOT NULL DEFAULT 0
950 ) DEFAULT CHARSET=utf8;
953 -- TABLE unique_contacts
955 CREATE TABLE IF NOT EXISTS `unique_contacts` (
956 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
957 `url` varchar(255) NOT NULL DEFAULT '',
958 `nick` varchar(255) NOT NULL DEFAULT '',
959 `name` varchar(255) NOT NULL DEFAULT '',
960 `avatar` varchar(255) NOT NULL DEFAULT '',
961 `location` varchar(255) NOT NULL DEFAULT '',
962 `about` text NOT NULL,
964 ) DEFAULT CHARSET=utf8;
969 CREATE TABLE IF NOT EXISTS `user` (
970 `uid` int(11) NOT NULL auto_increment PRIMARY KEY,
971 `guid` varchar(64) NOT NULL DEFAULT '',
972 `username` varchar(255) NOT NULL DEFAULT '',
973 `password` varchar(255) NOT NULL DEFAULT '',
974 `nickname` varchar(255) NOT NULL DEFAULT '',
975 `email` varchar(255) NOT NULL DEFAULT '',
976 `openid` varchar(255) NOT NULL DEFAULT '',
977 `timezone` varchar(128) NOT NULL DEFAULT '',
978 `language` varchar(32) NOT NULL DEFAULT 'en',
979 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
980 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
981 `default-location` varchar(255) NOT NULL DEFAULT '',
982 `allow_location` tinyint(1) NOT NULL DEFAULT 0,
983 `theme` varchar(255) NOT NULL DEFAULT '',
984 `pubkey` text NOT NULL,
985 `prvkey` text NOT NULL,
986 `spubkey` text NOT NULL,
987 `sprvkey` text NOT NULL,
988 `verified` tinyint(1) unsigned NOT NULL DEFAULT 0,
989 `blocked` tinyint(1) unsigned NOT NULL DEFAULT 0,
990 `blockwall` tinyint(1) unsigned NOT NULL DEFAULT 0,
991 `hidewall` tinyint(1) unsigned NOT NULL DEFAULT 0,
992 `blocktags` tinyint(1) unsigned NOT NULL DEFAULT 0,
993 `unkmail` tinyint(1) NOT NULL DEFAULT 0,
994 `cntunkmail` int(11) NOT NULL DEFAULT 10,
995 `notify-flags` int(11) unsigned NOT NULL DEFAULT 65535,
996 `page-flags` int(11) unsigned NOT NULL DEFAULT 0,
997 `prvnets` tinyint(1) NOT NULL DEFAULT 0,
998 `pwdreset` varchar(255) NOT NULL DEFAULT '',
999 `maxreq` int(11) NOT NULL DEFAULT 10,
1000 `expire` int(11) unsigned NOT NULL DEFAULT 0,
1001 `account_removed` tinyint(1) NOT NULL DEFAULT 0,
1002 `account_expired` tinyint(1) NOT NULL DEFAULT 0,
1003 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1004 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1005 `service_class` varchar(32) NOT NULL DEFAULT '',
1006 `def_gid` int(11) NOT NULL DEFAULT 0,
1007 `allow_cid` mediumtext NOT NULL,
1008 `allow_gid` mediumtext NOT NULL,
1009 `deny_cid` mediumtext NOT NULL,
1010 `deny_gid` mediumtext NOT NULL,
1011 `openidserver` text NOT NULL,
1012 INDEX `nickname` (`nickname`)
1013 ) DEFAULT CHARSET=utf8;
1018 CREATE TABLE IF NOT EXISTS `userd` (
1019 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
1020 `username` varchar(255) NOT NULL,
1021 INDEX `username` (`username`)
1022 ) DEFAULT CHARSET=utf8;
1025 -- TABLE workerqueue
1027 CREATE TABLE IF NOT EXISTS `workerqueue` (
1028 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
1029 `parameter` text NOT NULL,
1030 `priority` tinyint(3) unsigned NOT NULL DEFAULT 0,
1031 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1032 `pid` int(11) NOT NULL DEFAULT 0,
1033 `executed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1034 INDEX `created` (`created`)
1035 ) DEFAULT CHARSET=utf8;