root/trunk/dotnode-struct.sql

Revision 33, 22.6 kB (checked in by alexx, 3 years ago)
  • Auth: Remove MySQL PASSWORD hashing method to hash password, replace by MD5 hashing, add code to make a smooth transition between hashing method
  • XML engine: Fix a trivial recent bug in dotnode-xml.php
  • Robots: fix a bug in crontab script robots/launch_robots.sh (add cd dirname $0)
  • CSS: Add max_width to image in blog (work on Mozilla/*, Opera but not good on Safari (no proportional resizing), of course, that doesn't work on IE)
  • DB: changing DB structure !!!
    ALTER TABLE `user` ADD `passwd_md5` CHAR( 32 ) NOT NULL AFTER `passwd` ;
    ALTER TABLE `user` CHANGE `passwd` `passwd` VARCHAR( 42 ) NULL ;
    ALTER TABLE `dntp_translator` ADD `passwd_md5` CHAR( 32 ) NOT NULL AFTER `passwd` ;
    ALTER TABLE `dntp_translator` CHANGE `passwd` `passwd` VARCHAR( 42 ) NULL ;
    
Line 
1 -- MySQL dump 10.9
2 --
3 -- Host: localhost    Database: dotnode_alexx
4 -- ------------------------------------------------------
5 -- Server version       4.1.11-Debian_4sarge1-log
6 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
7 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
8 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,MYSQL40' */;
9 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
10
11 --
12 -- Table structure for table `access`
13 --
14
15 DROP TABLE IF EXISTS `access`;
16 CREATE TABLE `access` (
17   `id` varchar(34) NOT NULL default '',
18   `table_name` varchar(64) NOT NULL default '',
19   `field` varchar(64) NOT NULL default '',
20   `access` enum('myself','friends','friends_of_friends','members','everyone') NOT NULL default 'friends',
21   PRIMARY KEY  (`id`,`table_name`,`field`)
22 ) TYPE=MyISAM;
23
24 --
25 -- Table structure for table `album`
26 --
27
28 DROP TABLE IF EXISTS `album`;
29 CREATE TABLE `album` (
30   `id` varchar(34) NOT NULL default '',
31   `id_image` int(10) unsigned NOT NULL auto_increment,
32   `width` int(10) unsigned NOT NULL default '0',
33   `height` int(10) unsigned NOT NULL default '0',
34   `format` enum('png','jpeg','gif') NOT NULL default 'png',
35   `caption` text,
36   `date` datetime NOT NULL default '0000-00-00 00:00:00',
37   PRIMARY KEY  (`id_image`)
38 ) TYPE=MyISAM COMMENT='Album';
39
40 --
41 -- Table structure for table `blog`
42 --
43
44 DROP TABLE IF EXISTS `blog`;
45 CREATE TABLE `blog` (
46   `id` varchar(34) NOT NULL default '',
47   `id_blog` int(10) unsigned NOT NULL auto_increment,
48   `id_cat` int(10) unsigned default NULL,
49   `title` varchar(255) NOT NULL default '',
50   `chapeau` text,
51   `ticket` text NOT NULL,
52   `nb_comments` int(10) unsigned NOT NULL default '0',
53   `date` int(11) NOT NULL default '0',
54   `status` enum('online','offline') NOT NULL default 'offline',
55   PRIMARY KEY  (`id_blog`)
56 ) TYPE=MyISAM;
57
58 --
59 -- Table structure for table `blog_categorie`
60 --
61
62 DROP TABLE IF EXISTS `blog_categorie`;
63 CREATE TABLE `blog_categorie` (
64   `id` varchar(34) NOT NULL default '',
65   `id_cat` int(10) unsigned NOT NULL auto_increment,
66   `name` varchar(255) NOT NULL default '',
67   `comment` text NOT NULL,
68   PRIMARY KEY  (`id_cat`),
69   UNIQUE KEY `id` (`id`,`name`)
70 ) TYPE=MyISAM;
71
72 --
73 -- Table structure for table `blog_comment`
74 --
75
76 DROP TABLE IF EXISTS `blog_comment`;
77 CREATE TABLE `blog_comment` (
78   `id` varchar(34) NOT NULL default '',
79   `id_comment` int(10) unsigned NOT NULL auto_increment,
80   `id_blog` int(10) unsigned NOT NULL default '0',
81   `id_author` varchar(34) NOT NULL default '',
82   `title` varchar(255) default NULL,
83   `comment` text NOT NULL,
84   `date` int(10) unsigned NOT NULL default '0',
85   PRIMARY KEY  (`id_comment`)
86 ) TYPE=MyISAM;
87
88 --
89 -- Table structure for table `bookmarks`
90 --
91
92 DROP TABLE IF EXISTS `bookmarks`;
93 CREATE TABLE `bookmarks` (
94   `id` varchar(34) NOT NULL default '',
95   `id_cat` int(10) unsigned NOT NULL default '0',
96   `cat_name` varchar(64) default NULL,
97   `link` varchar(255) NOT NULL default '',
98   `comment` text,
99   `date` int(11) NOT NULL default '0',
100   PRIMARY KEY  (`id`,`link`),
101   KEY `id_cat` (`id_cat`)
102 ) TYPE=MyISAM;
103
104 --
105 -- Table structure for table `bookmarks_cat`
106 --
107
108 DROP TABLE IF EXISTS `bookmarks_cat`;
109 CREATE TABLE `bookmarks_cat` (
110   `id` varchar(32) NOT NULL default '',
111   `id_cat` int(10) unsigned NOT NULL auto_increment,
112   `id_cat_parent` int(10) unsigned NOT NULL default '0',
113   `name` varchar(64) NOT NULL default '',
114   PRIMARY KEY  (`id_cat`),
115   UNIQUE KEY `id` (`id`,`name`),
116   KEY `id_parent` (`id_cat_parent`)
117 ) TYPE=MyISAM;
118
119 --
120 -- Table structure for table `cache_user`
121 --
122
123 DROP TABLE IF EXISTS `cache_user`;
124 CREATE TABLE `cache_user` (
125   `id` varchar(34) NOT NULL default '',
126   `login` varchar(32) NOT NULL default '',
127   `fname` varchar(32) default NULL,
128   `lname` varchar(32) default NULL,
129   `nick` varchar(64) default NULL,
130   `fname_sndex` varchar(32) NOT NULL default '',
131   `lname_sndex` varchar(32) NOT NULL default '',
132   `nick_sndex` varchar(32) default NULL,
133   `country` varchar(255) default NULL,
134   `gender` enum('male','female') default NULL,
135   `age` int(10) unsigned default '0',
136   `relationship_status` set('single','married','committed') default NULL,
137   `here_for` set('friend','business','dating','partners') default NULL,
138   `join_date` int(10) unsigned NOT NULL default '0',
139   `photo` enum('y','n') NOT NULL default 'n',
140   `nb_friends` int(10) unsigned NOT NULL default '0',
141   `friends_id` text,
142   `nb_communities` int(10) unsigned NOT NULL default '0',
143   `communities_id` text NOT NULL,
144   `nb_fans` int(10) unsigned NOT NULL default '0',
145   `nb_bookmarks` int(10) unsigned NOT NULL default '0',
146   `nb_blogs` int(10) unsigned NOT NULL default '0',
147   `nb_photos` int(10) unsigned NOT NULL default '0',
148   `fun` float(3,2) unsigned NOT NULL default '0.00',
149   `cool` float(3,2) unsigned NOT NULL default '0.00',
150   `sexy` float(3,2) unsigned NOT NULL default '0.00',
151   PRIMARY KEY  (`id`),
152   KEY `photo` (`photo`),
153   KEY `fname_sndex` (`fname_sndex`),
154   KEY `lname_sndex` (`lname_sndex`),
155   KEY `age` (`age`),
156   KEY `fname` (`fname`),
157   KEY `lname` (`lname`),
158   KEY `login` (`login`),
159   KEY `nick` (`nick`),
160   KEY `nick_sndex` (`nick_sndex`)
161 ) TYPE=MyISAM;
162
163 --
164 -- Table structure for table `community`
165 --
166
167 DROP TABLE IF EXISTS `community`;
168 CREATE TABLE `community` (
169   `id` varchar(34) NOT NULL default '',
170   `id_comm` int(10) unsigned NOT NULL auto_increment,
171   `id_cat` int(10) unsigned NOT NULL default '0',
172   `name` varchar(64) NOT NULL default '',
173   `description` text NOT NULL,
174   `moderated` enum('no','yes') NOT NULL default 'no',
175   `country` varchar(255) default NULL,
176   `date` int(10) unsigned NOT NULL default '0',
177   `status` enum('ok','pending_delete') NOT NULL default 'ok',
178   `status_text` text,
179   `status_date` int(10) unsigned default NULL,
180   `nb_members` int(10) unsigned NOT NULL default '1',
181   `last_post_date` int(10) unsigned NOT NULL default '0',
182   PRIMARY KEY  (`id_comm`),
183   UNIQUE KEY `name` (`name`),
184   KEY `date` (`date`),
185   KEY `last_post_date` (`last_post_date`),
186   KEY `id_cat` (`id_cat`),
187   KEY `status` (`status`)
188 ) TYPE=MyISAM;
189
190 --
191 -- Table structure for table `community_cat`
192 --
193
194 DROP TABLE IF EXISTS `community_cat`;
195 CREATE TABLE `community_cat` (
196   `id_cat` int(10) unsigned NOT NULL auto_increment,
197   `name` varchar(64) NOT NULL default '',
198   `description` text NOT NULL,
199   `nb_communities` int(10) unsigned NOT NULL default '0',
200   PRIMARY KEY  (`id_cat`),
201   KEY `name` (`name`)
202 ) TYPE=MyISAM;
203
204 --
205 -- Table structure for table `community_event`
206 --
207
208 DROP TABLE IF EXISTS `community_event`;
209 CREATE TABLE `community_event` (
210   `id_event` int(10) unsigned NOT NULL auto_increment,
211   `id_comm` int(11) NOT NULL default '0',
212   `id` varchar(32) NOT NULL default '',
213   `author` varchar(64) NOT NULL default '',
214   `title` varchar(64) NOT NULL default '',
215   `date_event` int(10) unsigned NOT NULL default '0',
216   `location` text,
217   `city` varchar(255) default NULL,
218   `country` varchar(255) default NULL,
219   `details` text NOT NULL,
220   `date` int(10) unsigned NOT NULL default '0',
221   PRIMARY KEY  (`id_event`)
222 ) TYPE=MyISAM;
223
224 --
225 -- Table structure for table `community_keyword`
226 --
227
228 DROP TABLE IF EXISTS `community_keyword`;
229 CREATE TABLE `community_keyword` (
230   `key_sndx` varchar(16) NOT NULL default '',
231   `id_comm` int(10) unsigned NOT NULL default '0',
232   `id_cat` int(10) unsigned NOT NULL default '0',
233   PRIMARY KEY  (`key_sndx`,`id_comm`),
234   KEY `key_sndx` (`key_sndx`),
235   KEY `id_cat` (`id_cat`)
236 ) TYPE=MyISAM;
237
238 --
239 -- Table structure for table `community_post`
240 --
241
242 DROP TABLE IF EXISTS `community_post`;
243 CREATE TABLE `community_post` (
244   `id_post` int(10) unsigned NOT NULL auto_increment,
245   `id_topic` int(10) unsigned NOT NULL default '0',
246   `id_comm` int(11) unsigned NOT NULL default '0',
247   `id` varchar(34) NOT NULL default '',
248   `author` varchar(64) NOT NULL default '',
249   `title` varchar(64) default NULL,
250   `message` text NOT NULL,
251   `date` int(10) unsigned NOT NULL default '0',
252   PRIMARY KEY  (`id_post`),
253   KEY `id_topic` (`id_topic`)
254 ) TYPE=MyISAM;
255
256 --
257 -- Table structure for table `community_topic`
258 --
259
260 DROP TABLE IF EXISTS `community_topic`;
261 CREATE TABLE `community_topic` (
262   `id_topic` int(10) unsigned NOT NULL auto_increment,
263   `id_comm` int(10) unsigned NOT NULL default '0',
264   `id` varchar(34) NOT NULL default '',
265   `title` varchar(255) NOT NULL default '',
266   `date` int(10) unsigned NOT NULL default '0',
267   `sticky` enum('false','true') NOT NULL default 'false',
268   `author` varchar(64) NOT NULL default '',
269   `nb_posts` int(10) unsigned NOT NULL default '0',
270   `last_post_date` int(10) unsigned NOT NULL default '0',
271   PRIMARY KEY  (`id_topic`),
272   KEY `date` (`date`),
273   KEY `sticky` (`sticky`)
274 ) TYPE=MyISAM;
275
276 --
277 -- Table structure for table `dntp_msgid`
278 --
279
280 DROP TABLE IF EXISTS `dntp_msgid`;
281 CREATE TABLE `dntp_msgid` (
282   `id` int(10) unsigned NOT NULL auto_increment,
283   `md5` varchar(32) NOT NULL default '',
284   `msgid` text NOT NULL,
285   `msgid_plural` text,
286   `multiline` enum('n','y') NOT NULL default 'n',
287   `first_see` varchar(255) default NULL,
288   `status` enum('new','ok') NOT NULL default 'new',
289   `date` int(10) unsigned NOT NULL default '0',
290   PRIMARY KEY  (`id`),
291   UNIQUE KEY `md5` (`md5`),
292   KEY `status` (`status`)
293 ) TYPE=MyISAM;
294
295 --
296 -- Table structure for table `dntp_msgstr`
297 --
298
299 DROP TABLE IF EXISTS `dntp_msgstr`;
300 CREATE TABLE `dntp_msgstr` (
301   `id_msgstr` int(10) unsigned NOT NULL auto_increment,
302   `id` int(10) unsigned NOT NULL default '0',
303   `key` tinyint(3) unsigned NOT NULL default '0',
304   `msgstr` text NOT NULL,
305   `multiline` enum('n','y') NOT NULL default 'n',
306   `lang` varchar(16) NOT NULL default '',
307   `translator` varchar(64) NOT NULL default '',
308   `status` enum('new','must_be_verified','ok') NOT NULL default 'new',
309   `last` enum('y','n') NOT NULL default 'y',
310   `comment` text,
311   `date` int(10) unsigned NOT NULL default '0',
312   PRIMARY KEY  (`id_msgstr`),
313   KEY `id` (`id`,`key`,`lang`,`last`)
314 ) TYPE=MyISAM;
315
316 --
317 -- Table structure for table `dntp_translator`
318 --
319
320 DROP TABLE IF EXISTS `dntp_translator`;
321 CREATE TABLE `dntp_translator` (
322   `id_translator` int(10) unsigned NOT NULL auto_increment,
323   `id_dotnode` varchar(34) NOT NULL default '',
324   `login` varchar(64) NOT NULL default '',
325   `passwd` varchar(42) default NULL,
326   `passwd_md5` varchar(32) NOT NULL default '',
327   `comment` text NOT NULL,
328   `status` enum('waiting','ok','ko') NOT NULL default 'waiting',
329   `level` set('verif','translator','admin','sadmin') NOT NULL default '',
330   `lang` varchar(16) NOT NULL default '',
331   `date` int(10) unsigned NOT NULL default '0',
332   PRIMARY KEY  (`id_translator`,`id_dotnode`),
333   UNIQUE KEY `name` (`login`),
334   KEY `lang` (`lang`)
335 ) TYPE=MyISAM COMMENT='2';
336
337 --
338 -- Table structure for table `dntp_translator_msgstr`
339 --
340
341 DROP TABLE IF EXISTS `dntp_translator_msgstr`;
342 CREATE TABLE `dntp_translator_msgstr` (
343   `id` int(10) unsigned NOT NULL default '0',
344   `id_translator` int(10) unsigned NOT NULL default '0',
345   PRIMARY KEY  (`id`,`id_translator`)
346 ) TYPE=MyISAM;
347
348 --
349 -- Table structure for table `global_data`
350 --
351
352 DROP TABLE IF EXISTS `global_data`;
353 CREATE TABLE `global_data` (
354   `name` varchar(32) NOT NULL default '',
355   `value` varchar(32) NOT NULL default '',
356   PRIMARY KEY  (`name`)
357 ) TYPE=HEAP;
358
359 --
360 -- Table structure for table `invitation`
361 --
362
363 DROP TABLE IF EXISTS `invitation`;
364 CREATE TABLE `invitation` (
365   `id` varchar(34) NOT NULL default '',
366   `id_invit` varchar(34) NOT NULL default '',
367   `level` enum('havent_seen','acquaintance','friend','good_friend','best_friend') NOT NULL default 'friend',
368   PRIMARY KEY  (`id`,`id_invit`)
369 ) TYPE=MyISAM;
370
371 --
372 -- Table structure for table `invitation_email`
373 --
374
375 DROP TABLE IF EXISTS `invitation_email`;
376 CREATE TABLE `invitation_email` (
377   `id` varchar(34) NOT NULL default '',
378   `id_invit` varchar(34) NOT NULL default '',
379   `fname` varchar(64) NOT NULL default '',
380   `lname` varchar(64) NOT NULL default '',
381   `email` varchar(64) NOT NULL default '',
382   `lang` varchar(7) NOT NULL default 'en_US',
383   `type` enum('man','csv','6nergies') NOT NULL default 'man',
384   `status` enum('todo','doing','done','stop') NOT NULL default 'todo',
385   `response` enum('accepted','rejected','blacklist','mailproblem') default NULL,
386   `date_begin` int(10) unsigned NOT NULL default '0',
387   `date_finish` int(10) unsigned NOT NULL default '0',
388   `failure_notice` text,
389   `ip` varchar(15) NOT NULL default '',
390   PRIMARY KEY  (`id`),
391   KEY `status` (`status`)
392 ) TYPE=MyISAM;
393
394 --
395 -- Table structure for table `message`
396 --
397
398 DROP TABLE IF EXISTS `message`;
399 CREATE TABLE `message` (
400   `id` varchar(34) default NULL,
401   `id_mess` int(10) unsigned NOT NULL auto_increment,
402   `id_from` varchar(34) default NULL,
403   `from_str` varchar(64) NOT NULL default '',
404   `type` varchar(32) NOT NULL default 'message',
405   `dest` enum('one','friends','friends_of_friends') NOT NULL default 'one',
406   `subject` varchar(255) NOT NULL default '',
407   `message` text NOT NULL,
408   `box` enum('inbox','save','send','outbox') NOT NULL default 'inbox',
409   `flag` enum('new','read') NOT NULL default 'new',
410   `date` int(10) unsigned NOT NULL default '0',
411   PRIMARY KEY  (`id_mess`),
412   KEY `box` (`box`),
413   KEY `id` (`id`),
414   KEY `type` (`type`),
415   KEY `dest` (`dest`),
416   KEY `new_message` (`id`,`box`,`flag`)
417 ) TYPE=MyISAM;
418
419 --
420 -- Table structure for table `metalbum`
421 --
422
423 DROP TABLE IF EXISTS `metalbum`;
424 CREATE TABLE `metalbum` (
425   `id` varchar(32) NOT NULL default '',
426   `type` varchar(16) NOT NULL default '',
427   `login` varchar(64) NOT NULL default '',
428   `nb_items` int(10) unsigned default NULL,
429   PRIMARY KEY  (`id`,`type`,`login`)
430 ) TYPE=MyISAM;
431
432 --
433 -- Table structure for table `relation`
434 --
435
436 DROP TABLE IF EXISTS `relation`;
437 CREATE TABLE `relation` (
438   `id` varchar(34) NOT NULL default '',
439   `id_friend` varchar(34) NOT NULL default '',
440   `cool` tinyint(2) NOT NULL default '0',
441   `fun` tinyint(2) NOT NULL default '0',
442   `sexy` tinyint(2) NOT NULL default '0',
443   `fan` tinyint(1) unsigned NOT NULL default '0',
444   `level` enum('havent_seen','acquaintance','friend','good_friend','best_friend') NOT NULL default 'friend',
445   `type` enum('love','club','childhood','studies','family','internet','parties','work','holidays','other') NOT NULL default 'internet',
446   `last_visit` int(10) unsigned NOT NULL default '0',
447   PRIMARY KEY  (`id`,`id_friend`),
448   KEY `last_visit` (`last_visit`),
449   KEY `id_friend` (`id_friend`)
450 ) TYPE=MyISAM COMMENT='Relation + karma';
451
452 --
453 -- Table structure for table `rss_blog`
454 --
455
456 DROP TABLE IF EXISTS `rss_blog`;
457 CREATE TABLE `rss_blog` (
458   `id` varchar(34) NOT NULL default '',
459   `id_blog` int(10) unsigned NOT NULL auto_increment,
460   `title` varchar(255) NOT NULL default '',
461   `link` text NOT NULL,
462   `rss` text NOT NULL,
463   PRIMARY KEY  (`id_blog`),
464   UNIQUE KEY `id` (`id`)
465 ) TYPE=MyISAM;
466
467 --
468 -- Table structure for table `rss_blog_ticket`
469 --
470
471 DROP TABLE IF EXISTS `rss_blog_ticket`;
472 CREATE TABLE `rss_blog_ticket` (
473   `id` varchar(34) NOT NULL default '',
474   `id_blog` int(10) unsigned NOT NULL default '0',
475   `id_ticket` varchar(34) NOT NULL default '',
476   `title` text NOT NULL,
477   `description` text,
478   `content` text,
479   `link` text NOT NULL,
480   `date` int(10) unsigned default NULL,
481   PRIMARY KEY  (`id`,`id_ticket`),
482   KEY `id` (`id`),
483   KEY `id_blog` (`id_blog`)
484 ) TYPE=MyISAM;
485
486 --
487 -- Table structure for table `session`
488 --
489
490 DROP TABLE IF EXISTS `session`;
491 CREATE TABLE `session` (
492   `id` varchar(32) binary NOT NULL default '',
493   `SecID` varchar(32) NOT NULL default '',
494   `timestamp` int(10) unsigned NOT NULL default '0',
495   PRIMARY KEY  (`id`),
496   KEY `timestamp` (`timestamp`)
497 ) TYPE=HEAP;
498
499 --
500 -- Table structure for table `settings`
501 --
502
503 DROP TABLE IF EXISTS `settings`;
504 CREATE TABLE `settings` (
505   `id` varchar(34) NOT NULL default '',
506   `new_friend_notifications` set('email') default NULL,
507   `new_friend_approval` set('email') default NULL,
508   `new_blog_comment` set('email') default NULL,
509   `messages_sent_directly_to_me` set('email') default NULL,
510   `messages_sent_to_friends` set('email') default NULL,
511   `messages_sent_to_friends_of_friends` set('email') default NULL,
512   `messages_sent_to_communities` set('email') default NULL,
513   `birthday_reminder` set('email') default NULL,
514   `publish` enum('yes','no') NOT NULL default 'yes',
515   `dotpage_css` varchar(32) NOT NULL default 'default',
516   `invitation_message` text,
517   PRIMARY KEY  (`id`)
518 ) TYPE=MyISAM;
519
520 --
521 -- Table structure for table `todo`
522 --
523
524 DROP TABLE IF EXISTS `todo`;
525 CREATE TABLE `todo` (
526   `id_todo` int(10) unsigned NOT NULL auto_increment,
527   `robot` varchar(128) NOT NULL default '',
528   `param` varchar(255) default NULL,
529   `status` enum('todo','doing','done','stop') NOT NULL default 'todo',
530   `date` int(10) unsigned NOT NULL default '0',
531   `id` varchar(34) NOT NULL default '',
532   `ip` varchar(15) NOT NULL default '',
533   `lang` varchar(7) NOT NULL default 'en_US',
534   PRIMARY KEY  (`id_todo`),
535   UNIQUE KEY `robot_2` (`robot`,`id`),
536   KEY `robot` (`robot`),
537   KEY `etat` (`status`)
538 ) TYPE=MyISAM;
539
540 --
541 -- Table structure for table `user`
542 --
543
544 DROP TABLE IF EXISTS `user`;
545 CREATE TABLE `user` (
546   `id` varchar(34) NOT NULL default '',
547   `login` varchar(24) NOT NULL default '',
548   `passwd` varchar(42) binary default NULL,
549   `passwd_md5` varchar(32) binary NOT NULL default '',
550   `fname` varchar(32) NOT NULL default '',
551   `lname` varchar(32) NOT NULL default '',
552   `nick` varchar(64) default NULL,
553   `photo` enum('y','n') NOT NULL default 'n',
554   `blog_url` varchar(255) default NULL,
555   `join_date` int(11) NOT NULL default '0',
556   `invite_date` int(11) NOT NULL default '0',
557   `last_visite` int(11) NOT NULL default '0',
558   `lang` varchar(7) NOT NULL default 'en_US',
559   `id_parent` varchar(34) NOT NULL default '',
560   `status` set('ok','waiting','jail') NOT NULL default '',
561   `ip` varchar(16) NOT NULL default '',
562   PRIMARY KEY  (`id`),
563   UNIQUE KEY `login` (`login`),
564   KEY `id_parent` (`id_parent`),
565   KEY `status` (`status`),
566   KEY `photo` (`photo`),
567   KEY `nick` (`nick`)
568 ) TYPE=MyISAM COMMENT='2';
569
570 --
571 -- Table structure for table `user_comm`
572 --
573
574 DROP TABLE IF EXISTS `user_comm`;
575 CREATE TABLE `user_comm` (
576   `id` varchar(34) NOT NULL default '',
577   `id_comm` int(10) unsigned NOT NULL default '0',
578   `status` enum('ok','waiting') NOT NULL default 'ok',
579   `last_visit` int(10) unsigned NOT NULL default '0',
580   PRIMARY KEY  (`id`,`id_comm`),
581   KEY `id_comm` (`id_comm`),
582   KEY `last_visit` (`last_visit`)
583 ) TYPE=MyISAM;
584
585 --
586 -- Table structure for table `user_contact`
587 --
588
589 DROP TABLE IF EXISTS `user_contact`;
590 CREATE TABLE `user_contact` (
591   `id` varchar(34) NOT NULL default '',
592   `email` varchar(128) NOT NULL default '',
593   `email2` varchar(128) default NULL,
594   `email3` varchar(128) default NULL,
595   `email4` varchar(128) default NULL,
596   `im` varchar(128) default NULL,
597   `im_type` enum('aim','icq','irc','msn','jabber','yahoo','skype') default NULL,
598   `im2` varchar(128) default NULL,
599   `im2_type` enum('aim','icq','irc','msn','jabber','yahoo','skype') default NULL,
600   `phone` varchar(32) default NULL,
601   `cell_phone` varchar(32) default NULL,
602   `address` text,
603   `zip` varchar(10) default NULL,
604   `city` varchar(128) default NULL,
605   `country` varchar(255) default NULL,
606   PRIMARY KEY  (`id`),
607   UNIQUE KEY `email` (`email`),
608   KEY `city` (`city`),
609   KEY `country` (`country`),
610   KEY `zip` (`zip`)
611 ) TYPE=MyISAM;
612
613 --
614 -- Table structure for table `user_general`
615 --
616
617 DROP TABLE IF EXISTS `user_general`;
618 CREATE TABLE `user_general` (
619   `id` varchar(34) NOT NULL default '',
620   `relationship_status` enum('single','married','committed') default NULL,
621   `birthday` date default NULL,
622   `here_for` set('friend','business','dating','partners') default NULL,
623   `children` enum('no','fulltime','halftime','notathome') default NULL,
624   `gender` enum('male','female') default NULL,
625   `fashion` set('alternative','casual','classic','contemporary','designer','minimal','natural','outdoorsy','smart','trendy','urban') default NULL,
626   `smoking` enum('no','little','socialy','occasionally','regularly') default NULL,
627   `drinking` enum('no','little','socialy','occasionally','regularly') default NULL,
628   `living` set('alone','roommate','parents','partner','pet','kid') default NULL,
629   `web` varchar(255) default NULL,
630   `description` text,
631   PRIMARY KEY  (`id`),
632   KEY `smoking` (`smoking`),
633   KEY `drinking` (`drinking`),
634   KEY `living` (`living`),
635   KEY `children` (`children`),
636   KEY `gender` (`gender`),
637   KEY `fashion` (`fashion`),
638   KEY `here_for` (`here_for`),
639   KEY `relationship_status` (`relationship_status`)
640 ) TYPE=MyISAM;
641
642 --
643 -- Table structure for table `user_interests`
644 --
645
646 DROP TABLE IF EXISTS `user_interests`;
647 CREATE TABLE `user_interests` (
648   `id` varchar(34) NOT NULL default '',
649   `passions` text,
650   `sports` text,
651   `activities` text,
652   `favorite_books` text,
653   `favorite_music` text,
654   `favorite_tvshow` text,
655   `favorite_movies` text,
656   `favorite_cuisines` text,
657   PRIMARY KEY  (`id`)
658 ) TYPE=MyISAM;
659
660 --
661 -- Table structure for table `user_personal`
662 --
663
664 DROP TABLE IF EXISTS `user_personal`;
665 CREATE TABLE `user_personal` (
666   `id` varchar(34) NOT NULL default '',
667   `headline` text,
668   `notice` text,
669   `size` int(3) default NULL,
670   `eye` enum('blue','green','brown','black','gray','hazel') default NULL,
671   `hair` enum('blonde','black','auburn','gray','salt_and_pepper','light_brown','dark_brown','red') default NULL,
672   `body_art` set('hidden_tattoo','visible_tattoo','pierced_tongue','other_piercing') default NULL,
673   `best_feature` enum('eyes','hair','lips','neck','arms','hands','chest','belly_button','butt','legs','calves','feet','not_on_the_list') default NULL,
674   `things_i_cant_live_without` text,
675   `ideal_match` text,
676   PRIMARY KEY  (`id`),
677   KEY `eye` (`eye`),
678   KEY `hair` (`hair`),
679   KEY `body_art` (`body_art`),
680   KEY `best_feature` (`best_feature`)
681 ) TYPE=MyISAM;
682
683 --
684 -- Table structure for table `user_professional`
685 --
686
687 DROP TABLE IF EXISTS `user_professional`;
688 CREATE TABLE `user_professional` (
689   `id` varchar(34) NOT NULL default '',
690   `6nergies_url` varchar(255) default NULL,
691   `occupation` varchar(128) default NULL,
692   `industry` set('agriculture','arts','construction','consumer_goods','corporate_services','education','finance','government','hi-tech','legal','manufacturing','media','medical','non-profit','entertainment','scientific','service_industry','transportation') default NULL,
693   `company` varchar(128) default NULL,
694   `web` varchar(255) default NULL,
695   `title` varchar(128) default NULL,
696   `description` text,
697   `email` varchar(128) default NULL,
698   `phone` varchar(64) default NULL,
699   PRIMARY KEY  (`id`)
700 ) TYPE=MyISAM;
701
702 --
703 -- Table structure for table `user_schools`
704 --
705
706 DROP TABLE IF EXISTS `user_schools`;
707 CREATE TABLE `user_schools` (
708   `id` varchar(34) NOT NULL default '',
709   `year` int(4) NOT NULL default '0',
710   `name` varchar(64) NOT NULL default '',
711   `city` varchar(64) NOT NULL default '',
712   `country` varchar(64) NOT NULL default '',
713   PRIMARY KEY  (`id`,`year`,`name`),
714   KEY `name` (`name`),
715   KEY `city` (`city`),
716   KEY `country` (`country`),
717   KEY `year` (`year`)
718 ) TYPE=MyISAM;
719
720 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
721 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
722 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
723 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
724
Note: See TracBrowser for help on using the browser.