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 `event`
248 CREATE TABLE IF NOT EXISTS `event` (
249 `id` int(11) NOT NULL AUTO_INCREMENT,
250 `uid` int(11) NOT NULL,
251 `cid` int(11) NOT NULL,
252 `uri` char(255) NOT NULL,
253 `created` datetime NOT NULL,
254 `edited` datetime NOT NULL,
255 `start` datetime NOT NULL,
256 `finish` datetime NOT NULL,
257 `desc` text NOT NULL,
258 `location` text NOT NULL,
259 `type` char(255) NOT NULL,
260 `nofinish` tinyint(1) NOT NULL DEFAULT '0',
261 `adjust` tinyint(1) NOT NULL DEFAULT '1',
262 `allow_cid` mediumtext NOT NULL,
263 `allow_gid` mediumtext NOT NULL,
264 `deny_cid` mediumtext NOT NULL,
265 `deny_gid` mediumtext NOT NULL,
267 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
269 -- --------------------------------------------------------
272 -- Table structure for table `fcontact`
275 CREATE TABLE IF NOT EXISTS `fcontact` (
276 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
277 `url` char(255) NOT NULL,
278 `name` char(255) NOT NULL,
279 `photo` char(255) NOT NULL,
280 `request` char(255) NOT NULL,
281 `nick` char(255) NOT NULL,
282 `addr` char(255) NOT NULL,
283 `batch` char(255) NOT NULL,
284 `notify` char(255) NOT NULL,
285 `poll` char(255) NOT NULL,
286 `confirm` char(255) NOT NULL,
287 `priority` tinyint(1) NOT NULL,
288 `network` char(32) NOT NULL,
289 `alias` char(255) NOT NULL,
290 `pubkey` text NOT NULL,
291 `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
294 KEY `network` (`network`)
295 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
297 -- --------------------------------------------------------
300 -- Table structure for table `ffinder`
303 CREATE TABLE IF NOT EXISTS `ffinder` (
304 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
305 `uid` int(10) unsigned NOT NULL,
306 `cid` int(10) unsigned NOT NULL,
307 `fid` int(10) unsigned NOT NULL,
309 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
311 -- --------------------------------------------------------
314 -- Table structure for table `fserver`
317 CREATE TABLE IF NOT EXISTS `fserver` (
318 `id` int(11) NOT NULL AUTO_INCREMENT,
319 `server` char(255) NOT NULL,
320 `posturl` char(255) NOT NULL,
323 KEY `server` (`server`)
324 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
326 -- --------------------------------------------------------
329 -- Table structure for table `fsuggest`
332 CREATE TABLE IF NOT EXISTS `fsuggest` (
333 `id` int(11) NOT NULL AUTO_INCREMENT,
334 `uid` int(11) NOT NULL,
335 `cid` int(11) NOT NULL,
336 `name` char(255) NOT NULL,
337 `url` char(255) NOT NULL,
338 `request` char(255) NOT NULL,
339 `photo` char(255) NOT NULL,
340 `note` text NOT NULL,
341 `created` datetime NOT NULL,
343 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
345 -- --------------------------------------------------------
348 -- Table structure for table `gcign`
351 CREATE TABLE IF NOT EXISTS `gcign` (
352 `id` int(11) NOT NULL AUTO_INCREMENT,
353 `uid` int(11) NOT NULL,
354 `gcid` int(11) NOT NULL,
358 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
360 -- --------------------------------------------------------
363 -- Table structure for table `gcontact`
366 CREATE TABLE IF NOT EXISTS `gcontact` (
367 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
368 `name` char(255) NOT NULL,
369 `url` char(255) NOT NULL,
370 `nurl` char(255) NOT NULL,
371 `photo` char(255) NOT NULL,
372 `connect` char(255) NOT NULL,
375 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
377 -- --------------------------------------------------------
380 -- Table structure for table `glink`
383 CREATE TABLE IF NOT EXISTS `glink` (
384 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
385 `cid` int(11) NOT NULL,
386 `uid` int(11) NOT NULL,
387 `gcid` int(11) NOT NULL,
388 `zcid` int(11) NOT NULL,
389 `updated` datetime NOT NULL,
395 KEY `updated` (`updated`)
396 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
398 -- --------------------------------------------------------
401 -- Table structure for table `group`
404 CREATE TABLE IF NOT EXISTS `group` (
405 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
406 `uid` int(10) unsigned NOT NULL,
407 `visible` tinyint(1) NOT NULL DEFAULT '0',
408 `deleted` tinyint(1) NOT NULL DEFAULT '0',
409 `name` char(255) NOT NULL,
411 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
413 -- --------------------------------------------------------
416 -- Table structure for table `group_member`
419 CREATE TABLE IF NOT EXISTS `group_member` (
420 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
421 `uid` int(10) unsigned NOT NULL,
422 `gid` int(10) unsigned NOT NULL,
423 `contact-id` int(10) unsigned NOT NULL,
425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
427 -- --------------------------------------------------------
430 -- Table structure for table `guid`
433 CREATE TABLE IF NOT EXISTS `guid` (
434 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
435 `guid` char(64) NOT NULL,
438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
440 -- --------------------------------------------------------
443 -- Table structure for table `hook`
446 CREATE TABLE IF NOT EXISTS `hook` (
447 `id` int(11) NOT NULL AUTO_INCREMENT,
448 `hook` char(255) NOT NULL,
449 `file` char(255) NOT NULL,
450 `function` char(255) NOT NULL,
452 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
454 -- --------------------------------------------------------
457 -- Table structure for table `intro`
460 CREATE TABLE IF NOT EXISTS `intro` (
461 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
462 `uid` int(10) unsigned NOT NULL,
463 `fid` int(11) NOT NULL DEFAULT '0',
464 `contact-id` int(11) NOT NULL,
465 `knowyou` tinyint(1) NOT NULL,
466 `duplex` tinyint(1) NOT NULL DEFAULT '0',
467 `note` text NOT NULL,
468 `hash` char(255) NOT NULL,
469 `datetime` datetime NOT NULL,
470 `blocked` tinyint(1) NOT NULL DEFAULT '1',
471 `ignore` tinyint(1) NOT NULL DEFAULT '0',
473 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
475 -- --------------------------------------------------------
478 -- Table structure for table `item`
481 CREATE TABLE IF NOT EXISTS `item` (
482 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
483 `guid` char(64) NOT NULL,
484 `uri` char(255) CHARACTER SET ascii NOT NULL,
485 `uid` int(10) unsigned NOT NULL DEFAULT '0',
486 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
487 `type` char(255) NOT NULL,
488 `wall` tinyint(1) NOT NULL DEFAULT '0',
489 `gravity` tinyint(1) NOT NULL DEFAULT '0',
490 `parent` int(10) unsigned NOT NULL DEFAULT '0',
491 `parent-uri` char(255) CHARACTER SET ascii NOT NULL,
492 `extid` char(255) NOT NULL,
493 `thr-parent` char(255) NOT NULL,
494 `created` datetime NOT NULL,
495 `edited` datetime NOT NULL,
496 `commented` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
497 `received` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
498 `changed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
499 `owner-name` char(255) NOT NULL,
500 `owner-link` char(255) NOT NULL,
501 `owner-avatar` char(255) NOT NULL,
502 `author-name` char(255) NOT NULL,
503 `author-link` char(255) NOT NULL,
504 `author-avatar` char(255) NOT NULL,
505 `title` char(255) NOT NULL,
506 `body` mediumtext NOT NULL,
507 `app` char(255) NOT NULL,
508 `verb` char(255) NOT NULL,
509 `object-type` char(255) NOT NULL,
510 `object` text NOT NULL,
511 `target-type` char(255) NOT NULL,
512 `target` text NOT NULL,
513 `postopts` text NOT NULL,
514 `plink` char(255) NOT NULL,
515 `resource-id` char(255) NOT NULL,
516 `event-id` int(11) NOT NULL,
517 `tag` mediumtext NOT NULL,
518 `attach` mediumtext NOT NULL,
519 `inform` mediumtext NOT NULL,
520 `file` mediumtext NOT NULL,
521 `location` char(255) NOT NULL,
522 `coord` char(255) NOT NULL,
523 `allow_cid` mediumtext NOT NULL,
524 `allow_gid` mediumtext NOT NULL,
525 `deny_cid` mediumtext NOT NULL,
526 `deny_gid` mediumtext NOT NULL,
527 `private` tinyint(1) NOT NULL DEFAULT '0',
528 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
529 `moderated` tinyint(1) NOT NULL DEFAULT '0',
530 `visible` tinyint(1) NOT NULL DEFAULT '0',
531 `spam` tinyint(1) NOT NULL DEFAULT '0',
532 `starred` tinyint(1) NOT NULL DEFAULT '0',
533 `bookmark` tinyint(1) NOT NULL DEFAULT '0',
534 `unseen` tinyint(1) NOT NULL DEFAULT '1',
535 `deleted` tinyint(1) NOT NULL DEFAULT '0',
536 `origin` tinyint(1) NOT NULL DEFAULT '0',
537 `forum_mode` tinyint(1) NOT NULL DEFAULT '0',
538 `last-child` tinyint(1) unsigned NOT NULL DEFAULT '1',
542 KEY `contact-id` (`contact-id`),
544 KEY `parent` (`parent`),
545 KEY `parent-uri` (`parent-uri`),
546 KEY `created` (`created`),
547 KEY `edited` (`edited`),
548 KEY `visible` (`visible`),
549 KEY `deleted` (`deleted`),
550 KEY `last-child` (`last-child`),
551 KEY `unseen` (`unseen`),
552 KEY `extid` (`extid`),
553 KEY `received` (`received`),
554 KEY `starred` (`starred`),
556 KEY `origin` (`origin`),
558 KEY `forum_mode` (`forum_mode`),
559 KEY `author-link` (`author-link`),
560 KEY `bookmark` (`bookmark`),
561 KEY `moderated` (`moderated`),
563 KEY `author-name` (`author-name`),
564 FULLTEXT KEY `title` (`title`),
565 FULLTEXT KEY `body` (`body`),
566 FULLTEXT KEY `allow_cid` (`allow_cid`),
567 FULLTEXT KEY `allow_gid` (`allow_gid`),
568 FULLTEXT KEY `deny_cid` (`deny_cid`),
569 FULLTEXT KEY `deny_gid` (`deny_gid`),
570 FULLTEXT KEY `tag` (`tag`),
571 FULLTEXT KEY `file` (`file`)
572 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
574 -- --------------------------------------------------------
577 -- Table structure for table `item_id`
580 CREATE TABLE IF NOT EXISTS `item_id` (
581 `iid` int(11) NOT NULL,
582 `uid` int(11) NOT NULL,
583 `sid` char(255) NOT NULL,
584 `service` char(255) NOT NULL,
588 KEY `service` (`service`)
589 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
591 -- --------------------------------------------------------
594 -- Table structure for table `mail`
597 CREATE TABLE IF NOT EXISTS `mail` (
598 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
599 `uid` int(10) unsigned NOT NULL,
600 `guid` char(64) NOT NULL,
601 `from-name` char(255) NOT NULL,
602 `from-photo` char(255) NOT NULL,
603 `from-url` char(255) NOT NULL,
604 `contact-id` char(255) NOT NULL,
605 `convid` int(11) NOT NULL,
606 `title` char(255) NOT NULL,
607 `body` mediumtext NOT NULL,
608 `seen` tinyint(1) NOT NULL,
609 `reply` tinyint(1) NOT NULL DEFAULT '0',
610 `replied` tinyint(1) NOT NULL,
611 `unknown` tinyint(1) NOT NULL DEFAULT '0',
612 `uri` char(255) NOT NULL,
613 `parent-uri` char(255) NOT NULL,
614 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
616 KEY `reply` (`reply`),
621 KEY `parent-uri` (`parent-uri`),
622 KEY `created` (`created`),
623 KEY `convid` (`convid`),
624 KEY `unknown` (`unknown`)
625 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
627 -- --------------------------------------------------------
630 -- Table structure for table `mailacct`
633 CREATE TABLE IF NOT EXISTS `mailacct` (
634 `id` int(11) NOT NULL AUTO_INCREMENT,
635 `uid` int(11) NOT NULL,
636 `server` char(255) NOT NULL,
637 `port` int(11) NOT NULL,
638 `ssltype` char(16) NOT NULL,
639 `mailbox` char(255) NOT NULL,
640 `user` char(255) NOT NULL,
641 `pass` text NOT NULL,
642 `action` int(11) NOT NULL,
643 `movetofolder` char(255) NOT NULL,
644 `reply_to` char(255) NOT NULL,
645 `pubmail` tinyint(1) NOT NULL DEFAULT '0',
646 `last_check` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
648 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
650 -- --------------------------------------------------------
653 -- Table structure for table `manage`
656 CREATE TABLE IF NOT EXISTS `manage` (
657 `id` int(11) NOT NULL AUTO_INCREMENT,
658 `uid` int(11) NOT NULL,
659 `mid` int(11) NOT NULL,
663 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
665 -- --------------------------------------------------------
668 -- Table structure for table `notify`
671 CREATE TABLE IF NOT EXISTS `notify` (
672 `id` int(11) NOT NULL AUTO_INCREMENT,
673 `hash` char(64) NOT NULL,
674 `name` char(255) NOT NULL,
675 `url` char(255) NOT NULL,
676 `photo` char(255) NOT NULL,
677 `date` datetime NOT NULL,
678 `msg` mediumtext NOT NULL,
679 `uid` int(11) NOT NULL,
680 `link` char(255) NOT NULL,
681 `parent` int(11) NOT NULL,
682 `seen` tinyint(1) NOT NULL DEFAULT '0',
683 `type` int(11) NOT NULL,
684 `verb` char(255) NOT NULL,
685 `otype` char(16) NOT NULL,
692 KEY `parent` (`parent`),
694 KEY `otype` (`otype`)
695 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
697 -- --------------------------------------------------------
700 -- Table structure for table `notify-threads`
703 CREATE TABLE IF NOT EXISTS `notify-threads` (
704 `id` int(11) NOT NULL AUTO_INCREMENT,
705 `notify-id` int(11) NOT NULL,
706 `master-parent-item` int(10) unsigned NOT NULL DEFAULT '0',
707 `parent-item` int(10) unsigned NOT NULL DEFAULT '0',
708 `receiver-uid` int(11) NOT NULL,
710 KEY `master-parent-item` (`master-parent-item`),
711 KEY `receiver-uid` (`receiver-uid`)
712 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
714 -- --------------------------------------------------------
717 -- Table structure for table `pconfig`
720 CREATE TABLE IF NOT EXISTS `pconfig` (
721 `id` int(11) NOT NULL AUTO_INCREMENT,
722 `uid` int(11) NOT NULL DEFAULT '0',
723 `cat` char(255) CHARACTER SET ascii NOT NULL,
724 `k` char(255) CHARACTER SET ascii NOT NULL,
725 `v` mediumtext NOT NULL,
727 UNIQUE KEY `access` (`uid`,`cat`,`k`)
728 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
730 -- --------------------------------------------------------
733 -- Table structure for table `photo`
736 CREATE TABLE IF NOT EXISTS `photo` (
737 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
738 `uid` int(10) unsigned NOT NULL,
739 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
740 `guid` char(64) NOT NULL,
741 `resource-id` char(255) NOT NULL,
742 `created` datetime NOT NULL,
743 `edited` datetime NOT NULL,
744 `title` char(255) NOT NULL,
745 `desc` text NOT NULL,
746 `album` char(255) NOT NULL,
747 `filename` char(255) NOT NULL,
748 `type` CHAR(128) NOT NULL DEFAULT 'image/jpeg',
749 `height` smallint(6) NOT NULL,
750 `width` smallint(6) NOT NULL,
751 `data` mediumblob NOT NULL,
752 `scale` tinyint(3) NOT NULL,
753 `profile` tinyint(1) NOT NULL DEFAULT '0',
754 `allow_cid` mediumtext NOT NULL,
755 `allow_gid` mediumtext NOT NULL,
756 `deny_cid` mediumtext NOT NULL,
757 `deny_gid` mediumtext NOT NULL,
760 KEY `resource-id` (`resource-id`),
761 KEY `album` (`album`),
762 KEY `scale` (`scale`),
763 KEY `profile` (`profile`)
764 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
766 -- --------------------------------------------------------
769 -- Table structure for table `poll`
772 CREATE TABLE IF NOT EXISTS `poll` (
773 `id` int(11) NOT NULL AUTO_INCREMENT,
774 `uid` int(11) NOT NULL,
775 `q0` mediumtext NOT NULL,
776 `q1` mediumtext NOT NULL,
777 `q2` mediumtext NOT NULL,
778 `q3` mediumtext NOT NULL,
779 `q4` mediumtext NOT NULL,
780 `q5` mediumtext NOT NULL,
781 `q6` mediumtext NOT NULL,
782 `q7` mediumtext NOT NULL,
783 `q8` mediumtext NOT NULL,
784 `q9` mediumtext NOT NULL,
787 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
789 -- --------------------------------------------------------
792 -- Table structure for table `poll_result`
795 CREATE TABLE IF NOT EXISTS `poll_result` (
796 `id` int(11) NOT NULL AUTO_INCREMENT,
797 `poll_id` int(11) NOT NULL,
798 `choice` int(11) NOT NULL,
800 KEY `poll_id` (`poll_id`),
801 KEY `choice` (`choice`)
802 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
804 -- --------------------------------------------------------
807 -- Table structure for table `profile`
810 CREATE TABLE IF NOT EXISTS `profile` (
811 `id` int(11) NOT NULL AUTO_INCREMENT,
812 `uid` int(11) NOT NULL,
813 `profile-name` char(255) NOT NULL,
814 `is-default` tinyint(1) NOT NULL DEFAULT '0',
815 `hide-friends` tinyint(1) NOT NULL DEFAULT '0',
816 `name` char(255) NOT NULL,
817 `pdesc` char(255) NOT NULL,
818 `dob` char(32) NOT NULL DEFAULT '0000-00-00',
819 `address` char(255) NOT NULL,
820 `locality` char(255) NOT NULL,
821 `region` char(255) NOT NULL,
822 `postal-code` char(32) NOT NULL,
823 `country-name` char(255) NOT NULL,
824 `hometown` char(255) NOT NULL,
825 `gender` char(32) NOT NULL,
826 `marital` char(255) NOT NULL,
827 `with` text NOT NULL,
828 `howlong` datetime NOT NULL default '0000-00-00 00:00:00',
829 `sexual` char(255) NOT NULL,
830 `politic` char(255) NOT NULL,
831 `religion` char(255) NOT NULL,
832 `pub_keywords` text NOT NULL,
833 `prv_keywords` text NOT NULL,
834 `about` text NOT NULL,
835 `summary` char(255) NOT NULL,
836 `music` text NOT NULL,
837 `book` text NOT NULL,
839 `film` text NOT NULL,
840 `interest` text NOT NULL,
841 `romance` text NOT NULL,
842 `work` text NOT NULL,
843 `education` text NOT NULL,
844 `contact` text NOT NULL,
845 `homepage` char(255) NOT NULL,
846 `photo` char(255) NOT NULL,
847 `thumb` char(255) NOT NULL,
848 `publish` tinyint(1) NOT NULL DEFAULT '0',
849 `net-publish` tinyint(1) NOT NULL DEFAULT '0',
851 FULLTEXT KEY `pub_keywords` (`pub_keywords`),
852 FULLTEXT KEY `prv_keywords` (`prv_keywords`)
853 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
855 -- --------------------------------------------------------
858 -- Table structure for table `profile_check`
861 CREATE TABLE IF NOT EXISTS `profile_check` (
862 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
863 `uid` int(10) unsigned NOT NULL,
864 `cid` int(10) unsigned NOT NULL DEFAULT '0',
865 `dfrn_id` char(255) NOT NULL,
866 `sec` char(255) NOT NULL,
867 `expire` int(11) NOT NULL,
869 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
871 -- --------------------------------------------------------
874 -- Table structure for table `queue`
877 CREATE TABLE IF NOT EXISTS `queue` (
878 `id` int(11) NOT NULL AUTO_INCREMENT,
879 `cid` int(11) NOT NULL,
880 `network` char(32) NOT NULL,
881 `created` datetime NOT NULL,
882 `last` datetime NOT NULL,
883 `content` mediumtext NOT NULL,
884 `batch` tinyint(1) NOT NULL DEFAULT '0',
887 KEY `network` (`network`),
888 KEY `created` (`created`),
890 KEY `batch` (`batch`)
891 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
893 -- --------------------------------------------------------
896 -- Table structure for table `register`
899 CREATE TABLE IF NOT EXISTS `register` (
900 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
901 `hash` char(255) NOT NULL,
902 `created` datetime NOT NULL,
903 `uid` int(10) unsigned NOT NULL,
904 `password` char(255) NOT NULL,
905 `language` char(16) NOT NULL,
907 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
909 -- --------------------------------------------------------
912 -- Table structure for table `search`
915 CREATE TABLE IF NOT EXISTS `search` (
916 `id` int(11) NOT NULL AUTO_INCREMENT,
917 `uid` int(11) NOT NULL,
918 `term` char(255) NOT NULL,
922 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
924 -- --------------------------------------------------------
927 -- Table structure for table `session`
930 CREATE TABLE IF NOT EXISTS `session` (
931 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
932 `sid` char(255) NOT NULL,
933 `data` text NOT NULL,
934 `expire` int(10) unsigned NOT NULL,
937 KEY `expire` (`expire`)
938 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
940 -- --------------------------------------------------------
943 -- Table structure for table `sign`
946 CREATE TABLE IF NOT EXISTS `sign` (
947 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
948 `iid` int(10) unsigned NOT NULL DEFAULT '0',
949 `retract_iid` int(10) unsigned NOT NULL DEFAULT '0',
950 `signed_text` mediumtext NOT NULL,
951 `signature` text NOT NULL,
952 `signer` char(255) NOT NULL,
955 KEY `retract_iid` (`retract_iid`)
956 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
958 -- --------------------------------------------------------
961 -- Table structure for table `spam`
964 CREATE TABLE IF NOT EXISTS `spam` (
965 `id` int(11) NOT NULL AUTO_INCREMENT,
966 `uid` int(11) NOT NULL,
967 `spam` int(11) NOT NULL DEFAULT '0',
968 `ham` int(11) NOT NULL DEFAULT '0',
969 `term` char(255) NOT NULL,
970 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
976 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
978 -- --------------------------------------------------------
981 -- Table structure for table `tokens`
984 CREATE TABLE IF NOT EXISTS `tokens` (
985 `id` varchar(40) NOT NULL,
986 `secret` text NOT NULL,
987 `client_id` varchar(20) NOT NULL,
988 `expires` int(11) NOT NULL,
989 `scope` varchar(200) NOT NULL,
990 `uid` int(11) NOT NULL,
992 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
994 -- --------------------------------------------------------
997 -- Table structure for table `user`
1000 CREATE TABLE IF NOT EXISTS `user` (
1001 `uid` int(11) NOT NULL AUTO_INCREMENT,
1002 `guid` char(16) NOT NULL,
1003 `username` char(255) NOT NULL,
1004 `password` char(255) NOT NULL,
1005 `nickname` char(255) NOT NULL,
1006 `email` char(255) NOT NULL,
1007 `openid` char(255) NOT NULL,
1008 `timezone` char(128) NOT NULL,
1009 `language` char(16) NOT NULL DEFAULT 'en',
1010 `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1011 `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1012 `default-location` char(255) NOT NULL,
1013 `allow_location` tinyint(1) NOT NULL DEFAULT '0',
1014 `theme` char(255) NOT NULL,
1015 `pubkey` text NOT NULL,
1016 `prvkey` text NOT NULL,
1017 `spubkey` text NOT NULL,
1018 `sprvkey` text NOT NULL,
1019 `verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
1020 `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
1021 `blockwall` tinyint(1) NOT NULL DEFAULT '0',
1022 `hidewall` tinyint(1) NOT NULL DEFAULT '0',
1023 `blocktags` tinyint(1) NOT NULL DEFAULT '0',
1024 `unkmail` tinyint(1) NOT NULL DEFAULT '0',
1025 `cntunkmail` int(11) NOT NULL DEFAULT '10',
1026 `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535',
1027 `page-flags` int(11) NOT NULL DEFAULT '0',
1028 `prvnets` tinyint(1) NOT NULL DEFAULT '0',
1029 `pwdreset` char(255) NOT NULL,
1030 `maxreq` int(11) NOT NULL DEFAULT '10',
1031 `expire` int(10) unsigned NOT NULL DEFAULT '0',
1032 `account_removed` tinyint(1) NOT NULL DEFAULT '0',
1033 `account_expired` tinyint(1) NOT NULL DEFAULT '0',
1034 `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1035 `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1036 `service_class` char(32) NOT NULL,
1037 `def_gid` int(11) NOT NULL DEFAULT '0',
1038 `allow_cid` mediumtext NOT NULL,
1039 `allow_gid` mediumtext NOT NULL,
1040 `deny_cid` mediumtext NOT NULL,
1041 `deny_gid` mediumtext NOT NULL,
1042 `openidserver` text NOT NULL,
1043 PRIMARY KEY (`uid`),
1044 KEY `nickname` (`nickname`),
1045 KEY `login_date` (`login_date`),
1046 KEY `account_expired` (`account_expired`),
1047 KEY `hidewall` (`hidewall`),
1048 KEY `blockwall` (`blockwall`),
1049 KEY `blocked` (`blocked`),
1050 KEY `verified` (`verified`),
1051 KEY `unkmail` (`unkmail`),
1052 KEY `cntunkmail` (`cntunkmail`),
1053 KEY `account_removed` (`account_removed`),
1054 KEY `service_class` (`service_class`)
1055 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1057 -- --------------------------------------------------------
1060 -- Table structure for table `userd`
1063 CREATE TABLE IF NOT EXISTS `userd` (
1064 `id` int(11) NOT NULL AUTO_INCREMENT,
1065 `username` char(255) NOT NULL,
1067 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;