[virtualcommons-svn] SF.net SVN: virtualcommons:[260] mentalmodels/trunk/src/main/db/init-mme. sql

[<see...@us...>]

Revision: 260
          http://virtualcommons.svn.sourceforge.net/virtualcommons/?rev=260&view=rev
Author:   seematalele
Date:     2009-08-18 22:35:46 +0000 (Tue, 18 Aug 2009)

Log Message:
-----------


Modified Paths:
--------------
    mentalmodels/trunk/src/main/db/init-mme.sql

Modified: mentalmodels/trunk/src/main/db/init-mme.sql
===================================================================
--- mentalmodels/trunk/src/main/db/init-mme.sql	2009-08-18 22:24:40 UTC (rev 259)
+++ mentalmodels/trunk/src/main/db/init-mme.sql	2009-08-18 22:35:46 UTC (rev 260)
@@ -327,19 +327,6 @@
 -- Table structure for table `grp`
 --
 
-DROP TABLE IF EXISTS `grp`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `grp` (
-  `id` bigint(20) NOT NULL AUTO_INCREMENT,
-  `grp_number` int(11) NOT NULL,
-  `game_id` bigint(20) NOT NULL,
-  PRIMARY KEY (`id`),
-  KEY `FK190E57AC42F73` (`game_id`),
-  CONSTRAINT `FK190E57AC42F73` FOREIGN KEY (`game_id`) REFERENCES `game` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
 --
 -- Dumping data for table `grp`
 --
@@ -684,24 +671,6 @@
 -- Table structure for table `student`
 --
 
-DROP TABLE IF EXISTS `student`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `student` (
-  `id` bigint(20) NOT NULL AUTO_INCREMENT,
-  `birth_year` int(11) DEFAULT NULL,
-  `gender` varchar(255) DEFAULT NULL,
-  `major` varchar(255) DEFAULT NULL,
-  `semester` varchar(255) DEFAULT NULL,
-  `student_no` int(11) DEFAULT NULL,
-  `timestamp` datetime DEFAULT NULL,
-  `group_id` bigint(20) DEFAULT NULL,
-  PRIMARY KEY (`id`),
-  KEY `FK8FFE823B65663181` (`group_id`),
-  CONSTRAINT `FK8FFE823B65663181` FOREIGN KEY (`group_id`) REFERENCES `grp` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
 --
 -- Dumping data for table `student`
 --


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.