-- MySQL dump 10.10
--
-- Host: localhost    Database: v63
-- ------------------------------------------------------
-- Server version	5.0.13-rc-nt-max-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 `pfdtdes`
--

DROP TABLE IF EXISTS `pfdtdes`;
CREATE TABLE `pfdtdes` (
  `DTCODI` varchar(2) character set latin1 collate latin1_bin NOT NULL,
  `DTPDTO` bigint(20) default NULL,
  `DTDESC` varchar(25) character set latin1 collate latin1_bin default NULL,
  `DTADED` date default NULL,
  `DTADEH` date default NULL,
  `DTDAYD` int(11) default NULL,
  `DTDAYH` int(11) default NULL,
  `DTCUPO` int(11) default NULL,
  `DTUSOS` int(11) default NULL,
  `DTSIST` varchar(4) character set latin1 collate latin1_bin default '0000',
  `DTFLG1` varchar(1) character set latin1 collate latin1_bin default NULL,
  `DTFLG2` varchar(1) character set latin1 collate latin1_bin default NULL,
  `DTFLG3` varchar(1) character set latin1 collate latin1_bin default NULL,
  `DTFLG4` varchar(1) character set latin1 collate latin1_bin default NULL,
  PRIMARY KEY  (`DTCODI`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

--
-- Dumping data for table `pfdtdes`
--


/*!40000 ALTER TABLE `pfdtdes` DISABLE KEYS */;
LOCK TABLES `pfdtdes` WRITE;
INSERT INTO `pfdtdes` VALUES ('01',2500,'Descuento 25%',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('02',110,'INFANTIL',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('03',12,'MAYORES 65 AÑOS',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('04',2595,'MENORES 25xxxxxxxxxxxxxxx',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('05',500,'5 % DE DESCUENTO',NULL,'2005-03-31',-1,-1,-1,0,'0000','S','N',' ',' '),('10',1234,'10_%_dto._(12,34)',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('11',1100,'1111','2005-05-19','2005-05-19',-1,-1,-1,0,'0000','S','N',NULL,NULL),('15',-1,'15',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('20',1204,'20_%_dto._(12,04)',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('25',-1,'Descuento 25% AE-AT-MG',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('99',0,'Sin descuento',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('A1',-1,'ALBERTO: telf',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('A2',222,'ALBERTO SIN DESGLOSE',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('A3',-1,'ALBERTO: taq',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('A4',-1,'ALBERTO: taq y tel',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('AB',1200,'ABONADOS',NULL,NULL,-1,-1,20,1,'0000','S','N',' ',' '),('AP',-1,'Descuento con desglose',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('C3',717,'CENTESIMAL 3DIGITOS 7.17',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('C4',1717,'CENTESIMAL 4DIGITOS 17.17',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('CJ',-1,'CARNET JOVEN',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('GR',10,'GRUPOS',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('IN',3005,'INAUGURACIÓN',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' '),('MB',1200,'desc. para el recinto mb',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('MG',500,'descuento para el mg',NULL,NULL,-1,-1,-1,0,'0000','S','N',NULL,NULL),('VE',2000,'20%',NULL,NULL,-1,-1,-1,0,'0000','S','N',' ',' ');
UNLOCK TABLES;
/*!40000 ALTER TABLE `pfdtdes` ENABLE KEYS */;

/*!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 */;