/century

Century Challenge Application for Leicester Forest CC

Primary LanguageJavaScript

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;