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 `hidden` tinyint(1) NOT NULL DEFAULT '0',
177 `archive` tinyint(1) NOT NULL DEFAULT '0',
178 `pending` tinyint(1) NOT NULL DEFAULT '1',
179 `rating` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-5 reputation, 0 unknown, 1 call police, 5 inscrutable',
180 `reason` text NOT NULL COMMENT 'why a rating was given - will help friends decide to make friends or not',
181 `closeness` tinyint(2) NOT NULL DEFAULT '99',
182 `info` mediumtext NOT NULL,
183 `profile-id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default',
184 `bdyear` char(4) NOT NULL COMMENT 'birthday notify flag',
189 KEY `issued-id` (`issued-id`),
190 KEY `dfrn-id` (`dfrn-id`),
191 KEY `blocked` (`blocked`),
192 KEY `readonly` (`readonly`),
193 KEY `network` (`network`),
196 KEY `attag` (`attag`),
199 KEY `batch` (`batch`),
201 KEY `pending` (`pending`),
202 KEY `hidden` (`hidden`),
203 KEY `archive` (`archive`),
204 KEY `forum` (`forum`)
205 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
207 -- --------------------------------------------------------
210 -- Table structure for table `conv`
213 CREATE TABLE IF NOT EXISTS `conv` (
214 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
215 `guid` char(64) NOT NULL,
216 `recips` mediumtext NOT NULL,
217 `uid` int(11) NOT NULL,
218 `creator` char(255) NOT NULL,
219 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
220 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
221 `subject` mediumtext NOT NULL,
223 KEY `created` (`created`),
224 KEY `updated` (`updated`)
225 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
227 -- --------------------------------------------------------
230 -- Table structure for table `deliverq`
233 CREATE TABLE IF NOT EXISTS `deliverq` (
234 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
235 `cmd` char(32) NOT NULL,
236 `item` int(11) NOT NULL,
237 `contact` int(11) NOT NULL,
239 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
241 -- --------------------------------------------------------
244 -- Table structure for table `event`
247 CREATE TABLE IF NOT EXISTS `event` (
248 `id` int(11) NOT NULL AUTO_INCREMENT,
249 `uid` int(11) NOT NULL,
250 `cid` int(11) NOT NULL,
251 `uri` char(255) NOT NULL,
252 `created` datetime NOT NULL,
253 `edited` datetime NOT NULL,
254 `start` datetime NOT NULL,
255 `finish` datetime NOT NULL,
256 `desc` text NOT NULL,
257 `location` text NOT NULL,
258 `type` char(255) NOT NULL,
259 `nofinish` tinyint(1) NOT NULL DEFAULT '0',
260 `adjust` tinyint(1) NOT NULL DEFAULT '1',
261 `allow_cid` mediumtext NOT NULL,
262 `allow_gid` mediumtext NOT NULL,
263 `deny_cid` mediumtext NOT NULL,
264 `deny_gid` mediumtext NOT NULL,
266 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
268 -- --------------------------------------------------------
271 -- Table structure for table `fcontact`
274 CREATE TABLE IF NOT EXISTS `fcontact` (
275 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
276 `url` char(255) NOT NULL,
277 `name` char(255) NOT NULL,
278 `photo` char(255) NOT NULL,
279 `request` char(255) NOT NULL,
280 `nick` char(255) NOT NULL,
281 `addr` char(255) NOT NULL,
282 `batch` char(255) NOT NULL,
283 `notify` char(255) NOT NULL,
284 `poll` char(255) NOT NULL,
285 `confirm` char(255) NOT NULL,
286 `priority` tinyint(1) NOT NULL,
287 `network` char(32) NOT NULL,
288 `alias` char(255) NOT NULL,
289 `pubkey` text NOT NULL,
290 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
293 KEY `network` (`network`)
294 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
296 -- --------------------------------------------------------
299 -- Table structure for table `ffinder`
302 CREATE TABLE IF NOT EXISTS `ffinder` (
303 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
304 `uid` int(10) unsigned NOT NULL,
305 `cid` int(10) unsigned NOT NULL,
306 `fid` int(10) unsigned NOT NULL,
308 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
310 -- --------------------------------------------------------
313 -- Table structure for table `fserver`
316 CREATE TABLE IF NOT EXISTS `fserver` (
317 `id` int(11) NOT NULL AUTO_INCREMENT,
318 `server` char(255) NOT NULL,
319 `posturl` char(255) NOT NULL,
322 KEY `server` (`server`)
323 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
325 -- --------------------------------------------------------
328 -- Table structure for table `fsuggest`
331 CREATE TABLE IF NOT EXISTS `fsuggest` (
332 `id` int(11) NOT NULL AUTO_INCREMENT,
333 `uid` int(11) NOT NULL,
334 `cid` int(11) NOT NULL,
335 `name` char(255) NOT NULL,
336 `url` char(255) NOT NULL,
337 `request` char(255) NOT NULL,
338 `photo` char(255) NOT NULL,
339 `note` text NOT NULL,
340 `created` datetime NOT NULL,
342 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
344 -- --------------------------------------------------------
347 -- Table structure for table `gcign`
350 CREATE TABLE IF NOT EXISTS `gcign` (
351 `id` int(11) NOT NULL AUTO_INCREMENT,
352 `uid` int(11) NOT NULL,
353 `gcid` int(11) NOT NULL,
357 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
359 -- --------------------------------------------------------
362 -- Table structure for table `gcontact`
365 CREATE TABLE IF NOT EXISTS `gcontact` (
366 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
367 `name` char(255) NOT NULL,
368 `url` char(255) NOT NULL,
369 `nurl` char(255) NOT NULL,
370 `photo` char(255) NOT NULL,
371 `connect` char(255) NOT NULL,
374 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
376 -- --------------------------------------------------------
379 -- Table structure for table `glink`
382 CREATE TABLE IF NOT EXISTS `glink` (
383 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
384 `cid` int(11) NOT NULL,
385 `uid` int(11) NOT NULL,
386 `gcid` int(11) NOT NULL,
387 `zcid` int(11) NOT NULL,
388 `updated` datetime NOT NULL,
394 KEY `updated` (`updated`)
395 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
397 -- --------------------------------------------------------
400 -- Table structure for table `group`
403 CREATE TABLE IF NOT EXISTS `group` (
404 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
405 `uid` int(10) unsigned NOT NULL,
406 `visible` tinyint(1) NOT NULL DEFAULT '0',
407 `deleted` tinyint(1) NOT NULL DEFAULT '0',
408 `name` char(255) NOT NULL,
410 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
412 -- --------------------------------------------------------
415 -- Table structure for table `group_member`
418 CREATE TABLE IF NOT EXISTS `group_member` (
419 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
420 `uid` int(10) unsigned NOT NULL,
421 `gid` int(10) unsigned NOT NULL,
422 `contact-id` int(10) unsigned NOT NULL,
424 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
426 -- --------------------------------------------------------
429 -- Table structure for table `guid`
432 CREATE TABLE IF NOT EXISTS `guid` (
433 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
434 `guid` char(64) NOT NULL,
437 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
439 -- --------------------------------------------------------
442 -- Table structure for table `hook`
445 CREATE TABLE IF NOT EXISTS `hook` (
446 `id` int(11) NOT NULL AUTO_INCREMENT,
447 `hook` char(255) NOT NULL,
448 `file` char(255) NOT NULL,
449 `function` char(255) NOT NULL,
451 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
453 -- --------------------------------------------------------
456 -- Table structure for table `intro`
459 CREATE TABLE IF NOT EXISTS `intro` (
460 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
461 `uid` int(10) unsigned NOT NULL,
462 `fid` int(11) NOT NULL DEFAULT '0',
463 `contact-id` int(11) NOT NULL,
464 `knowyou` tinyint(1) NOT NULL,
465 `duplex` tinyint(1) NOT NULL DEFAULT '0',
466 `note` text NOT NULL,
467 `hash` char(255) NOT NULL,
468 `datetime` datetime NOT NULL,
469 `blocked` tinyint(1) NOT NULL DEFAULT '1',
470 `ignore` tinyint(1) NOT NULL DEFAULT '0',
472 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
474 -- --------------------------------------------------------
477 -- Table structure for table `item`
480 CREATE TABLE IF NOT EXISTS `item` (
481 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
482 `guid` char(64) NOT NULL,
483 `uri` char(255) CHARACTER SET ascii NOT NULL,
484 `uid` int(10) unsigned NOT NULL DEFAULT '0',
485 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
486 `type` char(255) NOT NULL,
487 `wall` tinyint(1) NOT NULL DEFAULT '0',
488 `gravity` tinyint(1) NOT NULL DEFAULT '0',
489 `parent` int(10) unsigned NOT NULL DEFAULT '0',
490 `parent-uri` char(255) CHARACTER SET ascii NOT NULL,
491 `extid` char(255) NOT NULL,
492 `thr-parent` char(255) NOT NULL,
493 `created` datetime NOT NULL,
494 `edited` datetime NOT NULL,
495 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
496 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
497 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
498 `owner-name` char(255) NOT NULL,
499 `owner-link` char(255) NOT NULL,
500 `owner-avatar` char(255) NOT NULL,
501 `author-name` char(255) NOT NULL,
502 `author-link` char(255) NOT NULL,
503 `author-avatar` char(255) NOT NULL,
504 `title` char(255) NOT NULL,
505 `body` mediumtext NOT NULL,
506 `app` char(255) NOT NULL,
507 `verb` char(255) NOT NULL,
508 `object-type` char(255) NOT NULL,
509 `object` text NOT NULL,
510 `target-type` char(255) NOT NULL,
511 `target` text NOT NULL,
512 `postopts` text NOT NULL,
513 `plink` char(255) NOT NULL,
514 `resource-id` char(255) NOT NULL,
515 `event-id` int(11) NOT NULL,
516 `tag` mediumtext NOT NULL,
517 `attach` mediumtext NOT NULL,
518 `inform` mediumtext NOT NULL,
519 `file` mediumtext NOT NULL,
520 `location` char(255) NOT NULL,
521 `coord` char(255) NOT NULL,
522 `allow_cid` mediumtext NOT NULL,
523 `allow_gid` mediumtext NOT NULL,
524 `deny_cid` mediumtext NOT NULL,
525 `deny_gid` mediumtext NOT NULL,
526 `private` tinyint(1) NOT NULL DEFAULT '0',
527 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
528 `moderated` tinyint(1) NOT NULL DEFAULT '0',
529 `visible` tinyint(1) NOT NULL DEFAULT '0',
530 `spam` tinyint(1) NOT NULL DEFAULT '0',
531 `starred` tinyint(1) NOT NULL DEFAULT '0',
532 `bookmark` tinyint(1) NOT NULL DEFAULT '0',
533 `unseen` tinyint(1) NOT NULL DEFAULT '1',
534 `deleted` tinyint(1) NOT NULL DEFAULT '0',
535 `origin` tinyint(1) NOT NULL DEFAULT '0',
536 `forum_mode` tinyint(1) NOT NULL DEFAULT '0',
537 `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
541 KEY `contact-id` (`contact-id`),
543 KEY `parent` (`parent`),
544 KEY `parent-uri` (`parent-uri`),
545 KEY `created` (`created`),
546 KEY `edited` (`edited`),
547 KEY `visible` (`visible`),
548 KEY `deleted` (`deleted`),
549 KEY `last-child` (`last-child`),
550 KEY `unseen` (`unseen`),
551 KEY `extid` (`extid`),
552 KEY `received` (`received`),
553 KEY `starred` (`starred`),
555 KEY `origin` (`origin`),
557 KEY `forum_mode` (`forum_mode`),
558 KEY `author-link` (`author-link`),
559 KEY `bookmark` (`bookmark`),
560 KEY `moderated` (`moderated`),
562 KEY `author-name` (`author-name`),
563 FULLTEXT KEY `title` (`title`),
564 FULLTEXT KEY `body` (`body`),
565 FULLTEXT KEY `allow_cid` (`allow_cid`),
566 FULLTEXT KEY `allow_gid` (`allow_gid`),
567 FULLTEXT KEY `deny_cid` (`deny_cid`),
568 FULLTEXT KEY `deny_gid` (`deny_gid`),
569 FULLTEXT KEY `tag` (`tag`),
570 FULLTEXT KEY `file` (`file`)
571 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
573 -- --------------------------------------------------------
576 -- Table structure for table `item_id`
579 CREATE TABLE IF NOT EXISTS `item_id` (
580 `iid` int(11) NOT NULL,
581 `uid` int(11) NOT NULL,
582 `sid` char(255) NOT NULL,
583 `service` char(255) NOT NULL,
587 KEY `service` (`service`)
588 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
590 -- --------------------------------------------------------
593 -- Table structure for table `mail`
596 CREATE TABLE IF NOT EXISTS `mail` (
597 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
598 `uid` int(10) unsigned NOT NULL,
599 `guid` char(64) NOT NULL,
600 `from-name` char(255) NOT NULL,
601 `from-photo` char(255) NOT NULL,
602 `from-url` char(255) NOT NULL,
603 `contact-id` char(255) NOT NULL,
604 `convid` int(11) NOT NULL,
605 `title` char(255) NOT NULL,
606 `body` mediumtext NOT NULL,
607 `seen` tinyint(1) NOT NULL,
608 `reply` tinyint(1) NOT NULL DEFAULT '0',
609 `replied` tinyint(1) NOT NULL,
610 `unknown` tinyint(1) NOT NULL DEFAULT '0',
611 `uri` char(255) NOT NULL,
612 `parent-uri` char(255) NOT NULL,
613 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
615 KEY `reply` (`reply`),
620 KEY `parent-uri` (`parent-uri`),
621 KEY `created` (`created`),
622 KEY `convid` (`convid`),
623 KEY `unknown` (`unknown`)
624 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
626 -- --------------------------------------------------------
629 -- Table structure for table `mailacct`
632 CREATE TABLE IF NOT EXISTS `mailacct` (
633 `id` int(11) NOT NULL AUTO_INCREMENT,
634 `uid` int(11) NOT NULL,
635 `server` char(255) NOT NULL,
636 `port` int(11) NOT NULL,
637 `ssltype` char(16) NOT NULL,
638 `mailbox` char(255) NOT NULL,
639 `user` char(255) NOT NULL,
640 `pass` text NOT NULL,
641 `action` int(11) NOT NULL,
642 `movetofolder` char(255) NOT NULL,
643 `reply_to` char(255) NOT NULL,
644 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
645 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
647 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
649 -- --------------------------------------------------------
652 -- Table structure for table `manage`
655 CREATE TABLE IF NOT EXISTS `manage` (
656 `id` int(11) NOT NULL AUTO_INCREMENT,
657 `uid` int(11) NOT NULL,
658 `mid` int(11) NOT NULL,
662 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
664 -- --------------------------------------------------------
667 -- Table structure for table `notify`
670 CREATE TABLE IF NOT EXISTS `notify` (
671 `id` int(11) NOT NULL AUTO_INCREMENT,
672 `hash` char(64) NOT NULL,
673 `name` char(255) NOT NULL,
674 `url` char(255) NOT NULL,
675 `photo` char(255) NOT NULL,
676 `date` datetime NOT NULL,
677 `msg` mediumtext NOT NULL,
678 `uid` int(11) NOT NULL,
679 `link` char(255) NOT NULL,
680 `parent` int(11) NOT NULL,
681 `seen` tinyint(1) NOT NULL DEFAULT '0',
682 `type` int(11) NOT NULL,
683 `verb` char(255) NOT NULL,
684 `otype` char(16) NOT NULL,
691 KEY `parent` (`parent`),
693 KEY `otype` (`otype`)
694 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
696 -- --------------------------------------------------------
699 -- Table structure for table `notify-threads`
702 CREATE TABLE IF NOT EXISTS `notify-threads` (
703 `id` int(11) NOT NULL AUTO_INCREMENT,
704 `notify-id` int(11) NOT NULL,
705 `master-parent-item` int(10) unsigned NOT NULL DEFAULT '0',
706 `parent-item` int(10) unsigned NOT NULL DEFAULT '0',
707 `receiver-uid` int(11) NOT NULL,
709 KEY `master-parent-item` (`master-parent-item`),
710 KEY `receiver-uid` (`receiver-uid`)
711 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
713 -- --------------------------------------------------------
716 -- Table structure for table `pconfig`
719 CREATE TABLE IF NOT EXISTS `pconfig` (
720 `id` int(11) NOT NULL AUTO_INCREMENT,
721 `uid` int(11) NOT NULL DEFAULT '0',
722 `cat` char(255) CHARACTER SET ascii NOT NULL,
723 `k` char(255) CHARACTER SET ascii NOT NULL,
724 `v` mediumtext NOT NULL,
726 UNIQUE KEY `access` (`uid`,`cat`,`k`)
727 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
729 -- --------------------------------------------------------
732 -- Table structure for table `photo`
735 CREATE TABLE IF NOT EXISTS `photo` (
736 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
737 `uid` int(10) unsigned NOT NULL,
738 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
739 `guid` char(64) NOT NULL,
740 `resource-id` char(255) NOT NULL,
741 `created` datetime NOT NULL,
742 `edited` datetime NOT NULL,
743 `title` char(255) NOT NULL,
744 `desc` text NOT NULL,
745 `album` char(255) NOT NULL,
746 `filename` char(255) NOT NULL,
747 `height` smallint(6) NOT NULL,
748 `width` smallint(6) NOT NULL,
749 `data` mediumblob NOT NULL,
750 `scale` tinyint(3) NOT NULL,
751 `profile` tinyint(1) NOT NULL DEFAULT '0',
752 `allow_cid` mediumtext NOT NULL,
753 `allow_gid` mediumtext NOT NULL,
754 `deny_cid` mediumtext NOT NULL,
755 `deny_gid` mediumtext NOT NULL,
758 KEY `resource-id` (`resource-id`),
759 KEY `album` (`album`),
760 KEY `scale` (`scale`),
761 KEY `profile` (`profile`)
762 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
764 -- --------------------------------------------------------
767 -- Table structure for table `poll`
770 CREATE TABLE IF NOT EXISTS `poll` (
771 `id` int(11) NOT NULL AUTO_INCREMENT,
772 `uid` int(11) NOT NULL,
773 `q0` mediumtext NOT NULL,
774 `q1` mediumtext NOT NULL,
775 `q2` mediumtext NOT NULL,
776 `q3` mediumtext NOT NULL,
777 `q4` mediumtext NOT NULL,
778 `q5` mediumtext NOT NULL,
779 `q6` mediumtext NOT NULL,
780 `q7` mediumtext NOT NULL,
781 `q8` mediumtext NOT NULL,
782 `q9` mediumtext NOT NULL,
785 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
787 -- --------------------------------------------------------
790 -- Table structure for table `poll_result`
793 CREATE TABLE IF NOT EXISTS `poll_result` (
794 `id` int(11) NOT NULL AUTO_INCREMENT,
795 `poll_id` int(11) NOT NULL,
796 `choice` int(11) NOT NULL,
798 KEY `poll_id` (`poll_id`),
799 KEY `choice` (`choice`)
800 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
802 -- --------------------------------------------------------
805 -- Table structure for table `profile`
808 CREATE TABLE IF NOT EXISTS `profile` (
809 `id` int(11) NOT NULL AUTO_INCREMENT,
810 `uid` int(11) NOT NULL,
811 `profile-name` char(255) NOT NULL,
812 `is-default` tinyint(1) NOT NULL DEFAULT '0',
813 `hide-friends` tinyint(1) NOT NULL DEFAULT '0',
814 `name` char(255) NOT NULL,
815 `pdesc` char(255) NOT NULL,
816 `dob` char(32) NOT NULL DEFAULT '0000-00-00',
817 `address` char(255) NOT NULL,
818 `locality` char(255) NOT NULL,
819 `region` char(255) NOT NULL,
820 `postal-code` char(32) NOT NULL,
821 `country-name` char(255) NOT NULL,
822 `gender` char(32) NOT NULL,
823 `marital` char(255) NOT NULL,
824 `with` text NOT NULL,
825 `sexual` char(255) NOT NULL,
826 `politic` char(255) NOT NULL,
827 `religion` char(255) NOT NULL,
828 `pub_keywords` text NOT NULL,
829 `prv_keywords` text NOT NULL,
830 `about` text NOT NULL,
831 `summary` char(255) NOT NULL,
832 `music` text NOT NULL,
833 `book` text NOT NULL,
835 `film` text NOT NULL,
836 `interest` text NOT NULL,
837 `romance` text NOT NULL,
838 `work` text NOT NULL,
839 `education` text NOT NULL,
840 `contact` text NOT NULL,
841 `homepage` char(255) NOT NULL,
842 `photo` char(255) NOT NULL,
843 `thumb` char(255) NOT NULL,
844 `publish` tinyint(1) NOT NULL DEFAULT '0',
845 `net-publish` tinyint(1) NOT NULL DEFAULT '0',
847 FULLTEXT KEY `pub_keywords` (`pub_keywords`),
848 FULLTEXT KEY `prv_keywords` (`prv_keywords`)
849 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
851 -- --------------------------------------------------------
854 -- Table structure for table `profile_check`
857 CREATE TABLE IF NOT EXISTS `profile_check` (
858 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
859 `uid` int(10) unsigned NOT NULL,
860 `cid` int(10) unsigned NOT NULL DEFAULT '0',
861 `dfrn_id` char(255) NOT NULL,
862 `sec` char(255) NOT NULL,
863 `expire` int(11) NOT NULL,
865 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
867 -- --------------------------------------------------------
870 -- Table structure for table `queue`
873 CREATE TABLE IF NOT EXISTS `queue` (
874 `id` int(11) NOT NULL AUTO_INCREMENT,
875 `cid` int(11) NOT NULL,
876 `network` char(32) NOT NULL,
877 `created` datetime NOT NULL,
878 `last` datetime NOT NULL,
879 `content` mediumtext NOT NULL,
880 `batch` tinyint(1) NOT NULL DEFAULT '0',
883 KEY `network` (`network`),
884 KEY `created` (`created`),
886 KEY `batch` (`batch`)
887 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
889 -- --------------------------------------------------------
892 -- Table structure for table `register`
895 CREATE TABLE IF NOT EXISTS `register` (
896 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
897 `hash` char(255) NOT NULL,
898 `created` datetime NOT NULL,
899 `uid` int(10) unsigned NOT NULL,
900 `password` char(255) NOT NULL,
901 `language` char(16) NOT NULL,
903 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
905 -- --------------------------------------------------------
908 -- Table structure for table `search`
911 CREATE TABLE IF NOT EXISTS `search` (
912 `id` int(11) NOT NULL AUTO_INCREMENT,
913 `uid` int(11) NOT NULL,
914 `term` char(255) NOT NULL,
918 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
920 -- --------------------------------------------------------
923 -- Table structure for table `session`
926 CREATE TABLE IF NOT EXISTS `session` (
927 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
928 `sid` char(255) NOT NULL,
929 `data` text NOT NULL,
930 `expire` int(10) unsigned NOT NULL,
933 KEY `expire` (`expire`)
934 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
936 -- --------------------------------------------------------
939 -- Table structure for table `sign`
942 CREATE TABLE IF NOT EXISTS `sign` (
943 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
944 `iid` int(10) unsigned NOT NULL,
945 `signed_text` mediumtext NOT NULL,
946 `signature` text NOT NULL,
947 `signer` char(255) NOT NULL,
950 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
952 -- --------------------------------------------------------
955 -- Table structure for table `spam`
958 CREATE TABLE IF NOT EXISTS `spam` (
959 `id` int(11) NOT NULL AUTO_INCREMENT,
960 `uid` int(11) NOT NULL,
961 `spam` int(11) NOT NULL DEFAULT '0',
962 `ham` int(11) NOT NULL DEFAULT '0',
963 `term` char(255) NOT NULL,
964 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
970 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
972 -- --------------------------------------------------------
975 -- Table structure for table `tokens`
978 CREATE TABLE IF NOT EXISTS `tokens` (
979 `id` varchar(40) NOT NULL,
980 `secret` text NOT NULL,
981 `client_id` varchar(20) NOT NULL,
982 `expires` int(11) NOT NULL,
983 `scope` varchar(200) NOT NULL,
984 `uid` int(11) NOT NULL,
986 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
988 -- --------------------------------------------------------
991 -- Table structure for table `user`
994 CREATE TABLE IF NOT EXISTS `user` (
995 `uid` int(11) NOT NULL AUTO_INCREMENT,
996 `guid` char(16) NOT NULL,
997 `username` char(255) NOT NULL,
998 `password` char(255) NOT NULL,
999 `nickname` char(255) NOT NULL,
1000 `email` char(255) NOT NULL,
1001 `openid` char(255) NOT NULL,
1002 `timezone` char(128) NOT NULL,
1003 `language` char(16) NOT NULL DEFAULT 'en',
1004 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1005 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1006 `default-location` char(255) NOT NULL,
1007 `allow_location` tinyint(1) NOT NULL DEFAULT '0',
1008 `theme` char(255) NOT NULL,
1009 `pubkey` text NOT NULL,
1010 `prvkey` text NOT NULL,
1011 `spubkey` text NOT NULL,
1012 `sprvkey` text NOT NULL,
1013 `verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
1014 `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
1015 `blockwall` tinyint(1) NOT NULL DEFAULT '0',
1016 `hidewall` tinyint(1) NOT NULL DEFAULT '0',
1017 `blocktags` tinyint(1) NOT NULL DEFAULT '0',
1018 `unkmail` tinyint(1) NOT NULL DEFAULT '0',
1019 `cntunkmail` int(11) NOT NULL DEFAULT '10',
1020 `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535',
1021 `page-flags` int(11) NOT NULL DEFAULT '0',
1022 `prvnets` tinyint(1) NOT NULL DEFAULT '0',
1023 `pwdreset` char(255) NOT NULL,
1024 `maxreq` int(11) NOT NULL DEFAULT '10',
1025 `expire` int(10) unsigned NOT NULL DEFAULT '0',
1026 `account_removed` tinyint(1) NOT NULL DEFAULT '0',
1027 `account_expired` tinyint(1) NOT NULL DEFAULT '0',
1028 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1029 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1030 `service_class` char(32) NOT NULL,
1031 `def_gid` int(11) NOT NULL DEFAULT '0',
1032 `allow_cid` mediumtext NOT NULL,
1033 `allow_gid` mediumtext NOT NULL,
1034 `deny_cid` mediumtext NOT NULL,
1035 `deny_gid` mediumtext NOT NULL,
1036 `openidserver` text NOT NULL,
1037 PRIMARY KEY (`uid`),
1038 KEY `nickname` (`nickname`),
1039 KEY `login_date` (`login_date`),
1040 KEY `account_expired` (`account_expired`),
1041 KEY `hidewall` (`hidewall`),
1042 KEY `blockwall` (`blockwall`),
1043 KEY `blocked` (`blocked`),
1044 KEY `verified` (`verified`),
1045 KEY `unkmail` (`unkmail`),
1046 KEY `cntunkmail` (`cntunkmail`),
1047 KEY `account_removed` (`account_removed`),
1048 KEY `service_class` (`service_class`)
1049 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1051 -- --------------------------------------------------------
1054 -- Table structure for table `userd`
1057 CREATE TABLE IF NOT EXISTS `userd` (
1058 `id` int(11) NOT NULL AUTO_INCREMENT,
1059 `username` char(255) NOT NULL,
1061 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;