Skip to content

Instantly share code, notes, and snippets.

@stepheneb

stepheneb/00-toc.md Secret

Created August 19, 2011 17:53
Show Gist options
  • Save stepheneb/d53b1f23fdd146066ce6 to your computer and use it in GitHub Desktop.
Save stepheneb/d53b1f23fdd146066ce6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
00-toc.md

Listed below are three files:

  1. 01-wise4-mysqldump.sql
  2. 02-wise4-trunk-mysqldump.sql
  3. 03-wise4-and-wise4-trunk-sql.diff

The first file: 01-wise4-mysqldump.sql is an sql dump of the sail_database and the vle_database from a new instance of WISE4 v4.3

The second file: 02-wise4-trunk-mysqldump.sql is an sql dump of the sail_database and the vle_database from a new instance of WISE4 v5 (trunk).

The third file: 03-wise4-and-wise4-trunk-sql.diff is the diff of the sql dump from WISE4 v4.3 with WISE4 v5 (trunk).

A large number of tables from the WISE4 v5 instance are empty that correspond to WISE4 v4.3 tables that have data. Examples include: acl_class; acl_entry; acl_object_identity; etc

A few tables appear to be similar such as: user_details; portal; etc.

Raw
01-wise4-mysqldump.sql
-- vagrant@lucid32:~$ mysqldump -uroot -ppassword sail_database
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
--
-- Host: localhost Database: sail_database
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.10-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `acl_class`
--
DROP TABLE IF EXISTS `acl_class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_class` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`class` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `class` (`class`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_class`
--
LOCK TABLES `acl_class` WRITE;
/*!40000 ALTER TABLE `acl_class` DISABLE KEYS */;
INSERT INTO `acl_class` VALUES (1,'org.telscenter.sail.webapp.domain.project.impl.ProjectImpl',NULL),(2,'org.telscenter.sail.webapp.domain.impl.RunImpl',NULL),(3,'org.telscenter.sail.webapp.domain.workgroup.impl.WISEWorkgroupImpl',NULL);
/*!40000 ALTER TABLE `acl_class` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_entry`
--
DROP TABLE IF EXISTS `acl_entry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_entry` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ace_order` int(11) NOT NULL,
`audit_failure` bit(1) NOT NULL,
`audit_success` bit(1) NOT NULL,
`granting` bit(1) NOT NULL,
`mask` int(11) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`sid` bigint(20) NOT NULL,
`acl_object_identity` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `acl_object_identity` (`acl_object_identity`,`ace_order`),
KEY `FK5302D47DC9975936` (`acl_object_identity`),
KEY `FK5302D47D9A4DE79D` (`sid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_entry`
--
LOCK TABLES `acl_entry` WRITE;
/*!40000 ALTER TABLE `acl_entry` DISABLE KEYS */;
INSERT INTO `acl_entry` VALUES (1,0,'\0','\0','',16,NULL,1,1),(2,0,'\0','\0','',16,NULL,1,2),(3,0,'\0','\0','',16,NULL,1,3),(4,0,'\0','\0','',16,NULL,1,4),(5,0,'\0','\0','',16,NULL,2,5);
/*!40000 ALTER TABLE `acl_entry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_object_identity`
--
DROP TABLE IF EXISTS `acl_object_identity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_object_identity` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`object_id_identity` bigint(20) NOT NULL,
`object_id_identity_num` int(11) DEFAULT NULL,
`entries_inheriting` bit(1) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`object_id_class` bigint(20) NOT NULL,
`owner_sid` bigint(20) DEFAULT NULL,
`parent_object` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `object_id_class` (`object_id_class`,`object_id_identity`),
KEY `FK2A2BB009BDC00DA1` (`parent_object`),
KEY `FK2A2BB0092458F1A3` (`object_id_class`),
KEY `FK2A2BB0099B5E7811` (`owner_sid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_object_identity`
--
LOCK TABLES `acl_object_identity` WRITE;
/*!40000 ALTER TABLE `acl_object_identity` DISABLE KEYS */;
INSERT INTO `acl_object_identity` VALUES (1,1,NULL,'',NULL,1,1,NULL),(2,2,NULL,'',NULL,1,1,NULL),(3,1,NULL,'',NULL,2,1,NULL),(4,1,NULL,'',NULL,3,1,NULL),(5,2,NULL,'',NULL,3,2,NULL);
/*!40000 ALTER TABLE `acl_object_identity` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_sid`
--
DROP TABLE IF EXISTS `acl_sid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_sid` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`principal` tinyint(1) NOT NULL,
`sid` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sid` (`sid`,`principal`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_sid`
--
LOCK TABLES `acl_sid` WRITE;
/*!40000 ALTER TABLE `acl_sid` DISABLE KEYS */;
INSERT INTO `acl_sid` VALUES (1,1,'admin',NULL),(2,1,'students0101',NULL);
/*!40000 ALTER TABLE `acl_sid` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `annotationbundles`
--
DROP TABLE IF EXISTS `annotationbundles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annotationbundles` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`bundle` longtext NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`workgroup_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKAA5FD222F54443B2` (`workgroup_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `annotationbundles`
--
LOCK TABLES `annotationbundles` WRITE;
/*!40000 ALTER TABLE `annotationbundles` DISABLE KEYS */;
/*!40000 ALTER TABLE `annotationbundles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `announcements`
--
DROP TABLE IF EXISTS `announcements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `announcements` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`announcement` text NOT NULL,
`timestamp` datetime NOT NULL,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `announcements`
--
LOCK TABLES `announcements` WRITE;
/*!40000 ALTER TABLE `announcements` DISABLE KEYS */;
/*!40000 ALTER TABLE `announcements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers`
--
DROP TABLE IF EXISTS `brainstormanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`isanonymous` bit(1) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK678121622B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers`
--
LOCK TABLES `brainstormanswers` WRITE;
/*!40000 ALTER TABLE `brainstormanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_answertags`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_answertags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_answertags` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`answer_tag_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`answer_tag_fk`),
UNIQUE KEY `answer_tag_fk` (`answer_tag_fk`),
KEY `FKB048F4EA995F00FD` (`answer_tag_fk`),
KEY `FKB048F4EA2605B8EA` (`brainstormanswers_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_answertags`
--
LOCK TABLES `brainstormanswers_related_to_answertags` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_answertags` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_answertags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_brainstormcomments`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_brainstormcomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_brainstormcomments` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`brainstormcomments_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`brainstormcomments_fk`),
UNIQUE KEY `brainstormcomments_fk` (`brainstormcomments_fk`),
KEY `FKCF105FBAA73BCAE9` (`brainstormcomments_fk`),
KEY `FKCF105FBA2605B8EA` (`brainstormanswers_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_brainstormcomments`
--
LOCK TABLES `brainstormanswers_related_to_brainstormcomments` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormcomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormcomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_brainstormrevisions`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_brainstormrevisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_brainstormrevisions` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`brainstormrevisions_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`brainstormrevisions_fk`),
UNIQUE KEY `brainstormrevisions_fk` (`brainstormrevisions_fk`),
KEY `FK8A39FAF2AA8628E4` (`brainstormrevisions_fk`),
KEY `FK8A39FAF22605B8EA` (`brainstormanswers_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_brainstormrevisions`
--
LOCK TABLES `brainstormanswers_related_to_brainstormrevisions` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormrevisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormrevisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_workgroups`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_workgroups` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`workgroups_fk`),
KEY `FK6398E0382605B8EA` (`brainstormanswers_fk`),
KEY `FK6398E0382B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_workgroups`
--
LOCK TABLES `brainstormanswers_related_to_workgroups` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_workgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswertags`
--
DROP TABLE IF EXISTS `brainstormanswertags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswertags` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`answer_tag_type` int(11) DEFAULT NULL,
`explanation` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`owner_workgroup_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKEC0DB8CA1A6D590D` (`owner_workgroup_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswertags`
--
LOCK TABLES `brainstormanswertags` WRITE;
/*!40000 ALTER TABLE `brainstormanswertags` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswertags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormcomments`
--
DROP TABLE IF EXISTS `brainstormcomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormcomments` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`isanonymous` bit(1) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK828192A72B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormcomments`
--
LOCK TABLES `brainstormcomments` WRITE;
/*!40000 ALTER TABLE `brainstormcomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormcomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormpreparedanswers`
--
DROP TABLE IF EXISTS `brainstormpreparedanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormpreparedanswers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`displayname` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormpreparedanswers`
--
LOCK TABLES `brainstormpreparedanswers` WRITE;
/*!40000 ALTER TABLE `brainstormpreparedanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormpreparedanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormquestions`
--
DROP TABLE IF EXISTS `brainstormquestions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormquestions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormquestions`
--
LOCK TABLES `brainstormquestions` WRITE;
/*!40000 ALTER TABLE `brainstormquestions` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormquestions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormrevisions`
--
DROP TABLE IF EXISTS `brainstormrevisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormrevisions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`displayname` varchar(255) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormrevisions`
--
LOCK TABLES `brainstormrevisions` WRITE;
/*!40000 ALTER TABLE `brainstormrevisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormrevisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms`
--
DROP TABLE IF EXISTS `brainstorms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`displaynameoption` int(11) DEFAULT NULL,
`isanonymousallowed` bit(1) DEFAULT NULL,
`isgated` bit(1) DEFAULT NULL,
`isinstantpollactive` bit(1) DEFAULT NULL,
`ispollended` bit(1) DEFAULT NULL,
`isrichtexteditorallowed` bit(1) DEFAULT NULL,
`parent_brainstorm_id` bigint(20) DEFAULT NULL,
`questiontype` int(11) DEFAULT NULL,
`starttime` datetime DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`projects_fk` bigint(20) DEFAULT NULL,
`brainstormquestions_fk` bigint(20) DEFAULT NULL,
`runs_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK174BDF2050B193C8` (`runs_fk`),
KEY `FK174BDF205E4D3D22` (`brainstormquestions_fk`),
KEY `FK174BDF20AC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms`
--
LOCK TABLES `brainstorms` WRITE;
/*!40000 ALTER TABLE `brainstorms` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms_related_to_brainstormanswers`
--
DROP TABLE IF EXISTS `brainstorms_related_to_brainstormanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms_related_to_brainstormanswers` (
`brainstorms_fk` bigint(20) NOT NULL,
`brainstormanswers_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstorms_fk`,`brainstormanswers_fk`),
UNIQUE KEY `brainstormanswers_fk` (`brainstormanswers_fk`),
KEY `FK477CA8F12605B8EA` (`brainstormanswers_fk`),
KEY `FK477CA8F179D46939` (`brainstorms_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms_related_to_brainstormanswers`
--
LOCK TABLES `brainstorms_related_to_brainstormanswers` WRITE;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms_related_to_brainstormpreparedanswers`
--
DROP TABLE IF EXISTS `brainstorms_related_to_brainstormpreparedanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms_related_to_brainstormpreparedanswers` (
`brainstorms_fk` bigint(20) NOT NULL,
`brainstormpreparedanswers_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstorms_fk`,`brainstormpreparedanswers_fk`),
UNIQUE KEY `brainstormpreparedanswers_fk` (`brainstormpreparedanswers_fk`),
KEY `FK5300A1437618004` (`brainstormpreparedanswers_fk`),
KEY `FK5300A1479D46939` (`brainstorms_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms_related_to_brainstormpreparedanswers`
--
LOCK TABLES `brainstorms_related_to_brainstormpreparedanswers` WRITE;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormpreparedanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormpreparedanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms_related_to_workgroups`
--
DROP TABLE IF EXISTS `brainstorms_related_to_workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms_related_to_workgroups` (
`brainstorms_fk` bigint(20) NOT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstorms_fk`,`workgroups_fk`),
KEY `FK6ED79B7679D46939` (`brainstorms_fk`),
KEY `FK6ED79B762B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms_related_to_workgroups`
--
LOCK TABLES `brainstorms_related_to_workgroups` WRITE;
/*!40000 ALTER TABLE `brainstorms_related_to_workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms_related_to_workgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `curnits`
--
DROP TABLE IF EXISTS `curnits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `curnits` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_curnit_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_curnit_fk` (`sds_curnit_fk`),
KEY `FK4329FBBA1B78E061` (`sds_curnit_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `curnits`
--
LOCK TABLES `curnits` WRITE;
/*!40000 ALTER TABLE `curnits` DISABLE KEYS */;
INSERT INTO `curnits` VALUES (1,NULL,0,NULL),(2,NULL,0,NULL);
/*!40000 ALTER TABLE `curnits` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `diyprojectcommunicators`
--
DROP TABLE IF EXISTS `diyprojectcommunicators`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diyprojectcommunicators` (
`diyportalhostname` varchar(255) DEFAULT NULL,
`previewdiyprojectsuffix` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK83FA9ED96FC1637F` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `diyprojectcommunicators`
--
LOCK TABLES `diyprojectcommunicators` WRITE;
/*!40000 ALTER TABLE `diyprojectcommunicators` DISABLE KEYS */;
/*!40000 ALTER TABLE `diyprojectcommunicators` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `externalprojects`
--
DROP TABLE IF EXISTS `externalprojects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `externalprojects` (
`external_id` bigint(20) DEFAULT NULL,
`id` bigint(20) NOT NULL,
`projectcommunicator_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKD8238145E48A3C0A` (`id`),
KEY `FKD8238145CE9C471A` (`projectcommunicator_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `externalprojects`
--
LOCK TABLES `externalprojects` WRITE;
/*!40000 ALTER TABLE `externalprojects` DISABLE KEYS */;
/*!40000 ALTER TABLE `externalprojects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `granted_authorities`
--
DROP TABLE IF EXISTS `granted_authorities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `granted_authorities` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`authority` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `authority` (`authority`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `granted_authorities`
--
LOCK TABLES `granted_authorities` WRITE;
/*!40000 ALTER TABLE `granted_authorities` DISABLE KEYS */;
INSERT INTO `granted_authorities` VALUES (1,'ROLE_USER',0),(2,'ROLE_ADMINISTRATOR',0),(3,'ROLE_TEACHER',0),(4,'ROLE_STUDENT',0),(5,'ROLE_AUTHOR',0),(6,'ROLE_RESEARCHER',0);
/*!40000 ALTER TABLE `granted_authorities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`parent_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKB63DD9D4E696E7FF` (`parent_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (1,'1',1,NULL),(2,' admin',0,NULL),(3,' students0101',0,NULL);
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups_related_to_users`
--
DROP TABLE IF EXISTS `groups_related_to_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups_related_to_users` (
`group_fk` bigint(20) NOT NULL,
`user_fk` bigint(20) NOT NULL,
PRIMARY KEY (`group_fk`,`user_fk`),
KEY `FK3311F7E3895EAE0A` (`group_fk`),
KEY `FK3311F7E356CA53B6` (`user_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups_related_to_users`
--
LOCK TABLES `groups_related_to_users` WRITE;
/*!40000 ALTER TABLE `groups_related_to_users` DISABLE KEYS */;
INSERT INTO `groups_related_to_users` VALUES (1,3),(2,1),(3,3);
/*!40000 ALTER TABLE `groups_related_to_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jaxbquestions`
--
DROP TABLE IF EXISTS `jaxbquestions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jaxbquestions` (
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK91A6B40C2C379613` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jaxbquestions`
--
LOCK TABLES `jaxbquestions` WRITE;
/*!40000 ALTER TABLE `jaxbquestions` DISABLE KEYS */;
/*!40000 ALTER TABLE `jaxbquestions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jnlps`
--
DROP TABLE IF EXISTS `jnlps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jnlps` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_jnlp_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_jnlp_fk` (`sds_jnlp_fk`),
KEY `FK6095FABA532A941` (`sds_jnlp_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jnlps`
--
LOCK TABLES `jnlps` WRITE;
/*!40000 ALTER TABLE `jnlps` DISABLE KEYS */;
/*!40000 ALTER TABLE `jnlps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_recipient`
--
DROP TABLE IF EXISTS `message_recipient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_recipient` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`isRead` bit(1) DEFAULT NULL,
`recipient_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK398E4FE1AAED82A8` (`recipient_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_recipient`
--
LOCK TABLES `message_recipient` WRITE;
/*!40000 ALTER TABLE `message_recipient` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_recipient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` varchar(255) NOT NULL,
`date` datetime NOT NULL,
`subject` varchar(255) NOT NULL,
`originalMessage` bigint(20) DEFAULT NULL,
`sender` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKE475014C298F8032` (`sender`),
KEY `FKE475014C895ABAC5` (`originalMessage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages_related_to_message_recipients`
--
DROP TABLE IF EXISTS `messages_related_to_message_recipients`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages_related_to_message_recipients` (
`messages_fk` bigint(20) NOT NULL,
`recipients_fk` bigint(20) NOT NULL,
PRIMARY KEY (`messages_fk`,`recipients_fk`),
UNIQUE KEY `recipients_fk` (`recipients_fk`),
KEY `FKB9B5242F9B0C1E47` (`messages_fk`),
KEY `FKB9B5242FE9D3BAD4` (`recipients_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages_related_to_message_recipients`
--
LOCK TABLES `messages_related_to_message_recipients` WRITE;
/*!40000 ALTER TABLE `messages_related_to_message_recipients` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages_related_to_message_recipients` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `modules`
--
DROP TABLE IF EXISTS `modules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modules` (
`authors` varchar(255) DEFAULT NULL,
`computer_time` bigint(20) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`grades` varchar(255) DEFAULT NULL,
`tech_reqs` varchar(255) DEFAULT NULL,
`topic_keywords` varchar(255) DEFAULT NULL,
`total_time` bigint(20) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK492927875E6F3BA6` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `modules`
--
LOCK TABLES `modules` WRITE;
/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
INSERT INTO `modules` VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(NULL,NULL,NULL,NULL,NULL,NULL,NULL,2);
/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `modules_related_to_owners`
--
DROP TABLE IF EXISTS `modules_related_to_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modules_related_to_owners` (
`module_fk` bigint(20) NOT NULL,
`owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`module_fk`,`owners_fk`),
KEY `FKE09C9839A4B723` (`module_fk`),
KEY `FKE09C9860AA7F41` (`owners_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `modules_related_to_owners`
--
LOCK TABLES `modules_related_to_owners` WRITE;
/*!40000 ALTER TABLE `modules_related_to_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `modules_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `newsitem`
--
DROP TABLE IF EXISTS `newsitem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `newsitem` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`news` text NOT NULL,
`title` varchar(255) NOT NULL,
`owner` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK532D646665E358B0` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `newsitem`
--
LOCK TABLES `newsitem` WRITE;
/*!40000 ALTER TABLE `newsitem` DISABLE KEYS */;
/*!40000 ALTER TABLE `newsitem` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `offerings`
--
DROP TABLE IF EXISTS `offerings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offerings` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_offering_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_offering_fk` (`sds_offering_fk`),
KEY `FK73F0F12DAB4F6201` (`sds_offering_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `offerings`
--
LOCK TABLES `offerings` WRITE;
/*!40000 ALTER TABLE `offerings` DISABLE KEYS */;
INSERT INTO `offerings` VALUES (1,1,NULL);
/*!40000 ALTER TABLE `offerings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `otmlmodules`
--
DROP TABLE IF EXISTS `otmlmodules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `otmlmodules` (
`otml` longblob,
`retrieveotmlurl` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK7DBC1CC39627A0C6` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `otmlmodules`
--
LOCK TABLES `otmlmodules` WRITE;
/*!40000 ALTER TABLE `otmlmodules` DISABLE KEYS */;
/*!40000 ALTER TABLE `otmlmodules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `portal`
--
DROP TABLE IF EXISTS `portal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portal` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`comments` varchar(255) DEFAULT NULL,
`google_map_key` varchar(255) DEFAULT NULL,
`sendmail_on_exception` bit(1) DEFAULT NULL,
`portalname` varchar(255) DEFAULT NULL,
`sendmail_properties` tinyblob,
`settings` text,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `portal`
--
LOCK TABLES `portal` WRITE;
/*!40000 ALTER TABLE `portal` DISABLE KEYS */;
INSERT INTO `portal` VALUES (0,NULL,NULL,NULL,'',NULL,NULL,'{\"isLoginAllowed\":true}',0);
/*!40000 ALTER TABLE `portal` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `portal_statistics`
--
DROP TABLE IF EXISTS `portal_statistics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portal_statistics` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT NULL,
`totalNumberProjects` bigint(20) DEFAULT NULL,
`totalNumberProjectsRun` bigint(20) DEFAULT NULL,
`totalNumberRuns` bigint(20) DEFAULT NULL,
`totalNumberStudentLogins` bigint(20) DEFAULT NULL,
`totalNumberStudents` bigint(20) DEFAULT NULL,
`totalNumberTeacherLogins` bigint(20) DEFAULT NULL,
`totalNumberTeachers` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `portal_statistics`
--
LOCK TABLES `portal_statistics` WRITE;
/*!40000 ALTER TABLE `portal_statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `portal_statistics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `premadecommentlists`
--
DROP TABLE IF EXISTS `premadecommentlists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `premadecommentlists` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`global` bit(1) DEFAULT NULL,
`label` varchar(255) NOT NULL,
`owner` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKF237B2CE65E358B0` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `premadecommentlists`
--
LOCK TABLES `premadecommentlists` WRITE;
/*!40000 ALTER TABLE `premadecommentlists` DISABLE KEYS */;
/*!40000 ALTER TABLE `premadecommentlists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `premadecomments`
--
DROP TABLE IF EXISTS `premadecomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `premadecomments` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`comment` varchar(255) NOT NULL,
`listposition` bigint(20) DEFAULT NULL,
`owner` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK7786D42C65E358B0` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `premadecomments`
--
LOCK TABLES `premadecomments` WRITE;
/*!40000 ALTER TABLE `premadecomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `premadecomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `premadecomments_related_to_premadecommentlists`
--
DROP TABLE IF EXISTS `premadecomments_related_to_premadecommentlists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `premadecomments_related_to_premadecommentlists` (
`premadecommentslist_fk` bigint(20) NOT NULL,
`premadecomments_fk` bigint(20) NOT NULL,
PRIMARY KEY (`premadecommentslist_fk`,`premadecomments_fk`),
KEY `FK6958FC11C8153CF5` (`premadecomments_fk`),
KEY `FK6958FC112FC6E4D5` (`premadecommentslist_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `premadecomments_related_to_premadecommentlists`
--
LOCK TABLES `premadecomments_related_to_premadecommentlists` WRITE;
/*!40000 ALTER TABLE `premadecomments_related_to_premadecommentlists` DISABLE KEYS */;
/*!40000 ALTER TABLE `premadecomments_related_to_premadecommentlists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_metadata`
--
DROP TABLE IF EXISTS `project_metadata`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project_metadata` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`author` varchar(255) DEFAULT NULL,
`comp_time` varchar(255) DEFAULT NULL,
`contact` varchar(255) DEFAULT NULL,
`grade_range` varchar(255) DEFAULT NULL,
`keywords` varchar(255) DEFAULT NULL,
`language` varchar(255) DEFAULT NULL,
`last_cleaned` datetime DEFAULT NULL,
`last_edited` datetime DEFAULT NULL,
`last_minified` datetime DEFAULT NULL,
`lesson_plan` text,
`max_scores` varchar(255) DEFAULT NULL,
`post_level` bigint(20) DEFAULT NULL,
`project_fk` bigint(20) DEFAULT NULL,
`standards` text,
`subject` varchar(255) DEFAULT NULL,
`summary` varchar(255) DEFAULT NULL,
`tech_reqs` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`tools` varchar(255) DEFAULT NULL,
`total_time` varchar(255) DEFAULT NULL,
`version_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_metadata`
--
LOCK TABLES `project_metadata` WRITE;
/*!40000 ALTER TABLE `project_metadata` DISABLE KEYS */;
INSERT INTO `project_metadata` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2011-08-10 14:13:44',NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,'{}','first_test_project','{}',NULL,NULL),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,'{}','first_test_project','{}',NULL,NULL);
/*!40000 ALTER TABLE `project_metadata` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projectcommunicators`
--
DROP TABLE IF EXISTS `projectcommunicators`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projectcommunicators` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`baseurl` varchar(255) DEFAULT NULL,
`latitude` varchar(255) DEFAULT NULL,
`longitude` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projectcommunicators`
--
LOCK TABLES `projectcommunicators` WRITE;
/*!40000 ALTER TABLE `projectcommunicators` DISABLE KEYS */;
/*!40000 ALTER TABLE `projectcommunicators` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects`
--
DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`datecreated` datetime NOT NULL,
`familytag` int(11) DEFAULT NULL,
`iscurrent` bit(1) DEFAULT NULL,
`ispublic` bit(1) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`parentprojectid` bigint(20) DEFAULT NULL,
`projecttype` int(11) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`curnit_fk` bigint(20) DEFAULT NULL,
`jnlp_fk` bigint(20) DEFAULT NULL,
`metadata_fk` bigint(20) DEFAULT NULL,
`run_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `metadata_fk` (`metadata_fk`),
UNIQUE KEY `run_fk` (`run_fk`),
KEY `FKC479187ABD6D05A5` (`run_fk`),
KEY `FKC479187A6E872393` (`metadata_fk`),
KEY `FKC479187A9568F016` (`jnlp_fk`),
KEY `FKC479187A7F08E576` (`curnit_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects`
--
LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
INSERT INTO `projects` VALUES (1,'2011-08-10 14:13:20',0,'','\0','first_test_project',NULL,4,0,1,NULL,1,NULL),(2,'2011-08-10 14:14:13',0,'','\0','first_test_project',1,4,0,2,NULL,2,NULL);
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_bookmarkers`
--
DROP TABLE IF EXISTS `projects_related_to_bookmarkers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_bookmarkers` (
`projects_fk` bigint(20) NOT NULL,
`bookmarkers` bigint(20) NOT NULL,
PRIMARY KEY (`projects_fk`,`bookmarkers`),
KEY `FK5AA350A531C3B66D` (`bookmarkers`),
KEY `FK5AA350A5AC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_bookmarkers`
--
LOCK TABLES `projects_related_to_bookmarkers` WRITE;
/*!40000 ALTER TABLE `projects_related_to_bookmarkers` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_bookmarkers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_owners`
--
DROP TABLE IF EXISTS `projects_related_to_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_owners` (
`projects_fk` bigint(20) NOT NULL,
`owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`projects_fk`,`owners_fk`),
KEY `FKDACF56CB60AA7F41` (`owners_fk`),
KEY `FKDACF56CBAC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_owners`
--
LOCK TABLES `projects_related_to_owners` WRITE;
/*!40000 ALTER TABLE `projects_related_to_owners` DISABLE KEYS */;
INSERT INTO `projects_related_to_owners` VALUES (1,1),(2,1);
/*!40000 ALTER TABLE `projects_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_shared_owners`
--
DROP TABLE IF EXISTS `projects_related_to_shared_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_shared_owners` (
`projects_fk` bigint(20) NOT NULL,
`shared_owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`projects_fk`,`shared_owners_fk`),
KEY `FK19A2B02FDB63ABE7` (`shared_owners_fk`),
KEY `FK19A2B02FAC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_shared_owners`
--
LOCK TABLES `projects_related_to_shared_owners` WRITE;
/*!40000 ALTER TABLE `projects_related_to_shared_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_shared_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_tags`
--
DROP TABLE IF EXISTS `projects_related_to_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_tags` (
`project_fk` bigint(20) NOT NULL,
`tag_fk` bigint(20) NOT NULL,
PRIMARY KEY (`project_fk`,`tag_fk`),
KEY `FK7A3DD584C525497A` (`tag_fk`),
KEY `FK7A3DD5846F1ED29A` (`project_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_tags`
--
LOCK TABLES `projects_related_to_tags` WRITE;
/*!40000 ALTER TABLE `projects_related_to_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs`
--
DROP TABLE IF EXISTS `runs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs` (
`archive_reminder` datetime NOT NULL,
`end_time` datetime DEFAULT NULL,
`extras` varchar(255) DEFAULT NULL,
`info` varchar(255) DEFAULT NULL,
`lastRun` datetime DEFAULT NULL,
`loggingLevel` int(11) DEFAULT NULL,
`maxWorkgroupSize` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`postLevel` int(11) DEFAULT NULL,
`run_code` varchar(255) NOT NULL,
`start_time` datetime NOT NULL,
`timesRun` int(11) DEFAULT NULL,
`versionId` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
`project_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `run_code` (`run_code`),
KEY `FK3597481834F8D3` (`id`),
KEY `FK3597486F1ED29A` (`project_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs`
--
LOCK TABLES `runs` WRITE;
/*!40000 ALTER TABLE `runs` DISABLE KEYS */;
INSERT INTO `runs` VALUES ('2011-09-09 14:14:13',NULL,NULL,NULL,'2011-08-10 14:14:54',NULL,3,'first_test_project',5,'Urchin548','2011-08-10 14:14:13',1,NULL,1,2);
/*!40000 ALTER TABLE `runs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_announcements`
--
DROP TABLE IF EXISTS `runs_related_to_announcements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_announcements` (
`runs_fk` bigint(20) NOT NULL,
`announcements_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`announcements_fk`),
UNIQUE KEY `announcements_fk` (`announcements_fk`),
KEY `FKEDEF47F33BC1BEB5` (`announcements_fk`),
KEY `FKEDEF47F350B193C8` (`runs_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_announcements`
--
LOCK TABLES `runs_related_to_announcements` WRITE;
/*!40000 ALTER TABLE `runs_related_to_announcements` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs_related_to_announcements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_groups`
--
DROP TABLE IF EXISTS `runs_related_to_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_groups` (
`runs_fk` bigint(20) NOT NULL,
`groups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`groups_fk`),
UNIQUE KEY `groups_fk` (`groups_fk`),
KEY `FK6CD673CD50B193C8` (`runs_fk`),
KEY `FK6CD673CD12D98E95` (`groups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_groups`
--
LOCK TABLES `runs_related_to_groups` WRITE;
/*!40000 ALTER TABLE `runs_related_to_groups` DISABLE KEYS */;
INSERT INTO `runs_related_to_groups` VALUES (1,1);
/*!40000 ALTER TABLE `runs_related_to_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_owners`
--
DROP TABLE IF EXISTS `runs_related_to_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_owners` (
`runs_fk` bigint(20) NOT NULL,
`owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`owners_fk`),
KEY `FK7AC2FE1950B193C8` (`runs_fk`),
KEY `FK7AC2FE1960AA7F41` (`owners_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_owners`
--
LOCK TABLES `runs_related_to_owners` WRITE;
/*!40000 ALTER TABLE `runs_related_to_owners` DISABLE KEYS */;
INSERT INTO `runs_related_to_owners` VALUES (1,1);
/*!40000 ALTER TABLE `runs_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_shared_owners`
--
DROP TABLE IF EXISTS `runs_related_to_shared_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_shared_owners` (
`runs_fk` bigint(20) NOT NULL,
`shared_owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`shared_owners_fk`),
KEY `FKBD30D521DB63ABE7` (`shared_owners_fk`),
KEY `FKBD30D52150B193C8` (`runs_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_shared_owners`
--
LOCK TABLES `runs_related_to_shared_owners` WRITE;
/*!40000 ALTER TABLE `runs_related_to_shared_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs_related_to_shared_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_curnits`
--
DROP TABLE IF EXISTS `sds_curnits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_curnits` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`curnit_id` bigint(20) NOT NULL,
`url` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `curnit_id` (`curnit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_curnits`
--
LOCK TABLES `sds_curnits` WRITE;
/*!40000 ALTER TABLE `sds_curnits` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_curnits` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_jnlps`
--
DROP TABLE IF EXISTS `sds_jnlps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_jnlps` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`jnlp_id` bigint(20) NOT NULL,
`url` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `jnlp_id` (`jnlp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_jnlps`
--
LOCK TABLES `sds_jnlps` WRITE;
/*!40000 ALTER TABLE `sds_jnlps` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_jnlps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_offerings`
--
DROP TABLE IF EXISTS `sds_offerings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_offerings` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`sds_curnitmap` longtext,
`offering_id` bigint(20) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_curnit_fk` bigint(20) NOT NULL,
`sds_jnlp_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `offering_id` (`offering_id`),
KEY `FK242EBD70A532A941` (`sds_jnlp_fk`),
KEY `FK242EBD701B78E061` (`sds_curnit_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_offerings`
--
LOCK TABLES `sds_offerings` WRITE;
/*!40000 ALTER TABLE `sds_offerings` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_offerings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_users`
--
DROP TABLE IF EXISTS `sds_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`user_id` bigint(20) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_users`
--
LOCK TABLES `sds_users` WRITE;
/*!40000 ALTER TABLE `sds_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_workgroups`
--
DROP TABLE IF EXISTS `sds_workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_workgroups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`workgroup_id` bigint(20) NOT NULL,
`sds_sessionbundle` longtext,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_offering_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `workgroup_id` (`workgroup_id`),
KEY `FK440A0C42AB4F6201` (`sds_offering_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_workgroups`
--
LOCK TABLES `sds_workgroups` WRITE;
/*!40000 ALTER TABLE `sds_workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_workgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_workgroups_related_to_sds_users`
--
DROP TABLE IF EXISTS `sds_workgroups_related_to_sds_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_workgroups_related_to_sds_users` (
`sds_workgroup_fk` bigint(20) NOT NULL,
`sds_user_fk` bigint(20) NOT NULL,
PRIMARY KEY (`sds_workgroup_fk`,`sds_user_fk`),
KEY `FKA31D36785AAC23E7` (`sds_workgroup_fk`),
KEY `FKA31D3678F342C661` (`sds_user_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_workgroups_related_to_sds_users`
--
LOCK TABLES `sds_workgroups_related_to_sds_users` WRITE;
/*!40000 ALTER TABLE `sds_workgroups_related_to_sds_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_workgroups_related_to_sds_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_user_details`
--
DROP TABLE IF EXISTS `student_user_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_user_details` (
`accountanswer` varchar(255) NOT NULL,
`accountquestion` varchar(255) NOT NULL,
`birthday` datetime NOT NULL,
`firstname` varchar(255) NOT NULL,
`gender` int(11) NOT NULL,
`lastlogintime` datetime DEFAULT NULL,
`lastname` varchar(255) NOT NULL,
`numberoflogins` int(11) NOT NULL,
`signupdate` datetime NOT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKC5AA2952D1D25907` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_user_details`
--
LOCK TABLES `student_user_details` WRITE;
/*!40000 ALTER TABLE `student_user_details` DISABLE KEYS */;
INSERT INTO `student_user_details` VALUES ('pass','QUESTION_ONE','2011-01-01 14:14:40','student',0,'2011-08-10 14:14:48','student',1,'2011-08-10 14:14:40',3);
/*!40000 ALTER TABLE `student_user_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tags`
--
DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tags`
--
LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teacher_user_details`
--
DROP TABLE IF EXISTS `teacher_user_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `teacher_user_details` (
`city` varchar(255) DEFAULT NULL,
`country` varchar(255) NOT NULL,
`curriculumsubjects` tinyblob NOT NULL,
`displayname` varchar(255) DEFAULT NULL,
`isEmailValid` bit(1) NOT NULL,
`firstname` varchar(255) NOT NULL,
`howDidYouHearAboutUs` varchar(255) DEFAULT NULL,
`lastlogintime` datetime DEFAULT NULL,
`lastname` varchar(255) NOT NULL,
`numberoflogins` int(11) NOT NULL,
`schoollevel` int(11) NOT NULL,
`schoolname` varchar(255) NOT NULL,
`signupdate` datetime NOT NULL,
`state` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKAC84070BD1D25907` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teacher_user_details`
--
LOCK TABLES `teacher_user_details` WRITE;
/*!40000 ALTER TABLE `teacher_user_details` DISABLE KEYS */;
INSERT INTO `teacher_user_details` VALUES ('Berkeley','USA','??\0ur\0[Ljava.lang.String;??V??{G\0\0xp\0\0\0t\0biology','adminuser','\0','ad',NULL,'2011-08-10 14:12:51','min',1,3,'Berkeley','2010-10-25 15:41:31','CA',1),('Berkeley','USA','??\0ur\0[Ljava.lang.String;??V??{G\0\0xp\0\0\0t\0biology','previewuser','\0','preview',NULL,NULL,'user',0,3,'Berkeley','2010-10-25 15:41:31','CA',2);
/*!40000 ALTER TABLE `teacher_user_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `urlmodules`
--
DROP TABLE IF EXISTS `urlmodules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `urlmodules` (
`module_url` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKC83237389627A0C6` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `urlmodules`
--
LOCK TABLES `urlmodules` WRITE;
/*!40000 ALTER TABLE `urlmodules` DISABLE KEYS */;
INSERT INTO `urlmodules` VALUES ('/1/wise4.project.json',1),('/2/wise4.project.json',2);
/*!40000 ALTER TABLE `urlmodules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_details`
--
DROP TABLE IF EXISTS `user_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_details` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_not_expired` bit(1) NOT NULL,
`account_not_locked` bit(1) NOT NULL,
`credentials_not_expired` bit(1) NOT NULL,
`email_address` varchar(255) DEFAULT NULL,
`enabled` bit(1) NOT NULL,
`recent_number_of_failed_login_attempts` int(11) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`recent_failed_login_time` datetime DEFAULT NULL,
`username` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_details`
--
LOCK TABLES `user_details` WRITE;
/*!40000 ALTER TABLE `user_details` DISABLE KEYS */;
INSERT INTO `user_details` VALUES (1,'','','',NULL,'',0,'24c002f26c14d8e087ade986531c7b5d',NULL,'admin',1),(2,'','','',NULL,'',NULL,'2ece21e1cf40509868e5a74a48d49a50',NULL,'previewuser',0),(3,'','','',NULL,'',0,'24c002f26c14d8e087ade986531c7b5d',NULL,'students0101',1);
/*!40000 ALTER TABLE `user_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_details_related_to_roles`
--
DROP TABLE IF EXISTS `user_details_related_to_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_details_related_to_roles` (
`user_details_fk` bigint(20) NOT NULL,
`granted_authorities_fk` bigint(20) NOT NULL,
PRIMARY KEY (`user_details_fk`,`granted_authorities_fk`),
KEY `FKE6A5FBDEE3B038C2` (`user_details_fk`),
KEY `FKE6A5FBDE44F8149A` (`granted_authorities_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_details_related_to_roles`
--
LOCK TABLES `user_details_related_to_roles` WRITE;
/*!40000 ALTER TABLE `user_details_related_to_roles` DISABLE KEYS */;
INSERT INTO `user_details_related_to_roles` VALUES (1,1),(1,2),(1,3),(1,5),(2,1),(2,3),(2,5),(3,1),(3,4);
/*!40000 ALTER TABLE `user_details_related_to_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_user_fk` bigint(20) DEFAULT NULL,
`user_details_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_details_fk` (`user_details_fk`),
UNIQUE KEY `sds_user_fk` (`sds_user_fk`),
KEY `FK6A68E08E3B038C2` (`user_details_fk`),
KEY `FK6A68E08F342C661` (`sds_user_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,0,NULL,1),(2,0,NULL,2),(3,0,NULL,3);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wiseworkgroups`
--
DROP TABLE IF EXISTS `wiseworkgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wiseworkgroups` (
`externalId` bigint(20) DEFAULT NULL,
`is_teacher_workgroup` bit(1) DEFAULT NULL,
`id` bigint(20) NOT NULL,
`period` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKF16C83C9F309B437` (`id`),
KEY `FKF16C83C93013AD46` (`period`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wiseworkgroups`
--
LOCK TABLES `wiseworkgroups` WRITE;
/*!40000 ALTER TABLE `wiseworkgroups` DISABLE KEYS */;
INSERT INTO `wiseworkgroups` VALUES (NULL,'',1,NULL),(NULL,'\0',2,1);
/*!40000 ALTER TABLE `wiseworkgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `workgroups`
--
DROP TABLE IF EXISTS `workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workgroups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`group_fk` bigint(20) NOT NULL,
`offering_fk` bigint(20) NOT NULL,
`sds_workgroup_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_workgroup_fk` (`sds_workgroup_fk`),
KEY `FKEC8E5025895EAE0A` (`group_fk`),
KEY `FKEC8E50255AAC23E7` (`sds_workgroup_fk`),
KEY `FKEC8E502553AE0756` (`offering_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `workgroups`
--
LOCK TABLES `workgroups` WRITE;
/*!40000 ALTER TABLE `workgroups` DISABLE KEYS */;
INSERT INTO `workgroups` VALUES (1,0,2,1,NULL),(2,0,3,1,NULL);
/*!40000 ALTER TABLE `workgroups` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-08-19 10:39:46
vagrant@lucid32:~$ mysqldump -uroot -ppassword vle_database
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
--
-- Host: localhost Database: vle_database
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.10-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `annotation`
--
DROP TABLE IF EXISTS `annotation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annotation` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`annotateTime` datetime DEFAULT NULL,
`postTime` datetime DEFAULT NULL,
`runId` bigint(20) DEFAULT NULL,
`stepWork_id` bigint(20) DEFAULT NULL,
`userInfo_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKA34FEB2FE8A0978C` (`stepWork_id`),
KEY `FKA34FEB2F206FE92` (`userInfo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `annotation`
--
LOCK TABLES `annotation` WRITE;
/*!40000 ALTER TABLE `annotation` DISABLE KEYS */;
/*!40000 ALTER TABLE `annotation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `annotation_comment`
--
DROP TABLE IF EXISTS `annotation_comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annotation_comment` (
`data` varchar(512) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKB3FAE14F5B80E7FE` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `annotation_comment`
--
LOCK TABLES `annotation_comment` WRITE;
/*!40000 ALTER TABLE `annotation_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `annotation_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `annotation_flag`
--
DROP TABLE IF EXISTS `annotation_flag`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annotation_flag` (
`data` varchar(512) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK6E89727C5B80E7FE` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `annotation_flag`
--
LOCK TABLES `annotation_flag` WRITE;
/*!40000 ALTER TABLE `annotation_flag` DISABLE KEYS */;
/*!40000 ALTER TABLE `annotation_flag` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `annotation_score`
--
DROP TABLE IF EXISTS `annotation_score`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annotation_score` (
`data` varchar(255) DEFAULT NULL,
`score` float DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK63582D825B80E7FE` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `annotation_score`
--
LOCK TABLES `annotation_score` WRITE;
/*!40000 ALTER TABLE `annotation_score` DISABLE KEYS */;
/*!40000 ALTER TABLE `annotation_score` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ideaBasket`
--
DROP TABLE IF EXISTS `ideaBasket`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ideaBasket` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`data` varchar(1024) DEFAULT NULL,
`postTime` datetime DEFAULT NULL,
`projectId` bigint(20) DEFAULT NULL,
`runId` bigint(20) DEFAULT NULL,
`workgroupId` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ideaBasket`
--
LOCK TABLES `ideaBasket` WRITE;
/*!40000 ALTER TABLE `ideaBasket` DISABLE KEYS */;
INSERT INTO `ideaBasket` VALUES (1,NULL,'2011-08-10 14:15:01',2,1,2);
/*!40000 ALTER TABLE `ideaBasket` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `journal`
--
DROP TABLE IF EXISTS `journal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `journal` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`data` varchar(1024) DEFAULT NULL,
`userInfo_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKAB64AF37206FE92` (`userInfo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `journal`
--
LOCK TABLES `journal` WRITE;
/*!40000 ALTER TABLE `journal` DISABLE KEYS */;
/*!40000 ALTER TABLE `journal` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `node`
--
DROP TABLE IF EXISTS `node`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `node` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nodeId` varchar(255) DEFAULT NULL,
`nodeType` varchar(255) DEFAULT NULL,
`runId` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `node`
--
LOCK TABLES `node` WRITE;
/*!40000 ALTER TABLE `node` DISABLE KEYS */;
INSERT INTO `node` VALUES (1,'node_0.or','OpenResponseNode','1');
/*!40000 ALTER TABLE `node` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `peerreviewgate`
--
DROP TABLE IF EXISTS `peerreviewgate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `peerreviewgate` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`open` bit(1) DEFAULT NULL,
`periodId` bigint(20) DEFAULT NULL,
`runId` bigint(20) DEFAULT NULL,
`node_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKD0AB7705D11C35FB` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `peerreviewgate`
--
LOCK TABLES `peerreviewgate` WRITE;
/*!40000 ALTER TABLE `peerreviewgate` DISABLE KEYS */;
/*!40000 ALTER TABLE `peerreviewgate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `peerreviewwork`
--
DROP TABLE IF EXISTS `peerreviewwork`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `peerreviewwork` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`periodId` bigint(20) DEFAULT NULL,
`runId` bigint(20) DEFAULT NULL,
`annotation_id` bigint(20) DEFAULT NULL,
`node_id` bigint(20) DEFAULT NULL,
`reviewerUserInfo_id` bigint(20) DEFAULT NULL,
`stepWork_id` bigint(20) DEFAULT NULL,
`userInfo_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKD0B2F14BD11C35FB` (`node_id`),
KEY `FKD0B2F14B2CBBDF0E` (`annotation_id`),
KEY `FKD0B2F14BD10BEB6D` (`reviewerUserInfo_id`),
KEY `FKD0B2F14BE8A0978C` (`stepWork_id`),
KEY `FKD0B2F14B206FE92` (`userInfo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `peerreviewwork`
--
LOCK TABLES `peerreviewwork` WRITE;
/*!40000 ALTER TABLE `peerreviewwork` DISABLE KEYS */;
/*!40000 ALTER TABLE `peerreviewwork` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork`
--
DROP TABLE IF EXISTS `stepwork`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`data` text,
`duplicateId` varchar(255) DEFAULT NULL,
`endTime` datetime DEFAULT NULL,
`postTime` datetime DEFAULT NULL,
`startTime` datetime DEFAULT NULL,
`node_id` bigint(20) DEFAULT NULL,
`userInfo_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK553587DDD11C35FB` (`node_id`),
KEY `FK553587DD206FE92` (`userInfo_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork`
--
LOCK TABLES `stepwork` WRITE;
/*!40000 ALTER TABLE `stepwork` DISABLE KEYS */;
INSERT INTO `stepwork` VALUES (1,'{\"nodeId\":\"node_0.or\",\"visitEndTime\":1313010904000,\"hintStates\":[],\"nodeStates\":[],\"visitStartTime\":1313010900000,\"nodeType\":\"OpenResponseNode\",\"visitPostTime\":null}',NULL,'2011-08-10 14:15:04','2011-08-10 14:15:04','2011-08-10 14:15:00',1,1);
/*!40000 ALTER TABLE `stepwork` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_al`
--
DROP TABLE IF EXISTS `stepwork_al`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_al` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKE06EFFCD831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_al`
--
LOCK TABLES `stepwork_al` WRITE;
/*!40000 ALTER TABLE `stepwork_al` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_al` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_branch`
--
DROP TABLE IF EXISTS `stepwork_branch`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_branch` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK10577844831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_branch`
--
LOCK TABLES `stepwork_branch` WRITE;
/*!40000 ALTER TABLE `stepwork_branch` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_branch` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_bs`
--
DROP TABLE IF EXISTS `stepwork_bs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_bs` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKE06EFFF3831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_bs`
--
LOCK TABLES `stepwork_bs` WRITE;
/*!40000 ALTER TABLE `stepwork_bs` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_bs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_cache`
--
DROP TABLE IF EXISTS `stepwork_cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_cache` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`cacheTime` datetime DEFAULT NULL,
`data` mediumtext,
`getRevisions` bit(1) DEFAULT NULL,
`userInfo_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK953280A0206FE92` (`userInfo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_cache`
--
LOCK TABLES `stepwork_cache` WRITE;
/*!40000 ALTER TABLE `stepwork_cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_cache` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_challenge`
--
DROP TABLE IF EXISTS `stepwork_challenge`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_challenge` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK35828E81831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_challenge`
--
LOCK TABLES `stepwork_challenge` WRITE;
/*!40000 ALTER TABLE `stepwork_challenge` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_challenge` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_fillin`
--
DROP TABLE IF EXISTS `stepwork_fillin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_fillin` (
`data` varchar(512) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK16B1008A831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_fillin`
--
LOCK TABLES `stepwork_fillin` WRITE;
/*!40000 ALTER TABLE `stepwork_fillin` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_fillin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_html`
--
DROP TABLE IF EXISTS `stepwork_html`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_html` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK80B19ACD831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_html`
--
LOCK TABLES `stepwork_html` WRITE;
/*!40000 ALTER TABLE `stepwork_html` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_html` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_matchsequence`
--
DROP TABLE IF EXISTS `stepwork_matchsequence`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_matchsequence` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKA1948FA4831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_matchsequence`
--
LOCK TABLES `stepwork_matchsequence` WRITE;
/*!40000 ALTER TABLE `stepwork_matchsequence` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_matchsequence` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_mc`
--
DROP TABLE IF EXISTS `stepwork_mc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_mc` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKE06F0138831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_mc`
--
LOCK TABLES `stepwork_mc` WRITE;
/*!40000 ALTER TABLE `stepwork_mc` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_mc` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_note`
--
DROP TABLE IF EXISTS `stepwork_note`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_note` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK80B44314831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_note`
--
LOCK TABLES `stepwork_note` WRITE;
/*!40000 ALTER TABLE `stepwork_note` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_note` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_or`
--
DROP TABLE IF EXISTS `stepwork_or`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_or` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKE06F0185831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_or`
--
LOCK TABLES `stepwork_or` WRITE;
/*!40000 ALTER TABLE `stepwork_or` DISABLE KEYS */;
INSERT INTO `stepwork_or` VALUES ('{\"nodeId\":\"node_0.or\",\"visitEndTime\":1313010904000,\"hintStates\":[],\"nodeStates\":[],\"visitStartTime\":1313010900000,\"nodeType\":\"OpenResponseNode\",\"visitPostTime\":null}',1);
/*!40000 ALTER TABLE `stepwork_or` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_sensor`
--
DROP TABLE IF EXISTS `stepwork_sensor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_sensor` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK2CA8A65C831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_sensor`
--
LOCK TABLES `stepwork_sensor` WRITE;
/*!40000 ALTER TABLE `stepwork_sensor` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_sensor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_svgdraw`
--
DROP TABLE IF EXISTS `stepwork_svgdraw`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_svgdraw` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK85051B46831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_svgdraw`
--
LOCK TABLES `stepwork_svgdraw` WRITE;
/*!40000 ALTER TABLE `stepwork_svgdraw` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_svgdraw` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stepwork_template`
--
DROP TABLE IF EXISTS `stepwork_template`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stepwork_template` (
`data` varchar(1024) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKB18FE9C831A3EA` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stepwork_template`
--
LOCK TABLES `stepwork_template` WRITE;
/*!40000 ALTER TABLE `stepwork_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `stepwork_template` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `userinfo`
--
DROP TABLE IF EXISTS `userinfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userinfo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workgroupId` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `workgroupId` (`workgroupId`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `userinfo`
--
LOCK TABLES `userinfo` WRITE;
/*!40000 ALTER TABLE `userinfo` DISABLE KEYS */;
INSERT INTO `userinfo` VALUES (1,2),(2,1);
/*!40000 ALTER TABLE `userinfo` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-08-19 10:39:57
Raw
02-wise4-trunk-mysqldump.sql
-- vagrant@lucid32:~$ mysqldump -uroot -ppassword sail_database
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
--
-- Host: localhost Database: sail_database
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.10-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `acl_class`
--
DROP TABLE IF EXISTS `acl_class`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_class` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`class` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `class` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_class`
--
LOCK TABLES `acl_class` WRITE;
/*!40000 ALTER TABLE `acl_class` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_class` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_entry`
--
DROP TABLE IF EXISTS `acl_entry`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_entry` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`ace_order` int(11) NOT NULL,
`audit_failure` bit(1) NOT NULL,
`audit_success` bit(1) NOT NULL,
`granting` bit(1) NOT NULL,
`mask` int(11) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`sid` bigint(20) NOT NULL,
`acl_object_identity` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `acl_object_identity` (`acl_object_identity`,`ace_order`),
KEY `FK5302D47DC9975936` (`acl_object_identity`),
KEY `FK5302D47D9A4DE79D` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_entry`
--
LOCK TABLES `acl_entry` WRITE;
/*!40000 ALTER TABLE `acl_entry` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_entry` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_object_identity`
--
DROP TABLE IF EXISTS `acl_object_identity`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_object_identity` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`object_id_identity` bigint(20) NOT NULL,
`object_id_identity_num` int(11) DEFAULT NULL,
`entries_inheriting` bit(1) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`object_id_class` bigint(20) NOT NULL,
`owner_sid` bigint(20) DEFAULT NULL,
`parent_object` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `object_id_class` (`object_id_class`,`object_id_identity`),
KEY `FK2A2BB009BDC00DA1` (`parent_object`),
KEY `FK2A2BB0092458F1A3` (`object_id_class`),
KEY `FK2A2BB0099B5E7811` (`owner_sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_object_identity`
--
LOCK TABLES `acl_object_identity` WRITE;
/*!40000 ALTER TABLE `acl_object_identity` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_object_identity` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `acl_sid`
--
DROP TABLE IF EXISTS `acl_sid`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `acl_sid` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`principal` tinyint(1) NOT NULL,
`sid` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sid` (`sid`,`principal`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `acl_sid`
--
LOCK TABLES `acl_sid` WRITE;
/*!40000 ALTER TABLE `acl_sid` DISABLE KEYS */;
/*!40000 ALTER TABLE `acl_sid` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `annotationbundles`
--
DROP TABLE IF EXISTS `annotationbundles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annotationbundles` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`bundle` longtext NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`workgroup_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKAA5FD222F54443B2` (`workgroup_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `annotationbundles`
--
LOCK TABLES `annotationbundles` WRITE;
/*!40000 ALTER TABLE `annotationbundles` DISABLE KEYS */;
/*!40000 ALTER TABLE `annotationbundles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `announcements`
--
DROP TABLE IF EXISTS `announcements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `announcements` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`announcement` text NOT NULL,
`timestamp` datetime NOT NULL,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `announcements`
--
LOCK TABLES `announcements` WRITE;
/*!40000 ALTER TABLE `announcements` DISABLE KEYS */;
/*!40000 ALTER TABLE `announcements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers`
--
DROP TABLE IF EXISTS `brainstormanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`isanonymous` bit(1) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK678121622B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers`
--
LOCK TABLES `brainstormanswers` WRITE;
/*!40000 ALTER TABLE `brainstormanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_answertags`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_answertags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_answertags` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`answer_tag_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`answer_tag_fk`),
UNIQUE KEY `answer_tag_fk` (`answer_tag_fk`),
KEY `FKB048F4EA995F00FD` (`answer_tag_fk`),
KEY `FKB048F4EA2605B8EA` (`brainstormanswers_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_answertags`
--
LOCK TABLES `brainstormanswers_related_to_answertags` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_answertags` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_answertags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_brainstormcomments`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_brainstormcomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_brainstormcomments` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`brainstormcomments_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`brainstormcomments_fk`),
UNIQUE KEY `brainstormcomments_fk` (`brainstormcomments_fk`),
KEY `FKCF105FBAA73BCAE9` (`brainstormcomments_fk`),
KEY `FKCF105FBA2605B8EA` (`brainstormanswers_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_brainstormcomments`
--
LOCK TABLES `brainstormanswers_related_to_brainstormcomments` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormcomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormcomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_brainstormrevisions`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_brainstormrevisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_brainstormrevisions` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`brainstormrevisions_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`brainstormrevisions_fk`),
UNIQUE KEY `brainstormrevisions_fk` (`brainstormrevisions_fk`),
KEY `FK8A39FAF2AA8628E4` (`brainstormrevisions_fk`),
KEY `FK8A39FAF22605B8EA` (`brainstormanswers_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_brainstormrevisions`
--
LOCK TABLES `brainstormanswers_related_to_brainstormrevisions` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormrevisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_brainstormrevisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswers_related_to_workgroups`
--
DROP TABLE IF EXISTS `brainstormanswers_related_to_workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswers_related_to_workgroups` (
`brainstormanswers_fk` bigint(20) NOT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstormanswers_fk`,`workgroups_fk`),
KEY `FK6398E0382605B8EA` (`brainstormanswers_fk`),
KEY `FK6398E0382B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswers_related_to_workgroups`
--
LOCK TABLES `brainstormanswers_related_to_workgroups` WRITE;
/*!40000 ALTER TABLE `brainstormanswers_related_to_workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswers_related_to_workgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormanswertags`
--
DROP TABLE IF EXISTS `brainstormanswertags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormanswertags` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`answer_tag_type` int(11) DEFAULT NULL,
`explanation` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`owner_workgroup_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKEC0DB8CA1A6D590D` (`owner_workgroup_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormanswertags`
--
LOCK TABLES `brainstormanswertags` WRITE;
/*!40000 ALTER TABLE `brainstormanswertags` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormanswertags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormcomments`
--
DROP TABLE IF EXISTS `brainstormcomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormcomments` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`isanonymous` bit(1) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK828192A72B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormcomments`
--
LOCK TABLES `brainstormcomments` WRITE;
/*!40000 ALTER TABLE `brainstormcomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormcomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormpreparedanswers`
--
DROP TABLE IF EXISTS `brainstormpreparedanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormpreparedanswers` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`displayname` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormpreparedanswers`
--
LOCK TABLES `brainstormpreparedanswers` WRITE;
/*!40000 ALTER TABLE `brainstormpreparedanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormpreparedanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormquestions`
--
DROP TABLE IF EXISTS `brainstormquestions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormquestions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormquestions`
--
LOCK TABLES `brainstormquestions` WRITE;
/*!40000 ALTER TABLE `brainstormquestions` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormquestions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstormrevisions`
--
DROP TABLE IF EXISTS `brainstormrevisions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstormrevisions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` text,
`displayname` varchar(255) DEFAULT NULL,
`timestamp` datetime NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstormrevisions`
--
LOCK TABLES `brainstormrevisions` WRITE;
/*!40000 ALTER TABLE `brainstormrevisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstormrevisions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms`
--
DROP TABLE IF EXISTS `brainstorms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`displaynameoption` int(11) DEFAULT NULL,
`isanonymousallowed` bit(1) DEFAULT NULL,
`isgated` bit(1) DEFAULT NULL,
`isinstantpollactive` bit(1) DEFAULT NULL,
`ispollended` bit(1) DEFAULT NULL,
`isrichtexteditorallowed` bit(1) DEFAULT NULL,
`parent_brainstorm_id` bigint(20) DEFAULT NULL,
`questiontype` int(11) DEFAULT NULL,
`starttime` datetime DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`projects_fk` bigint(20) DEFAULT NULL,
`brainstormquestions_fk` bigint(20) DEFAULT NULL,
`runs_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK174BDF2050B193C8` (`runs_fk`),
KEY `FK174BDF205E4D3D22` (`brainstormquestions_fk`),
KEY `FK174BDF20AC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms`
--
LOCK TABLES `brainstorms` WRITE;
/*!40000 ALTER TABLE `brainstorms` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms_related_to_brainstormanswers`
--
DROP TABLE IF EXISTS `brainstorms_related_to_brainstormanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms_related_to_brainstormanswers` (
`brainstorms_fk` bigint(20) NOT NULL,
`brainstormanswers_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstorms_fk`,`brainstormanswers_fk`),
UNIQUE KEY `brainstormanswers_fk` (`brainstormanswers_fk`),
KEY `FK477CA8F12605B8EA` (`brainstormanswers_fk`),
KEY `FK477CA8F179D46939` (`brainstorms_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms_related_to_brainstormanswers`
--
LOCK TABLES `brainstorms_related_to_brainstormanswers` WRITE;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms_related_to_brainstormpreparedanswers`
--
DROP TABLE IF EXISTS `brainstorms_related_to_brainstormpreparedanswers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms_related_to_brainstormpreparedanswers` (
`brainstorms_fk` bigint(20) NOT NULL,
`brainstormpreparedanswers_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstorms_fk`,`brainstormpreparedanswers_fk`),
UNIQUE KEY `brainstormpreparedanswers_fk` (`brainstormpreparedanswers_fk`),
KEY `FK5300A1437618004` (`brainstormpreparedanswers_fk`),
KEY `FK5300A1479D46939` (`brainstorms_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms_related_to_brainstormpreparedanswers`
--
LOCK TABLES `brainstorms_related_to_brainstormpreparedanswers` WRITE;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormpreparedanswers` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms_related_to_brainstormpreparedanswers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `brainstorms_related_to_workgroups`
--
DROP TABLE IF EXISTS `brainstorms_related_to_workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `brainstorms_related_to_workgroups` (
`brainstorms_fk` bigint(20) NOT NULL,
`workgroups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`brainstorms_fk`,`workgroups_fk`),
KEY `FK6ED79B7679D46939` (`brainstorms_fk`),
KEY `FK6ED79B762B7BFD8A` (`workgroups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `brainstorms_related_to_workgroups`
--
LOCK TABLES `brainstorms_related_to_workgroups` WRITE;
/*!40000 ALTER TABLE `brainstorms_related_to_workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `brainstorms_related_to_workgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `curnits`
--
DROP TABLE IF EXISTS `curnits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `curnits` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_curnit_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_curnit_fk` (`sds_curnit_fk`),
KEY `FK4329FBBA1B78E061` (`sds_curnit_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `curnits`
--
LOCK TABLES `curnits` WRITE;
/*!40000 ALTER TABLE `curnits` DISABLE KEYS */;
/*!40000 ALTER TABLE `curnits` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `diyprojectcommunicators`
--
DROP TABLE IF EXISTS `diyprojectcommunicators`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `diyprojectcommunicators` (
`diyportalhostname` varchar(255) DEFAULT NULL,
`previewdiyprojectsuffix` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK83FA9ED96FC1637F` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `diyprojectcommunicators`
--
LOCK TABLES `diyprojectcommunicators` WRITE;
/*!40000 ALTER TABLE `diyprojectcommunicators` DISABLE KEYS */;
/*!40000 ALTER TABLE `diyprojectcommunicators` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `externalprojects`
--
DROP TABLE IF EXISTS `externalprojects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `externalprojects` (
`external_id` bigint(20) DEFAULT NULL,
`id` bigint(20) NOT NULL,
`projectcommunicator_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKD8238145E48A3C0A` (`id`),
KEY `FKD8238145CE9C471A` (`projectcommunicator_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `externalprojects`
--
LOCK TABLES `externalprojects` WRITE;
/*!40000 ALTER TABLE `externalprojects` DISABLE KEYS */;
/*!40000 ALTER TABLE `externalprojects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `granted_authorities`
--
DROP TABLE IF EXISTS `granted_authorities`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `granted_authorities` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`authority` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `authority` (`authority`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `granted_authorities`
--
LOCK TABLES `granted_authorities` WRITE;
/*!40000 ALTER TABLE `granted_authorities` DISABLE KEYS */;
INSERT INTO `granted_authorities` VALUES (1,'ROLE_USER',0),(2,'ROLE_ADMINISTRATOR',0),(3,'ROLE_TEACHER',0),(4,'ROLE_STUDENT',0),(5,'ROLE_AUTHOR',0),(6,'ROLE_RESEARCHER',0);
/*!40000 ALTER TABLE `granted_authorities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`parent_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKB63DD9D4E696E7FF` (`parent_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups`
--
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `groups_related_to_users`
--
DROP TABLE IF EXISTS `groups_related_to_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups_related_to_users` (
`group_fk` bigint(20) NOT NULL,
`user_fk` bigint(20) NOT NULL,
PRIMARY KEY (`group_fk`,`user_fk`),
KEY `FK3311F7E3895EAE0A` (`group_fk`),
KEY `FK3311F7E356CA53B6` (`user_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `groups_related_to_users`
--
LOCK TABLES `groups_related_to_users` WRITE;
/*!40000 ALTER TABLE `groups_related_to_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `groups_related_to_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jaxbquestions`
--
DROP TABLE IF EXISTS `jaxbquestions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jaxbquestions` (
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK91A6B40C2C379613` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jaxbquestions`
--
LOCK TABLES `jaxbquestions` WRITE;
/*!40000 ALTER TABLE `jaxbquestions` DISABLE KEYS */;
/*!40000 ALTER TABLE `jaxbquestions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jnlps`
--
DROP TABLE IF EXISTS `jnlps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jnlps` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_jnlp_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_jnlp_fk` (`sds_jnlp_fk`),
KEY `FK6095FABA532A941` (`sds_jnlp_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jnlps`
--
LOCK TABLES `jnlps` WRITE;
/*!40000 ALTER TABLE `jnlps` DISABLE KEYS */;
/*!40000 ALTER TABLE `jnlps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_recipient`
--
DROP TABLE IF EXISTS `message_recipient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_recipient` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`isRead` bit(1) DEFAULT NULL,
`recipient_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK398E4FE1AAED82A8` (`recipient_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_recipient`
--
LOCK TABLES `message_recipient` WRITE;
/*!40000 ALTER TABLE `message_recipient` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_recipient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`body` varchar(255) NOT NULL,
`date` datetime NOT NULL,
`subject` varchar(255) NOT NULL,
`originalMessage` bigint(20) DEFAULT NULL,
`sender` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKE475014C298F8032` (`sender`),
KEY `FKE475014C895ABAC5` (`originalMessage`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages`
--
LOCK TABLES `messages` WRITE;
/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `messages_related_to_message_recipients`
--
DROP TABLE IF EXISTS `messages_related_to_message_recipients`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messages_related_to_message_recipients` (
`messages_fk` bigint(20) NOT NULL,
`recipients_fk` bigint(20) NOT NULL,
PRIMARY KEY (`messages_fk`,`recipients_fk`),
UNIQUE KEY `recipients_fk` (`recipients_fk`),
KEY `FKB9B5242F9B0C1E47` (`messages_fk`),
KEY `FKB9B5242FE9D3BAD4` (`recipients_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `messages_related_to_message_recipients`
--
LOCK TABLES `messages_related_to_message_recipients` WRITE;
/*!40000 ALTER TABLE `messages_related_to_message_recipients` DISABLE KEYS */;
/*!40000 ALTER TABLE `messages_related_to_message_recipients` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `modules`
--
DROP TABLE IF EXISTS `modules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modules` (
`authors` varchar(255) DEFAULT NULL,
`computer_time` bigint(20) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`grades` varchar(255) DEFAULT NULL,
`tech_reqs` varchar(255) DEFAULT NULL,
`topic_keywords` varchar(255) DEFAULT NULL,
`total_time` bigint(20) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK492927875E6F3BA6` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `modules`
--
LOCK TABLES `modules` WRITE;
/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `modules_related_to_owners`
--
DROP TABLE IF EXISTS `modules_related_to_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modules_related_to_owners` (
`module_fk` bigint(20) NOT NULL,
`owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`module_fk`,`owners_fk`),
KEY `FKE09C9839A4B723` (`module_fk`),
KEY `FKE09C9860AA7F41` (`owners_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `modules_related_to_owners`
--
LOCK TABLES `modules_related_to_owners` WRITE;
/*!40000 ALTER TABLE `modules_related_to_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `modules_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `newsitem`
--
DROP TABLE IF EXISTS `newsitem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `newsitem` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`news` text NOT NULL,
`title` varchar(255) NOT NULL,
`owner` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK532D646665E358B0` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `newsitem`
--
LOCK TABLES `newsitem` WRITE;
/*!40000 ALTER TABLE `newsitem` DISABLE KEYS */;
/*!40000 ALTER TABLE `newsitem` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `offerings`
--
DROP TABLE IF EXISTS `offerings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `offerings` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_offering_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_offering_fk` (`sds_offering_fk`),
KEY `FK73F0F12DAB4F6201` (`sds_offering_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `offerings`
--
LOCK TABLES `offerings` WRITE;
/*!40000 ALTER TABLE `offerings` DISABLE KEYS */;
/*!40000 ALTER TABLE `offerings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `otmlmodules`
--
DROP TABLE IF EXISTS `otmlmodules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `otmlmodules` (
`otml` longblob,
`retrieveotmlurl` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FK7DBC1CC39627A0C6` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `otmlmodules`
--
LOCK TABLES `otmlmodules` WRITE;
/*!40000 ALTER TABLE `otmlmodules` DISABLE KEYS */;
/*!40000 ALTER TABLE `otmlmodules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `portal`
--
DROP TABLE IF EXISTS `portal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portal` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`comments` varchar(255) DEFAULT NULL,
`google_map_key` varchar(255) DEFAULT NULL,
`sendmail_on_exception` bit(1) DEFAULT NULL,
`portalname` varchar(255) DEFAULT NULL,
`sendmail_properties` tinyblob,
`settings` text,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `portal`
--
LOCK TABLES `portal` WRITE;
/*!40000 ALTER TABLE `portal` DISABLE KEYS */;
INSERT INTO `portal` VALUES (0,NULL,NULL,NULL,'',NULL,NULL,'{\"isLoginAllowed\":true}',0);
/*!40000 ALTER TABLE `portal` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `portal_statistics`
--
DROP TABLE IF EXISTS `portal_statistics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portal_statistics` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`timestamp` datetime DEFAULT NULL,
`totalNumberProjects` bigint(20) DEFAULT NULL,
`totalNumberProjectsRun` bigint(20) DEFAULT NULL,
`totalNumberRuns` bigint(20) DEFAULT NULL,
`totalNumberStudentLogins` bigint(20) DEFAULT NULL,
`totalNumberStudents` bigint(20) DEFAULT NULL,
`totalNumberTeacherLogins` bigint(20) DEFAULT NULL,
`totalNumberTeachers` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `portal_statistics`
--
LOCK TABLES `portal_statistics` WRITE;
/*!40000 ALTER TABLE `portal_statistics` DISABLE KEYS */;
/*!40000 ALTER TABLE `portal_statistics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `premadecommentlists`
--
DROP TABLE IF EXISTS `premadecommentlists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `premadecommentlists` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`global` bit(1) DEFAULT NULL,
`label` varchar(255) NOT NULL,
`owner` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKF237B2CE65E358B0` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `premadecommentlists`
--
LOCK TABLES `premadecommentlists` WRITE;
/*!40000 ALTER TABLE `premadecommentlists` DISABLE KEYS */;
/*!40000 ALTER TABLE `premadecommentlists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `premadecomments`
--
DROP TABLE IF EXISTS `premadecomments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `premadecomments` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`comment` varchar(255) NOT NULL,
`listposition` bigint(20) DEFAULT NULL,
`owner` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK7786D42C65E358B0` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `premadecomments`
--
LOCK TABLES `premadecomments` WRITE;
/*!40000 ALTER TABLE `premadecomments` DISABLE KEYS */;
/*!40000 ALTER TABLE `premadecomments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `premadecomments_related_to_premadecommentlists`
--
DROP TABLE IF EXISTS `premadecomments_related_to_premadecommentlists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `premadecomments_related_to_premadecommentlists` (
`premadecommentslist_fk` bigint(20) NOT NULL,
`premadecomments_fk` bigint(20) NOT NULL,
PRIMARY KEY (`premadecommentslist_fk`,`premadecomments_fk`),
KEY `FK6958FC11C8153CF5` (`premadecomments_fk`),
KEY `FK6958FC112FC6E4D5` (`premadecommentslist_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `premadecomments_related_to_premadecommentlists`
--
LOCK TABLES `premadecomments_related_to_premadecommentlists` WRITE;
/*!40000 ALTER TABLE `premadecomments_related_to_premadecommentlists` DISABLE KEYS */;
/*!40000 ALTER TABLE `premadecomments_related_to_premadecommentlists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `project_metadata`
--
DROP TABLE IF EXISTS `project_metadata`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project_metadata` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`author` varchar(255) DEFAULT NULL,
`comp_time` varchar(255) DEFAULT NULL,
`contact` varchar(255) DEFAULT NULL,
`grade_range` varchar(255) DEFAULT NULL,
`keywords` varchar(255) DEFAULT NULL,
`language` varchar(255) DEFAULT NULL,
`last_cleaned` datetime DEFAULT NULL,
`last_edited` datetime DEFAULT NULL,
`last_minified` datetime DEFAULT NULL,
`lesson_plan` text,
`max_scores` varchar(255) DEFAULT NULL,
`post_level` bigint(20) DEFAULT NULL,
`project_fk` bigint(20) DEFAULT NULL,
`standards` text,
`subject` varchar(255) DEFAULT NULL,
`summary` varchar(255) DEFAULT NULL,
`tech_reqs` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`tools` varchar(255) DEFAULT NULL,
`total_time` varchar(255) DEFAULT NULL,
`version_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `project_metadata`
--
LOCK TABLES `project_metadata` WRITE;
/*!40000 ALTER TABLE `project_metadata` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_metadata` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projectcommunicators`
--
DROP TABLE IF EXISTS `projectcommunicators`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projectcommunicators` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`address` varchar(255) DEFAULT NULL,
`baseurl` varchar(255) DEFAULT NULL,
`latitude` varchar(255) DEFAULT NULL,
`longitude` varchar(255) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projectcommunicators`
--
LOCK TABLES `projectcommunicators` WRITE;
/*!40000 ALTER TABLE `projectcommunicators` DISABLE KEYS */;
/*!40000 ALTER TABLE `projectcommunicators` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects`
--
DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`datecreated` datetime NOT NULL,
`familytag` int(11) DEFAULT NULL,
`iscurrent` bit(1) DEFAULT NULL,
`ispublic` bit(1) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`parentprojectid` bigint(20) DEFAULT NULL,
`projecttype` int(11) DEFAULT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`curnit_fk` bigint(20) DEFAULT NULL,
`jnlp_fk` bigint(20) DEFAULT NULL,
`metadata_fk` bigint(20) DEFAULT NULL,
`run_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `metadata_fk` (`metadata_fk`),
UNIQUE KEY `run_fk` (`run_fk`),
KEY `FKC479187ABD6D05A5` (`run_fk`),
KEY `FKC479187A6E872393` (`metadata_fk`),
KEY `FKC479187A9568F016` (`jnlp_fk`),
KEY `FKC479187A7F08E576` (`curnit_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects`
--
LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_bookmarkers`
--
DROP TABLE IF EXISTS `projects_related_to_bookmarkers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_bookmarkers` (
`projects_fk` bigint(20) NOT NULL,
`bookmarkers` bigint(20) NOT NULL,
PRIMARY KEY (`projects_fk`,`bookmarkers`),
KEY `FK5AA350A531C3B66D` (`bookmarkers`),
KEY `FK5AA350A5AC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_bookmarkers`
--
LOCK TABLES `projects_related_to_bookmarkers` WRITE;
/*!40000 ALTER TABLE `projects_related_to_bookmarkers` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_bookmarkers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_owners`
--
DROP TABLE IF EXISTS `projects_related_to_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_owners` (
`projects_fk` bigint(20) NOT NULL,
`owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`projects_fk`,`owners_fk`),
KEY `FKDACF56CB60AA7F41` (`owners_fk`),
KEY `FKDACF56CBAC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_owners`
--
LOCK TABLES `projects_related_to_owners` WRITE;
/*!40000 ALTER TABLE `projects_related_to_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_shared_owners`
--
DROP TABLE IF EXISTS `projects_related_to_shared_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_shared_owners` (
`projects_fk` bigint(20) NOT NULL,
`shared_owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`projects_fk`,`shared_owners_fk`),
KEY `FK19A2B02FDB63ABE7` (`shared_owners_fk`),
KEY `FK19A2B02FAC92FD99` (`projects_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_shared_owners`
--
LOCK TABLES `projects_related_to_shared_owners` WRITE;
/*!40000 ALTER TABLE `projects_related_to_shared_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_shared_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `projects_related_to_tags`
--
DROP TABLE IF EXISTS `projects_related_to_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_related_to_tags` (
`project_fk` bigint(20) NOT NULL,
`tag_fk` bigint(20) NOT NULL,
PRIMARY KEY (`project_fk`,`tag_fk`),
KEY `FK7A3DD584C525497A` (`tag_fk`),
KEY `FK7A3DD5846F1ED29A` (`project_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `projects_related_to_tags`
--
LOCK TABLES `projects_related_to_tags` WRITE;
/*!40000 ALTER TABLE `projects_related_to_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_related_to_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs`
--
DROP TABLE IF EXISTS `runs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs` (
`archive_reminder` datetime NOT NULL,
`end_time` datetime DEFAULT NULL,
`extras` varchar(255) DEFAULT NULL,
`info` varchar(255) DEFAULT NULL,
`lastRun` datetime DEFAULT NULL,
`loggingLevel` int(11) DEFAULT NULL,
`maxWorkgroupSize` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`postLevel` int(11) DEFAULT NULL,
`run_code` varchar(255) NOT NULL,
`start_time` datetime NOT NULL,
`timesRun` int(11) DEFAULT NULL,
`versionId` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
`project_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `run_code` (`run_code`),
KEY `FK3597481834F8D3` (`id`),
KEY `FK3597486F1ED29A` (`project_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs`
--
LOCK TABLES `runs` WRITE;
/*!40000 ALTER TABLE `runs` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_announcements`
--
DROP TABLE IF EXISTS `runs_related_to_announcements`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_announcements` (
`runs_fk` bigint(20) NOT NULL,
`announcements_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`announcements_fk`),
UNIQUE KEY `announcements_fk` (`announcements_fk`),
KEY `FKEDEF47F33BC1BEB5` (`announcements_fk`),
KEY `FKEDEF47F350B193C8` (`runs_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_announcements`
--
LOCK TABLES `runs_related_to_announcements` WRITE;
/*!40000 ALTER TABLE `runs_related_to_announcements` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs_related_to_announcements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_groups`
--
DROP TABLE IF EXISTS `runs_related_to_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_groups` (
`runs_fk` bigint(20) NOT NULL,
`groups_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`groups_fk`),
UNIQUE KEY `groups_fk` (`groups_fk`),
KEY `FK6CD673CD50B193C8` (`runs_fk`),
KEY `FK6CD673CD12D98E95` (`groups_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_groups`
--
LOCK TABLES `runs_related_to_groups` WRITE;
/*!40000 ALTER TABLE `runs_related_to_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs_related_to_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_owners`
--
DROP TABLE IF EXISTS `runs_related_to_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_owners` (
`runs_fk` bigint(20) NOT NULL,
`owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`owners_fk`),
KEY `FK7AC2FE1950B193C8` (`runs_fk`),
KEY `FK7AC2FE1960AA7F41` (`owners_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_owners`
--
LOCK TABLES `runs_related_to_owners` WRITE;
/*!40000 ALTER TABLE `runs_related_to_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `runs_related_to_shared_owners`
--
DROP TABLE IF EXISTS `runs_related_to_shared_owners`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `runs_related_to_shared_owners` (
`runs_fk` bigint(20) NOT NULL,
`shared_owners_fk` bigint(20) NOT NULL,
PRIMARY KEY (`runs_fk`,`shared_owners_fk`),
KEY `FKBD30D521DB63ABE7` (`shared_owners_fk`),
KEY `FKBD30D52150B193C8` (`runs_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `runs_related_to_shared_owners`
--
LOCK TABLES `runs_related_to_shared_owners` WRITE;
/*!40000 ALTER TABLE `runs_related_to_shared_owners` DISABLE KEYS */;
/*!40000 ALTER TABLE `runs_related_to_shared_owners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_curnits`
--
DROP TABLE IF EXISTS `sds_curnits`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_curnits` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`curnit_id` bigint(20) NOT NULL,
`url` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `curnit_id` (`curnit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_curnits`
--
LOCK TABLES `sds_curnits` WRITE;
/*!40000 ALTER TABLE `sds_curnits` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_curnits` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_jnlps`
--
DROP TABLE IF EXISTS `sds_jnlps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_jnlps` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`jnlp_id` bigint(20) NOT NULL,
`url` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `jnlp_id` (`jnlp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_jnlps`
--
LOCK TABLES `sds_jnlps` WRITE;
/*!40000 ALTER TABLE `sds_jnlps` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_jnlps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_offerings`
--
DROP TABLE IF EXISTS `sds_offerings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_offerings` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`sds_curnitmap` longtext,
`offering_id` bigint(20) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_curnit_fk` bigint(20) NOT NULL,
`sds_jnlp_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `offering_id` (`offering_id`),
KEY `FK242EBD70A532A941` (`sds_jnlp_fk`),
KEY `FK242EBD701B78E061` (`sds_curnit_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_offerings`
--
LOCK TABLES `sds_offerings` WRITE;
/*!40000 ALTER TABLE `sds_offerings` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_offerings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_users`
--
DROP TABLE IF EXISTS `sds_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`user_id` bigint(20) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_users`
--
LOCK TABLES `sds_users` WRITE;
/*!40000 ALTER TABLE `sds_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_workgroups`
--
DROP TABLE IF EXISTS `sds_workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_workgroups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`workgroup_id` bigint(20) NOT NULL,
`sds_sessionbundle` longtext,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_offering_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `workgroup_id` (`workgroup_id`),
KEY `FK440A0C42AB4F6201` (`sds_offering_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_workgroups`
--
LOCK TABLES `sds_workgroups` WRITE;
/*!40000 ALTER TABLE `sds_workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_workgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sds_workgroups_related_to_sds_users`
--
DROP TABLE IF EXISTS `sds_workgroups_related_to_sds_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sds_workgroups_related_to_sds_users` (
`sds_workgroup_fk` bigint(20) NOT NULL,
`sds_user_fk` bigint(20) NOT NULL,
PRIMARY KEY (`sds_workgroup_fk`,`sds_user_fk`),
KEY `FKA31D36785AAC23E7` (`sds_workgroup_fk`),
KEY `FKA31D3678F342C661` (`sds_user_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sds_workgroups_related_to_sds_users`
--
LOCK TABLES `sds_workgroups_related_to_sds_users` WRITE;
/*!40000 ALTER TABLE `sds_workgroups_related_to_sds_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `sds_workgroups_related_to_sds_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_attendance`
--
DROP TABLE IF EXISTS `student_attendance`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_attendance` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`absentUserIds` varchar(255) DEFAULT NULL,
`loginTimestamp` datetime DEFAULT NULL,
`presentUserIds` varchar(255) DEFAULT NULL,
`runId` bigint(20) DEFAULT NULL,
`workgroupId` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_attendance`
--
LOCK TABLES `student_attendance` WRITE;
/*!40000 ALTER TABLE `student_attendance` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_attendance` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `student_user_details`
--
DROP TABLE IF EXISTS `student_user_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_user_details` (
`accountanswer` varchar(255) NOT NULL,
`accountquestion` varchar(255) NOT NULL,
`birthday` datetime NOT NULL,
`firstname` varchar(255) NOT NULL,
`gender` int(11) NOT NULL,
`lastlogintime` datetime DEFAULT NULL,
`lastname` varchar(255) NOT NULL,
`numberoflogins` int(11) NOT NULL,
`signupdate` datetime NOT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKC5AA2952D1D25907` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `student_user_details`
--
LOCK TABLES `student_user_details` WRITE;
/*!40000 ALTER TABLE `student_user_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_user_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tags`
--
DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tags`
--
LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `teacher_user_details`
--
DROP TABLE IF EXISTS `teacher_user_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `teacher_user_details` (
`city` varchar(255) DEFAULT NULL,
`country` varchar(255) NOT NULL,
`curriculumsubjects` tinyblob,
`displayname` varchar(255) DEFAULT NULL,
`isEmailValid` bit(1) NOT NULL,
`firstname` varchar(255) NOT NULL,
`howDidYouHearAboutUs` varchar(255) DEFAULT NULL,
`lastlogintime` datetime DEFAULT NULL,
`lastname` varchar(255) NOT NULL,
`numberoflogins` int(11) NOT NULL,
`schoollevel` int(11) NOT NULL,
`schoolname` varchar(255) NOT NULL,
`signupdate` datetime NOT NULL,
`state` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKAC84070BD1D25907` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `teacher_user_details`
--
LOCK TABLES `teacher_user_details` WRITE;
/*!40000 ALTER TABLE `teacher_user_details` DISABLE KEYS */;
INSERT INTO `teacher_user_details` VALUES ('Berkeley','USA',NULL,'adminuser','\0','ad',NULL,'2011-08-19 10:45:34','min',2,3,'Berkeley','2010-10-25 15:41:31','CA',1),('Berkeley','USA',NULL,'previewuser','\0','preview',NULL,NULL,'user',0,3,'Berkeley','2010-10-25 15:41:31','CA',2);
/*!40000 ALTER TABLE `teacher_user_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `urlmodules`
--
DROP TABLE IF EXISTS `urlmodules`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `urlmodules` (
`module_url` varchar(255) DEFAULT NULL,
`id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `FKC83237389627A0C6` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `urlmodules`
--
LOCK TABLES `urlmodules` WRITE;
/*!40000 ALTER TABLE `urlmodules` DISABLE KEYS */;
/*!40000 ALTER TABLE `urlmodules` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_details`
--
DROP TABLE IF EXISTS `user_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_details` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_not_expired` bit(1) NOT NULL,
`account_not_locked` bit(1) NOT NULL,
`credentials_not_expired` bit(1) NOT NULL,
`email_address` varchar(255) DEFAULT NULL,
`enabled` bit(1) NOT NULL,
`recent_number_of_failed_login_attempts` int(11) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`recent_failed_login_time` datetime DEFAULT NULL,
`username` varchar(255) NOT NULL,
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_details`
--
LOCK TABLES `user_details` WRITE;
/*!40000 ALTER TABLE `user_details` DISABLE KEYS */;
INSERT INTO `user_details` VALUES (1,'','','',NULL,'',0,'24c002f26c14d8e087ade986531c7b5d',NULL,'admin',2),(2,'','','',NULL,'',NULL,'2ece21e1cf40509868e5a74a48d49a50',NULL,'previewuser',0);
/*!40000 ALTER TABLE `user_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_details_related_to_roles`
--
DROP TABLE IF EXISTS `user_details_related_to_roles`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_details_related_to_roles` (
`user_details_fk` bigint(20) NOT NULL,
`granted_authorities_fk` bigint(20) NOT NULL,
PRIMARY KEY (`user_details_fk`,`granted_authorities_fk`),
KEY `FKE6A5FBDEE3B038C2` (`user_details_fk`),
KEY `FKE6A5FBDE44F8149A` (`granted_authorities_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_details_related_to_roles`
--
LOCK TABLES `user_details_related_to_roles` WRITE;
/*!40000 ALTER TABLE `user_details_related_to_roles` DISABLE KEYS */;
INSERT INTO `user_details_related_to_roles` VALUES (1,1),(1,2),(1,3),(1,5),(2,1),(2,3),(2,5);
/*!40000 ALTER TABLE `user_details_related_to_roles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`sds_user_fk` bigint(20) DEFAULT NULL,
`user_details_fk` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_details_fk` (`user_details_fk`),
UNIQUE KEY `sds_user_fk` (`sds_user_fk`),
KEY `FK6A68E08E3B038C2` (`user_details_fk`),
KEY `FK6A68E08F342C661` (`sds_user_fk`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,0,NULL,1),(2,0,NULL,2);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wiseworkgroups`
--
DROP TABLE IF EXISTS `wiseworkgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wiseworkgroups` (
`externalId` bigint(20) DEFAULT NULL,
`is_teacher_workgroup` bit(1) DEFAULT NULL,
`id` bigint(20) NOT NULL,
`period` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKF16C83C9F309B437` (`id`),
KEY `FKF16C83C93013AD46` (`period`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wiseworkgroups`
--
LOCK TABLES `wiseworkgroups` WRITE;
/*!40000 ALTER TABLE `wiseworkgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `wiseworkgroups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `workgroups`
--
DROP TABLE IF EXISTS `workgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workgroups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`OPTLOCK` int(11) DEFAULT NULL,
`group_fk` bigint(20) NOT NULL,
`offering_fk` bigint(20) NOT NULL,
`sds_workgroup_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sds_workgroup_fk` (`sds_workgroup_fk`),
KEY `FKEC8E5025895EAE0A` (`group_fk`),
KEY `FKEC8E50255AAC23E7` (`sds_workgroup_fk`),
KEY `FKEC8E502553AE0756` (`offering_fk`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `workgroups`
--
LOCK TABLES `workgroups` WRITE;
/*!40000 ALTER TABLE `workgroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `workgroups` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-08-19 13:45:43
vagrant@lucid32:~$ mysqldump -uroot -ppassword vle_database
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
--
-- Host: localhost Database: vle_database
-- ------------------------------------------------------
-- Server version 5.1.41-3ubuntu12.10-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-08-19 13:45:48
Raw
03-wise4-and-wise4-trunk-sql.diff
--- wise4-mysqldump.sql 2011-08-19 13:42:49.000000000 -0400
+++ wise4-trunk-mysqldump.sql 2011-08-19 13:46:28.000000000 -0400
@@ -29,7 +29,7 @@
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `class` (`class`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -38,7 +38,6 @@
LOCK TABLES `acl_class` WRITE;
/*!40000 ALTER TABLE `acl_class` DISABLE KEYS */;
-INSERT INTO `acl_class` VALUES (1,'org.telscenter.sail.webapp.domain.project.impl.ProjectImpl',NULL),(2,'org.telscenter.sail.webapp.domain.impl.RunImpl',NULL),(3,'org.telscenter.sail.webapp.domain.workgroup.impl.WISEWorkgroupImpl',NULL);
/*!40000 ALTER TABLE `acl_class` ENABLE KEYS */;
UNLOCK TABLES;
@@ -63,7 +62,7 @@
UNIQUE KEY `acl_object_identity` (`acl_object_identity`,`ace_order`),
KEY `FK5302D47DC9975936` (`acl_object_identity`),
KEY `FK5302D47D9A4DE79D` (`sid`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -72,7 +71,6 @@
LOCK TABLES `acl_entry` WRITE;
/*!40000 ALTER TABLE `acl_entry` DISABLE KEYS */;
-INSERT INTO `acl_entry` VALUES (1,0,'\0','\0','',16,NULL,1,1),(2,0,'\0','\0','',16,NULL,1,2),(3,0,'\0','\0','',16,NULL,1,3),(4,0,'\0','\0','',16,NULL,1,4),(5,0,'\0','\0','',16,NULL,2,5);
/*!40000 ALTER TABLE `acl_entry` ENABLE KEYS */;
UNLOCK TABLES;
@@ -97,7 +95,7 @@
KEY `FK2A2BB009BDC00DA1` (`parent_object`),
KEY `FK2A2BB0092458F1A3` (`object_id_class`),
KEY `FK2A2BB0099B5E7811` (`owner_sid`)
-) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -106,7 +104,6 @@
LOCK TABLES `acl_object_identity` WRITE;
/*!40000 ALTER TABLE `acl_object_identity` DISABLE KEYS */;
-INSERT INTO `acl_object_identity` VALUES (1,1,NULL,'',NULL,1,1,NULL),(2,2,NULL,'',NULL,1,1,NULL),(3,1,NULL,'',NULL,2,1,NULL),(4,1,NULL,'',NULL,3,1,NULL),(5,2,NULL,'',NULL,3,2,NULL);
/*!40000 ALTER TABLE `acl_object_identity` ENABLE KEYS */;
UNLOCK TABLES;
@@ -124,7 +121,7 @@
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sid` (`sid`,`principal`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -133,7 +130,6 @@
LOCK TABLES `acl_sid` WRITE;
/*!40000 ALTER TABLE `acl_sid` DISABLE KEYS */;
-INSERT INTO `acl_sid` VALUES (1,1,'admin',NULL),(2,1,'students0101',NULL);
/*!40000 ALTER TABLE `acl_sid` ENABLE KEYS */;
UNLOCK TABLES;
@@ -577,7 +573,7 @@
PRIMARY KEY (`id`),
UNIQUE KEY `sds_curnit_fk` (`sds_curnit_fk`),
KEY `FK4329FBBA1B78E061` (`sds_curnit_fk`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -586,7 +582,6 @@
LOCK TABLES `curnits` WRITE;
/*!40000 ALTER TABLE `curnits` DISABLE KEYS */;
-INSERT INTO `curnits` VALUES (1,NULL,0,NULL),(2,NULL,0,NULL);
/*!40000 ALTER TABLE `curnits` ENABLE KEYS */;
UNLOCK TABLES;
@@ -681,7 +676,7 @@
`parent_fk` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKB63DD9D4E696E7FF` (`parent_fk`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -690,7 +685,6 @@
LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
-INSERT INTO `groups` VALUES (1,'1',1,NULL),(2,' admin',0,NULL),(3,' students0101',0,NULL);
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;
@@ -716,7 +710,6 @@
LOCK TABLES `groups_related_to_users` WRITE;
/*!40000 ALTER TABLE `groups_related_to_users` DISABLE KEYS */;
-INSERT INTO `groups_related_to_users` VALUES (1,3),(2,1),(3,3);
/*!40000 ALTER TABLE `groups_related_to_users` ENABLE KEYS */;
UNLOCK TABLES;
@@ -876,7 +869,6 @@
LOCK TABLES `modules` WRITE;
/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
-INSERT INTO `modules` VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(NULL,NULL,NULL,NULL,NULL,NULL,NULL,2);
/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
UNLOCK TABLES;
@@ -946,7 +938,7 @@
PRIMARY KEY (`id`),
UNIQUE KEY `sds_offering_fk` (`sds_offering_fk`),
KEY `FK73F0F12DAB4F6201` (`sds_offering_fk`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -955,7 +947,6 @@
LOCK TABLES `offerings` WRITE;
/*!40000 ALTER TABLE `offerings` DISABLE KEYS */;
-INSERT INTO `offerings` VALUES (1,1,NULL);
/*!40000 ALTER TABLE `offerings` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1153,7 +1144,7 @@
`total_time` varchar(255) DEFAULT NULL,
`version_id` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -1162,7 +1153,6 @@
LOCK TABLES `project_metadata` WRITE;
/*!40000 ALTER TABLE `project_metadata` DISABLE KEYS */;
-INSERT INTO `project_metadata` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2011-08-10 14:13:44',NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,'{}','first_test_project','{}',NULL,NULL),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,'{}','first_test_project','{}',NULL,NULL);
/*!40000 ALTER TABLE `project_metadata` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1221,7 +1211,7 @@
KEY `FKC479187A6E872393` (`metadata_fk`),
KEY `FKC479187A9568F016` (`jnlp_fk`),
KEY `FKC479187A7F08E576` (`curnit_fk`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -1230,7 +1220,6 @@
LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
-INSERT INTO `projects` VALUES (1,'2011-08-10 14:13:20',0,'','\0','first_test_project',NULL,4,0,1,NULL,1,NULL),(2,'2011-08-10 14:14:13',0,'','\0','first_test_project',1,4,0,2,NULL,2,NULL);
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1281,7 +1270,6 @@
LOCK TABLES `projects_related_to_owners` WRITE;
/*!40000 ALTER TABLE `projects_related_to_owners` DISABLE KEYS */;
-INSERT INTO `projects_related_to_owners` VALUES (1,1),(2,1);
/*!40000 ALTER TABLE `projects_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1371,7 +1359,6 @@
LOCK TABLES `runs` WRITE;
/*!40000 ALTER TABLE `runs` DISABLE KEYS */;
-INSERT INTO `runs` VALUES ('2011-09-09 14:14:13',NULL,NULL,NULL,'2011-08-10 14:14:54',NULL,3,'first_test_project',5,'Urchin548','2011-08-10 14:14:13',1,NULL,1,2);
/*!40000 ALTER TABLE `runs` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1424,7 +1411,6 @@
LOCK TABLES `runs_related_to_groups` WRITE;
/*!40000 ALTER TABLE `runs_related_to_groups` DISABLE KEYS */;
-INSERT INTO `runs_related_to_groups` VALUES (1,1);
/*!40000 ALTER TABLE `runs_related_to_groups` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1450,7 +1436,6 @@
LOCK TABLES `runs_related_to_owners` WRITE;
/*!40000 ALTER TABLE `runs_related_to_owners` DISABLE KEYS */;
-INSERT INTO `runs_related_to_owners` VALUES (1,1);
/*!40000 ALTER TABLE `runs_related_to_owners` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1646,6 +1631,33 @@
UNLOCK TABLES;
--
+-- Table structure for table `student_attendance`
+--
+
+DROP TABLE IF EXISTS `student_attendance`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `student_attendance` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `absentUserIds` varchar(255) DEFAULT NULL,
+ `loginTimestamp` datetime DEFAULT NULL,
+ `presentUserIds` varchar(255) DEFAULT NULL,
+ `runId` bigint(20) DEFAULT NULL,
+ `workgroupId` bigint(20) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `student_attendance`
+--
+
+LOCK TABLES `student_attendance` WRITE;
+/*!40000 ALTER TABLE `student_attendance` DISABLE KEYS */;
+/*!40000 ALTER TABLE `student_attendance` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `student_user_details`
--
@@ -1674,7 +1686,6 @@
LOCK TABLES `student_user_details` WRITE;
/*!40000 ALTER TABLE `student_user_details` DISABLE KEYS */;
-INSERT INTO `student_user_details` VALUES ('pass','QUESTION_ONE','2011-01-01 14:14:40','student',0,'2011-08-10 14:14:48','student',1,'2011-08-10 14:14:40',3);
/*!40000 ALTER TABLE `student_user_details` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1711,7 +1722,7 @@
CREATE TABLE `teacher_user_details` (
`city` varchar(255) DEFAULT NULL,
`country` varchar(255) NOT NULL,
- `curriculumsubjects` tinyblob NOT NULL,
+ `curriculumsubjects` tinyblob,
`displayname` varchar(255) DEFAULT NULL,
`isEmailValid` bit(1) NOT NULL,
`firstname` varchar(255) NOT NULL,
@@ -1735,7 +1746,7 @@
LOCK TABLES `teacher_user_details` WRITE;
/*!40000 ALTER TABLE `teacher_user_details` DISABLE KEYS */;
-INSERT INTO `teacher_user_details` VALUES ('Berkeley','USA','??\0ur\0[Ljava.lang.String;??V??{G\0\0xp\0\0\0t\0biology','adminuser','\0','ad',NULL,'2011-08-10 14:12:51','min',1,3,'Berkeley','2010-10-25 15:41:31','CA',1),('Berkeley','USA','??\0ur\0[Ljava.lang.String;??V??{G\0\0xp\0\0\0t\0biology','previewuser','\0','preview',NULL,NULL,'user',0,3,'Berkeley','2010-10-25 15:41:31','CA',2);
+INSERT INTO `teacher_user_details` VALUES ('Berkeley','USA',NULL,'adminuser','\0','ad',NULL,'2011-08-19 10:45:34','min',2,3,'Berkeley','2010-10-25 15:41:31','CA',1),('Berkeley','USA',NULL,'previewuser','\0','preview',NULL,NULL,'user',0,3,'Berkeley','2010-10-25 15:41:31','CA',2);
/*!40000 ALTER TABLE `teacher_user_details` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1760,7 +1771,6 @@
LOCK TABLES `urlmodules` WRITE;
/*!40000 ALTER TABLE `urlmodules` DISABLE KEYS */;
-INSERT INTO `urlmodules` VALUES ('/1/wise4.project.json',1),('/2/wise4.project.json',2);
/*!40000 ALTER TABLE `urlmodules` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1785,7 +1795,7 @@
`OPTLOCK` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -1794,7 +1804,7 @@
LOCK TABLES `user_details` WRITE;
/*!40000 ALTER TABLE `user_details` DISABLE KEYS */;
-INSERT INTO `user_details` VALUES (1,'','','',NULL,'',0,'24c002f26c14d8e087ade986531c7b5d',NULL,'admin',1),(2,'','','',NULL,'',NULL,'2ece21e1cf40509868e5a74a48d49a50',NULL,'previewuser',0),(3,'','','',NULL,'',0,'24c002f26c14d8e087ade986531c7b5d',NULL,'students0101',1);
+INSERT INTO `user_details` VALUES (1,'','','',NULL,'',0,'24c002f26c14d8e087ade986531c7b5d',NULL,'admin',2),(2,'','','',NULL,'',NULL,'2ece21e1cf40509868e5a74a48d49a50',NULL,'previewuser',0);
/*!40000 ALTER TABLE `user_details` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1820,7 +1830,7 @@
LOCK TABLES `user_details_related_to_roles` WRITE;
/*!40000 ALTER TABLE `user_details_related_to_roles` DISABLE KEYS */;
-INSERT INTO `user_details_related_to_roles` VALUES (1,1),(1,2),(1,3),(1,5),(2,1),(2,3),(2,5),(3,1),(3,4);
+INSERT INTO `user_details_related_to_roles` VALUES (1,1),(1,2),(1,3),(1,5),(2,1),(2,3),(2,5);
/*!40000 ALTER TABLE `user_details_related_to_roles` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1841,7 +1851,7 @@
UNIQUE KEY `sds_user_fk` (`sds_user_fk`),
KEY `FK6A68E08E3B038C2` (`user_details_fk`),
KEY `FK6A68E08F342C661` (`sds_user_fk`)
-) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -1850,7 +1860,7 @@
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
-INSERT INTO `users` VALUES (1,0,NULL,1),(2,0,NULL,2),(3,0,NULL,3);
+INSERT INTO `users` VALUES (1,0,NULL,1),(2,0,NULL,2);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1878,7 +1888,6 @@
LOCK TABLES `wiseworkgroups` WRITE;
/*!40000 ALTER TABLE `wiseworkgroups` DISABLE KEYS */;
-INSERT INTO `wiseworkgroups` VALUES (NULL,'',1,NULL),(NULL,'\0',2,1);
/*!40000 ALTER TABLE `wiseworkgroups` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1900,7 +1909,7 @@
KEY `FKEC8E5025895EAE0A` (`group_fk`),
KEY `FKEC8E50255AAC23E7` (`sds_workgroup_fk`),
KEY `FKEC8E502553AE0756` (`offering_fk`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -1909,7 +1918,6 @@
LOCK TABLES `workgroups` WRITE;
/*!40000 ALTER TABLE `workgroups` DISABLE KEYS */;
-INSERT INTO `workgroups` VALUES (1,0,2,1,NULL),(2,0,3,1,NULL);
/*!40000 ALTER TABLE `workgroups` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -1922,7 +1930,7 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2011-08-19 10:39:46
+-- Dump completed on 2011-08-19 13:45:43
vagrant@lucid32:~$ mysqldump -uroot -ppassword vle_database
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
--
@@ -1940,645 +1948,6 @@
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
---
--- Table structure for table `annotation`
---
-
-DROP TABLE IF EXISTS `annotation`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `annotation` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `annotateTime` datetime DEFAULT NULL,
- `postTime` datetime DEFAULT NULL,
- `runId` bigint(20) DEFAULT NULL,
- `stepWork_id` bigint(20) DEFAULT NULL,
- `userInfo_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FKA34FEB2FE8A0978C` (`stepWork_id`),
- KEY `FKA34FEB2F206FE92` (`userInfo_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `annotation`
---
-
-LOCK TABLES `annotation` WRITE;
-/*!40000 ALTER TABLE `annotation` DISABLE KEYS */;
-/*!40000 ALTER TABLE `annotation` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `annotation_comment`
---
-
-DROP TABLE IF EXISTS `annotation_comment`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `annotation_comment` (
- `data` varchar(512) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKB3FAE14F5B80E7FE` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `annotation_comment`
---
-
-LOCK TABLES `annotation_comment` WRITE;
-/*!40000 ALTER TABLE `annotation_comment` DISABLE KEYS */;
-/*!40000 ALTER TABLE `annotation_comment` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `annotation_flag`
---
-
-DROP TABLE IF EXISTS `annotation_flag`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `annotation_flag` (
- `data` varchar(512) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK6E89727C5B80E7FE` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `annotation_flag`
---
-
-LOCK TABLES `annotation_flag` WRITE;
-/*!40000 ALTER TABLE `annotation_flag` DISABLE KEYS */;
-/*!40000 ALTER TABLE `annotation_flag` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `annotation_score`
---
-
-DROP TABLE IF EXISTS `annotation_score`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `annotation_score` (
- `data` varchar(255) DEFAULT NULL,
- `score` float DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK63582D825B80E7FE` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `annotation_score`
---
-
-LOCK TABLES `annotation_score` WRITE;
-/*!40000 ALTER TABLE `annotation_score` DISABLE KEYS */;
-/*!40000 ALTER TABLE `annotation_score` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `ideaBasket`
---
-
-DROP TABLE IF EXISTS `ideaBasket`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ideaBasket` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `data` varchar(1024) DEFAULT NULL,
- `postTime` datetime DEFAULT NULL,
- `projectId` bigint(20) DEFAULT NULL,
- `runId` bigint(20) DEFAULT NULL,
- `workgroupId` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `ideaBasket`
---
-
-LOCK TABLES `ideaBasket` WRITE;
-/*!40000 ALTER TABLE `ideaBasket` DISABLE KEYS */;
-INSERT INTO `ideaBasket` VALUES (1,NULL,'2011-08-10 14:15:01',2,1,2);
-/*!40000 ALTER TABLE `ideaBasket` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `journal`
---
-
-DROP TABLE IF EXISTS `journal`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `journal` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `data` varchar(1024) DEFAULT NULL,
- `userInfo_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FKAB64AF37206FE92` (`userInfo_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `journal`
---
-
-LOCK TABLES `journal` WRITE;
-/*!40000 ALTER TABLE `journal` DISABLE KEYS */;
-/*!40000 ALTER TABLE `journal` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `node`
---
-
-DROP TABLE IF EXISTS `node`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `node` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `nodeId` varchar(255) DEFAULT NULL,
- `nodeType` varchar(255) DEFAULT NULL,
- `runId` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `node`
---
-
-LOCK TABLES `node` WRITE;
-/*!40000 ALTER TABLE `node` DISABLE KEYS */;
-INSERT INTO `node` VALUES (1,'node_0.or','OpenResponseNode','1');
-/*!40000 ALTER TABLE `node` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `peerreviewgate`
---
-
-DROP TABLE IF EXISTS `peerreviewgate`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `peerreviewgate` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `open` bit(1) DEFAULT NULL,
- `periodId` bigint(20) DEFAULT NULL,
- `runId` bigint(20) DEFAULT NULL,
- `node_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FKD0AB7705D11C35FB` (`node_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `peerreviewgate`
---
-
-LOCK TABLES `peerreviewgate` WRITE;
-/*!40000 ALTER TABLE `peerreviewgate` DISABLE KEYS */;
-/*!40000 ALTER TABLE `peerreviewgate` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `peerreviewwork`
---
-
-DROP TABLE IF EXISTS `peerreviewwork`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `peerreviewwork` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `periodId` bigint(20) DEFAULT NULL,
- `runId` bigint(20) DEFAULT NULL,
- `annotation_id` bigint(20) DEFAULT NULL,
- `node_id` bigint(20) DEFAULT NULL,
- `reviewerUserInfo_id` bigint(20) DEFAULT NULL,
- `stepWork_id` bigint(20) DEFAULT NULL,
- `userInfo_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FKD0B2F14BD11C35FB` (`node_id`),
- KEY `FKD0B2F14B2CBBDF0E` (`annotation_id`),
- KEY `FKD0B2F14BD10BEB6D` (`reviewerUserInfo_id`),
- KEY `FKD0B2F14BE8A0978C` (`stepWork_id`),
- KEY `FKD0B2F14B206FE92` (`userInfo_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `peerreviewwork`
---
-
-LOCK TABLES `peerreviewwork` WRITE;
-/*!40000 ALTER TABLE `peerreviewwork` DISABLE KEYS */;
-/*!40000 ALTER TABLE `peerreviewwork` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork`
---
-
-DROP TABLE IF EXISTS `stepwork`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `data` text,
- `duplicateId` varchar(255) DEFAULT NULL,
- `endTime` datetime DEFAULT NULL,
- `postTime` datetime DEFAULT NULL,
- `startTime` datetime DEFAULT NULL,
- `node_id` bigint(20) DEFAULT NULL,
- `userInfo_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK553587DDD11C35FB` (`node_id`),
- KEY `FK553587DD206FE92` (`userInfo_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork`
---
-
-LOCK TABLES `stepwork` WRITE;
-/*!40000 ALTER TABLE `stepwork` DISABLE KEYS */;
-INSERT INTO `stepwork` VALUES (1,'{\"nodeId\":\"node_0.or\",\"visitEndTime\":1313010904000,\"hintStates\":[],\"nodeStates\":[],\"visitStartTime\":1313010900000,\"nodeType\":\"OpenResponseNode\",\"visitPostTime\":null}',NULL,'2011-08-10 14:15:04','2011-08-10 14:15:04','2011-08-10 14:15:00',1,1);
-/*!40000 ALTER TABLE `stepwork` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_al`
---
-
-DROP TABLE IF EXISTS `stepwork_al`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_al` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKE06EFFCD831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_al`
---
-
-LOCK TABLES `stepwork_al` WRITE;
-/*!40000 ALTER TABLE `stepwork_al` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_al` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_branch`
---
-
-DROP TABLE IF EXISTS `stepwork_branch`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_branch` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK10577844831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_branch`
---
-
-LOCK TABLES `stepwork_branch` WRITE;
-/*!40000 ALTER TABLE `stepwork_branch` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_branch` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_bs`
---
-
-DROP TABLE IF EXISTS `stepwork_bs`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_bs` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKE06EFFF3831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_bs`
---
-
-LOCK TABLES `stepwork_bs` WRITE;
-/*!40000 ALTER TABLE `stepwork_bs` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_bs` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_cache`
---
-
-DROP TABLE IF EXISTS `stepwork_cache`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_cache` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `cacheTime` datetime DEFAULT NULL,
- `data` mediumtext,
- `getRevisions` bit(1) DEFAULT NULL,
- `userInfo_id` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `FK953280A0206FE92` (`userInfo_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_cache`
---
-
-LOCK TABLES `stepwork_cache` WRITE;
-/*!40000 ALTER TABLE `stepwork_cache` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_cache` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_challenge`
---
-
-DROP TABLE IF EXISTS `stepwork_challenge`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_challenge` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK35828E81831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_challenge`
---
-
-LOCK TABLES `stepwork_challenge` WRITE;
-/*!40000 ALTER TABLE `stepwork_challenge` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_challenge` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_fillin`
---
-
-DROP TABLE IF EXISTS `stepwork_fillin`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_fillin` (
- `data` varchar(512) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK16B1008A831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_fillin`
---
-
-LOCK TABLES `stepwork_fillin` WRITE;
-/*!40000 ALTER TABLE `stepwork_fillin` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_fillin` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_html`
---
-
-DROP TABLE IF EXISTS `stepwork_html`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_html` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK80B19ACD831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_html`
---
-
-LOCK TABLES `stepwork_html` WRITE;
-/*!40000 ALTER TABLE `stepwork_html` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_html` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_matchsequence`
---
-
-DROP TABLE IF EXISTS `stepwork_matchsequence`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_matchsequence` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKA1948FA4831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_matchsequence`
---
-
-LOCK TABLES `stepwork_matchsequence` WRITE;
-/*!40000 ALTER TABLE `stepwork_matchsequence` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_matchsequence` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_mc`
---
-
-DROP TABLE IF EXISTS `stepwork_mc`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_mc` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKE06F0138831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_mc`
---
-
-LOCK TABLES `stepwork_mc` WRITE;
-/*!40000 ALTER TABLE `stepwork_mc` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_mc` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_note`
---
-
-DROP TABLE IF EXISTS `stepwork_note`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_note` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK80B44314831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_note`
---
-
-LOCK TABLES `stepwork_note` WRITE;
-/*!40000 ALTER TABLE `stepwork_note` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_note` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_or`
---
-
-DROP TABLE IF EXISTS `stepwork_or`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_or` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKE06F0185831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_or`
---
-
-LOCK TABLES `stepwork_or` WRITE;
-/*!40000 ALTER TABLE `stepwork_or` DISABLE KEYS */;
-INSERT INTO `stepwork_or` VALUES ('{\"nodeId\":\"node_0.or\",\"visitEndTime\":1313010904000,\"hintStates\":[],\"nodeStates\":[],\"visitStartTime\":1313010900000,\"nodeType\":\"OpenResponseNode\",\"visitPostTime\":null}',1);
-/*!40000 ALTER TABLE `stepwork_or` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_sensor`
---
-
-DROP TABLE IF EXISTS `stepwork_sensor`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_sensor` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK2CA8A65C831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_sensor`
---
-
-LOCK TABLES `stepwork_sensor` WRITE;
-/*!40000 ALTER TABLE `stepwork_sensor` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_sensor` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_svgdraw`
---
-
-DROP TABLE IF EXISTS `stepwork_svgdraw`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_svgdraw` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK85051B46831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_svgdraw`
---
-
-LOCK TABLES `stepwork_svgdraw` WRITE;
-/*!40000 ALTER TABLE `stepwork_svgdraw` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_svgdraw` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `stepwork_template`
---
-
-DROP TABLE IF EXISTS `stepwork_template`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `stepwork_template` (
- `data` varchar(1024) DEFAULT NULL,
- `id` bigint(20) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FKB18FE9C831A3EA` (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `stepwork_template`
---
-
-LOCK TABLES `stepwork_template` WRITE;
-/*!40000 ALTER TABLE `stepwork_template` DISABLE KEYS */;
-/*!40000 ALTER TABLE `stepwork_template` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Table structure for table `userinfo`
---
-
-DROP TABLE IF EXISTS `userinfo`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `userinfo` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `workgroupId` bigint(20) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `workgroupId` (`workgroupId`)
-) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `userinfo`
---
-
-LOCK TABLES `userinfo` WRITE;
-/*!40000 ALTER TABLE `userinfo` DISABLE KEYS */;
-INSERT INTO `userinfo` VALUES (1,2),(2,1);
-/*!40000 ALTER TABLE `userinfo` ENABLE KEYS */;
-UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
@@ -2589,4 +1958,4 @@
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2011-08-19 10:39:57
\ No newline at end of file
+-- Dump completed on 2011-08-19 13:45:48
\ No newline at end of file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment