Century Challenge Please read TODO Application aimed to automate the process of collecting and collating century challenge data for LFCC DB: -- -- Table structure for table `ride` -- CREATE TABLE IF NOT EXISTS `ride` ( `ride_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `km` decimal(10,0) DEFAULT NULL, `url` mediumtext, `points` int(4) DEFAULT NULL, `date` datetime DEFAULT NULL, `date_added` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `details` longtext, PRIMARY KEY (`ride_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `username` text, `name` text, `forum_name` text, `active` tinyint(4) DEFAULT '0', `strava` text, PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;