-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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-23 13:44:58');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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('00326_5757', 'A', '0', '1303585974', '<user id=\"00326_5757\"><name>A</name><nickname></nickname><contact></contact><refid></refid></user>');
INSERT INTO `clientids` VALUES('_created', '_created', '-2', '1303566298', 'Sat, 23 Apr 11 13:44:58 +0000');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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('00326_5757', '1303586141', '1303586141934', '3', 'afterTickets', 'Round', '3');
INSERT INTO `clientstatus` VALUES('_created', '1303566298', '1303566298', 'Created', 'Database created', '_started', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');
INSERT INTO `customdata` VALUES('1', 'STUFF', '<!-- Saturday, April 23, 2011 3:14:20 PM  for round 1, #  clients = 1  --> \n \n <data><round>1</round> <id>00326_5757</id> \n     <ISDEMO>1</ISDEMO>  \n    <NAME>A</NAME> <NOWROUND>1</NOWROUND> <NOWROUND_SCENARIO>1</NOWROUND_SCENARIO> <BIDS_USED_1_>50</BIDS_USED_1_>  \n    <BIDS_USED_2_>152</BIDS_USED_2_> <PRODCOST_USED_1_>44</PRODCOST_USED_1_> <PRODCOST_USED_2_>143</PRODCOST_USED_2_>  \n    <PRODCOST_LOWER_1_>44</PRODCOST_LOWER_1_> <PRODCOST_LOWER_2_>143</PRODCOST_LOWER_2_>  \n    <PRODCOST_UPPER_1_>44</PRODCOST_UPPER_1_> <PRODCOST_UPPER_2_>143</PRODCOST_UPPER_2_>  \n    <SCORES_USED_1_>50</SCORES_USED_1_> <SCORES_USED_2_>152</SCORES_USED_2_> <MYGROUP_1_>1</MYGROUP_1_>  \n    <MYGROUP_2_>4</MYGROUP_2_> <MAXBID_USED_1_>90</MAXBID_USED_1_> <MAXBID_USED_2_>300</MAXBID_USED_2_>  \n    <FEE_USED_1_>0</FEE_USED_1_> <FEE_USED_2_>0</FEE_USED_2_> <QPOINTS_USED_1_>0</QPOINTS_USED_1_>  \n    <QPOINTS_USED_2_>0</QPOINTS_USED_2_> <UNDERBIDPOINTS_USED_1_>0</UNDERBIDPOINTS_USED_1_>  \n    <UNDERBIDPOINTS_USED_2_>0</UNDERBIDPOINTS_USED_2_> <ROUNDEARN>15</ROUNDEARN> <EARN_1_>6</EARN_1_>  \n    <EARN_2_>9</EARN_2_> <STATUS_1_>4</STATUS_1_> <STATUS_2_>4</STATUS_2_> <SCORES2_1_>50</SCORES2_1_>  \n    <SCORES2_2_>152</SCORES2_2_> <QTEST_ANSWER_1_>1</QTEST_ANSWER_1_> <QTEST_ANSWER_2_>1</QTEST_ANSWER_2_>  \n    <QTEST_ANSWER_3_>0</QTEST_ANSWER_3_> <QTEST_ANSWER_4_>0</QTEST_ANSWER_4_> <QTEST_ANSWER_5_>0</QTEST_ANSWER_5_>  \n    \n </data>', '1303586060');
INSERT INTO `customdata` VALUES('2', 'STUFF', '<!-- Saturday, April 23, 2011 3:14:36 PM  for round 2, #  clients = 1  --> \n \n <data><round>2</round> <id>00326_5757</id> \n     <ISDEMO>0</ISDEMO>  \n    <NOWROUND>2</NOWROUND> <NOWROUND_SCENARIO>2</NOWROUND_SCENARIO> <BIDS_USED_1_>48</BIDS_USED_1_>  \n    <BIDS_USED_2_>126</BIDS_USED_2_> <PRODCOST_USED_1_>41</PRODCOST_USED_1_> <PRODCOST_USED_2_>121.2</PRODCOST_USED_2_>  \n    <PRODCOST_LOWER_1_>41</PRODCOST_LOWER_1_> <PRODCOST_LOWER_2_>121.2</PRODCOST_LOWER_2_>  \n    <PRODCOST_UPPER_1_>41</PRODCOST_UPPER_1_> <PRODCOST_UPPER_2_>121.2</PRODCOST_UPPER_2_>  \n    <SCORES_USED_1_>48</SCORES_USED_1_> <SCORES_USED_2_>126</SCORES_USED_2_> <MYGROUP_1_>1</MYGROUP_1_>  \n    <MYGROUP_2_>4</MYGROUP_2_> <MAXBID_USED_1_>90</MAXBID_USED_1_> <MAXBID_USED_2_>300</MAXBID_USED_2_>  \n    <FEE_USED_1_>0</FEE_USED_1_> <FEE_USED_2_>0</FEE_USED_2_> <QPOINTS_USED_1_>0</QPOINTS_USED_1_>  \n    <QPOINTS_USED_2_>0</QPOINTS_USED_2_> <UNDERBIDPOINTS_USED_1_>0</UNDERBIDPOINTS_USED_1_>  \n    <UNDERBIDPOINTS_USED_2_>0</UNDERBIDPOINTS_USED_2_> <ROUNDEARN>11.799999999999997</ROUNDEARN>  \n    <EARN_1_>7</EARN_1_> <EARN_2_>4.799999999999997</EARN_2_> <STATUS_1_>4</STATUS_1_>  \n    <STATUS_2_>4</STATUS_2_> <SCORES2_1_>48</SCORES2_1_> <SCORES2_2_>126</SCORES2_2_>  \n    \n </data>', '1303586076');
INSERT INTO `customdata` VALUES('3', 'STUFF', '<!-- Saturday, April 23, 2011 3:15:25 PM  for round 3, #  clients = 1  --> \n \n <data><round>3</round> <id>00326_5757</id> \n     <ISDEMO>1</ISDEMO>  \n    <NOWROUND>3</NOWROUND> <NOWROUND_SCENARIO>1</NOWROUND_SCENARIO> <BIDS_USED_1_>53</BIDS_USED_1_>  \n    <BIDS_USED_2_>80</BIDS_USED_2_> <PRODCOST_USED_1_>34.8</PRODCOST_USED_1_> <PRODCOST_USED_2_>75</PRODCOST_USED_2_>  \n    <PRODCOST_LOWER_1_>34.8</PRODCOST_LOWER_1_> <PRODCOST_LOWER_2_>75</PRODCOST_LOWER_2_>  \n    <PRODCOST_UPPER_1_>34.8</PRODCOST_UPPER_1_> <PRODCOST_UPPER_2_>75</PRODCOST_UPPER_2_>  \n    <SCORES_USED_1_>33</SCORES_USED_1_> <SCORES_USED_2_>80</SCORES_USED_2_> <MYGROUP_1_>1</MYGROUP_1_>  \n    <MYGROUP_2_>4</MYGROUP_2_> <MAXBID_USED_1_>90</MAXBID_USED_1_> <MAXBID_USED_2_>300</MAXBID_USED_2_>  \n    <FEE_USED_1_>0</FEE_USED_1_> <FEE_USED_2_>0</FEE_USED_2_> <QPOINTS_USED_1_>20</QPOINTS_USED_1_>  \n    <QPOINTS_USED_2_>0</QPOINTS_USED_2_> <UNDERBIDPOINTS_USED_1_>0</UNDERBIDPOINTS_USED_1_>  \n    <UNDERBIDPOINTS_USED_2_>0</UNDERBIDPOINTS_USED_2_> <ROUNDEARN>13.200000000000003</ROUNDEARN>  \n    <EARN_1_>8.200000000000003</EARN_1_> <EARN_2_>5</EARN_2_> <STATUS_1_>4</STATUS_1_>  \n    <STATUS_2_>4</STATUS_2_> <SCORES2_1_>33</SCORES2_1_> <SCORES2_2_>80</SCORES2_2_>  \n    \n </data>', '1303586125');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');
INSERT INTO `generaldata` VALUES('1', '<!-- Saturday, April 23, 2011 3:14:20 PM--> \n <data><round>1</round> \n     <NPARTICIPANTS>10</NPARTICIPANTS> <NACCEPT>12</NACCEPT> <NUMROUNDS>32</NUMROUNDS> <TYPENAMES_0_>undefined</TYPENAMES_0_> <TYPENAMES_1_>A</TYPENAMES_1_> <TYPENAMES_2_>B</TYPENAMES_2_> <TYPENAMES_3_>C</TYPENAMES_3_> <TYPENAMES_4_>D</TYPENAMES_4_>  \n    <NUM_PERGROUP_0_>undefined</NUM_PERGROUP_0_> <NUM_PERGROUP_1_>5</NUM_PERGROUP_1_> <NUM_PERGROUP_2_>5</NUM_PERGROUP_2_> <NUM_PERGROUP_3_>5</NUM_PERGROUP_3_> <NUM_PERGROUP_4_>5</NUM_PERGROUP_4_> <P_BONUS>10.00</P_BONUS>  \n    <EDOLLAR_RATE>0.04</EDOLLAR_RATE> <COST_MIN_0_>undefined</COST_MIN_0_> <COST_MIN_1_>30</COST_MIN_1_> <COST_MIN_2_>20</COST_MIN_2_> <COST_MIN_3_>35</COST_MIN_3_> <COST_MIN_4_>40</COST_MIN_4_> <COST_MAX_0_>undefined</COST_MAX_0_>  \n    <COST_MAX_1_>45</COST_MAX_1_> <COST_MAX_2_>65</COST_MAX_2_> <COST_MAX_3_>95</COST_MAX_3_> <COST_MAX_4_>150</COST_MAX_4_> <USE_COSTRANGE>0</USE_COSTRANGE> <COST_RANGE_0_>undefined</COST_RANGE_0_> <COST_RANGE_1_>5</COST_RANGE_1_>  \n    <COST_RANGE_2_>5</COST_RANGE_2_> <COST_RANGE_3_>5</COST_RANGE_3_> <COST_RANGE_4_>5</COST_RANGE_4_> <USE_QUALITY>0</USE_QUALITY> <QUALITY_MAXPOINTS>20</QUALITY_MAXPOINTS> <QUALITY_PRICE>0.5</QUALITY_PRICE> <USE_SHARES>0</USE_SHARES>  \n    <SHARES_0_>undefined</SHARES_0_> <SHARES_1_>4</SHARES_1_> <SHARES_2_>4</SHARES_2_> <SHARES_3_>4</SHARES_3_> <SHARES_4_>4</SHARES_4_> <USE_DISCOUNTS>0</USE_DISCOUNTS> <DISCOUNTS_0_>undefined</DISCOUNTS_0_>  \n    <DISCOUNTS_1_>1.0</DISCOUNTS_1_> <DISCOUNTS_2_>1</DISCOUNTS_2_> <DISCOUNTS_3_>0</DISCOUNTS_3_> <DISCOUNTS_4_>0.8</DISCOUNTS_4_> <DISCOUNTS_5_>0.8</DISCOUNTS_5_> <USE_TARGETBID>0</USE_TARGETBID> <UNDERBID_TYPE>0</UNDERBID_TYPE>  \n    <UNDERBID_FACTOR>1</UNDERBID_FACTOR> <OVERBID_FACTOR>1</OVERBID_FACTOR> <TARGET_TYPE>0</TARGET_TYPE> <TARGET_BETA>0.6</TARGET_BETA> <STARTWITHTARGET>0</STARTWITHTARGET> <USE_BIDPENALTY>0</USE_BIDPENALTY> <BIDPENALTY_FACTOR>1</BIDPENALTY_FACTOR> <BIDPENALTY_SHOW>2</BIDPENALTY_SHOW>  \n    <USE_MESSAGES>1</USE_MESSAGES> <USE_MAX>2</USE_MAX> <MAX_OFFER>2000</MAX_OFFER> <BID_MIN_0_>undefined</BID_MIN_0_> <BID_MIN_1_>1</BID_MIN_1_> <BID_MIN_2_>1</BID_MIN_2_> <BID_MIN_3_>1</BID_MIN_3_> <BID_MIN_4_>1</BID_MIN_4_>  \n    <BID_MAX_0_>undefined</BID_MAX_0_> <BID_MAX_1_>2</BID_MAX_1_> <BID_MAX_2_>2</BID_MAX_2_> <BID_MAX_3_>2</BID_MAX_3_> <BID_MAX_4_>2</BID_MAX_4_> <DISPLAY_MAXBID>1</DISPLAY_MAXBID>  \n    <FORCE_DEBRIEF>1</FORCE_DEBRIEF> <USE_VICKERY>0</USE_VICKERY> <USE_FEE>0</USE_FEE> <ROUND_TIMER1>180</ROUND_TIMER1> <ROUND_TIMER1_INC>5</ROUND_TIMER1_INC> <SHOW_GOTICKETS>0</SHOW_GOTICKETS> <NUMTICKETS>2</NUMTICKETS> <AVAIL_TICKETS>4</AVAIL_TICKETS>  \n    <FINAL_TYPE>1</FINAL_TYPE> <QTEST_CORRECT_0_>undefined</QTEST_CORRECT_0_> <QTEST_CORRECT_1_>1</QTEST_CORRECT_1_> <QTEST_CORRECT_2_>0</QTEST_CORRECT_2_> <QTEST_CORRECT_3_>0</QTEST_CORRECT_3_> <QTEST_CORRECT_4_>1</QTEST_CORRECT_4_> <QTEST_CORRECT_5_>1</QTEST_CORRECT_5_>  \n    <WHICH_RANDOM>1</WHICH_RANDOM> <RANDOMSEEDRESET>0</RANDOMSEEDRESET> <VERBOSEINTRO>0</VERBOSEINTRO> <N_RESUBMITS>4</N_RESUBMITS> <QUERY_FREQ1>4000</QUERY_FREQ1> <ISDEMO>1</ISDEMO> <NOWROUND>1</NOWROUND> <NOWROUND_SCENARIO>1</NOWROUND_SCENARIO>  \n    <SCENARIOVARS_RUNTIME>NPARTICIPANTS NACCEPT NUM_PERGROUP SHARES ,-1 -1 1 1 ,NPARTICIPANTS NACCEPT NUMROUNDS TYPENAMES NUM_PERGROUP P_BONUS EDOLLAR_RATE COST_MIN COST_MAX COST_RANGE QUALITY_MAXPOINTS QUALITY_PRICE SHARES DISCOUNTS UNDERBID_FACTOR OVERBID_FACTOR TARGET_BETA BIDPENALTY_FACTOR MAX_OFFER BID_MIN BID_MAX ROUND_TIMER1 ROUND_TIMER1_INC NUMTICKETS AVAIL_TICKETS QTEST_CORRECT N_RESUBMITS QUERY_FREQ1 USE_COSTRANGE USE_QUALITY USE_SHARES USE_DISCOUNTS USE_TARGETBID UNDERBID_TYPE TARGET_TYPE STARTWITHTARGET USE_BIDPENALTY BIDPENALTY_SHOW USE_MESSAGES USE_MAX DISPLAY_MAXBID FORCE_DEBRIEF USE_VICKERY USE_FEE SHOW_GOTICKETS FINAL_TYPE WHICH_RANDOM RANDOMSEEDRESET VERBOSEINTRO ISDEMO </SCENARIOVARS_RUNTIME> \n </data>', '1303586060');
INSERT INTO `generaldata` VALUES('2', '<!-- Saturday, April 23, 2011 3:14:35 PM--> \n <data><round>2</round> \n     <NPARTICIPANTS>10</NPARTICIPANTS> <NACCEPT>12</NACCEPT> <NUMROUNDS>32</NUMROUNDS> <TYPENAMES_0_>undefined</TYPENAMES_0_> <TYPENAMES_1_>A</TYPENAMES_1_> <TYPENAMES_2_>B</TYPENAMES_2_> <TYPENAMES_3_>C</TYPENAMES_3_> <TYPENAMES_4_>D</TYPENAMES_4_>  \n    <NUM_PERGROUP_0_>undefined</NUM_PERGROUP_0_> <NUM_PERGROUP_1_>5</NUM_PERGROUP_1_> <NUM_PERGROUP_2_>5</NUM_PERGROUP_2_> <NUM_PERGROUP_3_>5</NUM_PERGROUP_3_> <NUM_PERGROUP_4_>5</NUM_PERGROUP_4_> <P_BONUS>10.00</P_BONUS>  \n    <EDOLLAR_RATE>0.04</EDOLLAR_RATE> <COST_MIN_0_>undefined</COST_MIN_0_> <COST_MIN_1_>30</COST_MIN_1_> <COST_MIN_2_>20</COST_MIN_2_> <COST_MIN_3_>35</COST_MIN_3_> <COST_MIN_4_>40</COST_MIN_4_> <COST_MAX_0_>undefined</COST_MAX_0_>  \n    <COST_MAX_1_>45</COST_MAX_1_> <COST_MAX_2_>65</COST_MAX_2_> <COST_MAX_3_>95</COST_MAX_3_> <COST_MAX_4_>150</COST_MAX_4_> <USE_COSTRANGE>0</USE_COSTRANGE> <COST_RANGE_0_>undefined</COST_RANGE_0_> <COST_RANGE_1_>5</COST_RANGE_1_>  \n    <COST_RANGE_2_>5</COST_RANGE_2_> <COST_RANGE_3_>5</COST_RANGE_3_> <COST_RANGE_4_>5</COST_RANGE_4_> <USE_QUALITY>0</USE_QUALITY> <QUALITY_MAXPOINTS>20</QUALITY_MAXPOINTS> <QUALITY_PRICE>0.5</QUALITY_PRICE> <USE_SHARES>0</USE_SHARES>  \n    <SHARES_0_>undefined</SHARES_0_> <SHARES_1_>4</SHARES_1_> <SHARES_2_>4</SHARES_2_> <SHARES_3_>4</SHARES_3_> <SHARES_4_>4</SHARES_4_> <USE_DISCOUNTS>0</USE_DISCOUNTS> <DISCOUNTS_0_>undefined</DISCOUNTS_0_>  \n    <DISCOUNTS_1_>1.0</DISCOUNTS_1_> <DISCOUNTS_2_>1</DISCOUNTS_2_> <DISCOUNTS_3_>0</DISCOUNTS_3_> <DISCOUNTS_4_>0.8</DISCOUNTS_4_> <DISCOUNTS_5_>0.8</DISCOUNTS_5_> <USE_TARGETBID>0</USE_TARGETBID> <UNDERBID_TYPE>0</UNDERBID_TYPE>  \n    <UNDERBID_FACTOR>1</UNDERBID_FACTOR> <OVERBID_FACTOR>1</OVERBID_FACTOR> <TARGET_TYPE>0</TARGET_TYPE> <TARGET_BETA>0.6</TARGET_BETA> <STARTWITHTARGET>0</STARTWITHTARGET> <USE_BIDPENALTY>0</USE_BIDPENALTY> <BIDPENALTY_FACTOR>1</BIDPENALTY_FACTOR> <BIDPENALTY_SHOW>2</BIDPENALTY_SHOW>  \n    <USE_MESSAGES>1</USE_MESSAGES> <USE_MAX>2</USE_MAX> <MAX_OFFER>2000</MAX_OFFER> <BID_MIN_0_>undefined</BID_MIN_0_> <BID_MIN_1_>1</BID_MIN_1_> <BID_MIN_2_>1</BID_MIN_2_> <BID_MIN_3_>1</BID_MIN_3_> <BID_MIN_4_>1</BID_MIN_4_>  \n    <BID_MAX_0_>undefined</BID_MAX_0_> <BID_MAX_1_>2</BID_MAX_1_> <BID_MAX_2_>2</BID_MAX_2_> <BID_MAX_3_>2</BID_MAX_3_> <BID_MAX_4_>2</BID_MAX_4_> <DISPLAY_MAXBID>1</DISPLAY_MAXBID>  \n    <FORCE_DEBRIEF>1</FORCE_DEBRIEF> <USE_VICKERY>0</USE_VICKERY> <USE_FEE>0</USE_FEE> <ROUND_TIMER1>180</ROUND_TIMER1> <ROUND_TIMER1_INC>5</ROUND_TIMER1_INC> <SHOW_GOTICKETS>0</SHOW_GOTICKETS> <NUMTICKETS>2</NUMTICKETS> <AVAIL_TICKETS>4</AVAIL_TICKETS>  \n    <FINAL_TYPE>1</FINAL_TYPE> <QTEST_CORRECT_0_>undefined</QTEST_CORRECT_0_> <QTEST_CORRECT_1_>1</QTEST_CORRECT_1_> <QTEST_CORRECT_2_>0</QTEST_CORRECT_2_> <QTEST_CORRECT_3_>0</QTEST_CORRECT_3_> <QTEST_CORRECT_4_>1</QTEST_CORRECT_4_> <QTEST_CORRECT_5_>1</QTEST_CORRECT_5_>  \n    <WHICH_RANDOM>1</WHICH_RANDOM> <RANDOMSEEDRESET>0</RANDOMSEEDRESET> <VERBOSEINTRO>0</VERBOSEINTRO> <N_RESUBMITS>4</N_RESUBMITS> <QUERY_FREQ1>4000</QUERY_FREQ1> <ISDEMO>0</ISDEMO> <NOWROUND>2</NOWROUND> <NOWROUND_SCENARIO>2</NOWROUND_SCENARIO>  \n    <SCENARIOVARS_RUNTIME>NPARTICIPANTS NACCEPT NUM_PERGROUP SHARES ,-1 -1 1 1 ,NPARTICIPANTS NACCEPT NUMROUNDS TYPENAMES NUM_PERGROUP P_BONUS EDOLLAR_RATE COST_MIN COST_MAX COST_RANGE QUALITY_MAXPOINTS QUALITY_PRICE SHARES DISCOUNTS UNDERBID_FACTOR OVERBID_FACTOR TARGET_BETA BIDPENALTY_FACTOR MAX_OFFER BID_MIN BID_MAX ROUND_TIMER1 ROUND_TIMER1_INC NUMTICKETS AVAIL_TICKETS QTEST_CORRECT N_RESUBMITS QUERY_FREQ1 USE_COSTRANGE USE_QUALITY USE_SHARES USE_DISCOUNTS USE_TARGETBID UNDERBID_TYPE TARGET_TYPE STARTWITHTARGET USE_BIDPENALTY BIDPENALTY_SHOW USE_MESSAGES USE_MAX DISPLAY_MAXBID FORCE_DEBRIEF USE_VICKERY USE_FEE SHOW_GOTICKETS FINAL_TYPE WHICH_RANDOM RANDOMSEEDRESET VERBOSEINTRO ISDEMO </SCENARIOVARS_RUNTIME> <NOMOREROUNDS>0</NOMOREROUNDS> \n </data>', '1303586075');
INSERT INTO `generaldata` VALUES('3', '<!-- Saturday, April 23, 2011 3:15:24 PM--> \n <data><round>3</round> \n     <NPARTICIPANTS>10</NPARTICIPANTS> <NACCEPT>12</NACCEPT> <NUMROUNDS>32</NUMROUNDS> <TYPENAMES_0_>undefined</TYPENAMES_0_> <TYPENAMES_1_>A</TYPENAMES_1_> <TYPENAMES_2_>B</TYPENAMES_2_> <TYPENAMES_3_>C</TYPENAMES_3_> <TYPENAMES_4_>D</TYPENAMES_4_>  \n    <NUM_PERGROUP_0_>undefined</NUM_PERGROUP_0_> <NUM_PERGROUP_1_>5</NUM_PERGROUP_1_> <NUM_PERGROUP_2_>5</NUM_PERGROUP_2_> <NUM_PERGROUP_3_>5</NUM_PERGROUP_3_> <NUM_PERGROUP_4_>5</NUM_PERGROUP_4_> <P_BONUS>10.00</P_BONUS>  \n    <EDOLLAR_RATE>0.04</EDOLLAR_RATE> <COST_MIN_0_>undefined</COST_MIN_0_> <COST_MIN_1_>30</COST_MIN_1_> <COST_MIN_2_>20</COST_MIN_2_> <COST_MIN_3_>35</COST_MIN_3_> <COST_MIN_4_>40</COST_MIN_4_> <COST_MAX_0_>undefined</COST_MAX_0_>  \n    <COST_MAX_1_>45</COST_MAX_1_> <COST_MAX_2_>65</COST_MAX_2_> <COST_MAX_3_>95</COST_MAX_3_> <COST_MAX_4_>150</COST_MAX_4_> <USE_COSTRANGE>0</USE_COSTRANGE> <COST_RANGE_0_>undefined</COST_RANGE_0_> <COST_RANGE_1_>5</COST_RANGE_1_>  \n    <COST_RANGE_2_>5</COST_RANGE_2_> <COST_RANGE_3_>5</COST_RANGE_3_> <COST_RANGE_4_>5</COST_RANGE_4_> <USE_QUALITY>1</USE_QUALITY> <QUALITY_MAXPOINTS>20</QUALITY_MAXPOINTS> <QUALITY_PRICE>0.5</QUALITY_PRICE> <USE_SHARES>0</USE_SHARES>  \n    <SHARES_0_>undefined</SHARES_0_> <SHARES_1_>4</SHARES_1_> <SHARES_2_>4</SHARES_2_> <SHARES_3_>4</SHARES_3_> <SHARES_4_>4</SHARES_4_> <USE_DISCOUNTS>0</USE_DISCOUNTS> <DISCOUNTS_0_>undefined</DISCOUNTS_0_>  \n    <DISCOUNTS_1_>1.0</DISCOUNTS_1_> <DISCOUNTS_2_>1</DISCOUNTS_2_> <DISCOUNTS_3_>0</DISCOUNTS_3_> <DISCOUNTS_4_>0.8</DISCOUNTS_4_> <DISCOUNTS_5_>0.8</DISCOUNTS_5_> <USE_TARGETBID>0</USE_TARGETBID> <UNDERBID_TYPE>0</UNDERBID_TYPE>  \n    <UNDERBID_FACTOR>1</UNDERBID_FACTOR> <OVERBID_FACTOR>1</OVERBID_FACTOR> <TARGET_TYPE>0</TARGET_TYPE> <TARGET_BETA>0.6</TARGET_BETA> <STARTWITHTARGET>0</STARTWITHTARGET> <USE_BIDPENALTY>0</USE_BIDPENALTY> <BIDPENALTY_FACTOR>1</BIDPENALTY_FACTOR> <BIDPENALTY_SHOW>2</BIDPENALTY_SHOW>  \n    <USE_MESSAGES>1</USE_MESSAGES> <USE_MAX>2</USE_MAX> <MAX_OFFER>2000</MAX_OFFER> <BID_MIN_0_>undefined</BID_MIN_0_> <BID_MIN_1_>1</BID_MIN_1_> <BID_MIN_2_>1</BID_MIN_2_> <BID_MIN_3_>1</BID_MIN_3_> <BID_MIN_4_>1</BID_MIN_4_>  \n    <BID_MAX_0_>undefined</BID_MAX_0_> <BID_MAX_1_>2</BID_MAX_1_> <BID_MAX_2_>2</BID_MAX_2_> <BID_MAX_3_>2</BID_MAX_3_> <BID_MAX_4_>2</BID_MAX_4_> <DISPLAY_MAXBID>1</DISPLAY_MAXBID>  \n    <FORCE_DEBRIEF>1</FORCE_DEBRIEF> <USE_VICKERY>0</USE_VICKERY> <USE_FEE>0</USE_FEE> <ROUND_TIMER1>180</ROUND_TIMER1> <ROUND_TIMER1_INC>5</ROUND_TIMER1_INC> <SHOW_GOTICKETS>0</SHOW_GOTICKETS> <NUMTICKETS>2</NUMTICKETS> <AVAIL_TICKETS>4</AVAIL_TICKETS>  \n    <FINAL_TYPE>1</FINAL_TYPE> <QTEST_CORRECT_0_>undefined</QTEST_CORRECT_0_> <QTEST_CORRECT_1_>1</QTEST_CORRECT_1_> <QTEST_CORRECT_2_>0</QTEST_CORRECT_2_> <QTEST_CORRECT_3_>0</QTEST_CORRECT_3_> <QTEST_CORRECT_4_>1</QTEST_CORRECT_4_> <QTEST_CORRECT_5_>1</QTEST_CORRECT_5_>  \n    <WHICH_RANDOM>1</WHICH_RANDOM> <RANDOMSEEDRESET>0</RANDOMSEEDRESET> <VERBOSEINTRO>0</VERBOSEINTRO> <N_RESUBMITS>4</N_RESUBMITS> <QUERY_FREQ1>4000</QUERY_FREQ1> <ISDEMO>1</ISDEMO> <NOWROUND>3</NOWROUND> <NOWROUND_SCENARIO>1</NOWROUND_SCENARIO>  \n    <SCENARIOVARS_RUNTIME>NPARTICIPANTS NACCEPT NUM_PERGROUP SHARES ,-1 -1 1 1 ,NPARTICIPANTS NACCEPT NUMROUNDS TYPENAMES NUM_PERGROUP P_BONUS EDOLLAR_RATE COST_MIN COST_MAX COST_RANGE QUALITY_MAXPOINTS QUALITY_PRICE SHARES DISCOUNTS UNDERBID_FACTOR OVERBID_FACTOR TARGET_BETA BIDPENALTY_FACTOR MAX_OFFER BID_MIN BID_MAX ROUND_TIMER1 ROUND_TIMER1_INC NUMTICKETS AVAIL_TICKETS QTEST_CORRECT N_RESUBMITS QUERY_FREQ1 USE_COSTRANGE USE_QUALITY USE_SHARES USE_DISCOUNTS USE_TARGETBID UNDERBID_TYPE TARGET_TYPE STARTWITHTARGET USE_BIDPENALTY BIDPENALTY_SHOW USE_MESSAGES USE_MAX DISPLAY_MAXBID FORCE_DEBRIEF USE_VICKERY USE_FEE SHOW_GOTICKETS FINAL_TYPE WHICH_RANDOM RANDOMSEEDRESET VERBOSEINTRO ISDEMO </SCENARIOVARS_RUNTIME> <NOMOREROUNDS>0</NOMOREROUNDS> \n </data>', '1303586124');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');
INSERT INTO `historydata` VALUES('1', '<!-- Saturday, April 23, 2011 3:14:20 PM  for round 1, #  clients = 1  --> \n \n <data><round>1</round> <id>00326_5757</id> \n     <NOWROUND_SCENARIO>1</NOWROUND_SCENARIO>  \n    <NOWROUND>1</NOWROUND> <ISDEMO>1</ISDEMO> <NUMTICKETS>2</NUMTICKETS> <USE_TARGETBID>0</USE_TARGETBID>  \n    <USE_QUALITY>0</USE_QUALITY> <USE_BIDPENALTY>0</USE_BIDPENALTY> <BIGPENALTY_FACTOR></BIGPENALTY_FACTOR>  \n    <DISCOUNTS_1_>1.0</DISCOUNTS_1_> <DISCOUNTS_2_>1</DISCOUNTS_2_> <DISCOUNTS_3_>0</DISCOUNTS_3_>  \n    <DISCOUNTS_4_>0.8</DISCOUNTS_4_> <DISCOUNTS_5_>0.8</DISCOUNTS_5_> <USE_DISCOUNTS>0</USE_DISCOUNTS>  \n    <USE_FEE>0</USE_FEE> <TYPENAMES_1_>A</TYPENAMES_1_> <TYPENAMES_2_>B</TYPENAMES_2_>  \n    <TYPENAMES_3_>C</TYPENAMES_3_> <TYPENAMES_4_>D</TYPENAMES_4_> <CUMEARN>0</CUMEARN>  \n    <GROUP_1_>  1</GROUP_1_> <GROUP_2_>  4</GROUP_2_> <GROUP_3_>  1</GROUP_3_> <FEE_USED_1_>0</FEE_USED_1_>  \n    <FEE_USED_2_>0</FEE_USED_2_> <PRODCOST_USED_1_>44</PRODCOST_USED_1_> <PRODCOST_USED_2_>143</PRODCOST_USED_2_>  \n    <PRODCOST_LOWER_1_>44</PRODCOST_LOWER_1_> <PRODCOST_LOWER_2_>143</PRODCOST_LOWER_2_>  \n    <PRODCOST_UPPER_1_>44</PRODCOST_UPPER_1_> <PRODCOST_UPPER_2_>143</PRODCOST_UPPER_2_>  \n    <TARGETBID_1_>39</TARGETBID_1_> <TARGETBID_2_>106</TARGETBID_2_> <BIDS_USED_1_>50</BIDS_USED_1_>  \n    <BIDS_USED_2_>152</BIDS_USED_2_> <QPOINTS_USED_1_>0</QPOINTS_USED_1_> <QPOINTS_USED_2_>0</QPOINTS_USED_2_>  \n    <SCORES_USED_1_>50</SCORES_USED_1_> <SCORES_USED_2_>152</SCORES_USED_2_> <STATUS_1_>4</STATUS_1_>  \n    <STATUS_2_>4</STATUS_2_> <MAXACCEPTTICKET_1_>152.00</MAXACCEPTTICKET_1_> <MAXACCEPTTICKET_2_>152.00</MAXACCEPTTICKET_2_>  \n    <EARN_1_>6</EARN_1_> <EARN_2_>9</EARN_2_> <SCORES2_1_>50</SCORES2_1_> <SCORES2_2_>152</SCORES2_2_>  \n    \n </data>', '1303586060');
INSERT INTO `historydata` VALUES('2', '<!-- Saturday, April 23, 2011 3:14:36 PM  for round 2, #  clients = 1  --> \n \n <data><round>2</round> <id>00326_5757</id> \n     <NOWROUND_SCENARIO>2</NOWROUND_SCENARIO>  \n    <NOWROUND>2</NOWROUND> <ISDEMO>0</ISDEMO> <NUMTICKETS>2</NUMTICKETS> <USE_TARGETBID>0</USE_TARGETBID>  \n    <USE_QUALITY>0</USE_QUALITY> <USE_BIDPENALTY>0</USE_BIDPENALTY> <BIGPENALTY_FACTOR></BIGPENALTY_FACTOR>  \n    <DISCOUNTS_1_>1.0</DISCOUNTS_1_> <DISCOUNTS_2_>1</DISCOUNTS_2_> <DISCOUNTS_3_>0</DISCOUNTS_3_>  \n    <DISCOUNTS_4_>0.8</DISCOUNTS_4_> <DISCOUNTS_5_>0.8</DISCOUNTS_5_> <USE_DISCOUNTS>0</USE_DISCOUNTS>  \n    <USE_FEE>0</USE_FEE> <TYPENAMES_1_>A</TYPENAMES_1_> <TYPENAMES_2_>B</TYPENAMES_2_>  \n    <TYPENAMES_3_>C</TYPENAMES_3_> <TYPENAMES_4_>D</TYPENAMES_4_> <CUMEARN>0</CUMEARN>  \n    <GROUP_1_>  1</GROUP_1_> <GROUP_2_>  4</GROUP_2_> <GROUP_3_>  1</GROUP_3_> <FEE_USED_1_>0</FEE_USED_1_>  \n    <FEE_USED_2_>0</FEE_USED_2_> <PRODCOST_USED_1_>41</PRODCOST_USED_1_> <PRODCOST_USED_2_>121.2</PRODCOST_USED_2_>  \n    <PRODCOST_LOWER_1_>41</PRODCOST_LOWER_1_> <PRODCOST_LOWER_2_>121.2</PRODCOST_LOWER_2_>  \n    <PRODCOST_UPPER_1_>41</PRODCOST_UPPER_1_> <PRODCOST_UPPER_2_>121.2</PRODCOST_UPPER_2_>  \n    <TARGETBID_1_>39</TARGETBID_1_> <TARGETBID_2_>106</TARGETBID_2_> <BIDS_USED_1_>48</BIDS_USED_1_>  \n    <BIDS_USED_2_>126</BIDS_USED_2_> <QPOINTS_USED_1_>0</QPOINTS_USED_1_> <QPOINTS_USED_2_>0</QPOINTS_USED_2_>  \n    <SCORES_USED_1_>48</SCORES_USED_1_> <SCORES_USED_2_>126</SCORES_USED_2_> <STATUS_1_>4</STATUS_1_>  \n    <STATUS_2_>4</STATUS_2_> <MAXACCEPTTICKET_1_>126.00</MAXACCEPTTICKET_1_> <MAXACCEPTTICKET_2_>126.00</MAXACCEPTTICKET_2_>  \n    <EARN_1_>7</EARN_1_> <EARN_2_>4.799999999999997</EARN_2_> <SCORES2_1_>48</SCORES2_1_>  \n    <SCORES2_2_>126</SCORES2_2_> \n </data>', '1303586076');
INSERT INTO `historydata` VALUES('3', '<!-- Saturday, April 23, 2011 3:15:25 PM  for round 3, #  clients = 1  --> \n \n <data><round>3</round> <id>00326_5757</id> \n     <NOWROUND_SCENARIO>1</NOWROUND_SCENARIO>  \n    <NOWROUND>3</NOWROUND> <ISDEMO>1</ISDEMO> <NUMTICKETS>2</NUMTICKETS> <USE_TARGETBID>0</USE_TARGETBID>  \n    <USE_QUALITY>1</USE_QUALITY> <USE_BIDPENALTY>0</USE_BIDPENALTY> <BIGPENALTY_FACTOR></BIGPENALTY_FACTOR>  \n    <DISCOUNTS_1_>1.0</DISCOUNTS_1_> <DISCOUNTS_2_>1</DISCOUNTS_2_> <DISCOUNTS_3_>0</DISCOUNTS_3_>  \n    <DISCOUNTS_4_>0.8</DISCOUNTS_4_> <DISCOUNTS_5_>0.8</DISCOUNTS_5_> <USE_DISCOUNTS>0</USE_DISCOUNTS>  \n    <USE_FEE>0</USE_FEE> <TYPENAMES_1_>A</TYPENAMES_1_> <TYPENAMES_2_>B</TYPENAMES_2_>  \n    <TYPENAMES_3_>C</TYPENAMES_3_> <TYPENAMES_4_>D</TYPENAMES_4_> <CUMEARN>11.799999999999997</CUMEARN>  \n    <GROUP_1_>  1</GROUP_1_> <GROUP_2_>  4</GROUP_2_> <GROUP_3_>  1</GROUP_3_> <FEE_USED_1_>0</FEE_USED_1_>  \n    <FEE_USED_2_>0</FEE_USED_2_> <PRODCOST_USED_1_>34.8</PRODCOST_USED_1_> <PRODCOST_USED_2_>75</PRODCOST_USED_2_>  \n    <PRODCOST_LOWER_1_>34.8</PRODCOST_LOWER_1_> <PRODCOST_LOWER_2_>75</PRODCOST_LOWER_2_>  \n    <PRODCOST_UPPER_1_>34.8</PRODCOST_UPPER_1_> <PRODCOST_UPPER_2_>75</PRODCOST_UPPER_2_>  \n    <TARGETBID_1_>39</TARGETBID_1_> <TARGETBID_2_>106</TARGETBID_2_> <BIDS_USED_1_>53</BIDS_USED_1_>  \n    <BIDS_USED_2_>80</BIDS_USED_2_> <QPOINTS_USED_1_>20</QPOINTS_USED_1_> <QPOINTS_USED_2_>0</QPOINTS_USED_2_>  \n    <SCORES_USED_1_>33</SCORES_USED_1_> <SCORES_USED_2_>80</SCORES_USED_2_> <STATUS_1_>4</STATUS_1_>  \n    <STATUS_2_>4</STATUS_2_> <MAXACCEPTTICKET_1_>80.00</MAXACCEPTTICKET_1_> <MAXACCEPTTICKET_2_>80.00</MAXACCEPTTICKET_2_>  \n    <EARN_1_>8.200000000000003</EARN_1_> <EARN_2_>5</EARN_2_> <SCORES2_1_>33</SCORES2_1_>  \n    <SCORES2_2_>80</SCORES2_2_> \n </data>', '1303586125');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');
INSERT INTO `resultsdata` VALUES('1', '<!-- Saturday, April 23, 2011 3:14:20 PM  for round 1, #  clients = 1  --> \n \n <data><round>1</round> <id>00326_5757</id> \n     <EARN_1_>6</EARN_1_> <STATUS_1_>4</STATUS_1_> <EARN_2_>9</EARN_2_> <STATUS_2_>4</STATUS_2_> <ROUNDEARN>15</ROUNDEARN> <SCORES2_1_>50</SCORES2_1_>  \n    <MAXACCEPTTICKET_1_>152.00</MAXACCEPTTICKET_1_> <MINBIDGROUP_1_>50</MINBIDGROUP_1_> <SCORES2_2_>152</SCORES2_2_> <MAXACCEPTTICKET_2_>152.00</MAXACCEPTTICKET_2_> <MINBIDGROUP_2_>152</MINBIDGROUP_2_> \n </data> \n <data><round>1</round><id>*</id> \n     <NTICKETS>2</NTICKETS>  \n    <ISDEMO>1</ISDEMO> <MAXACCEPT>152.00</MAXACCEPT> <MINREJECT>n.a</MINREJECT> <NSUBMITS>2</NSUBMITS> <NACCEPT>2</NACCEPT> <TOTALEARNALLACCEPT>15.00</TOTALEARNALLACCEPT>  \n    <TOTALCOSTALLACCEPT>187.00</TOTALCOSTALLACCEPT> <TOTALCOSTALLREJECT>0.00</TOTALCOSTALLREJECT> <GROUPLIST_0_>1</GROUPLIST_0_> <GROUPLIST_1_>4</GROUPLIST_1_> <NACCEPTSGROUP_1_>1</NACCEPTSGROUP_1_> <NACCEPTSGROUP_2_>0</NACCEPTSGROUP_2_>  \n    <NACCEPTSGROUP_3_>0</NACCEPTSGROUP_3_> <NACCEPTSGROUP_4_>1</NACCEPTSGROUP_4_> <NSUBMITSGROUP_1_>1</NSUBMITSGROUP_1_> <NSUBMITSGROUP_2_>0</NSUBMITSGROUP_2_> <NSUBMITSGROUP_3_>0</NSUBMITSGROUP_3_> <NSUBMITSGROUP_4_>1</NSUBMITSGROUP_4_>  \n    </data>', '1303586060');
INSERT INTO `resultsdata` VALUES('2', '<!-- Saturday, April 23, 2011 3:14:35 PM  for round 2, #  clients = 1  --> \n \n <data><round>2</round> <id>00326_5757</id> \n     <EARN_1_>7</EARN_1_> <STATUS_1_>4</STATUS_1_> <EARN_2_>4.799999999999997</EARN_2_> <STATUS_2_>4</STATUS_2_> <ROUNDEARN>11.799999999999997</ROUNDEARN> <SCORES2_1_>48</SCORES2_1_>  \n    <MAXACCEPTTICKET_1_>126.00</MAXACCEPTTICKET_1_> <MINBIDGROUP_1_>48</MINBIDGROUP_1_> <SCORES2_2_>126</SCORES2_2_> <MAXACCEPTTICKET_2_>126.00</MAXACCEPTTICKET_2_> <MINBIDGROUP_2_>126</MINBIDGROUP_2_> \n </data> \n <data><round>2</round><id>*</id> \n     <NTICKETS>2</NTICKETS>  \n    <ISDEMO>0</ISDEMO> <MAXACCEPT>126.00</MAXACCEPT> <MINREJECT>n.a</MINREJECT> <NSUBMITS>2</NSUBMITS> <NACCEPT>2</NACCEPT> <TOTALEARNALLACCEPT>11.80</TOTALEARNALLACCEPT>  \n    <TOTALCOSTALLACCEPT>162.20</TOTALCOSTALLACCEPT> <TOTALCOSTALLREJECT>0.00</TOTALCOSTALLREJECT> <GROUPLIST_0_>1</GROUPLIST_0_> <GROUPLIST_1_>4</GROUPLIST_1_> <NACCEPTSGROUP_1_>1</NACCEPTSGROUP_1_> <NACCEPTSGROUP_2_>0</NACCEPTSGROUP_2_>  \n    <NACCEPTSGROUP_3_>0</NACCEPTSGROUP_3_> <NACCEPTSGROUP_4_>1</NACCEPTSGROUP_4_> <NSUBMITSGROUP_1_>1</NSUBMITSGROUP_1_> <NSUBMITSGROUP_2_>0</NSUBMITSGROUP_2_> <NSUBMITSGROUP_3_>0</NSUBMITSGROUP_3_> <NSUBMITSGROUP_4_>1</NSUBMITSGROUP_4_>  \n    </data>', '1303586075');
INSERT INTO `resultsdata` VALUES('3', '<!-- Saturday, April 23, 2011 3:15:24 PM  for round 3, #  clients = 1  --> \n \n <data><round>3</round> <id>00326_5757</id> \n     <EARN_1_>8.200000000000003</EARN_1_> <STATUS_1_>4</STATUS_1_> <EARN_2_>5</EARN_2_> <STATUS_2_>4</STATUS_2_> <ROUNDEARN>13.200000000000003</ROUNDEARN> <SCORES2_1_>33</SCORES2_1_>  \n    <MAXACCEPTTICKET_1_>80.00</MAXACCEPTTICKET_1_> <MINBIDGROUP_1_>53</MINBIDGROUP_1_> <SCORES2_2_>80</SCORES2_2_> <MAXACCEPTTICKET_2_>80.00</MAXACCEPTTICKET_2_> <MINBIDGROUP_2_>80</MINBIDGROUP_2_> \n </data> \n <data><round>3</round><id>*</id> \n     <NTICKETS>2</NTICKETS>  \n    <ISDEMO>1</ISDEMO> <MAXACCEPT>80.00</MAXACCEPT> <MINREJECT>n.a</MINREJECT> <NSUBMITS>2</NSUBMITS> <NACCEPT>2</NACCEPT> <TOTALEARNALLACCEPT>13.20</TOTALEARNALLACCEPT>  \n    <TOTALCOSTALLACCEPT>109.80</TOTALCOSTALLACCEPT> <TOTALCOSTALLREJECT>0.00</TOTALCOSTALLREJECT> <GROUPLIST_0_>1</GROUPLIST_0_> <GROUPLIST_1_>4</GROUPLIST_1_> <NACCEPTSGROUP_1_>1</NACCEPTSGROUP_1_> <NACCEPTSGROUP_2_>0</NACCEPTSGROUP_2_>  \n    <NACCEPTSGROUP_3_>0</NACCEPTSGROUP_3_> <NACCEPTSGROUP_4_>1</NACCEPTSGROUP_4_> <NSUBMITSGROUP_1_>1</NSUBMITSGROUP_1_> <NSUBMITSGROUP_2_>0</NSUBMITSGROUP_2_> <NSUBMITSGROUP_3_>0</NSUBMITSGROUP_3_> <NSUBMITSGROUP_4_>1</NSUBMITSGROUP_4_>  \n    </data>', '1303586124');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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('CUMCASHEARNINGS', '0.4719999999999999', '1303586075');
INSERT INTO `servervars` VALUES('DODEBRIEFERS', '1', '1303586011');
INSERT INTO `servervars` VALUES('ENABLESUBMIT', '1', '1303586000');
INSERT INTO `servervars` VALUES('FORCEDEBRIEFERS', '1', '1303586018');
INSERT INTO `servervars` VALUES('FORCESUBMIT', '1', '1303586010');
INSERT INTO `servervars` VALUES('INTROADMIN_VAR', '1001', '1303585996');
INSERT INTO `servervars` VALUES('MAXRECORDID', '30', '1303585948');
INSERT INTO `servervars` VALUES('ROUND', '3', '1303586083');
INSERT INTO `servervars` VALUES('SHOW_PAGE', '3', '1303586091');
INSERT INTO `servervars` VALUES('STARTSESSION', '1', '1303585987');
INSERT INTO `servervars` VALUES('STARTSESSIONREAL', '1', '1303585988');
INSERT INTO `servervars` VALUES('_created', '1303566298', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303585986');
INSERT INTO `statusvars` VALUES('users', ' A:00326_5757= ', '1303585974');
INSERT INTO `statusvars` VALUES('_created', 'Sat, 23 Apr 11 13:44:58 +0000', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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('00326_5757:1', '1303586017347');
INSERT INTO `submitstatus` VALUES('00326_5757:2', '1303586073089');
INSERT INTO `submitstatus` VALUES('00326_5757:3', '1303586121537');
INSERT INTO `submitstatus` VALUES('_created', '1303566298');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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('00326_5757', '1', '1303586017', '1303586017347', '0', '1', '<data id=\"00326_5757\"  round=\"1\" ct=\"1\" notFinal=\"0\" time=\"1303586017347\" > <vars>USE_DISCOUNTS USE_SHARES USE_QUALITY USE_TARGETBID QUALITY_PRICE UNDERBID_FACTOR TOTEARN TOTSCORE CUMEARN MYNAME BIDS_USED[1] BIDS_USED[2] QPOINTS_USED[1] QPOINTS_USED[2] SCORES_USED[1] SCORES_USED[2] EARNINGS_USED[1] EARNINGS_USED[2] TARGETBID[1] TARGETBID[2] UNDERBIDPOINTS_USED[1] UNDERBIDPOINTS_USED[2] MYGROUP[1] MYGROUP[2] PRODCOST_USED[1] PRODCOST_USED[2] PRODCOST_LOWER[1] PRODCOST_LOWER[2] PRODCOST_UPPER[1] PRODCOST_UPPER[2] MAXBID_USED[1] MAXBID_USED[2] FEE_USED[1] FEE_USED[2] DISCOUNTS[0] DISCOUNTS[1] DISCOUNTS[2] DISCOUNTS[3] DISCOUNTS[4] DISCOUNTS[5] SHARES[0] SHARES[1] SHARES[2] SHARES[3] SHARES[4] QTEST_ANSWER[1] QTEST_ANSWER[2] QTEST_ANSWER[3] QTEST_ANSWER[4] QTEST_ANSWER[5]</vars><vals>0,0,0,0,0.5,1,15,202,0,A,50,152,0,0,50,152,6,9,39,106,0,0,1,4,44,143,44,143,44,143,90,300,0,0,undefined,1.0,1,0,0.8,0.8,undefined,4,4,4,4,1,1,0,0,0</vals><status>SUBMIT_INTRO1</status></data>', 'id=00326_5757 & name=A & time=1303586017347 & round=1 & action=Submit');
INSERT INTO `submitted` VALUES('00326_5757', '2', '1303586073', '1303586073089', '0', '1', '<data id=\"00326_5757\"  round=\"2\" ct=\"1\" notFinal=\"0\" time=\"1303586073089\" > <vars>USE_DISCOUNTS USE_SHARES USE_QUALITY USE_TARGETBID QUALITY_PRICE UNDERBID_FACTOR TOTEARN TOTSCORE CUMEARN BIDS_USED[1] BIDS_USED[2] QPOINTS_USED[1] QPOINTS_USED[2] SCORES_USED[1] SCORES_USED[2] EARNINGS_USED[1] EARNINGS_USED[2] TARGETBID[1] TARGETBID[2] UNDERBIDPOINTS_USED[1] UNDERBIDPOINTS_USED[2] MYGROUP[1] MYGROUP[2] PRODCOST_USED[1] PRODCOST_USED[2] PRODCOST_LOWER[1] PRODCOST_LOWER[2] PRODCOST_UPPER[1] PRODCOST_UPPER[2] MAXBID_USED[1] MAXBID_USED[2] FEE_USED[1] FEE_USED[2] DISCOUNTS[0] DISCOUNTS[1] DISCOUNTS[2] DISCOUNTS[3] DISCOUNTS[4] DISCOUNTS[5] SHARES[0] SHARES[1] SHARES[2] SHARES[3] SHARES[4]</vars><vals>0,0,0,0,0.5,1,11.799999999999997,174,0,48,126,0,0,48,126,7,4.799999999999997,39,106,0,0,1,4,41,121.2,41,121.2,41,121.2,90,300,0,0,undefined,1.0,1,0,0.8,0.8,undefined,4,4,4,4</vals><status>SUBMIT_2</status></data>', 'id=00326_5757 & name=A & time=1303586073089 & round=2 & action=Submit');
INSERT INTO `submitted` VALUES('00326_5757', '3', '1303586121', '1303586121537', '0', '1', '<data id=\"00326_5757\"  round=\"3\" ct=\"1\" notFinal=\"0\" time=\"1303586121537\" > <vars>USE_DISCOUNTS USE_SHARES USE_QUALITY USE_TARGETBID QUALITY_PRICE UNDERBID_FACTOR TOTEARN TOTSCORE CUMEARN BIDS_USED[1] BIDS_USED[2] QPOINTS_USED[1] QPOINTS_USED[2] SCORES_USED[1] SCORES_USED[2] EARNINGS_USED[1] EARNINGS_USED[2] TARGETBID[1] TARGETBID[2] UNDERBIDPOINTS_USED[1] UNDERBIDPOINTS_USED[2] MYGROUP[1] MYGROUP[2] PRODCOST_USED[1] PRODCOST_USED[2] PRODCOST_LOWER[1] PRODCOST_LOWER[2] PRODCOST_UPPER[1] PRODCOST_UPPER[2] MAXBID_USED[1] MAXBID_USED[2] FEE_USED[1] FEE_USED[2] DISCOUNTS[0] DISCOUNTS[1] DISCOUNTS[2] DISCOUNTS[3] DISCOUNTS[4] DISCOUNTS[5] SHARES[0] SHARES[1] SHARES[2] SHARES[3] SHARES[4]</vars><vals>0,0,1,0,0.5,1,13.200000000000003,113,11.799999999999997,53,80,20,0,33,80,8.200000000000003,5,39,106,0,0,1,4,34.8,75,34.8,75,34.8,75,90,300,0,0,undefined,1.0,1,0,0.8,0.8,undefined,4,4,4,4</vals><status>SUBMIT_3</status></data>', 'id=00326_5757 & name=A & time=1303586121537 & round=3 & action=Submit');
INSERT INTO `submitted` VALUES('_created', '-1', '1303566298', 'Sat, 23 Apr 11 13:44:58 +0000', '', '0', '', 'for submitted data');

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

-- 
--  For dSurvey session $ERS_glug1 on Sat, 23 Apr 11 19:15:44 +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', '1303566298');
INSERT INTO `usersdata` VALUES('1', '<!-- Saturday, April 23, 2011 3:14:20 PM  for round 1, #  clients = 1  --> \n \n <data><round>1</round><id>00326_5757</id> \n     <MYTYPE>  1</MYTYPE> <GROUP_1_>  1</GROUP_1_> <FEE_1_>  1</FEE_1_> <GROUP_2_>  4</GROUP_2_> <FEE_2_>  2</FEE_2_> <GROUP_3_>  1</GROUP_3_>  \n    <FEE_3_>  2</FEE_3_> <SEED1>  3222</SEED1> <SEED2>  9871</SEED2> </data>', '1303586060');
INSERT INTO `usersdata` VALUES('2', '<!-- Saturday, April 23, 2011 3:14:35 PM  for round 2, #  clients = 1  --> \n \n <data><round>2</round><id>00326_5757</id> \n     <MYTYPE>  1</MYTYPE> <GROUP_1_>  1</GROUP_1_> <FEE_1_>  1</FEE_1_> <GROUP_2_>  4</GROUP_2_> <FEE_2_>  2</FEE_2_> <GROUP_3_>  1</GROUP_3_>  \n    <FEE_3_>  2</FEE_3_> <SEED1>  3222</SEED1> <SEED2>  9871</SEED2> </data>', '1303586076');
INSERT INTO `usersdata` VALUES('3', '<!-- Saturday, April 23, 2011 3:15:24 PM  for round 3, #  clients = 1  --> \n \n <data><round>3</round><id>00326_5757</id> \n     <MYTYPE>  1</MYTYPE> <GROUP_1_>  1</GROUP_1_> <FEE_1_>  1</FEE_1_> <GROUP_2_>  4</GROUP_2_> <FEE_2_>  2</FEE_2_> <GROUP_3_>  1</GROUP_3_>  \n    <FEE_3_>  2</FEE_3_> <SEED1>  3222</SEED1> <SEED2>  9871</SEED2> </data>', '1303586124');

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

