-- MySQL dump 10.11
--
-- Host: localhost    Database: ianseo
-- ------------------------------------------------------

/*!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 `AccColors`
--

DROP TABLE IF EXISTS `AccColors`;
CREATE TABLE `AccColors` (
  `AcTournament` int(10) unsigned NOT NULL,
  `AcDivClass` varchar(4) NOT NULL,
  `AcColor` varchar(6) NOT NULL,
  `AcIsAthlete` tinyint(3) unsigned NOT NULL,
  `AcTitleReverse` tinyint(4) NOT NULL default '0',
  `AcArea0` tinyint(4) NOT NULL default '0',
  `AcArea1` tinyint(4) NOT NULL default '0',
  `AcArea2` tinyint(4) NOT NULL default '0',
  `AcArea3` tinyint(4) NOT NULL default '0',
  `AcArea4` tinyint(4) NOT NULL default '0',
  `AcArea5` tinyint(4) NOT NULL default '0',
  `AcArea6` tinyint(4) NOT NULL default '0',
  `AcArea7` tinyint(4) NOT NULL default '0',
  `AcAreaStar` tinyint(4) NOT NULL default '0',
  `AcTransport` tinyint(4) NOT NULL default '0',
  `AcAccomodation` tinyint(4) NOT NULL default '0',
  `AcMeal` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`AcTournament`,`AcDivClass`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AccColors`
--

LOCK TABLES `AccColors` WRITE;
/*!40000 ALTER TABLE `AccColors` DISABLE KEYS */;
/*!40000 ALTER TABLE `AccColors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `AccEntries`
--

DROP TABLE IF EXISTS `AccEntries`;
CREATE TABLE `AccEntries` (
  `AEId` int(10) unsigned NOT NULL default '0',
  `AEOperation` tinyint(4) NOT NULL default '0',
  `AETournament` int(10) unsigned NOT NULL default '0',
  `AEWhen` datetime NOT NULL default '0000-00-00 00:00:00',
  `AEFromIp` int(10) unsigned NOT NULL default '0',
  `AERapp` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`AEId`,`AEOperation`,`AETournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AccEntries`
--

LOCK TABLES `AccEntries` WRITE;
/*!40000 ALTER TABLE `AccEntries` DISABLE KEYS */;
/*!40000 ALTER TABLE `AccEntries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `AccOperationType`
--

DROP TABLE IF EXISTS `AccOperationType`;
CREATE TABLE `AccOperationType` (
  `AOTId` smallint(5) unsigned NOT NULL auto_increment,
  `AOTDescr` varchar(32) NOT NULL,
  PRIMARY KEY  (`AOTId`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AccOperationType`
--

LOCK TABLES `AccOperationType` WRITE;
/*!40000 ALTER TABLE `AccOperationType` DISABLE KEYS */;
INSERT INTO `AccOperationType` VALUES (1,'Accreditation'),(2,'ControlMaterial');
/*!40000 ALTER TABLE `AccOperationType` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `AccPrice`
--

DROP TABLE IF EXISTS `AccPrice`;
CREATE TABLE `AccPrice` (
  `APId` int(10) unsigned NOT NULL auto_increment,
  `APTournament` int(10) unsigned NOT NULL default '0',
  `APDivClass` varchar(4) NOT NULL,
  `APPrice` float(5,2) NOT NULL default '0.00',
  PRIMARY KEY  (`APId`),
  UNIQUE KEY `APTournament` (`APTournament`,`APDivClass`)
) ENGINE=MyISAM AUTO_INCREMENT=1268 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AccPrice`
--

LOCK TABLES `AccPrice` WRITE;
/*!40000 ALTER TABLE `AccPrice` DISABLE KEYS */;
/*!40000 ALTER TABLE `AccPrice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `AvailableTarget`
--

DROP TABLE IF EXISTS `AvailableTarget`;
CREATE TABLE `AvailableTarget` (
  `AtTournament` int(10) unsigned NOT NULL,
  `AtTargetNo` varchar(5) NOT NULL,
  PRIMARY KEY  (`AtTournament`,`AtTargetNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `AvailableTarget`
--

LOCK TABLES `AvailableTarget` WRITE;
/*!40000 ALTER TABLE `AvailableTarget` DISABLE KEYS */;
/*!40000 ALTER TABLE `AvailableTarget` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `BackNumber`
--

DROP TABLE IF EXISTS `BackNumber`;
CREATE TABLE `BackNumber` (
  `BnTournament` int(10) unsigned NOT NULL,
  `BnFinal` tinyint(4) NOT NULL,
  `BnHeight` smallint(5) unsigned NOT NULL,
  `BnWidth` smallint(5) unsigned NOT NULL,
  `BnBackground` mediumblob NOT NULL,
  `BnBgX` smallint(6) NOT NULL,
  `BnBgY` smallint(6) NOT NULL,
  `BnBgW` smallint(6) NOT NULL,
  `BnBgH` smallint(6) NOT NULL,
  `BnTargetNo` tinyint(3) unsigned NOT NULL,
  `BnTnoColor` varchar(6) NOT NULL default '000000',
  `BnTnoSize` smallint(6) NOT NULL,
  `BnTnoX` smallint(6) NOT NULL,
  `BnTnoY` smallint(6) NOT NULL,
  `BnTnoW` smallint(6) NOT NULL,
  `BnTnoH` smallint(6) NOT NULL,
  `BnAthlete` tinyint(3) unsigned NOT NULL,
  `BnAthColor` varchar(6) NOT NULL default '000000',
  `BnAthSize` smallint(6) NOT NULL,
  `BnAthX` smallint(6) NOT NULL,
  `BnAthY` smallint(6) NOT NULL,
  `BnAthW` smallint(6) NOT NULL,
  `BnAthH` smallint(6) NOT NULL,
  `BnCountry` tinyint(3) unsigned NOT NULL,
  `BnCoColor` varchar(6) NOT NULL default '000000',
  `BnCoSize` smallint(6) NOT NULL,
  `BnCoX` smallint(6) NOT NULL,
  `BnCoY` smallint(6) NOT NULL,
  `BnCoW` smallint(6) NOT NULL,
  `BnCoH` smallint(6) NOT NULL,
  `BnOffsetX` smallint(6) NOT NULL,
  `BnOffsetY` smallint(6) NOT NULL,
  PRIMARY KEY  (`BnTournament`,`BnFinal`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `BackNumber`
--

LOCK TABLES `BackNumber` WRITE;
/*!40000 ALTER TABLE `BackNumber` DISABLE KEYS */;
/*!40000 ALTER TABLE `BackNumber` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Broadcast`
--

DROP TABLE IF EXISTS `Broadcast`;
CREATE TABLE `Broadcast` (
  `BrTournament` int(10) unsigned NOT NULL,
  `BrEnabled` int(10) unsigned NOT NULL default '0',
  `BrSottoPancia0` tinytext NOT NULL,
  `BrSottoPancia1` tinytext NOT NULL,
  `BrSottoPancia2` tinytext NOT NULL,
  `BrSottoPancia3` tinytext NOT NULL,
  `BrEvent` varchar(4) NOT NULL,
  `BrMatchNo` tinyint(3) unsigned NOT NULL,
  `BrCommentL` tinytext NOT NULL,
  `BrCommentR` tinytext NOT NULL,
  `BrTimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`BrTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Broadcast`
--

LOCK TABLES `Broadcast` WRITE;
/*!40000 ALTER TABLE `Broadcast` DISABLE KEYS */;
/*!40000 ALTER TABLE `Broadcast` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CasGrid`
--

DROP TABLE IF EXISTS `CasGrid`;
CREATE TABLE `CasGrid` (
  `CGPhase` tinyint(3) unsigned NOT NULL COMMENT '1 o 2 a seconda della fase della gara',
  `CGRound` tinyint(3) unsigned NOT NULL,
  `CGMatchNo1` tinyint(3) unsigned NOT NULL,
  `CGMatchNo2` tinyint(3) unsigned NOT NULL,
  `CGGroup` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`CGPhase`,`CGRound`,`CGMatchNo1`,`CGMatchNo2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `CasGrid`
--

LOCK TABLES `CasGrid` WRITE;
/*!40000 ALTER TABLE `CasGrid` DISABLE KEYS */;
INSERT INTO `CasGrid` VALUES (1,1,1,8,1),(1,1,2,7,2),(1,1,3,6,3),(1,1,4,5,4),(1,1,9,13,4),(1,1,10,14,3),(1,1,11,15,2),(1,1,12,16,1),(1,2,1,12,1),(1,2,2,11,2),(1,2,3,10,3),(1,2,4,9,4),(1,2,5,13,4),(1,2,6,14,3),(1,2,7,15,2),(1,2,8,16,1),(1,3,1,16,1),(1,3,2,15,2),(1,3,3,14,3),(1,3,4,13,4),(1,3,5,9,4),(1,3,6,10,3),(1,3,7,11,2),(1,3,8,12,1),(2,1,1,8,1),(2,1,2,7,2),(2,1,3,6,3),(2,1,4,5,4),(2,1,9,13,4),(2,1,10,14,3),(2,1,11,15,2),(2,1,12,16,1),(2,2,1,12,1),(2,2,2,11,2),(2,2,3,10,3),(2,2,4,9,4),(2,2,5,13,4),(2,2,6,14,3),(2,2,7,15,2),(2,2,8,16,1),(2,3,1,16,1),(2,3,2,15,2),(2,3,3,14,3),(2,3,4,13,4),(2,3,5,9,4),(2,3,6,10,3),(2,3,7,11,2),(2,3,8,12,1);
/*!40000 ALTER TABLE `CasGrid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CasGroupMatch`
--

DROP TABLE IF EXISTS `CasGroupMatch`;
CREATE TABLE `CasGroupMatch` (
  `CaGMGroup` tinyint(3) unsigned NOT NULL,
  `CaGRank` tinyint(4) unsigned NOT NULL,
  `CaGMMatchNo` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`CaGMGroup`,`CaGMMatchNo`,`CaGRank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `CasGroupMatch`
--

LOCK TABLES `CasGroupMatch` WRITE;
/*!40000 ALTER TABLE `CasGroupMatch` DISABLE KEYS */;
INSERT INTO `CasGroupMatch` VALUES (1,1,1),(1,2,2),(1,3,3),(1,4,4),(2,4,5),(2,3,6),(2,1,7),(2,2,8),(3,4,9),(3,3,10),(3,2,11),(3,1,12),(4,4,13),(4,3,14),(4,1,15),(4,2,16);
/*!40000 ALTER TABLE `CasGroupMatch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CasRankMatch`
--

DROP TABLE IF EXISTS `CasRankMatch`;
CREATE TABLE `CasRankMatch` (
  `CRMEventPhase` tinyint(4) NOT NULL,
  `CRMRank` tinyint(4) NOT NULL,
  `CRMMatchNo` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`CRMEventPhase`,`CRMRank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `CasRankMatch`
--

LOCK TABLES `CasRankMatch` WRITE;
/*!40000 ALTER TABLE `CasRankMatch` DISABLE KEYS */;
INSERT INTO `CasRankMatch` VALUES (16,1,1),(16,2,2),(16,3,3),(16,4,4),(16,5,5),(16,6,6),(16,7,7),(16,8,8),(16,9,9),(16,10,10),(16,11,11),(16,12,12),(16,13,13),(16,14,14),(16,15,15),(16,16,16);
/*!40000 ALTER TABLE `CasRankMatch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CasScore`
--

DROP TABLE IF EXISTS `CasScore`;
CREATE TABLE `CasScore` (
  `CaSTournament` int(10) unsigned NOT NULL default '0',
  `CaSPhase` tinyint(3) unsigned NOT NULL default '0' COMMENT '1=fase 1;2=fase2',
  `CaSRound` tinyint(3) unsigned NOT NULL,
  `CaSMatchNo` tinyint(3) unsigned NOT NULL,
  `CaSEventCode` varchar(4) NOT NULL,
  `CaSTarget` varchar(2) NOT NULL,
  `CaSScore` smallint(6) NOT NULL default '0',
  `CaSTie` tinyint(1) NOT NULL default '0',
  `CaSArrowString` varchar(24) NOT NULL,
  `CaSArrowPosition` varchar(240) NOT NULL,
  `CaSTiebreak` varchar(9) NOT NULL,
  `CaSTiePosition` varchar(90) NOT NULL,
  `CaSPoints` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`CaSTournament`,`CaSPhase`,`CaSMatchNo`,`CaSEventCode`,`CaSRound`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `CasScore`
--

LOCK TABLES `CasScore` WRITE;
/*!40000 ALTER TABLE `CasScore` DISABLE KEYS */;
/*!40000 ALTER TABLE `CasScore` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CasTeam`
--

DROP TABLE IF EXISTS `CasTeam`;
CREATE TABLE `CasTeam` (
  `CaTournament` int(10) unsigned NOT NULL default '0',
  `CaPhase` tinyint(3) unsigned NOT NULL default '0' COMMENT '1=fase 1;2=fase2',
  `CaMatchNo` tinyint(3) unsigned NOT NULL default '0',
  `CaEventCode` varchar(4) NOT NULL,
  `CaTeam` int(11) unsigned NOT NULL default '0',
  `CaSubTeam` varchar(1) NOT NULL,
  `CaRank` tinyint(4) unsigned NOT NULL,
  `CaTiebreak` varchar(9) NOT NULL,
  PRIMARY KEY  (`CaTournament`,`CaPhase`,`CaMatchNo`,`CaEventCode`,`CaTeam`,`CaSubTeam`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `CasTeam`
--

LOCK TABLES `CasTeam` WRITE;
/*!40000 ALTER TABLE `CasTeam` DISABLE KEYS */;
/*!40000 ALTER TABLE `CasTeam` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Classes`
--

DROP TABLE IF EXISTS `Classes`;
CREATE TABLE `Classes` (
  `ClId` varchar(2) NOT NULL,
  `ClTournament` int(10) unsigned NOT NULL default '0',
  `ClDescription` varchar(32) NOT NULL,
  `ClViewOrder` tinyint(3) unsigned NOT NULL default '0',
  `ClAgeFrom` tinyint(4) NOT NULL,
  `ClAgeTo` tinyint(4) NOT NULL,
  `ClValidClass` varchar(16) NOT NULL default '0',
  `ClSex` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ClId`,`ClTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Classes`
--

LOCK TABLES `Classes` WRITE;
/*!40000 ALTER TABLE `Classes` DISABLE KEYS */;
/*!40000 ALTER TABLE `Classes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ClubTeam`
--

DROP TABLE IF EXISTS `ClubTeam`;
CREATE TABLE `ClubTeam` (
  `CTTournament` int(10) unsigned NOT NULL default '0',
  `CTPhase` tinyint(3) unsigned NOT NULL default '0' COMMENT '1=fase 1;2=fase2',
  `CTMatchNo` tinyint(3) unsigned NOT NULL default '0',
  `CTEventCode` varchar(4) NOT NULL,
  `CTPrimary` tinyint(3) unsigned NOT NULL,
  `CTTeam` int(11) unsigned NOT NULL default '0',
  `CTSubTeam` varchar(1) NOT NULL,
  `CTBonus` tinyint(3) unsigned NOT NULL default '0',
  `CTRank` tinyint(4) unsigned NOT NULL,
  `CTTiebreak` varchar(9) NOT NULL default '',
  PRIMARY KEY  (`CTTournament`,`CTPhase`,`CTMatchNo`,`CTEventCode`,`CTPrimary`,`CTTeam`,`CTSubTeam`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ClubTeam`
--

LOCK TABLES `ClubTeam` WRITE;
/*!40000 ALTER TABLE `ClubTeam` DISABLE KEYS */;
/*!40000 ALTER TABLE `ClubTeam` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ClubTeamGrid`
--

DROP TABLE IF EXISTS `ClubTeamGrid`;
CREATE TABLE `ClubTeamGrid` (
  `CTGPhase` tinyint(3) unsigned NOT NULL COMMENT '1 o 2 a seconda della fase della gara',
  `CTGRound` tinyint(3) unsigned NOT NULL,
  `CTGMatchNo1` tinyint(3) unsigned NOT NULL,
  `CTGMatchNo2` tinyint(3) unsigned NOT NULL,
  `CTGGroup` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`CTGPhase`,`CTGRound`,`CTGMatchNo1`,`CTGMatchNo2`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ClubTeamGrid`
--

LOCK TABLES `ClubTeamGrid` WRITE;
/*!40000 ALTER TABLE `ClubTeamGrid` DISABLE KEYS */;
INSERT INTO `ClubTeamGrid` VALUES (1,1,1,8,1),(1,1,2,7,2),(1,1,3,6,3),(1,1,4,5,4),(1,1,9,16,1),(1,1,10,15,2),(1,1,11,14,3),(1,1,12,13,4),(1,2,1,9,1),(1,2,2,10,2),(1,2,3,11,3),(1,2,4,12,4),(1,2,5,13,4),(1,2,6,14,3),(1,2,7,15,2),(1,2,8,16,1),(1,3,1,16,1),(1,3,2,15,2),(1,3,3,14,3),(1,3,4,13,4),(1,3,5,12,4),(1,3,6,11,3),(1,3,7,10,2),(1,3,8,9,1),(2,1,1,4,1),(2,1,2,3,1),(2,1,5,8,2),(2,1,6,7,2),(2,1,9,12,3),(2,1,10,11,3),(2,1,13,16,4),(2,1,14,15,4),(3,1,1,2,1),(3,1,3,4,1),(3,1,5,6,2),(3,1,7,8,2),(3,1,9,10,3),(3,1,11,12,3),(3,1,13,14,4),(3,1,15,16,4);
/*!40000 ALTER TABLE `ClubTeamGrid` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ClubTeamGroupMatch`
--

DROP TABLE IF EXISTS `ClubTeamGroupMatch`;
CREATE TABLE `ClubTeamGroupMatch` (
  `CTGMGroup` tinyint(3) unsigned NOT NULL,
  `CTGMMatchNo` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`CTGMGroup`,`CTGMMatchNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ClubTeamGroupMatch`
--

LOCK TABLES `ClubTeamGroupMatch` WRITE;
/*!40000 ALTER TABLE `ClubTeamGroupMatch` DISABLE KEYS */;
INSERT INTO `ClubTeamGroupMatch` VALUES (1,1),(1,8),(1,9),(1,16),(2,2),(2,7),(2,10),(2,15),(3,3),(3,6),(3,11),(3,14),(4,4),(4,5),(4,12),(4,13);
/*!40000 ALTER TABLE `ClubTeamGroupMatch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ClubTeamRankMatch`
--

DROP TABLE IF EXISTS `ClubTeamRankMatch`;
CREATE TABLE `ClubTeamRankMatch` (
  `CTRMEventPhase` tinyint(4) NOT NULL,
  `CTRMRank` tinyint(4) NOT NULL,
  `CTRMMatchNo` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`CTRMEventPhase`,`CTRMRank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ClubTeamRankMatch`
--

LOCK TABLES `ClubTeamRankMatch` WRITE;
/*!40000 ALTER TABLE `ClubTeamRankMatch` DISABLE KEYS */;
INSERT INTO `ClubTeamRankMatch` VALUES (8,1,1),(8,2,2),(8,3,7),(8,4,8),(8,5,9),(8,6,10),(8,7,15),(8,8,16),(16,1,1),(16,2,2),(16,3,3),(16,4,4),(16,5,5),(16,6,6),(16,7,7),(16,8,8),(16,9,9),(16,10,10),(16,11,11),(16,12,12),(16,13,13),(16,14,14),(16,15,15),(16,16,16);
/*!40000 ALTER TABLE `ClubTeamRankMatch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ClubTeamScore`
--

DROP TABLE IF EXISTS `ClubTeamScore`;
CREATE TABLE `ClubTeamScore` (
  `CTSTournament` int(10) unsigned NOT NULL default '0',
  `CTSPhase` tinyint(3) unsigned NOT NULL default '0' COMMENT '1=fase 1;2=fase2',
  `CTSRound` tinyint(3) unsigned NOT NULL,
  `CTSMatchNo` tinyint(3) unsigned NOT NULL,
  `CTSEventCode` varchar(4) NOT NULL,
  `CTSPrimary` tinyint(3) unsigned NOT NULL,
  `CTSTarget` varchar(2) NOT NULL,
  `CTSScore` smallint(6) NOT NULL default '0',
  `CTSTie` tinyint(1) NOT NULL default '0',
  `CTSArrowString` varchar(24) NOT NULL,
  `CTSArrowPosition` varchar(240) NOT NULL,
  `CTSTiebreak` varchar(9) NOT NULL,
  `CTSTiePosition` varchar(90) NOT NULL,
  `CTSPoints` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`CTSTournament`,`CTSPhase`,`CTSMatchNo`,`CTSEventCode`,`CTSRound`,`CTSPrimary`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `ClubTeamScore`
--

LOCK TABLES `ClubTeamScore` WRITE;
/*!40000 ALTER TABLE `ClubTeamScore` DISABLE KEYS */;
/*!40000 ALTER TABLE `ClubTeamScore` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Countries`
--

DROP TABLE IF EXISTS `Countries`;
CREATE TABLE `Countries` (
  `CoId` int(10) unsigned NOT NULL auto_increment,
  `CoTournament` int(10) unsigned NOT NULL default '0',
  `CoCode` varchar(5) NOT NULL,
  `CoName` varchar(30) NOT NULL,
  `CoNameComplete` varchar(80) NOT NULL,
  `CoSubCountry` varchar(5) NOT NULL,
  `CoFlag` mediumblob NOT NULL,
  `CoMail` varchar(30) NOT NULL,
  `CoNoPrint` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`CoId`),
  UNIQUE KEY `CoTournament` (`CoTournament`,`CoCode`)
) ENGINE=MyISAM AUTO_INCREMENT=5869 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Countries`
--

LOCK TABLES `Countries` WRITE;
/*!40000 ALTER TABLE `Countries` DISABLE KEYS */;
/*!40000 ALTER TABLE `Countries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Divisions`
--

DROP TABLE IF EXISTS `Divisions`;
CREATE TABLE `Divisions` (
  `DivId` varchar(2) NOT NULL,
  `DivTournament` int(10) unsigned NOT NULL default '0',
  `DivDescription` varchar(32) NOT NULL,
  `DivViewOrder` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`DivId`,`DivTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Divisions`
--

LOCK TABLES `Divisions` WRITE;
/*!40000 ALTER TABLE `Divisions` DISABLE KEYS */;
/*!40000 ALTER TABLE `Divisions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ElabQualifications`
--

DROP TABLE IF EXISTS `ElabQualifications`;
CREATE TABLE `ElabQualifications` (
  `EqId` int(10) unsigned NOT NULL,
  `EqArrowNo` smallint(5) unsigned NOT NULL,
  `EqDistance` tinyint(4) unsigned NOT NULL,
  `EqScore` int(11) NOT NULL,
  `EqHits` int(11) NOT NULL,
  `EqGold` int(11) NOT NULL,
  `EqXnine` int(11) NOT NULL,
  `EqTimestamp` datetime default NULL,
  PRIMARY KEY  (`EqId`,`EqArrowNo`,`EqDistance`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ElabQualifications`
--

LOCK TABLES `ElabQualifications` WRITE;
/*!40000 ALTER TABLE `ElabQualifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `ElabQualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Eliminations`
--

DROP TABLE IF EXISTS `Eliminations`;
CREATE TABLE `Eliminations` (
  `ElId` int(10) unsigned NOT NULL,
  `ElElimPhase` tinyint(4) NOT NULL default '0',
  `ElEventCode` varchar(4) NOT NULL,
  `ElSession` tinyint(3) unsigned NOT NULL default '0',
  `ElTargetNo` varchar(5) NOT NULL,
  `ElScore` smallint(6) NOT NULL,
  `ElHits` smallint(6) NOT NULL,
  `ElGold` smallint(6) NOT NULL,
  `ElXnine` smallint(6) NOT NULL,
  `ElArrowString` varchar(36) NOT NULL,
  `ElRank` tinyint(3) unsigned NOT NULL,
  `ElStatus` tinyint(3) unsigned NOT NULL,
  `ElDateTime` datetime NOT NULL,
  PRIMARY KEY  (`ElId`,`ElElimPhase`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Eliminations`
--

LOCK TABLES `Eliminations` WRITE;
/*!40000 ALTER TABLE `Eliminations` DISABLE KEYS */;
/*!40000 ALTER TABLE `Eliminations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Entries`
--

DROP TABLE IF EXISTS `Entries`;
CREATE TABLE `Entries` (
  `EnId` int(10) unsigned NOT NULL auto_increment,
  `EnTournament` int(10) unsigned NOT NULL default '0',
  `EnDivision` varchar(2) NOT NULL,
  `EnClass` varchar(2) NOT NULL,
  `EnSubClass` varchar(2) NOT NULL,
  `EnAgeClass` varchar(2) NOT NULL,
  `EnCountry` int(10) unsigned NOT NULL default '0',
  `EnCtrlCode` varchar(16) NOT NULL,
  `EnDob` date NOT NULL,
  `EnCode` varchar(9) NOT NULL,
  `EnName` varchar(30) NOT NULL,
  `EnFirstName` varchar(30) NOT NULL,
  `EnPhoto` varchar(40) NOT NULL,
  `EnAthlete` tinyint(1) unsigned NOT NULL default '1',
  `EnSex` tinyint(1) unsigned NOT NULL default '0',
  `EnWChair` tinyint(1) unsigned NOT NULL default '0',
  `EnSitting` tinyint(1) unsigned NOT NULL default '0',
  `EnIndClEvent` tinyint(1) unsigned NOT NULL default '1',
  `EnTeamClEvent` tinyint(1) unsigned NOT NULL default '1',
  `EnIndFEvent` tinyint(1) unsigned NOT NULL default '1',
  `EnTeamFEvent` tinyint(1) unsigned NOT NULL default '1',
  `EnPays` tinyint(1) unsigned NOT NULL default '1',
  `EnStatus` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`EnId`),
  KEY `EnDivision` (`EnDivision`),
  KEY `EnClass` (`EnClass`),
  KEY `CalcRank` (`EnTournament`,`EnAthlete`,`EnStatus`)
) ENGINE=MyISAM AUTO_INCREMENT=21521 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Entries`
--

LOCK TABLES `Entries` WRITE;
/*!40000 ALTER TABLE `Entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `Entries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `EventClass`
--

DROP TABLE IF EXISTS `EventClass`;
CREATE TABLE `EventClass` (
  `EcCode` varchar(4) NOT NULL,
  `EcTeamEvent` tinyint(1) NOT NULL default '0',
  `EcTournament` int(11) NOT NULL,
  `EcClass` varchar(2) NOT NULL,
  `EcDivision` varchar(2) NOT NULL,
  `EcNumber` tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (`EcCode`,`EcTeamEvent`,`EcTournament`,`EcClass`,`EcDivision`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `EventClass`
--

LOCK TABLES `EventClass` WRITE;
/*!40000 ALTER TABLE `EventClass` DISABLE KEYS */;
/*!40000 ALTER TABLE `EventClass` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Events`
--

DROP TABLE IF EXISTS `Events`;
CREATE TABLE `Events` (
  `EvCode` varchar(4) NOT NULL,
  `EvTeamEvent` tinyint(1) NOT NULL,
  `EvTournament` int(11) NOT NULL,
  `EvEventName` varchar(64) NOT NULL,
  `EvProgr` int(11) NOT NULL,
  `EvShootOff` tinyint(3) unsigned NOT NULL default '0',
  `EvE1ShootOff` tinyint(3) unsigned NOT NULL default '0',
  `EvE2ShootOff` tinyint(3) unsigned NOT NULL default '0',
  `EvSession` int(11) NOT NULL,
  `EvPrint` tinyint(1) NOT NULL,
  `EvQualPrintHead` varchar(64) NOT NULL,
  `EvQualLastUpdate` datetime default NULL,
  `EvFinalFirstPhase` tinyint(4) NOT NULL,
  `EvFinalPrintHead` varchar(64) NOT NULL,
  `EvFinalLastUpdate` datetime default NULL,
  `EvFinalTargetType` tinyint(4) NOT NULL,
  `EvFinalAthTarget` tinyint(3) unsigned NOT NULL default '0',
  `EvElim1` tinyint(3) unsigned NOT NULL default '0',
  `EvElim2` tinyint(3) unsigned NOT NULL default '0',
  `EvPartialTeam` tinyint(1) unsigned NOT NULL default '0',
  `EvMultiTeam` tinyint(1) unsigned NOT NULL default '0',
  `EvMixedTeam` tinyint(3) unsigned NOT NULL default '0',
  `EvRunning` tinyint(3) unsigned NOT NULL default '0',
  `EvMatchMode` tinyint(4) NOT NULL default '0',
  `EvMatchArrowsNo` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`EvCode`,`EvTeamEvent`,`EvTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Events`
--

LOCK TABLES `Events` WRITE;
/*!40000 ALTER TABLE `Events` DISABLE KEYS */;
/*!40000 ALTER TABLE `Events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FinGroups`
--

DROP TABLE IF EXISTS `FinGroups`;
CREATE TABLE `FinGroups` (
  `FGId` int(10) unsigned NOT NULL auto_increment,
  `FGTournament` int(10) unsigned NOT NULL default '0',
  `FGDescr` varchar(24) NOT NULL,
  PRIMARY KEY  (`FGId`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `FinGroups`
--

LOCK TABLES `FinGroups` WRITE;
/*!40000 ALTER TABLE `FinGroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `FinGroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FinSchedule`
--

DROP TABLE IF EXISTS `FinSchedule`;
CREATE TABLE `FinSchedule` (
  `FSEvent` varchar(4) NOT NULL,
  `FSTeamEvent` tinyint(1) unsigned NOT NULL default '0',
  `FSMatchNo` tinyint(4) unsigned NOT NULL,
  `FSTournament` int(10) unsigned NOT NULL,
  `FSTarget` varchar(3) NOT NULL,
  `FSGroup` int(10) unsigned NOT NULL default '0',
  `FSScheduledDate` date NOT NULL,
  `FSScheduledTime` time default NULL,
  PRIMARY KEY  (`FSEvent`,`FSTeamEvent`,`FSMatchNo`,`FSTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `FinSchedule`
--

LOCK TABLES `FinSchedule` WRITE;
/*!40000 ALTER TABLE `FinSchedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `FinSchedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FinalReportA`
--

DROP TABLE IF EXISTS `FinalReportA`;
CREATE TABLE `FinalReportA` (
  `FraQuestion` varchar(5) NOT NULL,
  `FraTournament` int(10) unsigned NOT NULL,
  `FraAnswer` text NOT NULL,
  PRIMARY KEY  (`FraQuestion`,`FraTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `FinalReportA`
--

LOCK TABLES `FinalReportA` WRITE;
/*!40000 ALTER TABLE `FinalReportA` DISABLE KEYS */;
/*!40000 ALTER TABLE `FinalReportA` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FinalReportQ`
--

DROP TABLE IF EXISTS `FinalReportQ`;
CREATE TABLE `FinalReportQ` (
  `FrqId` varchar(5) NOT NULL,
  `FrqStatus` tinyint(4) NOT NULL default '0',
  `FrqQuestion` tinytext NOT NULL,
  `FrqTip` text NOT NULL,
  `FrqType` tinyint(4) NOT NULL,
  `FrqOptions` varchar(200) NOT NULL,
  PRIMARY KEY  (`FrqId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `FinalReportQ`
--

LOCK TABLES `FinalReportQ` WRITE;
/*!40000 ALTER TABLE `FinalReportQ` DISABLE KEYS */;
INSERT INTO `FinalReportQ` VALUES ('A',15,'Definizione Competizione','',-1,''),('a01',15,'Conforme al calendario','',2,''),('a02',15,'Tutte le classi e divisioni ammesse','',2,''),('a03',15,'in caso contrario, specificare','',1,'70|2'),('a04',3,'Direttore dei tiri','',3,'non iscritto all\'albo|iscritto all\'albo|arbitro|arbitro e GdG'),('a05',15,'Giuria d\'Appello','Pubblicata ad inizio gara; solo per gare nazionali ed internazionali',2,''),('a06',15,'Field Manager','Responsabile dell\'organizzazione appositamente nominato per la gestione del campo',2,''),('a07',15,'Calendario','',3,'Internazionale|Nazionale|Interregionale|Giovanile|Sperimentale'),('a08',15,'Squadre Nazionali straniere','Solo rappresentative ufficiali; non applicabile solo per eventi federali',3,'N.A.|No|Si'),('a09',15,'In caso affermativo, specificare','',1,'70|2'),('a10',3,'Segnalazione eventuali Record','',1,'70|10'),('a11',15,'Reclami','',1,'70|7'),('a12',15,'Programma della gara pervenuto alla Giuria di Gara','',3,'No|Pubblicato|Si'),('a13',15,'Tassa ridotta per le classi giovanili','50% o differente se stabilito da apposito regolamento (es: Campionati Italiani)',3,'Come da Regolamento|Non Applicabile|No|Gratuita'),('a14',0,'Numero Allegati','',0,'5'),('E',15,'Disposizione e attrezzatura del campo ','',-1,''),('e01',15,'Distanze in tolleranza','Distanze tra linea di tiro e bersagli',2,''),('e02',3,'Separazione interasse conforme al regolamento','',2,''),('e03',3,'Linea di tiro','Temporanea = Nastro Fissa = autobloccanti o equivalente per indoor',3,'Assente|Temporanea|Fissa'),('e04',3,'Numeri sulla linea di Tiro ','tra 1 e 2 metri',2,''),('e05',3,'Linea dei tre metri','',3,'Presente|Assente'),('e06',3,'Linea Stampa/Media','',2,''),('e08',3,'Linea di attesa conforme al regolamento','',2,''),('e09',3,'Corridoi ','Tra i paglioni ove previsto dal regolamento',3,'Presente|Assente|Non Applicabile'),('e10',7,'Battifreccia','',3,'Usurati|Nuovi'),('e11',7,'Materiale Battifreccia','',3,'Sintetico|Paglia'),('e12',3,'Supporti battifreccia','cavalletti',3,'Improvvisati|Triangolari|Rettangolari'),('e13',7,'Assicurazione battifreccia con tiranti','Per indoor = tirante tra paglione e cavalletto',3,'Non Applicabile|No|Si'),('e14',7,'Angolazione Battifreccia conforme al regolamento','per hf intendersi perpendicolarità del bersaglio rispetto alla posizione di tiro',2,''),('e15',7,'Disposizione visuali conforme','',2,''),('e16',1,'Bandiere segnavento','',3,'Assenti|Presenti non ben visibili|Presenti ben visibili'),('e17',3,'Numeratori dei battifreccia','numeri dei paglioni',3,'Assenti|Presenti non conformi|Presenti conformi'),('e18',1,'Maniche a vento','',3,'Non Applicabile|Assente|Si 1|Si 2 o più'),('e19',3,'Impianto semaforico ','Per automatico si intende la temporizzazione e la sincronizzazione delle luci dopo la chiamata tranne che per un eventuale termine anticipato\r\nNon a norma di sicurezza=deferimento automatico',3,'Assenti|Non a norma di sicurezza|Manuale|Automatico'),('e20',3,'Sistemi visivi ausiliari','Bandierine ',2,''),('e21',3,'Indicatori di sequenza ','(AB/CD) Non necessari per turno unico',3,'Non Necessari|Assenti|Manuale|Automatico'),('e22',3,'Orologi contasecondi','',2,''),('e23',3,'Indicatori acustici','Automatico se sincronizzato automaticamente con l\'impianto semforico',3,'Manuale|Automatico'),('e24',3,'Indicatori individuali di punteggio per la fase di qualifica','flip board o altri indicatori di punteggio',2,''),('e25',15,'Indicatori di punteggio per le fasi finali','Manuali ed automatici= utilizzati i manuali per le eliminatorie e elettronici solo per le finali a medaglia',3,'Non applicabile|Assenti|Manuali|Manuali ed Automatici|Automatici'),('e26',3,'Sedie e ombrelloni per gli arbitri','Nell\'indoor solo sedie',2,''),('e27',3,'Postazione direttore dei tiri rialzata','',2,''),('e28',1,'Blind per le finali','Protezione per gli arbitri in prossimità del bersaglio',2,'Non Applicabile|Si|No'),('e29',1,'Campo di tiri di allenamento','',3,'Non necessario|Assente|Utilizzate parti del campo di gara|Campo separato con orientamento differente|Campo separato con stesso orientamento '),('e30',15,'Campo per la finale','Campo per le finali singole',3,'Non necessario|Utilizzata parte del campo di gara|Campo apposito'),('e31',15,'Spazio per il pubblico','Per HF e 3D da intendersi solo per le fasi finali',3,'No|Spazio libero|Sedie|Tribune della struttura|Tribune appositamente realizzate'),('e32',12,'Campo tiri di prova','',4,'No|Si|Distante dal punto di raduno|In prossimità del punto di raduno|Sufficiente per tutti gli arcieri|Necessità di turnazione'),('e33',12,'Picchetto dello stop','',2,''),('e34',12,'Percorso alternativo','per raggiungere le piazzole senza attraversare il percorso di gara',2,''),('e35',12,'Distanza campo base / piazzola più lontana','Tempo di percorrenza',3,'Oltre i 15 minuti|Entro i 15 minuti'),('e36',12,'Interferenze','',4,'Al volo delle frecce|Alla visione del bersaglio|All\'arco|No'),('e37',4,'Distanze conosciute','Rispetto delle distanze e del numero dei bersagli per tipo indicati nel regolamento',2,''),('e38',12,'Distanze sconosciute','',3,'Inferiori alla media|nella media|Superiori alla media'),('e39',12,'Visibilità dei picchetti di tiro','dallo stop',2,''),('e40',12,'Pendenze medie','indicativo',3,'zero|Meno di 15°|Più di 15°'),('F',15,'Sicurezza','',-1,''),('f01',15,'Dietro la linea delle visuali','',3,'Non Presidiata|Presidiata|Assoluta'),('f02',15,'Accesso al campo','libero=nessun controllo; regolato=con pass nel rispetto del regolamento',3,'Libero|Regolato'),('f03',12,'Problemi generali di sicurezza del percorso','',4,'Tiri incrociati|Direzioni di tiro verso altre piazzole|Direzione di tiro verso il percorso di trasferimento|No'),('G',15,'Organizzazione','',-1,''),('g01',15,'Gestione della gara','',3,'Non adeguata|Continui e necessari interventi gdg|Con sporadici interventi gdg|Autonoma'),('g02',15,'Assegnazione piazzole','',3,'Assegnazione manuale|In ordine di rank|Sorteggio manuale|Sorteggio automatico'),('g03',15,'Abbigliamento  Personale organizzazione','',3,'Non riconoscibile|Divisa di società|Pettorine|Divisa evento '),('g04',7,'Visuale di riserva','',3,'Insufficienti|Appena Sufficienti|Abbondanti'),('g05',15,'Battifreccia o sagome di riserva','',2,''),('g06',3,'Cavalletti di riserva','',2,''),('g07',15,'Numeri di gara','Pettorali\r\nPersonalizzati (con nome dell\'atleta)',3,'Assenti|Della Società|Dell\'evento|Dell\'evento personalizzati'),('g08',15,'Ristoro','Alimenti',3,'Assente|Presente a pagamento|Gratuito'),('g09',15,'Bevande sul campo di gara','',3,'Assenti|Presenti a pagamento|Presenti gratuite'),('g10',3,'Assistenza ai disabili','',3,'Non necessaria|No|Si'),('g11',3,'Periodicità di esposizione classifiche','',3,'Mai|A fine gara|A fine distanza|Parziali di distanza|Tempo reale (ogni volèe)'),('g12',15,'Meccanismi di esposizione classifiche','',3,'Assente|Cartaceo|Monitor|Maxischermo|Monitor e Maxischermo'),('g13',3,'Raccolta punteggi parziali','Strumento utilizzato',3,'Assente|Cartaceo|Tastierini elettronici'),('g14',15,'Speaker','',3,'No|Durante la competizione|Durante le Finali|Durante qualifica e finali'),('g15',15,'Musica','',3,'No|Durante le pause|Dal vivo'),('g16',15,'Impianto di amplificazione','Per musica, comunicazioni di servizio, speaker',2,''),('g17',15,'Comunicazione sul campo','',3,'A voce|Telefoni dell\'organizzazione|Radio dell\'organizzazione'),('g18',12,'Raccolta punteggi parziali','',2,'Assente|Via Radio'),('g19',12,'Periodicità esposizione classifiche','',3,'Assente|Al termine della gara|Parziale una volta|Parziale più volte'),('g20',15,'Rinfresco finale','',2,''),('g21',15,'Connessione ad internet','per pubblico o partecipanti',3,'No|Si Gratuita|Si a pagamento'),('H',15,'Luogo della gara','',-1,''),('h01',3,'Servizi igienici','',4,'No|Comuni|Divisi per sesso|Lontani dal campo di gara|Facilmente Accessibili|Anche per disabili'),('h02',3,'Barriere architettoniche','',3,'Presenti|Assenti'),('h03',15,'Indicazioni stradali','Non mappe o indicazioni online ma cartellonistica',3,'No|Insufficiente|Sufficiente'),('h04',15,'Recettivita\' alberghiera','',4,'No|Gestita dall\'organizzazione|Oltre i 10 minuti dal campo di gara|Entro i 10 minuti dal campo di gara'),('h05',15,'Trasporto da e per il campo di gara','',3,'Non applicabile|No|Gestiti ma insufficienti|Gestiti e organizzati'),('h06',3,'Sedili','Insufficiente se < al 50% dei partecipanti',3,'Non applicabile|Insufficiente|Sufficiente per gli atleti|Sufficienti per atleti e accompagnatori'),('h07',13,'Ombrelloni e/o ombreggiatura','Insufficiente se < al 50% dei partecipanti',3,'Non applicabile|Insufficiente|Sufficiente per gli atleti|Sufficienti per atleti e accompagnatori'),('h08',15,'Sacchetti per la spazzatura','',3,'Sufficiente|Insufficiente'),('h09',1,'Orientamento campo','',3,'Non Applicabile|Sud|Est o Ovest|Entro 15 gradi|Nord'),('h10',1,'Fondo del campo','',3,'Non Applicabile|Terriccio| Sintetico|Erboso sconnesso|Erboso raso'),('h11',2,'Temperatura sulla linea di tiro','',3,'Meno di 18°|18° o più'),('h12',2,'Illuminazione artificiale ','',4,'Diffusa|Diretta|Uniforme|Non uniforme|Sufficiente|Non Sufficiente'),('h13',2,'Illuminazione naturale ','',4,'No|Filtrante|Omogenea'),('h14',12,'Servizi igienici','',3,'No|Solo al punto di ritrovo|Servizi lungo il percorso'),('h15',12,'Indicazioni di percorso','',4,'No|Scarsamente segnalato|Ben segnalato e visibile|Mappa del percorso distribuita'),('h16',12,'Pulizia del percorso','da intendersi del fondo del sentiero tra le piazzole',2,''),('I',15,'Assistenza Sanitaria','',-1,''),('i01',15,'Ospedale Entro i 10 Km','',2,''),('i02',15,'Medico Presente','',2,''),('i03',15,'Ambulanza','',2,''),('i04',15,'Stanza Attrezzata per le Emergenze','',2,''),('i05',15,'Stanza attrezzata per antidoping','',3,'Non necessaria|No|Si comune|Si separata per sesso'),('J',15,'Premiazioni','',-1,''),('j01',15,'Podio','',3,'Assente|Realizzato con paglioni o estemporaneamente|Struttura apposita'),('j02',15,'Bandiere','Nazionale, Fitarco, del comitato Regionale, della società',3,'No|Appoggiate a reti o siepi|Appese|Issate su pali'),('j03',15,'Inno Nazionale','',3,'Non Applicabile|No|Si'),('j04',15,'Tipo di Premi (Scelta multipla)','',4,'Medaglie/Coppe|Diplomi|Premi in Denaro|Premi in Natura'),('j05',15,'Premiazione conforme al Regolamento','Numero di premiati e tipologia dei premi',2,''),('j06',15,'Cerimonia di premiazione conforme al Regolamento','Chiamata nell\'ordine previsto, con posizione, società, punteggio e nome',2,''),('j07',15,'Omaggio di partecipazione','meglio conosciuto come \"premio di partecipazione\"',2,''),('j08',15,'Premi a sorteggio','',2,''),('K',15,'Promozione','',-1,''),('k01',15,'Conferenza Stampa','Nei giorni precedenti la competizione',2,''),('k02',15,'Presenza sulla carta stampata','Prima della competizione',4,'No|Stampa Locale|Stampa Nazionale|Stampa Estera'),('k03',15,'Testate','',1,'70|5'),('k04',15,'Presenza di televisioni','di emittenti televisive che trasmettono la competizione',4,'Assente|Locali|Web|Nazionali|Diretta'),('k05',15,'Emittenti','',1,'70|5'),('k06',15,'Pubblicazione risultati su internet','',3,'Nessuna|Termine gara|Rilevamenti parziali|Tempo reale (ogni volèe)'),('k07',15,'Indirizzo internet','indicare indirizzo internet sul quale sono stati pubblicati i risultati, con esclusione di quello fitarco',0,''),('Z',15,'Note','',-1,''),('z01',15,'Valutazione della Gara ed eventuali annotazioni ','',1,'70|7'),('e41',4,'Supporti Battifreccia','',4,'Pali|Cavalletti');
/*!40000 ALTER TABLE `FinalReportQ` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Finals`
--

DROP TABLE IF EXISTS `Finals`;
CREATE TABLE `Finals` (
  `FinEvent` varchar(4) NOT NULL,
  `FinMatchNo` tinyint(4) unsigned NOT NULL default '0',
  `FinTournament` int(10) unsigned NOT NULL default '0',
  `FinRank` tinyint(4) unsigned NOT NULL default '0',
  `FinAthlete` int(10) unsigned NOT NULL default '0',
  `FinScore` smallint(6) NOT NULL default '0',
  `FinSetScore` tinyint(4) NOT NULL default '0',
  `FinSetPoints` varchar(15) default NULL,
  `FinTie` tinyint(1) NOT NULL default '0',
  `FinArrowstring` varchar(18) default NULL,
  `FinTiebreak` varchar(6) default NULL,
  `FinArrowPosition` varchar(180) default NULL,
  `FinTiePosition` varchar(60) default NULL,
  `FinWinLose` tinyint(1) unsigned NOT NULL default '0',
  `FinFinalRank` tinyint(4) unsigned NOT NULL default '0',
  `FinDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `FinSyncro` datetime NOT NULL,
  `FinLive` tinyint(4) NOT NULL default '0',
  `FinVxF` tinyint(4) NOT NULL default '0',
  `FinTarget` varchar(5) NOT NULL,
  PRIMARY KEY  (`FinEvent`,`FinMatchNo`,`FinTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Finals`
--

LOCK TABLES `Finals` WRITE;
/*!40000 ALTER TABLE `Finals` DISABLE KEYS */;
/*!40000 ALTER TABLE `Finals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Grids`
--

DROP TABLE IF EXISTS `Grids`;
CREATE TABLE `Grids` (
  `GrMatchNo` tinyint(3) unsigned NOT NULL default '0',
  `GrPosition` tinyint(4) NOT NULL default '0',
  `GrPhase` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`GrMatchNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Grids`
--

LOCK TABLES `Grids` WRITE;
/*!40000 ALTER TABLE `Grids` DISABLE KEYS */;
INSERT INTO `Grids` VALUES (32,1,16),(33,32,16),(34,17,16),(35,16,16),(36,9,16),(37,24,16),(38,25,16),(39,8,16),(40,5,16),(41,28,16),(42,21,16),(43,12,16),(44,13,16),(45,20,16),(46,29,16),(47,4,16),(48,3,16),(49,30,16),(50,19,16),(51,14,16),(52,11,16),(53,22,16),(54,27,16),(55,6,16),(56,7,16),(57,26,16),(58,23,16),(59,10,16),(60,15,16),(61,18,16),(62,31,16),(63,2,16),(16,1,8),(17,16,8),(18,9,8),(19,8,8),(20,5,8),(21,12,8),(22,13,8),(23,4,8),(24,3,8),(25,14,8),(26,11,8),(27,6,8),(28,7,8),(29,10,8),(30,15,8),(31,2,8),(8,1,4),(9,8,4),(10,5,4),(11,4,4),(12,3,4),(13,6,4),(14,7,4),(15,2,4),(4,1,2),(5,4,2),(6,3,2),(7,2,2),(2,4,1),(3,3,1),(0,1,0),(1,2,0),(64,1,32),(65,64,32),(66,33,32),(67,32,32),(68,17,32),(69,48,32),(70,49,32),(71,16,32),(72,9,32),(73,56,32),(74,41,32),(75,24,32),(76,25,32),(77,40,32),(78,57,32),(79,8,32),(80,5,32),(81,60,32),(82,37,32),(83,28,32),(84,21,32),(85,44,32),(86,53,32),(87,12,32),(88,13,32),(89,52,32),(90,45,32),(91,20,32),(92,29,32),(93,36,32),(94,61,32),(95,4,32),(96,3,32),(97,62,32),(98,35,32),(99,30,32),(100,19,32),(101,46,32),(102,51,32),(103,14,32),(104,11,32),(105,54,32),(106,43,32),(107,22,32),(108,27,32),(109,38,32),(110,59,32),(111,6,32),(112,7,32),(113,58,32),(114,39,32),(115,26,32),(116,23,32),(117,42,32),(118,55,32),(119,10,32),(120,15,32),(121,50,32),(122,47,32),(123,18,32),(124,31,32),(125,34,32),(126,63,32),(127,2,32);
/*!40000 ALTER TABLE `Grids` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `HTTData`
--

DROP TABLE IF EXISTS `HTTData`;
CREATE TABLE `HTTData` (
  `HtdEnId` int(10) unsigned NOT NULL,
  `HtdMatchNo` tinyint(4) unsigned default NULL,
  `HtdEvent` varchar(4) NOT NULL default '',
  `HtdTargetNo` varchar(5) NOT NULL,
  `HtdDistance` tinyint(4) NOT NULL,
  `HtdFinScheduling` datetime NOT NULL default '0000-00-00 00:00:00',
  `HtdTeamEvent` tinyint(1) unsigned NOT NULL default '0',
  `HtdArrowStart` tinyint(4) NOT NULL,
  `HtdArrowEnd` tinyint(4) NOT NULL,
  `HtdArrowString` varchar(6) NOT NULL,
  PRIMARY KEY  (`HtdTargetNo`,`HtdDistance`,`HtdArrowStart`,`HtdFinScheduling`,`HtdTeamEvent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `HTTData`
--

LOCK TABLES `HTTData` WRITE;
/*!40000 ALTER TABLE `HTTData` DISABLE KEYS */;
/*!40000 ALTER TABLE `HTTData` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `InvolvedType`
--

DROP TABLE IF EXISTS `InvolvedType`;
CREATE TABLE `InvolvedType` (
  `ItId` smallint(5) unsigned NOT NULL auto_increment,
  `ItDescription` varchar(32) NOT NULL,
  `ItJudge` tinyint(3) unsigned NOT NULL default '0',
  `ItDoS` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ItId`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `InvolvedType`
--

LOCK TABLES `InvolvedType` WRITE;
/*!40000 ALTER TABLE `InvolvedType` DISABLE KEYS */;
INSERT INTO `InvolvedType` VALUES (1,'Judge',1,0),(2,'Dos',0,1),(3,'OrgResponsible',0,0),(4,'Jury',0,0);
/*!40000 ALTER TABLE `InvolvedType` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `LookUpEntries`
--

DROP TABLE IF EXISTS `LookUpEntries`;
CREATE TABLE `LookUpEntries` (
  `LueCode` varchar(9) NOT NULL,
  `LueFamilyName` varchar(60) NOT NULL,
  `LueName` varchar(30) NOT NULL,
  `LueSex` tinyint(1) unsigned NOT NULL default '0',
  `LueCtrlCode` varchar(16) NOT NULL,
  `LueCountry` varchar(5) NOT NULL,
  `LueCoDescr` varchar(80) NOT NULL,
  `LueCoShort` varchar(30) NOT NULL,
  `LueDivision` varchar(2) NOT NULL,
  `LueClass` varchar(2) NOT NULL,
  `LueSubClass` varchar(2) NOT NULL,
  `LueStatus` tinyint(4) NOT NULL,
  `LueAthlete` tinyint(4) NOT NULL,
  `LueJudge` tinyint(4) NOT NULL,
  `LueDoS` tinyint(4) NOT NULL,
  `LueDefault` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`LueCode`,`LueClass`),
  KEY `LueCountry` (`LueCountry`),
  KEY `LueCode` (`LueCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `LookUpEntries`
--

LOCK TABLES `LookUpEntries` WRITE;
/*!40000 ALTER TABLE `LookUpEntries` DISABLE KEYS */;
/*!40000 ALTER TABLE `LookUpEntries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Parameters`
--

DROP TABLE IF EXISTS `Parameters`;
CREATE TABLE `Parameters` (
  `ParId` varchar(8) NOT NULL,
  `ParValue` varchar(255) NOT NULL,
  PRIMARY KEY  (`ParId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Parameters`
--

LOCK TABLES `Parameters` WRITE;
/*!40000 ALTER TABLE `Parameters` DISABLE KEYS */;
INSERT INTO `Parameters` VALUES ('LueUpdat','20090908103644'),('LuePath','http://www.fitarco-italia.org/gare/ianseo/Ianseo.php'),('ResPath','http://www.fitarco-italia.org/gare/getfiles.php'),('IntEvent','0'),('SwUpdate','2010.01.02'),('HttMode','0'),('HttFlg','NNNNNNNNNNNNNNNN'),('HttSeq','0103011006'),('HttSes','0'),('HttHost','192.168.1.1'),('HttPort','9001'),('DBUpdate','2010-01-20 02:00:00');
/*!40000 ALTER TABLE `Parameters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Phases`
--

DROP TABLE IF EXISTS `Phases`;
CREATE TABLE `Phases` (
  `PhId` tinyint(4) NOT NULL default '0',
  `PhDescr` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`PhId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Phases`
--

LOCK TABLES `Phases` WRITE;
/*!40000 ALTER TABLE `Phases` DISABLE KEYS */;
INSERT INTO `Phases` VALUES (0,'Final'),(1,'BronzeFinal'),(2,'SemiFinal'),(4,'4Final'),(8,'8Final'),(16,'16Final'),(32,'32Final'),(64,'64Final');
/*!40000 ALTER TABLE `Phases` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Photos`
--

DROP TABLE IF EXISTS `Photos`;
CREATE TABLE `Photos` (
  `PhEnId` int(10) unsigned NOT NULL,
  `PhPhoto` blob NOT NULL,
  PRIMARY KEY  (`PhEnId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Photos`
--

LOCK TABLES `Photos` WRITE;
/*!40000 ALTER TABLE `Photos` DISABLE KEYS */;
/*!40000 ALTER TABLE `Photos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `PrintOuts`
--

DROP TABLE IF EXISTS `PrintOuts`;
CREATE TABLE `PrintOuts` (
  `PoCode` varchar(25) NOT NULL,
  `PoType` varchar(1) NOT NULL COMMENT 'P=Participants, Q=qualif., F=Final, S=Stats',
  `PoFile` varchar(255) NOT NULL,
  `PoFunction` varchar(20) NOT NULL,
  `PoTeam` varchar(1) NOT NULL,
  `PoOrdine` int(11) NOT NULL,
  PRIMARY KEY  (`PoCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PrintOuts`
--

LOCK TABLES `PrintOuts` WRITE;
/*!40000 ALTER TABLE `PrintOuts` DISABLE KEYS */;
INSERT INTO `PrintOuts` VALUES ('EP','P','PrnSession.php','PrnSession','',1),('ES','P','PrnCountry.php','PrnCountry','',2),('EA','P','PrnAlphabetical.php','PrnAlphabetical','',3),('QSc','Q','/Qualification/PrintScore.php','','',5),('QNr','Q','/Qualification/PrintBackNo.php','','',6),('QI','Q','PrnQualClass.php','PrnQualClass','',7),('QIM','Q','/Qualification/PrnMedalInd.php','','',8),('QIQ','F','PrnQualAbs.php','PrnQualAbs','',9),('FIScA','F','/Final/Individual/PDFScore.php','','',10),('FIScI','F','/Final/Individual/PDFScoreMatch.php','','',11),('FIN','F','/Final/Individual/PrnName.php','','',12),('FINr','F','/Final/Individual/PDFBackNumber.php','','',13),('FIB','F','PrnBracket.php','PrnBracket','',14),('FIR','F','PrnRanking.php','PrnRanking','',15),('SMS','S','PrnMedal.php','PrnMedal','',16),('SI','S','PrnStatClasses.php','PrnStatClasses','',17),('ST','S','PrnStatCountry.php','PrnStatCountry','',18),('EN','P','PrnName.php','','',4);
/*!40000 ALTER TABLE `PrintOuts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `PrintOutsRules`
--

DROP TABLE IF EXISTS `PrintOutsRules`;
CREATE TABLE `PrintOutsRules` (
  `PorId` int(10) unsigned NOT NULL auto_increment,
  `PorTournament` int(10) unsigned NOT NULL default '0',
  `PorRuleName` varchar(64) NOT NULL,
  `PorTitle` varchar(50) NOT NULL,
  `PorPrintOuts` varchar(255) NOT NULL,
  `PorEventQual` varchar(255) NOT NULL,
  `PorQualCollate` varchar(1) NOT NULL default '1',
  `PorEventFin` varchar(255) NOT NULL,
  `PorFinCollate` varchar(1) NOT NULL default '1',
  `PorVisPar` varchar(1) NOT NULL,
  `PorVisFin` varchar(1) NOT NULL,
  `PorVisQual` varchar(1) NOT NULL,
  PRIMARY KEY  (`PorId`),
  KEY `PorTournament` (`PorTournament`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `PrintOutsRules`
--

LOCK TABLES `PrintOutsRules` WRITE;
/*!40000 ALTER TABLE `PrintOutsRules` DISABLE KEYS */;
INSERT INTO `PrintOutsRules` VALUES (1,42,'Book completo','Results Book','ES,EA,QI,FIB,FIR,SI,ST,SMS','RBSM,RBSMT,RBSW,RBSWT,RBJM,RBJMT,RBJW,RBJWT,CBSM,CBSMT,CBSW,CBSWT,CBJM,CBJMT,CBJW,CBJWT','','RM,RMT,RW,RWT,RJM,RJMT,RJW,RJWT,CM,CMT,CW,CWT,CJM,CJMT,CJW','1','','','');
/*!40000 ALTER TABLE `PrintOutsRules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Qualifications`
--

DROP TABLE IF EXISTS `Qualifications`;
CREATE TABLE `Qualifications` (
  `QuId` int(10) unsigned NOT NULL,
  `QuSession` tinyint(3) unsigned NOT NULL default '0',
  `QuTargetNo` varchar(5) NOT NULL,
  `QuD1Score` smallint(6) NOT NULL,
  `QuD1Hits` smallint(6) NOT NULL,
  `QuD1Gold` smallint(6) NOT NULL,
  `QuD1Xnine` smallint(6) NOT NULL,
  `QuD1Arrowstring` varchar(36) NOT NULL,
  `QuD1Rank` smallint(6) NOT NULL,
  `QuD1Status` tinyint(4) unsigned NOT NULL,
  `QuD2Score` smallint(6) NOT NULL,
  `QuD2Hits` smallint(6) NOT NULL,
  `QuD2Gold` smallint(6) NOT NULL,
  `QuD2Xnine` smallint(6) NOT NULL,
  `QuD2Arrowstring` varchar(36) NOT NULL,
  `QuD2Rank` smallint(6) NOT NULL,
  `QuD2Status` tinyint(4) unsigned NOT NULL,
  `QuD3Score` smallint(6) NOT NULL,
  `QuD3Hits` smallint(6) NOT NULL,
  `QuD3Gold` smallint(6) NOT NULL,
  `QuD3Xnine` smallint(6) NOT NULL,
  `QuD3Arrowstring` varchar(36) NOT NULL,
  `QuD3Rank` smallint(6) NOT NULL,
  `QuD3Status` tinyint(4) unsigned NOT NULL,
  `QuD4Score` smallint(6) NOT NULL,
  `QuD4Hits` smallint(6) NOT NULL,
  `QuD4Gold` smallint(6) NOT NULL,
  `QuD4Xnine` smallint(6) NOT NULL,
  `QuD4Arrowstring` varchar(36) NOT NULL,
  `QuD4Rank` smallint(6) NOT NULL,
  `QuD4Status` tinyint(4) unsigned NOT NULL,
  `QuD5Score` smallint(6) NOT NULL,
  `QuD5Hits` smallint(6) NOT NULL,
  `QuD5Gold` smallint(6) NOT NULL,
  `QuD5Xnine` smallint(6) NOT NULL,
  `QuD5Arrowstring` varchar(36) NOT NULL,
  `QuD5Rank` smallint(6) NOT NULL,
  `QuD5Status` tinyint(4) unsigned NOT NULL,
  `QuD6Score` smallint(6) NOT NULL,
  `QuD6Hits` smallint(6) NOT NULL,
  `QuD6Gold` smallint(6) NOT NULL,
  `QuD6Xnine` smallint(6) NOT NULL,
  `QuD6Arrowstring` varchar(36) NOT NULL,
  `QuD6Rank` smallint(6) NOT NULL,
  `QuD6Status` tinyint(4) unsigned NOT NULL,
  `QuD7Score` smallint(6) NOT NULL,
  `QuD7Hits` smallint(6) NOT NULL,
  `QuD7Gold` smallint(6) NOT NULL,
  `QuD7Xnine` smallint(6) NOT NULL,
  `QuD7Arrowstring` varchar(36) NOT NULL,
  `QuD7Rank` smallint(6) NOT NULL,
  `QuD7Status` tinyint(4) unsigned NOT NULL,
  `QuD8Score` smallint(6) NOT NULL,
  `QuD8Hits` smallint(6) NOT NULL,
  `QuD8Gold` smallint(6) NOT NULL,
  `QuD8Xnine` smallint(6) NOT NULL,
  `QuD8Arrowstring` varchar(36) NOT NULL,
  `QuD8Rank` smallint(6) NOT NULL,
  `QuD8Status` tinyint(4) unsigned NOT NULL,
  `QuScore` int(11) NOT NULL,
  `QuHits` int(11) NOT NULL,
  `QuGold` int(11) NOT NULL,
  `QuXnine` int(11) NOT NULL,
  `QuArrow` tinyint(3) NOT NULL,
  `QuClRank` smallint(6) NOT NULL,
  `QuRank` smallint(6) NOT NULL,
  `QuStatus` tinyint(4) unsigned NOT NULL,
  `QuTie` tinyint(1) NOT NULL,
  `QuTieBreak` varchar(16) NOT NULL,
  `QuTimestamp` timestamp NULL default NULL,
  PRIMARY KEY  (`QuId`),
  KEY `QuSession` (`QuSession`),
  KEY `QuTargetNo` (`QuTargetNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Qualifications`
--

LOCK TABLES `Qualifications` WRITE;
/*!40000 ALTER TABLE `Qualifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `Qualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Reviews`
--

DROP TABLE IF EXISTS `Reviews`;
CREATE TABLE `Reviews` (
  `RevEvent` varchar(4) NOT NULL,
  `RevMatchNo` tinyint(3) unsigned NOT NULL,
  `RevTournament` int(10) unsigned NOT NULL,
  `RevTeamEvent` tinyint(4) NOT NULL,
  `RevLanguage1` text NOT NULL,
  `RevLanguage2` text NOT NULL,
  `RevDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `RevSyncro` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`RevEvent`,`RevMatchNo`,`RevTournament`,`RevTeamEvent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Reviews`
--

LOCK TABLES `Reviews` WRITE;
/*!40000 ALTER TABLE `Reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `Reviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `SubClass`
--

DROP TABLE IF EXISTS `SubClass`;
CREATE TABLE `SubClass` (
  `ScId` varchar(2) NOT NULL,
  `ScTournament` int(10) unsigned NOT NULL default '0',
  `ScDescription` varchar(32) NOT NULL,
  `ScViewOrder` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ScId`,`ScTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `SubClass`
--

LOCK TABLES `SubClass` WRITE;
/*!40000 ALTER TABLE `SubClass` DISABLE KEYS */;
/*!40000 ALTER TABLE `SubClass` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TVContents`
--

DROP TABLE IF EXISTS `TVContents`;
CREATE TABLE `TVContents` (
  `TVCId` int(11) NOT NULL,
  `TVCTournament` int(11) NOT NULL,
  `TVCName` varchar(50) NOT NULL,
  `TVCContent` mediumblob NOT NULL,
  `TVCMimeType` varchar(50) NOT NULL,
  `TVCTime` tinyint(4) NOT NULL,
  `TVCScroll` tinyint(4) NOT NULL,
  PRIMARY KEY  (`TVCId`,`TVCTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TVContents`
--

LOCK TABLES `TVContents` WRITE;
/*!40000 ALTER TABLE `TVContents` DISABLE KEYS */;
INSERT INTO `TVContents` VALUES (1, -1, 'Logo Ianseo',  , 'image/gif', 5, 50);
/*!40000 ALTER TABLE `TVContents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TVOut`
--

DROP TABLE IF EXISTS `TVOut`;
CREATE TABLE `TVOut` (
  `TVId` int(10) unsigned NOT NULL auto_increment,
  `TVTime` smallint(5) unsigned NOT NULL default '5',
  `TVTournament` int(10) unsigned NOT NULL default '0',
  `TVRuleName` varchar(64) NOT NULL,
  `TVNumInd` smallint(5) unsigned NOT NULL default '0',
  `TVNumTeam` smallint(5) unsigned NOT NULL default '0',
  `TVMaxPage` tinyint(3) unsigned NOT NULL default '0',
  `TVSession` tinyint(3) unsigned NOT NULL default '0',
  `TVViewNationName` tinyint(1) unsigned NOT NULL default '0',
  `TVNameComplete` tinyint(1) unsigned NOT NULL default '0',
  `TVViewTeamComponents` tinyint(1) unsigned NOT NULL default '1',
  `TVEventInd` varchar(255) NOT NULL,
  `TVEventTeam` varchar(255) NOT NULL,
  `TVPhasesInd` varchar(255) NOT NULL,
  `TVPhasesTeam` varchar(255) NOT NULL,
  `TVStartPage` varchar(1) NOT NULL,
  `TVChain` varchar(64) NOT NULL,
  `TV_TR_BGColor` varchar(7) NOT NULL default '#FFFFFF',
  `TV_TRNext_BGColor` varchar(7) NOT NULL default '#FFFFCC',
  `TV_TR_Color` varchar(7) NOT NULL default '#000000',
  `TV_TRNext_Color` varchar(7) NOT NULL default '#000000',
  `TV_Content_BGColor` varchar(7) NOT NULL default '#FEFEFE',
  `TV_Page_BGColor` varchar(7) NOT NULL default '#FFFFFF',
  `TV_TH_BGColor` varchar(7) NOT NULL default '#CCCCCC',
  `TV_TH_Color` varchar(7) NOT NULL default '#000000',
  `TV_THTitle_BGColor` varchar(7) NOT NULL default '#585858',
  `TV_THTitle_Color` varchar(7) NOT NULL default '#F4F4F4',
  `TV_Carattere` smallint(5) unsigned NOT NULL default '30',
  PRIMARY KEY  (`TVId`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TVOut`
--

LOCK TABLES `TVOut` WRITE;
/*!40000 ALTER TABLE `TVOut` DISABLE KEYS */;
/*!40000 ALTER TABLE `TVOut` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TVParams`
--

DROP TABLE IF EXISTS `TVParams`;
CREATE TABLE `TVParams` (
  `TVPId` int(11) NOT NULL,
  `TVPTournament` int(11) NOT NULL,
  `TVPTimeStop` smallint(5) unsigned NOT NULL,
  `TVPTimeScroll` smallint(5) unsigned NOT NULL,
  `TVPNumRows` smallint(5) unsigned NOT NULL,
  `TVMaxPage` tinyint(3) unsigned NOT NULL,
  `TVPSession` tinyint(3) unsigned NOT NULL,
  `TVPViewNationName` tinyint(1) unsigned NOT NULL,
  `TVPNameComplete` tinyint(1) unsigned NOT NULL,
  `TVPViewTeamComponents` tinyint(1) unsigned NOT NULL,
  `TVPEventInd` varchar(255) NOT NULL,
  `TVPEventTeam` varchar(255) NOT NULL,
  `TVPPhasesInd` varchar(255) NOT NULL,
  `TVPPhasesTeam` varchar(255) NOT NULL,
  `TVPPage` varchar(10) NOT NULL,
  `TVPDefault` varchar(1) NOT NULL,
  `TVP_TR_BGColor` varchar(7) NOT NULL,
  `TVP_TRNext_BGColor` varchar(7) NOT NULL,
  `TVP_TR_Color` varchar(7) NOT NULL,
  `TVP_TRNext_Color` varchar(7) NOT NULL,
  `TVP_Content_BGColor` varchar(7) NOT NULL,
  `TVP_Page_BGColor` varchar(7) NOT NULL,
  `TVP_TH_BGColor` varchar(7) NOT NULL,
  `TVP_TH_Color` varchar(7) NOT NULL,
  `TVP_THTitle_BGColor` varchar(7) NOT NULL,
  `TVP_THTitle_Color` varchar(7) NOT NULL,
  `TVP_Carattere` smallint(5) unsigned NOT NULL,
  PRIMARY KEY  (`TVPId`,`TVPTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TVParams`
--

LOCK TABLES `TVParams` WRITE;
/*!40000 ALTER TABLE `TVParams` DISABLE KEYS */;
/*!40000 ALTER TABLE `TVParams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TVRules`
--

DROP TABLE IF EXISTS `TVRules`;
CREATE TABLE `TVRules` (
  `TVRId` int(11) NOT NULL,
  `TVRTournament` int(11) NOT NULL,
  `TVRName` varchar(50) NOT NULL,
  `TV_TR_BGColor` varchar(7) NOT NULL,
  `TV_TRNext_BGColor` varchar(7) NOT NULL,
  `TV_TR_Color` varchar(7) NOT NULL,
  `TV_TRNext_Color` varchar(7) NOT NULL,
  `TV_Content_BGColor` varchar(7) NOT NULL,
  `TV_Page_BGColor` varchar(7) NOT NULL,
  `TV_TH_BGColor` varchar(7) NOT NULL,
  `TV_TH_Color` varchar(7) NOT NULL,
  `TV_THTitle_BGColor` varchar(7) NOT NULL,
  `TV_THTitle_Color` varchar(7) NOT NULL,
  `TV_Carattere` int(11) NOT NULL,
  PRIMARY KEY  (`TVRId`,`TVRTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TVRules`
--

LOCK TABLES `TVRules` WRITE;
/*!40000 ALTER TABLE `TVRules` DISABLE KEYS */;
/*!40000 ALTER TABLE `TVRules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TVSequence`
--

DROP TABLE IF EXISTS `TVSequence`;
CREATE TABLE `TVSequence` (
  `TVSId` int(11) NOT NULL,
  `TVSTournament` int(11) NOT NULL,
  `TVSRule` int(11) NOT NULL,
  `TVSContent` int(11) NOT NULL,
  `TVSCntSameTour` tinyint(4) NOT NULL,
  `TVSTime` tinyint(4) NOT NULL,
  `TVSScroll` tinyint(4) NOT NULL,
  `TVSTable` varchar(5) NOT NULL,
  `TVSOrder` tinyint(4) NOT NULL,
  PRIMARY KEY  (`TVSId`,`TVSTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TVSequence`
--

LOCK TABLES `TVSequence` WRITE;
/*!40000 ALTER TABLE `TVSequence` DISABLE KEYS */;
/*!40000 ALTER TABLE `TVSequence` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Targets`
--

DROP TABLE IF EXISTS `Targets`;
CREATE TABLE `Targets` (
  `TarId` tinyint(3) unsigned NOT NULL auto_increment,
  `TarDescr` varchar(24) NOT NULL,
  `TarArray` varchar(24) NOT NULL default '0',
  PRIMARY KEY  (`TarId`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Targets`
--

LOCK TABLES `Targets` WRITE;
/*!40000 ALTER TABLE `Targets` DISABLE KEYS */;
INSERT INTO `Targets` VALUES (1,'TrgIndComplete','TrgIndComplete'),(2,'TrgIndSmall','TrgIndSmall'),(4,'TrgCOIndSmall','TrgCOIndSmall'),(3,'TrgCOIndComplete','TrgCOIndComplete'),(5,'TrgOutdoor','TrgOutdoor'),(6,'TrgField','TrgField'),(7,'TrgHMOutComplete','TrgHMOutComplete');
/*!40000 ALTER TABLE `Targets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TeamComponent`
--

DROP TABLE IF EXISTS `TeamComponent`;
CREATE TABLE `TeamComponent` (
  `TcCoId` int(11) NOT NULL,
  `TcSubTeam` varchar(1) NOT NULL default '0',
  `TcTournament` int(11) NOT NULL,
  `TcEvent` varchar(4) NOT NULL,
  `TcId` int(10) unsigned NOT NULL,
  `TcFinEvent` tinyint(3) unsigned NOT NULL default '0',
  `TcOrder` tinyint(4) NOT NULL,
  PRIMARY KEY  (`TcCoId`,`TcSubTeam`,`TcTournament`,`TcEvent`,`TcId`,`TcFinEvent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TeamComponent`
--

LOCK TABLES `TeamComponent` WRITE;
/*!40000 ALTER TABLE `TeamComponent` DISABLE KEYS */;
/*!40000 ALTER TABLE `TeamComponent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TeamFinComponent`
--

DROP TABLE IF EXISTS `TeamFinComponent`;
CREATE TABLE `TeamFinComponent` (
  `TfcCoId` int(11) NOT NULL,
  `TfcSubTeam` varchar(1) NOT NULL default '0',
  `TfcTournament` int(11) NOT NULL,
  `TfcEvent` varchar(4) NOT NULL,
  `TfcId` int(10) unsigned NOT NULL,
  `TfcOrder` tinyint(4) NOT NULL,
  PRIMARY KEY  (`TfcCoId`,`TfcSubTeam`,`TfcTournament`,`TfcEvent`,`TfcId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TeamFinComponent`
--

LOCK TABLES `TeamFinComponent` WRITE;
/*!40000 ALTER TABLE `TeamFinComponent` DISABLE KEYS */;
/*!40000 ALTER TABLE `TeamFinComponent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TeamFinals`
--

DROP TABLE IF EXISTS `TeamFinals`;
CREATE TABLE `TeamFinals` (
  `TfEvent` varchar(4) NOT NULL,
  `TfMatchNo` tinyint(4) unsigned NOT NULL default '0',
  `TfTournament` int(10) unsigned NOT NULL default '0',
  `TfSession` tinyint(4) unsigned NOT NULL default '0',
  `TfTarget` varchar(6) NOT NULL,
  `TfScheduledtime` datetime NOT NULL,
  `TfRank` tinyint(4) unsigned NOT NULL default '0',
  `TfTeam` int(10) unsigned NOT NULL default '0',
  `TfSubTeam` varchar(1) NOT NULL default '0',
  `TfScore` smallint(6) NOT NULL default '0',
  `TfSetScore` tinyint(4) NOT NULL default '0',
  `TfSetPoints` varchar(15) default NULL,
  `TfTie` tinyint(1) NOT NULL default '0',
  `TfArrowstring` varchar(24) default NULL,
  `TfTiebreak` varchar(9) default NULL,
  `TfArrowPosition` varchar(240) default NULL,
  `TfTiePosition` varchar(90) default NULL,
  `TfWinLose` tinyint(1) unsigned NOT NULL default '0',
  `TfFinalRank` tinyint(4) unsigned NOT NULL default '0',
  `TfDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `TfSyncro` datetime NOT NULL,
  `TfLive` tinyint(4) NOT NULL default '0',
  `TfVxF` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`TfEvent`,`TfMatchNo`,`TfTournament`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TeamFinals`
--

LOCK TABLES `TeamFinals` WRITE;
/*!40000 ALTER TABLE `TeamFinals` DISABLE KEYS */;
/*!40000 ALTER TABLE `TeamFinals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Teams`
--

DROP TABLE IF EXISTS `Teams`;
CREATE TABLE `Teams` (
  `TeCoId` int(11) NOT NULL,
  `TeSubTeam` varchar(1) NOT NULL default '0',
  `TeEvent` varchar(4) NOT NULL,
  `TeTournament` int(11) NOT NULL,
  `TeFinEvent` tinyint(3) unsigned NOT NULL default '0',
  `TeScore` smallint(6) NOT NULL,
  `TeHits` smallint(6) NOT NULL,
  `TeGold` smallint(6) NOT NULL,
  `TeXnine` smallint(6) NOT NULL,
  `TeTie` tinyint(1) NOT NULL,
  `TeTieBreak` varchar(15) NOT NULL,
  `TeRank` tinyint(4) NOT NULL,
  `TeTimeStamp` timestamp NULL default NULL,
  `TeFinal` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`TeCoId`,`TeSubTeam`,`TeEvent`,`TeTournament`,`TeFinEvent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Teams`
--

LOCK TABLES `Teams` WRITE;
/*!40000 ALTER TABLE `Teams` DISABLE KEYS */;
/*!40000 ALTER TABLE `Teams` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Tournament`
--

DROP TABLE IF EXISTS `Tournament`;
CREATE TABLE `Tournament` (
  `ToId` int(10) unsigned NOT NULL auto_increment,
  `ToType` smallint(5) unsigned NOT NULL,
  `ToCode` varchar(8) NOT NULL,
  `ToName` tinytext NOT NULL,
  `ToCommitee` varchar(5) NOT NULL,
  `ToComDescr` tinytext NOT NULL,
  `ToWhere` tinytext NOT NULL,
  `ToWhenFrom` date NOT NULL,
  `ToWhenTo` date NOT NULL,
  `ToIntEvent` tinyint(3) unsigned NOT NULL default '0',
  `ToCurrency` varchar(8) default NULL,
  `ToPrintLang` varchar(5) NOT NULL,
  `ToPrintChars` tinyint(3) unsigned NOT NULL default '0',
  `ToPrintPaper` tinyint(3) unsigned NOT NULL default '0' COMMENT '0: ansi A4, 1: Letter',
  `ToImpFin` tinyint(3) unsigned NOT NULL default '0',
  `ToImgL` blob NOT NULL,
  `ToImgR` blob NOT NULL,
  `ToImgB` blob NOT NULL,
  `ToImgB2` blob NOT NULL,
  `ToNumSession` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session1` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session2` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session3` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session4` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session5` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session6` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session7` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session8` tinyint(3) unsigned NOT NULL default '0',
  `ToTar4Session9` tinyint(3) unsigned NOT NULL default '0',
  `ToAth4Target1` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target2` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target3` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target4` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target5` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target6` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target7` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target8` tinyint(3) unsigned NOT NULL default '4',
  `ToAth4Target9` tinyint(3) unsigned NOT NULL default '4',
  `ToIndFinVxA` tinyint(3) unsigned NOT NULL default '0',
  `ToTeamFinVxA` tinyint(3) unsigned NOT NULL default '0',
  `ToDbVersion` datetime NOT NULL default '0000-00-00 00:00:00',
  `ToBlock` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ToId`),
  UNIQUE KEY `ToCode` (`ToCode`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Tournament`
--

LOCK TABLES `Tournament` WRITE;
/*!40000 ALTER TABLE `Tournament` DISABLE KEYS */;
/*!40000 ALTER TABLE `Tournament` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TournamentDistances`
--

DROP TABLE IF EXISTS `TournamentDistances`;
CREATE TABLE `TournamentDistances` (
  `TdClasses` varchar(4) NOT NULL,
  `TdType` smallint(5) unsigned NOT NULL,
  `Td1` varchar(10) NOT NULL,
  `Td2` varchar(10) NOT NULL,
  `Td3` varchar(10) NOT NULL,
  `Td4` varchar(10) NOT NULL,
  `Td5` varchar(10) NOT NULL,
  `Td6` varchar(10) NOT NULL,
  `Td7` varchar(10) NOT NULL,
  `Td8` varchar(10) NOT NULL,
  PRIMARY KEY  (`TdClasses`,`TdType`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TournamentDistances`
--

LOCK TABLES `TournamentDistances` WRITE;
/*!40000 ALTER TABLE `TournamentDistances` DISABLE KEYS */;
INSERT INTO `TournamentDistances` VALUES ('AN__',1,'60 m','50 m','40 m','30 m','','','',''),('OLVM',4,'90 m','70 m','50 m','30 m','','','',''),('OLRM',4,'50 m','40 m','30 m','20 m','','','',''),('OLSM',1,'90 m','70 m','50 m','30 m','','','',''),('OLJM',1,'90 m','70 m','50 m','30 m','','','',''),('OLRM',1,'50 m','40 m','30 m','20 m','','','',''),('OLVM',1,'90 m','70 m','50 m','30 m','','','',''),('OLGM',1,'30 m','25 m','20 m','15 m','','','',''),('OLAM',1,'70 m','60 m','50 m','30 m','','','',''),('OLGF',1,'30 m','25 m','20 m','15 m','','','',''),('OLVF',1,'70 m','60 m','50 m','30 m','','','',''),('OLRF',1,'50 m','40 m','30 m','20 m','','','',''),('OLJF',1,'70 m','60 m','50 m','30 m','','','',''),('OLSF',1,'70 m','60 m','50 m','30 m','','','',''),('OLAF',1,'60 m','50 m','40 m','30 m','','','',''),('COSM',1,'90 m','70 m','50 m','30 m','','','',''),('COJM',1,'90 m','70 m','50 m','30 m','','','',''),('CORM',1,'50 m','40 m','30 m','20 m','','','',''),('COVM',1,'90 m','70 m','50 m','30 m','','','',''),('COGM',1,'30 m','25 m','20 m','15 m','','','',''),('COAM',1,'70 m','60 m','50 m','30 m','','','',''),('COGF',1,'30 m','25 m','20 m','15 m','','','',''),('COVF',1,'70 m','60 m','50 m','30 m','','','',''),('CORF',1,'50 m','40 m','30 m','20 m','','','',''),('COJF',1,'70 m','60 m','50 m','30 m','','','',''),('COSF',1,'70 m','60 m','50 m','30 m','','','',''),('COAF',1,'60 m','50 m','40 m','30 m','','','',''),('__S_',3,'70m-1','70m-2','','','','','',''),('__V_',3,'70m-1','70m-2','','','','','',''),('__J_',3,'70m-1','70m-2','','','','','',''),('__AM',3,'70m-1','70m-2','','','','','',''),('__AF',3,'60m-1','60m-2','','','','','',''),('AN__',2,'60 m','50 m','40 m','30 m','60 m','50 m','40 m','30 m'),('OLSM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('OLJM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('OLRM',2,'50 m','40 m','30 m','20 m','50 m','40 m','30 m','20 m'),('OLVM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('OLGM',2,'30 m','25 m','20 m','15 m','30 m','25 m','20 m','15 m'),('OLAM',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('OLGF',2,'30 m','25 m','20 m','15 m','30 m','25 m','20 m','15 m'),('OLVF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('OLRF',2,'50 m','40 m','30 m','20 m','50 m','40 m','30 m','20 m'),('OLJF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('OLSF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('OLAF',2,'60 m','50 m','40 m','30 m','60 m','50 m','40 m','30 m'),('COSM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('COJM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('CORM',2,'50 m','40 m','30 m','20 m','50 m','40 m','30 m','20 m'),('COVM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('COGM',2,'30 m','25 m','20 m','15 m','30 m','25 m','20 m','15 m'),('COAM',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('COGF',2,'30 m','25 m','20 m','15 m','30 m','25 m','20 m','15 m'),('COVF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('CORF',2,'50 m','40 m','30 m','20 m','50 m','40 m','30 m','20 m'),('COJF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('COSF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('COAF',2,'60 m','50 m','40 m','30 m','60 m','50 m','40 m','30 m'),('OLGM',4,'30 m','25 m','20 m','15 m','','','',''),('OLJM',4,'90 m','70 m','50 m','30 m','','','',''),('OLSM',4,'90 m','70 m','50 m','30 m','','','',''),('AN__',4,'60 m','50 m','40 m','30 m','','','',''),('__R_',5,'40 m','35 m','30 m','','','','',''),('__G_',5,'25 m','20 m','15 m','','','','',''),('__A_',5,'60 m','50 m','40 m','','','','',''),('__J_',5,'60 m','50 m','40 m','','','','',''),('__S_',5,'60 m','50 m','40 m','','','','',''),('__V_',5,'60 m','50 m','40 m','','','','',''),('__M_',5,'60 m','50 m','40 m','','','','',''),('OLAM',4,'70 m','60 m','50 m','30 m','','','',''),('OLGF',4,'30 m','25 m','20 m','15 m','','','',''),('OLVF',4,'70 m','60 m','50 m','30 m','','','',''),('OLRF',4,'50 m','40 m','30 m','20 m','','','',''),('OLJF',4,'70 m','60 m','50 m','30 m','','','',''),('OLSF',4,'70 m','60 m','50 m','30 m','','','',''),('OLAF',4,'60 m','50 m','40 m','30 m','','','',''),('COSM',4,'90 m','70 m','50 m','30 m','','','',''),('COJM',4,'90 m','70 m','50 m','30 m','','','',''),('CORM',4,'50 m','40 m','30 m','20 m','','','',''),('COVM',4,'90 m','70 m','50 m','30 m','','','',''),('COGM',4,'30 m','25 m','20 m','15 m','','','',''),('COAM',4,'70 m','60 m','50 m','30 m','','','',''),('COGF',4,'30 m','25 m','20 m','15 m','','','',''),('COVF',4,'70 m','60 m','50 m','30 m','','','',''),('CORF',4,'50 m','40 m','30 m','20 m','','','',''),('COJF',4,'70 m','60 m','50 m','30 m','','','',''),('COSF',4,'70 m','60 m','50 m','30 m','','','',''),('COAF',4,'60 m','50 m','40 m','30 m','','','',''),('OLMM',4,'90 m','70 m','50 m','30 m','','','',''),('COMM',4,'90 m','70 m','50 m','30 m','','','',''),('OLMF',4,'70 m','60 m','50 m','30 m','','','',''),('COMF',4,'70 m','60 m','50 m','30 m','','','',''),('OLMM',1,'90 m','70 m','50 m','30 m','','','',''),('COMM',1,'90 m','70 m','50 m','30 m','','','',''),('OLMF',1,'70 m','60 m','50 m','30 m','','','',''),('COMF',1,'70 m','60 m','50 m','30 m','','','',''),('OLMM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('OLMF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('COMM',2,'90 m','70 m','50 m','30 m','90 m','70 m','50 m','30 m'),('COMF',2,'70 m','60 m','50 m','30 m','70 m','60 m','50 m','30 m'),('__M_',3,'70m-1','70m-2','','','','','',''),('%',6,'18m-1','18m-2','','','','','',''),('%',7,'25m-1','25m-2','','','','','',''),('%',8,'25m-1','25m-2','18m-1','18m-2','','','',''),('%',9,'H&F','','','','','','',''),('%',10,'Hunter','Field','','','','','',''),('%',12,'Hunter','Field','','','','','',''),('__F_',15,'20m-1','20m-2','','','','','',''),('__M_',15,'20m-1','20m-2','','','','','',''),('__G_',15,'15m-1','15m-2','','','','','',''),('__P_',15,'10m-1','10m-2','','','','','',''),('%',14,'Day 1','Day 2','Day 3','S.O.','','','',''),('%',13,'Perc.','Perc.','','','','','',''),('%',11,'Perc.','','','','','','','');
/*!40000 ALTER TABLE `TournamentDistances` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TournamentInvolved`
--

DROP TABLE IF EXISTS `TournamentInvolved`;
CREATE TABLE `TournamentInvolved` (
  `TiId` int(10) unsigned NOT NULL auto_increment,
  `TiTournament` int(10) unsigned NOT NULL,
  `TiType` smallint(5) unsigned NOT NULL,
  `TiCode` varchar(9) NOT NULL,
  `TiName` varchar(64) NOT NULL,
  PRIMARY KEY  (`TiId`)
) ENGINE=MyISAM AUTO_INCREMENT=297 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TournamentInvolved`
--

LOCK TABLES `TournamentInvolved` WRITE;
/*!40000 ALTER TABLE `TournamentInvolved` DISABLE KEYS */;
/*!40000 ALTER TABLE `TournamentInvolved` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `TournamentType`
--

DROP TABLE IF EXISTS `TournamentType`;
CREATE TABLE `TournamentType` (
  `TtId` smallint(5) unsigned NOT NULL auto_increment,
  `TtName` varchar(25) NOT NULL,
  `TtNumDist` tinyint(3) unsigned NOT NULL,
  `TtNumEnds` tinyint(3) unsigned NOT NULL,
  `TtMaxDistScore` mediumint(8) unsigned NOT NULL,
  `TtMaxFinIndScore` mediumint(8) unsigned NOT NULL,
  `TtMaxFinTeamScore` mediumint(8) unsigned NOT NULL,
  `TtCategory` tinyint(4) NOT NULL default '0' COMMENT '0: Other, 1: Outdoor, 2: Indoor, 4:Field, 8:3D',
  `TtElabTeam` tinyint(4) NOT NULL default '0' COMMENT '0:Standard, 1:Field, 2:3DI',
  `TtElimination` tinyint(4) NOT NULL default '0' COMMENT 'o: No Eliminations, 1: Elimination Allowed',
  `TtGolds` varchar(5) NOT NULL,
  `TtXNine` varchar(5) NOT NULL,
  `TtOrder` int(11) NOT NULL,
  PRIMARY KEY  (`TtId`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TournamentType`
--

LOCK TABLES `TournamentType` WRITE;
/*!40000 ALTER TABLE `TournamentType` DISABLE KEYS */;
INSERT INTO `TournamentType` VALUES (1,'Type_FITA',4,12,360,120,240,1,0,0,'10','X',10),(2,'Type_2xFITA',8,12,360,120,240,1,0,0,'10','X',20),(3,'Type_70m Round',2,12,360,120,240,1,0,0,'10','X',40),(4,'Type_FITA 72',4,6,180,120,240,1,0,0,'10','X',30),(5,'Type_900 Round',3,10,300,0,0,1,0,0,'10','X',140),(6,'Type_Indoor 18',2,10,300,120,240,2,0,0,'10','9',50),(7,'Type_Indoor 25',2,10,300,120,240,2,0,0,'10','9',60),(8,'Type_Indoor 25+18',4,10,300,120,240,2,0,0,'10','9',70),(9,'Type_HF 12+12',1,24,432,72,144,4,1,1,'6+5','6',90),(10,'Type_HF 24+24',2,24,432,72,144,4,1,1,'6+5','6',110),(11,'Type_3D',1,20,200,40,240,8,2,1,'10','X',120),(12,'Type_HF 12+12',2,12,216,72,144,4,1,1,'6+5','6',100),(13,'Type_3D',2,20,200,40,240,8,2,1,'10','X',130),(14,'Type_Las Vegas',4,10,300,0,0,0,0,0,'10','X',80),(15,'Type_GiochiGioventu',2,8,240,0,0,1,0,0,'10','X',150),(16,'Type_GiochiGioventuWinter',2,8,240,0,0,2,0,0,'10','9',160);
/*!40000 ALTER TABLE `TournamentType` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `VxA`
--

DROP TABLE IF EXISTS `VxA`;
CREATE TABLE `VxA` (
  `VxAId` tinyint(3) unsigned NOT NULL auto_increment,
  `VxAValue` varchar(5) NOT NULL,
  `VxATeam` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`VxAId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `VxA`
--

LOCK TABLES `VxA` WRITE;
/*!40000 ALTER TABLE `VxA` DISABLE KEYS */;
INSERT INTO `VxA` VALUES (1,'4x3',0),(2,'2x6',0),(3,'4x6',1);
/*!40000 ALTER TABLE `VxA` 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 2010-02-05 10:46:00