API tools faq
paste
Advertisement
11eimilia11

povo

11eimilia11
Jan 4th, 2018
154
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 19.19 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. */
  272.  
  273.  
  274.  
  275. -- inserindo valores na tabela de compra comum
  276.  
  277. INSERT INTO compra_comum ( id ) VALUES
  278.  
  279. ( '0001' ),
  280. ( '0003' ),
  281. ( '0005' ),
  282. ( '0006' ),
  283. ( '0008' );
  284.  
  285. -- inserindo valores na tabela de compra programada
  286.  
  287. INSERT INTO compra_programada ( id , date_1 , date2 , esta_ativa ) VALUES
  288.  
  289. ( '0002' , '2016-04-09 ' , '2017-04-09 ' , true ),
  290. ( '0004' , '2016-04-09 ' , '2017-01-09 ' , true ),
  291. ( '0007' , '2016-04-02 ' , '2016-11-02 ' , true ),
  292. ( '0009' , '2016-04-02 ' , '2017-02-02 ' , true ),
  293. ( '0010' , '2016-04-02 ' , '2017-04-02 ' , true );
  294.  
  295.  
  296.  
  297. INSERT INTO prateleira ( codigo , altura , comprimento , posicao_nivel ) VALUES
  298.  
  299. ('0001' , 5 , 10 , 'A1' ),
  300. ('0002' , 5 , 10 , 'A2' ),
  301. ('0003' , 5 , 10 , 'A3' ),
  302. ('0004' , 5 , 10 , 'A4' ),
  303. ('0005' , 5 , 10 , 'A5' ),
  304. ('0006' , 5 , 10 , 'B1' ),
  305. ('0007' , 5 , 10 , 'B2' ),
  306. ('0008' , 5 , 10 , 'B3' ),
  307. ('0009' , 5 , 10 , 'B4' ),
  308. ('0010' , 5 , 10 , 'B5' ),
  309. ('0011' , 5 , 10 , 'C1' ),
  310. ('0012' , 5 , 10 , 'C2' ),
  311. ('0013' , 5 , 10 , 'C3' ),
  312. ('0014' , 5 , 10 , 'C4' ),
  313. ('0015' , 5 , 10 , 'C5' );
  314.  
  315. INSERT INTO unidade (cod, descricao , sigla) VALUES
  316.  
  317. ('0001', 'quilogramas', 'kg'),
  318. ('0002' , 'mililitros', 'mL'),
  319. ('0003', 'gramas' , 'g'),
  320. ('0004', 'litros' , 'L'),
  321. ('0005', 'miligramas' , 'mg');
  322.  
  323. INSERT INTO NCM ( id , descricao , cod_mercosul) VALUES
  324.  
  325. ('0001', ' ' , '000000001'),
  326. ('0002' , ' ' , '000000002'),
  327. ('0003' , ' ', '000000003'),
  328. ('0004' , ' ', '000000004'),
  329. ('0005', ' ' , '000000005');
  330.  
  331. INSERT INTO marca ( cod , descricao ) VALUES
  332.  
  333. ('0001', 'Sadia'),
  334. ('0002' , 'Knorr'),
  335. ('0004' , 'Camponesa'),
  336. ('0005' , 'Kicaldo'),
  337. ('0006' , 'Vitarela'),
  338. ('0007' , 'Bauduco'),
  339. ('0008', 'OMO'),
  340. ('0009' , 'Dona Benta'),
  341. ('0010', 'Nestle');
  342.  
  343. INSERT INTO categoria ( cod , desricao ) VALUES
  344.  
  345. ('0001', 'Condimentos' ),
  346. ('0002' , 'Laticinios'),
  347. ('0003', 'HortiFruti'),
  348. ('0004' , 'Conservas'),
  349. ('0005', 'Limpeza'),
  350. ('0006' , 'Bebidas Alcoolicas'),
  351. ('0007' , 'Bebidas nao Alcoolicas'),
  352. ('0008' , 'Graos e Cereais');
  353.  
  354. INSERT INTO subcategoria ( cod , cod_categoria , descricao ) VALUES
  355.  
  356. ('0001' , '0001' , 'Vinagres'),
  357. ('0002' , '0001' , 'Temperos'),
  358. ('0003' , '0001' , 'Sal' ),
  359. ('0004' , '0001', 'Azeites'),
  360. ('0005' , '0001', 'Oleos'),
  361. ('0006' , '0001', 'Especiarias'),
  362. ('0007' , '0002', 'Leites'),
  363. ('0008' , '0002', 'Iogurtes'),
  364. ('0009' , '0002', 'Fermentados'),
  365. ('0010' , '0002', 'Queijos'),
  366. ('0011' , '0003', 'Ovos'),
  367. ('0012' , '0003', 'Frutas secas'),
  368. ('0013' , '0003', 'Legumes'),
  369. ('0014' , '0004' , 'Frutas'),
  370. ('0015' , '0004', 'Peixes'),
  371. ('0016' , '0004', 'Vegetais'),
  372. ('0017' , '0004', 'Cogumelos'),
  373. ('0018' , '0005', 'Detergente'),
  374. ('0019' , '0005', 'Desinfetante'),
  375. ('0020' , '0005', 'Sabao em po'),
  376. ('0021' , '0005', 'Sabao em barra'),
  377. ('0022' , '0005', 'Amaciante');
  378.  
  379.  
  380. -- inserindo valores na tabela fornecedor
  381.  
  382. INSERT INTO fornecedor ( cod , nome , CNPJ , rua , bairro , CEP , estado , ativo ) VALUES
  383. ('0001' , 'Sadia'     , '55274471000180' , 'rua valadares ' , 'ipsep ', '54330315' , 'Pernambuco' , true ) ,
  384. ('0002' , 'Pampers'   , '26724671000180' , 'rua cartomante ' , 'ibura', '54202010' , 'Pernambuco' , true ) ,
  385. ('0003' , 'Vitarela'  , '21712241000162' , 'rua maniac ' , 'algodão', '54215322' , 'São paulo' , true ) ,
  386. ('0004' , 'Coca-cola' , '26804531000180' , 'rua argola ' , 'vale tinhaem ', '51215020' , 'Rio de janeiro' , true ) ,
  387. ('0005' , 'Helmans'   , '77411981000180' , 'rua sartre ' , 'gitacity ', '44650201' , 'São paulo' , true );
  388.  
  389. -- inserindo valores na tabela telefone_fornecedor
  390.  
  391. INSERT INTO telefone_fornecedor ( cod_fornecedor , telefone) VALUES
  392.  
  393. ('0001' , '8133115544'),
  394. ('0002' , '8133468952'),
  395. ('0003' , '1140025632'),
  396. ('0004' , '1432456895'),
  397. ('0005' , '1121452062');
  398.  
  399. -- inserindo valores na tabela produto_ref
  400.  
  401. INSERT INTO produto_ref ( cod , id_unidade , id_marca , id_ncm, id_categoria, id_subcategoria , id_fornecedor, qtd_estoque,
  402. ICMS , CST , preco_por_tabela, cod_barra , freq_pedido, descricao , qtd_min, qtd_total_estoque, preco_ult_compra) VALUES
  403.  
  404. ('0001', '0001', '0001' , '0001', '0001' , '0002' , '0001' , 700, 0.13 , 'A93' , 15.75 , NULL , NULL ,  'Queijo Minas' , NULL ,
  405.  
  406. -- INSERT INTO item_compra ( cod_compra , cod_produto , seq , quantidade , valor_desconto , valor_unitario ) VALUES
  407.  
  408. -- ('0001
  409.  
  410.  
  411. INSERT INTO matriz( CNPJ , nomefantasia ) VALUES
  412.  
  413. ( '23416393000114' , 'ICBSP'),
  414. ( '23416393000140' , 'ICBPE'),
  415. ( '23416393000169' , 'ICBRJ');
  416.  
  417. -- inserindo valores na tabela telefone_matriz
  418.  
  419. INSERT INTO telefone_matriz ( CNPJ , telefone ) VALUES
  420.  
  421. ( '23416393000114' , '8133002432'),
  422. ( '23416393000114' , '8133002149'),
  423. ( '23416393000140' , '1133002932'),
  424. ( '23416393000140' , '1140443949'),
  425. ( '23416393000169' , '1433004732'),
  426. ( '23416393000169' , '1440002449');
  427.  
  428. -- inserindo valores na tabela filial
  429.  
  430. INSERT INTO filial ( seq , CNPJ_Matriz , CPF_gerente , endereco , qtd_func ) VALUES
  431.  
  432. ( '0001' ,  '23416393000114' , '96202875763' , 'Rua valtavares ' , 4 ),
  433. ( '0002' ,  '23416393000114' , '02123011878' , 'Rua alivetania ' , 4 ),
  434. ( '0003' ,  '23416393000140' , '15141182894' , 'Rua maranguape ' , 4 ),
  435. ( '0004' ,  '23416393000169' , '57325297050' , 'Rua fernigan ' , 4 );
  436.  
  437.  
  438. -- inserindo valores na tabela telefone_filial
  439.  
  440. INSERT INTO telefone_filial(seq_filial , CNPJ_Matriz , telefone ) VALUES
  441.  
  442. ( '0001' ,  '23416393000114' , '1133115021' ),
  443. ( '0002' ,  '23416393000114' , '1133505231' ),
  444. ( '0003' ,  '23416393000140' , '8143022151' ),
  445. ( '0004' ,  '23416393000169' , '1431205412' );
  446.  
  447. -- inserindo valores na tabela garagem
  448.  
  449. INSERT INTO garagem ( cod , seq_filial , CNPJ_matriz , descricao , capacidade , num_veiculos_atual ) VALUES
  450. ( '0001' , '0001' ,  '23416393000114' , null , 4 , 2 ),
  451. ( '0002' , '0002' ,  '23416393000114' , null , 4 , 2 ),
  452. ( '0003' , '0003' ,  '23416393000140' , null , 4 , 2 ),
  453. ( '0004' , '0004' ,  '23416393000169' , null , 4 , 2 );
  454.  
  455. -- inserindo valores na tabela veiculo
  456.  
  457. INSERT INTO veiculo ( placa , seq_filial , CNPJ_matriz , cod_garagem , modelo , descricao , cor , ano , statos ) VALUES
  458.  
  459. ( 'PEX0220 ' ,  '0001' ,  '23416393000114' , '0001' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  460. ( 'PEX2030 ' ,  '0001' ,  '23416393000114' , '0001' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  461. ( 'VET4320 ' ,  '0002' ,  '23416393000114' , '0002' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  462. ( 'VET3240 ' ,  '0002' ,  '23416393000114' , '0002' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  463. ( 'WCV0943'  ,  '0003' ,  '23416393000114' , '0003' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  464. ( 'WCV3344 ' ,  '0003' ,  '23416393000114' , '0003' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  465. ( 'HLT0032 ' ,  '0004' ,  '23416393000114' , '0004' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true),
  466. ( 'HLT3994 ' ,  '0004' ,  '23416393000114' , '0004' , 'Caminhão' , 'Mercedes-benz' , 'preto' , '2014' , true);
  467.  
  468.  
  469. -- inserindo valores na tabela estoque
  470.  
  471. INSERT INTO estoque ( id , seq_filial , cnpj_matriz , descricao , dt_ultima_entrada ) VALUES
  472.  
  473. ( '0000001' , '0001' ,  '23416393000114' , null , '2018-01-04'),
  474. ( '0000002' , '0002' ,  '23416393000114' , null , '2018-01-04'),
  475. ( '0000003' , '0003' ,  '23416393000140' , null , '2018-01-04'),
  476. ( '0000004' , '0004' ,  '23416393000169' , null , '2018-01-04');
  477.  
  478. -- inserindo valores na tabela maquina
  479.  
  480. INSERT INTO maquina ( id , id_estoque , id_operador , ano, combustivel , modelo , capacidade , elevavao_max ,
  481. garantia , tipo , comprimento ) VALUES
  482.  
  483. ( '0001' , '0000001' , '77491222226' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  484. ( '0002' , '0000002' , '57859332507' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  485. ( '0003' , '0000003' , '16565525749' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 ),
  486. ( '0004' , '0000004' , '98243208909' , '2014' , 'diesel', null , 600 , 5 , '2019-02-02' , 'empilhadeira' , 2.20 );
  487.  
  488. -- inserindo valores na tabela avaria
  489.  
  490. INSERT INTO avaria (id , causa , preco , obs ) VALUES
  491.  
  492. ('0001' , 'Queda' , 30 , null ),
  493. ('0002' , 'Queda' , 10 , null ),
  494. ('0003' , 'Queda' , 200 , null ),
  495. ('0004' , 'Queda' , 32.2 , null ),
  496. ('0005' , 'Queda' , 230 , null ),
  497. ('0006' , 'Queda' , 92.2 , null );
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!