API tools faq
paste
OracyMartos

Untitled

OracyMartos
Dec 16th, 2018
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.53 KB | None | 0 0
raw download clone embed print report
  1. -- Insert Values in Esportes
  2. INSERT INTO Esportes
  3.     (`ID`, `Nome`)
  4. VALUES
  5.     (NULL, 'Futebol'),
  6.     (NULL, 'Basquete'),
  7.     (NULL, 'Tenis'),
  8.     (NULL, 'MMA');
  9.  
  10.  
  11.  
  12.  
  13. -- Insert Values in Ligas
  14. INSERT INTO Ligas
  15.     (`ID`, `Esporte_ID`, `Nome`, `Ano`)
  16. VALUES
  17.     (NULL, '1', 'Paulista', '2019'),
  18.     (NULL, '1', 'La Liga', '2019'),
  19.     (NULL, '2', 'NBA', '2019'),
  20.     (NULL, '4', 'UFC', '2019'),
  21.     (NULL, '4', 'Bellator', '2019'),
  22.     (NULL, '3', 'wimbledon', '2019');
  23.  
  24.  
  25.  
  26.  
  27. -- Insert Values in Rodadas
  28. INSERT INTO Rodadas
  29.     (`ID`, `Liga_ID`, `Rodada`)
  30. VALUES
  31.     (NULL, '1', '1'),
  32.     (NULL, '1', '2'),
  33.     (NULL, '1', '3'),
  34.     (NULL, '2', '1'),
  35.     (NULL, '2', '2'),
  36.     (NULL, '2', '3'),
  37.     (NULL, '3', '1'),
  38.     (NULL, '3', '2'),
  39.     (NULL, '3', '3'),
  40.     (NULL, '4', '215'),
  41.     (NULL, '4', '216'),
  42.     (NULL, '4', '217'),
  43.     (NULL, '5', '174'),
  44.     (NULL, '5', '175'),
  45.     (NULL, '5', '176'),
  46.     (NULL, '6', '1'),
  47.     (NULL, '6', '2'),
  48.     (NULL, '6', '3');
  49.  
  50.  
  51.  
  52.  
  53. -- Insert Values in Jogos
  54. INSERT INTO Jogos
  55.     (`ID`, `Rodada_ID`, `Oponente_1`, `Oponente_2`)
  56. VALUES
  57.     (NULL, '1', 'SAO', 'PAL'),
  58.     (NULL, '1', 'COR', 'SAN'),
  59.     (NULL, '2', 'PIR', 'BAU'),
  60.     (NULL, '2', 'SCA', 'MIR'),
  61.     (NULL, '3', 'BRA', 'NOV'),
  62.     (NULL, '3', 'ITU', 'OES'),
  63.     (NULL, '4', 'BAR', 'SEV'),
  64.     (NULL, '4', 'CVI', 'LEG'),
  65.     (NULL, '5', 'ATL', 'VAL'),
  66.     (NULL, '5', 'ESP', 'MAD'),
  67.     (NULL, '6', 'ATH', 'ALV'),
  68.     (NULL, '6', 'BET', 'GIR'),
  69.     (NULL, '7', 'UTAH', 'MIAMI'),
  70.     (NULL, '7', 'SACRAMENTO', 'MINNESOTA'),
  71.     (NULL, '8', 'GSW', 'TORONTO'),
  72.     (NULL, '8', 'HOU', 'LA'),
  73.     (NULL, '9', 'SAS', 'LAC'),
  74.     (NULL, '9', 'DAL', 'ATL'),
  75.     (NULL, '10', 'KevinLee', 'AlIaquinta'),
  76.     (NULL, '10', 'EdsonBarboza', 'DanHooker'),
  77.     (NULL, '11', 'RobFont', 'SergioPettis'),
  78.     (NULL, '11', 'JimMiller', 'CharlesOliveira'),
  79.     (NULL, '12', 'AndersonSilva', 'Chael'),
  80.     (NULL, '12', 'CrisCyborg', 'AmandaNunes'),
  81.     (NULL, '13', 'EddieAlvarez', 'MichaelChandler'),
  82.     (NULL, '13', 'NickNewell', 'BenAskren'),
  83.     (NULL, '14', 'DuduDantas', 'BibianoFernandes'),
  84.     (NULL, '14', 'ShinyaAoki', 'YushinOkami'),
  85.     (NULL, '15', 'TitoOrtiz', 'JonFitch'),
  86.     (NULL, '15', 'RousimarToquinho', 'AlexanderShlemenko'),
  87.     (NULL, '16', 'AlexanderZverev', 'JuanMartíndelPotro'),
  88.     (NULL, '16', 'NickKyrgios', 'SerenaWilliams'),
  89.     (NULL, '17', 'MariaSharapova', 'SimonaHalep'),
  90.     (NULL, '17', 'GaelMonfils', 'NovakDjokovic'),
  91.     (NULL, '18', 'NicolasJarry', 'JohnIsner'),
  92.     (NULL, '18', 'LeonardoMayer', 'StefanosTsitsipas');
  93.  
  94.  
  95.  
  96.  
  97. -- Insert Values in Apostadores
  98. INSERT INTO Apostadores
  99.     (`ID`, `Nome`, `CPF`, `Email`)
  100. VALUES
  101.     (NULL, 'Marcos', '12345678901', 'marcos@email.com'),
  102.     (NULL, 'Paulo', '12345678902', 'paulo@email.com'),
  103.     (NULL, 'Mariana', '12345678903', 'mariana@email.com'),
  104.     (NULL, 'Marcela', '12345678904', 'marcela@email.com'),
  105.     (NULL, 'Mario', '12345678905', 'mario@email.com'),
  106.     (NULL, 'Maria', '12345678906', 'maria@email.com');
  107.  
  108.  
  109.  
  110.  
  111. -- Insert Values in Contas
  112. INSERT INTO Contas
  113.     (`ID`, `Apostador_ID`, `Saldo`)
  114. VALUES
  115.     (NULL, '1', '700.00'),
  116.     (NULL, '2', '1000.00'),
  117.     (NULL, '3', '5000.00'),
  118.     (NULL, '4', '250.00'),
  119.     (NULL, '5', '365.00'),
  120.     (NULL, '6', '391.82');
  121.  
  122.  
  123.  
  124.  
  125. -- Insert Values in Apostas
  126. INSERT INTO Apostas
  127.     (`ID`, `Jogo_ID`, `Apostador_ID`, `Minha_Aposta`, `Valor_Apostado`, `Aposta_Finalizada`, `Resultado`)
  128. VALUES
  129.     (NULL, '1' , '1', '2', '50', 0, NULL),
  130.     (NULL, '1' , '1', '3', '200', 0, NULL),
  131.     (NULL, '2' , '1', '1', '300', 0, NULL),
  132.     (NULL, '2' , '1', '2', '450', 0, NULL),
  133.     (NULL, '3' , '1', '3', '260', 0, NULL),
  134.     (NULL, '3' , '1', '1', '350', 0, NULL),
  135.     (NULL, '4' , '2', '2', '690', 0, NULL),
  136.     (NULL, '4' , '2', '3', '153', 0, NULL),
  137.     (NULL, '5' , '2', '1', '132.56', 0, NULL),
  138.     (NULL, '5' , '2', '2', '658', 0, NULL),
  139.     (NULL, '6' , '2', '3', '650', 0, NULL),
  140.     (NULL, '6' , '2', '1', '320', 0, NULL),
  141.     (NULL, '7' , '3', '2', '321', 0, NULL),
  142.     (NULL, '7' , '3', '3', '654', 0, NULL),
  143.     (NULL, '8' , '3', '1', '123', 0, NULL),
  144.     (NULL, '8' , '3', '2', '987', 0, NULL),
  145.     (NULL, '9' , '3', '3', '456', 0, NULL),
  146.     (NULL, '9' , '3', '1', '321', 0, NULL),
  147.     (NULL, '10' , '4', '2', '159', 0, NULL),
  148.     (NULL, '10' , '4', '3', '951', 0, NULL),
  149.     (NULL, '11' , '4', '1', '327', 0, NULL),
  150.     (NULL, '11' , '4', '2', '723', 0, NULL),
  151.     (NULL, '12' , '4', '3', '756', 0, NULL),
  152.     (NULL, '12' , '4', '1', '984', 0, NULL),
  153.     (NULL, '13' , '5', '2', '512', 0, NULL),
  154.     (NULL, '13' , '5', '3', '659', 0, NULL),
  155.     (NULL, '14' , '5', '1', '652', 0, NULL),
  156.     (NULL, '14' , '5', '2', '564', 0, NULL),
  157.     (NULL, '15' , '5', '3', '984', 0, NULL),
  158.     (NULL, '15' , '5', '1', '520', 0, NULL),
  159.     (NULL, '16' , '6', '2', '580', 0, NULL),
  160.     (NULL, '16' , '6', '3', '500', 0, NULL),
  161.     (NULL, '17' , '6', '1', '204', 0, NULL),
  162.     (NULL, '17' , '6', '2', '213', 0, NULL),
  163.     (NULL, '18' , '6', '3', '2004', 0, NULL),
  164.     (NULL, '18' , '6', '1', '311', 0, NULL);
  165.  
  166.  
  167.  
  168. -- Insert Values in Transferencias
  169. INSERT INTO Transferencias
  170.     (`ID`, `Origem_Apostador_ID`, `Destino_Apostador_ID`, `Valor_Transferido`, `Data`)
  171. VALUES
  172.     (NULL, '1', '6', '200.00', SYSDATE()),
  173.     (NULL, '2', '5', '300.00', SYSDATE()),
  174.     (NULL, '3', '4', '400.00', SYSDATE()),
  175.     (NULL, '4', '3', '500.00', SYSDATE()),
  176.     (NULL, '5', '2', '100.00', SYSDATE()),
  177.     (NULL, '6', '1', '200.00', SYSDATE()),
  178.     (NULL, '1', '6', '300.00', SYSDATE()),
  179.     (NULL, '2', '5', '400.00', SYSDATE()),
  180.     (NULL, '3', '4', '150.00', SYSDATE()),
  181.     (NULL, '4', '3', '250.00', SYSDATE()),
  182.     (NULL, '5', '2', '350.00', SYSDATE()),
  183.     (NULL, '6', '1', '230.00', SYSDATE()),
  184.     (NULL, '1', '6', '330.00', SYSDATE()),
  185.     (NULL, '2', '5', '660.00', SYSDATE()),
  186.     (NULL, '3', '4', '120.00', SYSDATE()),
  187.     (NULL, '4', '3', '200.00', SYSDATE()),
  188.     (NULL, '5', '2', '100.00', SYSDATE()),
  189.     (NULL, '6', '1', '90.00', SYSDATE()),
  190.     (NULL, '1', '6', '80.00', SYSDATE()),
  191.     (NULL, '2', '5', '70.00', SYSDATE()),
  192.     (NULL, '3', '4', '60.00', SYSDATE()),
  193.     (NULL, '4', '3', '50.00', SYSDATE()),
  194.     (NULL, '5', '2', '40.00', SYSDATE()),
  195.     (NULL, '6', '1', '90.00', SYSDATE()),
  196.     (NULL, '1', '6', '60.00', SYSDATE()),
  197.     (NULL, '2', '5', '30.00', SYSDATE()),
  198.     (NULL, '3', '4', '40.00', SYSDATE()),
  199.     (NULL, '4', '3', '70.00', SYSDATE()),
  200.     (NULL, '5', '2', '80.00', SYSDATE()),
  201.     (NULL, '6', '1', '90.00', SYSDATE());
  202.  
  203. -- Insert Values in Depositos
  204. INSERT INTO Depositos
  205.     (`ID`, `Apostador_ID`, `Valor_Depositado`, `Data`)
  206. VALUES
  207.     (NULL, '1', '700', SYSDATE()),
  208.     (NULL, '2', '900', SYSDATE()),
  209.     (NULL, '3', '580', SYSDATE()),
  210.     (NULL, '4', '260', SYSDATE()),
  211.     (NULL, '5', '360', SYSDATE()),
  212.     (NULL, '6', '154', SYSDATE()),
  213.     (NULL, '1', '1000', SYSDATE()),
  214.     (NULL, '2', '1346', SYSDATE()),
  215.     (NULL, '3', '2005', SYSDATE()),
  216.     (NULL, '4', '360', SYSDATE()),
  217.     (NULL, '5', '392', SYSDATE()),
  218.     (NULL, '6', '182', SYSDATE()),
  219.     (NULL, '1', '362', SYSDATE()),
  220.     (NULL, '2', '182', SYSDATE()),
  221.     (NULL, '3', '270', SYSDATE()),
  222.     (NULL, '4', '390', SYSDATE()),
  223.     (NULL, '5', '160', SYSDATE()),
  224.     (NULL, '6', '380', SYSDATE()),
  225.     (NULL, '1', '290', SYSDATE()),
  226.     (NULL, '2', '370', SYSDATE()),
  227.     (NULL, '3', '193', SYSDATE()),
  228.     (NULL, '4', '256', SYSDATE()),
  229.     (NULL, '5', '509', SYSDATE()),
  230.     (NULL, '6', '536', SYSDATE()),
  231.     (NULL, '1', '500', SYSDATE()),
  232.     (NULL, '2', '190', SYSDATE()),
  233.     (NULL, '3', '160', SYSDATE()),
  234.     (NULL, '4', '380', SYSDATE()),
  235.     (NULL, '5', '190', SYSDATE()),
  236.     (NULL, '6', '170', SYSDATE());
  237.  
  238. -- Insert Values in Saques
  239. INSERT INTO Saques
  240.     (`ID`, `Apostador_ID`, `Valor_Sacado`, dATA)
  241. VALUES
  242.     (NULL, '1', '100', SYSDATE()),
  243.     (NULL, '2', '200', SYSDATE()),
  244.     (NULL, '3', '100', SYSDATE()),
  245.     (NULL, '4', '50', SYSDATE()),
  246.     (NULL, '5', '55', SYSDATE()),
  247.     (NULL, '6', '70', SYSDATE()),
  248.     (NULL, '1', '80', SYSDATE()),
  249.     (NULL, '2', '90', SYSDATE()),
  250.     (NULL, '3', '65', SYSDATE()),
  251.     (NULL, '4', '55', SYSDATE()),
  252.     (NULL, '5', '45', SYSDATE()),
  253.     (NULL, '6', '60', SYSDATE()),
  254.     (NULL, '1', '35', SYSDATE()),
  255.     (NULL, '2', '61', SYSDATE()),
  256.     (NULL, '3', '99', SYSDATE()),
  257.     (NULL, '4', '66', SYSDATE()),
  258.     (NULL, '5', '55', SYSDATE()),
  259.     (NULL, '6', '33', SYSDATE()),
  260.     (NULL, '1', '88', SYSDATE()),
  261.     (NULL, '2', '15', SYSDATE()),
  262.     (NULL, '3', '20', SYSDATE()),
  263.     (NULL, '4', '29', SYSDATE()),
  264.     (NULL, '5', '36', SYSDATE()),
  265.     (NULL, '6', '58', SYSDATE());
  266.  
  267.  
  268.  
  269. -- Insert Values in Resultado
  270. INSERT INTO Resultados
  271.     (`ID`, `Jogo_ID`, `Resultado`)
  272. VALUES
  273.     (NULL, '1', '0'),
  274.     (NULL, '1', '1'),
  275.     (NULL, '2', '2'),
  276.     (NULL, '2', '0'),
  277.     (NULL, '3', '1'),
  278.     (NULL, '3', '2'),
  279.     (NULL, '4', '0'),
  280.     (NULL, '4', '1'),
  281.     (NULL, '5', '2'),
  282.     (NULL, '5', '3'),
  283.     (NULL, '6', '0'),
  284.     (NULL, '6', '1'),
  285.     (NULL, '7', '2'),
  286.     (NULL, '7', '3'),
  287.     (NULL, '8', '0'),
  288.     (NULL, '8', '1'),
  289.     (NULL, '9', '2'),
  290.     (NULL, '9', '3'),
  291.     (NULL, '10', '0'),
  292.     (NULL, '10', '1'),
  293.     (NULL, '11', '2'),
  294.     (NULL, '11', '3'),
  295.     (NULL, '12', '0'),
  296.     (NULL, '12', '1'),
  297.     (NULL, '13', '2'),
  298.     (NULL, '13', '3'),
  299.     (NULL, '14', '0'),
  300.     (NULL, '14', '1'),
  301.     (NULL, '15', '2'),
  302.     (NULL, '15', '3'),
  303.     (NULL, '16', '0'),
  304.     (NULL, '16', '1'),
  305.     (NULL, '17', '2'),
  306.     (NULL, '17', '3'),
  307.     (NULL, '18', '0'),
  308.     (NULL, '18', '1');
Add Comment
Please, Sign In to add comment
Public Pastes
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!