Sending and fetching results feature complete

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

diff --git a/Server/application/models/database_dump.sql b/Server/application/models/database_dump.sql
index 4232936..a1c18e3 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-17 14:16:47 +0200
+# Generation Time: 2010-03-19 09:49:37 +0200
 # ************************************************************
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -43,6 +43,23 @@ VALUES
 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,
+  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
 # ------------------------------------------------------------
 
@@ -56,7 +73,7 @@ CREATE TABLE `users` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `login_unique` (`username`),
   UNIQUE KEY `email_unique` (`email`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;