root/trunk/dotnode-struct.sql

Revision 33, 22.6 KB (checked in by alexx, 6 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
15DROP TABLE IF EXISTS `access`;
16CREATE 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
28DROP TABLE IF EXISTS `album`;
29CREATE 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
44DROP TABLE IF EXISTS `blog`;
45CREATE 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
62DROP TABLE IF EXISTS `blog_categorie`;
63CREATE 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
76DROP TABLE IF EXISTS `blog_comment`;
77CREATE 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
92DROP TABLE IF EXISTS `bookmarks`;
93CREATE 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
108DROP TABLE IF EXISTS `bookmarks_cat`;
109CREATE 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
123DROP TABLE IF EXISTS `cache_user`;
124CREATE 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
167DROP TABLE IF EXISTS `community`;
168CREATE 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
194DROP TABLE IF EXISTS `community_cat`;
195CREATE 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
208DROP TABLE IF EXISTS `community_event`;
209CREATE 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
228DROP TABLE IF EXISTS `community_keyword`;
229CREATE 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
242DROP TABLE IF EXISTS `community_post`;
243CREATE 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
260DROP TABLE IF EXISTS `community_topic`;
261CREATE 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
280DROP TABLE IF EXISTS `dntp_msgid`;
281CREATE 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
299DROP TABLE IF EXISTS `dntp_msgstr`;
300CREATE 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
320DROP TABLE IF EXISTS `dntp_translator`;
321CREATE 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
341DROP TABLE IF EXISTS `dntp_translator_msgstr`;
342CREATE 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
352DROP TABLE IF EXISTS `global_data`;
353CREATE 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
363DROP TABLE IF EXISTS `invitation`;
364CREATE 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
375DROP TABLE IF EXISTS `invitation_email`;
376CREATE 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
398DROP TABLE IF EXISTS `message`;
399CREATE 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
423DROP TABLE IF EXISTS `metalbum`;
424CREATE 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
436DROP TABLE IF EXISTS `relation`;
437CREATE 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
456DROP TABLE IF EXISTS `rss_blog`;
457CREATE 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
471DROP TABLE IF EXISTS `rss_blog_ticket`;
472CREATE 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
490DROP TABLE IF EXISTS `session`;
491CREATE 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
503DROP TABLE IF EXISTS `settings`;
504CREATE 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
524DROP TABLE IF EXISTS `todo`;
525CREATE 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
544DROP TABLE IF EXISTS `user`;
545CREATE 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
574DROP TABLE IF EXISTS `user_comm`;
575CREATE 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
589DROP TABLE IF EXISTS `user_contact`;
590CREATE 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
617DROP TABLE IF EXISTS `user_general`;
618CREATE 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
646DROP TABLE IF EXISTS `user_interests`;
647CREATE 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
664DROP TABLE IF EXISTS `user_personal`;
665CREATE 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
687DROP TABLE IF EXISTS `user_professional`;
688CREATE 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
706DROP TABLE IF EXISTS `user_schools`;
707CREATE 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.