3 -- http://www.phpmyadmin.net
6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
9 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12 /*!40101 SET NAMES utf8 */;
17 -- --------------------------------------------------------
20 -- Table structure for table `challenge`
23 CREATE TABLE IF NOT EXISTS `challenge` (
24 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
25 `challenge` char(255) NOT NULL,
26 `dfrn-id` char(255) NOT NULL,
27 `expire` int(11) NOT NULL,
29 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
31 -- --------------------------------------------------------
34 -- Table structure for table `contact`
37 CREATE TABLE IF NOT EXISTS `contact` (
38 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `uid` int(11) NOT NULL COMMENT 'owner uid',
40 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
41 `self` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'boolean 1 == info for local UID, primarily name and photo to use in item displays.',
42 `name` char(255) NOT NULL,
43 `photo` text NOT NULL COMMENT 'remote photo URL initially until approved',
44 `thumb` text NOT NULL,
45 `site-pubkey` text NOT NULL,
46 `issued-id` char(255) NOT NULL,
47 `dfrn-id` char(255) NOT NULL,
48 `url` char(255) NOT NULL,
49 `issued-pubkey` char(255) NOT NULL,
50 `pubkey` text NOT NULL,
51 `prvkey` text NOT NULL,
52 `request` text NOT NULL,
53 `notify` text NOT NULL,
55 `confirm` text NOT NULL,
56 `aes_allow` tinyint(1) NOT NULL DEFAULT '0',
57 `ret-aes` tinyint(1) NOT NULL DEFAULT '0',
58 `ret-id` char(255) NOT NULL,
59 `ret-pubkey` text NOT NULL,
60 `priority` tinyint(3) NOT NULL,
61 `blocked` tinyint(1) NOT NULL DEFAULT '1',
62 `rating` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-5 reputation, 0 unknown, 1 call police, 5 inscrutable',
63 `reason` text NOT NULL COMMENT 'why a rating was given - will help friends decide to make friends or not',
64 `profile-id` int(11) NOT NULL DEFAULT '0' COMMENT 'which profile to display - 0 is public default',
66 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
68 -- --------------------------------------------------------
71 -- Table structure for table `group`
74 CREATE TABLE IF NOT EXISTS `group` (
75 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
76 `uid` int(10) unsigned NOT NULL,
77 `name` char(255) NOT NULL,
79 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
81 -- --------------------------------------------------------
84 -- Table structure for table `group_member`
87 CREATE TABLE IF NOT EXISTS `group_member` (
88 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
89 `uid` int(10) unsigned NOT NULL,
90 `gid` int(10) unsigned NOT NULL,
91 `contact-id` int(10) unsigned NOT NULL,
93 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
95 -- --------------------------------------------------------
98 -- Table structure for table `intro`
101 CREATE TABLE IF NOT EXISTS `intro` (
102 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
103 `uid` int(10) unsigned NOT NULL,
104 `contact-id` int(11) NOT NULL,
105 `knowyou` tinyint(1) NOT NULL,
106 `note` text NOT NULL,
107 `hash` char(255) NOT NULL,
108 `datetime` datetime NOT NULL,
109 `blocked` tinyint(1) NOT NULL DEFAULT '1',
110 `ignore` tinyint(1) NOT NULL DEFAULT '0',
112 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
114 -- --------------------------------------------------------
117 -- Table structure for table `item`
120 CREATE TABLE IF NOT EXISTS `item` (
121 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
122 `uid` int(10) unsigned NOT NULL DEFAULT '0',
123 `type` char(255) NOT NULL,
124 `resource-id` char(255) NOT NULL,
125 `contact-id` int(10) unsigned NOT NULL DEFAULT '0',
126 `remote-id` char(255) NOT NULL,
127 `created` datetime NOT NULL,
128 `edited` datetime NOT NULL,
129 `commented` datetime NOT NULL,
130 `hash` char(255) NOT NULL,
131 `parent` int(10) unsigned NOT NULL DEFAULT '0',
132 `title` char(255) NOT NULL,
133 `body` text NOT NULL,
134 `visible` tinyint(1) NOT NULL DEFAULT '0',
135 `deleted` tinyint(1) NOT NULL DEFAULT '0',
136 `allow_uid` mediumtext NOT NULL,
137 `allow_gid` mediumtext NOT NULL,
138 `deny_uid` mediumtext NOT NULL,
139 `deny_gid` mediumtext NOT NULL,
141 KEY `created` (`created`),
144 KEY `commented` (`commented`),
145 FULLTEXT KEY `body` (`body`),
146 FULLTEXT KEY `title` (`title`)
147 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
149 -- --------------------------------------------------------
152 -- Table structure for table `photo`
155 CREATE TABLE IF NOT EXISTS `photo` (
156 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
157 `uid` int(10) unsigned NOT NULL,
158 `resource-id` char(255) NOT NULL,
159 `created` datetime NOT NULL,
160 `edited` datetime NOT NULL,
161 `title` char(255) NOT NULL,
162 `desc` text NOT NULL,
163 `filename` char(255) NOT NULL,
164 `height` smallint(6) NOT NULL,
165 `width` smallint(6) NOT NULL,
166 `data` mediumblob NOT NULL,
167 `scale` tinyint(3) NOT NULL,
168 `allow_uid` mediumtext NOT NULL,
169 `allow_gid` mediumtext NOT NULL,
170 `deny_uid` mediumtext NOT NULL,
171 `deny_gid` mediumtext NOT NULL,
173 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
175 -- --------------------------------------------------------
178 -- Table structure for table `profile`
181 CREATE TABLE IF NOT EXISTS `profile` (
182 `id` int(11) NOT NULL AUTO_INCREMENT,
183 `uid` int(11) NOT NULL,
184 `profile-name` char(255) NOT NULL,
185 `is-default` tinyint(1) NOT NULL DEFAULT '0',
186 `hide-friends` tinyint(1) NOT NULL DEFAULT '0',
187 `name` char(255) NOT NULL,
188 `dob` char(32) NOT NULL DEFAULT '0000-00-00',
189 `address` char(255) NOT NULL,
190 `locality` char(255) NOT NULL,
191 `region` char(255) NOT NULL,
192 `postal-code` char(32) NOT NULL,
193 `country-name` char(255) NOT NULL,
194 `gender` char(8) NOT NULL,
195 `marital` char(255) NOT NULL,
196 `sexual` char(255) NOT NULL,
197 `politic` char(255) NOT NULL,
198 `religion` char(255) NOT NULL,
199 `about` text NOT NULL,
200 `summary` char(255) NOT NULL,
201 `music` text NOT NULL,
202 `book` text NOT NULL,
204 `film` text NOT NULL,
205 `interest` text NOT NULL,
206 `romance` text NOT NULL,
207 `work` text NOT NULL,
208 `education` text NOT NULL,
209 `contact` text NOT NULL,
210 `homepage` char(255) NOT NULL,
211 `photo` char(255) NOT NULL,
212 `thumb` char(255) NOT NULL,
213 `publish` tinyint(1) NOT NULL DEFAULT '0',
215 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
217 -- --------------------------------------------------------
220 -- Table structure for table `profile_check`
223 CREATE TABLE IF NOT EXISTS `profile_check` (
224 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
225 `uid` int(10) unsigned NOT NULL,
226 `dfrn_id` char(255) NOT NULL,
227 `expire` int(11) NOT NULL,
229 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
231 -- --------------------------------------------------------
234 -- Table structure for table `session`
237 CREATE TABLE IF NOT EXISTS `session` (
238 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
239 `sid` char(255) NOT NULL,
240 `data` text NOT NULL,
241 `expire` int(10) unsigned NOT NULL,
244 KEY `expire` (`expire`)
245 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
247 -- --------------------------------------------------------
250 -- Table structure for table `user`
253 CREATE TABLE IF NOT EXISTS `user` (
254 `uid` int(11) NOT NULL AUTO_INCREMENT,
255 `username` char(255) NOT NULL,
256 `password` char(255) NOT NULL,
257 `nickname` char(255) NOT NULL,
258 `email` char(255) NOT NULL,
259 `timezone` char(128) NOT NULL,
260 `pubkey` text NOT NULL,
261 `prvkey` text NOT NULL,
262 `verified` tinyint(1) unsigned NOT NULL DEFAULT '0',
263 `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
265 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;