1 -- ------------------------------------------
2 -- Friendica 3.4.1 (Lily of the valley)
3 -- DB_UPDATE_VERSION 1188
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 `generation` tinyint(3) NOT NULL DEFAULT 0,
321 `server_url` varchar(255) NOT NULL DEFAULT '',
322 INDEX `nurl` (`nurl`),
323 INDEX `updated` (`updated`)
324 ) DEFAULT CHARSET=utf8;
329 CREATE TABLE IF NOT EXISTS `glink` (
330 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
331 `cid` int(11) NOT NULL DEFAULT 0,
332 `uid` int(11) NOT NULL DEFAULT 0,
333 `gcid` int(11) NOT NULL DEFAULT 0,
334 `zcid` int(11) NOT NULL DEFAULT 0,
335 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
336 INDEX `cid_uid_gcid_zcid` (`cid`,`uid`,`gcid`,`zcid`),
337 INDEX `gcid` (`gcid`),
338 INDEX `zcid` (`zcid`)
339 ) DEFAULT CHARSET=utf8;
344 CREATE TABLE IF NOT EXISTS `group` (
345 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
346 `uid` int(10) unsigned NOT NULL DEFAULT 0,
347 `visible` tinyint(1) NOT NULL DEFAULT 0,
348 `deleted` tinyint(1) NOT NULL DEFAULT 0,
349 `name` varchar(255) NOT NULL DEFAULT '',
351 ) DEFAULT CHARSET=utf8;
354 -- TABLE group_member
356 CREATE TABLE IF NOT EXISTS `group_member` (
357 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
358 `uid` int(10) unsigned NOT NULL DEFAULT 0,
359 `gid` int(10) unsigned NOT NULL DEFAULT 0,
360 `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
361 INDEX `uid_gid_contactid` (`uid`,`gid`,`contact-id`)
362 ) DEFAULT CHARSET=utf8;
367 CREATE TABLE IF NOT EXISTS `gserver` (
368 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
369 `url` varchar(255) NOT NULL DEFAULT '',
370 `nurl` varchar(255) NOT NULL DEFAULT '',
371 `version` varchar(255) NOT NULL DEFAULT '',
372 `site_name` varchar(255) NOT NULL DEFAULT '',
373 `info` text NOT NULL,
374 `register_policy` tinyint(1) NOT NULL DEFAULT 0,
375 `poco` varchar(255) NOT NULL DEFAULT '',
376 `noscrape` varchar(255) NOT NULL DEFAULT '',
377 `network` varchar(32) NOT NULL DEFAULT '',
378 `platform` varchar(255) NOT NULL DEFAULT '',
379 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
380 `last_poco_query` datetime DEFAULT '0000-00-00 00:00:00',
381 `last_contact` datetime DEFAULT '0000-00-00 00:00:00',
382 `last_failure` datetime DEFAULT '0000-00-00 00:00:00',
383 INDEX `nurl` (`nurl`)
384 ) DEFAULT CHARSET=utf8;
389 CREATE TABLE IF NOT EXISTS `guid` (
390 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
391 `guid` varchar(255) NOT NULL DEFAULT '',
392 `plink` varchar(255) NOT NULL DEFAULT '',
393 `uri` varchar(255) NOT NULL DEFAULT '',
394 `network` varchar(32) NOT NULL DEFAULT '',
395 INDEX `guid` (`guid`),
396 INDEX `plink` (`plink`),
398 ) DEFAULT CHARSET=utf8;
403 CREATE TABLE IF NOT EXISTS `hook` (
404 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
405 `hook` varchar(255) NOT NULL DEFAULT '',
406 `file` varchar(255) NOT NULL DEFAULT '',
407 `function` varchar(255) NOT NULL DEFAULT '',
408 `priority` int(11) unsigned NOT NULL DEFAULT 0,
409 INDEX `hook_file_function` (`hook`(30),`file`(60),`function`(30))
410 ) DEFAULT CHARSET=utf8;
415 CREATE TABLE IF NOT EXISTS `intro` (
416 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
417 `uid` int(10) unsigned NOT NULL DEFAULT 0,
418 `fid` int(11) NOT NULL DEFAULT 0,
419 `contact-id` int(11) NOT NULL DEFAULT 0,
420 `knowyou` tinyint(1) NOT NULL DEFAULT 0,
421 `duplex` tinyint(1) NOT NULL DEFAULT 0,
422 `note` text NOT NULL,
423 `hash` varchar(255) NOT NULL DEFAULT '',
424 `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
425 `blocked` tinyint(1) NOT NULL DEFAULT 1,
426 `ignore` tinyint(1) NOT NULL DEFAULT 0
427 ) DEFAULT CHARSET=utf8;
432 CREATE TABLE IF NOT EXISTS `item` (
433 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
434 `guid` varchar(255) NOT NULL DEFAULT '',
435 `uri` varchar(255) NOT NULL DEFAULT '',
436 `uid` int(10) unsigned NOT NULL DEFAULT 0,
437 `contact-id` int(11) NOT NULL DEFAULT 0,
438 `type` varchar(255) NOT NULL DEFAULT '',
439 `wall` tinyint(1) NOT NULL DEFAULT 0,
440 `gravity` tinyint(1) NOT NULL DEFAULT 0,
441 `parent` int(10) unsigned NOT NULL DEFAULT 0,
442 `parent-uri` varchar(255) NOT NULL DEFAULT '',
443 `extid` varchar(255) NOT NULL DEFAULT '',
444 `thr-parent` varchar(255) NOT NULL DEFAULT '',
445 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
446 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
447 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
448 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
449 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
450 `owner-name` varchar(255) NOT NULL DEFAULT '',
451 `owner-link` varchar(255) NOT NULL DEFAULT '',
452 `owner-avatar` varchar(255) NOT NULL DEFAULT '',
453 `author-name` varchar(255) NOT NULL DEFAULT '',
454 `author-link` varchar(255) NOT NULL DEFAULT '',
455 `author-avatar` varchar(255) NOT NULL DEFAULT '',
456 `title` varchar(255) NOT NULL DEFAULT '',
457 `body` mediumtext NOT NULL,
458 `app` varchar(255) NOT NULL DEFAULT '',
459 `verb` varchar(255) NOT NULL DEFAULT '',
460 `object-type` varchar(255) NOT NULL DEFAULT '',
461 `object` text NOT NULL,
462 `target-type` varchar(255) NOT NULL DEFAULT '',
463 `target` text NOT NULL,
464 `postopts` text NOT NULL,
465 `plink` varchar(255) NOT NULL DEFAULT '',
466 `resource-id` varchar(255) NOT NULL DEFAULT '',
467 `event-id` int(11) NOT NULL DEFAULT 0,
468 `tag` mediumtext NOT NULL,
469 `attach` mediumtext NOT NULL,
470 `inform` mediumtext NOT NULL,
471 `file` mediumtext NOT NULL,
472 `location` varchar(255) NOT NULL DEFAULT '',
473 `coord` varchar(255) NOT NULL DEFAULT '',
474 `allow_cid` mediumtext NOT NULL,
475 `allow_gid` mediumtext NOT NULL,
476 `deny_cid` mediumtext NOT NULL,
477 `deny_gid` mediumtext NOT NULL,
478 `private` tinyint(1) NOT NULL DEFAULT 0,
479 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
480 `moderated` tinyint(1) NOT NULL DEFAULT 0,
481 `visible` tinyint(1) NOT NULL DEFAULT 0,
482 `spam` tinyint(1) NOT NULL DEFAULT 0,
483 `starred` tinyint(1) NOT NULL DEFAULT 0,
484 `bookmark` tinyint(1) NOT NULL DEFAULT 0,
485 `unseen` tinyint(1) NOT NULL DEFAULT 1,
486 `deleted` tinyint(1) NOT NULL DEFAULT 0,
487 `origin` tinyint(1) NOT NULL DEFAULT 0,
488 `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
489 `last-child` tinyint(1) unsigned NOT NULL DEFAULT 1,
490 `mention` tinyint(1) NOT NULL DEFAULT 0,
491 `network` varchar(32) NOT NULL DEFAULT '',
492 `rendered-hash` varchar(32) NOT NULL DEFAULT '',
493 `rendered-html` mediumtext NOT NULL,
494 `global` tinyint(1) NOT NULL DEFAULT 0,
495 INDEX `guid` (`guid`),
497 INDEX `parent` (`parent`),
498 INDEX `parent-uri` (`parent-uri`),
499 INDEX `extid` (`extid`),
500 INDEX `uid_id` (`uid`,`id`),
501 INDEX `uid_created` (`uid`,`created`),
502 INDEX `uid_unseen` (`uid`,`unseen`),
503 INDEX `uid_network_received` (`uid`,`network`,`received`),
504 INDEX `uid_received` (`uid`,`received`),
505 INDEX `uid_network_commented` (`uid`,`network`,`commented`),
506 INDEX `uid_commented` (`uid`,`commented`),
507 INDEX `uid_title` (`uid`,`title`),
508 INDEX `uid_thrparent` (`uid`,`thr-parent`),
509 INDEX `uid_parenturi` (`uid`,`parent-uri`),
510 INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
511 INDEX `wall_body` (`wall`,`body`(6)),
512 INDEX `uid_visible_moderated_created` (`uid`,`visible`,`moderated`,`created`),
513 INDEX `uid_uri` (`uid`,`uri`),
514 INDEX `uid_wall_created` (`uid`,`wall`,`created`),
515 INDEX `resource-id` (`resource-id`),
516 INDEX `uid_type` (`uid`,`type`),
517 INDEX `uid_starred` (`uid`,`starred`),
518 INDEX `contactid_allowcid_allowpid_denycid_denygid` (`contact-id`,`allow_cid`(10),`allow_gid`(10),`deny_cid`(10),`deny_gid`(10)),
519 INDEX `uid_wall_parent_created` (`uid`,`wall`,`parent`,`created`),
520 INDEX `uid_type_changed` (`uid`,`type`,`changed`),
521 INDEX `contactid_verb` (`contact-id`,`verb`),
522 INDEX `deleted_changed` (`deleted`,`changed`),
523 INDEX `uid_wall_changed` (`uid`,`wall`,`changed`),
524 INDEX `uid_eventid` (`uid`,`event-id`),
525 INDEX `uid_authorlink` (`uid`,`author-link`),
526 INDEX `uid_ownerlink` (`uid`,`owner-link`)
527 ) DEFAULT CHARSET=utf8;
532 CREATE TABLE IF NOT EXISTS `item_id` (
533 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
534 `iid` int(11) NOT NULL DEFAULT 0,
535 `uid` int(11) NOT NULL DEFAULT 0,
536 `sid` varchar(255) NOT NULL DEFAULT '',
537 `service` varchar(255) NOT NULL DEFAULT '',
540 INDEX `service` (`service`),
542 ) DEFAULT CHARSET=utf8;
547 CREATE TABLE IF NOT EXISTS `locks` (
548 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
549 `name` varchar(128) NOT NULL DEFAULT '',
550 `locked` tinyint(1) NOT NULL DEFAULT 0,
551 `created` datetime DEFAULT '0000-00-00 00:00:00'
552 ) DEFAULT CHARSET=utf8;
557 CREATE TABLE IF NOT EXISTS `mail` (
558 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
559 `uid` int(10) unsigned NOT NULL DEFAULT 0,
560 `guid` varchar(64) NOT NULL DEFAULT '',
561 `from-name` varchar(255) NOT NULL DEFAULT '',
562 `from-photo` varchar(255) NOT NULL DEFAULT '',
563 `from-url` varchar(255) NOT NULL DEFAULT '',
564 `contact-id` varchar(255) NOT NULL DEFAULT '',
565 `convid` int(11) unsigned NOT NULL DEFAULT 0,
566 `title` varchar(255) NOT NULL DEFAULT '',
567 `body` mediumtext NOT NULL,
568 `seen` tinyint(1) NOT NULL DEFAULT 0,
569 `reply` tinyint(1) NOT NULL DEFAULT 0,
570 `replied` tinyint(1) NOT NULL DEFAULT 0,
571 `unknown` tinyint(1) NOT NULL DEFAULT 0,
572 `uri` varchar(255) NOT NULL DEFAULT '',
573 `parent-uri` varchar(255) NOT NULL DEFAULT '',
574 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
576 INDEX `guid` (`guid`),
577 INDEX `convid` (`convid`),
578 INDEX `reply` (`reply`),
580 INDEX `parent-uri` (`parent-uri`)
581 ) DEFAULT CHARSET=utf8;
586 CREATE TABLE IF NOT EXISTS `mailacct` (
587 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
588 `uid` int(11) NOT NULL DEFAULT 0,
589 `server` varchar(255) NOT NULL DEFAULT '',
590 `port` int(11) NOT NULL DEFAULT 0,
591 `ssltype` varchar(16) NOT NULL DEFAULT '',
592 `mailbox` varchar(255) NOT NULL DEFAULT '',
593 `user` varchar(255) NOT NULL DEFAULT '',
594 `pass` text NOT NULL,
595 `reply_to` varchar(255) NOT NULL DEFAULT '',
596 `action` int(11) NOT NULL DEFAULT 0,
597 `movetofolder` varchar(255) NOT NULL DEFAULT '',
598 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
599 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
600 ) DEFAULT CHARSET=utf8;
605 CREATE TABLE IF NOT EXISTS `manage` (
606 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
607 `uid` int(11) NOT NULL DEFAULT 0,
608 `mid` int(11) NOT NULL DEFAULT 0,
609 INDEX `uid_mid` (`uid`,`mid`)
610 ) DEFAULT CHARSET=utf8;
615 CREATE TABLE IF NOT EXISTS `notify` (
616 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
617 `hash` varchar(64) NOT NULL DEFAULT '',
618 `type` int(11) NOT NULL DEFAULT 0,
619 `name` varchar(255) NOT NULL DEFAULT '',
620 `url` varchar(255) NOT NULL DEFAULT '',
621 `photo` varchar(255) NOT NULL DEFAULT '',
622 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
623 `msg` mediumtext NOT NULL,
624 `uid` int(11) NOT NULL DEFAULT 0,
625 `link` varchar(255) NOT NULL DEFAULT '',
626 `iid` int(11) NOT NULL DEFAULT 0,
627 `parent` int(11) NOT NULL DEFAULT 0,
628 `seen` tinyint(1) NOT NULL DEFAULT 0,
629 `verb` varchar(255) NOT NULL DEFAULT '',
630 `otype` varchar(16) NOT NULL DEFAULT '',
632 ) DEFAULT CHARSET=utf8;
635 -- TABLE notify-threads
637 CREATE TABLE IF NOT EXISTS `notify-threads` (
638 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
639 `notify-id` int(11) NOT NULL DEFAULT 0,
640 `master-parent-item` int(10) unsigned NOT NULL DEFAULT 0,
641 `parent-item` int(10) unsigned NOT NULL DEFAULT 0,
642 `receiver-uid` int(11) NOT NULL DEFAULT 0,
643 INDEX `master-parent-item` (`master-parent-item`),
644 INDEX `receiver-uid` (`receiver-uid`)
645 ) DEFAULT CHARSET=utf8;
650 CREATE TABLE IF NOT EXISTS `pconfig` (
651 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
652 `uid` int(11) NOT NULL DEFAULT 0,
653 `cat` varchar(255) NOT NULL DEFAULT '',
654 `k` varchar(255) NOT NULL DEFAULT '',
655 `v` mediumtext NOT NULL,
656 INDEX `uid_cat_k` (`uid`,`cat`(30),`k`(30))
657 ) DEFAULT CHARSET=utf8;
662 CREATE TABLE IF NOT EXISTS `photo` (
663 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
664 `uid` int(10) unsigned NOT NULL DEFAULT 0,
665 `contact-id` int(10) unsigned NOT NULL DEFAULT 0,
666 `guid` varchar(64) NOT NULL DEFAULT '',
667 `resource-id` varchar(255) NOT NULL DEFAULT '',
668 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
669 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
670 `title` varchar(255) NOT NULL DEFAULT '',
671 `desc` text NOT NULL,
672 `album` varchar(255) NOT NULL DEFAULT '',
673 `filename` varchar(255) NOT NULL DEFAULT '',
674 `type` varchar(128) NOT NULL DEFAULT 'image/jpeg',
675 `height` smallint(6) NOT NULL DEFAULT 0,
676 `width` smallint(6) NOT NULL DEFAULT 0,
677 `datasize` int(10) unsigned NOT NULL DEFAULT 0,
678 `data` mediumblob NOT NULL,
679 `scale` tinyint(3) NOT NULL DEFAULT 0,
680 `profile` tinyint(1) NOT NULL DEFAULT 0,
681 `allow_cid` mediumtext NOT NULL,
682 `allow_gid` mediumtext NOT NULL,
683 `deny_cid` mediumtext NOT NULL,
684 `deny_gid` mediumtext NOT NULL,
686 INDEX `resource-id` (`resource-id`),
687 INDEX `guid` (`guid`)
688 ) DEFAULT CHARSET=utf8;
693 CREATE TABLE IF NOT EXISTS `poll` (
694 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
695 `uid` int(11) NOT NULL DEFAULT 0,
696 `q0` mediumtext NOT NULL,
697 `q1` mediumtext NOT NULL,
698 `q2` mediumtext NOT NULL,
699 `q3` mediumtext NOT NULL,
700 `q4` mediumtext NOT NULL,
701 `q5` mediumtext NOT NULL,
702 `q6` mediumtext NOT NULL,
703 `q7` mediumtext NOT NULL,
704 `q8` mediumtext NOT NULL,
705 `q9` mediumtext NOT NULL,
707 ) DEFAULT CHARSET=utf8;
712 CREATE TABLE IF NOT EXISTS `poll_result` (
713 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
714 `poll_id` int(11) NOT NULL DEFAULT 0,
715 `choice` int(11) NOT NULL DEFAULT 0,
716 INDEX `poll_id` (`poll_id`),
717 INDEX `choice` (`choice`)
718 ) DEFAULT CHARSET=utf8;
723 CREATE TABLE IF NOT EXISTS `profile` (
724 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
725 `uid` int(11) NOT NULL DEFAULT 0,
726 `profile-name` varchar(255) NOT NULL DEFAULT '',
727 `is-default` tinyint(1) NOT NULL DEFAULT 0,
728 `hide-friends` tinyint(1) NOT NULL DEFAULT 0,
729 `name` varchar(255) NOT NULL DEFAULT '',
730 `pdesc` varchar(255) NOT NULL DEFAULT '',
731 `dob` varchar(32) NOT NULL DEFAULT '0000-00-00',
732 `address` varchar(255) NOT NULL DEFAULT '',
733 `locality` varchar(255) NOT NULL DEFAULT '',
734 `region` varchar(255) NOT NULL DEFAULT '',
735 `postal-code` varchar(32) NOT NULL DEFAULT '',
736 `country-name` varchar(255) NOT NULL DEFAULT '',
737 `hometown` varchar(255) NOT NULL DEFAULT '',
738 `gender` varchar(32) NOT NULL DEFAULT '',
739 `marital` varchar(255) NOT NULL DEFAULT '',
740 `with` text NOT NULL,
741 `howlong` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
742 `sexual` varchar(255) NOT NULL DEFAULT '',
743 `politic` varchar(255) NOT NULL DEFAULT '',
744 `religion` varchar(255) NOT NULL DEFAULT '',
745 `pub_keywords` text NOT NULL,
746 `prv_keywords` text NOT NULL,
747 `likes` text NOT NULL,
748 `dislikes` text NOT NULL,
749 `about` text NOT NULL,
750 `summary` varchar(255) NOT NULL DEFAULT '',
751 `music` text NOT NULL,
752 `book` text NOT NULL,
754 `film` text NOT NULL,
755 `interest` text NOT NULL,
756 `romance` text NOT NULL,
757 `work` text NOT NULL,
758 `education` text NOT NULL,
759 `contact` text NOT NULL,
760 `homepage` varchar(255) NOT NULL DEFAULT '',
761 `photo` varchar(255) NOT NULL DEFAULT '',
762 `thumb` varchar(255) NOT NULL DEFAULT '',
763 `publish` tinyint(1) NOT NULL DEFAULT 0,
764 `net-publish` tinyint(1) NOT NULL DEFAULT 0,
765 INDEX `hometown` (`hometown`)
766 ) DEFAULT CHARSET=utf8;
769 -- TABLE profile_check
771 CREATE TABLE IF NOT EXISTS `profile_check` (
772 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
773 `uid` int(10) unsigned NOT NULL DEFAULT 0,
774 `cid` int(10) unsigned NOT NULL DEFAULT 0,
775 `dfrn_id` varchar(255) NOT NULL DEFAULT '',
776 `sec` varchar(255) NOT NULL DEFAULT '',
777 `expire` int(11) NOT NULL DEFAULT 0
778 ) DEFAULT CHARSET=utf8;
781 -- TABLE push_subscriber
783 CREATE TABLE IF NOT EXISTS `push_subscriber` (
784 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
785 `uid` int(11) NOT NULL DEFAULT 0,
786 `callback_url` varchar(255) NOT NULL DEFAULT '',
787 `topic` varchar(255) NOT NULL DEFAULT '',
788 `nickname` varchar(255) NOT NULL DEFAULT '',
789 `push` int(11) NOT NULL DEFAULT 0,
790 `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
791 `secret` varchar(255) NOT NULL DEFAULT ''
792 ) DEFAULT CHARSET=utf8;
797 CREATE TABLE IF NOT EXISTS `queue` (
798 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
799 `cid` int(11) NOT NULL DEFAULT 0,
800 `network` varchar(32) NOT NULL DEFAULT '',
801 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
802 `last` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
803 `content` mediumtext NOT NULL,
804 `batch` tinyint(1) NOT NULL DEFAULT 0,
806 INDEX `created` (`created`),
807 INDEX `last` (`last`),
808 INDEX `network` (`network`),
809 INDEX `batch` (`batch`)
810 ) DEFAULT CHARSET=utf8;
815 CREATE TABLE IF NOT EXISTS `register` (
816 `id` int(11) unsigned NOT NULL auto_increment PRIMARY KEY,
817 `hash` varchar(255) NOT NULL DEFAULT '',
818 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
819 `uid` int(11) unsigned NOT NULL DEFAULT 0,
820 `password` varchar(255) NOT NULL DEFAULT '',
821 `language` varchar(16) NOT NULL DEFAULT ''
822 ) DEFAULT CHARSET=utf8;
827 CREATE TABLE IF NOT EXISTS `search` (
828 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
829 `uid` int(11) NOT NULL DEFAULT 0,
830 `term` varchar(255) NOT NULL DEFAULT '',
832 INDEX `term` (`term`)
833 ) DEFAULT CHARSET=utf8;
838 CREATE TABLE IF NOT EXISTS `session` (
839 `id` bigint(20) unsigned NOT NULL auto_increment PRIMARY KEY,
840 `sid` varchar(255) NOT NULL DEFAULT '',
841 `data` text NOT NULL,
842 `expire` int(10) unsigned NOT NULL DEFAULT 0,
844 INDEX `expire` (`expire`)
845 ) DEFAULT CHARSET=utf8;
850 CREATE TABLE IF NOT EXISTS `sign` (
851 `id` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
852 `iid` int(10) unsigned NOT NULL DEFAULT 0,
853 `retract_iid` int(10) unsigned NOT NULL DEFAULT 0,
854 `signed_text` mediumtext NOT NULL,
855 `signature` text NOT NULL,
856 `signer` varchar(255) NOT NULL DEFAULT '',
858 INDEX `retract_iid` (`retract_iid`)
859 ) DEFAULT CHARSET=utf8;
864 CREATE TABLE IF NOT EXISTS `spam` (
865 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
866 `uid` int(11) NOT NULL DEFAULT 0,
867 `spam` int(11) NOT NULL DEFAULT 0,
868 `ham` int(11) NOT NULL DEFAULT 0,
869 `term` varchar(255) NOT NULL DEFAULT '',
870 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
872 INDEX `spam` (`spam`),
874 INDEX `term` (`term`)
875 ) DEFAULT CHARSET=utf8;
880 CREATE TABLE IF NOT EXISTS `term` (
881 `tid` int(10) unsigned NOT NULL auto_increment PRIMARY KEY,
882 `oid` int(10) unsigned NOT NULL DEFAULT 0,
883 `otype` tinyint(3) unsigned NOT NULL DEFAULT 0,
884 `type` tinyint(3) unsigned NOT NULL DEFAULT 0,
885 `term` varchar(255) NOT NULL DEFAULT '',
886 `url` varchar(255) NOT NULL DEFAULT '',
887 `guid` varchar(255) NOT NULL DEFAULT '',
888 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
889 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
890 `global` tinyint(1) NOT NULL DEFAULT 0,
891 `aid` int(10) unsigned NOT NULL DEFAULT 0,
892 `uid` int(10) unsigned NOT NULL DEFAULT 0,
893 INDEX `oid_otype_type_term` (`oid`,`otype`,`type`,`term`),
894 INDEX `uid_term_tid` (`uid`,`term`,`tid`),
895 INDEX `type_term` (`type`,`term`),
896 INDEX `uid_otype_type_term_global_created` (`uid`,`otype`,`type`,`term`,`global`,`created`),
897 INDEX `otype_type_term_tid` (`otype`,`type`,`term`,`tid`),
898 INDEX `guid` (`guid`)
899 ) DEFAULT CHARSET=utf8;
904 CREATE TABLE IF NOT EXISTS `thread` (
905 `iid` int(10) unsigned NOT NULL DEFAULT 0 PRIMARY KEY,
906 `uid` int(10) unsigned NOT NULL DEFAULT 0,
907 `contact-id` int(11) unsigned NOT NULL DEFAULT 0,
908 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
909 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
910 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
911 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
912 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
913 `wall` tinyint(1) NOT NULL DEFAULT 0,
914 `private` tinyint(1) NOT NULL DEFAULT 0,
915 `pubmail` tinyint(1) NOT NULL DEFAULT 0,
916 `moderated` tinyint(1) NOT NULL DEFAULT 0,
917 `visible` tinyint(1) NOT NULL DEFAULT 0,
918 `spam` tinyint(1) NOT NULL DEFAULT 0,
919 `starred` tinyint(1) NOT NULL DEFAULT 0,
920 `ignored` tinyint(1) NOT NULL DEFAULT 0,
921 `bookmark` tinyint(1) NOT NULL DEFAULT 0,
922 `unseen` tinyint(1) NOT NULL DEFAULT 1,
923 `deleted` tinyint(1) NOT NULL DEFAULT 0,
924 `origin` tinyint(1) NOT NULL DEFAULT 0,
925 `forum_mode` tinyint(1) NOT NULL DEFAULT 0,
926 `mention` tinyint(1) NOT NULL DEFAULT 0,
927 `network` varchar(32) NOT NULL DEFAULT '',
928 INDEX `created` (`created`),
929 INDEX `commented` (`commented`),
930 INDEX `uid_network_commented` (`uid`,`network`,`commented`),
931 INDEX `uid_network_created` (`uid`,`network`,`created`),
932 INDEX `uid_contactid_commented` (`uid`,`contact-id`,`commented`),
933 INDEX `uid_contactid_created` (`uid`,`contact-id`,`created`),
934 INDEX `wall_private_received` (`wall`,`private`,`received`),
935 INDEX `uid_created` (`uid`,`created`),
936 INDEX `uid_commented` (`uid`,`commented`)
937 ) DEFAULT CHARSET=utf8;
942 CREATE TABLE IF NOT EXISTS `tokens` (
943 `id` varchar(40) NOT NULL PRIMARY KEY,
944 `secret` text NOT NULL,
945 `client_id` varchar(20) NOT NULL DEFAULT '',
946 `expires` int(11) NOT NULL DEFAULT 0,
947 `scope` varchar(200) NOT NULL DEFAULT '',
948 `uid` int(11) NOT NULL DEFAULT 0
949 ) DEFAULT CHARSET=utf8;
952 -- TABLE unique_contacts
954 CREATE TABLE IF NOT EXISTS `unique_contacts` (
955 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
956 `url` varchar(255) NOT NULL DEFAULT '',
957 `nick` varchar(255) NOT NULL DEFAULT '',
958 `name` varchar(255) NOT NULL DEFAULT '',
959 `avatar` varchar(255) NOT NULL DEFAULT '',
960 `location` varchar(255) NOT NULL DEFAULT '',
961 `about` text NOT NULL,
963 ) DEFAULT CHARSET=utf8;
968 CREATE TABLE IF NOT EXISTS `user` (
969 `uid` int(11) NOT NULL auto_increment PRIMARY KEY,
970 `guid` varchar(64) NOT NULL DEFAULT '',
971 `username` varchar(255) NOT NULL DEFAULT '',
972 `password` varchar(255) NOT NULL DEFAULT '',
973 `nickname` varchar(255) NOT NULL DEFAULT '',
974 `email` varchar(255) NOT NULL DEFAULT '',
975 `openid` varchar(255) NOT NULL DEFAULT '',
976 `timezone` varchar(128) NOT NULL DEFAULT '',
977 `language` varchar(32) NOT NULL DEFAULT 'en',
978 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
979 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
980 `default-location` varchar(255) NOT NULL DEFAULT '',
981 `allow_location` tinyint(1) NOT NULL DEFAULT 0,
982 `theme` varchar(255) NOT NULL DEFAULT '',
983 `pubkey` text NOT NULL,
984 `prvkey` text NOT NULL,
985 `spubkey` text NOT NULL,
986 `sprvkey` text NOT NULL,
987 `verified` tinyint(1) unsigned NOT NULL DEFAULT 0,
988 `blocked` tinyint(1) unsigned NOT NULL DEFAULT 0,
989 `blockwall` tinyint(1) unsigned NOT NULL DEFAULT 0,
990 `hidewall` tinyint(1) unsigned NOT NULL DEFAULT 0,
991 `blocktags` tinyint(1) unsigned NOT NULL DEFAULT 0,
992 `unkmail` tinyint(1) NOT NULL DEFAULT 0,
993 `cntunkmail` int(11) NOT NULL DEFAULT 10,
994 `notify-flags` int(11) unsigned NOT NULL DEFAULT 65535,
995 `page-flags` int(11) unsigned NOT NULL DEFAULT 0,
996 `prvnets` tinyint(1) NOT NULL DEFAULT 0,
997 `pwdreset` varchar(255) NOT NULL DEFAULT '',
998 `maxreq` int(11) NOT NULL DEFAULT 10,
999 `expire` int(11) unsigned NOT NULL DEFAULT 0,
1000 `account_removed` tinyint(1) NOT NULL DEFAULT 0,
1001 `account_expired` tinyint(1) NOT NULL DEFAULT 0,
1002 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1003 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1004 `service_class` varchar(32) NOT NULL DEFAULT '',
1005 `def_gid` int(11) NOT NULL DEFAULT 0,
1006 `allow_cid` mediumtext NOT NULL,
1007 `allow_gid` mediumtext NOT NULL,
1008 `deny_cid` mediumtext NOT NULL,
1009 `deny_gid` mediumtext NOT NULL,
1010 `openidserver` text NOT NULL,
1011 INDEX `nickname` (`nickname`)
1012 ) DEFAULT CHARSET=utf8;
1017 CREATE TABLE IF NOT EXISTS `userd` (
1018 `id` int(11) NOT NULL auto_increment PRIMARY KEY,
1019 `username` varchar(255) NOT NULL,
1020 INDEX `username` (`username`)
1021 ) DEFAULT CHARSET=utf8;