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 `timestamp` bigint(20) NOT NULL DEFAULT '0',
20 `plugin_admin` tinyint(1) NOT NULL DEFAULT '0',
22 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
24 -- --------------------------------------------------------
27 -- Table structure for table `attach`
30 CREATE TABLE IF NOT EXISTS `attach` (
31 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `uid` int(11) NOT NULL,
33 `hash` char(64) NOT NULL,
34 `filename` char(255) NOT NULL,
35 `filetype` char(64) NOT NULL,
36 `filesize` int(11) NOT NULL,
37 `data` longblob NOT NULL,
38 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
39 `edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
40 `allow_cid` mediumtext NOT NULL,
41 `allow_gid` mediumtext NOT NULL,
42 `deny_cid` mediumtext NOT NULL,
43 `deny_gid` mediumtext NOT NULL,
45 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
47 -- --------------------------------------------------------
50 -- Table structure for table `auth_codes`
53 CREATE TABLE IF NOT EXISTS `auth_codes` (
54 `id` varchar(40) NOT NULL,
55 `client_id` varchar(20) NOT NULL,
56 `redirect_uri` varchar(200) NOT NULL,
57 `expires` int(11) NOT NULL,
58 `scope` varchar(250) NOT NULL,
60 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
62 -- --------------------------------------------------------
65 -- Table structure for table `cache`
68 CREATE TABLE IF NOT EXISTS `cache` (
69 `k` char(255) NOT NULL,
71 `updated` datetime NOT NULL,
73 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
75 -- --------------------------------------------------------
78 -- Table structure for table `challenge`
81 CREATE TABLE IF NOT EXISTS `challenge` (
82 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
83 `challenge` char(255) NOT NULL,
84 `dfrn-id` char(255) NOT NULL,
85 `expire` int(11) NOT NULL,
86 `type` char(255) NOT NULL,
87 `last_update` char(255) NOT NULL,
89 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
91 -- --------------------------------------------------------
94 -- Table structure for table `clients`
97 CREATE TABLE IF NOT EXISTS `clients` (
98 `client_id` varchar(20) NOT NULL,
99 `pw` varchar(20) NOT NULL,
100 `redirect_uri` varchar(200) NOT NULL,
103 `uid` int(11) NOT NULL DEFAULT '0',
104 PRIMARY KEY (`client_id`)
105 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
107 -- --------------------------------------------------------
110 -- Table structure for table `config`
113 CREATE TABLE IF NOT EXISTS `config` (
114 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
115 `cat` char(255) CHARACTER SET ascii NOT NULL,
116 `k` char(255) CHARACTER SET ascii NOT NULL,
119 UNIQUE KEY `access` (`cat`,`k`)
120 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
122 -- --------------------------------------------------------
125 -- Table structure for table `contact`
128 CREATE TABLE IF NOT EXISTS `contact` (
129 `id` int(11) NOT NULL AUTO_INCREMENT,
130 `uid` int(11) NOT NULL COMMENT 'owner uid',
131 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
132 `self` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'boolean 1 == info for local UID, primarily name and photo to use in item displays.',
133 `remote_self` tinyint(1) NOT NULL DEFAULT '0',
134 `rel` tinyint(1) NOT NULL DEFAULT '0',
135 `duplex` tinyint(1) NOT NULL DEFAULT '0',
136 `network` char(255) NOT NULL,
137 `name` char(255) NOT NULL,
138 `nick` char(255) NOT NULL,
139 `attag` char(255) NOT NULL,
140 `photo` text NOT NULL COMMENT 'remote photo URL initially until approved',
141 `thumb` text NOT NULL,
142 `micro` text NOT NULL,
143 `site-pubkey` text NOT NULL,
144 `issued-id` char(255) NOT NULL,
145 `dfrn-id` char(255) NOT NULL,
146 `url` char(255) NOT NULL,
147 `nurl` char(255) NOT NULL,
148 `addr` char(255) NOT NULL,
149 `alias` char(255) NOT NULL,
150 `pubkey` text NOT NULL,
151 `prvkey` text NOT NULL,
152 `batch` char(255) NOT NULL,
153 `request` text NOT NULL,
154 `notify` text NOT NULL,
155 `poll` text NOT NULL,
156 `confirm` text NOT NULL,
157 `poco` text NOT NULL,
158 `aes_allow` tinyint(1) NOT NULL DEFAULT '0',
159 `ret-aes` tinyint(1) NOT NULL DEFAULT '0',
160 `usehub` tinyint(1) NOT NULL DEFAULT '0',
161 `subhub` tinyint(1) NOT NULL DEFAULT '0',
162 `hub-verify` char(255) NOT NULL,
163 `last-update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
164 `success_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
165 `name-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
166 `uri-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
167 `avatar-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
168 `term-date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
169 `priority` tinyint(3) NOT NULL,
170 `blocked` tinyint(1) NOT NULL DEFAULT '1',
171 `readonly` tinyint(1) NOT NULL DEFAULT '0',
172 `writable` tinyint(1) NOT NULL DEFAULT '0',
173 `forum` tinyint(1) NOT NULL DEFAULT '0',
174 `hidden` tinyint(1) NOT NULL DEFAULT '0',
175 `archive` tinyint(1) NOT NULL DEFAULT '0',
176 `pending` tinyint(1) NOT NULL DEFAULT '1',
177 `rating` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-5 reputation, 0 unknown, 1 call police, 5 inscrutable',
178 `reason` text NOT NULL COMMENT 'why a rating was given - will help friends decide to make friends or not',
179 `closeness` tinyint(2) NOT NULL DEFAULT '99',
180 `info` mediumtext NOT NULL,
181 `profile-id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default',
182 `bdyear` char(4) NOT NULL COMMENT 'birthday notify flag',
187 KEY `issued-id` (`issued-id`),
188 KEY `dfrn-id` (`dfrn-id`),
189 KEY `blocked` (`blocked`),
190 KEY `readonly` (`readonly`),
191 KEY `network` (`network`),
194 KEY `attag` (`attag`),
197 KEY `batch` (`batch`),
199 KEY `pending` (`pending`),
200 KEY `hidden` (`hidden`),
201 KEY `archive` (`archive`),
202 KEY `forum` (`forum`)
203 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
205 -- --------------------------------------------------------
208 -- Table structure for table `conv`
211 CREATE TABLE IF NOT EXISTS `conv` (
212 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
213 `guid` char(64) NOT NULL,
214 `recips` mediumtext NOT NULL,
215 `uid` int(11) NOT NULL,
216 `creator` char(255) NOT NULL,
217 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
218 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
219 `subject` mediumtext NOT NULL,
221 KEY `created` (`created`),
222 KEY `updated` (`updated`)
223 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
225 -- --------------------------------------------------------
228 -- Table structure for table `deliverq`
231 CREATE TABLE IF NOT EXISTS `deliverq` (
232 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
233 `cmd` char(32) NOT NULL,
234 `item` int(11) NOT NULL,
235 `contact` int(11) NOT NULL,
237 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
239 -- --------------------------------------------------------
242 -- Table structure for table `event`
245 CREATE TABLE IF NOT EXISTS `event` (
246 `id` int(11) NOT NULL AUTO_INCREMENT,
247 `uid` int(11) NOT NULL,
248 `cid` int(11) NOT NULL,
249 `uri` char(255) NOT NULL,
250 `created` datetime NOT NULL,
251 `edited` datetime NOT NULL,
252 `start` datetime NOT NULL,
253 `finish` datetime NOT NULL,
254 `desc` text NOT NULL,
255 `location` text NOT NULL,
256 `type` char(255) NOT NULL,
257 `nofinish` tinyint(1) NOT NULL DEFAULT '0',
258 `adjust` tinyint(1) NOT NULL DEFAULT '1',
259 `allow_cid` mediumtext NOT NULL,
260 `allow_gid` mediumtext NOT NULL,
261 `deny_cid` mediumtext NOT NULL,
262 `deny_gid` mediumtext NOT NULL,
264 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
266 -- --------------------------------------------------------
269 -- Table structure for table `fcontact`
272 CREATE TABLE IF NOT EXISTS `fcontact` (
273 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
274 `url` char(255) NOT NULL,
275 `name` char(255) NOT NULL,
276 `photo` char(255) NOT NULL,
277 `request` char(255) NOT NULL,
278 `nick` char(255) NOT NULL,
279 `addr` char(255) NOT NULL,
280 `batch` char(255) NOT NULL,
281 `notify` char(255) NOT NULL,
282 `poll` char(255) NOT NULL,
283 `confirm` char(255) NOT NULL,
284 `priority` tinyint(1) NOT NULL,
285 `network` char(32) NOT NULL,
286 `alias` char(255) NOT NULL,
287 `pubkey` text NOT NULL,
288 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
291 KEY `network` (`network`)
292 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
294 -- --------------------------------------------------------
297 -- Table structure for table `ffinder`
300 CREATE TABLE IF NOT EXISTS `ffinder` (
301 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
302 `uid` int(10) unsigned NOT NULL,
303 `cid` int(10) unsigned NOT NULL,
304 `fid` int(10) unsigned NOT NULL,
306 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
308 -- --------------------------------------------------------
311 -- Table structure for table `fserver`
314 CREATE TABLE IF NOT EXISTS `fserver` (
315 `id` int(11) NOT NULL AUTO_INCREMENT,
316 `server` char(255) NOT NULL,
317 `posturl` char(255) NOT NULL,
320 KEY `server` (`server`)
321 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
323 -- --------------------------------------------------------
326 -- Table structure for table `fsuggest`
329 CREATE TABLE IF NOT EXISTS `fsuggest` (
330 `id` int(11) NOT NULL AUTO_INCREMENT,
331 `uid` int(11) NOT NULL,
332 `cid` int(11) NOT NULL,
333 `name` char(255) NOT NULL,
334 `url` char(255) NOT NULL,
335 `request` char(255) NOT NULL,
336 `photo` char(255) NOT NULL,
337 `note` text NOT NULL,
338 `created` datetime NOT NULL,
340 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
342 -- --------------------------------------------------------
345 -- Table structure for table `gcign`
348 CREATE TABLE IF NOT EXISTS `gcign` (
349 `id` int(11) NOT NULL AUTO_INCREMENT,
350 `uid` int(11) NOT NULL,
351 `gcid` int(11) NOT NULL,
355 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
357 -- --------------------------------------------------------
360 -- Table structure for table `gcontact`
363 CREATE TABLE IF NOT EXISTS `gcontact` (
364 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
365 `name` char(255) NOT NULL,
366 `url` char(255) NOT NULL,
367 `nurl` char(255) NOT NULL,
368 `photo` char(255) NOT NULL,
369 `connect` char(255) NOT NULL,
372 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
374 -- --------------------------------------------------------
377 -- Table structure for table `glink`
380 CREATE TABLE IF NOT EXISTS `glink` (
381 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
382 `cid` int(11) NOT NULL,
383 `uid` int(11) NOT NULL,
384 `gcid` int(11) NOT NULL,
385 `updated` datetime NOT NULL,
390 KEY `updated` (`updated`)
391 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
393 -- --------------------------------------------------------
396 -- Table structure for table `group`
399 CREATE TABLE IF NOT EXISTS `group` (
400 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
401 `uid` int(10) unsigned NOT NULL,
402 `visible` tinyint(1) NOT NULL DEFAULT '0',
403 `deleted` tinyint(1) NOT NULL DEFAULT '0',
404 `name` char(255) NOT NULL,
406 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
408 -- --------------------------------------------------------
411 -- Table structure for table `group_member`
414 CREATE TABLE IF NOT EXISTS `group_member` (
415 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
416 `uid` int(10) unsigned NOT NULL,
417 `gid` int(10) unsigned NOT NULL,
418 `contact-id` int(10) unsigned NOT NULL,
420 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
422 -- --------------------------------------------------------
425 -- Table structure for table `guid`
428 CREATE TABLE IF NOT EXISTS `guid` (
429 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
430 `guid` char(64) NOT NULL,
433 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
435 -- --------------------------------------------------------
438 -- Table structure for table `hook`
441 CREATE TABLE IF NOT EXISTS `hook` (
442 `id` int(11) NOT NULL AUTO_INCREMENT,
443 `hook` char(255) NOT NULL,
444 `file` char(255) NOT NULL,
445 `function` char(255) NOT NULL,
447 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
449 -- --------------------------------------------------------
452 -- Table structure for table `intro`
455 CREATE TABLE IF NOT EXISTS `intro` (
456 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
457 `uid` int(10) unsigned NOT NULL,
458 `fid` int(11) NOT NULL DEFAULT '0',
459 `contact-id` int(11) NOT NULL,
460 `knowyou` tinyint(1) NOT NULL,
461 `duplex` tinyint(1) NOT NULL DEFAULT '0',
462 `note` text NOT NULL,
463 `hash` char(255) NOT NULL,
464 `datetime` datetime NOT NULL,
465 `blocked` tinyint(1) NOT NULL DEFAULT '1',
466 `ignore` tinyint(1) NOT NULL DEFAULT '0',
468 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
470 -- --------------------------------------------------------
473 -- Table structure for table `item`
476 CREATE TABLE IF NOT EXISTS `item` (
477 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
478 `guid` char(64) NOT NULL,
479 `uri` char(255) CHARACTER SET ascii NOT NULL,
480 `uid` int(10) unsigned NOT NULL DEFAULT '0',
481 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
482 `type` char(255) NOT NULL,
483 `wall` tinyint(1) NOT NULL DEFAULT '0',
484 `gravity` tinyint(1) NOT NULL DEFAULT '0',
485 `parent` int(10) unsigned NOT NULL DEFAULT '0',
486 `parent-uri` char(255) CHARACTER SET ascii NOT NULL,
487 `extid` char(255) NOT NULL,
488 `thr-parent` char(255) NOT NULL,
489 `created` datetime NOT NULL,
490 `edited` datetime NOT NULL,
491 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
492 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
493 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
494 `owner-name` char(255) NOT NULL,
495 `owner-link` char(255) NOT NULL,
496 `owner-avatar` char(255) NOT NULL,
497 `author-name` char(255) NOT NULL,
498 `author-link` char(255) NOT NULL,
499 `author-avatar` char(255) NOT NULL,
500 `title` char(255) NOT NULL,
501 `body` mediumtext NOT NULL,
502 `app` char(255) NOT NULL,
503 `verb` char(255) NOT NULL,
504 `object-type` char(255) NOT NULL,
505 `object` text NOT NULL,
506 `target-type` char(255) NOT NULL,
507 `target` text NOT NULL,
508 `postopts` text NOT NULL,
509 `plink` char(255) NOT NULL,
510 `resource-id` char(255) NOT NULL,
511 `event-id` int(11) NOT NULL,
512 `tag` mediumtext NOT NULL,
513 `attach` mediumtext NOT NULL,
514 `inform` mediumtext NOT NULL,
515 `file` mediumtext NOT NULL,
516 `location` char(255) NOT NULL,
517 `coord` char(255) NOT NULL,
518 `allow_cid` mediumtext NOT NULL,
519 `allow_gid` mediumtext NOT NULL,
520 `deny_cid` mediumtext NOT NULL,
521 `deny_gid` mediumtext NOT NULL,
522 `private` tinyint(1) NOT NULL DEFAULT '0',
523 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
524 `moderated` tinyint(1) NOT NULL DEFAULT '0',
525 `visible` tinyint(1) NOT NULL DEFAULT '0',
526 `spam` tinyint(1) NOT NULL DEFAULT '0',
527 `starred` tinyint(1) NOT NULL DEFAULT '0',
528 `bookmark` tinyint(1) NOT NULL DEFAULT '0',
529 `unseen` tinyint(1) NOT NULL DEFAULT '1',
530 `deleted` tinyint(1) NOT NULL DEFAULT '0',
531 `origin` tinyint(1) NOT NULL DEFAULT '0',
532 `forum_mode` tinyint(1) NOT NULL DEFAULT '0',
533 `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
537 KEY `contact-id` (`contact-id`),
539 KEY `parent` (`parent`),
540 KEY `parent-uri` (`parent-uri`),
541 KEY `created` (`created`),
542 KEY `edited` (`edited`),
543 KEY `visible` (`visible`),
544 KEY `deleted` (`deleted`),
545 KEY `last-child` (`last-child`),
546 KEY `unseen` (`unseen`),
547 KEY `extid` (`extid`),
548 KEY `received` (`received`),
549 KEY `starred` (`starred`),
551 KEY `origin` (`origin`),
553 KEY `forum_mode` (`forum_mode`),
554 KEY `author-link` (`author-link`),
555 KEY `bookmark` (`bookmark`),
556 KEY `moderated` (`moderated`),
558 KEY `author-name` (`author-name`),
559 FULLTEXT KEY `title` (`title`),
560 FULLTEXT KEY `body` (`body`),
561 FULLTEXT KEY `allow_cid` (`allow_cid`),
562 FULLTEXT KEY `allow_gid` (`allow_gid`),
563 FULLTEXT KEY `deny_cid` (`deny_cid`),
564 FULLTEXT KEY `deny_gid` (`deny_gid`),
565 FULLTEXT KEY `tag` (`tag`),
566 FULLTEXT KEY `file` (`file`)
567 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
569 -- --------------------------------------------------------
572 -- Table structure for table `item_id`
575 CREATE TABLE IF NOT EXISTS `item_id` (
576 `iid` int(11) NOT NULL,
577 `uid` int(11) NOT NULL,
578 `sid` char(255) NOT NULL,
579 `service` char(255) NOT NULL,
583 KEY `service` (`service`)
584 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
586 -- --------------------------------------------------------
589 -- Table structure for table `mail`
592 CREATE TABLE IF NOT EXISTS `mail` (
593 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
594 `uid` int(10) unsigned NOT NULL,
595 `guid` char(64) NOT NULL,
596 `from-name` char(255) NOT NULL,
597 `from-photo` char(255) NOT NULL,
598 `from-url` char(255) NOT NULL,
599 `contact-id` char(255) NOT NULL,
600 `convid` int(11) NOT NULL,
601 `title` char(255) NOT NULL,
602 `body` mediumtext NOT NULL,
603 `seen` tinyint(1) NOT NULL,
604 `reply` tinyint(1) NOT NULL DEFAULT '0',
605 `replied` tinyint(1) NOT NULL,
606 `unknown` tinyint(1) NOT NULL DEFAULT '0',
607 `uri` char(255) NOT NULL,
608 `parent-uri` char(255) NOT NULL,
609 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
611 KEY `reply` (`reply`),
616 KEY `parent-uri` (`parent-uri`),
617 KEY `created` (`created`),
618 KEY `convid` (`convid`),
619 KEY `unknown` (`unknown`)
620 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
622 -- --------------------------------------------------------
625 -- Table structure for table `mailacct`
628 CREATE TABLE IF NOT EXISTS `mailacct` (
629 `id` int(11) NOT NULL AUTO_INCREMENT,
630 `uid` int(11) NOT NULL,
631 `server` char(255) NOT NULL,
632 `port` int(11) NOT NULL,
633 `ssltype` char(16) NOT NULL,
634 `mailbox` char(255) NOT NULL,
635 `user` char(255) NOT NULL,
636 `pass` text NOT NULL,
637 `action` int(11) NOT NULL,
638 `movetofolder` char(255) NOT NULL,
639 `reply_to` char(255) NOT NULL,
640 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
641 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
643 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
645 -- --------------------------------------------------------
648 -- Table structure for table `manage`
651 CREATE TABLE IF NOT EXISTS `manage` (
652 `id` int(11) NOT NULL AUTO_INCREMENT,
653 `uid` int(11) NOT NULL,
654 `mid` int(11) NOT NULL,
658 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
660 -- --------------------------------------------------------
663 -- Table structure for table `notify`
666 CREATE TABLE IF NOT EXISTS `notify` (
667 `id` int(11) NOT NULL AUTO_INCREMENT,
668 `hash` char(64) NOT NULL,
669 `name` char(255) NOT NULL,
670 `url` char(255) NOT NULL,
671 `photo` char(255) NOT NULL,
672 `date` datetime NOT NULL,
673 `msg` mediumtext NOT NULL,
674 `uid` int(11) NOT NULL,
675 `link` char(255) NOT NULL,
676 `parent` int(11) NOT NULL,
677 `seen` tinyint(1) NOT NULL DEFAULT '0',
678 `type` int(11) NOT NULL,
679 `verb` char(255) NOT NULL,
680 `otype` char(16) NOT NULL,
687 KEY `parent` (`parent`),
689 KEY `otype` (`otype`)
690 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
692 -- --------------------------------------------------------
695 -- Table structure for table `notify-threads`
698 CREATE TABLE IF NOT EXISTS `notify-threads` (
699 `id` int(11) NOT NULL AUTO_INCREMENT,
700 `notify-id` int(11) NOT NULL,
701 `master-parent-item` int(10) unsigned NOT NULL DEFAULT '0',
702 `parent-item` int(10) unsigned NOT NULL DEFAULT '0',
703 `receiver-uid` int(11) NOT NULL,
705 KEY `master-parent-item` (`master-parent-item`),
706 KEY `receiver-uid` (`receiver-uid`)
707 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
709 -- --------------------------------------------------------
712 -- Table structure for table `pconfig`
715 CREATE TABLE IF NOT EXISTS `pconfig` (
716 `id` int(11) NOT NULL AUTO_INCREMENT,
717 `uid` int(11) NOT NULL DEFAULT '0',
718 `cat` char(255) CHARACTER SET ascii NOT NULL,
719 `k` char(255) CHARACTER SET ascii NOT NULL,
720 `v` mediumtext NOT NULL,
722 UNIQUE KEY `access` (`uid`,`cat`,`k`)
723 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
725 -- --------------------------------------------------------
728 -- Table structure for table `photo`
731 CREATE TABLE IF NOT EXISTS `photo` (
732 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
733 `uid` int(10) unsigned NOT NULL,
734 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
735 `guid` char(64) NOT NULL,
736 `resource-id` char(255) NOT NULL,
737 `created` datetime NOT NULL,
738 `edited` datetime NOT NULL,
739 `title` char(255) NOT NULL,
740 `desc` text NOT NULL,
741 `album` char(255) NOT NULL,
742 `filename` char(255) NOT NULL,
743 `height` smallint(6) NOT NULL,
744 `width` smallint(6) NOT NULL,
745 `data` mediumblob NOT NULL,
746 `scale` tinyint(3) NOT NULL,
747 `profile` tinyint(1) NOT NULL DEFAULT '0',
748 `allow_cid` mediumtext NOT NULL,
749 `allow_gid` mediumtext NOT NULL,
750 `deny_cid` mediumtext NOT NULL,
751 `deny_gid` mediumtext NOT NULL,
754 KEY `resource-id` (`resource-id`),
755 KEY `album` (`album`),
756 KEY `scale` (`scale`),
757 KEY `profile` (`profile`)
758 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
760 -- --------------------------------------------------------
763 -- Table structure for table `poll`
766 CREATE TABLE IF NOT EXISTS `poll` (
767 `id` int(11) NOT NULL AUTO_INCREMENT,
768 `uid` int(11) NOT NULL,
769 `q0` mediumtext NOT NULL,
770 `q1` mediumtext NOT NULL,
771 `q2` mediumtext NOT NULL,
772 `q3` mediumtext NOT NULL,
773 `q4` mediumtext NOT NULL,
774 `q5` mediumtext NOT NULL,
775 `q6` mediumtext NOT NULL,
776 `q7` mediumtext NOT NULL,
777 `q8` mediumtext NOT NULL,
778 `q9` mediumtext NOT NULL,
781 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
783 -- --------------------------------------------------------
786 -- Table structure for table `poll_result`
789 CREATE TABLE IF NOT EXISTS `poll_result` (
790 `id` int(11) NOT NULL AUTO_INCREMENT,
791 `poll_id` int(11) NOT NULL,
792 `choice` int(11) NOT NULL,
794 KEY `poll_id` (`poll_id`),
795 KEY `choice` (`choice`)
796 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
798 -- --------------------------------------------------------
801 -- Table structure for table `profile`
804 CREATE TABLE IF NOT EXISTS `profile` (
805 `id` int(11) NOT NULL AUTO_INCREMENT,
806 `uid` int(11) NOT NULL,
807 `profile-name` char(255) NOT NULL,
808 `is-default` tinyint(1) NOT NULL DEFAULT '0',
809 `hide-friends` tinyint(1) NOT NULL DEFAULT '0',
810 `name` char(255) NOT NULL,
811 `pdesc` char(255) NOT NULL,
812 `dob` char(32) NOT NULL DEFAULT '0000-00-00',
813 `address` char(255) NOT NULL,
814 `locality` char(255) NOT NULL,
815 `region` char(255) NOT NULL,
816 `postal-code` char(32) NOT NULL,
817 `country-name` char(255) NOT NULL,
818 `gender` char(32) NOT NULL,
819 `marital` char(255) NOT NULL,
820 `with` text NOT NULL,
821 `sexual` char(255) NOT NULL,
822 `politic` char(255) NOT NULL,
823 `religion` char(255) NOT NULL,
824 `pub_keywords` text NOT NULL,
825 `prv_keywords` text NOT NULL,
826 `about` text NOT NULL,
827 `summary` char(255) NOT NULL,
828 `music` text NOT NULL,
829 `book` text NOT NULL,
831 `film` text NOT NULL,
832 `interest` text NOT NULL,
833 `romance` text NOT NULL,
834 `work` text NOT NULL,
835 `education` text NOT NULL,
836 `contact` text NOT NULL,
837 `homepage` char(255) NOT NULL,
838 `photo` char(255) NOT NULL,
839 `thumb` char(255) NOT NULL,
840 `publish` tinyint(1) NOT NULL DEFAULT '0',
841 `net-publish` tinyint(1) NOT NULL DEFAULT '0',
843 FULLTEXT KEY `pub_keywords` (`pub_keywords`),
844 FULLTEXT KEY `prv_keywords` (`prv_keywords`)
845 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
847 -- --------------------------------------------------------
850 -- Table structure for table `profile_check`
853 CREATE TABLE IF NOT EXISTS `profile_check` (
854 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
855 `uid` int(10) unsigned NOT NULL,
856 `cid` int(10) unsigned NOT NULL DEFAULT '0',
857 `dfrn_id` char(255) NOT NULL,
858 `sec` char(255) NOT NULL,
859 `expire` int(11) NOT NULL,
861 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
863 -- --------------------------------------------------------
866 -- Table structure for table `queue`
869 CREATE TABLE IF NOT EXISTS `queue` (
870 `id` int(11) NOT NULL AUTO_INCREMENT,
871 `cid` int(11) NOT NULL,
872 `network` char(32) NOT NULL,
873 `created` datetime NOT NULL,
874 `last` datetime NOT NULL,
875 `content` mediumtext NOT NULL,
876 `batch` tinyint(1) NOT NULL DEFAULT '0',
879 KEY `network` (`network`),
880 KEY `created` (`created`),
882 KEY `batch` (`batch`)
883 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
885 -- --------------------------------------------------------
888 -- Table structure for table `register`
891 CREATE TABLE IF NOT EXISTS `register` (
892 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
893 `hash` char(255) NOT NULL,
894 `created` datetime NOT NULL,
895 `uid` int(10) unsigned NOT NULL,
896 `password` char(255) NOT NULL,
897 `language` char(16) NOT NULL,
899 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
901 -- --------------------------------------------------------
904 -- Table structure for table `search`
907 CREATE TABLE IF NOT EXISTS `search` (
908 `id` int(11) NOT NULL AUTO_INCREMENT,
909 `uid` int(11) NOT NULL,
910 `term` char(255) NOT NULL,
914 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
916 -- --------------------------------------------------------
919 -- Table structure for table `session`
922 CREATE TABLE IF NOT EXISTS `session` (
923 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
924 `sid` char(255) NOT NULL,
925 `data` text NOT NULL,
926 `expire` int(10) unsigned NOT NULL,
929 KEY `expire` (`expire`)
930 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
932 -- --------------------------------------------------------
935 -- Table structure for table `sign`
938 CREATE TABLE IF NOT EXISTS `sign` (
939 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
940 `iid` int(10) unsigned NOT NULL,
941 `signed_text` mediumtext NOT NULL,
942 `signature` text NOT NULL,
943 `signer` char(255) NOT NULL,
946 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
948 -- --------------------------------------------------------
951 -- Table structure for table `spam`
954 CREATE TABLE IF NOT EXISTS `spam` (
955 `id` int(11) NOT NULL AUTO_INCREMENT,
956 `uid` int(11) NOT NULL,
957 `spam` int(11) NOT NULL DEFAULT '0',
958 `ham` int(11) NOT NULL DEFAULT '0',
959 `term` char(255) NOT NULL,
960 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
966 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
968 -- --------------------------------------------------------
971 -- Table structure for table `tokens`
974 CREATE TABLE IF NOT EXISTS `tokens` (
975 `id` varchar(40) NOT NULL,
976 `secret` text NOT NULL,
977 `client_id` varchar(20) NOT NULL,
978 `expires` int(11) NOT NULL,
979 `scope` varchar(200) NOT NULL,
980 `uid` int(11) NOT NULL,
982 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
984 -- --------------------------------------------------------
987 -- Table structure for table `user`
990 CREATE TABLE IF NOT EXISTS `user` (
991 `uid` int(11) NOT NULL AUTO_INCREMENT,
992 `guid` char(16) NOT NULL,
993 `username` char(255) NOT NULL,
994 `password` char(255) NOT NULL,
995 `nickname` char(255) NOT NULL,
996 `email` char(255) NOT NULL,
997 `openid` char(255) NOT NULL,
998 `timezone` char(128) NOT NULL,
999 `language` char(16) NOT NULL DEFAULT 'en',
1000 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1001 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1002 `default-location` char(255) NOT NULL,
1003 `allow_location` tinyint(1) NOT NULL DEFAULT '0',
1004 `theme` char(255) NOT NULL,
1005 `pubkey` text NOT NULL,
1006 `prvkey` text NOT NULL,
1007 `spubkey` text NOT NULL,
1008 `sprvkey` text NOT NULL,
1009 `verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
1010 `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
1011 `blockwall` tinyint(1) NOT NULL DEFAULT '0',
1012 `hidewall` tinyint(1) NOT NULL DEFAULT '0',
1013 `blocktags` tinyint(1) NOT NULL DEFAULT '0',
1014 `unkmail` tinyint(1) NOT NULL DEFAULT '0',
1015 `cntunkmail` int(11) NOT NULL DEFAULT '10',
1016 `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535',
1017 `page-flags` int(11) NOT NULL DEFAULT '0',
1018 `prvnets` tinyint(1) NOT NULL DEFAULT '0',
1019 `pwdreset` char(255) NOT NULL,
1020 `maxreq` int(11) NOT NULL DEFAULT '10',
1021 `expire` int(10) unsigned NOT NULL DEFAULT '0',
1022 `account_removed` tinyint(1) NOT NULL DEFAULT '0',
1023 `account_expired` tinyint(1) NOT NULL DEFAULT '0',
1024 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1025 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1026 `allow_cid` mediumtext NOT NULL,
1027 `allow_gid` mediumtext NOT NULL,
1028 `deny_cid` mediumtext NOT NULL,
1029 `deny_gid` mediumtext NOT NULL,
1030 `openidserver` text NOT NULL,
1031 PRIMARY KEY (`uid`),
1032 KEY `nickname` (`nickname`),
1033 KEY `login_date` (`login_date`),
1034 KEY `account_expired` (`account_expired`),
1035 KEY `hidewall` (`hidewall`),
1036 KEY `blockwall` (`blockwall`),
1037 KEY `blocked` (`blocked`),
1038 KEY `verified` (`verified`),
1039 KEY `unkmail` (`unkmail`),
1040 KEY `cntunkmail` (`cntunkmail`),
1041 KEY `account_removed` (`account_removed`)
1042 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1044 -- --------------------------------------------------------
1047 -- Table structure for table `userd`
1050 CREATE TABLE IF NOT EXISTS `userd` (
1051 `id` int(11) NOT NULL AUTO_INCREMENT,
1052 `username` char(255) NOT NULL,
1054 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;