gafedade

--
-- Create schema prefeitura
--

CREATE DATABASE IF NOT EXISTS prefeitura;
USE prefeitura;

--
-- Definition of table `aidf_docs`
--

DROP TABLE IF EXISTS `aidf_docs`;
CREATE TABLE `aidf_docs` ( `codigo` int(10) NOT NULL auto_increment, `codsolicitacao` int(10) default NULL, `especie` varchar(50) default NULL, `serie` varchar(10) default NULL, `subserie` varchar(10) default NULL, `nroinicial` int(10) default NULL, `nrofinal` int(10) default NULL, `quantidade` int(10) default NULL, `tipo` varchar(10) default NULL, PRIMARY KEY (`codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='Tabela de documentos a serem impressos.';

--
-- Dumping data for table `aidf_docs`
--

/*!40000 ALTER TABLE `aidf_docs` DISABLE KEYS */;
/*!40000 ALTER TABLE `aidf_docs` ENABLE KEYS */;

--
-- Definition of table `aidf_especie`
--

DROP TABLE IF EXISTS `aidf_especie`;
CREATE TABLE `aidf_especie` ( `codigo` int(11) NOT NULL auto_increment, `especie` text, `serie` varchar(10) default NULL, PRIMARY KEY (`codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `aidf_especie`
--

/*!40000 ALTER TABLE `aidf_especie` DISABLE KEYS */;
/*!40000 ALTER TABLE `aidf_especie` ENABLE KEYS */;

--
-- Definition of table `aidf_solicitacoes`
--

DROP TABLE IF EXISTS `aidf_solicitacoes`;
CREATE TABLE `aidf_solicitacoes` ( `codigo` int(10) NOT NULL auto_increment, `codemissor` int(10) default NULL COMMENT 'tabela cadastro', `codgrafica` int(10) default NULL COMMENT 'tabela cadastro', `observacoes` text, `confirmar` char(1) default 'n' COMMENT 's para sim, n para nao', `data` date default NULL, PRIMARY KEY (`codigo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `aidf_solicitacoes`
--

/*!40000 ALTER TABLE `aidf_solicitacoes` DISABLE KEYS */;
/*!40000 ALTER TABLE `aidf_solicitacoes`