Jonas_3k

@ - Banco LanHouse com insert - @

Oct 24th, 2018
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 7.36 KB | None | 0 0
  1. create database unihouse;
  2. use unihouse;
  3. /*- Inserts completos -*/
  4. create table endereco(
  5.     ID_end      smallint primary key not null,
  6.     rua         varchar(30),
  7.     num_casa    smallint,
  8.     bairro      varchar(30),
  9.     cidade      varchar(30),
  10.     estado      varchar(3),
  11.     cep         int
  12. );
  13.  
  14. /*- inserts comletos-*/
  15. create table dispositivos(
  16.     id_disp     smallint primary key not null,
  17.     nome_disp   varchar(20),
  18.     ip_disp     varchar(20),
  19.     hora_ini    datetime,
  20.     hora_fim    datetime
  21. );
  22. /*- Inserts completos -*/
  23. create table banco(
  24.     cod_banco   smallint primary key not null,
  25.     nome        varchar(30)
  26. );
  27.  
  28. /*- Inserts completos -*/
  29. create table cartao(
  30.     ID_card     int primary key not null,
  31.     num_card    varchar(30),
  32.     validade    date,
  33.     cod_banco   smallint,
  34.     cod_agencia int,
  35.     cvv         smallint,
  36.     foreign key(cod_banco) references banco(cod_banco)
  37. );
  38. /*- Inserts completos-*/
  39. create table cliente(
  40.     cod_cliente int primary key not null,
  41.     cpf         varchar(20),
  42.     nome        varchar(30),
  43.     apelido     varchar(10),
  44.     email       varchar(50),
  45.     telefone    varchar(10),
  46.     ID_end      smallint,
  47.     ID_disp     smallint,
  48.     ID_card     int,
  49.     foreign key(ID_end) references endereco(ID_end),
  50.     foreign key(ID_disp) references dispositivos(ID_disp),
  51.     foreign key(ID_card) references cartao(ID_card)
  52. );
  53.  
  54. /*- Inserts completos-*/
  55. create table funcionario(
  56.     matricula   int primary key not null,
  57.     nome        varchar(30),
  58.     telefone    varchar(10),
  59.     ID_end      smallint,
  60.     foreign key(ID_end) references endereco(ID_end)
  61. );
  62.  
  63.  
  64.    
  65. /* -
  66.  * -        0000        000000000    000000000  0000000000000     00000000000000       0000000000
  67.  * -        0000      00000000000    000000000  0000     000000   00000000000000   00000000000000
  68.  * -                  0000           000        0000     0000000  00000000000000    000000
  69.  * -       0000000      0000000000   00000000   0000 0000000           00000          00000000000
  70.  * -        0000           0000000   00000000   00000 000000000        00000                00000000
  71.  * -        0000            000000   0000       00000    000000        00000                0000000
  72.  * -        0000          000000     000000000  00000    000000        00000            00000000
  73.  * -      00000000    0000000        000000000  00000    000000        00000        0000000000    
  74.  - */
  75.  
  76. insert into endereco values
  77.     (1,"Travessa Maravilha tristeza",85,"Jardim Boa vista","São paulo","SP",5576100),
  78.     (2,"Rua do corno",803,"São luiz","Maranhão","MA",65604450),
  79.     (3,"Rua Tapaxanas",4,"Diadema","São paulo","SP",16050063),
  80.     (4,"Rua deus te guarde",100,"Recife","Pernambuco","PE",55028490),
  81.     (5,"Rua borboletas psicodélicas",2800,"Centro","São paulo","SP",03311060),
  82.     (6,"Rua sessenta e nove",74,"Campo Grande","Rio de Janeiro","RJ",28894643),
  83.     (7,"Rua arthur broxado",337,"Macaé","Rio de Janeiro","RJ",24720270),  
  84.     (8,"Travessa Mário cinco paus",18,"Macaé","Rio de Janeiro","RJ",25926756),
  85.     (9,"Estrada pé do viado",723,"Itabaiana","Sergipe","SE",49009028),
  86.     (10,"Rua Eduardo Mukdese",4619,"Vila Mariana","Aparecida de Goiânia","GO",74938100),
  87.     (11,"Rua da feia",69,"Buzios","Rio de Janeiro","RJ",24474190),
  88.     (12,"Vila Sarmieri",89,"Centro","Nilópolis","RJ",26525750),
  89.     (13,"Rua das Pedras Preciosas",9,"Parque de Exposições","Parnamirim","RN",59146580),
  90.     (14,"Quadra CLS 409 Bloco D",409,"Asa Sul","Brasília","DF",70258540),
  91.     (15,"Rua Gonçalves Dias",77,"Mata de Itapera","São Luís","MA",65092134),
  92.     (16,"Rua do Contorno ",2,"Carrascal","Quixadá","CE",63902265),
  93.     (17,"Rua Tércio Rosado",69,"Aeroporto","Mossoró","RN",59607550),
  94.     (18,"Rua Manoel Anastácio",24,"Jardim Cibeli","Araranguá","SC",88901270),
  95.     (19,"Rua Professor Antônio Aleixo",684,"Jardim Vera Cruz","Anápolis","GO",75104770),
  96.     (20,"Rua Tucandeira",771,"Tarumã-Açu","Manaus","AM",69022362);
  97.    
  98.    
  99. insert into dispositivos values
  100.     (21,"ESTACAO01","192.168.1.1",'2018-08-11 10:18:0','2018-08-11 11:17:0'),
  101.     (22,"ESTACAO02","192.168.1.2",'2018-08-12 09:18:0','2018-08-12 12:13:0'),
  102.     (23,"ESTACAO03","192.168.1.3",'2018-08-13 08:18:0','2018-08-13 18:17:0'),
  103.     (24,"ESTACAO04","192.168.1.4",'2018-08-11 10:00:0','2018-08-11 10:58:0'),
  104.     (25,"ESTACAO05","192.168.1.5",'2018-08-11 17:01:0','2018-08-11 22:05:0'),
  105.     (26,"IMP01","192.168.1.6",'2018-08-11 10:18:5','2018-08-11 10:22:5'),
  106.     (27,"IMP02","192.168.1.7",'2018-08-13 08:18:0','2018-08-13 18:17:0'),
  107.     (28,"IMP03","192.168.1.8",'2018-08-11 10:18:5','2018-08-11 11:17:5'),
  108.     (29,"SCAN01","192.168.1.9",'2018-08-11 10:18:5','2018-08-11 11:17:5'),
  109.     (30,"SCAN02","192.168.1.10",'2018-08-13 08:18:0','2018-08-13 18:17:0');
  110.  
  111. insert into banco values
  112.     (1,"Banco do Brasil S.A"),
  113.     (33,"Banco Santander S.A"),
  114.     (237,"Banco Bradesco S.A"),
  115.     (341,"Itaú Unibanco S.A"),
  116.     (104,"Caixa Econômica Federal");
  117.    
  118. insert into cartao values
  119.     (50,"5475 2598 2300 1968",'2019-10-29',33,78998,759),
  120.     (51,"4576 3139 7940 9623",'2019-04-29',104,15015,307),
  121.     (52,"4389 3565 5025 8148",'2019-10-29',341,30814,963),
  122.     (53,"3551 8334 0824 4672",'2019-10-29',1,83013,443),
  123.     (54,"2014 6169 0571 3181",'2020-02-29',104,23012,626),
  124.     (55,"3422 7761 0533 7360",'2019-09-29',1,33011,665),
  125.     (56,"4916 8512 9678 1421",'2019-08-29',237,43010,361),
  126.     (57,"6011 0383 0658 5328",'2020-05-29',237,53317,759),
  127.     (58,"5260 0264 3154 2561",'2029-08-29',104,66014,394),
  128.     (59,"4556 6390 7959 6099",'2021-07-29',1,77013,709),
  129.     (60,"4716 5387 7956 2608",'2022-01-29',33,89012,539),
  130.     (61,"4223 7998 0096 8141",'2019-12-02',1,99816,975),
  131.     (62,"5269 4111 4539 4510",'2018-11-08',1,74134,100),
  132.     (63,"9168 5475 2598 2300",'2019-10-29',341,03014,222),
  133.     (64,"3033 627   302 6528",'2018-12-31',33,87014,333),
  134.     (65,"6011 0368 3650 5337",'2019-10-29',1,69017,759),
  135.     (66,"2149 966  2178 3357",'2020-10-29',341,37013,559),
  136.     (67,"4118 6091 3237 8927",'2021-10-29',33,70104,259),
  137.     (68,"4454 5245 5029 2827",'2025-10-29',341,83018,509),
  138.     (69,"4539 9620 4782 5230",'2031-10-29',237,50149,159);    
  139.    
  140.    
  141. insert into cliente values
  142.     (1,"190.923.760-43","Miguel Pereira Peixoto","Mipe","mppeixoto@unicarioca.edu.br","2222-0245",1,30,50),
  143.     (2,"406.483.760-60","Manuela Angel da Silveira","Manu","manu@unicarioca.edu.br","3352-0045",2,21,51),
  144.     (3,"571.180.680-71","Bernardo Santos","Mipe","bernardo@gmail.com","7232-5245",3,27,52),
  145.     (4,"360.743.350-01","Daniel Ferreira","gueta","daniel@unicarioca.edu.br","2211-4001",4,30,53),
  146.     (5,"590.965.150-13","Ana Julia","aninha","ana@unicentro.com.br","2882-5000",5,29,54),
  147.     (6,"101.341.990-14","Yudi Tamashiro","Preyx","yudi@sbt.com.br","4002-8922",6,23,55),
  148.     (7,"201.517.940-22","Rafaela Pereira","Faela","rafa@unicarioca.edu.br","2222-0245",7,25,56),
  149.     (8,"443.046.620-31","Benjamin Scrowisck","ben","bens@hotmail.com","3245-8744",8,26,57),
  150.     (9,"203.190.890-10","Maria Fernanda","mari","marife@unicarioca.edu.br","2217-1822",9,28,58),
  151.     (10,"693.824.370-02","João Gabrie","gabriel","joao@sentivale.ch","2874-0245",10,22,59);
  152.  
  153. insert into funcionario values
  154.     (4118,"Isaac Renato Moura",'2215-5463',11),
  155.     (6091,"Carlos Kauê Almeida",'3772-8877',12),
  156.     (3237,"Luís Kaique João Ribeiro",'2545-1364',13),
  157.     (8927,"Rita Heloisa Carvalho",'2759-7961',14),
  158.     (4916,"Alícia Camila da Silva",'2178-4112',15),
  159.     (4127,"Carla Luzia Eduarda Dias",'4004-8922',16),
  160.     (7636,"Emanuelly Betina da Mata",'3675-4412',17),
  161.     (9342,"César Hugo Vicente Carvalho",'3587-2019',18),
  162.     (1234,"Lucca Victor Breno Gomes",'2018-2017',19),
  163.     (4567,"Stefany Esther Farias",'2255-4788',20);
Add Comment
Please, Sign In to add comment