text: ﻿--
  -- Script was generated by Devart dbForge Data Generator for MySQL, Version 2.4.216.0
  -- Product Home Page: http://www.devart.com/dbforge/mysql/data-generator
  -- Script date 8/15/2020 8:52:22 PM
  -- Target server version: 8.0.21
  -- Target connection string: User Id=root;Host=localhost;Database=seinfo;Character Set=utf8
  --
  
  
  
  SET NAMES 'utf8';
  USE seinfo;
  --
  -- Delete data from the table 'receitainscricaoevento'
  --
  TRUNCATE TABLE receitainscricaoevento;
  --
  -- Delete data from the table 'receita'
  --
  TRUNCATE TABLE receita;
  --
  -- Delete data from the table 'participaatividade'
  --
  TRUNCATE TABLE participaatividade;
  --
  -- Delete data from the table 'lote'
  --
  TRUNCATE TABLE lote;
  --
  -- Delete data from the table 'eventoimagem'
  --
  TRUNCATE TABLE eventoimagem;
  --
  -- Delete data from the table 'despesa'
  --
  TRUNCATE TABLE despesa;
  --
  -- Delete data from the table 'carrossel'
  --
  TRUNCATE TABLE carrossel;
  --
  -- Delete data from the table 'agendamentoatividade'
  --
  TRUNCATE TABLE agendamentoatividade;
  --
  -- Delete data from the table 'receitainscricaoatividade'
  --
  DELETE FROM receitainscricaoatividade;
  --
  -- Delete data from the table 'inscricaoatividade'
  --
  DELETE FROM inscricaoatividade;
  --
  -- Delete data from the table 'atividade'
  --
  DELETE FROM atividade;
  --
  -- Delete data from the table 'evento'
  --
  DELETE FROM evento;
  --
  -- Delete data from the table 'protagonista'
  --
  TRUNCATE TABLE protagonista;
  --
  -- Delete data from the table 'pessoa'
  --
  TRUNCATE TABLE pessoa;
  --
  -- Delete data from the table 'organizacao'
  --
  TRUNCATE TABLE organizacao;
  --
  -- Delete data from the table 'inscricaoevento'
  --
  DELETE FROM inscricaoevento;
  --
  -- Delete data from the table 'imagem'
  --
  DELETE FROM imagem;
  --
  -- Delete data from the table 'categoria'
  --
  DELETE FROM categoria;
  --
  -- Delete data from the table 'agenda'
  --
  DELETE FROM agenda;
  
  --
  -- Inserting data into table agenda
  --
  INSERT INTO agenda(idAgenda, dataHoraInicio, dataHoraFim, local) VALUES
  (1, '2020-04-15 09:37:12', '2020-04-22 14:53:25.367923', '240 Hidden Front Way'),
  (2, '2020-08-15 05:38:28', '2020-08-17 18:55:26.234103', '2948 Stonewood Pkwy'),
  (3, '2020-07-18 20:04:59', '2020-07-25 22:10:56.398023', '44 West Church Ct'),
  (4, '2020-09-19 03:40:49', '2020-09-21 08:30:39.786545', '3778 Edgewood Highway'),
  (5, '2020-07-24 05:47:39', '2020-07-26 13:25:22.025586', '12 1st Circle'),
  (6, '2020-08-28 17:12:14', '2020-09-04 07:56:03.621901', '3570 Flintwood Parkway'),
  (7, '2020-10-30 16:40:48', '2020-11-04 17:12:06.722894', '1790 SW Church Avenue'),
  (8, '2020-05-26 19:15:14', '2020-06-03 06:42:53.03355', '2014 Social Road'),
  (9, '2020-04-15 09:31:03', '2020-04-18 01:24:42.059907', '34 Riddle Hill Pkwy'),
  (10, '2020-10-14 01:32:17', '2020-10-18 20:09:12.267882', '65 Waterview Avenue'),
  (11, '2020-10-05 23:52:46', '2020-10-12 09:24:05.201111', '3760 West Social Parkway'),
  (12, '2020-04-15 09:30:04', '2020-04-20 06:56:58.31756', '1254 New Cedar Tree Rd'),
  (13, '2020-06-22 12:29:32', '2020-06-30 08:03:08.937488', '2354 N Cedar Tree Hwy'),
  (14, '2020-04-15 09:30:00', '2020-04-21 15:20:26.395436', '95 North Church Road'),
  (15, '2020-08-27 01:33:40', '2020-08-27 16:27:39.725306', '47 W Ashwood Avenue'),
  (16, '2020-04-26 13:45:11', '2020-04-28 01:56:22.137794', '2455 Buttonwood Ln'),
  (17, '2020-10-09 23:47:07', '2020-10-13 12:03:54.659023', '10 Social Lane'),
  (18, '2020-04-15 09:45:41', '2020-04-20 21:59:42.173325', '633 New Parkwood St'),
  (19, '2020-04-20 11:01:00', '2020-04-27 03:16:53.920548', '2762 Buttonwood Road'),
  (20, '2020-04-15 09:31:22', '2020-04-19 02:24:34.140576', '1027 NW Ashwood Cir'),
  (21, '2020-07-20 22:30:05', '2020-07-27 16:02:50.019311', '38 South Mount Highway'),
  (22, '2020-09-20 11:17:18', '2020-09-23 10:55:18.206923', '2795 East Lake Ct'),
  (23, '2020-08-18 02:52:00', '2020-08-24 17:35:46.759075', '1063 SW Hope Pkwy'),
  (24, '2020-06-16 04:40:15', '2020-06-16 22:47:44.436146', '3172 Deepwood Blvd'),
  (25, '2020-04-15 09:35:12', '2020-04-19 01:36:17.294872', '582 Rushwood Court'),
  (26, '2020-07-13 06:50:48', '2020-07-18 19:54:58.840335', '994 SW Glenwood Parkway'),
  (27, '2020-06-10 22:38:45', '2020-06-17 21:56:38.737312', '1136 SW Ashwood St'),
  (28, '2020-04-15 09:31:27', '2020-04-17 13:04:18.106302', '36 NE Hunting Hill Way'),
  (29, '2020-07-08 00:23:50', '2020-07-08 20:10:30.753539', '105 Old Deepwood Lane'),
  (30, '2020-04-15 09:31:37', '2020-04-21 07:45:48.104326', '777 Pine Tree Pkwy'),
  (31, '2020-11-12 09:50:56', '2020-11-16 19:07:36.556718', '75 Riverside Rd'),
  (32, '2020-08-04 04:12:47', '2020-08-06 12:44:31.763213', '3474 New Farmview St'),
  (33, '2020-10-18 19:51:49', '2020-10-19 10:38:16.860289', '255 Edgewood Street'),
  (34, '2020-04-15 10:30:17', '2020-04-21 08:04:35.906149', '71 Buttonwood Way'),
  (35, '2020-09-17 04:52:11', '2020-09-19 20:37:44.386337', '2049 North Chapel Hill Street'),
  (36, '2020-08-22 20:22:34', '2020-08-25 10:07:27.489086', '81 Old Mountain Ln'),
  (37, '2020-05-27 19:06:03', '2020-05-30 04:07:55.82475', '476 Rushwood Pkwy'),
  (38, '2020-07-27 19:58:01', '2020-08-01 10:15:42.013245', '139 Mount Hwy'),
  (39, '2020-09-16 04:09:56', '2020-09-19 01:38:22.860297', '1296 Beachwood Way'),
  (40, '2020-08-06 06:23:11', '2020-08-06 19:53:28.461164', '2052 Mountain Lane'),
  (41, '2020-06-03 17:51:10', '2020-06-05 22:47:33.382921', '2429 Rock Hill Highway'),
  (42, '2020-08-09 12:45:13', '2020-08-10 06:05:06.061373', '2402 East Rockwood Pkwy'),
  (43, '2020-06-23 12:16:24', '2020-07-01 10:06:47.858074', '685 Rock Hill Loop'),
  (44, '2020-06-08 12:08:45', '2020-06-10 02:35:37.829457', '10 North Highland Blvd'),
  (45, '2020-04-15 09:32:21', '2020-04-16 22:20:13.625313', '701 Ski Hill Drive'),
  (46, '2020-07-03 19:37:31', '2020-07-09 05:33:09.002157', '2744 New Rock Hill Way'),
  (47, '2020-10-29 17:06:11', '2020-11-02 10:19:02.117789', '665 SW Waterview Court'),
  (48, '2020-06-23 11:37:27', '2020-06-26 00:15:40.208335', '11 Rock Hill Hwy'),
  (49, '2020-10-12 15:24:33', '2020-10-16 10:41:34.526695', '802 Oak Blvd'),
  (50, '2020-04-15 12:15:14', '2020-04-18 21:20:18.963805', '2035 Mountain Pkwy');
  
  --
  -- Inserting data into table categoria
  --
  INSERT INTO categoria(idCategoria, nome) VALUES
  (1, 'Fund management activities'),
  (2, 'Financial management '),
  (3, 'Glazing '),
  (4, 'Dental practice activities'),
  (5, 'Sale of other motor vehicles'),
  (6, 'Manufacture of electronic instruments/appliances for measuring, testing, and navigation, except process control equipment '),
  (7, 'Repair of other equipment'),
  (8, 'News agency activities'),
  (9, 'Business and domestic software development '),
  (10, 'Manufacture of other taps and valves'),
  (11, 'Manufacture of plaster products for construction purposes'),
  (12, 'Manufacture of musical instruments'),
  (13, 'Architectural activities '),
  (14, 'Specialised cleaning services '),
  (15, 'Information technology consultancy activities'),
  (16, 'Manufacture of agricultural and forestry machinery (other than agricultural tractors)'),
  (17, 'Manufacture of wallpaper'),
  (18, 'Manufacture of paper and paperboard containers other than sacks and bags'),
  (19, 'Manufacture of basic iron and steel and of ferro-alloys'),
  (20, 'Extraction of crude petroleum'),
  (21, 'Non-specialized wholesale of food, beverages and tobacco'),
  (22, 'Cargo handling for land transport activities of division 49'),
  (23, 'Letting and operating of own or leased real estate n.e.c.'),
  (24, 'Landscape service activities'),
  (25, 'Manufacture of soft drinks, production of mineral waters and other bottled waters'),
  (26, 'Cargo handling for land transport activities of division 49'),
  (27, 'Manufacture of gas'),
  (28, 'Wholesale of tobacco products'),
  (29, 'Funeral and related activities'),
  (30, 'Retail sale of footwear in specialized stores'),
  (31, 'Manufacture of cleaning and polishing preparations '),
  (32, 'Manufacture of agricultural and forestry machinery (other than agricultural tractors)'),
  (33, 'Other financial intermediation (not including security dealing on own account and factoring) n.e.c. '),
  (34, 'Barristers at law '),
  (35, 'Manufacture of other tanks, reservoirs and containers of metal'),
  (36, 'Architectural activities '),
  (37, 'Wholesale of meat and meat products'),
  (38, 'Library activities'),
  (39, 'Manufacture of light metal packaging'),
  (40, 'Processing of tea and coffee'),
  (41, 'Growing of grapes'),
  (42, 'Tea processing '),
  (43, 'Wholesale of flowers and plants'),
  (44, 'Manufacture of bodies (coachwork) for motor vehicles, manufacture of trailers and semi-trailers'),
  (45, 'Life reinsurance '),
  (46, 'Striking of coins'),
  (47, 'Support activities for crop production'),
  (48, 'Manufacture of machinery for food, beverage and tobacco processing'),
  (49, 'Retail sale via mail order houses or via Internet'),
  (50, 'Manufacture of musical instruments');
  
  --
  -- Inserting data into table imagem
  --
  INSERT INTO imagem(idImagem, url) VALUES
  (1, 'https://orngthin.hu/te/oneaas/ingedted/toorasoul.htm'),
  (2, 'http://www.ereouleratha.za/tiedwa/thehis/thiwasith/enshoarnd.php'),
  (3, 'http://enndndit.fi/terereto/enforentan.php'),
  (4, 'http://www.eave.es/it/stithhat.asp'),
  (5, 'https://www.ereasand.it/asnewa/ithherrete.htm#732'),
  (6, 'http://heerveand.org/hieve/arallnt/anerainan.php?t=25&p=8383'),
  (7, 'http://www.verare.es/eretheith/aryouve/hindng/iseaoment.php?t=56'),
  (8, 'http://iserateit.us/inhadar/erane.htm#4'),
  (9, 'http://www.eraherouwit.be/thetiohen/nderahenfor.php'),
  (10, 'https://www.vetithabut.it/wasou/heeveve/uldhi/histwasing.php?t=35&p=93'),
  (11, 'http://www.hadshomeand.se/iontheti/esedhenoul.htm'),
  (12, 'https://inin.eg/forverwit/nottome/his/hadouinte.asp'),
  (13, 'http://www.ngallaling.net/thaerme/oulent/hisrewa/youere.htm'),
  (14, 'https://arearheneve.ca/hatted/nenot.html'),
  (15, 'http://www.meyou.hu/tedtoith/eaeathe/ent/foriseve.html'),
  (16, 'http://esleme.mx/shohatse/henent/youareed/andng.php'),
  (17, 'https://www.arstted.uk/enerent/buttione/hi/tedth.aspx?id=84'),
  (18, 'https://www.enthandion.cy/oulandas/le/eveall/lehenntyou.php'),
  (19, 'https://tedoulng.lv/asarehe/ereomeve/vereoual.php?t=20'),
  (20, 'http://eatheteres.lu/toeveeve/era/ngsetha/tothilehen.php?t=35&p=793'),
  (21, 'http://tersterahis.us/areand/heres/an/seathis.php?t=33&p=6829'),
  (22, 'http://araserees.eg/wa/hat/areuldth.php'),
  (23, 'https://erehen.cn/forerebut/hehadbut/esbut/aryou.asp'),
  (24, 'http://butstthier.dk/theuldas/itleit.asp?id=30'),
  (25, 'https://totewitbut.au/uldeaion/allas.asp'),
  (26, 'https://thhinareere.cz/on/hattient/oranouryou.htm#6835'),
  (27, 'https://www.orsttiofor.au/ha/ngmeted/erave/ithnttedthe.asp'),
  (28, 'http://verveareou.nz/ouritng/ngngti/hadrehe/esas.php'),
  (29, 'http://www.erethalenot.gr/ithhennot/for/alhere/outerorto.php'),
  (30, 'http://www.ingthor.il/neingyou/ouerahat/enituld/metewasas.asp?id=959'),
  (31, 'https://henforoulera.au/edtedome/esatit/youted/theonit.asp'),
  (32, 'http://tetiwahe.at/waentha/orarthed.html#54'),
  (33, 'https://thititiin.mx/ourtiter/aruld/eaallon/ioneveoulve.htm'),
  (34, 'https://www.toststted.at/not/tiis/ed/entourwasti.php?t=30'),
  (35, 'http://tonduldas.us/sho/hinter/asteteuld.aspx?id=18'),
  (36, 'https://www.areen.lu/arto/hentoar.aspx'),
  (37, 'https://www.eraneonand.de/tiedted/tianar/ionwa/eveityoune.php'),
  (38, 'https://inhaduldera.cz/hadve/ing/enttile/ndingngour.php?t=14&p=937'),
  (39, 'http://www.uldanne.cn/hatoed/anourhisre.asp?id=256'),
  (40, 'http://uldalented.nl/isithere/thenera/reston/ouryouuld.aspx'),
  (41, 'http://veentevefor.lu/atingto/onhi/edhaed/uldteromeve.php'),
  (42, 'http://streisith.it/enwasal/me/ntoufor/notmearenot.php?t=36&p=5244'),
  (43, 'https://inbuterar.hu/or/esng/arin/forall.asp'),
  (44, 'https://www.teinnot.za/was/or/oulatan/hisentithto.php?t=63&p=58'),
  (45, 'https://erealthahi.il/entvehis/ne/arehian.html'),
  (46, 'https://foroure.dk/eses/ted/inguldall/henand.php?t=13'),
  (47, 'http://www.ereforhin.be/wa/evendit/areallhi/nttedisen.php'),
  (48, 'https://hathiha.uk/hadouryou/notwaswit/henisour/hisyoutersho.asp?id=490'),
  (49, 'http://www.arngshoare.eg/theter/buter/hinentera/oueveasand.html'),
  (50, 'http://www.ioneveit.lv/hi/heevetoour.php');
  
  --
  -- Inserting data into table inscricaoevento
  --
  INSERT INTO inscricaoevento(CPF, idEvento, dataInscricao) VALUES
  ('31144959656', 14, '2020-07-13'),
  ('36553364665', 8, '2020-07-30'),
  ('33049501078', 9, '2020-07-06'),
  ('34179556342', 15, '2020-05-19'),
  ('37076348597', 12, '2020-08-05'),
  ('39517389244', 9, '2020-05-11'),
  ('32416400536', 10, '2020-09-15'),
  ('33990502814', 5, '2020-04-22'),
  ('35705099333', 3, '2020-04-23'),
  ('34919610802', 1, '2020-09-10'),
  ('36747824308', 10, '2020-07-29'),
  ('35340081227', 14, '2020-10-06'),
  ('32866496508', 1, '2020-10-26'),
  ('39588047180', 15, '2020-09-01'),
  ('35072935091', 5, '2020-08-19'),
  ('33256139627', 4, '2020-06-23'),
  ('39477688745', 7, '2020-06-17'),
  ('39066245018', 8, '2020-06-22'),
  ('33292661983', 12, '2020-04-23'),
  ('36143339872', 15, '2020-07-03'),
  ('31257500092', 3, '2020-05-19'),
  ('38277667974', 9, '2020-07-01'),
  ('38690174010', 9, '2020-08-28'),
  ('38197795893', 15, '2020-07-06'),
  ('38562911824', 3, '2020-08-14'),
  ('37948835420', 6, '2020-04-23'),
  ('37253821547', 3, '2020-04-16'),
  ('33085529131', 1, '2020-07-10'),
  ('32618621705', 7, '2020-04-27'),
  ('31287767150', 3, '2020-04-16'),
  ('30196530766', 15, '2020-10-25'),
  ('39852265853', 12, '2020-07-21'),
  ('30765394198', 9, '2020-04-15'),
  ('34662195033', 5, '2020-09-15'),
  ('36383688525', 8, '2020-07-01'),
  ('32101910773', 3, '2020-04-22'),
  ('32786903569', 14, '2020-08-20'),
  ('35992966406', 15, '2020-06-03'),
  ('33640892777', 15, '2020-04-29'),
  ('30827338000', 3, '2020-04-17'),
  ('32504996195', 3, '2020-07-16'),
  ('38864095608', 12, '2020-10-10'),
  ('31347449283', 12, '2020-04-16'),
  ('33771931039', 14, '2020-05-11'),
  ('30724652092', 9, '2020-06-03'),
  ('30163620952', 4, '2020-07-11'),
  ('30774347153', 15, '2020-06-23'),
  ('34081245285', 2, '2020-11-04'),
  ('34871516568', 7, '2020-04-17'),
  ('39260980014', 3, '2020-10-12');
  
  --
  -- Inserting data into table organizacao
  --
  INSERT INTO organizacao(CPF, idEvento, horasParticipacao) VALUES
  ('37948835420', 2, '01:57:28'),
  ('36553364665', 8, '00:41:31'),
  ('36553364665', 6, '01:29:43'),
  ('34179556342', 7, '02:54:59'),
  ('38690174010', 6, '02:33:37'),
  ('39588047180', 9, '02:02:02'),
  ('36553364665', 1, '01:45:33'),
  ('35992966406', 6, '00:30:08'),
  ('38690174010', 4, '01:50:47'),
  ('38562911824', 10, '01:34:48'),
  ('34179556342', 10, '00:42:39'),
  ('38690174010', 8, '01:34:58'),
  ('39852265853', 3, '01:00:01'),
  ('38562911824', 7, '02:35:20'),
  ('37948835420', 9, '00:39:32'),
  ('36747824308', 8, '01:06:10'),
  ('39852265853', 1, '01:15:49'),
  ('38690174010', 2, '02:40:10'),
  ('33771931039', 10, '02:37:30'),
  ('39260980014', 5, '02:31:10'),
  ('37948835420', 8, '00:52:33'),
  ('37948835420', 6, '02:25:23'),
  ('38690174010', 9, '00:36:00'),
  ('33771931039', 4, '01:08:58'),
  ('38562911824', 1, '01:57:06'),
  ('34081245285', 5, '02:35:25'),
  ('39852265853', 7, '00:39:11'),
  ('35992966406', 9, '01:37:43'),
  ('33771931039', 1, '02:17:53'),
  ('34179556342', 3, '02:43:29'),
  ('34871516568', 7, '00:37:15'),
  ('39852265853', 4, '02:46:55'),
  ('34179556342', 5, '01:47:31'),
  ('35992966406', 8, '01:36:32'),
  ('34871516568', 4, '01:44:43'),
  ('38562911824', 3, '02:14:58'),
  ('34871516568', 2, '02:13:50'),
  ('39260980014', 3, '01:27:54'),
  ('33640892777', 5, '01:08:56'),
  ('33771931039', 7, '00:36:12'),
  ('36747824308', 9, '01:04:05'),
  ('36553364665', 2, '02:00:52'),
  ('39852265853', 10, '00:30:48'),
  ('33771931039', 2, '02:21:22'),
  ('34871516568', 1, '00:30:37'),
  ('38562911824', 5, '02:14:32'),
  ('36553364665', 4, '00:30:47'),
  ('34081245285', 3, '00:31:57'),
  ('34871516568', 6, '02:26:24'),
  ('39260980014', 10, '01:02:34');
  
  --
  -- Inserting data into table pessoa
  --
  INSERT INTO pessoa(CPF, idPessoa, nome, email, senha, nivel, classificacao) VALUES
  ('33640892777', 'a1958346', 'Charmaine Stock', 'GabrielS.Handy@gmail.com', '6CKGOA', 1, 2),
  ('34081245285', 'a1958940', 'Matthew Hoffman', 'Bowie@gmail.com', 'SG8RLS', 0, 0),
  ('39260980014', 'a1993372', 'Jacinta Yanez', 'Adelaida_Massie768@hotmail.com', '6IX46I', 1, 0),
  ('34179556342', 'a1992609', 'Drew Perry', 'Gagne@gmail.com', 'R074EX', 2, 2),
  ('38562911824', 'a1986148', 'Kyoko Adams', 'AntwanAyres@gmail.com', 'F3VL79', 1, 1),
  ('39852265853', 'a1968410', 'Renea Russo', 'jopbhg1309@hotmail.com', '3GK6PH', 1, 0),
  ('33771931039', 'a1966963', 'Isidra Kirchner', 'Castellanos988@hotmail.com', 'W9Z8G3', 1, 2),
  ('34871516568', 'a1958267', 'Donita Huff', 'Armstead75@gmail.com', '69IU9B', 0, 1),
  ('36553364665', 'a1982546', 'Rosendo Lunsford', 'Rickey.Gable@gmail.com', 'CLPGP0', 1, 0),
  ('38690174010', 'a1988016', 'Cesar Edge', 'BillieHughey@hotmail.com', 'KGTQ92', 1, 0),
  ('37948835420', 'a1987719', 'Paul Medeiros', 'KirkWChung@hotmail.com', '1UK772', 2, 2),
  ('35992966406', 'a1990396', 'Theodora Munn', 'Lerner243@hotmail.com', 'O9FWNE', 2, 2),
  ('36747824308', 'a1983744', 'Keenan Gatewood', 'Grayce_Cecil61@hotmail.com', 'W07NGY', 0, 2),
  ('39588047180', 'a1962595', 'Arlyne Wheeler', 'Morgan.K.Rhoads@hotmail.com', 'GPKFB6', 1, 1),
  ('39477688745', 'a1985420', 'Alysa Paulson', 'AdrianBriscoe@gmail.com', '7T7463', 2, 0),
  ('38197795893', 'a1978690', 'Alton Calloway', 'Stacey_Dove@hotmail.com', '6R5406', 0, 1),
  ('32786903569', 'a1984010', 'Arnoldo Handy', 'VirgilioDobbs@gmail.com', 'EZ3I4A', 0, 0),
  ('33049501078', 'a1983554', 'Charlie Sallee', 'Frances.Stewart732@hotmail.com', '86UJU7', 1, 0),
  ('35340081227', 'a1988059', 'Margit Sales', 'RexEastman135@hotmail.com', 'NBVK5A', 0, 0),
  ('35072935091', 'a1960433', 'Louvenia Evers', 'Tobias.Stowe@hotmail.com', '0QL884', 2, 1),
  ('36143339872', 'a1960296', 'Neda Mcqueen', 'iaipyd884@hotmail.com', '4J3LTM', 2, 2),
  ('31287767150', 'a1975460', 'Jospeh Story', 'DesmondOchoa@gmail.com', '002F30', 2, 1),
  ('34919610802', 'a1958804', 'Winfred Ornelas', 'MendyDelagarza361@hotmail.com', 'JGKU3L', 0, 1),
  ('37253821547', 'a1997693', 'Daniel Gates', 'AbelB529@gmail.com', 'D12183', 2, 1),
  ('32618621705', 'a1966763', 'Abraham Connolly', 'dgrup6@gmail.com', 'O39546', 0, 1),
  ('36383688525', 'a1970721', 'Vivien Fisk', 'Vida_Lange@hotmail.com', '3RR62H', 1, 2),
  ('38864095608', 'a1982839', 'Adelaida Isbell', 'Jack@gmail.com', '5GY11Z', 0, 1),
  ('37076348597', 'a1993969', 'Alden Fincher', 'Emory_Hillman@gmail.com', 'ABB0Y4', 0, 2),
  ('31257500092', 'a1985693', 'Garry Deaton', 'Lilliam_Abrams@hotmail.com', 'JP76KT', 2, 0),
  ('33085529131', 'a1990636', 'Janene Turney', 'BlanchBreen@hotmail.com', 'I5473C', 2, 2),
  ('30765394198', 'a1972168', 'Cyndi Mcmillen', 'Dionne.Richardson82@gmail.com', 'G0W4BB', 1, 1),
  ('32101910773', 'a1961850', 'Jorge Abney', 'Cara_Oneal@hotmail.com', 'P7020N', 0, 2),
  ('31347449283', 'a1995072', 'Terica Corley', 'Mcadams326@hotmail.com', 'U80B9Z', 1, 0),
  ('30827338000', 'a1965091', 'Noel Fulton', 'MelyndaPence522@gmail.com', 'AD33L5', 1, 0),
  ('30724652092', 'a1999670', 'Frederic Rasmussen', 'DominickCraig7@hotmail.com', 'ODA22S', 0, 1),
  ('30774347153', 'a1977102', 'Antoine Adams', 'AdanHaney21@hotmail.com', 'Y65OQH', 2, 0),
  ('39066245018', 'a1971482', 'Denise Coyle', 'ybkewpxy.achowa@hotmail.com', 'R24064', 2, 1),
  ('38277667974', 'a1959753', 'Stefan Acker', 'Albers@hotmail.com', '5ICJG1', 0, 1),
  ('34662195033', 'a1987339', 'Richard Cho', 'rhojlxoa6791@gmail.com', '0D47E5', 1, 2),
  ('32504996195', 'a1955637', 'Gary Legg', 'LloydR_Matson18@hotmail.com', 'MT2G97', 1, 0),
  ('30163620952', 'a1990713', 'Mariko Warfield', 'CletusFryer494@hotmail.com', 'FEJF7Y', 0, 0),
  ('32866496508', 'a1967375', 'Alfonzo Michel', 'Huerta449@hotmail.com', 'W186M3', 0, 1),
  ('33292661983', 'a1952863', 'Ginny Acker', 'vpfybyif2589@hotmail.com', 'O49J63', 2, 2),
  ('30196530766', 'a1978525', 'Alethia Capps', 'SammyLim87@hotmail.com', 'ZT854J', 1, 2),
  ('32416400536', 'a1964252', 'Adolph Starr', 'BlakePBivins@hotmail.com', '2025MG', 2, 0),
  ('35705099333', 'a1980610', 'April Calabrese', 'Willingham@hotmail.com', 'JD365G', 0, 1),
  ('31144959656', 'a1963777', 'Reagan Cousins', 'bidmwz3065@hotmail.com', '14D8O9', 1, 1),
  ('33990502814', 'a1992534', 'Diana Archibald', 'Boehm248@hotmail.com', 'UD909Z', 0, 2),
  ('33256139627', 'a1975565', 'Lakisha Betancourt', 'YolandaRidley253@gmail.com', 'HT7MB6', 0, 1),
  ('39517389244', 'a1964924', 'Charlena Rasmussen', 'wmgu1298@gmail.com', '2DAMBE', 1, 2);
  
  --
  -- Inserting data into table protagonista
  --
  INSERT INTO protagonista(CPF, idAtividade, atuacao) VALUES
  ('31144959656', 47, 1),
  ('36553364665', 9, 0),
  ('33049501078', 18, 1),
  ('34179556342', 4, 0),
  ('37076348597', 28, 1),
  ('39517389244', 50, 0),
  ('32416400536', 45, 1),
  ('33990502814', 48, 0),
  ('35705099333', 46, 0),
  ('34919610802', 23, 1),
  ('36747824308', 13, 0),
  ('35340081227', 19, 1),
  ('32866496508', 42, 1),
  ('39588047180', 14, 0),
  ('35072935091', 20, 1),
  ('33256139627', 49, 0),
  ('39477688745', 15, 1),
  ('39066245018', 37, 0),
  ('33292661983', 43, 1),
  ('36143339872', 21, 1),
  ('31257500092', 29, 0),
  ('38277667974', 38, 0),
  ('38690174010', 10, 1),
  ('38197795893', 16, 0),
  ('38562911824', 5, 0),
  ('37948835420', 11, 0),
  ('37253821547', 24, 1),
  ('33085529131', 30, 1),
  ('32618621705', 25, 0),
  ('31287767150', 22, 1),
  ('30196530766', 44, 1),
  ('39852265853', 6, 0),
  ('30765394198', 31, 0),
  ('34662195033', 39, 1),
  ('36383688525', 26, 1),
  ('32101910773', 32, 0),
  ('32786903569', 17, 1),
  ('35992966406', 12, 1),
  ('33640892777', 1, 0),
  ('30827338000', 34, 0),
  ('32504996195', 40, 0),
  ('38864095608', 27, 1),
  ('31347449283', 33, 0),
  ('33771931039', 7, 1),
  ('30724652092', 35, 1),
  ('30163620952', 41, 1),
  ('30774347153', 36, 0),
  ('34081245285', 2, 1),
  ('34871516568', 8, 0),
  ('39260980014', 3, 1);
  
  --
  -- Inserting data into table evento
  --
  INSERT INTO evento(idEvento, nome, descricao, status, idAgenda) VALUES
  (1, 'Construction of railways and underground railways', 'Growing of cereals (except rice), leguminous crops and oil seeds', 1, 13),
  (2, 'Other service activities incidental to land transportation, n.e.c.', 'Manufacture of consumer electronics', 1, 24),
  (3, 'Manufacture of electric lighting equipment', 'Wholesale of fruit and vegetable juices, mineral waters and soft drinks', 0, 50),
  (4, 'Manufacture of tools', 'Passenger rail transport, interurban', 0, 30),
  (5, 'Manufacture of paper stationery', 'Mining of iron ores', 0, 19),
  (6, 'Manufacture of plaster products for construction purposes', 'Wholesale of textiles', 1, 42),
  (7, 'Wholesale of solid, liquid and gaseous fuels and related products', 'Marine aquaculture', 0, 49),
  (8, 'Manufacture of ceramic sanitary fixtures', NULL, 0, 37),
  (9, 'Other telecommunications activities', 'Operation of sports facilities', 1, 9),
  (10, 'Manufacture of other technical ceramic products', 'General medical practice activities', 0, 43),
  (11, 'Other manufacturing n.e.c.', 'Wholesale of furniture, carpets and lighting equipment', 1, 38),
  (12, 'Manufacture of essential oils', 'Freight transport by road', 1, 14),
  (13, 'Passenger rail transport, interurban', 'Retail sale of automotive fuel in specialized stores', 1, 25),
  (14, 'Manufacture of other rubber products', 'Manufacture of other inorganic basic chemicals', 1, 4),
  (15, 'Accounting, and auditing activities', 'Precious metals production', 0, 44),
  (16, 'Cold rolling of narrow strip', 'Production of coffee and coffee substitutes ', 0, 10),
  (17, 'Fund management activities', 'Manufacture of sugar confectionery ', 0, 20),
  (18, 'Trusts, funds and other financial vehicles', 'Wholesale of flowers and plants', 1, 5),
  (19, 'Support activities for other mining and quarrying', 'Manufacture of household textiles (other than soft furnishings of 13.42/1)', 0, 39),
  (20, 'Manufacture of fasteners and screw machine products', 'Freight air transport', 1, 34),
  (21, 'Renting and operating of Housing Association real estate ', 'Growing of sugar cane', 1, 31),
  (22, 'Growing of grapes', 'Growing of cereals (except rice), leguminous crops and oil seeds', 0, 11),
  (23, 'Manufacture of articles of fur', 'Manufacture of paper stationery', 0, 6),
  (24, 'Manufacture of other taps and valves', 'Manufacture of ice cream', 1, 1),
  (25, 'Manufacture of caravans', 'Support activities for animal production (other than farm animal boarding and care) n.e.c.', 1, 26),
  (26, 'Operation of dairies and cheese making', 'Cargo handling for air transport activities of division 51', 0, 47),
  (27, 'Manufacture of other non-distilled fermented beverages', 'Manufacture of other electrical equipment', 1, 15),
  (28, 'Retail sale of hearing aids in specialized stores', 'Hotels and similar accommodation', 1, 32),
  (29, 'Operation of warehousing and storage facilities for air transport activities of division 51', 'Human resources provision', 1, 40),
  (30, 'Holiday centres and villages ', 'Business and other management consultancy activities', 0, 45),
  (31, 'Tax consultancy', 'Non-specialized wholesale trade', 1, 48),
  (32, 'Manufacture of motor vehicles', 'Manufacture of other tanks, reservoirs and containers of metal', 0, 7),
  (33, 'Wholesale of household goods (other than musical instruments) n.e.c.', 'Collection of non-hazardous waste', 0, 21),
  (34, 'Manufacture of wine from grape', 'Engineering activities and related technical consultancy', 1, 2),
  (35, 'Tanning and dressing of leather, dressing and dyeing of fur', 'Other retail sale of new goods in specialized stores (other than by opticians or commercial art galleries), n.e.c.', 0, 35),
  (36, 'Other activities auxiliary to insurance and pension funding', 'Growing of other non-perennial crops', 1, 27),
  (37, 'Gathering of wild growing non-wood products', 'Other research and experimental development on natural sciences and engineering', 0, 16),
  (38, 'Growing of vegetables and melons, roots and tubers', 'Medical nursing home activities ', 0, 22),
  (39, 'Human resources provision', 'Activities of investment trusts ', 1, 8),
  (40, 'Growing of vegetables and melons, roots and tubers', 'Manufacture of ceramic sanitary fixtures', 0, 17),
  (41, 'Data processing, hosting and related activities', 'Growing of tropical and subtropical fruits', 0, 46),
  (42, 'Wholesale of other intermediate products', 'Wholesale of other office machinery and equipment', 0, 41),
  (43, 'Life reinsurance ', 'Manufacture of wooden containers', 0, 36),
  (44, 'Other passenger land transport', 'Mining of iron ores', 1, 33),
  (45, 'Wholesale of mining, construction and civil engineering machinery', 'Manufacture of locks and hinges', 0, 3),
  (46, 'Tax consultancy', 'Activities of mortgage finance companies ', 0, 12),
  (47, 'Growing of sugar cane', 'Operation of gravel and sand pits, mining of clays and kaolin', 0, 18),
  (48, 'Manufacture of starches and starch products', 'Foreign affairs', 1, 28),
  (49, 'Lead, zinc and tin production', 'Life reinsurance ', 0, 23),
  (50, 'Growing of sugar cane', 'Tea processing ', 1, 29);
  
  --
  -- Inserting data into table atividade
  --
  INSERT INTO atividade(idAtividade, titulo, valor, descricao, horasParticipacao, quantidadeVagas, idCategoria, idEvento) VALUES
  (1, 'Aprosonrex', 21, 'Cpl', '01:21:45', 33, 7, 22),
  (2, 'Innochloridedene', 42, 'Lord', '00:30:06', 11, 28, 1),
  (3, 'Neugozyl', 43, 'Fr.', '00:30:08', 26, 27, 27),
  (4, 'Chlorperalat', 39, 'Madam', '01:01:39', 17, 45, 22),
  (5, 'Dynasivex', 30, 'Brgdr', '00:30:00', 10, 1, 39),
  (6, 'Acohydroino', 35, 'Lord', '02:32:47', 32, 28, 30),
  (7, 'Tenobutamtec', 31, 'Br.', '01:24:09', 17, 21, 46),
  (8, 'Oxioxedex', 35, 'Sr', '01:48:36', 25, 23, 38),
  (9, 'Adioxevant', 16, 'Supt.', '02:46:32', 6, 42, 17),
  (10, 'Mykochloridevant', 21, 'Msgr', '00:51:21', 23, 11, 46),
  (11, 'Fibradipivant', 35, 'Esq.', '01:40:44', 0, 4, 48),
  (12, 'Micoclodine', 32, 'Gov', '00:44:53', 20, 37, 16),
  (13, 'Aconapin', 20, 'Lady', '01:06:20', 2, 8, 3),
  (14, 'Parahydrotex', 47, 'Hon.', '01:11:38', 2, 21, 10),
  (15, 'Allerpaino', 15, 'Maj', '00:45:24', 35, 42, 43),
  (16, 'Levosonmuc', 29, 'Br', '00:42:42', 32, 3, 47),
  (17, 'Candioxecept', 23, 'Atty.', '02:48:23', 22, 5, 23),
  (18, 'Epiclotex', 27, 'Ofc', '00:30:02', 44, 24, 8),
  (19, 'Mecosilxol', 18, 'Msgr', '01:46:51', 35, 33, 32),
  (20, 'Actidrone', 26, 'Cmdr', '02:53:39', 1, 33, 45),
  (21, 'Isodropren', 37, NULL, '01:14:28', 37, 4, 1),
  (22, 'Amfosoprocose', 19, 'Gov', '00:30:04', 1, 32, 36),
  (23, 'Valcoperifast', 35, 'Adv', '00:30:01', 21, 22, 8),
  (24, 'Protanpin', 50, 'Adv', '01:04:26', 17, 23, 12),
  (25, 'Acamafen', 19, 'Lord', '00:34:10', 0, 47, 24),
  (26, 'Flosipos', 30, 'Sr.', '02:47:27', 36, 13, 27),
  (27, 'Ecospotan', 23, 'Maj.', '00:44:47', 32, 41, 34),
  (28, 'Alfimaxin', 48, 'Pres', '00:30:01', 29, 40, 15),
  (29, 'Zylasonmuc', 46, 'Gov', '00:39:07', 35, 37, 12),
  (30, 'Rythmoxabid', 21, 'Cmdr', '02:43:28', 34, 47, 21),
  (31, 'Omedrozol', 29, 'Msgr', '00:44:07', 3, 13, 2),
  (32, 'Reducurzol', 18, 'Lt.Cmdr.', '01:09:39', 19, 46, 44),
  (33, 'Losapuritriol', 25, 'Sec', '00:38:44', 22, 19, 17),
  (34, 'Pipepapren', 23, 'Supt.', '01:47:05', 36, 28, 9),
  (35, 'Miraperahex', 27, 'Treas.', '00:30:53', 42, 19, 7),
  (36, 'Durachloridevant', 30, 'Rep.', '00:44:51', 17, 19, 34),
  (37, 'Renachloridenide', 31, 'Fr.', '00:38:11', 25, 4, 44),
  (38, 'Ecopurimuc', 39, 'Msgr.', '00:30:06', 21, 20, 40),
  (39, 'Aerocarpambid', 31, 'Adv.', '01:08:05', 22, 43, 6),
  (40, 'Afsitec', 33, 'Cpl.', '00:31:37', 22, 1, 34),
  (41, 'Aprozovant', 24, 'Dame', '02:13:19', 2, 20, 25),
  (42, 'Levopafen', 29, 'Gov.', '01:17:58', 41, 17, 14),
  (43, 'Medrotraxel', 26, 'Pres.', '00:38:51', 9, 12, 9),
  (44, 'Doxxaliq', 29, NULL, '01:34:13', 17, 15, 50),
  (45, 'Betatasine', 45, 'Rev', '01:48:10', 0, 4, 3),
  (46, 'Ciclopatex', 32, 'Ofc', '02:54:27', 36, 47, 35),
  (47, 'Acadipiphane', 49, 'Lady', '00:35:04', 40, 8, 47),
  (48, 'Septomapin', 15, 'Rep', '02:33:34', 41, 48, 47),
  (49, 'Acioxenal', 26, NULL, '02:40:34', 4, 2, 8),
  (50, 'Natadrolol', 45, 'Ofc', '01:24:42', 6, 17, 25);
  
  --
  -- Inserting data into table inscricaoatividade
  --
  INSERT INTO inscricaoatividade(CPF, idEvento, idAtividade, dataInscricao) VALUES
  ('30774347153', 15, 47, '2020-08-15'),
  ('35705099333', 3, 9, '2020-06-02'),
  ('39066245018', 8, 18, '2020-05-18'),
  ('34179556342', 15, 4, '2020-10-06'),
  ('33085529131', 1, 28, '2020-09-20'),
  ('39260980014', 3, 50, '2020-10-23'),
  ('30724652092', 9, 45, '2020-08-09'),
  ('34081245285', 2, 48, '2020-08-03'),
  ('30163620952', 4, 46, '2020-08-29'),
  ('38690174010', 9, 23, '2020-09-13'),
  ('32866496508', 1, 13, '2020-10-11'),
  ('33292661983', 12, 19, '2020-06-30'),
  ('38864095608', 12, 42, '2020-04-26'),
  ('39588047180', 15, 14, '2020-04-23'),
  ('36143339872', 15, 20, '2020-08-28'),
  ('34871516568', 7, 49, '2020-06-05'),
  ('35072935091', 5, 15, '2020-04-15'),
  ('32786903569', 14, 37, '2020-07-07'),
  ('31347449283', 12, 43, '2020-10-21'),
  ('31257500092', 3, 21, '2020-08-22'),
  ('32618621705', 7, 29, '2020-05-21'),
  ('35992966406', 15, 38, '2020-09-08'),
  ('34919610802', 1, 10, '2020-04-23'),
  ('33256139627', 4, 16, '2020-05-24'),
  ('37076348597', 12, 5, '2020-10-30'),
  ('36747824308', 10, 11, '2020-05-13'),
  ('38197795893', 15, 24, '2020-11-07'),
  ('31287767150', 3, 30, '2020-07-09'),
  ('38562911824', 3, 25, '2020-09-04'),
  ('38277667974', 9, 22, '2020-11-10'),
  ('33771931039', 14, 44, '2020-10-10'),
  ('39517389244', 9, 6, '2020-10-30'),
  ('30196530766', 15, 31, '2020-07-19'),
  ('33640892777', 15, 39, '2020-05-30'),
  ('37948835420', 6, 26, '2020-07-30'),
  ('39852265853', 12, 32, '2020-06-20'),
  ('39477688745', 7, 17, '2020-07-04'),
  ('35340081227', 14, 12, '2020-05-03'),
  ('31144959656', 14, 1, '2020-05-04'),
  ('34662195033', 5, 34, '2020-05-31'),
  ('30827338000', 3, 40, '2020-09-24'),
  ('37253821547', 3, 27, '2020-09-28'),
  ('30765394198', 9, 33, '2020-10-21'),
  ('32416400536', 10, 7, '2020-08-02'),
  ('36383688525', 8, 35, '2020-11-06'),
  ('32504996195', 3, 41, '2020-04-21'),
  ('32101910773', 3, 36, '2020-09-24'),
  ('36553364665', 8, 2, '2020-08-30'),
  ('33990502814', 5, 8, '2020-10-23'),
  ('33049501078', 9, 3, '2020-08-22');
  
  --
  -- Inserting data into table receitainscricaoatividade
  --
  INSERT INTO receitainscricaoatividade(CPF, idEvento, idAtividade, dataPagamento) VALUES
  ('33640892777', 15, 39, '2020-11-04'),
  ('35705099333', 3, 9, '2020-05-02'),
  ('32786903569', 14, 37, '2020-06-01'),
  ('36383688525', 8, 35, '2020-04-17'),
  ('36553364665', 8, 2, '2020-06-11'),
  ('38864095608', 12, 42, '2020-05-04'),
  ('34662195033', 5, 34, '2020-11-15'),
  ('33049501078', 9, 3, '2020-05-02'),
  ('34081245285', 2, 48, '2020-09-07'),
  ('31347449283', 12, 43, '2020-08-23'),
  ('39588047180', 15, 14, '2020-05-12'),
  ('39517389244', 9, 6, '2020-09-04'),
  ('38197795893', 15, 24, '2020-09-09'),
  ('31257500092', 3, 21, '2020-09-22'),
  ('39066245018', 8, 18, '2020-06-28'),
  ('30196530766', 15, 31, '2020-04-15'),
  ('36143339872', 15, 20, '2020-06-21'),
  ('32618621705', 7, 29, '2020-11-10'),
  ('32504996195', 3, 41, '2020-09-12'),
  ('30163620952', 4, 46, '2020-04-20'),
  ('34179556342', 15, 4, '2020-06-05'),
  ('37948835420', 6, 26, '2020-06-16'),
  ('31287767150', 3, 30, '2020-09-21'),
  ('38690174010', 9, 23, '2020-08-30'),
  ('33085529131', 1, 28, '2020-10-18'),
  ('34919610802', 1, 10, '2020-11-02'),
  ('38562911824', 3, 25, '2020-09-11'),
  ('33990502814', 5, 8, '2020-04-25'),
  ('32101910773', 3, 36, '2020-05-27'),
  ('33256139627', 4, 16, '2020-06-09'),
  ('32866496508', 1, 13, '2020-10-27'),
  ('34871516568', 7, 49, '2020-06-21'),
  ('35992966406', 15, 38, '2020-08-16'),
  ('30827338000', 3, 40, '2020-11-02'),
  ('39852265853', 12, 32, '2020-10-11'),
  ('35072935091', 5, 15, '2020-04-16'),
  ('37253821547', 3, 27, '2020-07-17'),
  ('33292661983', 12, 19, '2020-05-28'),
  ('39477688745', 7, 17, '2020-11-02'),
  ('39260980014', 3, 50, '2020-08-14'),
  ('38277667974', 9, 22, '2020-06-03'),
  ('37076348597', 12, 5, '2020-04-16'),
  ('30774347153', 15, 47, '2020-04-19'),
  ('30765394198', 9, 33, '2020-05-29'),
  ('35340081227', 14, 12, '2020-05-29'),
  ('33771931039', 14, 44, '2020-10-10'),
  ('32416400536', 10, 7, '2020-05-19'),
  ('36747824308', 10, 11, '2020-08-15'),
  ('31144959656', 14, 1, '2020-05-15'),
  ('30724652092', 9, 45, '2020-07-23');
  
  --
  -- Inserting data into table agendamentoatividade
  --
  INSERT INTO agendamentoatividade(idAtividade, idAgenda) VALUES
  (47, 47),
  (9, 9),
  (18, 18),
  (4, 4),
  (28, 28),
  (50, 50),
  (45, 45),
  (48, 48),
  (46, 46),
  (23, 23),
  (13, 13),
  (19, 19),
  (42, 42),
  (14, 14),
  (20, 20),
  (49, 49),
  (15, 15),
  (37, 37),
  (43, 43),
  (21, 21),
  (29, 29),
  (38, 38),
  (10, 10),
  (16, 16),
  (5, 5),
  (11, 11),
  (24, 24),
  (30, 30),
  (25, 25),
  (22, 22),
  (44, 44),
  (6, 6),
  (31, 31),
  (39, 39),
  (26, 26),
  (32, 32),
  (17, 17),
  (12, 12),
  (1, 1),
  (34, 34),
  (40, 40),
  (27, 27),
  (33, 33),
  (7, 7),
  (35, 35),
  (41, 41),
  (36, 36),
  (2, 2),
  (8, 8),
  (3, 3);
  
  --
  -- Inserting data into table carrossel
  --
  INSERT INTO carrossel(idCarrossel, status, idImagem) VALUES
  (1, 1, 46),
  (2, 0, 44),
  (3, 0, 26),
  (4, 0, 33),
  (5, 1, 28),
  (6, 1, 5),
  (7, 0, 23),
  (8, 0, 35),
  (9, 1, 46),
  (10, 1, 32),
  (11, 1, 39),
  (12, 1, 13),
  (13, 1, 8),
  (14, 0, 28),
  (15, 1, 7),
  (16, 0, 23),
  (17, 1, 47),
  (18, 1, 26),
  (19, 0, 32),
  (20, 1, 38),
  (21, 1, 49),
  (22, 1, 28),
  (23, 1, 37),
  (24, 1, 13),
  (25, 0, 32),
  (26, 1, 25),
  (27, 1, 49),
  (28, 0, 6),
  (29, 0, 4),
  (30, 1, 6),
  (31, 0, 20),
  (32, 1, 1),
  (33, 0, 44),
  (34, 1, 12),
  (35, 0, 4),
  (36, 1, 37),
  (37, 0, 45),
  (38, 1, 4),
  (39, 0, 31),
  (40, 1, 20),
  (41, 1, 44),
  (42, 0, 1),
  (43, 1, 27),
  (44, 1, 40),
  (45, 0, 37),
  (46, 0, 31),
  (47, 1, 25),
  (48, 1, 14),
  (49, 1, 36),
  (50, 0, 12);
  
  --
  -- Inserting data into table despesa
  --
  INSERT INTO despesa(idDespesa, descricao, valor, dataDespesa, idEvento) VALUES
  (1, 'Antaridge', 33, '2020-09-21', 33),
  (2, 'Monwoofridge', 76, '2020-07-05', 37),
  (3, 'Chartoplet', 52, '2020-08-19', 41),
  (4, 'Prolifiar', 58, '2020-07-10', 39),
  (5, 'Recordicphone', 78, '2020-07-07', 38),
  (6, 'Contopexor', 28, '2020-05-13', 33),
  (7, 'Monoholdphone', 58, '2020-08-25', 4),
  (8, 'Bijectentor', 17, '2020-04-18', 15),
  (9, 'Probandeflet', 63, '2020-09-19', 42),
  (10, 'Tabcordefscope', 62, '2020-10-25', 41),
  (11, 'Comtectar', 71, '2020-07-03', 31),
  (12, 'Tabniepra', 76, '2020-09-14', 23),
  (13, 'Reholdepscope', 50, '2020-06-22', 6),
  (14, 'Mictellewor', 57, '2020-06-04', 29),
  (15, 'Printculon', 55, '2020-04-23', 22),
  (16, 'Ampcordletra', 79, '2020-05-03', 17),
  (17, 'Subbandridge', 20, '2020-09-02', 49),
  (18, 'Charcesseder', 68, '2020-07-19', 16),
  (19, 'Readleinridge', 26, '2020-07-14', 25),
  (20, 'Cartnieper', 34, '2020-05-22', 47),
  (21, 'Ampcordimor', 44, '2020-05-11', 1),
  (22, 'Stereomuterphone', 67, '2020-09-29', 7),
  (23, 'Readcordar', 72, '2020-10-25', 32),
  (24, 'Monholdewon', 67, '2020-10-20', 21),
  (25, 'Projectimer', 62, '2020-04-24', 45),
  (26, 'Ampleupentor', 49, '2020-05-08', 30),
  (27, 'Stereoplotter', 41, '2020-06-05', 49),
  (28, 'Tecordletphone', 35, '2020-07-11', 31),
  (29, 'Stereowooflet', 38, '2020-11-04', 32),
  (30, 'Tweettaridge', 42, '2020-09-30', 37),
  (31, 'Proputlet', 53, '2020-10-14', 32),
  (32, 'Ampjectfiator', 70, '2020-07-06', 19),
  (33, 'Tweetplottar', 72, '2020-04-21', 38),
  (34, 'Cleancessentor', 69, '2020-04-21', 31),
  (35, 'Monofindommer', 71, '2020-08-25', 25),
  (36, 'Charpickedgphone', 31, '2020-07-29', 42),
  (37, 'Mictinlet', 57, '2020-08-01', 4),
  (38, 'Supbandinscope', 41, '2020-04-16', 37),
  (39, 'Monofinder', 22, '2020-08-07', 24),
  (40, 'Cartcyclader', 75, '2020-06-11', 43),
  (41, 'Armbandentor', 37, '2020-07-22', 44),
  (42, 'Armleadator', 31, '2020-07-04', 44),
  (43, 'Bilictedgon', 51, '2020-04-17', 25),
  (44, 'Amptellopator', 76, '2020-06-18', 50),
  (45, 'Chartectridge', 27, '2020-11-10', 50),
  (46, 'Biceivonor', 31, '2020-08-21', 30),
  (47, 'Tweetcordaquar', 77, '2020-07-01', 8),
  (48, 'Monocessimentor', 64, '2020-07-20', 37),
  (49, 'Comcycler', 64, '2020-08-24', 29),
  (50, 'Tweetbandimphone', 17, '2020-07-19', 24);
  
  --
  -- Inserting data into table eventoimagem
  --
  INSERT INTO eventoimagem(idEvento, idImagem) VALUES
  (47, 47),
  (9, 9),
  (18, 18),
  (4, 4),
  (28, 28),
  (50, 50),
  (45, 45),
  (48, 48),
  (46, 46),
  (23, 23),
  (13, 13),
  (19, 19),
  (42, 42),
  (14, 14),
  (20, 20),
  (49, 49),
  (15, 15),
  (37, 37),
  (43, 43),
  (21, 21),
  (29, 29),
  (38, 38),
  (10, 10),
  (16, 16),
  (5, 5),
  (11, 11),
  (24, 24),
  (30, 30),
  (25, 25),
  (22, 22),
  (44, 44),
  (6, 6),
  (31, 31),
  (39, 39),
  (26, 26),
  (32, 32),
  (17, 17),
  (12, 12),
  (1, 1),
  (34, 34),
  (40, 40),
  (27, 27),
  (33, 33),
  (7, 7),
  (35, 35),
  (41, 41),
  (36, 36),
  (2, 2),
  (8, 8),
  (3, 3);
  
  --
  -- Inserting data into table lote
  --
  INSERT INTO lote(idLote, valor, dataAbertura, dataFechamento, idEvento) VALUES
  (1, 25, '2020-04-23', '2020-04-25', 22),
  (2, 15, '2020-07-05', '2020-07-09', 44),
  (3, 25, '2020-04-21', '2020-04-24', 25),
  (4, 18, '2020-06-28', '2020-06-30', 22),
  (5, 19, '2020-05-19', '2020-05-23', 46),
  (6, 34, '2020-04-18', '2020-04-22', 7),
  (7, 37, '2020-07-14', '2020-07-17', 29),
  (8, 24, '2020-09-06', '2020-09-10', 47),
  (9, 23, '2020-08-29', '2020-09-01', 8),
  (10, 47, '2020-10-19', '2020-10-23', 42),
  (11, 22, '2020-07-25', '2020-07-27', 20),
  (12, 37, '2020-08-30', '2020-09-02', 7),
  (13, 31, '2020-10-11', '2020-10-13', 44),
  (14, 24, '2020-10-09', '2020-10-13', 46),
  (15, 35, '2020-06-11', '2020-06-15', 13),
  (16, 20, '2020-11-08', '2020-11-11', 20),
  (17, 22, '2020-10-06', '2020-10-08', 46),
  (18, 47, '2020-04-21', '2020-04-25', 12),
  (19, 28, '2020-11-12', '2020-11-14', 46),
  (20, 46, '2020-09-14', '2020-09-18', 31),
  (21, 20, '2020-07-06', '2020-07-09', 43),
  (22, 39, '2020-11-15', '2020-11-17', 37),
  (23, 29, '2020-11-03', '2020-11-07', 37),
  (24, 27, '2020-10-07', '2020-10-10', 23),
  (25, 49, '2020-09-29', '2020-10-01', 31),
  (26, 30, '2020-05-09', '2020-05-11', 10),
  (27, 22, '2020-11-09', '2020-11-13', 9),
  (28, 43, '2020-07-14', '2020-07-17', 32),
  (29, 47, '2020-10-29', '2020-10-31', 15),
  (30, 21, '2020-05-22', '2020-05-26', 37),
  (31, 48, '2020-10-15', '2020-10-17', 7),
  (32, 17, '2020-07-20', '2020-07-22', 32),
  (33, 25, '2020-05-01', '2020-05-03', 19),
  (34, 49, '2020-08-27', '2020-08-31', 24),
  (35, 26, '2020-11-15', '2020-11-19', 37),
  (36, 32, '2020-08-17', '2020-08-20', 8),
  (37, 17, '2020-04-21', '2020-04-25', 1),
  (38, 38, '2020-07-02', '2020-07-05', 47),
  (39, 38, '2020-06-30', '2020-07-03', 17),
  (40, 20, '2020-04-15', '2020-04-17', 34);
  
  --
  -- Inserting data into table participaatividade
  --
  INSERT INTO participaatividade(CPF, idEvento, idAtividade, presenca) VALUES
  ('38562911824', 3, 25, 1),
  ('35340081227', 14, 12, 0),
  ('36747824308', 10, 11, 1),
  ('33771931039', 14, 44, 0),
  ('30765394198', 9, 33, 1),
  ('34179556342', 15, 4, 0),
  ('31144959656', 14, 1, 0),
  ('32416400536', 10, 7, 0),
  ('30196530766', 15, 31, 1),
  ('34662195033', 5, 34, 0),
  ('30724652092', 9, 45, 1),
  ('39477688745', 7, 17, 1),
  ('30827338000', 3, 40, 1),
  ('35992966406', 15, 38, 1),
  ('33990502814', 5, 8, 0),
  ('37948835420', 6, 26, 1),
  ('36143339872', 15, 20, 1),
  ('39517389244', 9, 6, 0),
  ('39260980014', 3, 50, 0),
  ('32618621705', 7, 29, 1),
  ('39852265853', 12, 32, 0),
  ('38277667974', 9, 22, 1),
  ('35705099333', 3, 9, 0),
  ('38197795893', 15, 24, 0),
  ('32504996195', 3, 41, 1),
  ('33049501078', 9, 3, 0),
  ('31287767150', 3, 30, 0),
  ('32101910773', 3, 36, 1),
  ('38690174010', 9, 23, 0),
  ('33256139627', 4, 16, 1),
  ('33085529131', 1, 28, 0),
  ('35072935091', 5, 15, 1),
  ('31257500092', 3, 21, 0),
  ('37076348597', 12, 5, 1),
  ('32866496508', 1, 13, 1),
  ('37253821547', 3, 27, 1),
  ('32786903569', 14, 37, 0),
  ('34919610802', 1, 10, 0),
  ('30774347153', 15, 47, 0),
  ('34081245285', 2, 48, 1),
  ('36383688525', 8, 35, 1),
  ('30163620952', 4, 46, 0),
  ('33292661983', 12, 19, 0),
  ('34871516568', 7, 49, 1),
  ('31347449283', 12, 43, 1),
  ('36553364665', 8, 2, 1),
  ('39588047180', 15, 14, 1),
  ('39066245018', 8, 18, 1),
  ('38864095608', 12, 42, 0),
  ('33640892777', 15, 39, 1);
  
  --
  -- Inserting data into table receita
  --
  INSERT INTO receita(idReceita, descricao, valor, dataReceita, idEvento) VALUES
  (1, 'Manufacture of other products of wood', 90, '2020-06-30', 39),
  (2, 'Manufacture of rubber tyres and tubes', 108, '2020-07-18', 15),
  (3, 'Wholesale of solid, liquid and gaseous fuels and related products', 256, '2020-07-19', 14),
  (4, 'Growing of tobacco', 130, '2020-04-06', 25),
  (5, 'Manufacture of ovens, furnaces and furnace burners', 126, '2020-09-10', 44),
  (6, 'Distilling, rectifying and blending of spirits', 199, '2020-05-30', 16),
  (7, 'Collection of hazardous waste', 107, '2020-10-14', 27),
  (8, 'Growing of other non-perennial crops', 109, '2020-04-08', 26),
  (9, 'Printing', 112, '2020-08-20', 48),
  (10, 'Activities of extraterritorial organizations and bodies', 252, '2020-07-28', 40),
  (11, 'Growing of grapes', 117, '2020-04-09', 23),
  (12, 'Activities of extraterritorial organizations and bodies', 129, '2020-04-02', 49),
  (13, 'Manufacture of other special-purpose machinery', 177, '2020-06-06', 25),
  (14, 'Repair of other equipment', 133, '2020-09-13', 29),
  (15, 'Other human health activities', 148, '2020-10-21', 6),
  (16, 'Sea and coastal passenger water transport', 240, '2020-08-17', 42),
  (17, 'Landscape care and maintenance service activities', 89, '2020-04-01', 31),
  (18, 'Defence activities', 188, '2020-04-06', 22),
  (19, 'Manufacture of engines and turbines, except aircraft, vehicle and cycle engines', 70, '2020-11-14', 31),
  (20, 'Manufacture of cutlery, hand tools and general hardware', 221, '2020-10-29', 32),
  (21, 'Activities of collection agencies and credit bureaus', 53, '2020-10-25', 9),
  (22, 'Residential care activities for the elderly and disabled', 223, '2020-04-12', 10),
  (23, 'Event catering', 248, '2020-04-09', 3),
  (24, 'Social work activities without accommodation for the elderly and disabled', 137, '2020-10-14', 36),
  (25, 'Activities of households as employers of domestic personnel', 256, '2020-04-05', 44),
  (26, 'Distilling, rectifying and blending of spirits', 204, '2020-08-12', 49),
  (27, 'Other sports activities', 73, '2020-08-11', 8),
  (28, 'Weaving of textiles', 285, '2020-07-04', 13),
  (29, 'Freight transport by road', 185, '2020-10-23', 40),
  (30, 'Manufacture of other articles of paper and paperboard', 50, '2020-06-15', 19),
  (31, 'Building completion and finishing', 137, '2020-05-24', 37),
  (32, 'Manufacture of bicycles and invalid carriages', 251, '2020-06-08', 2),
  (33, 'Manufacture of batteries and accumulators', 94, '2020-05-16', 49),
  (34, 'Printing', 73, '2020-04-02', 47),
  (35, 'Weaving of textiles', 186, '2020-09-28', 12),
  (36, 'Other food service activities', 264, '2020-07-20', 10),
  (37, 'Extraction of crude petroleum', 67, '2020-07-09', 35),
  (38, 'Manufacture of corrugated paper and paperboard and of containers of paper and paperboard', 171, '2020-08-27', 23),
  (39, 'Activities of political organizations', 115, '2020-06-13', 1),
  (40, 'Forging, pressing, stamping and roll-forming of metal', 241, '2020-09-10', 36),
  (41, 'Retail sale of computers, peripheral units, software and telecommunications equipment in specialized stores', 112, '2020-11-11', 28),
  (42, 'Quarrying of stone, sand and clay', 187, '2020-08-10', 40),
  (43, 'Inland passenger water transport', 225, '2020-09-01', 31),
  (44, 'Manufacture of military fighting vehicles', 195, '2020-09-03', 1),
  (45, 'Manufacture of cocoa, chocolate and sugar confectionery', 187, '2020-05-27', 14),
  (46, 'Renting and leasing of motor vehicles', 215, '2020-04-02', 11),
  (47, 'Manufacture of grain mill products', 237, '2020-11-05', 33),
  (48, 'Growing of tobacco', 99, '2020-04-06', 22),
  (49, 'Growing of vegetables and melons, roots and tubers', 68, '2020-04-04', 49),
  (50, 'Building completion and finishing', 182, '2020-06-03', 17);
  
  --
  -- Inserting data into table receitainscricaoevento
  --
  INSERT INTO receitainscricaoevento(CPF, idEvento, dataPagamento) VALUES
  ('39260980014', 3, '2020-06-09'),
  ('30163620952', 4, '2020-11-12'),
  ('36553364665', 8, '2020-09-23'),
  ('35072935091', 5, '2020-09-13'),
  ('34871516568', 7, '2020-04-16'),
  ('37948835420', 6, '2020-08-16'),
  ('30774347153', 15, '2020-08-28'),
  ('31257500092', 3, '2020-09-13'),
  ('39852265853', 12, '2020-09-29'),
  ('33256139627', 4, '2020-04-30'),
  ('37253821547', 3, '2020-07-31'),
  ('30827338000', 3, '2020-08-31'),
  ('38277667974', 9, '2020-05-10'),
  ('30724652092', 9, '2020-08-06'),
  ('33990502814', 5, '2020-05-30'),
  ('34081245285', 2, '2020-05-13'),
  ('39477688745', 7, '2020-07-22'),
  ('36383688525', 8, '2020-11-06'),
  ('35340081227', 14, '2020-07-20'),
  ('33049501078', 9, '2020-04-21'),
  ('30765394198', 9, '2020-05-30'),
  ('39066245018', 8, '2020-10-28'),
  ('33085529131', 1, '2020-04-22'),
  ('35705099333', 3, '2020-04-18'),
  ('38690174010', 9, '2020-07-23'),
  ('32504996195', 3, '2020-04-15'),
  ('32618621705', 7, '2020-10-12'),
  ('38197795893', 15, '2020-06-17'),
  ('32866496508', 1, '2020-10-31'),
  ('32101910773', 3, '2020-06-24'),
  ('33292661983', 12, '2020-07-17'),
  ('38864095608', 12, '2020-05-20'),
  ('39588047180', 15, '2020-07-29'),
  ('36143339872', 15, '2020-09-22'),
  ('32786903569', 14, '2020-04-23'),
  ('31287767150', 3, '2020-08-08'),
  ('34179556342', 15, '2020-06-01'),
  ('34919610802', 1, '2020-07-07'),
  ('37076348597', 12, '2020-08-13'),
  ('31347449283', 12, '2020-10-06'),
  ('36747824308', 10, '2020-08-22'),
  ('38562911824', 3, '2020-08-27'),
  ('35992966406', 15, '2020-10-13'),
  ('30196530766', 15, '2020-06-02'),
  ('39517389244', 9, '2020-04-26'),
  ('31144959656', 14, '2020-04-24'),
  ('32416400536', 10, '2020-06-05'),
  ('33771931039', 14, '2020-05-13'),
  ('33640892777', 15, '2020-10-29'),
  ('34662195033', 5, '2020-10-24');