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.

root/trunk/dotnode-struct.sql

Download in other formats: