· 7 years ago · Sep 16, 2018, 09:30 PM
1-- --------------------------------------------------------
2-- Servidor: 127.0.0.1
3-- Versão do servidor: 5.7.12 - MySQL Community Server (GPL)
4-- OS do Servidor: Win32
5-- HeidiSQL Versão: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Copiando estrutura para tabela textil_pannos.bancos
15CREATE TABLE IF NOT EXISTS `bancos` (
16 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
17 `Codigo` varchar(5) DEFAULT NULL,
18 `Descricao` varchar(100) DEFAULT NULL,
19 `LastModified` varchar(50) DEFAULT NULL,
20 PRIMARY KEY (`ID`)
21) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
22
23-- Copiando dados para a tabela textil_pannos.bancos: ~19 rows (aproximadamente)
24DELETE FROM `bancos`;
25/*!40000 ALTER TABLE `bancos` DISABLE KEYS */;
26INSERT INTO `bancos` (`ID`, `Codigo`, `Descricao`, `LastModified`) VALUES
27 (1, '001', 'BANCO DO BRASIL', 'Administrador - 28/07/2015 10:47:42'),
28 (2, '003', 'BANCO DA AMAZONIA', 'DAVI - 11/08/2015 09:50:18'),
29 (3, '004', 'BANCO DO NORDESTE', 'DAVI - 11/08/2015 09:57:09'),
30 (4, '021', 'BANESTES', 'DAVI - 27/10/2015 08:40:03'),
31 (5, '033', 'SANTANDER', 'DAVI - 11/08/2015 09:56:52'),
32 (6, '037', 'BANPARA', 'DAVI - 06/10/2015 17:50:38'),
33 (7, '041', 'BANRISUL', 'DAVI - 26/11/2015 11:51:45'),
34 (8, '047', 'BANESE', 'DAVI - 30/07/2015 14:54:09'),
35 (9, '070', 'BANCO DE BRASILIA', 'DAVI - 29/11/2016 10:54:48'),
36 (10, '097', 'CREDISIS', 'DAVI - 01/10/2015 11:31:39'),
37 (11, '104', 'CAIXA', 'NAILSON - 28/07/2015 15:38:02'),
38 (12, '136', 'UNICRED', 'DAVI - 03/10/2016 10:58:20'),
39 (13, '237', 'BRADESCO', 'Administrador - 28/07/2015 10:59:50'),
40 (14, '341', 'ITAU', 'Administrador - 28/07/2015 10:48:06'),
41 (15, '389', 'MERCANTIL DO BRASIL', 'DAVI - 22/03/2016 10:13:23'),
42 (16, '399', 'HSBC', 'DAVI - 30/07/2015 14:53:55'),
43 (17, '422', 'BANCO SAFRA SA', 'DAVI - 16/09/2016 14:54:37'),
44 (18, '748', 'SICREDI / UNICRED', 'DAVI - 24/11/2015 11:48:47'),
45 (19, '756', 'SICOOB', 'DAVI - 06/08/2015 14:38:55');
46/*!40000 ALTER TABLE `bancos` ENABLE KEYS */;
47
48/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
49/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
50/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;