API tools faq
paste
Advertisement
11eimilia11

versao 2

11eimilia11
Jan 4th, 2018
368
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 22.62 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 para funcionario
  24.  
  25. INSERT INTO funcionario (CPF, id_jornada, seq_filial, cnpj_matriz, data_admissao, sex, estado_civil, login, senha, RG, nome, situacao, endereco) VALUES
  26.  
  27. ('774   91222226' , '0598', '9903' ,  '08351501000124' , '2005-04-12' , 'F', 'solteiro' , 'helo.12' , '123' , '1259312' , 'Heloisa Macedo de Souza' , 'ativo' , 'Rua Eloy Monteiro Nunes'),
  28. ( '98243208909' , '0012' , '9903' ,'08351501000124' , '2007-07-25' , 'M' , 'casado' , 'Garza2019' , 'E3221' , '3654296' , 'Elias ChateauBriand Gomes' , 'inativo' , 'Avenida Paraíba'),
  29. ('57325297050' , '3232' , '1100' , '32164472000176', '2003-09-02', 'F', 'viuva' , 'Riggs642' , 'YM' , '4563573' , 'Maria Helena Rosendo' , 'ativo', 'Rua Pedro Viana Neto'),
  30. ('16565525749' , '5749' , '1100' , '32164472000176' , '2000-01-07', 'F', 'solteiro' , 'Eugene759' , 'XX133' , '2144770', 'Afrodite Bezerra das Flores' , 'ativo', 'Rua Amelia'),
  31. ('57859332507', '9234' , '1876' ,  '50754767000184' , '2016-02-02' , 'M' , 'solteiro' , 'TM1' , '98UJ' , '1555582' , 'Mauricio de Souza Carvalho' , 'ativo' , ' Rua da Concordia'),
  32. ('96202875763' , '8872' , '1876' , '50754767000184' , '2012-09-11' , 'F' , 'solteiro' , 'Juli.Alves' , '8900' , '3494135' , 'Juliana Macedo Pinheiro' , 'inativo' , 'Rua Tucano'),
  33. ('02123011878' , '1363' , '9103' , '08351501000124' , '2012-08-10' , 'M' , 'solteiro' , 'ana.mari' , 'bb34' , '1783833' , 'Mariana Siqueira Jardim' , 'ativo' , 'Rua Lealberto Leal'),
  34. ('15141182894' , '4571' , '9103' , '08351501000124' , '2013-06-13' , 'F' , 'casado' , 'dudu.arda' , '1999' ,'2267700', 'Bernadete Maria da Silva' , 'ativo' , 'Rua Guajuvira'),
  35. ('33666472214' , '9811' , '1100' , '32164472000176' , '2012-03-01' , 'F' , 'solteiro', 'ana.belle' , 'AX6','4137799','Anabelle Cristina Leal de Figueiredo' , 'ativo', 'Rua Manuel de Medeiros'),
  36. ('32568071001', '3192' , '2034' ,  '39438485000135' , '2017-09-26' , 'F' , 'casado' , 'bee.a' , '134N' ,'4163131', 'Ana Beatriz Castanho Guedes' , 'ativo', 'Rua Jornalista Benedito Cunha'),
  37. ('45321186898' , '1306', '9675',   '86660421000164' , '2017-09-20', 'M' , 'solteiro' , 'alan.marq' , '0j7e' , '1557345','Allan Jose Malta de Souza' , 'inativo', ' Rua Projetada'),
  38. ('86147207504' , '9732' , '1153' , '01764804000120' , '2016-10-27' , 'F' , 'casado' , 'lelezinha' , '223d' ,' 3217467', 'Leticia Santana Rodrigues' , 'ativo' , 'Rua Felipe Guerra'),
  39. ('85902755239' , '7415' , '1153' , '01764804000120' , '2012-11-14' , 'F' , 'solteiro' , 'mwd2', '1332','2437550', 'Gabriela Amado Batista', 'ativo', 'Rua da Palma'),
  40. ('14073416260' , '2155' , '1153' , '01764804000120', '2015-02-14', 'M' , 'casado', 'mumu321', '9901',' 1190089','Jadiane Matoso dos Santos', 'ativo', 'Rua Real da Torre'),
  41. ('32970753502', '2856' , '1876' ,  '50754767000184' , '2013-01-10', 'F' , 'solteiro' , 'JH10' , '1132' , ' 2422874', 'Viviane Mendonca do Nascimento', 'ativo', 'Rua da Harmonia'),
  42. ('88356795591' , '0987' , '1153' , '01764804000120' , '2012-06-10', 'M' , 'casado', '991jj', '1233','1316411', 'Ronaldo Fagundes da Silva' , 'ativo', 'Rua da Praia');
  43.  
  44. -- inserindo valores para gerente
  45.  
  46. INSERT INTO gerente (CPF) VALUES
  47.  
  48. ('96202875763'),
  49. ('02123011878'),
  50. ('15141182894'),
  51. ('57325297050');
  52.  
  53. -- inserindo valores para estoquista
  54.  
  55. INSERT INTO estoquista (CPF) VALUES
  56. ('77491222226'),
  57. ('98243208909'),
  58. ('57859332507'),
  59. ('16565525749');
  60.  
  61. -- inserindo valores para dba
  62.  
  63. INSERT INTO dba (CPF) VALUES
  64. ('45321186898');
  65.  
  66. -- inserindo valores na tabela entregador
  67.  
  68. INSERT INTO entregador (CPF) VALUES
  69. ('33666472214'),
  70. ('86147207504'),
  71. ('32970753502'),
  72. ('32568071001');
  73.  
  74. -- inserindo valotes na tabela supervisorestoque
  75.  
  76. INSERT INTO supervisorestoque (CPF) VALUES
  77.  
  78. ('14073416260'),
  79. ('85902755239' ),
  80. ('88356795591');
  81.  
  82. -- inserindo valores na tabela de telefone_funcionario
  83.  
  84. INSERT INTO telefone_funcionario ( CPF, telefone ) VALUES
  85.  
  86. ('14073416260' , '08133552321'),
  87. ('85902755239' , '08132324567'),
  88. ('88356795591', '08131311111'),
  89. ('32568071001', '08134587831'),
  90. ('32970753502', '08132324502'),
  91. ('32970753502' , '08191912343'),
  92. ('33666472214' , '08199096532'),
  93. ('86147207504', '08132732100'),
  94. ('96202875763' , '08199690359');
  95.  
  96. -- inserindo valores na tabela de notificacao
  97.  
  98. INSERT INTO notificacao (id, cpf_fun, dia, descricao) VALUES
  99.  
  100. ('2940' , '33666472214' , '2014-02-30' , NULL), -- ENTREGADOR
  101. ('2941' , '86147207504' , '2015-03-06' , NULL), -- ENTREGADOR
  102. ('2942' , '32970753502' , '2015-06-02' , NULL), -- ENTREGADOR
  103. ('2943' , '33666472214' , '2014-07-20' , NULL),  
  104. ('2944' , '33666472214' , '2014-07-20' , NULL),
  105. ('2945' , '16565525749' , '2014-02-30' , NULL),
  106. ('2946' , '33666472214' , '2015-03-06' , NULL),
  107. ('2947' , '33666472214' , '2015-06-02' , NULL),
  108. ('2948' , '77491222226' , '2014-07-20' , NULL),
  109. ('2949' , '88356795591' , '2014-07-20' , NULL),
  110. ('2950' , '45321186898' , '2014-07-20' , NULL),
  111. ('2951' , '86147207504' , '2014-02-30' , NULL);
  112.  
  113. -- inserindo dados para notif_multa
  114.  
  115. INSERT INTO notif_multa (id, pontos, valor, cep, complemento) VALUES
  116. ('2940' , 3 , 198.50 , 50789123 , 'Rua da Aurora'),
  117. ('2941' , 4 , 198.50 , 54330315 , 'Rua Itacuruba'),
  118. ('2942' , 5 , 198.50 , 54315330 , 'Rua verdejantes');
  119.  
  120.  
  121. -- inserindo dados para notif_advertencia
  122.  
  123. INSERT INTO notif_advertencia (id) VALUES
  124. ('2943'),
  125. ('2944'),
  126. ('2945');
  127.  
  128. -- inseindo dados para notif_suspensao
  129.  
  130. INSERT INTO notif_suspensao ( id , data_inicio , data_termino ) VALUES
  131.  
  132. ('2946 ' , '2015-06-02' , '2015-06-04'  ),
  133. ( '2947 ' , '2015-08-20' , '2015-08-23'  ),
  134. ( '2948 ' , '2015-09-10' , '2015-09-13'  );
  135.  
  136. -- inserindo valores para notif_falta
  137.  
  138. INSERT INTO notif_falta ( id , dia ) VALUES
  139.  
  140. (' 2949 ' , '2015-06-01' ),
  141. (' 2950 ' , '2015-08-19' ),
  142. (' 2951 ' , '2015-09-09' );
  143.  
  144. -- insenrindo valores na tabela ferias
  145.  
  146. INSERT INTO ferias (id , cpf_fun , numero_dias , seq , data_inicio , data_fim) VALUES
  147.  
  148. ( ' 2340 ' , ' 96202875763 ' , 20 , '0001 ' , ' 2016-06-02' , '2016-06-22' ),
  149. ( ' 2341 ' , ' 32970753502 ' , 20 , '0002 ' , ' 2016-06-02' , '2016-06-22' ),
  150. ( ' 2342 ' , ' 45321186898 ' , 20 , '0003 ' , ' 2016-01-02' , '2016-01-22' ),
  151. ( ' 2343 ' , ' 57859332507 ' , 20 , '0004 ' , ' 2016-01-02' , '2016-01-22' ),
  152. ( ' 2344 ' , ' 14073416260 ' , 20 , '0005 ' , ' 2016-04-02' , '2016-04-22' );
  153.  
  154. -- inserindo valores na tabela contracheque
  155.  
  156. INSERT INTO contracheque (mes_referencia , CPF, data_pagamento , valor_bruto, valor_liqd, valor_desconto) VALUES
  157.  
  158. ('02', '96202875763' , '2017-02-15', 3250.30, 3237.68 , 12.32),
  159. ('03' , '96202875763', '2017-03-15' , 3250.30,  3237.68, 12.32),
  160. ('05' , '45321186898' , '2017-05-15' , 8720.55,8708.8, 11.75),
  161. ('01' , '57325297050' , '2017-01-15' , 5956.00, 5942.00 , 14.00),
  162. ('03' , '85902755239' ,'2017-03-15', 4567.32 , 4553.32 , 14.00),
  163. ('08' , '85902755239' , '2017-08-15',4567.32 , 4553.32 , 14.00),
  164. ('01', '96202875763' , '2017-01-15', 3250.30, 3237.68 , 12.32),
  165. ('11' , '45321186898' , '2017-11-15' , 8720.55,8708.8, 11.75),
  166. ('07' , '45321186898' , '2017-07-15' , 8720.55,8708.8, 11.75),
  167. ('04' , '45321186898' , '2017-04-15' , 8720.55,8708.8, 11.75),
  168. ('01' , '02123011878' , '2017-04-15' ,4567.32 , 4553.32, 14.00),
  169. ('05' ,'86147207504', '2016-05-16' , 3250.30, 3237.68 , 12.32);
  170.  
  171.  
  172. -- inserindo valores na tabela jornadatrabalho
  173.  
  174. INSERT INTO jornadatrabalho ( id , descricao , trabalha_sabado) VALUES
  175.  
  176. ('0598' , 'segunda a domingo' , true),
  177. ('0012' , NULL , false),
  178. ('3232' , 'trabalha feriados' , true),
  179. ('5749' , ' ' , true ),
  180. ('9234' , ' ' , false),
  181. ('8872' , ' ', false),
  182. ('1363' , 'trabalha feriados' , true),
  183. ('4571' , ' ' , true),
  184. ('9811' , ' ' , true),
  185. ('3192' , ' ', true ),
  186. ('1306' , ' ', true),
  187. ('9732', ' ', true),
  188. ('7415' , ' ' , true),
  189. ('2155', ' ' , true),
  190. ('2856' , ' ', true ),
  191. ('0987'  , ' ' , false);
  192.  
  193. -- inserindo valores na tabela de turno
  194.  
  195. INSERT INTO turno ( cod, descricao , hora_inicio, hora_fim ) VALUES
  196.  
  197. ('1102' , ' ' , '07:30:00' , '16:30:00'),
  198. ('35971' , ' ', '08:40:00' , '17:40:00'),
  199. ('1233' , ' ' , '07:00:00' , '14:00:00'),
  200. ('8503' , ' ' , '11:00:00' , '17:00:00'),
  201. ('6249' , ' ' , '14:00:00' , '18:30:00'),
  202. ('9191' , ' ' , '13:35:00' , '19:45:00'),
  203. ('2101' , ' ' , '7:30;00' , '12:30:00'),
  204. ('8736' , ' ' , '7:10:00' , '13:30:00'),
  205. ('3977' , ' ' , '18:00:00' , '23:55:00'),
  206. ('1309' , ' ' , '00:00:01' , '08:00:01');
  207.  
  208. -- inserindo valores na tabela de dia
  209.  
  210. INSERT INTO dia ( seq , descricao ) VALUES
  211.  
  212. ('0001' , ' segunda-feira' ),
  213. ('0002' , ' terça-feira' ),
  214. ('0003' , ' quarta-feira' ),
  215. ('0004' , ' quinta-feira' ),
  216. ('0005' , ' sexta-feira' ),
  217. ('0006' , ' sabado' ),
  218. ('0007' , ' domingo' );
  219.  
  220. -- inserindo valores na tabela de entrega
  221.  
  222. INSERT INTO entrega ( seq , CPF_entregador , data_entrega , hora_estimada ) VALUES
  223.  
  224. ('0001' , '33666472214' , '2016-04-09 ' , '07:30:00'),
  225. ('0002' , '33666472214' , '2016-04-09 ' , '19:45:00'),
  226. ('0003' , '33666472214' , '2016-04-09 ' , '18:00:00'),
  227. ('0004' , '33666472214' , '2016-04-09 ' , '09:30:00'),
  228. ('0005' , '33666472214' , '2016-04-09 ' , '13:30:00'),
  229. ('0006' , '86147207504' , '2016-04-02 ' , '06:30:00'),
  230. ('0007' , '86147207504' , '2016-04-02 ' , '11:45:00'),
  231. ('0008' , '86147207504' , '2016-04-02 ' , '14:00:00'),
  232. ('0009' , '86147207504' , '2016-04-02 ' , '015:30:00'),
  233. ('0010' , '86147207504' , '2016-04-02 ' , '14:30:00');
  234.  
  235. -- inserindo valores na tabela incidente
  236.  
  237. INSERT INTO incidente (cod , seq_entrega , dataa, relatorio , hora ) VALUES
  238.  
  239. ('0001' , '0003' , '2016-04-09 ' , ' Tentativa de assalto ' , '18:06:00' ),
  240. ('0002' , '0005' , '2016-04-09 ' , ' Tentativa de assalto ' , '13:34:00' ),
  241. ('0003' , '0006' , '2016-04-02 ' , ' Tentativa de assalto ' , '06:32:00' );
  242.  
  243. -- inserindo valores na tabela docs
  244.  
  245. INSERT INTO docs ( cod_incidente , docs ) VALUES
  246.  
  247. ('0001', null ) ,
  248. ('0002' , null ) ,
  249. ('0003' , null);
  250.  
  251.  
  252. -- inserindo valores na tabela de compra
  253.  
  254. INSERT INTO compra ( cod , seq_entrega , valor_total , dia , valor_total_desconto , statos ) VALUES
  255.  
  256. ('0001' , '0001 ' , 693 , '2016-04-09 ' , 0 , true ),
  257. ('0002' , '0002 ' , 789 , '2016-04-09 ' , 23.4 , true ),
  258. ('0003' , '0003 ' , 403 , '2016-04-09 ' , 4.2 , true ),
  259. ('0004' , '0004 ' , 233 , '2016-04-09 ' , 0 , true ),
  260. ('0005' , '0005 ' , 70  , '2016-04-09 ' , 0 , true ),
  261. ('0006' , '0006 ' , 2020 , '2016-04-02  ' , 20.2 , true ),
  262. ('0007' , '0007 ' , 400 , '2016-04-02  ' , 0 , true ),
  263. ('0008' , '0008 ' , 121 , '2016-04-02 ' , 0 , true ),
  264. ('0009' , '0009 ' , 133 , '2016-04-02 ' , 3.2 , true ),
  265. ('0010' , '0010 ' , 154 , '2016-04-02 ' , 0 , true );
  266.  
  267.  
  268.  
  269. INSERT INTO fatura (id , cod_pedido_fornecedor , data_vencimento , valor_pago_atual , valor_total_final,
  270. data_emissao , statos,  data_paga ,  multa ) VALUES
  271. ('0001' , '0001' , '2017-02-13' ,
  272.  
  273.  
  274.  
  275.  
  276.  
  277. -- inserindo valores na tabela de compra comum
  278.  
  279. INSERT INTO compra_comum ( id ) VALUES
  280.  
  281. ( '0001' ),
  282. ( '0003' ),
  283. ( '0005' ),
  284. ( '0006' ),
  285. ( '0008' );
  286.  
  287. -- inserindo valores na tabela de compra programada
  288.  
  289. INSERT INTO compra_programada ( id , date_1 , date2 , esta_ativa ) VALUES
  290.  
  291. ( '0002' , '2016-04-09 ' , '2017-04-09 ' , true ),
  292. ( '0004' , '2016-04-09 ' , '2017-01-09 ' , true ),
  293. ( '0007' , '2016-04-02 ' , '2016-11-02 ' , true ),
  294. ( '0009' , '2016-04-02 ' , '2017-02-02 ' , true ),
  295. ( '0010' , '2016-04-02 ' , '2017-04-02 ' , true );
  296.  
  297.  
  298.  
  299. INSERT INTO prateleira ( codigo , altura , comprimento , posicao_nivel ) VALUES
  300.  
  301. ('0001' , 5 , 10 , 'A1' ),
  302. ('0002' , 5 , 10 , 'A2' ),
  303. ('0003' , 5 , 10 , 'A3' ),
  304. ('0004' , 5 , 10 , 'A4' ),
  305. ('0005' , 5 , 10 , 'A5' ),
  306. ('0006' , 5 , 10 , 'B1' ),
  307. ('0007' , 5 , 10 , 'B2' ),
  308. ('0008' , 5 , 10 , 'B3' ),
  309. ('0009' , 5 , 10 , 'B4' ),
  310. ('0010' , 5 , 10 , 'B5' ),
  311. ('0011' , 5 , 10 , 'C1' ),
  312. ('0012' , 5 , 10 , 'C2' ),
  313. ('0013' , 5 , 10 , 'C3' ),
  314. ('0014' , 5 , 10 , 'C4' ),
  315. ('0015' , 5 , 10 , 'C5' );
  316.  
  317. INSERT INTO unidade (cod, descricao , sigla) VALUES
  318.  
  319. ('0001', 'quilogramas', 'kg'),
  320. ('0002' , 'mililitros', 'mL'),
  321. ('0003', 'gramas' , 'g'),
  322. ('0004', 'litros' , 'L'),
  323. ('0005', 'miligramas' , 'mg');
  324.  
  325. INSERT INTO NCM ( id , descricao , cod_mercosul) VALUES
  326.  
  327. ('0001', ' ' , '000000001'),
  328. ('0002' , ' ' , '000000002'),
  329. ('0003' , ' ', '000000003'),
  330. ('0004' , ' ', '000000004'),
  331. ('0005', ' ' , '000000005');
  332.  
  333. INSERT INTO marca ( cod , descricao ) VALUES
  334.  
  335. ('0001', 'Sadia'),
  336. ('0002' , 'Knorr'),
  337. ('0004' , 'Camponesa'),
  338. ('0005' , 'Kicaldo'),
  339. ('0006' , 'Vitarela'),
  340. ('0007' , 'Bauduco'),
  341. ('0008', 'OMO'),
  342. ('0009' , 'Dona Benta'),
  343. ('0010', 'Nestle');
  344.  
  345. INSERT INTO categoria ( cod , desricao ) VALUES
  346.  
  347. ('0001', 'Condimentos' ),
  348. ('0002' , 'Laticinios'),
  349. ('0003', 'HortiFruti'),
  350. ('0004' , 'Conservas'),
  351. ('0005', 'Limpeza'),
  352. ('0006' , 'Bebidas Alcoolicas'),
  353. ('0007' , 'Bebidas nao Alcoolicas'),
  354. ('0008' , 'Graos e Cereais');
  355.  
  356. INSERT INTO subcategoria ( cod , cod_categoria , descricao ) VALUES
  357.  
  358. ('0001' , '0001' , 'Vinagres'),
  359. ('0002' , '0001' , 'Temperos'),
  360. ('0003' , '0001' , 'Sal' ),
  361. ('0004' , '0001', 'Azeites'),
  362. ('0005' , '0001', 'Oleos'),
  363. ('0006' , '0001', 'Especiarias'),
  364. ('0007' , '0002', 'Leites'),
  365. ('0008' , '0002', 'Iogurtes'),
  366. ('0009' , '0002', 'Fermentados'),
  367. ('0010' , '0002', 'Queijos'),
  368. ('0011' , '0003', 'Ovos'),
  369. ('0012' , '0003', 'Frutas secas'),
  370. ('0013' , '0003', 'Legumes'),
  371. ('0014' , '0004' , 'Frutas'),
  372. ('0015' , '0004', 'Peixes'),
  373. ('0016' , '0004', 'Vegetais'),
  374. ('0017' , '0004', 'Cogumelos'),
  375. ('0018' , '0005', 'Detergente'),
  376. ('0019' , '0005', 'Desinfetante'),
  377. ('0020' , '0005', 'Sabao em po'),
  378. ('0021' , '0005', 'Sabao em barra'),
  379. ('0022' , '0005', 'Amaciante');
  380.  
  381.  
  382. -- inserindo valores na tabela fornecedor
  383.  
  384. INSERT INTO fornecedor ( cod , nome , CNPJ , rua , bairro , CEP , estado , ativo ) VALUES
  385. ('0001' , 'Sadia'     , '55274471000180' , 'rua valadares ' , 'ipsep ', '54330315' , 'Pernambuco' , true ) ,
  386. ('0002' , 'Pampers'   , '26724671000180' , 'rua cartomante ' , 'ibura', '54202010' , 'Pernambuco' , true ) ,
  387. ('0003' , 'Vitarela'  , '21712241000162' , 'rua maniac ' , 'algodão', '54215322' , 'São paulo' , true ) ,
  388. ('0004' , 'Coca-cola' , '26804531000180' , 'rua argola ' , 'vale tinhaem ', '51215020' , 'Rio de janeiro' , true ) ,
  389. ('0005' , 'Helmans'   , '77411981000180' , 'rua sartre ' , 'gitacity ', '44650201' , 'São paulo' , true );
  390.  
  391. -- inserindo valores na tabela telefone_fornecedor
  392.  
  393. INSERT INTO telefone_fornecedor ( cod_fornecedor , telefone) VALUES
  394.  
  395. ('0001' , '8133115544'),
  396. ('0002' , '8133468952'),
  397. ('0003' , '1140025632'),
  398. ('0004' , '1432456895'),
  399. ('0005' , '1121452062');
  400.  
  401. -- inserindo valores na tabela produto_ref
  402.  
  403. INSERT INTO produto_ref ( cod , id_unidade , id_marca , id_ncm, id_categoria, id_subcategoria , id_fornecedor, qtd_estoque,
  404. ICMS , CST , preco_por_tabela, cod_barra , freq_pedido, descricao , qtd_min, qtd_total_estoque, preco_ult_compra) VALUES
  405.  
  406. ('0001', '0001', '0001' , '0001', '0001' , '0002' , '0001' , 700, 0.13 , 'A93' , 15.75 , NULL , NULL ,  'Queijo Minas' , NULL ,
  407.  
  408. -- INSERT INTO item_compra ( cod_compra , cod_produto , seq , quantidade , valor_desconto , valor_unitario ) VALUES
  409.  
  410. -- ('0001
  411.  
  412.  
  413. INSERT INTO matriz( CNPJ , nomefantasia ) VALUES
  414.  
  415. ( '23416393000114' , 'ICBSP'),
  416. ( '23416393000140' , 'ICBPE'),
  417. ( '23416393000169' , 'ICBRJ');
  418.  
  419. -- inserindo valores na tabela telefone_matriz
  420.  
  421. INSERT INTO telefone_matriz ( CNPJ , telefone ) VALUES
  422.  
  423. ( '23416393000114' , '8133002432'),
  424. ( '23416393000114' , '8133002149'),
  425. ( '23416393000140' , '1133002932'),
  426. ( '23416393000140' , '1140443949'),
  427. ( '23416393000169' , '1433004732'),
  428. ( '23416393000169' , '1440002449');
  429.  
  430. -- inserindo valores na tabela filial
  431.  
  432. INSERT INTO filial ( seq , CNPJ_Matriz , CPF_gerente , endereco , qtd_func ) VALUES
  433.  
  434. ( '0001' ,  '23416393000114' , '96202875763' , 'Rua valtavares ' , 4 ),
  435. ( '0002' ,  '23416393000114' , '02123011878' , 'Rua alivetania ' , 4 ),
  436. ( '0003' ,  '23416393000140' , '15141182894' , 'Rua maranguape ' , 4 ),
  437. ( '0004' ,  '23416393000169' , '57325297050' , 'Rua fernigan ' , 4 );
  438.  
  439.  
  440. -- inserindo valores na tabela telefone_filial
  441.  
  442. INSERT INTO telefone_filial(seq_filial , CNPJ_Matriz , telefone ) VALUES
  443.  
  444. ( '0001' ,  '23416393000114' , '1133115021' ),
  445. ( '0002' ,  '23416393000114' , '1133505231' ),
  446. ( '0003' ,  '23416393000140' , '8143022151' ),
  447. ( '0004' ,  '23416393000169' , '1431205412' );
  448.  
  449. -- inserindo valores na tabela garagem
  450.  
  451. INSERT INTO garagem ( cod , seq_filial , CNPJ_matriz , descricao , capacidade , num_veiculos_atual ) VALUES
  452. ( '0001' , '0001' ,  '23416393000114' , null , 4 , 2 ),
  453. ( '0002' , '0002' ,  '23416393000114' , null , 4 , 2 ),
  454. ( '0003' , '0003' ,  '23416393000140' , null , 4 , 2 ),
  455. ( '0004' , '0004' ,  '23416393000169' , null , 4 , 2 );
  456.  
  457. -- inserindo valores na tabela veiculo
  458.  
  459. INSERT INTO veiculo ( placa , seq_filial , CNPJ_matriz , cod_garagem , modelo , descricao , cor , ano , statos ) VALUES
  460.  
  461. ( 'PEX0220 ' ,  '0001' ,  '23416393000114' , '0001' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  462. ( 'PEX2030 ' ,  '0001' ,  '23416393000114' , '0001' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  463. ( 'VET4320 ' ,  '0002' ,  '23416393000114' , '0002' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  464. ( 'VET3240 ' ,  '0002' ,  '23416393000114' , '0002' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  465. ( 'WCV0943'  ,  '0003' ,  '23416393000114' , '0003' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  466. ( 'WCV3344 ' ,  '0003' ,  '23416393000114' , '0003' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  467. ( 'HLT0032 ' ,  '0004' ,  '23416393000114' , '0004' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  468. ( 'HLT3994 ' ,  '0004' ,  '23416393000114' , '0004' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true);
  469.  
  470.  
  471. -- inserindo valores na tabela estoque
  472.  
  473. INSERT INTO estoque ( id , seq_filial , cnpj_matriz , descricao , dt_ultima_entrada ) VALUES
  474.  
  475. ( '0000001' , '0001' ,  '23416393000114' , null , '2018-01-04'),
  476. ( '0000002' , '0002' ,  '23416393000114' , null , '2018-01-04'),
  477. ( '0000003' , '0003' ,  '23416393000140' , null , '2018-01-04'),
  478. ( '0000004' , '0004' ,  '23416393000169' , null , '2018-01-04');
  479.  
  480. -- inserindo valores na tabela maquina
  481.  
  482. INSERT INTO maquina ( id , id_estoque , id_operador , ano, combustivel , modelo , capacidade , elevavao_max ,
  483. garantia , tipo , comprimento ) VALUES
  484.  
  485. ( '0001' , '0000001' , '77491222226' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  486. ( '0002' , '0000002' , '57859332507' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  487. ( '0003' , '0000003' , '16565525749' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  488. ( '0004' , '0000004' , '98243208909' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 );
  489.  
  490. -- inserindo valores na tabela avaria
  491.  
  492. INSERT INTO avaria (id , causa , preco , obs ) VALUES
  493.  
  494. ('0001' , 'Queda' , 30 , null ),
  495. ('0002' , 'Queda' , 10 , null ),
  496. ('0003' , 'Queda' , 200 , null ),
  497. ('0004' , 'Queda' , 32.2 , null ),
  498. ('0005' , 'Queda' , 230 , null ),
  499. ('0006' , 'Queda' , 92.2 , null );
  500.  
  501. INSERT INTO nota_fiscal (NFE , ICMS , valor_total, valor_total_desconto, dia , valor_frete) VALUES
  502.  
  503. ('111111109' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  504. ('111111104' ,  NULL , 35.80 , 35.80, '2017-10-21' , 7.90),
  505. ('111111105' ,  NULL , 50.21 , 49.95 , '2012-03-27' , 10.32),
  506. ('111111105' ,  NULL , 173.98, 173.98 , '2010-06-13' , 8.50),
  507. ('111111107' ,  NULL , 50.43 , 50.43 , '2002-04-01' , 2.21),
  508. ('111111108' ,  NULL , 283,10 , 279.50 , '2011-11-11' , 4.30),
  509. ('111111139' ,  NULL , 123.54 , 111.20 , '2016-11-12' , 6.80),
  510. ('111111199' ,  NULL , 12.99 , 12.99 , '2016-11-13' , 8.30),
  511. ('111111129' ,  NULL , 346.10 , 336.10 , '2016-11-10' , 2.12);
  512.  
  513. -- TABELA DE NOTA FISCAL FORNECEDOR INCOMPLETA
  514. INSERT INTO nota_fiscal_fornecedor (NFE, cod_pagamento , CFOP , IPI ) VALUES
  515.  
  516. ('111111109' ,   , 143.98 , 120 , '2016-11-12' , 3.78),
  517. ('111111104' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  518. ('111111105' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  519. ('111111145' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  520. ('111111184' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  521. ('111111110' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  522. ('111111133' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78),
  523. ('111111199' ,  NULL , 143.98 , 139.90 , '2016-11-12' , 3.78);
  524.  
  525.  
  526. INSERT INTO nota_fiscal_compra ( NFE , cod_pagamento) VALUES
  527.  
  528. ('111111109',
  529.  
  530. INSERT INTO pagamento ( cod, id_fatura ,cod_compra , cod_tipo_pagamento  , valor_pago , dia ,  statos, tipo_pagamento ) VALUES
  531. ('0001' ,
  532.  
  533. INSERT INTO entrega (seq , CPF_entregador , data_entrega, hora_estimada) VALUES
  534.  
  535. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  536. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  537. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  538. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  539. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  540. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  541. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  542. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  543. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' ),
  544. ('0001' , '33666472214' , '2017-11-04' , '13:30:00' );
  545.  
  546.  
  547. INSERT INTO cliente ( CPF , seq_filial , cep, cidade, numero, descricao , valor_credito, p_nome , m_nome , u_nome, rg , senha , tem_clube_desconto , data_cadastro , email , data_nascimento) VALUES
  548.  
  549. ('54501233290' , '0001' , '52291045' , 'Recife' , 13 ,  'Rua Jaguaribara' , 1200.00 , 'Melissa' , 'Andreia' , 'Nascimento', '9921', false , '2016-02-12', 'manasc@gmail.com' , '1999-06-13'),
  550. ('25251145314' , '0002'  );
  551.  
  552. INSERT INTO pedido_fornecedor ( cod, CPF_gerente , total_desconto , valor_total_IPI, dia , statos, valor_frete ) VALUES
  553.  
  554. ('0001' , '96202875763' , 12380.00, 354.20 , '2017-12-09' , true , 12.90),
  555. ('0002', '96202875763' , 3456.40 , 123.20 , '2017-11-09' , true , 10.30),
  556. ('0003' , '96202875763' , 2280.25 , 220.00, '2017-06-13', true , 28.50),
  557. ('0004' , '96202875763' , 12200.00, 123.99, '2017-07-04', true , 9.89),
  558. ('0005' , '96202875763' , 990.00 , 19.89, '2016-12-09', true , 12.43),
  559. ('0006' , '96202875763' , 5660.00, 56.70 , '2015-08-27' , true , 6.98),
  560. ('0007' , '96202875763' , 2890.00 , 35.47 , '2016-04-12' , true , 10.20),
  561. ('0008' , '96202875763' , 1873.20 , 190.00 , '2017-01-04' , true , 8.33),
  562. ('0009' , '96202875763' , 2348.80, 111.10 , '2017-06-09' , true , 10.22),
  563. ('0010' , '02123011878' , 1300.00, 132.30 , '2017-08-27' , true , 11.30);
  564.  
  565. INSERT INTO
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!