Context Navigation

← Previous Change
Next Change →

Changeset 33 for trunk/dotnode-struct.sql

Timestamp:

09/03/05 22:42:52 (7 years ago)

Author:

alexx

Message:

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 ;

Files:

: 1 modified

trunk/dotnode-struct.sql (modified) (41 diffs)

Legend:

: Unmodified
: Added
: Removed

trunk/dotnode-struct.sql

r24	r33
1		-- MySQL dump ~~9.11~~
	1	-- MySQL dump 10.9
2	2	--
3	3	-- Host: localhost Database: dotnode_alexx
4	4	-- ------------------------------------------------------
5		-- Server version 4.0.24_Debian-10-log
	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 /;
6	10
7	11	--
…	…
9	13	--
10	14
	15	DROP TABLE IF EXISTS `access`;
11	16	CREATE TABLE `access` (
12	17	`id` varchar(34) NOT NULL default '',
…	…
21	26	--
22	27
	28	DROP TABLE IF EXISTS `album`;
23	29	CREATE TABLE `album` (
24	30	`id` varchar(34) NOT NULL default '',
…	…
36	42	--
37	43
	44	DROP TABLE IF EXISTS `blog`;
38	45	CREATE TABLE `blog` (
39	46	`id` varchar(34) NOT NULL default '',
…	…
53	60	--
54	61
	62	DROP TABLE IF EXISTS `blog_categorie`;
55	63	CREATE TABLE `blog_categorie` (
56	64	`id` varchar(34) NOT NULL default '',
…	…
66	74	--
67	75
	76	DROP TABLE IF EXISTS `blog_comment`;
68	77	CREATE TABLE `blog_comment` (
69	78	`id` varchar(34) NOT NULL default '',
…	…
81	90	--
82	91
	92	DROP TABLE IF EXISTS `bookmarks`;
83	93	CREATE TABLE `bookmarks` (
84	94	`id` varchar(34) NOT NULL default '',
…	…
96	106	--
97	107
	108	DROP TABLE IF EXISTS `bookmarks_cat`;
98	109	CREATE TABLE `bookmarks_cat` (
99	110	`id` varchar(32) NOT NULL default '',
…	…
110	121	--
111	122
	123	DROP TABLE IF EXISTS `cache_user`;
112	124	CREATE TABLE `cache_user` (
113	125	`id` varchar(34) NOT NULL default '',
…	…
153	165	--
154	166
	167	DROP TABLE IF EXISTS `community`;
155	168	CREATE TABLE `community` (
156	169	`id` varchar(34) NOT NULL default '',
…	…
179	192	--
180	193
	194	DROP TABLE IF EXISTS `community_cat`;
181	195	CREATE TABLE `community_cat` (
182	196	`id_cat` int(10) unsigned NOT NULL auto_increment,
…	…
192	206	--
193	207
	208	DROP TABLE IF EXISTS `community_event`;
194	209	CREATE TABLE `community_event` (
195	210	`id_event` int(10) unsigned NOT NULL auto_increment,
…	…
211	226	--
212	227
	228	DROP TABLE IF EXISTS `community_keyword`;
213	229	CREATE TABLE `community_keyword` (
214	230	`key_sndx` varchar(16) NOT NULL default '',
…	…
224	240	--
225	241
	242	DROP TABLE IF EXISTS `community_post`;
226	243	CREATE TABLE `community_post` (
227	244	`id_post` int(10) unsigned NOT NULL auto_increment,
…	…
241	258	--
242	259
	260	DROP TABLE IF EXISTS `community_topic`;
243	261	CREATE TABLE `community_topic` (
244	262	`id_topic` int(10) unsigned NOT NULL auto_increment,
…	…
260	278	--
261	279
	280	DROP TABLE IF EXISTS `dntp_msgid`;
262	281	CREATE TABLE `dntp_msgid` (
263	282	`id` int(10) unsigned NOT NULL auto_increment,
…	…
278	297	--
279	298
	299	DROP TABLE IF EXISTS `dntp_msgstr`;
280	300	CREATE TABLE `dntp_msgstr` (
281	301	`id_msgstr` int(10) unsigned NOT NULL auto_increment,
…	…
298	318	--
299	319
	320	DROP TABLE IF EXISTS `dntp_translator`;
300	321	CREATE TABLE `dntp_translator` (
301	322	`id_translator` int(10) unsigned NOT NULL auto_increment,
302	323	`id_dotnode` varchar(34) NOT NULL default '',
303	324	`login` varchar(64) NOT NULL default '',
304		`passwd` varchar(32) NOT NULL default '',
	325	`passwd` varchar(42) default NULL,
	326	`passwd_md5` varchar(32) NOT NULL default '',
305	327	`comment` text NOT NULL,
306	328	`status` enum('waiting','ok','ko') NOT NULL default 'waiting',
…	…
311	333	UNIQUE KEY `name` (`login`),
312	334	KEY `lang` (`lang`)
313		) TYPE=MyISAM;
	335	) TYPE=MyISAM COMMENT='2';
314	336
315	337	--
…	…
317	339	--
318	340
	341	DROP TABLE IF EXISTS `dntp_translator_msgstr`;
319	342	CREATE TABLE `dntp_translator_msgstr` (
320	343	`id` int(10) unsigned NOT NULL default '0',
…	…
327	350	--
328	351
	352	DROP TABLE IF EXISTS `global_data`;
329	353	CREATE TABLE `global_data` (
330	354	`name` varchar(32) NOT NULL default '',
…	…
337	361	--
338	362
	363	DROP TABLE IF EXISTS `invitation`;
339	364	CREATE TABLE `invitation` (
340	365	`id` varchar(34) NOT NULL default '',
…	…
348	373	--
349	374
	375	DROP TABLE IF EXISTS `invitation_email`;
350	376	CREATE TABLE `invitation_email` (
351	377	`id` varchar(34) NOT NULL default '',
…	…
370	396	--
371	397
	398	DROP TABLE IF EXISTS `message`;
372	399	CREATE TABLE `message` (
373	400	`id` varchar(34) default NULL,
…	…
394	421	--
395	422
	423	DROP TABLE IF EXISTS `metalbum`;
396	424	CREATE TABLE `metalbum` (
397	425	`id` varchar(32) NOT NULL default '',
…	…
406	434	--
407	435
	436	DROP TABLE IF EXISTS `relation`;
408	437	CREATE TABLE `relation` (
409	438	`id` varchar(34) NOT NULL default '',
…	…
425	454	--
426	455
	456	DROP TABLE IF EXISTS `rss_blog`;
427	457	CREATE TABLE `rss_blog` (
428	458	`id` varchar(34) NOT NULL default '',
…	…
439	469	--
440	470
	471	DROP TABLE IF EXISTS `rss_blog_ticket`;
441	472	CREATE TABLE `rss_blog_ticket` (
442	473	`id` varchar(34) NOT NULL default '',
…	…
457	488	--
458	489
	490	DROP TABLE IF EXISTS `session`;
459	491	CREATE TABLE `session` (
460	492	`id` varchar(32) binary NOT NULL default '',
…	…
469	501	--
470	502
	503	DROP TABLE IF EXISTS `settings`;
471	504	CREATE TABLE `settings` (
472	505	`id` varchar(34) NOT NULL default '',
…	…
489	522	--
490	523
	524	DROP TABLE IF EXISTS `todo`;
491	525	CREATE TABLE `todo` (
492	526	`id_todo` int(10) unsigned NOT NULL auto_increment,
…	…
508	542	--
509	543
	544	DROP TABLE IF EXISTS `user`;
510	545	CREATE TABLE `user` (
511	546	`id` varchar(34) NOT NULL default '',
512	547	`login` varchar(24) NOT NULL default '',
513		`passwd` varchar(32) NOT NULL default '',
	548	`passwd` varchar(42) binary default NULL,
	549	`passwd_md5` varchar(32) binary NOT NULL default '',
514	550	`fname` varchar(32) NOT NULL default '',
515	551	`lname` varchar(32) NOT NULL default '',
…	…
530	566	KEY `photo` (`photo`),
531	567	KEY `nick` (`nick`)
532		) TYPE=MyISAM;
	568	) TYPE=MyISAM COMMENT='2';
533	569
534	570	--
…	…
536	572	--
537	573
	574	DROP TABLE IF EXISTS `user_comm`;
538	575	CREATE TABLE `user_comm` (
539	576	`id` varchar(34) NOT NULL default '',
…	…
550	587	--
551	588
	589	DROP TABLE IF EXISTS `user_contact`;
552	590	CREATE TABLE `user_contact` (
553	591	`id` varchar(34) NOT NULL default '',
…	…
577	615	--
578	616
	617	DROP TABLE IF EXISTS `user_general`;
579	618	CREATE TABLE `user_general` (
580	619	`id` varchar(34) NOT NULL default '',
…	…
605	644	--
606	645
	646	DROP TABLE IF EXISTS `user_interests`;
607	647	CREATE TABLE `user_interests` (
608	648	`id` varchar(34) NOT NULL default '',
…	…
622	662	--
623	663
	664	DROP TABLE IF EXISTS `user_personal`;
624	665	CREATE TABLE `user_personal` (
625	666	`id` varchar(34) NOT NULL default '',
…	…
644	685	--
645	686
	687	DROP TABLE IF EXISTS `user_professional`;
646	688	CREATE TABLE `user_professional` (
647	689	`id` varchar(34) NOT NULL default '',
…	…
662	704	--
663	705
	706	DROP TABLE IF EXISTS `user_schools`;
664	707	CREATE TABLE `user_schools` (
665	708	`id` varchar(34) NOT NULL default '',
…	…
675	718	) TYPE=MyISAM;
676	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

Context Navigation

Changeset 33 for trunk/dotnode-struct.sql

Legend:

trunk/dotnode-struct.sql

Download in other formats: