3 -- http://www.phpmyadmin.net
6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
8 -- --------------------------------------------------------
11 -- Table structure for table `addon`
14 CREATE TABLE IF NOT EXISTS `addon` (
15 `id` int(11) NOT NULL AUTO_INCREMENT,
16 `name` char(255) NOT NULL,
17 `version` char(255) NOT NULL,
18 `installed` tinyint(1) NOT NULL DEFAULT '0',
19 `hidden` tinyint(1) NOT NULL DEFAULT '0',
20 `timestamp` bigint(20) NOT NULL DEFAULT '0',
21 `plugin_admin` tinyint(1) NOT NULL DEFAULT '0',
23 KEY `hidden` (`hidden`)
24 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
26 -- --------------------------------------------------------
29 -- Table structure for table `attach`
32 CREATE TABLE IF NOT EXISTS `attach` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `uid` int(11) NOT NULL,
35 `hash` char(64) NOT NULL,
36 `filename` char(255) NOT NULL,
37 `filetype` char(64) NOT NULL,
38 `filesize` int(11) NOT NULL,
39 `data` longblob NOT NULL,
40 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
41 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
42 `allow_cid` mediumtext NOT NULL,
43 `allow_gid` mediumtext NOT NULL,
44 `deny_cid` mediumtext NOT NULL,
45 `deny_gid` mediumtext NOT NULL,
47 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
49 -- --------------------------------------------------------
52 -- Table structure for table `auth_codes`
55 CREATE TABLE IF NOT EXISTS `auth_codes` (
56 `id` varchar(40) NOT NULL,
57 `client_id` varchar(20) NOT NULL,
58 `redirect_uri` varchar(200) NOT NULL,
59 `expires` int(11) NOT NULL,
60 `scope` varchar(250) NOT NULL,
62 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
64 -- --------------------------------------------------------
67 -- Table structure for table `cache`
70 CREATE TABLE IF NOT EXISTS `cache` (
71 `k` char(255) NOT NULL,
73 `updated` datetime NOT NULL,
75 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
77 -- --------------------------------------------------------
80 -- Table structure for table `challenge`
83 CREATE TABLE IF NOT EXISTS `challenge` (
84 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
85 `challenge` char(255) NOT NULL,
86 `dfrn-id` char(255) NOT NULL,
87 `expire` int(11) NOT NULL,
88 `type` char(255) NOT NULL,
89 `last_update` char(255) NOT NULL,
91 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
93 -- --------------------------------------------------------
96 -- Table structure for table `clients`
99 CREATE TABLE IF NOT EXISTS `clients` (
100 `client_id` varchar(20) NOT NULL,
101 `pw` varchar(20) NOT NULL,
102 `redirect_uri` varchar(200) NOT NULL,
105 `uid` int(11) NOT NULL DEFAULT '0',
106 PRIMARY KEY (`client_id`)
107 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
109 -- --------------------------------------------------------
112 -- Table structure for table `config`
115 CREATE TABLE IF NOT EXISTS `config` (
116 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
117 `cat` char(255) CHARACTER SET ascii NOT NULL,
118 `k` char(255) CHARACTER SET ascii NOT NULL,
121 UNIQUE KEY `access` (`cat`,`k`)
122 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
124 -- --------------------------------------------------------
127 -- Table structure for table `contact`
130 CREATE TABLE IF NOT EXISTS `contact` (
131 `id` int(11) NOT NULL AUTO_INCREMENT,
132 `uid` int(11) NOT NULL COMMENT 'owner uid',
133 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
134 `self` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'boolean 1 == info for local UID, primarily name and photo to use in item displays.',
135 `remote_self` tinyint(1) NOT NULL DEFAULT '0',
136 `rel` tinyint(1) NOT NULL DEFAULT '0',
137 `duplex` tinyint(1) NOT NULL DEFAULT '0',
138 `network` char(255) NOT NULL,
139 `name` char(255) NOT NULL,
140 `nick` char(255) NOT NULL,
141 `attag` char(255) NOT NULL,
142 `photo` text NOT NULL COMMENT 'remote photo URL initially until approved',
143 `thumb` text NOT NULL,
144 `micro` text NOT NULL,
145 `site-pubkey` text NOT NULL,
146 `issued-id` char(255) NOT NULL,
147 `dfrn-id` char(255) NOT NULL,
148 `url` char(255) NOT NULL,
149 `nurl` char(255) NOT NULL,
150 `addr` char(255) NOT NULL,
151 `alias` char(255) NOT NULL,
152 `pubkey` text NOT NULL,
153 `prvkey` text NOT NULL,
154 `batch` char(255) NOT NULL,
155 `request` text NOT NULL,
156 `notify` text NOT NULL,
157 `poll` text NOT NULL,
158 `confirm` text NOT NULL,
159 `poco` text NOT NULL,
160 `aes_allow` tinyint(1) NOT NULL DEFAULT '0',
161 `ret-aes` tinyint(1) NOT NULL DEFAULT '0',
162 `usehub` tinyint(1) NOT NULL DEFAULT '0',
163 `subhub` tinyint(1) NOT NULL DEFAULT '0',
164 `hub-verify` char(255) NOT NULL,
165 `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
166 `success_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
167 `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
168 `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
169 `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
170 `term-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
171 `priority` tinyint(3) NOT NULL,
172 `blocked` tinyint(1) NOT NULL DEFAULT '1',
173 `readonly` tinyint(1) NOT NULL DEFAULT '0',
174 `writable` tinyint(1) NOT NULL DEFAULT '0',
175 `forum` tinyint(1) NOT NULL DEFAULT '0',
176 `prv` tinyint(1) NOT NULL DEFAULT '0',
177 `hidden` tinyint(1) NOT NULL DEFAULT '0',
178 `archive` tinyint(1) NOT NULL DEFAULT '0',
179 `pending` tinyint(1) NOT NULL DEFAULT '1',
180 `rating` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-5 reputation, 0 unknown, 1 call police, 5 inscrutable',
181 `reason` text NOT NULL COMMENT 'why a rating was given - will help friends decide to make friends or not',
182 `closeness` tinyint(2) NOT NULL DEFAULT '99',
183 `info` mediumtext NOT NULL,
184 `profile-id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default',
185 `bdyear` char(4) NOT NULL COMMENT 'birthday notify flag',
190 KEY `issued-id` (`issued-id`),
191 KEY `dfrn-id` (`dfrn-id`),
192 KEY `blocked` (`blocked`),
193 KEY `readonly` (`readonly`),
194 KEY `network` (`network`),
197 KEY `attag` (`attag`),
200 KEY `batch` (`batch`),
202 KEY `pending` (`pending`),
203 KEY `hidden` (`hidden`),
204 KEY `archive` (`archive`),
205 KEY `forum` (`forum`)
206 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
208 -- --------------------------------------------------------
211 -- Table structure for table `conv`
214 CREATE TABLE IF NOT EXISTS `conv` (
215 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
216 `guid` char(64) NOT NULL,
217 `recips` mediumtext NOT NULL,
218 `uid` int(11) NOT NULL,
219 `creator` char(255) NOT NULL,
220 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
221 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
222 `subject` mediumtext NOT NULL,
224 KEY `created` (`created`),
225 KEY `updated` (`updated`)
226 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
228 -- --------------------------------------------------------
231 -- Table structure for table `deliverq`
234 CREATE TABLE IF NOT EXISTS `deliverq` (
235 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
236 `cmd` char(32) NOT NULL,
237 `item` int(11) NOT NULL,
238 `contact` int(11) NOT NULL,
240 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
242 -- --------------------------------------------------------
245 -- Table structure for table `dsprphotoq`
248 CREATE TABLE `dsprphotoq` (
249 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
250 `uid` int(11) NOT NULL,
251 `msg` mediumtext NOT NULL,
252 `attempt` tinyint(4) NOT NULL,
254 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
256 -- --------------------------------------------------------
259 -- Table structure for table `event`
262 CREATE TABLE IF NOT EXISTS `event` (
263 `id` int(11) NOT NULL AUTO_INCREMENT,
264 `uid` int(11) NOT NULL,
265 `cid` int(11) NOT NULL,
266 `uri` char(255) NOT NULL,
267 `created` datetime NOT NULL,
268 `edited` datetime NOT NULL,
269 `start` datetime NOT NULL,
270 `finish` datetime NOT NULL,
271 `summary` text NOT NULL,
272 `desc` text NOT NULL,
273 `location` text NOT NULL,
274 `type` char(255) NOT NULL,
275 `nofinish` tinyint(1) NOT NULL DEFAULT '0',
276 `adjust` tinyint(1) NOT NULL DEFAULT '1',
277 `ignore` tinyint(1) NOT NULL DEFAULT '0',
278 `allow_cid` mediumtext NOT NULL,
279 `allow_gid` mediumtext NOT NULL,
280 `deny_cid` mediumtext NOT NULL,
281 `deny_gid` mediumtext NOT NULL,
286 KEY `type` ( `type` ),
287 KEY `start` ( `start` ),
288 KEY `finish` ( `finish` ),
289 KEY `adjust` ( `adjust` ),
290 KEY `ignore` ( `ignore` )
291 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
293 -- --------------------------------------------------------
296 -- Table structure for table `fcontact`
299 CREATE TABLE IF NOT EXISTS `fcontact` (
300 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
301 `url` char(255) NOT NULL,
302 `name` char(255) NOT NULL,
303 `photo` char(255) NOT NULL,
304 `request` char(255) NOT NULL,
305 `nick` char(255) NOT NULL,
306 `addr` char(255) NOT NULL,
307 `batch` char(255) NOT NULL,
308 `notify` char(255) NOT NULL,
309 `poll` char(255) NOT NULL,
310 `confirm` char(255) NOT NULL,
311 `priority` tinyint(1) NOT NULL,
312 `network` char(32) NOT NULL,
313 `alias` char(255) NOT NULL,
314 `pubkey` text NOT NULL,
315 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
318 KEY `network` (`network`)
319 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
321 -- --------------------------------------------------------
324 -- Table structure for table `ffinder`
327 CREATE TABLE IF NOT EXISTS `ffinder` (
328 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
329 `uid` int(10) unsigned NOT NULL,
330 `cid` int(10) unsigned NOT NULL,
331 `fid` int(10) unsigned NOT NULL,
333 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
335 -- --------------------------------------------------------
338 -- Table structure for table `fserver`
341 CREATE TABLE IF NOT EXISTS `fserver` (
342 `id` int(11) NOT NULL AUTO_INCREMENT,
343 `server` char(255) NOT NULL,
344 `posturl` char(255) NOT NULL,
347 KEY `server` (`server`)
348 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
350 -- --------------------------------------------------------
353 -- Table structure for table `fsuggest`
356 CREATE TABLE IF NOT EXISTS `fsuggest` (
357 `id` int(11) NOT NULL AUTO_INCREMENT,
358 `uid` int(11) NOT NULL,
359 `cid` int(11) NOT NULL,
360 `name` char(255) NOT NULL,
361 `url` char(255) NOT NULL,
362 `request` char(255) NOT NULL,
363 `photo` char(255) NOT NULL,
364 `note` text NOT NULL,
365 `created` datetime NOT NULL,
367 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
369 -- --------------------------------------------------------
372 -- Table structure for table `gcign`
375 CREATE TABLE IF NOT EXISTS `gcign` (
376 `id` int(11) NOT NULL AUTO_INCREMENT,
377 `uid` int(11) NOT NULL,
378 `gcid` int(11) NOT NULL,
382 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
384 -- --------------------------------------------------------
387 -- Table structure for table `gcontact`
390 CREATE TABLE IF NOT EXISTS `gcontact` (
391 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
392 `name` char(255) NOT NULL,
393 `url` char(255) NOT NULL,
394 `nurl` char(255) NOT NULL,
395 `photo` char(255) NOT NULL,
396 `connect` char(255) NOT NULL,
399 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
401 -- --------------------------------------------------------
404 -- Table structure for table `glink`
407 CREATE TABLE IF NOT EXISTS `glink` (
408 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
409 `cid` int(11) NOT NULL,
410 `uid` int(11) NOT NULL,
411 `gcid` int(11) NOT NULL,
412 `zcid` int(11) NOT NULL,
413 `updated` datetime NOT NULL,
419 KEY `updated` (`updated`)
420 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
422 -- --------------------------------------------------------
425 -- Table structure for table `group`
428 CREATE TABLE IF NOT EXISTS `group` (
429 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
430 `uid` int(10) unsigned NOT NULL,
431 `visible` tinyint(1) NOT NULL DEFAULT '0',
432 `deleted` tinyint(1) NOT NULL DEFAULT '0',
433 `name` char(255) NOT NULL,
435 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
437 -- --------------------------------------------------------
440 -- Table structure for table `group_member`
443 CREATE TABLE IF NOT EXISTS `group_member` (
444 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
445 `uid` int(10) unsigned NOT NULL,
446 `gid` int(10) unsigned NOT NULL,
447 `contact-id` int(10) unsigned NOT NULL,
449 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
451 -- --------------------------------------------------------
454 -- Table structure for table `guid`
457 CREATE TABLE IF NOT EXISTS `guid` (
458 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
459 `guid` char(64) NOT NULL,
462 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
464 -- --------------------------------------------------------
467 -- Table structure for table `hook`
470 CREATE TABLE IF NOT EXISTS `hook` (
471 `id` int(11) NOT NULL AUTO_INCREMENT,
472 `hook` char(255) NOT NULL,
473 `file` char(255) NOT NULL,
474 `function` char(255) NOT NULL,
475 `priority` int(11) UNSIGNED NOT NULL DEFAULT '0',
477 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
479 -- --------------------------------------------------------
482 -- Table structure for table `intro`
485 CREATE TABLE IF NOT EXISTS `intro` (
486 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
487 `uid` int(10) unsigned NOT NULL,
488 `fid` int(11) NOT NULL DEFAULT '0',
489 `contact-id` int(11) NOT NULL,
490 `knowyou` tinyint(1) NOT NULL,
491 `duplex` tinyint(1) NOT NULL DEFAULT '0',
492 `note` text NOT NULL,
493 `hash` char(255) NOT NULL,
494 `datetime` datetime NOT NULL,
495 `blocked` tinyint(1) NOT NULL DEFAULT '1',
496 `ignore` tinyint(1) NOT NULL DEFAULT '0',
498 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
500 -- --------------------------------------------------------
503 -- Table structure for table `item`
506 CREATE TABLE IF NOT EXISTS `item` (
507 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
508 `guid` char(64) NOT NULL,
509 `uri` char(255) CHARACTER SET ascii NOT NULL,
510 `uid` int(10) unsigned NOT NULL DEFAULT '0',
511 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
512 `type` char(255) NOT NULL,
513 `wall` tinyint(1) NOT NULL DEFAULT '0',
514 `gravity` tinyint(1) NOT NULL DEFAULT '0',
515 `parent` int(10) unsigned NOT NULL DEFAULT '0',
516 `parent-uri` char(255) CHARACTER SET ascii NOT NULL,
517 `extid` char(255) NOT NULL,
518 `thr-parent` char(255) NOT NULL,
519 `created` datetime NOT NULL,
520 `edited` datetime NOT NULL,
521 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
522 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
523 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
524 `owner-name` char(255) NOT NULL,
525 `owner-link` char(255) NOT NULL,
526 `owner-avatar` char(255) NOT NULL,
527 `author-name` char(255) NOT NULL,
528 `author-link` char(255) NOT NULL,
529 `author-avatar` char(255) NOT NULL,
530 `title` char(255) NOT NULL,
531 `body` mediumtext NOT NULL,
532 `app` char(255) NOT NULL,
533 `verb` char(255) NOT NULL,
534 `object-type` char(255) NOT NULL,
535 `object` text NOT NULL,
536 `target-type` char(255) NOT NULL,
537 `target` text NOT NULL,
538 `postopts` text NOT NULL,
539 `plink` char(255) NOT NULL,
540 `resource-id` char(255) NOT NULL,
541 `event-id` int(11) NOT NULL,
542 `tag` mediumtext NOT NULL,
543 `attach` mediumtext NOT NULL,
544 `inform` mediumtext NOT NULL,
545 `file` mediumtext NOT NULL,
546 `location` char(255) NOT NULL,
547 `coord` char(255) NOT NULL,
548 `allow_cid` mediumtext NOT NULL,
549 `allow_gid` mediumtext NOT NULL,
550 `deny_cid` mediumtext NOT NULL,
551 `deny_gid` mediumtext NOT NULL,
552 `private` tinyint(1) NOT NULL DEFAULT '0',
553 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
554 `moderated` tinyint(1) NOT NULL DEFAULT '0',
555 `visible` tinyint(1) NOT NULL DEFAULT '0',
556 `spam` tinyint(1) NOT NULL DEFAULT '0',
557 `starred` tinyint(1) NOT NULL DEFAULT '0',
558 `bookmark` tinyint(1) NOT NULL DEFAULT '0',
559 `unseen` tinyint(1) NOT NULL DEFAULT '1',
560 `deleted` tinyint(1) NOT NULL DEFAULT '0',
561 `origin` tinyint(1) NOT NULL DEFAULT '0',
562 `forum_mode` tinyint(1) NOT NULL DEFAULT '0',
563 `mention` tinyint(1) NOT NULL DEFAULT '0',
564 `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
565 `network` char(32) NOT NULL,
569 KEY `contact-id` (`contact-id`),
571 KEY `parent` (`parent`),
572 KEY `parent-uri` (`parent-uri`),
573 KEY `created` (`created`),
574 KEY `edited` (`edited`),
575 KEY `visible` (`visible`),
576 KEY `deleted` (`deleted`),
577 KEY `last-child` (`last-child`),
578 KEY `unseen` (`unseen`),
579 KEY `extid` (`extid`),
580 KEY `received` (`received`),
581 KEY `starred` (`starred`),
583 KEY `origin` (`origin`),
585 KEY `forum_mode` (`forum_mode`),
586 KEY `author-link` (`author-link`),
587 KEY `bookmark` (`bookmark`),
588 KEY `moderated` (`moderated`),
590 KEY `author-name` (`author-name`),
591 KEY `uid_commented` (`uid`, `commented`),
592 KEY `uid_created` (`uid`, `created`),
593 KEY `uid_unseen` (`uid`, `unseen`),
594 KEY `mention` (`mention`),
595 KEY `resource-id` (`resource-id`),
596 KEY `event_id` (`event-id`),
597 KEY `network` (`network`),
598 FULLTEXT KEY `title` (`title`),
599 FULLTEXT KEY `body` (`body`),
600 FULLTEXT KEY `allow_cid` (`allow_cid`),
601 FULLTEXT KEY `allow_gid` (`allow_gid`),
602 FULLTEXT KEY `deny_cid` (`deny_cid`),
603 FULLTEXT KEY `deny_gid` (`deny_gid`),
604 FULLTEXT KEY `tag` (`tag`),
605 FULLTEXT KEY `file` (`file`)
606 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
608 -- --------------------------------------------------------
611 -- Table structure for table `item_id`
614 CREATE TABLE IF NOT EXISTS `item_id` (
615 `id` int(11) NOT NULL AUTO_INCREMENT,
616 `iid` int(11) NOT NULL,
617 `uid` int(11) NOT NULL,
618 `sid` char(255) NOT NULL,
619 `service` char(255) NOT NULL,
624 KEY `service` (`service`)
625 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
627 -- --------------------------------------------------------
630 -- Table structure for table `locks`
633 CREATE TABLE IF NOT EXISTS `locks` (
634 `id` int(11) NOT NULL AUTO_INCREMENT,
635 `name` char(128) NOT NULL,
636 `locked` tinyint(1) NOT NULL DEFAULT '0',
638 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
640 -- --------------------------------------------------------
643 -- Table structure for table `mail`
646 CREATE TABLE IF NOT EXISTS `mail` (
647 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
648 `uid` int(10) unsigned NOT NULL,
649 `guid` char(64) NOT NULL,
650 `from-name` char(255) NOT NULL,
651 `from-photo` char(255) NOT NULL,
652 `from-url` char(255) NOT NULL,
653 `contact-id` char(255) NOT NULL,
654 `convid` int(11) NOT NULL,
655 `title` char(255) NOT NULL,
656 `body` mediumtext NOT NULL,
657 `seen` tinyint(1) NOT NULL,
658 `reply` tinyint(1) NOT NULL DEFAULT '0',
659 `replied` tinyint(1) NOT NULL,
660 `unknown` tinyint(1) NOT NULL DEFAULT '0',
661 `uri` char(255) NOT NULL,
662 `parent-uri` char(255) NOT NULL,
663 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
665 KEY `reply` (`reply`),
670 KEY `parent-uri` (`parent-uri`),
671 KEY `created` (`created`),
672 KEY `convid` (`convid`),
673 KEY `unknown` (`unknown`)
674 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
676 -- --------------------------------------------------------
679 -- Table structure for table `mailacct`
682 CREATE TABLE IF NOT EXISTS `mailacct` (
683 `id` int(11) NOT NULL AUTO_INCREMENT,
684 `uid` int(11) NOT NULL,
685 `server` char(255) NOT NULL,
686 `port` int(11) NOT NULL,
687 `ssltype` char(16) NOT NULL,
688 `mailbox` char(255) NOT NULL,
689 `user` char(255) NOT NULL,
690 `pass` text NOT NULL,
691 `action` int(11) NOT NULL,
692 `movetofolder` char(255) NOT NULL,
693 `reply_to` char(255) NOT NULL,
694 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
695 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
697 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
699 -- --------------------------------------------------------
702 -- Table structure for table `manage`
705 CREATE TABLE IF NOT EXISTS `manage` (
706 `id` int(11) NOT NULL AUTO_INCREMENT,
707 `uid` int(11) NOT NULL,
708 `mid` int(11) NOT NULL,
712 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
714 -- --------------------------------------------------------
717 -- Table structure for table `notify`
720 CREATE TABLE IF NOT EXISTS `notify` (
721 `id` int(11) NOT NULL AUTO_INCREMENT,
722 `hash` char(64) NOT NULL,
723 `name` char(255) NOT NULL,
724 `url` char(255) NOT NULL,
725 `photo` char(255) NOT NULL,
726 `date` datetime NOT NULL,
727 `msg` mediumtext NOT NULL,
728 `uid` int(11) NOT NULL,
729 `link` char(255) NOT NULL,
730 `parent` int(11) NOT NULL,
731 `seen` tinyint(1) NOT NULL DEFAULT '0',
732 `type` int(11) NOT NULL,
733 `verb` char(255) NOT NULL,
734 `otype` char(16) NOT NULL,
741 KEY `parent` (`parent`),
743 KEY `otype` (`otype`)
744 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
746 -- --------------------------------------------------------
749 -- Table structure for table `notify-threads`
752 CREATE TABLE IF NOT EXISTS `notify-threads` (
753 `id` int(11) NOT NULL AUTO_INCREMENT,
754 `notify-id` int(11) NOT NULL,
755 `master-parent-item` int(10) unsigned NOT NULL DEFAULT '0',
756 `parent-item` int(10) unsigned NOT NULL DEFAULT '0',
757 `receiver-uid` int(11) NOT NULL,
759 KEY `master-parent-item` (`master-parent-item`),
760 KEY `receiver-uid` (`receiver-uid`)
761 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
763 -- --------------------------------------------------------
766 -- Table structure for table `pconfig`
769 CREATE TABLE IF NOT EXISTS `pconfig` (
770 `id` int(11) NOT NULL AUTO_INCREMENT,
771 `uid` int(11) NOT NULL DEFAULT '0',
772 `cat` char(255) CHARACTER SET ascii NOT NULL,
773 `k` char(255) CHARACTER SET ascii NOT NULL,
774 `v` mediumtext NOT NULL,
776 UNIQUE KEY `access` (`uid`,`cat`,`k`)
777 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
779 -- --------------------------------------------------------
782 -- Table structure for table `photo`
785 CREATE TABLE IF NOT EXISTS `photo` (
786 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
787 `uid` int(10) unsigned NOT NULL,
788 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
789 `guid` char(64) NOT NULL,
790 `resource-id` char(255) NOT NULL,
791 `created` datetime NOT NULL,
792 `edited` datetime NOT NULL,
793 `title` char(255) NOT NULL,
794 `desc` text NOT NULL,
795 `album` char(255) NOT NULL,
796 `filename` char(255) NOT NULL,
797 `type` CHAR(128) NOT NULL DEFAULT 'image/jpeg',
798 `height` smallint(6) NOT NULL,
799 `width` smallint(6) NOT NULL,
800 `datasize` int(10) unsigned NOT NULL DEFAULT '0',
801 `data` mediumblob NOT NULL,
802 `scale` tinyint(3) NOT NULL,
803 `profile` tinyint(1) NOT NULL DEFAULT '0',
804 `allow_cid` mediumtext NOT NULL,
805 `allow_gid` mediumtext NOT NULL,
806 `deny_cid` mediumtext NOT NULL,
807 `deny_gid` mediumtext NOT NULL,
810 KEY `resource-id` (`resource-id`),
811 KEY `album` (`album`),
812 KEY `scale` (`scale`),
813 KEY `datasize` (`datasize`),
814 KEY `profile` (`profile`)
815 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
817 -- --------------------------------------------------------
820 -- Table structure for table `poll`
823 CREATE TABLE IF NOT EXISTS `poll` (
824 `id` int(11) NOT NULL AUTO_INCREMENT,
825 `uid` int(11) NOT NULL,
826 `q0` mediumtext NOT NULL,
827 `q1` mediumtext NOT NULL,
828 `q2` mediumtext NOT NULL,
829 `q3` mediumtext NOT NULL,
830 `q4` mediumtext NOT NULL,
831 `q5` mediumtext NOT NULL,
832 `q6` mediumtext NOT NULL,
833 `q7` mediumtext NOT NULL,
834 `q8` mediumtext NOT NULL,
835 `q9` mediumtext NOT NULL,
838 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
840 -- --------------------------------------------------------
843 -- Table structure for table `poll_result`
846 CREATE TABLE IF NOT EXISTS `poll_result` (
847 `id` int(11) NOT NULL AUTO_INCREMENT,
848 `poll_id` int(11) NOT NULL,
849 `choice` int(11) NOT NULL,
851 KEY `poll_id` (`poll_id`),
852 KEY `choice` (`choice`)
853 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
855 -- --------------------------------------------------------
858 -- Table structure for table `profile`
861 CREATE TABLE IF NOT EXISTS `profile` (
862 `id` int(11) NOT NULL AUTO_INCREMENT,
863 `uid` int(11) NOT NULL,
864 `profile-name` char(255) NOT NULL,
865 `is-default` tinyint(1) NOT NULL DEFAULT '0',
866 `hide-friends` tinyint(1) NOT NULL DEFAULT '0',
867 `name` char(255) NOT NULL,
868 `pdesc` char(255) NOT NULL,
869 `dob` char(32) NOT NULL DEFAULT '0000-00-00',
870 `address` char(255) NOT NULL,
871 `locality` char(255) NOT NULL,
872 `region` char(255) NOT NULL,
873 `postal-code` char(32) NOT NULL,
874 `country-name` char(255) NOT NULL,
875 `hometown` char(255) NOT NULL,
876 `gender` char(32) NOT NULL,
877 `marital` char(255) NOT NULL,
878 `with` text NOT NULL,
879 `howlong` datetime NOT NULL default '0000-00-00 00:00:00',
880 `sexual` char(255) NOT NULL,
881 `politic` char(255) NOT NULL,
882 `religion` char(255) NOT NULL,
883 `pub_keywords` text NOT NULL,
884 `prv_keywords` text NOT NULL,
885 `likes` text NOT NULL,
886 `dislikes` text NOT NULL,
887 `about` text NOT NULL,
888 `summary` char(255) NOT NULL,
889 `music` text NOT NULL,
890 `book` text NOT NULL,
892 `film` text NOT NULL,
893 `interest` text NOT NULL,
894 `romance` text NOT NULL,
895 `work` text NOT NULL,
896 `education` text NOT NULL,
897 `contact` text NOT NULL,
898 `homepage` char(255) NOT NULL,
899 `photo` char(255) NOT NULL,
900 `thumb` char(255) NOT NULL,
901 `publish` tinyint(1) NOT NULL DEFAULT '0',
902 `net-publish` tinyint(1) NOT NULL DEFAULT '0',
904 FULLTEXT KEY `pub_keywords` (`pub_keywords`),
905 FULLTEXT KEY `prv_keywords` (`prv_keywords`)
906 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
908 -- --------------------------------------------------------
911 -- Table structure for table `profile_check`
914 CREATE TABLE IF NOT EXISTS `profile_check` (
915 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
916 `uid` int(10) unsigned NOT NULL,
917 `cid` int(10) unsigned NOT NULL DEFAULT '0',
918 `dfrn_id` char(255) NOT NULL,
919 `sec` char(255) NOT NULL,
920 `expire` int(11) NOT NULL,
922 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
924 -- --------------------------------------------------------
927 -- Table structure for table `queue`
930 CREATE TABLE IF NOT EXISTS `queue` (
931 `id` int(11) NOT NULL AUTO_INCREMENT,
932 `cid` int(11) NOT NULL,
933 `network` char(32) NOT NULL,
934 `created` datetime NOT NULL,
935 `last` datetime NOT NULL,
936 `content` mediumtext NOT NULL,
937 `batch` tinyint(1) NOT NULL DEFAULT '0',
940 KEY `network` (`network`),
941 KEY `created` (`created`),
943 KEY `batch` (`batch`)
944 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
946 -- --------------------------------------------------------
949 -- Table structure for table `register`
952 CREATE TABLE IF NOT EXISTS `register` (
953 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
954 `hash` char(255) NOT NULL,
955 `created` datetime NOT NULL,
956 `uid` int(10) unsigned NOT NULL,
957 `password` char(255) NOT NULL,
958 `language` char(16) NOT NULL,
960 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
962 -- --------------------------------------------------------
965 -- Table structure for table `search`
968 CREATE TABLE IF NOT EXISTS `search` (
969 `id` int(11) NOT NULL AUTO_INCREMENT,
970 `uid` int(11) NOT NULL,
971 `term` char(255) NOT NULL,
975 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
977 -- --------------------------------------------------------
980 -- Table structure for table `session`
983 CREATE TABLE IF NOT EXISTS `session` (
984 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
985 `sid` char(255) NOT NULL,
986 `data` text NOT NULL,
987 `expire` int(10) unsigned NOT NULL,
990 KEY `expire` (`expire`)
991 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
993 -- --------------------------------------------------------
996 -- Table structure for table `sign`
999 CREATE TABLE IF NOT EXISTS `sign` (
1000 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1001 `iid` int(10) unsigned NOT NULL DEFAULT '0',
1002 `retract_iid` int(10) unsigned NOT NULL DEFAULT '0',
1003 `signed_text` mediumtext NOT NULL,
1004 `signature` text NOT NULL,
1005 `signer` char(255) NOT NULL,
1008 KEY `retract_iid` (`retract_iid`)
1009 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1011 -- --------------------------------------------------------
1014 -- Table structure for table `spam`
1017 CREATE TABLE IF NOT EXISTS `spam` (
1018 `id` int(11) NOT NULL AUTO_INCREMENT,
1019 `uid` int(11) NOT NULL,
1020 `spam` int(11) NOT NULL DEFAULT '0',
1021 `ham` int(11) NOT NULL DEFAULT '0',
1022 `term` char(255) NOT NULL,
1023 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1026 KEY `spam` (`spam`),
1029 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1031 -- --------------------------------------------------------
1034 -- Table structure for table `term`
1037 CREATE TABLE IF NOT EXISTS `term` (
1038 `tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1039 `aid` int(10) unsigned NOT NULL DEFAULT '0',
1040 `uid` int(10) unsigned NOT NULL DEFAULT '0',
1041 `oid` int(10) unsigned NOT NULL,
1042 `otype` tinyint(3) unsigned NOT NULL,
1043 `type` tinyint(3) unsigned NOT NULL,
1044 `term` char(255) NOT NULL,
1045 `url` char(255) NOT NULL,
1046 PRIMARY KEY (`tid`),
1048 KEY `otype` (`otype`),
1049 KEY `type` (`type`),
1050 KEY `term` (`term`),
1053 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1055 -- --------------------------------------------------------
1058 -- Table structure for table `tokens`
1061 CREATE TABLE IF NOT EXISTS `tokens` (
1062 `id` varchar(40) NOT NULL,
1063 `secret` text NOT NULL,
1064 `client_id` varchar(20) NOT NULL,
1065 `expires` int(11) NOT NULL,
1066 `scope` varchar(200) NOT NULL,
1067 `uid` int(11) NOT NULL,
1069 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1071 -- --------------------------------------------------------
1074 -- Table structure for table `user`
1077 CREATE TABLE IF NOT EXISTS `user` (
1078 `uid` int(11) NOT NULL AUTO_INCREMENT,
1079 `guid` char(16) NOT NULL,
1080 `username` char(255) NOT NULL,
1081 `password` char(255) NOT NULL,
1082 `nickname` char(255) NOT NULL,
1083 `email` char(255) NOT NULL,
1084 `openid` char(255) NOT NULL,
1085 `timezone` char(128) NOT NULL,
1086 `language` char(16) NOT NULL DEFAULT 'en',
1087 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1088 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1089 `default-location` char(255) NOT NULL,
1090 `allow_location` tinyint(1) NOT NULL DEFAULT '0',
1091 `theme` char(255) NOT NULL,
1092 `pubkey` text NOT NULL,
1093 `prvkey` text NOT NULL,
1094 `spubkey` text NOT NULL,
1095 `sprvkey` text NOT NULL,
1096 `verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
1097 `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
1098 `blockwall` tinyint(1) NOT NULL DEFAULT '0',
1099 `hidewall` tinyint(1) NOT NULL DEFAULT '0',
1100 `blocktags` tinyint(1) NOT NULL DEFAULT '0',
1101 `unkmail` tinyint(1) NOT NULL DEFAULT '0',
1102 `cntunkmail` int(11) NOT NULL DEFAULT '10',
1103 `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535',
1104 `page-flags` int(11) NOT NULL DEFAULT '0',
1105 `prvnets` tinyint(1) NOT NULL DEFAULT '0',
1106 `pwdreset` char(255) NOT NULL,
1107 `maxreq` int(11) NOT NULL DEFAULT '10',
1108 `expire` int(10) unsigned NOT NULL DEFAULT '0',
1109 `account_removed` tinyint(1) NOT NULL DEFAULT '0',
1110 `account_expired` tinyint(1) NOT NULL DEFAULT '0',
1111 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1112 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1113 `service_class` char(32) NOT NULL,
1114 `def_gid` int(11) NOT NULL DEFAULT '0',
1115 `allow_cid` mediumtext NOT NULL,
1116 `allow_gid` mediumtext NOT NULL,
1117 `deny_cid` mediumtext NOT NULL,
1118 `deny_gid` mediumtext NOT NULL,
1119 `openidserver` text NOT NULL,
1120 PRIMARY KEY (`uid`),
1121 KEY `nickname` (`nickname`),
1122 KEY `login_date` (`login_date`),
1123 KEY `account_expired` (`account_expired`),
1124 KEY `hidewall` (`hidewall`),
1125 KEY `blockwall` (`blockwall`),
1126 KEY `blocked` (`blocked`),
1127 KEY `verified` (`verified`),
1128 KEY `unkmail` (`unkmail`),
1129 KEY `cntunkmail` (`cntunkmail`),
1130 KEY `account_removed` (`account_removed`),
1131 KEY `service_class` (`service_class`)
1132 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1134 -- --------------------------------------------------------
1137 -- Table structure for table `userd`
1140 CREATE TABLE IF NOT EXISTS `userd` (
1141 `id` int(11) NOT NULL AUTO_INCREMENT,
1142 `username` char(255) NOT NULL,
1144 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1146 -- --------------------------------------------------------
1149 -- Table structure for table `tag`
1152 CREATE TABLE IF NOT EXISTS `tag` (
1153 `iid` int(11) NOT NULL,
1154 `tag` char(255) NOT NULL,
1155 `link` char(255) NOT NULL,
1156 PRIMARY KEY (`iid`, `tag`),
1158 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;