-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `assigncid`
-- 

DROP TABLE IF EXISTS `assigncid` ; 
CREATE TABLE IF NOT EXISTS `assigncid` (
  `clientid` int(2) NOT NULL AUTO_INCREMENT,
  `clientName` varchar(40) DEFAULT NULL,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`clientid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

-- 
-- Data to be executed for table `assigncid`
-- 

INSERT INTO `assigncid` VALUES('1', '_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `basic`
-- 

DROP TABLE IF EXISTS `basic` ; 
CREATE TABLE IF NOT EXISTS `basic` (
  `instrument` varchar(40) DEFAULT NULL,
  `filelist` text,
  `creation` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `basic`
-- 

INSERT INTO `basic` VALUES('$ERS_TICKETS', 'allowedUsers.xml describe.txt PARAMS.XML REFERENCE.XML SC_basic.XML SC_penalty.XML SC_penalty_costRange.XML SC_quality.XML SC_shares.XML SC_shares_costRange.XML SC_target.XML SC_target_costRange.XML SL_list1.XML SL_list2.XML SL_list3.XML SL_list4.XML SL_list5.XML SL_test.XML', '2011-04-25 16:58:34');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `clientids`
-- 

DROP TABLE IF EXISTS `clientids` ; 
CREATE TABLE IF NOT EXISTS `clientids` (
  `clientid` varchar(40) NOT NULL,
  `clientName` varchar(40) DEFAULT NULL,
  `refId` int(4) DEFAULT NULL,
  `servertime` int(11) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`clientid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `clientids`
-- 

INSERT INTO `clientids` VALUES('78802_4125', 'A', '0', '1303750795', '<user id=\"78802_4125\"><name>A</name><nickname></nickname><contact></contact><refid></refid></user>');
INSERT INTO `clientids` VALUES('_created', '_created', '-2', '1303750714', 'Mon, 25 Apr 11 16:58:34 +0000');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `clientstatus`
-- 

DROP TABLE IF EXISTS `clientstatus` ; 
CREATE TABLE IF NOT EXISTS `clientstatus` (
  `clientid` varchar(40) NOT NULL,
  `servertime` int(11) DEFAULT NULL,
  `clienttime` varchar(40) DEFAULT NULL,
  `state` varchar(40) DEFAULT NULL,
  `message` tinytext,
  `varname` varchar(40) DEFAULT NULL,
  `varvalue` tinytext,
  PRIMARY KEY (`clientid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `clientstatus`
-- 

INSERT INTO `clientstatus` VALUES('78802_4125', '1303777527', '1303777527653', '1', 'check_to_start_adminIntro', 'IntroAdmin_var', '');
INSERT INTO `clientstatus` VALUES('_created', '1303750714', '1303750714', 'Created', 'Database created', '_started', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `customdata`
-- 

DROP TABLE IF EXISTS `customdata` ; 
CREATE TABLE IF NOT EXISTS `customdata` (
  `round` int(4) NOT NULL,
  `cname` varchar(60) NOT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`cname`,`round`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `customdata`
-- 

INSERT INTO `customdata` VALUES('-1', '0', '_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `generaldata`
-- 

DROP TABLE IF EXISTS `generaldata` ; 
CREATE TABLE IF NOT EXISTS `generaldata` (
  `round` int(4) NOT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`round`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `generaldata`
-- 

INSERT INTO `generaldata` VALUES('-1', '_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `historydata`
-- 

DROP TABLE IF EXISTS `historydata` ; 
CREATE TABLE IF NOT EXISTS `historydata` (
  `round` int(4) NOT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`round`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `historydata`
-- 

INSERT INTO `historydata` VALUES('-1', '_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `messages`
-- 

DROP TABLE IF EXISTS `messages` ; 
CREATE TABLE IF NOT EXISTS `messages` (
  `clientId` varchar(40) NOT NULL,
  `servertime` int(11) DEFAULT NULL,
  `content` text,
  `subject` varchar(250) DEFAULT NULL,
  `cTime` varchar(20) DEFAULT NULL,
  `fromId` varchar(30) DEFAULT NULL,
  `fromName` varchar(80) DEFAULT NULL,
  `toList` varchar(1000) DEFAULT NULL,
  `urgent` int(11) DEFAULT NULL,
  `stuff` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `messages`
-- 

INSERT INTO `messages` VALUES('_created', '1303750714', 'dSurvey messages', 'messages', '1303750714', 'initId', 'initName', '-1', '0', ' ');
INSERT INTO `messages` VALUES('ADMIN', '1303761569', ' this is mesage1\ndid it work', 'm1', '1303761569759', 'admin', 'Administrator', 'admin,', '0', '0,1303761569759,admin,Administrator,admin ,m1,%20this%20is%20mesage1%0Adid%20it%20work');
INSERT INTO `messages` VALUES('ADMIN', '1303761584', ' Will mesage 2 work?\nCould be.\n', 'm2 again', '1303761584888', 'admin', 'Administrator', 'admin,', '0', '0,1303761584888,admin,Administrator,admin ,m2%20again,%20Will%20mesage%202%20work%3F%0ACould%20be.%0A');
INSERT INTO `messages` VALUES('78802_4125', '1303761668', ' wask up\n', 'xx', '1303761668564', 'admin', 'Administrator', '78802_4125,', '0', '0,1303761668564,admin,Administrator,78802_4125 ,xx,%20wask%20up%0A');
INSERT INTO `messages` VALUES('78802_4125', '1303761704', ' if you are\nPlease clap  & shout!\n', 'are you up yet', '1303761704518', 'admin', 'Administrator', '78802_4125,', '0', '0,1303761704518,admin,Administrator,78802_4125 ,are%20you%20up%20yet,%20if%20you%20are%0APlease%20clap%20%20%26%20shout%21%0A');
INSERT INTO `messages` VALUES('ADMIN', '1303761825', ' Don\'t let me down,\ndon\'t let me down', 'yes', '1303761825355', '78802_4125', 'A', 'admin', '0', '0,1303761825355,78802_4125,A,admin,yes,%20Don%27t%20let%20me%20down%2C%0Adon%27t%20let%20me%20down');
INSERT INTO `messages` VALUES('78802_4125', '1303761895', ' read ty do', 'hi', '1303761895318', 'admin', 'Administrator', '78802_4125,', '0', '0,1303761895318,admin,Administrator,78802_4125 ,hi,%20read%20ty%20do');
INSERT INTO `messages` VALUES('78802_4125', '1303762266', ' Sasasdf', 'Reply to: yes', '1303762266559', 'admin', 'Administrator', '78802_4125', '0', '0,1303762266559,admin,Administrator,78802_4125,Reply%20to%3A%20yes,%20Sasasdf');
INSERT INTO `messages` VALUES('78802_4125', '1303774097', ' cfg87 0-6 m5uyoijgh ', 'asf', '1303774097741', 'admin', 'Administrator', '78802_4125,', '0', '0,1303774097741,admin,Administrator,78802_4125 ,asf,%20cfg87%200-6%20m5uyoijgh%20');
INSERT INTO `messages` VALUES('78802_4125', '1303774278', ' asd asd ', 'yy', '1303774278229', 'admin', 'Administrator', '78802_4125,', '0', '0,1303774278229,admin,Administrator,78802_4125 ,yy,%20asd%20asd%20');
INSERT INTO `messages` VALUES('78802_4125', '1303775544', '  jjk jklsd ', 'oii', '1303775544927', 'admin', 'Administrator', '78802_4125,', '0', '0,1303775544927,admin,Administrator,78802_4125 ,oii,%20%20jjk%20jklsd%20');
INSERT INTO `messages` VALUES('ADMIN', '1303775625', ' wft?', 'Reply to:oii', '1303775625546', '78802_4125', 'A', 'admin', '0', '0,1303775625546,78802_4125,A,admin,Reply%20to%3Aoii,%20wft%3F');
INSERT INTO `messages` VALUES('78802_4125', '1303775686', ' 00067', 'oinb', '1303775685965', 'admin', 'Administrator', '78802_4125,', '0', '0,1303775685965,admin,Administrator,78802_4125 ,oinb,%2000067');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `messagesadmin`
-- 

DROP TABLE IF EXISTS `messagesadmin` ; 
CREATE TABLE IF NOT EXISTS `messagesadmin` (
  `clientId` varchar(40) NOT NULL,
  `lastReadTime` int(11) DEFAULT NULL,
  `newFlag` int(11) DEFAULT NULL,
  PRIMARY KEY (`clientId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `messagesadmin`
-- 

INSERT INTO `messagesadmin` VALUES('78802_4125', '1303777521', '0');
INSERT INTO `messagesadmin` VALUES('ADMIN', '0', '1');
INSERT INTO `messagesadmin` VALUES('_created', '1303750714', '0');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `notes`
-- 

DROP TABLE IF EXISTS `notes` ; 
CREATE TABLE IF NOT EXISTS `notes` (
  `content` text NOT NULL,
  `servertime` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `notes`
-- 

INSERT INTO `notes` VALUES('_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `participantsdata`
-- 

DROP TABLE IF EXISTS `participantsdata` ; 
CREATE TABLE IF NOT EXISTS `participantsdata` (
  `round` int(4) NOT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`round`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `participantsdata`
-- 

INSERT INTO `participantsdata` VALUES('-1', '_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `resultsdata`
-- 

DROP TABLE IF EXISTS `resultsdata` ; 
CREATE TABLE IF NOT EXISTS `resultsdata` (
  `round` int(4) NOT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`round`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `resultsdata`
-- 

INSERT INTO `resultsdata` VALUES('-1', '_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `servervars`
-- 

DROP TABLE IF EXISTS `servervars` ; 
CREATE TABLE IF NOT EXISTS `servervars` (
  `varname` varchar(40) NOT NULL,
  `varvalue` tinytext,
  `modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`varname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `servervars`
-- 

INSERT INTO `servervars` VALUES('MAXRECORDID', '30', '1303777479');
INSERT INTO `servervars` VALUES('ROUND', '1', '1303750803');
INSERT INTO `servervars` VALUES('STARTSESSION', '1', '1303750803');
INSERT INTO `servervars` VALUES('STARTSESSIONREAL', '1', '1303750809');
INSERT INTO `servervars` VALUES('_created', '1303750714', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `simplehistory`
-- 

DROP TABLE IF EXISTS `simplehistory` ; 
CREATE TABLE IF NOT EXISTS `simplehistory` (
  `arow` int(4) NOT NULL AUTO_INCREMENT,
  `round` int(4) DEFAULT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  `comment` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`arow`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

-- 
-- Data to be executed for table `simplehistory`
-- 

INSERT INTO `simplehistory` VALUES('1', '-1', '_created', '1303750714', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `statusvars`
-- 

DROP TABLE IF EXISTS `statusvars` ; 
CREATE TABLE IF NOT EXISTS `statusvars` (
  `varname` varchar(40) NOT NULL,
  `varvalue` tinytext,
  `modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`varname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `statusvars`
-- 

INSERT INTO `statusvars` VALUES('JOIN', '3', '1303750803');
INSERT INTO `statusvars` VALUES('users', ' A:78802_4125= ', '1303750795');
INSERT INTO `statusvars` VALUES('_created', 'Mon, 25 Apr 11 16:58:34 +0000', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `submitstatus`
-- 

DROP TABLE IF EXISTS `submitstatus` ; 
CREATE TABLE IF NOT EXISTS `submitstatus` (
  `sstatus` varchar(40) NOT NULL,
  `clienttime` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`sstatus`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `submitstatus`
-- 

INSERT INTO `submitstatus` VALUES('_created', '1303750714');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `submitted`
-- 

DROP TABLE IF EXISTS `submitted` ; 
CREATE TABLE IF NOT EXISTS `submitted` (
  `clientid` varchar(40) NOT NULL,
  `round` int(4) NOT NULL,
  `servertime` int(11) DEFAULT NULL,
  `clienttime` varchar(40) DEFAULT NULL,
  `notFinal` int(2) DEFAULT NULL,
  `ct` int(2) NOT NULL DEFAULT '0',
  `entry` text,
  `comment` tinytext,
  PRIMARY KEY (`clientid`,`round`,`ct`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `submitted`
-- 

INSERT INTO `submitted` VALUES('_created', '-1', '1303750714', 'Mon, 25 Apr 11 16:58:34 +0000', '', '0', '', 'for submitted data');

-- --------------------------------------------------------

-- 
--  For dSurvey session $ERS_g3 on Sun, 26 Jun 11 01:51:10 +0000 
-- 
-- Table structure for `usersdata`
-- 

DROP TABLE IF EXISTS `usersdata` ; 
CREATE TABLE IF NOT EXISTS `usersdata` (
  `round` int(4) NOT NULL,
  `content` text,
  `servertime` int(11) DEFAULT NULL,
  PRIMARY KEY (`round`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Data to be executed for table `usersdata`
-- 

INSERT INTO `usersdata` VALUES('-1', '_created', '1303750714');

-- --------------------------------------------------------

