Changed category from 0-10 to 0-20

[speedfreak] / Server / application / models / database_dump.sql

diff --git a/Server/application/models/database_dump.sql b/Server/application/models/database_dump.sql
index a1c18e3..92aefd1 100644 (file)
--- a/Server/application/models/database_dump.sql
+++ b/Server/application/models/database_dump.sql
@@ -4,7 +4,7 @@
 #
 # Host: localhost (MySQL 5.1.37)
 # Database: speedfreak
-# Generation Time: 2010-03-19 09:49:37 +0200
+# Generation Time: 2010-03-19 11:11:11 +0200
 # ************************************************************
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -35,8 +35,8 @@ 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'),
+       (1,'acceleration-0-20','Acceleration from 0km/h to 20km/h','km/h'),
+       (2,'acceleration-0-40','Acceleration from 0km/h to 40km/h','km/h'),
        (3,'acceleration-0-100','Acceleration from 0km/h to 100km/h','km/h');
 
 /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
@@ -52,6 +52,7 @@ 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`),
@@ -73,7 +74,7 @@ CREATE TABLE `users` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `login_unique` (`username`),
   UNIQUE KEY `email_unique` (`email`)
-) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;