API tools faq
paste
Advertisement
11eimilia11

Povoamento dase de Dados FINAL

11eimilia11
Jan 24th, 2018
752
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 37.98 KB | None | 0 0
raw download clone embed print report
  1. USE IchibaSuperMarket;
  2.  
  3. -- inserindo valores para curso
  4.  
  5. INSERT INTO curso VALUES
  6.  
  7. ( '7070', 12 , 'entregas'),
  8. ( '1010' , 20, 'libras'),
  9. ( '2276' , 5 , 'marketing'),
  10. ( '9085' , 13 , 'informatica'),
  11. ( '7324' , 7 , 'financas'),
  12. ( '8012'  , 60 , 'ingles'),
  13. ( '3390', 30 , 'relacoes humanas'),
  14. ( '8344' , 30 , 'estatistica'),
  15. ( '5793' , 40 , 'circuitos'),
  16. ( '3333' , 20 , 'ginastica laboral'),
  17. ( '5449', 40 , 'mecanica'),
  18. ( '7573' , 20, 'administracao'),
  19. ( '9090' , 40 , 'programacao'),
  20. ( '2101' , 40 , 'espanhol');
  21.  
  22.  
  23. -- inserindo valores na tabela jornadatrabalho
  24.  
  25. INSERT INTO jornadatrabalho ( id , descricao , trabalha_sabado) VALUES
  26.  
  27. ('0001' , 'segunda a domingo' , true),
  28. ('0002' , NULL , false),
  29. ('0003' , 'trabalha feriados' , true),
  30. ('0004' , ' ' , true ),
  31. ('0005' , ' ' , false),
  32. ('0006' , ' ', false),
  33. ('0007' , 'trabalha feriados' , true),
  34. ('0008' , ' ' , true),
  35. ('0009' , ' ' , true),
  36. ('0010' , ' ', true ),
  37. ('0011' , ' ', true),
  38. ('0012', ' ', true),
  39. ('0013' , ' ' , true),
  40. ('0014', ' ' , true),
  41. ('0015' , ' ', true ),
  42. ('0016'  , ' ' , false);
  43.  
  44.  
  45. -- inserindo valores na tabela de turno
  46.  
  47. INSERT INTO turno ( cod, descricao , hora_inicio, hora_fim ) VALUES
  48.  
  49. ('0001' , ' ' , '07:30:00' , '16:30:00'),
  50. ('0002' , ' ', '08:40:00' , '17:40:00'),
  51. ('0003' , ' ' , '07:00:00' , '14:00:00'),
  52. ('0004' , ' ' , '11:00:00' , '17:00:00'),
  53. ('0005' , ' ' , '14:00:00' , '18:30:00'),
  54. ('0006' , ' ' , '13:35:00' , '19:45:00'),
  55. ('0007' , ' ' , '07:30:00' , '12:30:00'),
  56. ('0008' , ' ' , '07:10:00' , '13:30:00'),
  57. ('0009' , ' ' , '18:00:00' , '23:55:00'),
  58. ('0010' , ' ' , '00:00:01' , '08:00:01');
  59.  
  60.  
  61.  
  62. -- inserindo valores na tabela de dia
  63.  
  64. INSERT INTO dia ( sequencial , descricao ) VALUES
  65.  
  66. ('0001' , ' segunda-feira' ),
  67. ('0002' , ' terça-feira' ),
  68. ('0003' , ' quarta-feira' ),
  69. ('0004' , ' quinta-feira' ),
  70. ('0005' , ' sexta-feira' ),
  71. ('0006' , ' sabado' ),
  72. ('0007' , ' domingo' );
  73.  
  74.  
  75.  
  76. -- inserindo valores na tabela Matriz
  77.  
  78. INSERT INTO matriz ( CNPJ , nomefantasia ) VALUES
  79.  
  80. ( '23416393000114' , 'ICBSP'),
  81. ( '23416393000140' , 'ICBPE'),
  82. ( '23416393000169' , 'ICBRJ');
  83.  
  84.  
  85.  
  86. -- inserindo valores na tabela telefone_matriz
  87.  
  88. INSERT INTO telefone_matriz (CNPJ , telefone ) VALUES
  89.  
  90. ('23416393000114' , '8133002432'),
  91. ('23416393000140' , '8133002149'),
  92. ('23416393000140' , '1133002932'),
  93. ('23416393000140' , '1140443949'),
  94. ('23416393000169' , '1433004732'),
  95. ('23416393000169' , '1440002449');
  96.  
  97.  
  98.  
  99.  
  100. -- inserindo valores na tabela filial
  101.  
  102. INSERT INTO filial ( seq , CNPJ_Matriz , CPF_gerente , endereco , qtd_func ) VALUES
  103.  
  104. ( '0001' ,  '23416393000114' , NULL , 'Rua valtavares ' , 4 ),
  105. ( '0002' ,  '23416393000114' , NULL , 'Rua alivetania ' , 4 ),
  106. ( '0003' ,  '23416393000140' , NULL, 'Rua maranguape ' , 4 ),
  107. ( '0004' ,  '23416393000169' , NULL , 'Rua fernigan ' , 4 );
  108.  
  109.  
  110.  
  111. -- inserindo valores na tabela telefone_filial
  112.  
  113. INSERT INTO telefone_filial( seq_filial , CNPJ_Matriz , telefone ) VALUES
  114.  
  115. ( '0001' ,  '23416393000114' , '1133115021' ),
  116. ( '0002' ,  '23416393000114' , '1133505231' ),
  117. ( '0003' ,  '23416393000140' , '8143022151' ),
  118. ( '0004' ,  '23416393000169' , '1431205412' );
  119.  
  120.  
  121.  
  122. -- inserindo valores para funcionario
  123.  
  124. INSERT INTO funcionario (CPF, id_jornada, seq_filial, cnpj_matriz, data_admissao, sex, estado_civil, login, senha, RG, nome, situacao, endereco) VALUES
  125.  
  126. ('77491222226' , '0001', '0001' ,  '23416393000114' , '2005-04-12' , 'F', 'solteiro' , 'helo.12' , '123' ,  '1259312' , 'Heloisa Macedo de Souza' , 'ativo' , 'Rua Eloy Monteiro Nunes'),
  127. ('98243208909' , '0002' , '0001' ,'23416393000114' , '2007-07-25' , 'M' , 'casado' , 'Garza2019' , 'E3221' ,'3654296' , 'Elias ChateauBriand Gomes' , 'inativo' , 'Avenida Paraíba'),
  128. ('57325297050' , '0003' , '0003' , '23416393000140', '2003-09-02', 'F', 'viuva' , 'Riggs642' , 'YM' ,       '4563573' , 'Maria Helena Rosendo' , 'ativo', 'Rua Pedro Viana Neto'),
  129. ('16565525749' , '0004' , '0002' , '23416393000114' , '2000-01-07', 'F', 'solteiro' , 'Eugene759' , 'XX133','2144770', 'Afrodite Bezerra das Flores' , 'ativo', 'Rua Amelia'),
  130. ('57859332507', '0005' , '0002' ,  '23416393000114' , '2006-02-02' , 'M' , 'solteiro' , 'TM1' , '98UJ' ,    '1555582' , 'Mauricio de Souza Carvalho' , 'ativo' , ' Rua da Concordia'),
  131. ('96202875763' , '0006' , '0003' , '23416393000140' , '2001-09-11' , 'F' , 'solteiro' ,'Juli.Alves', '8900','3494135' , 'Juliana Macedo Pinheiro' , 'inativo' , 'Rua Tucano'),
  132. ('02123011878' , '0007' , '0004' , '23416393000169' , '2000-08-10' , 'F' , 'solteiro' , 'ana.mari' , 'bb34','1783833' , 'Mariana Siqueira Jardim' , 'ativo' , 'Rua Lealberto Leal'),
  133. ('15141182894' , '0008' , '0001' , '23416393000114' , '2005-06-13' , 'F' , 'casado' , 'dudu.arda' , '1999' ,'2267700', 'Bernadete Maria da Silva' , 'ativo' , 'Rua Guajuvira'),
  134. ('33666472214' , '0009' , '0004' , '23416393000169' , '2011-03-01' , 'F' , 'solteiro', 'ana.belle' , 'AX6', '4137799','Anabelle Cristina Leal de Figueiredo' , 'ativo', 'Rua Manuel de Medeiros'),
  135. ('32568071001', '0010' , '0001' ,  '23416393000114' , '2010-09-26' , 'F' , 'casado' , 'bee.a' , '134N' ,    '4163131', 'Ana Beatriz Castanho Guedes' , 'ativo', 'Rua Jornalista Benedito Cunha'),
  136. ('45321186898' , '0011', '0004',   '23416393000169' , '2007-09-20', 'M' , 'solteiro' , 'alan.marq' , '0j7e','1557345','Allan Jose Malta de Souza' , 'inativo', ' Rua Projetada'),
  137. ('86147207504' , '0012' , '0004' , '23416393000169' , '2001-10-27' , 'F' , 'casado' , 'lelezinha' , '223d' ,'3217467', 'Leticia Santana Rodrigues' , 'ativo' , 'Rua Felipe Guerra'),
  138. ('85902755239' , '0013' , '0003' , '23416393000140' , '2005-11-14' , 'F' , 'solteiro' , 'mwd2', '1332',     '2437550', 'Gabriela Amado Batista', 'ativo', 'Rua da Palma'),
  139. ('14073416260' , '0014' , '0002' , '23416393000114', '2000-02-14', 'F' , 'casado', 'mumu321', '9901',       '1190089','Jadiane Matoso dos Santos', 'ativo', 'Rua Real da Torre'),
  140. ('32970753502', '0015' , '0002' ,  '23416393000114' , '2013-01-10', 'F' , 'solteiro' , 'JH10' , '1132' ,    '2422874', 'Viviane Mendonca do Nascimento', 'ativo', 'Rua da Harmonia'),
  141. ('88356795591' , '0016' , '0003' , '23416393000140' , '2012-06-10', 'M' , 'casado', '991jj', '1233',        '1316411', 'Ronaldo Fagundes da Silva' , 'ativo', 'Rua da Praia');
  142.  
  143.  
  144.  
  145.  -- inserindo valores para estoquista
  146.  
  147. INSERT INTO estoquista (CPF) VALUES
  148.  
  149. ('77491222226'),
  150. ('98243208909'),
  151. ('57859332507'),
  152. ('16565525749');
  153.  
  154.  
  155.  -- inserindo valores para dba
  156.  
  157. INSERT INTO DBA (CPF) VALUES
  158.  
  159. ('45321186898');
  160.  
  161.  
  162.  
  163. -- inserindo valores para gerente
  164.  
  165. INSERT INTO gerente (CPF) VALUES
  166.  
  167. ('96202875763'),
  168. ('02123011878'),
  169. ('15141182894'),
  170. ('57325297050');
  171.  
  172.  
  173. -- inserindo valores na tabela entregador
  174.  
  175. INSERT INTO entregador (CPF) VALUES
  176.  
  177. ( '33666472214'),
  178. ('86147207504'),
  179. ('32970753502'),
  180. ('32568071001');
  181.  
  182.  
  183.  
  184. -- inserindo valotes na tabela supervisorestoque
  185.  
  186. INSERT INTO supervisorestoque (CPF) VALUES
  187.  
  188. ('14073416260'),
  189. ('85902755239' ),
  190. ('88356795591');
  191.  
  192.  
  193. -- inserindo valores na tabela de telefone_funcionario
  194.  
  195. INSERT INTO telefone_funcionario ( CPF, telefone ) VALUES
  196.  
  197. ('14073416260' , '08133552321'),
  198. ('85902755239' , '08132324567'),
  199. ('88356795591', '08131311111'),
  200. ('32568071001', '08134587831'),
  201. ('32970753502', '08132324502'),
  202. ('32970753502' , '08191912343'),
  203. ('33666472214' , '08199096532'),
  204. ('86147207504', '08132732100'),
  205. ('96202875763' , '08199690359');
  206.  
  207.  
  208.  
  209. -- inserindo valores na tabela de notificacao
  210.  
  211. INSERT INTO notificacao (id, cpf_fun, dia, descricao) VALUES
  212.  
  213. ('2940' , '33666472214' , '2014-02-26' , NULL),
  214. ('2941' , '86147207504' , '2015-03-06' , NULL),
  215. ('2942' , '32970753502' , '2015-06-02' , NULL),
  216. ('2943' , '33666472214' , '2014-07-20' , NULL),  
  217. ('2944' , '33666472214' , '2014-07-20' , NULL),
  218. ('2945' , '16565525749' , '2014-02-12' , NULL),
  219. ('2946' , '33666472214' , '2015-03-06' , NULL),
  220. ('2947' , '33666472214' , '2015-06-02' , NULL),
  221. ('2948' , '77491222226' , '2014-07-20' , NULL),
  222. ('2949' , '88356795591' , '2014-07-20' , NULL),
  223. ('2950' , '45321186898' , '2014-07-20' , NULL),
  224. ('2951' , '86147207504' , '2014-02-10' , NULL);
  225.  
  226.  
  227. -- inserindo dados para notif_multa
  228.  
  229. INSERT INTO notif_multa (id , pontos_cnh, valor, cep, complemento) VALUES
  230.  
  231. ('2940',  3 , 58.50 , 50789123 , 'Rua da Aurora'),
  232. ('2941' ,4 , 198.50 , 54330315 , 'Rua Itacuruba'),
  233. ('2942' , 5 , 398.50 , 54315330 , 'Rua verdejantes');
  234.  
  235.  
  236. -- inserindo dados para notif_advertencia
  237.  
  238. INSERT INTO notif_advertencia (id, descricao ) VALUES
  239.  
  240. ('2943' , NULL),
  241. ('2944' , NULL),
  242. ('2945' , NULL);
  243.  
  244. -- inseindo dados para notif_suspensao
  245.  
  246. INSERT INTO notif_suspensao ( id , data_inicio , data_termino ) VALUES
  247.  
  248. ('2946' , '2015-06-02' , '2015-06-04' ),
  249. ('2947' , '2015-08-20' , '2015-08-23'  ),
  250. ('2948' , '2015-09-10' , '2015-09-13'  );
  251.  
  252.  
  253.  
  254.  -- inserindo valores para notif_falta
  255.  
  256. INSERT INTO notif_falta ( id , dia , duracao ) VALUES
  257.  
  258. ('2949' , '2015-06-01' , 3),
  259. ('2950' , '2015-08-19' , 2 ),
  260. ('2951' , '2015-09-09' , 2);
  261.  
  262.  
  263. -- insenrindo valores na tabela ferias
  264.  
  265. INSERT INTO ferias (id , cpf_fun , numero_dias , seq , data_inicio , data_fim) VALUES
  266.  
  267. ( '2340' , '96202875763' , 20 , '0001' , '2016-06-02' , '2016-06-22' ),
  268. ( '2341' , '32970753502' , 20 , '0002' , '2016-06-02' , '2016-06-22' ),
  269. ( '2342' , '45321186898' , 20 , '0003' , '2016-01-02' , '2016-01-22' ),
  270. ( '2343' , '57859332507' , 20 , '0004' , '2016-01-02' , '2016-01-22' ),
  271. ( '2344' , '14073416260' , 20 , '0005' , '2016-04-02' , '2016-04-22' );
  272.  
  273.  
  274. -- inserindo valores na tabela contracheque
  275.  
  276. INSERT INTO contracheque (mes_referencia , CPF, data_pagamento , valor_bruto, valor_liqd, valor_desconto) VALUES
  277.  
  278. ('02', '96202875763' , '2017-02-15', 3250.30, 3237.68 , 12.32),
  279. ('03' , '96202875763', '2017-03-15' , 3250.30,  3237.68, 12.32),
  280. ('05' , '45321186898' , '2017-05-15' , 8720.55,8708.8, 11.75),
  281. ('01' , '57325297050' , '2017-01-15' , 5956.00, 5942.00 , 14.00),
  282. ('03' , '85902755239' ,'2017-03-15', 4567.32 , 4553.32 , 14.00),
  283. ('08' , '85902755239' , '2017-08-15',4567.32 , 4553.32 , 14.00),
  284. ('01', '96202875763' , '2017-01-15', 3250.30, 3237.68 , 12.32),
  285. ('11' , '45321186898' , '2017-11-15' , 8720.55,8708.8, 11.75),
  286. ('07' , '45321186898' , '2017-07-15' , 8720.55,8708.8, 11.75),
  287. ('04' , '45321186898' , '2017-04-15' , 8720.55,8708.8, 11.75),
  288. ('04' , '02123011878' , '2017-04-15' ,4567.32 , 4553.32, 14.00),
  289. ('05' ,'86147207504', '2016-05-16' , 3250.30, 3237.68 , 12.32);
  290.  
  291.  
  292.  
  293.  -- inserindo valores na tabela de entrega
  294.  
  295. INSERT INTO entrega ( seq , CPF_entregador , data_entrega , hora_estimada ) VALUES
  296.  
  297. ('0001' , '33666472214' , '2016-04-09 ' , '07:30:00'),
  298. ('0002' , '33666472214' , '2016-04-09 ' , '19:45:00'),
  299. ('0003' , '33666472214' , '2016-04-09 ' , '18:00:00'),
  300. ('0004' , '33666472214' , '2016-04-09 ' , '09:30:00'),
  301. ('0005' , '33666472214' , '2016-04-09 ' , '13:30:00'),
  302. ('0006' , '86147207504' , '2016-04-02 ' , '06:30:00'),
  303. ('0007' , '86147207504' , '2016-04-02 ' , '11:45:00'),
  304. ('0008' , '86147207504' , '2016-04-02 ' , '14:00:00'),
  305. ('0009' , '86147207504' , '2016-04-02 ' , '015:30:00'),
  306. ('0010' , '86147207504' , '2016-04-02 ' , '14:30:00');
  307.  
  308.  
  309. -- inserindo valores na tabela de compra
  310.  
  311. INSERT INTO compra ( cod , seq_entrega , valor_total , dia , valor_total_desconto , statos ) VALUES
  312.  
  313. ('0001' , '0001 ' , 693 , '2016-04-09 ' , 0 , true ),
  314. ('0002' , '0002 ' , 789 , '2016-04-09 ' , 23.4 , true ),
  315. ('0003' , '0003 ' , 403 , '2016-04-09 ' , 4.2 , true ),
  316. ('0004' , '0004 ' , 233 , '2016-04-09 ' , 0 , true ),
  317. ('0005' , '0005 ' , 70  , '2016-04-09 ' , 0 , true ),
  318. ('0006' , '0006 ' , 2020 , '2016-04-02  ' , 20.2 , true ),
  319. ('0007' , '0007 ' , 400 , '2016-04-02  ' , 0 , true ),
  320. ('0008' , '0008 ' , 121 , '2016-04-02 ' , 0 , true ),
  321. ('0009' , '0009 ' , 133 , '2016-04-02 ' , 3.2 , true ),
  322. ('0010' , '0010 ' , 154 , '2016-04-02 ' , 0 , true );
  323.  
  324.  
  325.  
  326. -- inserindo valores na tabela de compra comum
  327.  
  328. INSERT INTO compra_comum (cod ) VALUES
  329.  
  330. ('0001'),
  331. ('0003'),
  332. ('0005'),
  333. ('0006'),
  334. ('0008');
  335.  
  336.  
  337. -- inserindo valores na tabela de compra programada
  338.  
  339. INSERT INTO compra_programada (cod , data_1 , data2 , esta_ativa ) VALUES
  340.  
  341. ('0002' , '2016-04-09' , '2017-04-09' , true ),
  342. ('0004' , '2016-04-09' , '2017-01-09' , true ),
  343. ('0007' , '2016-04-02' , '2016-11-02' , true ),
  344. ('0009' , '2016-04-02' , '2017-02-02' , true ),
  345. ('0010' , '2016-04-02' , '2017-04-02' , true );
  346.  
  347.  
  348.  
  349. -- inserindo valores na tabela garagem
  350.  
  351. INSERT INTO garagem ( cod , seq_filial , CNPJ_matriz , descricao , capacidade , num_veiculos_atual ) VALUES
  352.  
  353. ( '0001' , '0001' ,  '23416393000114' , null , 4 , 2 ),
  354. ( '0002' , '0002' ,  '23416393000114' , null , 4 , 2 ),
  355. ( '0003' , '0003' ,  '23416393000140' , null , 4 , 2 ),
  356. ( '0004' , '0004' ,  '23416393000169' , null , 4 , 2 );
  357.  
  358.  
  359.  
  360. -- inserindo valores na tabela veiculo
  361.  
  362. INSERT INTO veiculo ( placa , seq_filial , CNPJ_matriz , cod_garagem , modelo , descricao , cor , ano , statuss ) VALUES
  363.  
  364. ( 'PEX0220 ' ,  '0001' ,  '23416393000114' , '0001' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  365. ( 'PEX2030 ' ,  '0001' ,  '23416393000114' , '0001' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  366. ( 'VET4320 ' ,  '0002' ,  '23416393000114' , '0002' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  367. ( 'VET3240 ' ,  '0002' ,  '23416393000114' , '0002' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  368. ( 'WCV0943'  ,  '0003' ,  '23416393000140' , '0003' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  369. ( 'WCV3344 ' ,  '0003' ,  '23416393000140' , '0003' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  370. ( 'HLT0032 ' ,  '0004' ,  '23416393000169' , '0004' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  371. ( 'HLT3994 ' ,  '0004' ,  '23416393000169' , '0004' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true);
  372.  
  373.  
  374.  
  375. -- inserindo valores na tabela estoque
  376.  
  377. INSERT INTO estoque ( id , seq_filial , cnpj_matriz , descricao , dt_ultima_entrada ) VALUES
  378.  
  379. ( '0001' , '0001' ,  '23416393000114' , null , '2018-01-04'),
  380. ( '0002' , '0002' ,  '23416393000114' , null , '2018-01-04'),
  381. ( '0003' , '0003' ,  '23416393000140' , null , '2018-01-04'),
  382. ( '0004' , '0004' ,  '23416393000169' , null , '2018-01-04');
  383.  
  384.  
  385.  
  386. -- inserindo valores na tabela maquina
  387.  
  388. INSERT INTO maquina ( id , id_estoque , id_operador , ano, combustivel , modelo , capacidade , elevavao_max ,
  389. garantia , tipo , comprimento ) VALUES
  390.  
  391. ( '0001' , '0001' , '77491222226' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  392. ( '0002' , '0002' , '57859332507' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  393. ( '0003' , '0003' , '16565525749' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  394. ( '0004' , '0004' , '98243208909' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 );
  395.  
  396.  
  397.  
  398. -- inserindo valores na tabela avaria
  399.  
  400. INSERT INTO avaria (id , causa , preco , obs ) VALUES
  401.  
  402. ('0001' , 'Queda' , 30 , null ),
  403. ('0002' , 'Queda' , 10 , null ),
  404. ('0003' , 'Queda' , 200 , null ),
  405. ('0004' , 'Queda' , 32.2 , null ),
  406. ('0005' , 'Queda' , 230 , null ),
  407. ('0006' , 'Queda' , 92.2 , null );
  408.  
  409.  
  410.  
  411. -- inserindo valores na tabela prateleira  
  412.  
  413. INSERT INTO prateleira ( codigo , altura , comprimento , posicao_nivel ) VALUES
  414.  
  415. ('0001' , 5 , 10 , 'A1' ),
  416. ('0002' , 5 , 10 , 'A2' ),
  417. ('0003' , 5 , 10 , 'A3' ),
  418. ('0004' , 5 , 10 , 'A4' ),
  419. ('0005' , 5 , 10 , 'A5' ),
  420. ('0006' , 5 , 10 , 'B1' ),
  421. ('0007' , 5 , 10 , 'B2' ),
  422. ('0008' , 5 , 10 , 'B3' ),
  423. ('0009' , 5 , 10 , 'B4' ),
  424. ('0010' , 5 , 10 , 'B5' ),
  425. ('0011' , 5 , 10 , 'C1' ),
  426. ('0012' , 5 , 10 , 'C2' ),
  427. ('0013' , 5 , 10 , 'C3' ),
  428. ('0014' , 5 , 10 , 'C4' ),
  429. ('0015' , 5 , 10 , 'C5' );
  430.  
  431.  
  432. -- inserindo valores na tabela NCM
  433.  
  434. INSERT INTO NCM ( id , descricao , cod_mercosul) VALUES
  435.  
  436. ('0001', ' ' , '000000001'),
  437. ('0002' , ' ' , '000000002'),
  438. ('0003' , ' ', '000000003'),
  439. ('0004' , ' ', '000000004'),
  440. ('0005', ' ' , '000000005');
  441.  
  442.  
  443. -- inserindo valores na tabela unidade  
  444.  
  445. INSERT INTO unidade (cod, descricao , sigla) VALUES
  446.  
  447. ('0001', 'quilogramas', 'kg'),
  448. ('0002' , 'mililitros', 'mL'),
  449. ('0003', 'gramas' , 'g'),
  450. ('0004', 'litros' , 'L'),
  451. ('0005', 'miligramas' , 'mg');
  452.  
  453.  
  454. -- inserindo valores na tabela categoria
  455.  
  456. INSERT INTO categoria ( cod , descricao ) VALUES
  457.  
  458. ('0001', 'Condimentos' ),
  459. ('0002' , 'Laticinios'),
  460. ('0003', 'HortiFruti'),
  461. ('0004' , 'Conservas'),
  462. ('0005', 'Limpeza'),
  463. ('0006' , 'Bebidas Alcoolicas'),
  464. ('0007' , 'Bebidas nao Alcoolicas'),
  465. ('0008' , 'Graos e Cereais');
  466.  
  467.  
  468.  
  469. -- inserindo valores na tabela subcategoria
  470.  
  471. INSERT INTO subcategoria ( cod , cod_categoria , descricao ) VALUES
  472.  
  473. ('0001' , '0001' , 'Vinagres'),
  474. ('0002' , '0001' , 'Temperos'),
  475. ('0003' , '0001' , 'Sal' ),
  476. ('0004' , '0001', 'Azeites'),
  477. ('0005' , '0001', 'Oleos'),
  478. ('0006' , '0001', 'Especiarias'),
  479. ('0007' , '0002', 'Leites'),
  480. ('0008' , '0002', 'Iogurtes'),
  481. ('0009' , '0002', 'Fermentados'),
  482. ('0010' , '0002', 'Queijos'),
  483. ('0011' , '0003', 'Ovos'),
  484. ('0012' , '0003', 'Frutas secas'),
  485. ('0013' , '0003', 'Legumes'),
  486. ('0014' , '0004' , 'Frutas'),
  487. ('0015' , '0004', 'Peixes'),
  488. ('0016' , '0004', 'Vegetais'),
  489. ('0017' , '0004', 'Cogumelos'),
  490. ('0018' , '0005', 'Detergente'),
  491. ('0019' , '0005', 'Desinfetante'),
  492. ('0020' , '0005', 'Sabao em po'),
  493. ('0021' , '0005', 'Sabao em barra'),
  494. ('0022' , '0005', 'Amaciante');
  495.  
  496.  
  497.  
  498. -- inserindo valores na tabela marca  
  499.  
  500. INSERT INTO marca ( cod , descricao ) VALUES
  501.  
  502. ('0001', 'Sadia'),
  503. ('0002' , 'Knorr'),
  504. ('0003' , 'Camponesa'),
  505. ('0004' , 'Kicaldo'),
  506. ('0005' , 'Vitarela'),
  507. ('0006' , 'Bauduco'),
  508. ('0007', 'OMO'),
  509. ('0008' , 'Dona Benta'),
  510. ('0009', 'Nestle');
  511.  
  512.  
  513. -- inserindo valores na tabela fornecedor
  514.  
  515. INSERT INTO fornecedor ( cod , nome , CNPJ , rua , bairro , CEP , estado , ativo ) VALUES
  516.  
  517. ('0001' , 'Sadia'     , '55274471000180' , 'Rua valadares' , 'ipsep', '54330315' , 'Pernambuco' , true ) ,
  518. ('0002' , 'Pampers'   , '26724671000180' , 'Rua cartomante' , 'ibura', '54202010' , 'Pernambuco' , true ) ,
  519. ('0003' , 'Vitarela'  , '21712241000162' , 'Rua maniac' , 'algodão', '54215322' , 'São paulo' , true ) ,
  520. ('0004' , 'Coca-cola' , '26804531000180' , 'Rua argola' , 'vale tinhaem ', '51215020' , 'Rio de janeiro' , true ) ,
  521. ('0005' , 'Helmans'   , '77411981000180' , 'Rua sartre' , 'gitacity ', '44650201' , 'São paulo' , true ),
  522. ('0006' , 'Bombril'   , '53686527000188' , 'Rua 3' , 'Varzea' , '50980320' , 'Pernambuco' , true );
  523.  
  524.  
  525.  
  526. -- inserindo valores na tabela telefone_fornecedor
  527.  
  528. INSERT INTO telefone_fornecedor (cod_fornecedor, telefone) VALUES
  529.  
  530. ('0001' , '8133115544'),
  531. ('0002' ,  '8133468952'),
  532. ('0003' , '1140025632'),
  533. ('0004', '1432456895'),
  534. ('0005', '1121452062');
  535.  
  536.  
  537. -- inserindo valores na tabela produto_ref
  538.  
  539. INSERT INTO produto_ref (cod, id_unidade , id_marca , id_ncm , id_categoria, id_subcategoria, id_fornecedor , qtd_estoque ,
  540.  ICMS , CST , preco_por_tabela , cod_barra , freq_pedido , descricao , qtd_min, qtd_total_estoque , preco_ult_compra) VALUES
  541.  
  542. ('0001' , '0001' , '0001', '0001' , '0001' , '0001' , '0001' , 30 , 4.5 , '00' , 8.69  , '0201254123151' ,  null , null , 3 , 80 , 8.20 ),
  543. ('0002' , '0001' , '0001', '0001' , '0001' , '0002' , '0001' , 31 , 1.1 , '00' , 3.69  , '0201223412341' ,  null , null , 3 , 81 , 8 ),
  544. ('0003' , '0001' , '0001', '0001' , '0001' , '0001' , '0001' , 32 , 1.4 , '00' , 4.69  , '0201254353434' ,  null , null , 3 , 82 , 7 ),
  545. ('0004' , '0001' , '0002', '0001' , '0001' , '0002' , '0002' , 33 , 2.4 , '00' , 5.69  , '0243453453453' ,  null , null , 3 , 83 , 6.20 ),
  546. ('0005' , '0005' , '0002', '0002' , '0001' , '0003' , '0002' , 34 , 3.7 , '00' , 6.69  , '0256523435134' ,  null , null , 3 , 84 , 5.20 ),
  547. ('0006' , '0002' , '0002', '0002' , '0001' , '0003' , '0002' , 35 , 1.7 , '00' , 7.69  , '3424343423434' ,  null , null , 3 , 85 , 8.20 ),
  548. ('0007' , '0002' , '0003', '0002' , '0001' , '0004' , '0003' , 36 , 4.8 , '00' , 8.69  , '0201545213412' ,  null , null , 3 , 86 , 9.20 ),
  549. ('0008' , '0002' , '0003', '0002' , '0001' , '0005' , '0003' , 37 , 4.7 , '00' , 21.69 , '0201265243565' ,  null , null , 3 , 87 , 7.20 ),
  550. ('0009' , '0002' , '0003', '0003' , '0001' , '0006' , '0003' , 38 , 5.4 , '00' , 10.69 , '0201256435453' ,  null , null , 3 , 88 , 1.20 ),
  551. ('0010' , '0005' , '0004', '0003' , '0001' , '0001' , '0004' , 39 , 9.3 , '00' , 69    , '0201250454544' ,  null , null , 3 , 89 , 82.20 ),
  552. ('0011' , '0003' , '0004', '0003' , '0001' , '0002' , '0004' , 20 , 7.1 , '00' , 23.69 , '0201254177575' ,  null , null , 3 , 90 , 2.20 ),
  553. ('0012' , '0003' , '0005', '0003' , '0002' , '0007' , '0004' , 30 , 6.4 , '00' , 8     , '0201254199997' ,  null , null , 3 , 99 , 3.20 ),
  554. ('0013' , '0003' , '0005', '0004' , '0002' , '0007' , '0005' , 40 , 1.5 , '00' , 0.69  , '0201255455555' ,  null , null , 3 , 98 , 8.20 ),
  555. ('0014' , '0003' , '0006', '0004' , '0002' , '0007' , '0005' , 50 , 3.4 , '00' , 2.69  , '0201254176777' ,  null , null , 3 , 97 , 99.20 ),
  556. ('0015' , '0005' , '0006', '0004' , '0002' , '0008' , '0005' , 70 , 7.9 , '00' , 3.69  , '0201254543543' ,  null , null , 3 , 96 , 20 ),
  557. ('0016' , '0004' , '0007', '0004' , '0002' , '0007' , '0006' , 50 , 4.2 , '00' , 4.69  , '0201256555555' ,  null , null , 3 , 95 , 12.20 ),
  558. ('0017' , '0004' , '0007', '0005' , '0002' , '0008' , '0006' , 30 , 6.3 , '00' , 8.69  , '0201255523151' ,  null , null , 3 , 94 , 20 ),
  559. ('0018' , '0004' , '0008', '0005' , '0002' , '0007' , '0006' , 60 , 5.2 , '00' , 89.69 , '0205465793151' ,  null , null , 3 , 93 , 21.20 ),
  560. ('0019' , '0004' , '0009', '0005' , '0002' , '0007' , '0006' , 40 , 7.1 , '00' , 87.69 , '0201888863151' ,  null , null , 3 , 92 , 23 ),
  561. ('0020' , '0005' , '0008', '0005' , '0002' , '0008' , '0006' , 57 , 4.1 , '00' , 46    , '0201999923151' ,  null , null , 3 , 91 , 42 );
  562.  
  563.  
  564.  
  565.  -- inserindo valores na tabela item_compra
  566.  
  567. INSERT INTO item_compra (cod_compra , cod_produto , quantidade , valor_desconto , valor_unitario ) VALUES
  568. ('0001' , '0001' , 3 , null , 8.69 ),
  569. ('0002' , '0001' , 5 , null , 8.69 ),
  570. ('0003' , '0001' , 8 , null , 8.69 ),
  571. ('0004' , '0003' , 5 , null , 4.69 ),
  572. ('0005' , '0004' , 2 , null , 5.69 ),
  573. ('0006' , '0005' , 4 , null , 6.69 ),
  574. ('0007' , '0006' , 5 , null , 7.69 ),
  575. ('0008' , '0007' , 4 , null , 8.69 );
  576.  
  577.  
  578. -- inserindo valores na tabela incidente
  579.  
  580. INSERT INTO incidente (cod , seq_entrega , dataa, relatorio , hora ) VALUES
  581.  
  582. ('0001' , '0003' , '2016-04-09 ' , ' Tentativa de assalto ' , '18:06:00' ),
  583. ('0002' , '0005' , '2016-04-09 ' , ' Tentativa de assalto ' , '13:34:00' ),
  584. ('0003' , '0006' , '2016-04-02 ' , ' Tentativa de assalto ' , '06:32:00' );
  585.  
  586.  
  587.  -- inserindo valores na tabela docs
  588.  
  589. INSERT INTO docs ( cod_incidente , docs ) VALUES
  590.  
  591. ( '0001', 'something' ) ,
  592. ('0002' , 'something' ) ,
  593. ('0003' , 'something');
  594.  
  595.  
  596.  -- inserindo valores na tabela tipo_pagamento  
  597.  
  598. INSERT INTO tipo_pagamento (cod, descricao ) VALUES
  599.  
  600. ('0001' , 'Boleto Bancario'),
  601. ('0002' , 'Cartao de Credito'),
  602. ('0003' , 'Cartao de Debito');
  603.  
  604.  
  605. -- inserindo valores na tabela pedido_fornecedor
  606.  
  607. INSERT INTO pedido_fornecedor ( cod, CPF_gerente , total_desconto , valor_total_IPI, CFOP, dia , statos, valor_frete ) VALUES
  608.  
  609. ('0001' , '96202875763' , 12380.00, 354.20 , '0001', '2017-12-09' , true , 12.90),
  610. ('0002', '96202875763' , 3456.40 , 123.20 , '0002', '2017-11-09' , true , 10.30),
  611. ('0003' , '96202875763' , 2280.25 , 220.00,'0003',  '2017-06-13', true , 28.50),
  612. ('0004' , '96202875763' , 12200.00, 123.99,'0004',  '2017-07-04', true , 9.89),
  613. ('0005' , '96202875763' , 990.00 , 19.89,  '0005',  '2016-12-09', true , 12.43),
  614. ('0006' , '96202875763' , 5660.00, 56.70 , '0006', '2015-08-27' , true , 6.98),
  615. ('0007' , '96202875763' , 2890.00 , 35.47 , '0007', '2016-04-12' , true , 10.20),
  616. ('0008' , '96202875763' , 1873.20 , 190.00 ,'0008' , '2017-01-04' , true , 8.33),
  617. ('0009' , '96202875763' , 2348.80, 111.10 , '0009' ,'2017-06-09' , true , 10.22),
  618. ('0010' , '02123011878' , 1300.00, 132.30 , '0010','2017-08-27' , true , 11.30);
  619.  
  620.  
  621. -- inserindo valores na tabela fatura
  622.  
  623. INSERT INTO fatura ( id , cod_pedido_fornecedor , data_vencimento , valor_pago_atual, valor_total_final ,
  624.  data_emissao , statos , data_paga , multa ) VALUES
  625.  
  626.  ('0001' , '0001', '2018-03-03' , 200.30 , 600 , '2017-11-13' , true , null , 0),
  627.  ('0002' , '0002', '2018-02-03' , 343 , 800 , '2017-11-17' , true , null , 0),
  628.  ('0003' , '0003', '2018-05-03' , 20.10 , 200 , '2017-11-16' , true , null , 0),
  629.  ('0004' , '0004', '2018-07-03' , 40 , 300 , '2017-12-20' , true , null , 0),
  630.  ('0005' , '0005', '2018-08-03' , 234 , 400 , '2018-01-13' , true , null , 0),
  631.  ('0006' , '0006', '2018-09-03' , 120 , 500 , '2017-11-22' , true , null , 0);
  632.  
  633.  
  634.  
  635. --  inserindo valores na tabela nota_fiscal
  636.  
  637. INSERT INTO nota_fiscal (NFE , ICMS , valor_total, valor_total_desconto, dia , valor_frete) VALUES
  638.  
  639. ('111111109' ,  0.04 , 143.98 , 139.90 , '2016-11-12' , 3.78),
  640. ('111111104' ,  0.06 , 35.80 , 35.80, '2017-10-21' , 7.90),
  641. ('111111113' ,  0.04 , 50.21 , 49.95 , '2012-03-27' , 10.32),
  642. ('111111105' ,  0.06 , 173.98, 173.98 , '2010-06-13' , 8.50),
  643. ('111111107' ,  0.02 , 50.43 , 50.43 , '2002-04-01' , 2.21),
  644. ('111111108' ,  0.03 , 283.10 , 279.50 , '2011-11-11' , 4.30),
  645. ('111111139' ,  0.02 , 123.54 , 111.20 , '2016-11-12' , 6.80),
  646. ('111111199' ,  0.02 , 12.99 , 12.99 , '2016-11-13' , 8.30),
  647. ('111111129' ,  0.03 , 346.10 , 336.10 , '2016-11-10' , 2.12);
  648.  
  649.  
  650.  
  651. -- inserindo valores na tabela pagamento
  652.  
  653. INSERT INTO pagamento ( cod, id_fatura ,cod_compra , cod_tipo_pagamento  , valor_pago , dia ,  statos, tipo_pagamento ) VALUES
  654.  
  655. ('0001', '0001' , '0001' , '0002' , 100 , '2017-11-03' , true , null ),  
  656. ('0002', '0002' , '0002' , '0001' , 80 , '2017-11-13' , true , null ),
  657. ('0003', '0003' , '0003' , '0002' , 200 , '2017-11-14' , true , null ),
  658. ('0004', '0004' , '0004' , '0002' , 49 , '2017-11-20' , true , null ),
  659. ('0005', '0005' , '0005' , '0003' , 90.20 , '2017-12-03' , true , null );
  660.  
  661.  
  662.  -- inserindo valores na tabela nota fiscal fornecedor
  663.  
  664. INSERT INTO nota_fiscal_fornecedor (NFE, cod_pagamento , CFOP , IPI ) VALUES
  665.  
  666. ('111111109' , '0001', '1100' , 5.4),
  667. ( '111111104' , '0002', '1100' , 6.4),
  668. ('111111113' ,  '0003', '1100' , 7.4),
  669. ( '111111105' , '0004' , '1100' , 3.2);
  670.  
  671.  
  672.  
  673. -- inserindo valores na tabela nota_fical_compra
  674.  
  675. INSERT INTO nota_fiscal_compra ( NFE , cod_pagamento ) VALUES
  676.  
  677. ('111111129' , '0001' ),
  678. ('111111107' , '0002' ),
  679. ('111111108' , '0003' ),
  680. ('111111139' , '0004' ),
  681. ('111111199' , '0005' );
  682.  
  683. -- inserindo valores na tabela cliente
  684.  
  685. INSERT INTO cliente ( CPF , seq_filial , cnpj_matriz ,cep, cidade, numero, descricao , valor_credito, p_nome , m_nome , u_nome, rg , senha , tem_clube_desconto , data_cadastro , email , data_nascimento) VALUES
  686.  
  687. ('54501233290' , '0001' , '23416393000114', '52291045' , 'Santo andre'  , '111' ,  'Rua Jaguaribara'         , 1200.00 , 'Melissa'  , 'Andreia'    , 'Nascimento', '1908234' , '3214'    , false , '2016-02-12' , 'manasc@gmail.com'            , '1999-06-13'),
  688. ('25251145314' , '0002' , '23416393000114', '50999321' , 'Sao bernardo' , '123' , 'Rua de Saão Bento'       , 0       , 'Marcos'   , 'Andre'      , 'Marques'   , '9123786' , 'xxx9'    , false , '2015-03-11' , 'marcossantos@hotmail.com'    , '1980-03-25' ),
  689. ('13345509287' , '0001' , '23416393000114', '50348567' , 'Sao caetano'  , '453' , 'Rua Real da Torre '       , 0       , 'Fatima'   , 'Caixias'    , 'Laffaiete' , '1866630' , '1233'    , false , '2017-02-11' , 'falcaix@gmail.com'           , '1972-09-09'),
  690. ('77658476358' , '0001' , '23416393000114', '63900435' , 'Sao bernardo' , '434' , 'Rua Chile'                , 0       , 'Renato'   , 'Murilo'     , 'Dias'      , '1266839' , '34g4'    , false , '2017-07-04' , 'murilodias@gmail.com'        , '1989-12-29'),
  691. ('50519774647' , '0002' , '23416393000114', '56332078' , 'Sao bernardo' ,  null , 'Rua Quarenta e Seis'      , 22.30   , 'Joaquim'  , 'Luiz'       , 'Campos'    , '2871019' , '88uh'    , true  , '2016-04-04' , 'uizjoaquim@hotmail.com'      , '1990-04-30'),
  692. ('79317880797' , '0001' , '23416393000114', '82600130' , 'Sao bernardo' , null  , 'Rua Bernardo Rosenmann'   , 0       , 'Alana'    , 'Rodrigues'  , 'Mello'     , '2368088' ,  '34f4'   , true  , '2016-09-11' , 'alana_rodriques@gmail.com'   , '1993-06-06'),
  693. ('52125191105' , '0002' , '23416393000114', '77820026' , 'Sao bernardo' , null  , 'Rua 16'                   , 0       , 'Luana'    , 'Barbosa'    , 'Pinto'     , '1994566' , '9jf4'    , true  , '2016-09-11' , 'luaninha_babrbosa@gmail.com' , '1996-06-06'),
  694. ('50130428361' , '0001' , '23416393000114', '77016638' , 'Sao bernardo' , null  , 'Quadra 509 Sul Alameda 7' , 0       , 'Agatha'   , 'Vasconcelos', 'Belarmino' , '4526174' , 'f56g'    , true  , '2016-03-04' , 'agatinha_bb@gmail.com'       , '1999-09-09'),
  695. ('96468793068' , '0001' , '23416393000114', '49069186' , 'Santo Andre'  , null  , 'Rua do Sol'               , 0       , 'Camila'   , 'Castro'     , 'Raimundo'  , '3199788' , 'kj004'   , true  , '2016-09-18' , 'camila_racastro@gmail.com'   , '1992-02-20'),
  696. ('16512268903' , '0002',  '23416393000114', '72876134' , 'Sao bernardo' , null  , 'Quadra 37'                , 23.33   , 'Valkiria' , 'Queiroz'    , 'Calado'    , '4241822' , 'kd3io4'  , true  , '2016-02-12' , 'valqueiros@outlook.com'      , '1960-03-07'),
  697. ('07617589689' , '0002' , '23416393000114', '89280577' , 'Sao bernardo' , null  , 'Rua Zanzibar'             , 0       , 'Angelica' , 'Meneses'    , 'da Silva'  , '4764955' , 'i4hfi4h' , false , '2017-02-05' , 'angelica_mene@outlook.com'   , '1992-12-11'),
  698.  
  699. ('54501212341' , '0004' , '23416393000169', '52291032' , 'Ipanema'      , '131' , 'Rua dreamer'              , 200.00  , 'Felissia' , 'Andreia'    , 'Nasciso'   , '1908312' , '3214'    , true  , '2016-02-12' , 'xxxxx@gmail.com'             , '1978-06-13'),
  700. ('25251444444' , '0004' , '23416393000169', '50999399' , 'Ipanema'      , '163' , 'Rua gastino'              , 123     , 'Maycomu'  , 'Andre'      , 'feliciano' , '9123321' , 'xxx9'    , true  , '2015-03-11' , 'yyyyy@hotmail.com'           , '1987-03-25' ),
  701. ('13345555555' , '0004' , '23416393000169', '50348577' , 'Ipanema'      , '543' , 'Rua malaneti'             , 214     , 'Fatima'   , 'Bernardes'  , 'Laffaiete' , '1864568' , '1233'    , false , '2017-02-11' , 'zzzzz@gmail.com'             , '1967-09-09'),
  702. ('77656666666' , '0004' , '23416393000169', '63900442' , 'Ipanema'      , '544' , 'Rua valadares'            , 54      , 'Renan'    , 'Murilo'     , 'Anos'      , '1264444' , '34g4'    , false , '2017-07-04' , 'hhhhh@gmail.com'             , '1989-12-29'),
  703. ('50519434234' , '0004' , '23416393000169', '56332011' , 'Ipanema'      , '003' , 'Rua noventa e sete'       , 22.30   , 'Joaquim'  , 'Nabuco'     , 'Oliveira'  , '2875412' , '88uh'    , true  , '2016-04-04' , 'jjjjj@hotmail.com'           , '1998-04-30'),
  704. ('79317887675' , '0004' , '23416393000169', '82600131' , 'Ipanema'      , null  , 'Rua Bernardo manoel'      , 0       , 'Alana'    , 'Guedes'     , 'Mello'     , '2364811' ,  '34f4'   , true  , '2016-09-11' , 'iiiii@gmail.com'             , '1976-06-06'),
  705. ('52125199997' , '0003' , '23416393000140', '77820021' , 'Recife'       , null  , 'Rua 16'                   , 21      , 'Valdemir' , 'Barbosa'    , 'Pinto'     , '1993333' , '9jf4'    , true  , '2016-09-11' , 'ppppp@gmail.com'             , '1956-06-06'),
  706. ('50130400000' , '0003' , '23416393000140', '77016614' , 'Recife'       , null  , 'Rua vital dos sonhos'     , 100     , 'Agatha'   , 'Cristh'     , 'Belarmino' , '4527777' , 'f56g'    , true  , '2016-03-04' , 'bbbbb@gmail.com'             , '1978-09-09'),
  707. ('96468754345' , '0003' , '23416393000140', '49069112' , 'Recife'       , null  , 'Rua nevermore'            , 0       , 'Camila'   , 'Fagundes'   , 'Nonato'    , '3194514' , 'kj004'   , true  , '2016-09-18' , 'ccccc@gmail.com'             , '1998-02-20'),
  708. ('16512211111' , '0003',  '23416393000140', '72876146' , 'Olinda'       , null  , 'Quadra 98'                , 20.33   , 'Marilia'  , 'Queiroz'    , 'Falado'    , '4241847' , 'kd3io4'  , true  , '2016-02-12' , 'aaaaa@outlook.com'           , '1978-03-07'),
  709. ('07617555555' , '0003' , '23416393000140', '89284561' , 'Olinda'       , null  , 'Rua gandalf'              , 0       , 'Diabolica', 'Meneses'    , 'da Cunha'  , '4764454' , 'i4hfi4h' , false , '2017-02-05' , 'mmmmm@outlook.com'           , '1997-12-11');
  710.  
  711.  
  712. -- inserindo valores na tabela telefone_cliente
  713.  
  714. INSERT INTO telefone_cliente ( CPF, telefone) VALUES
  715.  
  716.  ('54501233290' , '8134564432'),
  717.  ('25251145314' , '8199890765'),
  718.  ('77658476358' , '8599690359'),
  719.  ('07617589689' , '4899097820'),
  720.  ('07617589689' , '8191913012'),
  721.  ('96468793068' , '7934876650'),
  722.  ('96468793068' , '7988786534'),
  723.  ('50519774647' , '8133234567');
  724.  
  725.  
  726. -- inserindo valores na tabela sugestao
  727.  
  728. INSERT INTO  sugestao (CPF_cliente, id, dia , descricao) VALUES
  729.  
  730. ('54501233290' , '0001' , '2016-02-12' , 'mais entregadores'),
  731. ('54501233290' , '0002' , '2016-03-09' , 'mais entregadores'),
  732. ('54501233290' , '0003' , '2016-03-09' , 'mais entregadores'),
  733. ('54501233290' , '0004' , '2016-03-09' , 'mais entregadores'),
  734. ('54501233290' , '0005' , '2016-03-09' , 'mais entregadores'),
  735. ('54501233290' , '0006' , '2016-03-09' , 'mais entregadores'),
  736. ('54501233290' , '0007' , '2016-03-09' , 'mais entregadores'),
  737. ('54501233290' , '0008' , '2016-03-09' , 'mais entregadores'),
  738. ('54501233290' , '0009' , '2016-03-09' , 'mais entregadores');
  739.  
  740.  
  741.  
  742. -- inserindo valores na tabela reclamacao
  743.  
  744. INSERT INTO reclamacao ( CPF_cliente , id , motivo, data_ocorrido, data_reclamacao) VALUES
  745.  
  746. ('54501233290' , '0001' , 'atendimento demorado', '2016-03-09' , '2016-03-13'),
  747. ('54501233290' , '0002' , 'perto de vencer', '2016-03-09' , '2016-03-13'),
  748. ('54501233290' , '0003' , 'o entregador nao chegou', '2016-03-01' , '2016-03-20'),
  749. ('54501233290' , '0004' , 'erraram o endereco de entrega', '2016-03-09' , '2016-03-13'),
  750. ('54501233290' , '0005' , 'atendimento muito demorado', '2016-03-09' , '2016-03-10'),
  751. ('54501233290' , '0006' , 'site fora do ar', '2016-04-01' , '2016-04-01'),
  752. ('54501233290' , '0007' , 'atendimento muito demorado', '2016-03-09' , '2016-03-13');
  753.  
  754.  
  755.  
  756. -- inserindo valores na tabela promocao
  757.  
  758. INSERT INTO promocao (cod, seq_filial , cnpj_matriz , nome , data_inicio, percentual_reducao , data_fim, obs, descricao) VALUES
  759.  
  760. ('0001' , '0001 ',  '23416393000114', 'Um barato no pedaco' , '2017-02-05', 0.13 , '2017-03-05' , 'n inclui importados' , 'promocao para laticinios'),
  761. ('0002' , '0001' ,  '23416393000114', 'Queima de estoque' , '2016-12-22' , 0.33 , '2016-12-31' , NULL , NULL),
  762. ('0003' , '0002',  '23416393000114','Mes da verdura' , '2017-08-12' , 0.26 , '2017-10-12' , 'n inclui conservas' , 'promocao para hortifruti' ),
  763. ('0004' , '0002' ,  '23416393000114', 'Mes da conserva' , '2017-11-20' , 0.21 , '2017-12-20', NULL , 'apenas conservas' ),
  764. ('0005 ', '0001' , '23416393000114', 'Desinfetantes em queima' , '2018-01-02' , 0.24 , '2018-02-02' , NULL , 'apenas desinfetantes'),
  765. ('0006' , '0002' , '23416393000114', 'Promocao de amaciante' , '2017-09-15' , 0.12, '2017-11-15' , NULL , 'amaciantes nacionais'),
  766. ('0007' , '0001' , '23416393000114', 'Laticinios vao a loucura' , '2018-01-02', 0.29, '2018-03-02' , NULL , 'reducao de preco laticinios'),
  767. ('0008' , '0002' ,  '23416393000114','Promocao de Sabao em po' , '2017-06-15' , 0.19 , '2017-07-15' , NULL , 'promocao sabao em po');
  768.  
  769.  
  770.  
  771. -- inserindo valores na tabela item pedido
  772.  
  773. INSERT INTO item_pedido (seq , cod_produto_ref , cod_pedido_fornecedor, quantidade , preco_unitario) VALUES
  774.  
  775. ('0001' , '0001' ,'0001' , 10 , 10.4),
  776. ('0002' , '0002' ,'0002' , 5 , 4.60),
  777. ('0003' , '0003' ,'0003' , 40 , 5.44),
  778. ('0004' , '0004' ,'0004' , 12 , 4.41),
  779. ('0005' , '0005' ,'0005' , 7 , 6.43),
  780. ('0006' , '0006' ,'0006' , 9 , 7.2),
  781. ('0007' , '0007' ,'0007' , 3 , 8.3),
  782. ('0008' , '0008' ,'0008' , 5 , 9);
  783.  
  784.  
  785.  
  786. -- inserindo valores na tabela lote
  787.  
  788. INSERT INTO lote ( cod, cod_pedido_fornecedor, descricao , data_chegada) VALUES
  789.  
  790. ( '0001' , '0001', 'Lote de coca-cola ' , '2017-03-03' ),
  791. ( '0002' , '0002', 'Lote de pepsi ' , '2017-03-20' ),
  792. ( '0003' , '0003', 'Lote de margarina deline ' , '2017-05-03' ),
  793. ( '0004' , '0004', 'Lote de açucar pretinho ' , '2017-02-03' ),
  794. ( '0005' , '0005', null , '2017-04-03' );
  795.  
  796.  
  797. -- inserindo valores na tabela item_estoque
  798.  
  799. INSERT INTO item_estoque (cod_lote, id_estoque , cod_produto , id_avaria , id_prateleira , data_validade ,
  800.  data_fabricacao , data_entrada , valor_compra, quantidade)  VALUES
  801.  
  802.  ('0001' , '0001' , '0001' , null , '0001', '2018-04-04' , '2018-01-10' , '2018-01-14' , 60.30 , 8 ),
  803.  ('0002' , '0001' , '0002' , null , '0010', '2018-03-04' , '2018-01-04' , '2018-01-14' , 200 , 20 ),
  804.  ('0003' , '0002' , '0003' , null , '0006', '2018-04-05' , '2018-01-02' , '2018-01-14' , 43.70 , 10 ),
  805.  ('0004' , '0003' , '0004' , null , '0011', '2018-02-07' , '2018-01-10' , '2018-01-14' , 24.20 , 4 ),
  806.  ('0005' , '0004' , '0005' , null , '0013', '2018-01-01' , '2017-11-10' , '2018-01-14' , 90.32 , 12 );
  807.  
  808.  
  809.  
  810. -- inserindo valores na tabela perda
  811.  
  812. INSERT INTO perda ( seq , cod_lote, cod_produto, id_estoque, cpf_gerente , dia , quantidade_perdida , motivo) VALUES
  813. ( '0001' , '0001' , '0002', '0001' , null , '2018-03-04' , 2 , ' nao descoberto ' ),
  814. ( '0002' , '0003' , '0004', '0002' , null , '2018-03-06' , 6 , ' nao descoberto ' );
  815.  
  816.  
  817.  
  818. -- inserindo valores na tabela tem
  819.  
  820. INSERT INTO tem (id_jornada , id_turno, id_dia ) VALUES
  821.  
  822. ('0001' , '0001' , '0001' ),
  823. ('0001' , '0002' , '0002' ),
  824. ('0001' , '0003' , '0003' ),
  825. ('0001' , '0002' , '0004' ),
  826. ('0001' , '0002' , '0005' ),
  827. ('0001' , '0002' , '0006' ),
  828. ('0001' , '0001' , '0007' ),
  829. ('0002' , '0010' , '0001' ),
  830. ('0002' , '0006' , '0005' ),
  831. ('0003' , '0009' , '0006' ),
  832. ('0004' , '0001' , '0001' );
  833.  
  834.  
  835.  
  836. -- inserindo valores na tabela realiza_curso
  837.  
  838. INSERT INTO realizacurso ( cpf_fun , id_curso ,  dt_inicio , dt_fim) VALUES
  839.  
  840. ( '77491222226', '2101' , '2016-02-13' , '2016-03-15' ),
  841. ('77491222226' , '8012' , '2016-04-09' , '2016-06-09' ),
  842. ( '32568071001' , '2101' ,'2016-02-13' , '2016-03-15' ),
  843. ( '45321186898' , '8012' , '2016-04-09' , '2016-06-09' ),
  844. ('14073416260' , '8012' , '2016-04-09' , '2016-06-09' ),
  845. ( '88356795591' , '8012' , '2016-04-09' , '2016-06-09' );
  846.  
  847.  
  848.  
  849. -- inserindo valores na tabela gerencia_estoque
  850.  
  851. INSERT INTO gerencia_estoque (cpf_super_estoque, id_estoque , dt_fim, dt_inicio) VALUES
  852.  
  853. ('14073416260' , '0001' ,'2017-03-02' ,'2016-03-02'),
  854. ( '85902755239' , '0002' , '2017-04-15' , '2016-02-15'),
  855. ( '88356795591' , '0003' , '2016-01-01' , '2014-02-13'),
  856. ( '14073416260' , '0002 ' , '2013-06-22' , '2012-06-10'),
  857. ( '85902755239' , '0003'  ,'2017-09-02', '2016-01-02' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!