Context Navigation

Changeset 2885

Timestamp:

01/15/12 09:44:39 (4 months ago)

Author:

paparazzia

Message:

see #244

Location:

trunk

Files:

r2863	r2885
1	1	#Suppression des tracks cachÃ©es
2	2	UPDATE `users` SET color = SUBSTR(color, 2) WHERE LEFT(color, 1) = '-';
	3
	4	#Creation de la table racesgroups
	5	DROP TABLE IF EXISTS `racesgroups`;
	6	CREATE TABLE `racesgroups` (
	7	`idracesgroups` int(11) NOT NULL auto_increment,
	8	`grouptag` varchar(32) NOT NULL default '',
	9	`groupname` varchar(255) NOT NULL default '',
	10	`grouptitle` varchar(255) NOT NULL default '',
	11	`description` varchar(255) default NULL,
	12	`admincomments` varchar(255) default NULL,
	13	`updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
	14	PRIMARY KEY (`idracesgroups`),
	15	UNIQUE KEY `grouptag_idx` (`grouptag`)
	16	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='A racesgroup description';
	17
	18	#Creation de la table racestogroups
	19	DROP TABLE IF EXISTS `racestogroups`;
	20	CREATE TABLE `racestogroups` (
	21	`idracestogroups` int(11) NOT NULL auto_increment,
	22	`idraces` int(11) NOT NULL,
	23	`grouptag` varchar(32) NOT NULL default '',
	24	`updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
	25	PRIMARY KEY (`idracestogroups`),
	26	UNIQUE KEY `join_idx` (`idraces`, `grouptag`)
	27	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Join races with groups';
	28

r2844	r2885
43	43	"waypoints.php" => "Waypoints definitions",
44	44	"races_waypoints.php" => "Races_waypoints definitions",
	45	"block2" => "block",
	46	"racesgroups.php" => "Races groups definitions",
	47	"racestogroups.php" => "Join Races to RacesGroups",
45	48	);
46	49	adminlistbox($tablepages, "Race administration");