#
# Host: localhost (MySQL 5.1.37)
# Database: speedfreak
-# Generation Time: 2010-03-09 13:03:37 +0200
+# Generation Time: 2010-03-19 11:11:11 +0200
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+# Dump of table categories
+# ------------------------------------------------------------
+
+DROP TABLE IF EXISTS `categories`;
+
+CREATE TABLE `categories` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `slug` varchar(255) NOT NULL,
+ `description` varchar(255) NOT NULL,
+ `unit` varchar(255) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `slug` (`slug`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
+
+LOCK TABLES `categories` WRITE;
+/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
+INSERT INTO `categories` (`id`,`slug`,`description`,`unit`)
+VALUES
+ (1,'acceleration-0-10','Acceleration from 0km/h to 100km/h','km/h'),
+ (2,'acceleration-0-40','Acceleration from 0km/h to 100km/h','km/h'),
+ (3,'acceleration-0-100','Acceleration from 0km/h to 100km/h','km/h');
+
+/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
+UNLOCK TABLES;
+
+
+# Dump of table results
+# ------------------------------------------------------------
+
+DROP TABLE IF EXISTS `results`;
+
+CREATE TABLE `results` (
+ `cat_id` int(11) NOT NULL,
+ `user_id` int(11) NOT NULL,
+ `value` text NOT NULL,
+ `result_date` datetime NOT NULL,
+ KEY `cat_id` (`cat_id`),
+ KEY `user_id` (`user_id`),
+ CONSTRAINT `results_ibfk_1` FOREIGN KEY (`cat_id`) REFERENCES `categories` (`id`),
+ CONSTRAINT `results_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+
+
# Dump of table users
# ------------------------------------------------------------
PRIMARY KEY (`id`),
UNIQUE KEY `login_unique` (`username`),
UNIQUE KEY `email_unique` (`email`)
-) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;