1 -- ------------------------------------------
2 -- Friendica 3.5-dev (Asparagus)
3 -- DB_UPDATE_VERSION 1192
4 -- ------------------------------------------
10 CREATE TABLE IF NOT EXISTS `addon` (
11 `id` int(11) NOT NULL auto_increment,
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,
19 ) DEFAULT CHARSET=utf8;
24 CREATE TABLE IF NOT EXISTS `attach` (
25 `id` int(11) NOT NULL auto_increment,
26 `uid` int(11) NOT NULL DEFAULT 0,
27 `hash` varchar(64) NOT NULL DEFAULT '',
28 `filename` varchar(255) NOT NULL DEFAULT '',
29 `filetype` varchar(64) NOT NULL DEFAULT '',
30 `filesize` int(11) NOT NULL DEFAULT 0,
31 `data` longblob NOT NULL,
32 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
33 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
34 `allow_cid` mediumtext NOT NULL,
35 `allow_gid` mediumtext NOT NULL,
36 `deny_cid` mediumtext NOT NULL,
37 `deny_gid` mediumtext NOT NULL,
39 ) DEFAULT CHARSET=utf8;
44 CREATE TABLE IF NOT EXISTS `auth_codes` (
45 `id` varchar(40) NOT NULL,
46 `client_id` varchar(20) NOT NULL DEFAULT '',
47 `redirect_uri` varchar(200) NOT NULL DEFAULT '',
48 `expires` int(11) NOT NULL DEFAULT 0,
49 `scope` varchar(250) NOT NULL DEFAULT '',
51 ) DEFAULT CHARSET=utf8;
56 CREATE TABLE IF NOT EXISTS `cache` (
57 `k` varchar(255) NOT NULL,
59 `expire_mode` int(11) NOT NULL DEFAULT 0,
60 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
62 INDEX `updated` (`updated`)
63 ) DEFAULT CHARSET=utf8;
68 CREATE TABLE IF NOT EXISTS `challenge` (
69 `id` int(10) unsigned NOT NULL auto_increment,
70 `challenge` varchar(255) NOT NULL DEFAULT '',
71 `dfrn-id` varchar(255) NOT NULL DEFAULT '',
72 `expire` int(11) NOT NULL DEFAULT 0,
73 `type` varchar(255) NOT NULL DEFAULT '',
74 `last_update` varchar(255) NOT NULL DEFAULT '',
76 ) DEFAULT CHARSET=utf8;
81 CREATE TABLE IF NOT EXISTS `clients` (
82 `client_id` varchar(20) NOT NULL,
83 `pw` varchar(20) NOT NULL DEFAULT '',
84 `redirect_uri` varchar(200) NOT NULL DEFAULT '',
87 `uid` int(11) NOT NULL DEFAULT 0,
88 PRIMARY KEY(`client_id`)
89 ) DEFAULT CHARSET=utf8;
94 CREATE TABLE IF NOT EXISTS `config` (
95 `id` int(10) unsigned NOT NULL auto_increment,
96 `cat` varchar(255) NOT NULL DEFAULT '',
97 `k` varchar(255) NOT NULL DEFAULT '',
100 INDEX `cat_k` (`cat`(30),`k`(30))
101 ) DEFAULT CHARSET=utf8;
106 CREATE TABLE IF NOT EXISTS `contact` (
107 `id` int(11) NOT NULL auto_increment,
108 `uid` int(11) NOT NULL DEFAULT 0,
109 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
110 `self` tinyint(1) NOT NULL DEFAULT 0,
111 `remote_self` tinyint(1) NOT NULL DEFAULT 0,
112 `rel` tinyint(1) NOT NULL DEFAULT 0,
113 `duplex` tinyint(1) NOT NULL DEFAULT 0,
114 `network` varchar(255) NOT NULL DEFAULT '',
115 `name` varchar(255) NOT NULL DEFAULT '',
116 `nick` varchar(255) NOT NULL DEFAULT '',
117 `location` varchar(255) NOT NULL DEFAULT '',
118 `about` text NOT NULL,
119 `keywords` text NOT NULL,
120 `gender` varchar(32) NOT NULL DEFAULT '',
121 `attag` varchar(255) NOT NULL DEFAULT '',
122 `photo` text NOT NULL,
123 `thumb` text NOT NULL,
124 `micro` text NOT NULL,
125 `site-pubkey` text NOT NULL,
126 `issued-id` varchar(255) NOT NULL DEFAULT '',
127 `dfrn-id` varchar(255) NOT NULL DEFAULT '',
128 `url` varchar(255) NOT NULL DEFAULT '',
129 `nurl` varchar(255) NOT NULL DEFAULT '',
130 `addr` varchar(255) NOT NULL DEFAULT '',
131 `alias` varchar(255) NOT NULL DEFAULT '',
132 `pubkey` text NOT NULL,
133 `prvkey` text NOT NULL,
134 `batch` varchar(255) NOT NULL DEFAULT '',
135 `request` text NOT NULL,
136 `notify` text NOT NULL,
137 `poll` text NOT NULL,
138 `confirm` text NOT NULL,
139 `poco` text NOT NULL,
140 `aes_allow` tinyint(1) NOT NULL DEFAULT 0,
141 `ret-aes` tinyint(1) NOT NULL DEFAULT 0,
142 `usehub` tinyint(1) NOT NULL DEFAULT 0,
143 `subhub` tinyint(1) NOT NULL DEFAULT 0,
144 `hub-verify` varchar(255) NOT NULL DEFAULT '',
145 `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
146 `success_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
147 `failure_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
148 `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
149 `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
150 `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
151 `term-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
152 `last-item` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
153 `priority` tinyint(3) NOT NULL DEFAULT 0,
154 `blocked` tinyint(1) NOT NULL DEFAULT 1,
155 `readonly` tinyint(1) NOT NULL DEFAULT 0,
156 `writable` tinyint(1) NOT NULL DEFAULT 0,
157 `forum` tinyint(1) NOT NULL DEFAULT 0,
158 `prv` tinyint(1) NOT NULL DEFAULT 0,
159 `hidden` tinyint(1) NOT NULL DEFAULT 0,
160 `archive` tinyint(1) NOT NULL DEFAULT 0,
161 `pending` tinyint(1) NOT NULL DEFAULT 1,
162 `rating` tinyint(1) NOT NULL DEFAULT 0,
163 `reason` text NOT NULL,
164 `closeness` tinyint(2) NOT NULL DEFAULT 99,
165 `info` mediumtext NOT NULL,
166 `profile-id` int(11) NOT NULL DEFAULT 0,
167 `bdyear` varchar(4) NOT NULL DEFAULT '',
168 `bd` date NOT NULL DEFAULT '0000-00-00',
169 `notify_new_posts` tinyint(1) NOT NULL DEFAULT 0,
170 `fetch_further_information` tinyint(1) NOT NULL DEFAULT 0,
171 `ffi_keyword_blacklist` mediumtext NOT NULL,
174 ) DEFAULT CHARSET=utf8;
179 CREATE TABLE IF NOT EXISTS `conv` (
180 `id` int(10) unsigned NOT NULL auto_increment,
181 `guid` varchar(64) NOT NULL DEFAULT '',
182 `recips` mediumtext NOT NULL,
183 `uid` int(11) NOT NULL DEFAULT 0,
184 `creator` varchar(255) NOT NULL DEFAULT '',
185 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
186 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
187 `subject` mediumtext NOT NULL,
190 ) DEFAULT CHARSET=utf8;
195 CREATE TABLE IF NOT EXISTS `deliverq` (
196 `id` int(10) unsigned NOT NULL auto_increment,
197 `cmd` varchar(32) NOT NULL DEFAULT '',
198 `item` int(11) NOT NULL DEFAULT 0,
199 `contact` int(11) NOT NULL DEFAULT 0,
201 ) DEFAULT CHARSET=utf8;
206 CREATE TABLE IF NOT EXISTS `dsprphotoq` (
207 `id` int(10) unsigned NOT NULL auto_increment,
208 `uid` int(11) NOT NULL DEFAULT 0,
209 `msg` mediumtext NOT NULL,
210 `attempt` tinyint(4) NOT NULL DEFAULT 0,
212 ) DEFAULT CHARSET=utf8;
217 CREATE TABLE IF NOT EXISTS `event` (
218 `id` int(11) NOT NULL auto_increment,
219 `uid` int(11) NOT NULL DEFAULT 0,
220 `cid` int(11) NOT NULL DEFAULT 0,
221 `uri` varchar(255) NOT NULL DEFAULT '',
222 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
223 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
224 `start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
225 `finish` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
226 `summary` text NOT NULL,
227 `desc` text NOT NULL,
228 `location` text NOT NULL,
229 `type` varchar(255) NOT NULL DEFAULT '',
230 `nofinish` tinyint(1) NOT NULL DEFAULT 0,
231 `adjust` tinyint(1) NOT NULL DEFAULT 1,
232 `ignore` tinyint(1) unsigned NOT NULL DEFAULT 0,
233 `allow_cid` mediumtext NOT NULL,
234 `allow_gid` mediumtext NOT NULL,
235 `deny_cid` mediumtext NOT NULL,
236 `deny_gid` mediumtext NOT NULL,
239 ) DEFAULT CHARSET=utf8;
244 CREATE TABLE IF NOT EXISTS `fcontact` (
245 `id` int(10) unsigned NOT NULL auto_increment,
246 `url` varchar(255) NOT NULL DEFAULT '',
247 `name` varchar(255) NOT NULL DEFAULT '',
248 `photo` varchar(255) NOT NULL DEFAULT '',
249 `request` varchar(255) NOT NULL DEFAULT '',
250 `nick` varchar(255) NOT NULL DEFAULT '',
251 `addr` varchar(255) NOT NULL DEFAULT '',
252 `batch` varchar(255) NOT NULL DEFAULT '',
253 `notify` varchar(255) NOT NULL DEFAULT '',
254 `poll` varchar(255) NOT NULL DEFAULT '',
255 `confirm` varchar(255) NOT NULL DEFAULT '',
256 `priority` tinyint(1) NOT NULL DEFAULT 0,
257 `network` varchar(32) NOT NULL DEFAULT '',
258 `alias` varchar(255) NOT NULL DEFAULT '',
259 `pubkey` text NOT NULL,
260 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
262 INDEX `addr` (`addr`)
263 ) DEFAULT CHARSET=utf8;
268 CREATE TABLE IF NOT EXISTS `ffinder` (
269 `id` int(10) unsigned NOT NULL auto_increment,
270 `uid` int(10) unsigned NOT NULL DEFAULT 0,
271 `cid` int(10) unsigned NOT NULL DEFAULT 0,
272 `fid` int(10) unsigned NOT NULL DEFAULT 0,
274 ) DEFAULT CHARSET=utf8;
279 CREATE TABLE IF NOT EXISTS `fserver` (
280 `id` int(11) NOT NULL auto_increment,
281 `server` varchar(255) NOT NULL DEFAULT '',
282 `posturl` varchar(255) NOT NULL DEFAULT '',
285 INDEX `server` (`server`)
286 ) DEFAULT CHARSET=utf8;
291 CREATE TABLE IF NOT EXISTS `fsuggest` (
292 `id` int(11) NOT NULL auto_increment,
293 `uid` int(11) NOT NULL DEFAULT 0,
294 `cid` int(11) NOT NULL DEFAULT 0,
295 `name` varchar(255) NOT NULL DEFAULT '',
296 `url` varchar(255) NOT NULL DEFAULT '',
297 `request` varchar(255) NOT NULL DEFAULT '',
298 `photo` varchar(255) NOT NULL DEFAULT '',
299 `note` text NOT NULL,
300 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
302 ) DEFAULT CHARSET=utf8;
307 CREATE TABLE IF NOT EXISTS `gcign` (
308 `id` int(11) NOT NULL auto_increment,
309 `uid` int(11) NOT NULL DEFAULT 0,
310 `gcid` int(11) NOT NULL DEFAULT 0,
313 INDEX `gcid` (`gcid`)
314 ) DEFAULT CHARSET=utf8;
319 CREATE TABLE IF NOT EXISTS `gcontact` (
320 `id` int(10) unsigned NOT NULL auto_increment,
321 `name` varchar(255) NOT NULL DEFAULT '',
322 `nick` varchar(255) NOT NULL DEFAULT '',
323 `url` varchar(255) NOT NULL DEFAULT '',
324 `nurl` varchar(255) NOT NULL DEFAULT '',
325 `photo` varchar(255) NOT NULL DEFAULT '',
326 `connect` varchar(255) NOT NULL DEFAULT '',
327 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
328 `updated` datetime DEFAULT '0000-00-00 00:00:00',
329 `last_contact` datetime DEFAULT '0000-00-00 00:00:00',
330 `last_failure` datetime DEFAULT '0000-00-00 00:00:00',
331 `location` varchar(255) NOT NULL DEFAULT '',
332 `about` text NOT NULL,
333 `keywords` text NOT NULL,
334 `gender` varchar(32) NOT NULL DEFAULT '',
335 `birthday` varchar(32) NOT NULL DEFAULT '0000-00-00',
336 `community` tinyint(1) NOT NULL DEFAULT 0,
337 `hide` tinyint(1) NOT NULL DEFAULT 0,
338 `nsfw` tinyint(1) NOT NULL DEFAULT 0,
339 `network` varchar(255) NOT NULL DEFAULT '',
340 `addr` varchar(255) NOT NULL DEFAULT '',
341 `notify` text NOT NULL,
342 `alias` varchar(255) NOT NULL DEFAULT '',
343 `generation` tinyint(3) NOT NULL DEFAULT 0,
344 `server_url` varchar(255) NOT NULL DEFAULT '',
346 INDEX `nurl` (`nurl`),
347 INDEX `updated` (`updated`)
348 ) DEFAULT CHARSET=utf8;
353 CREATE TABLE IF NOT EXISTS `glink` (
354 `id` int(10) unsigned NOT NULL auto_increment,
355 `cid` int(11) NOT NULL DEFAULT 0,
356 `uid` int(11) NOT NULL DEFAULT 0,
357 `gcid` int(11) NOT NULL DEFAULT 0,
358 `zcid` int(11) NOT NULL DEFAULT 0,
359 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
361 INDEX `cid_uid_gcid_zcid` (`cid`,`uid`,`gcid`,`zcid`),
362 INDEX `gcid` (`gcid`),
363 INDEX `zcid` (`zcid`)
364 ) DEFAULT CHARSET=utf8;
369 CREATE TABLE IF NOT EXISTS `group` (
370 `id` int(10) unsigned NOT NULL auto_increment,
371 `uid` int(10) unsigned NOT NULL DEFAULT 0,
372 `visible` tinyint(1) NOT NULL DEFAULT 0,
373 `deleted` tinyint(1) NOT NULL DEFAULT 0,
374 `name` varchar(255) NOT NULL DEFAULT '',
377 ) DEFAULT CHARSET=utf8;
380 -- TABLE group_member
382 CREATE TABLE IF NOT EXISTS `group_member` (
383 `id` int(10) unsigned NOT NULL auto_increment,
384 `uid` int(10) unsigned NOT NULL DEFAULT 0,
385 `gid` int(10) unsigned NOT NULL DEFAULT 0,
386 `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
388 INDEX `uid_gid_contactid` (`uid`,`gid`,`contact-id`)
389 ) DEFAULT CHARSET=utf8;
394 CREATE TABLE IF NOT EXISTS `gserver` (
395 `id` int(10) unsigned NOT NULL auto_increment,
396 `url` varchar(255) NOT NULL DEFAULT '',
397 `nurl` varchar(255) NOT NULL DEFAULT '',
398 `version` varchar(255) NOT NULL DEFAULT '',
399 `site_name` varchar(255) NOT NULL DEFAULT '',
400 `info` text NOT NULL,
401 `register_policy` tinyint(1) NOT NULL DEFAULT 0,
402 `poco` varchar(255) NOT NULL DEFAULT '',
403 `noscrape` varchar(255) NOT NULL DEFAULT '',
404 `network` varchar(32) NOT NULL DEFAULT '',
405 `platform` varchar(255) NOT NULL DEFAULT '',
406 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
407 `last_poco_query` datetime DEFAULT '0000-00-00 00:00:00',
408 `last_contact` datetime DEFAULT '0000-00-00 00:00:00',
409 `last_failure` datetime DEFAULT '0000-00-00 00:00:00',
411 INDEX `nurl` (`nurl`)
412 ) DEFAULT CHARSET=utf8;
417 CREATE TABLE IF NOT EXISTS `guid` (
418 `id` int(10) unsigned NOT NULL auto_increment,
419 `guid` varchar(255) NOT NULL DEFAULT '',
420 `plink` varchar(255) NOT NULL DEFAULT '',
421 `uri` varchar(255) NOT NULL DEFAULT '',
422 `network` varchar(32) NOT NULL DEFAULT '',
424 INDEX `guid` (`guid`),
425 INDEX `plink` (`plink`),
427 ) DEFAULT CHARSET=utf8;
432 CREATE TABLE IF NOT EXISTS `hook` (
433 `id` int(11) NOT NULL auto_increment,
434 `hook` varchar(255) NOT NULL DEFAULT '',
435 `file` varchar(255) NOT NULL DEFAULT '',
436 `function` varchar(255) NOT NULL DEFAULT '',
437 `priority` int(11) unsigned NOT NULL DEFAULT 0,
439 INDEX `hook_file_function` (`hook`(30),`file`(60),`function`(30))
440 ) DEFAULT CHARSET=utf8;
445 CREATE TABLE IF NOT EXISTS `intro` (
446 `id` int(10) unsigned NOT NULL auto_increment,
447 `uid` int(10) unsigned NOT NULL DEFAULT 0,
448 `fid` int(11) NOT NULL DEFAULT 0,
449 `contact-id` int(11) NOT NULL DEFAULT 0,
450 `knowyou` tinyint(1) NOT NULL DEFAULT 0,
451 `duplex` tinyint(1) NOT NULL DEFAULT 0,
452 `note` text NOT NULL,
453 `hash` varchar(255) NOT NULL DEFAULT '',
454 `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
455 `blocked` tinyint(1) NOT NULL DEFAULT 1,
456 `ignore` tinyint(1) NOT NULL DEFAULT 0,
458 ) DEFAULT CHARSET=utf8;
463 CREATE TABLE IF NOT EXISTS `item` (
464 `id` int(10) unsigned NOT NULL auto_increment,
465 `guid` varchar(255) NOT NULL DEFAULT '',
466 `uri` varchar(255) NOT NULL DEFAULT '',
467 `uid` int(10) unsigned NOT NULL DEFAULT 0,
468 `contact-id` int(11) NOT NULL DEFAULT 0,
469 `gcontact-id` int(11) unsigned NOT NULL DEFAULT 0,
470 `type` varchar(255) NOT NULL DEFAULT '',
471 `wall` tinyint(1) NOT NULL DEFAULT 0,
472 `gravity` tinyint(1) NOT NULL DEFAULT 0,
473 `parent` int(10) unsigned NOT NULL DEFAULT 0,
474 `parent-uri` varchar(255) NOT NULL DEFAULT '',
475 `extid` varchar(255) NOT NULL DEFAULT '',
476 `thr-parent` varchar(255) NOT NULL DEFAULT '',
477 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
478 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
479 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
480 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
481 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
482 `owner-name` varchar(255) NOT NULL DEFAULT '',
483 `owner-link` varchar(255) NOT NULL DEFAULT '',
484 `owner-avatar` varchar(255) NOT NULL DEFAULT '',
485 `author-name` varchar(255) NOT NULL DEFAULT '',
486 `author-link` varchar(255) NOT NULL DEFAULT '',
487 `author-avatar` varchar(255) NOT NULL DEFAULT '',
488 `title` varchar(255) NOT NULL DEFAULT '',
489 `body` mediumtext NOT NULL,
490 `app` varchar(255) NOT NULL DEFAULT '',
491 `verb` varchar(255) NOT NULL DEFAULT '',
492 `object-type` varchar(255) NOT NULL DEFAULT '',
493 `object` text NOT NULL,
494 `target-type` varchar(255) NOT NULL DEFAULT '',
495 `target` text NOT NULL,
496 `postopts` text NOT NULL,
497 `plink` varchar(255) NOT NULL DEFAULT '',
498 `resource-id` varchar(255) NOT NULL DEFAULT '',
499 `event-id` int(11) NOT NULL DEFAULT 0,
500 `tag` mediumtext NOT NULL,
501 `attach` mediumtext NOT NULL,
502 `inform` mediumtext NOT NULL,
503 `file` mediumtext NOT NULL,
504 `location` varchar(255) NOT NULL DEFAULT '',
505 `coord` varchar(255) NOT NULL DEFAULT '',
506 `allow_cid` mediumtext NOT NULL,
507 `allow_gid` mediumtext NOT NULL,
508 `deny_cid` mediumtext NOT NULL,
509 `deny_gid` mediumtext NOT NULL,
510 `private` tinyint(1) NOT NULL DEFAULT 0,
511 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
512 `moderated` tinyint(1) NOT NULL DEFAULT 0,
513 `visible` tinyint(1) NOT NULL DEFAULT 0,
514 `spam` tinyint(1) NOT NULL DEFAULT 0,
515 `starred` tinyint(1) NOT NULL DEFAULT 0,
516 `bookmark` tinyint(1) NOT NULL DEFAULT 0,
517 `unseen` tinyint(1) NOT NULL DEFAULT 1,
518 `deleted` tinyint(1) NOT NULL DEFAULT 0,
519 `origin` tinyint(1) NOT NULL DEFAULT 0,
520 `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
521 `last-child` tinyint(1) unsigned NOT NULL DEFAULT 1,
522 `mention` tinyint(1) NOT NULL DEFAULT 0,
523 `network` varchar(32) NOT NULL DEFAULT '',
524 `rendered-hash` varchar(32) NOT NULL DEFAULT '',
525 `rendered-html` mediumtext NOT NULL,
526 `global` tinyint(1) NOT NULL DEFAULT 0,
528 INDEX `guid` (`guid`),
530 INDEX `parent` (`parent`),
531 INDEX `parent-uri` (`parent-uri`),
532 INDEX `extid` (`extid`),
533 INDEX `uid_id` (`uid`,`id`),
534 INDEX `uid_created` (`uid`,`created`),
535 INDEX `uid_unseen` (`uid`,`unseen`),
536 INDEX `uid_network_received` (`uid`,`network`,`received`),
537 INDEX `uid_received` (`uid`,`received`),
538 INDEX `uid_network_commented` (`uid`,`network`,`commented`),
539 INDEX `uid_commented` (`uid`,`commented`),
540 INDEX `uid_title` (`uid`,`title`),
541 INDEX `uid_thrparent` (`uid`,`thr-parent`),
542 INDEX `uid_parenturi` (`uid`,`parent-uri`),
543 INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
544 INDEX `gcontactid_uid_created` (`gcontact-id`,`uid`,`created`),
545 INDEX `wall_body` (`wall`,`body`(6)),
546 INDEX `uid_visible_moderated_created` (`uid`,`visible`,`moderated`,`created`),
547 INDEX `uid_uri` (`uid`,`uri`),
548 INDEX `uid_wall_created` (`uid`,`wall`,`created`),
549 INDEX `resource-id` (`resource-id`),
550 INDEX `uid_type` (`uid`,`type`),
551 INDEX `uid_starred` (`uid`,`starred`),
552 INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)),
553 INDEX `uid_wall_parent_created` (`uid`,`wall`,`parent`,`created`),
554 INDEX `uid_type_changed` (`uid`,`type`,`changed`),
555 INDEX `contactid_verb` (`contact-id`,`verb`),
556 INDEX `deleted_changed` (`deleted`,`changed`),
557 INDEX `uid_wall_changed` (`uid`,`wall`,`changed`),
558 INDEX `uid_eventid` (`uid`,`event-id`),
559 INDEX `uid_authorlink` (`uid`,`author-link`),
560 INDEX `uid_ownerlink` (`uid`,`owner-link`)
561 ) DEFAULT CHARSET=utf8;
566 CREATE TABLE IF NOT EXISTS `item_id` (
567 `id` int(11) NOT NULL auto_increment,
568 `iid` int(11) NOT NULL DEFAULT 0,
569 `uid` int(11) NOT NULL DEFAULT 0,
570 `sid` varchar(255) NOT NULL DEFAULT '',
571 `service` varchar(255) NOT NULL DEFAULT '',
575 INDEX `service` (`service`),
577 ) DEFAULT CHARSET=utf8;
582 CREATE TABLE IF NOT EXISTS `locks` (
583 `id` int(11) NOT NULL auto_increment,
584 `name` varchar(128) NOT NULL DEFAULT '',
585 `locked` tinyint(1) NOT NULL DEFAULT 0,
586 `created` datetime DEFAULT '0000-00-00 00:00:00',
588 ) DEFAULT CHARSET=utf8;
593 CREATE TABLE IF NOT EXISTS `mail` (
594 `id` int(10) unsigned NOT NULL auto_increment,
595 `uid` int(10) unsigned NOT NULL DEFAULT 0,
596 `guid` varchar(64) NOT NULL DEFAULT '',
597 `from-name` varchar(255) NOT NULL DEFAULT '',
598 `from-photo` varchar(255) NOT NULL DEFAULT '',
599 `from-url` varchar(255) NOT NULL DEFAULT '',
600 `contact-id` varchar(255) NOT NULL DEFAULT '',
601 `convid` int(11) unsigned NOT NULL DEFAULT 0,
602 `title` varchar(255) NOT NULL DEFAULT '',
603 `body` mediumtext NOT NULL,
604 `seen` tinyint(1) NOT NULL DEFAULT 0,
605 `reply` tinyint(1) NOT NULL DEFAULT 0,
606 `replied` tinyint(1) NOT NULL DEFAULT 0,
607 `unknown` tinyint(1) NOT NULL DEFAULT 0,
608 `uri` varchar(255) NOT NULL DEFAULT '',
609 `parent-uri` varchar(255) NOT NULL DEFAULT '',
610 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
613 INDEX `guid` (`guid`),
614 INDEX `convid` (`convid`),
615 INDEX `reply` (`reply`),
617 INDEX `parent-uri` (`parent-uri`)
618 ) DEFAULT CHARSET=utf8;
623 CREATE TABLE IF NOT EXISTS `mailacct` (
624 `id` int(11) NOT NULL auto_increment,
625 `uid` int(11) NOT NULL DEFAULT 0,
626 `server` varchar(255) NOT NULL DEFAULT '',
627 `port` int(11) NOT NULL DEFAULT 0,
628 `ssltype` varchar(16) NOT NULL DEFAULT '',
629 `mailbox` varchar(255) NOT NULL DEFAULT '',
630 `user` varchar(255) NOT NULL DEFAULT '',
631 `pass` text NOT NULL,
632 `reply_to` varchar(255) NOT NULL DEFAULT '',
633 `action` int(11) NOT NULL DEFAULT 0,
634 `movetofolder` varchar(255) NOT NULL DEFAULT '',
635 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
636 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
638 ) DEFAULT CHARSET=utf8;
643 CREATE TABLE IF NOT EXISTS `manage` (
644 `id` int(11) NOT NULL auto_increment,
645 `uid` int(11) NOT NULL DEFAULT 0,
646 `mid` int(11) NOT NULL DEFAULT 0,
648 INDEX `uid_mid` (`uid`,`mid`)
649 ) DEFAULT CHARSET=utf8;
654 CREATE TABLE IF NOT EXISTS `notify` (
655 `id` int(11) NOT NULL auto_increment,
656 `hash` varchar(64) NOT NULL DEFAULT '',
657 `type` int(11) NOT NULL DEFAULT 0,
658 `name` varchar(255) NOT NULL DEFAULT '',
659 `url` varchar(255) NOT NULL DEFAULT '',
660 `photo` varchar(255) NOT NULL DEFAULT '',
661 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
662 `msg` mediumtext NOT NULL,
663 `uid` int(11) NOT NULL DEFAULT 0,
664 `link` varchar(255) NOT NULL DEFAULT '',
665 `iid` int(11) NOT NULL DEFAULT 0,
666 `parent` int(11) NOT NULL DEFAULT 0,
667 `seen` tinyint(1) NOT NULL DEFAULT 0,
668 `verb` varchar(255) NOT NULL DEFAULT '',
669 `otype` varchar(16) NOT NULL DEFAULT '',
672 ) DEFAULT CHARSET=utf8;
675 -- TABLE notify-threads
677 CREATE TABLE IF NOT EXISTS `notify-threads` (
678 `id` int(11) NOT NULL auto_increment,
679 `notify-id` int(11) NOT NULL DEFAULT 0,
680 `master-parent-item` int(10) unsigned NOT NULL DEFAULT 0,
681 `parent-item` int(10) unsigned NOT NULL DEFAULT 0,
682 `receiver-uid` int(11) NOT NULL DEFAULT 0,
684 INDEX `master-parent-item` (`master-parent-item`),
685 INDEX `receiver-uid` (`receiver-uid`)
686 ) DEFAULT CHARSET=utf8;
691 CREATE TABLE IF NOT EXISTS `pconfig` (
692 `id` int(11) NOT NULL auto_increment,
693 `uid` int(11) NOT NULL DEFAULT 0,
694 `cat` varchar(255) NOT NULL DEFAULT '',
695 `k` varchar(255) NOT NULL DEFAULT '',
696 `v` mediumtext NOT NULL,
698 INDEX `uid_cat_k` (`uid`,`cat`(30),`k`(30))
699 ) DEFAULT CHARSET=utf8;
704 CREATE TABLE IF NOT EXISTS `photo` (
705 `id` int(10) unsigned NOT NULL auto_increment,
706 `uid` int(10) unsigned NOT NULL DEFAULT 0,
707 `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
708 `guid` varchar(64) NOT NULL DEFAULT '',
709 `resource-id` varchar(255) NOT NULL DEFAULT '',
710 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
711 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
712 `title` varchar(255) NOT NULL DEFAULT '',
713 `desc` text NOT NULL,
714 `album` varchar(255) NOT NULL DEFAULT '',
715 `filename` varchar(255) NOT NULL DEFAULT '',
716 `type` varchar(128) NOT NULL DEFAULT 'image/jpeg',
717 `height` smallint(6) NOT NULL DEFAULT 0,
718 `width` smallint(6) NOT NULL DEFAULT 0,
719 `datasize` int(10) unsigned NOT NULL DEFAULT 0,
720 `data` mediumblob NOT NULL,
721 `scale` tinyint(3) NOT NULL DEFAULT 0,
722 `profile` tinyint(1) NOT NULL DEFAULT 0,
723 `allow_cid` mediumtext NOT NULL,
724 `allow_gid` mediumtext NOT NULL,
725 `deny_cid` mediumtext NOT NULL,
726 `deny_gid` mediumtext NOT NULL,
729 INDEX `resource-id` (`resource-id`),
730 INDEX `guid` (`guid`)
731 ) DEFAULT CHARSET=utf8;
736 CREATE TABLE IF NOT EXISTS `poll` (
737 `id` int(11) NOT NULL auto_increment,
738 `uid` int(11) NOT NULL DEFAULT 0,
739 `q0` mediumtext NOT NULL,
740 `q1` mediumtext NOT NULL,
741 `q2` mediumtext NOT NULL,
742 `q3` mediumtext NOT NULL,
743 `q4` mediumtext NOT NULL,
744 `q5` mediumtext NOT NULL,
745 `q6` mediumtext NOT NULL,
746 `q7` mediumtext NOT NULL,
747 `q8` mediumtext NOT NULL,
748 `q9` mediumtext NOT NULL,
751 ) DEFAULT CHARSET=utf8;
756 CREATE TABLE IF NOT EXISTS `poll_result` (
757 `id` int(11) NOT NULL auto_increment,
758 `poll_id` int(11) NOT NULL DEFAULT 0,
759 `choice` int(11) NOT NULL DEFAULT 0,
761 INDEX `poll_id` (`poll_id`),
762 INDEX `choice` (`choice`)
763 ) DEFAULT CHARSET=utf8;
768 CREATE TABLE IF NOT EXISTS `profile` (
769 `id` int(11) NOT NULL auto_increment,
770 `uid` int(11) NOT NULL DEFAULT 0,
771 `profile-name` varchar(255) NOT NULL DEFAULT '',
772 `is-default` tinyint(1) NOT NULL DEFAULT 0,
773 `hide-friends` tinyint(1) NOT NULL DEFAULT 0,
774 `name` varchar(255) NOT NULL DEFAULT '',
775 `pdesc` varchar(255) NOT NULL DEFAULT '',
776 `dob` varchar(32) NOT NULL DEFAULT '0000-00-00',
777 `address` varchar(255) NOT NULL DEFAULT '',
778 `locality` varchar(255) NOT NULL DEFAULT '',
779 `region` varchar(255) NOT NULL DEFAULT '',
780 `postal-code` varchar(32) NOT NULL DEFAULT '',
781 `country-name` varchar(255) NOT NULL DEFAULT '',
782 `hometown` varchar(255) NOT NULL DEFAULT '',
783 `gender` varchar(32) NOT NULL DEFAULT '',
784 `marital` varchar(255) NOT NULL DEFAULT '',
785 `with` text NOT NULL,
786 `howlong` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
787 `sexual` varchar(255) NOT NULL DEFAULT '',
788 `politic` varchar(255) NOT NULL DEFAULT '',
789 `religion` varchar(255) NOT NULL DEFAULT '',
790 `pub_keywords` text NOT NULL,
791 `prv_keywords` text NOT NULL,
792 `likes` text NOT NULL,
793 `dislikes` text NOT NULL,
794 `about` text NOT NULL,
795 `summary` varchar(255) NOT NULL DEFAULT '',
796 `music` text NOT NULL,
797 `book` text NOT NULL,
799 `film` text NOT NULL,
800 `interest` text NOT NULL,
801 `romance` text NOT NULL,
802 `work` text NOT NULL,
803 `education` text NOT NULL,
804 `contact` text NOT NULL,
805 `homepage` varchar(255) NOT NULL DEFAULT '',
806 `photo` varchar(255) NOT NULL DEFAULT '',
807 `thumb` varchar(255) NOT NULL DEFAULT '',
808 `publish` tinyint(1) NOT NULL DEFAULT 0,
809 `net-publish` tinyint(1) NOT NULL DEFAULT 0,
811 INDEX `hometown` (`hometown`)
812 ) DEFAULT CHARSET=utf8;
815 -- TABLE profile_check
817 CREATE TABLE IF NOT EXISTS `profile_check` (
818 `id` int(10) unsigned NOT NULL auto_increment,
819 `uid` int(10) unsigned NOT NULL DEFAULT 0,
820 `cid` int(10) unsigned NOT NULL DEFAULT 0,
821 `dfrn_id` varchar(255) NOT NULL DEFAULT '',
822 `sec` varchar(255) NOT NULL DEFAULT '',
823 `expire` int(11) NOT NULL DEFAULT 0,
825 ) DEFAULT CHARSET=utf8;
828 -- TABLE push_subscriber
830 CREATE TABLE IF NOT EXISTS `push_subscriber` (
831 `id` int(11) NOT NULL auto_increment,
832 `uid` int(11) NOT NULL DEFAULT 0,
833 `callback_url` varchar(255) NOT NULL DEFAULT '',
834 `topic` varchar(255) NOT NULL DEFAULT '',
835 `nickname` varchar(255) NOT NULL DEFAULT '',
836 `push` int(11) NOT NULL DEFAULT 0,
837 `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
838 `secret` varchar(255) NOT NULL DEFAULT '',
840 ) DEFAULT CHARSET=utf8;
845 CREATE TABLE IF NOT EXISTS `queue` (
846 `id` int(11) NOT NULL auto_increment,
847 `cid` int(11) NOT NULL DEFAULT 0,
848 `network` varchar(32) NOT NULL DEFAULT '',
849 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
850 `last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
851 `content` mediumtext NOT NULL,
852 `batch` tinyint(1) NOT NULL DEFAULT 0,
855 INDEX `created` (`created`),
856 INDEX `last` (`last`),
857 INDEX `network` (`network`),
858 INDEX `batch` (`batch`)
859 ) DEFAULT CHARSET=utf8;
864 CREATE TABLE IF NOT EXISTS `register` (
865 `id` int(11) unsigned NOT NULL auto_increment,
866 `hash` varchar(255) NOT NULL DEFAULT '',
867 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
868 `uid` int(11) unsigned NOT NULL DEFAULT 0,
869 `password` varchar(255) NOT NULL DEFAULT '',
870 `language` varchar(16) NOT NULL DEFAULT '',
872 ) DEFAULT CHARSET=utf8;
877 CREATE TABLE IF NOT EXISTS `search` (
878 `id` int(11) NOT NULL auto_increment,
879 `uid` int(11) NOT NULL DEFAULT 0,
880 `term` varchar(255) NOT NULL DEFAULT '',
883 INDEX `term` (`term`)
884 ) DEFAULT CHARSET=utf8;
889 CREATE TABLE IF NOT EXISTS `session` (
890 `id` bigint(20) unsigned NOT NULL auto_increment,
891 `sid` varchar(255) NOT NULL DEFAULT '',
892 `data` text NOT NULL,
893 `expire` int(10) unsigned NOT NULL DEFAULT 0,
896 INDEX `expire` (`expire`)
897 ) DEFAULT CHARSET=utf8;
902 CREATE TABLE IF NOT EXISTS `sign` (
903 `id` int(10) unsigned NOT NULL auto_increment,
904 `iid` int(10) unsigned NOT NULL DEFAULT 0,
905 `retract_iid` int(10) unsigned NOT NULL DEFAULT 0,
906 `signed_text` mediumtext NOT NULL,
907 `signature` text NOT NULL,
908 `signer` varchar(255) NOT NULL DEFAULT '',
911 INDEX `retract_iid` (`retract_iid`)
912 ) DEFAULT CHARSET=utf8;
917 CREATE TABLE IF NOT EXISTS `spam` (
918 `id` int(11) NOT NULL auto_increment,
919 `uid` int(11) NOT NULL DEFAULT 0,
920 `spam` int(11) NOT NULL DEFAULT 0,
921 `ham` int(11) NOT NULL DEFAULT 0,
922 `term` varchar(255) NOT NULL DEFAULT '',
923 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
926 INDEX `spam` (`spam`),
928 INDEX `term` (`term`)
929 ) DEFAULT CHARSET=utf8;
934 CREATE TABLE IF NOT EXISTS `term` (
935 `tid` int(10) unsigned NOT NULL auto_increment,
936 `oid` int(10) unsigned NOT NULL DEFAULT 0,
937 `otype` tinyint(3) unsigned NOT NULL DEFAULT 0,
938 `type` tinyint(3) unsigned NOT NULL DEFAULT 0,
939 `term` varchar(255) NOT NULL DEFAULT '',
940 `url` varchar(255) NOT NULL DEFAULT '',
941 `guid` varchar(255) NOT NULL DEFAULT '',
942 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
943 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
944 `global` tinyint(1) NOT NULL DEFAULT 0,
945 `aid` int(10) unsigned NOT NULL DEFAULT 0,
946 `uid` int(10) unsigned NOT NULL DEFAULT 0,
948 INDEX `oid_otype_type_term` (`oid`,`otype`,`type`,`term`),
949 INDEX `uid_term_tid` (`uid`,`term`,`tid`),
950 INDEX `type_term` (`type`,`term`),
951 INDEX `uid_otype_type_term_global_created` (`uid`,`otype`,`type`,`term`,`global`,`created`),
952 INDEX `otype_type_term_tid` (`otype`,`type`,`term`,`tid`),
953 INDEX `guid` (`guid`)
954 ) DEFAULT CHARSET=utf8;
959 CREATE TABLE IF NOT EXISTS `thread` (
960 `iid` int(10) unsigned NOT NULL DEFAULT 0,
961 `uid` int(10) unsigned NOT NULL DEFAULT 0,
962 `contact-id` int(11) unsigned NOT NULL DEFAULT 0,
963 `gcontact-id` int(11) unsigned NOT NULL DEFAULT 0,
964 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
965 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
966 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
967 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
968 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
969 `wall` tinyint(1) NOT NULL DEFAULT 0,
970 `private` tinyint(1) NOT NULL DEFAULT 0,
971 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
972 `moderated` tinyint(1) NOT NULL DEFAULT 0,
973 `visible` tinyint(1) NOT NULL DEFAULT 0,
974 `spam` tinyint(1) NOT NULL DEFAULT 0,
975 `starred` tinyint(1) NOT NULL DEFAULT 0,
976 `ignored` tinyint(1) NOT NULL DEFAULT 0,
977 `bookmark` tinyint(1) NOT NULL DEFAULT 0,
978 `unseen` tinyint(1) NOT NULL DEFAULT 1,
979 `deleted` tinyint(1) NOT NULL DEFAULT 0,
980 `origin` tinyint(1) NOT NULL DEFAULT 0,
981 `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
982 `mention` tinyint(1) NOT NULL DEFAULT 0,
983 `network` varchar(32) NOT NULL DEFAULT '',
985 INDEX `created` (`created`),
986 INDEX `commented` (`commented`),
987 INDEX `uid_network_commented` (`uid`,`network`,`commented`),
988 INDEX `uid_network_created` (`uid`,`network`,`created`),
989 INDEX `uid_contactid_commented` (`uid`,`contact-id`,`commented`),
990 INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
991 INDEX `uid_gcontactid_commented` (`uid`,`gcontact-id`,`commented`),
992 INDEX `uid_gcontactid_created` (`uid`,`gcontact-id`,`created`),
993 INDEX `wall_private_received` (`wall`,`private`,`received`),
994 INDEX `uid_created` (`uid`,`created`),
995 INDEX `uid_commented` (`uid`,`commented`)
996 ) DEFAULT CHARSET=utf8;
1001 CREATE TABLE IF NOT EXISTS `tokens` (
1002 `id` varchar(40) NOT NULL,
1003 `secret` text NOT NULL,
1004 `client_id` varchar(20) NOT NULL DEFAULT '',
1005 `expires` int(11) NOT NULL DEFAULT 0,
1006 `scope` varchar(200) NOT NULL DEFAULT '',
1007 `uid` int(11) NOT NULL DEFAULT 0,
1009 ) DEFAULT CHARSET=utf8;
1014 CREATE TABLE IF NOT EXISTS `user` (
1015 `uid` int(11) NOT NULL auto_increment,
1016 `guid` varchar(64) NOT NULL DEFAULT '',
1017 `username` varchar(255) NOT NULL DEFAULT '',
1018 `password` varchar(255) NOT NULL DEFAULT '',
1019 `nickname` varchar(255) NOT NULL DEFAULT '',
1020 `email` varchar(255) NOT NULL DEFAULT '',
1021 `openid` varchar(255) NOT NULL DEFAULT '',
1022 `timezone` varchar(128) NOT NULL DEFAULT '',
1023 `language` varchar(32) NOT NULL DEFAULT 'en',
1024 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1025 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1026 `default-location` varchar(255) NOT NULL DEFAULT '',
1027 `allow_location` tinyint(1) NOT NULL DEFAULT 0,
1028 `theme` varchar(255) NOT NULL DEFAULT '',
1029 `pubkey` text NOT NULL,
1030 `prvkey` text NOT NULL,
1031 `spubkey` text NOT NULL,
1032 `sprvkey` text NOT NULL,
1033 `verified` tinyint(1) unsigned NOT NULL DEFAULT 0,
1034 `blocked` tinyint(1) unsigned NOT NULL DEFAULT 0,
1035 `blockwall` tinyint(1) unsigned NOT NULL DEFAULT 0,
1036 `hidewall` tinyint(1) unsigned NOT NULL DEFAULT 0,
1037 `blocktags` tinyint(1) unsigned NOT NULL DEFAULT 0,
1038 `unkmail` tinyint(1) NOT NULL DEFAULT 0,
1039 `cntunkmail` int(11) NOT NULL DEFAULT 10,
1040 `notify-flags` int(11) unsigned NOT NULL DEFAULT 65535,
1041 `page-flags` int(11) unsigned NOT NULL DEFAULT 0,
1042 `prvnets` tinyint(1) NOT NULL DEFAULT 0,
1043 `pwdreset` varchar(255) NOT NULL DEFAULT '',
1044 `maxreq` int(11) NOT NULL DEFAULT 10,
1045 `expire` int(11) unsigned NOT NULL DEFAULT 0,
1046 `account_removed` tinyint(1) NOT NULL DEFAULT 0,
1047 `account_expired` tinyint(1) NOT NULL DEFAULT 0,
1048 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1049 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1050 `service_class` varchar(32) NOT NULL DEFAULT '',
1051 `def_gid` int(11) NOT NULL DEFAULT 0,
1052 `allow_cid` mediumtext NOT NULL,
1053 `allow_gid` mediumtext NOT NULL,
1054 `deny_cid` mediumtext NOT NULL,
1055 `deny_gid` mediumtext NOT NULL,
1056 `openidserver` text NOT NULL,
1058 INDEX `nickname` (`nickname`)
1059 ) DEFAULT CHARSET=utf8;
1064 CREATE TABLE IF NOT EXISTS `userd` (
1065 `id` int(11) NOT NULL auto_increment,
1066 `username` varchar(255) NOT NULL,
1068 INDEX `username` (`username`)
1069 ) DEFAULT CHARSET=utf8;
1072 -- TABLE workerqueue
1074 CREATE TABLE IF NOT EXISTS `workerqueue` (
1075 `id` int(11) NOT NULL auto_increment,
1076 `parameter` text NOT NULL,
1077 `priority` tinyint(3) unsigned NOT NULL DEFAULT 0,
1078 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1079 `pid` int(11) NOT NULL DEFAULT 0,
1080 `executed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1082 INDEX `created` (`created`)
1083 ) DEFAULT CHARSET=utf8;