Navigation

Changeset 1186

Timestamp:

10/24/06 15:13:30 (2 years ago)

Author:

jm3

Message:

added born-on date for users

Files:

r1185	r1186
23	23	KEY `isPrivate_idx` (`isPrivate`),
24	24	KEY `createDate_idx` (`createDate`)
25		) ENGINE=MyISAM AUTO_INCREMENT=245744 DEFAULT CHARSET=latin1;
	25	) ENGINE=MyISAM AUTO_INCREMENT=245751 DEFAULT CHARSET=latin1;
26	26
27	27	--
…	…
52	52	KEY `userid_name_idx` (`userid`,`name`(32)),
53	53	KEY `id_userid_idx` (`ID`,`userid`)
54		) ENGINE=MyISAM AUTO_INCREMENT=179803 DEFAULT CHARSET=latin1;
	54	) ENGINE=MyISAM AUTO_INCREMENT=179811 DEFAULT CHARSET=latin1;
55	55
56	56	--
…	…
66	66	`timestamp` datetime default NULL,
67	67	PRIMARY KEY (`id`)
68		) ENGINE=MyISAM AUTO_INCREMENT=826757 DEFAULT CHARSET=latin1;
	68	) ENGINE=MyISAM AUTO_INCREMENT=826762 DEFAULT CHARSET=latin1;
69	69
70	70	--
…	…
83	83	`disabled` int(11) default NULL,
84	84	`snuffed` int(11) default NULL,
	85	`bornOn` timestamp NOT NULL default CURRENT_TIMESTAMP,
85	86	PRIMARY KEY (`ID`),
86	87	UNIQUE KEY `userid` (`userid`),
…	…
89	90	KEY `disabled_idx` (`disabled`),
90	91	KEY `snuffed_idx` (`snuffed`)
91		) ENGINE=MyISAM AUTO_INCREMENT=8420 DEFAULT CHARSET=latin1;
	92	) ENGINE=MyISAM AUTO_INCREMENT=8421 DEFAULT CHARSET=latin1;
92	93
93	94	--
…	…
103	104	`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
104	105	PRIMARY KEY (`id`)
105		) ENGINE=MyISAM AUTO_INCREMENT=236 DEFAULT CHARSET=latin1;
	106	) ENGINE=MyISAM AUTO_INCREMENT=237 DEFAULT CHARSET=latin1;
106	107