sql_script.txt

CREATE TABLE Users (
    user_id int NOT NULL UNIQUE AUTO_INCREMENT,
    email LONGTEXT,
    password LONGTEXT NOT NULL,
    citizenship varchar(255) NOT NULL DEFAULT 'Sweden',
    PRIMARY KEY(user_id)
    );
    
CREATE TABLE Country(
    country_id int NOT NULL UNIQUE AUTO_INCREMENT,
    country_name varchar(255) NOT NULL,
    PRIMARY KEY(country_id)
    );
    
    
CREATE TABLE Admin (
    admin_id int NOT NULL,
    email varchar(255) NOT NULL,
    password varchar(255) NOT NULL
    );
CREATE TABLE Bookmark(
    user_id int NOT NULL,
    country_id int NOT NULL,
    FOREIGN KEY (user_id) REFERENCES Users(user_id) 
    ON UPDATE CASCADE 
    ON DELETE CASCADE,
    FOREIGN KEY (country_id) REFERENCES Country(country_id) 
    ON UPDATE CASCADE
	ON DELETE CASCADE);

CREATE TABLE IF NOT EXISTS regulation (
`ID` VARCHAR(255) NOT NULL,
`FROM` VARCHAR(255) NOT NULL,
`TO` VARCHAR(255) NOT NULL,
`Boarding` LONGTEXT NULL,
`Qurantine` LONGTEXT NULL,
`Vaccine` VARCHAR(255) NULL,
`Regulation` LONGTEXT NULL,
`Face_Mask` VARCHAR(255) NULL,
`Public_Transportation` VARCHAR(255) NULL,
`Businesses` VARCHAR(255) NULL,
`Restaurants` VARCHAR(255) NULL,
`Reminder` LONGTEXT NULL
);

INSERT INTO REGULATION VALUES
('SWE_IND','Sweden','India','Submit complete and factual information in self-declaration form on the online Air Suvidha portal before the scheduled travel\, including last 14 days travel details.  Upload a negative COVID-19 RT-PCR report*. The test should have been conducted within 72 hrs prior to undertaking the journey. Each passenger shall also submit a declaration with respect to authenticity of the report and will be liable for criminal prosecution\, if found otherwise.','7 to 14 days depending on the state the passenger is travelling to. Home quarantine & Institutional quarantine options based on the state travelled to. ','If travellers are fully Vaccinated by the vaccines recognised by the Indian Government ','NULL','Required','Limited','Open in low risk areas','Open in low risk areas','1. Valid visa required2 Fill out the Air Suvedha Form 3. Negative PCR test taken within 72 hours of arrival4. Random PCR test upon arrival');

INSERT INTO REGULATION VALUES
('SWE_TUR','Sweden','Turkey','1. Passengers over the age of 12 must have a document showing a negative COVID-19 test result to enter Turkey. Either:     a. PCR test taken in the last 72 hours     b. Rapid antigen test taken in the last 48 hours2. Fully vaccinated and recovered patients are exempt if they can provide either:    a. Vaccination certificate showing the last dose was given at least 14 days before arrival    b. Medical certificate showing recovery in the last 6 months','Travelers arriving from countries considered high-risk\, or who have been to high-risk countries in the last 14 days\, are required to quarantine in Turkey. Quarantine is carried out at accommodation facilities determined by the Turkish government.','Need COVID proof. Being fully vaccinated is one acceptable way to do this.','NULL','Required in some cases','Operating','Open','Open','1. Need a valid visa 2. Traveler Entry Form3. Istanbul Airport has test centers which offer service 24/7. 4. COVID proofa. Negative PCR test taken within 72 hours before arrivingb. Negative antigen test taken within 48 hours before arrivingc. Recovery certificate from the past 6 monthsd. COVID vaccination');

INSERT INTO REGULATION VALUES
('SWE_HKG','Sweden','Hong Kong','1. has not stayed for more than two hours in the 14-day Period in any place that is on the “List of Specified Places with Flight Suspension”;2. Present recognised vaccination record;3. Negative result proof of a PCR-based nucleic acid test for COVID-19 within 48 hours(2) (including documentary proofs that the lab is ISO15189 accredited or Government recognised); and4. Confirmation of room reservation in a DQH for not less than 14 nights starting from the day of arrival at Hong Kong','1. Hotel quratine for 14 days 2. Home qurantine for 7 days','Yes',NULL,'Required','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES
('SWE_AUT','Sweden','Austria','1. Proof of full vaccination (2 jabs) OR proof of past infection (the medical document needs to show the date of recovery – (for guests from the UK: an NHS email/text of a positive test is not sufficient) 2. AND a negative PCR test (valid for 72 hours) OR proof of a booster jab (booster is valid from the first day) 3. See further details below (What proof is accepted?)','Entry without vaccination / recovery Entry for touristic purposes or business travel is not possible without quarantine\, if you cannot meet the “2-G” requirements. ','Yes',null,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_BEL','Sweden','Belgium','1. You have to fill in the Passenger Location Form (PLF) within 6 months before your arrival in Belgium, even if you are fully vaccinated.2. Check the colour code of your country and/or whether it is listed as a very high-risk country. There are currently 5 colours: green, orange, red, dark red and grey.3. Check which COVID certificate you have. There are three types of certificates.','You have to quarantine: as soon as you feel sick, but have not yet taken a positive test when you aren’t fully vaccinated and had a high-risk contact with a person who has COVID-19 (you were together for more than 15 minutes at a distance of less than 1.5 metres and without both of you wearing a face mask). in some cases if you were abroad for more than 48 hours or will be staying in Belgium for more than 48 hours. Read here about when you have to go into quarantine after arriving in Belgium. Quarantine and testing are mandatory. Those who do not abide by the rules risk a fine of EUR 250.','For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_BGR','Sweden','Bulgaria','Travellers from green and orange countries (according to Bulgaria''s national classification) can enter Bulgaria without further restrictions if their ''EU Digital COVID Certificate'' (EUDCC) contains one of the following: Proof of full vaccination, valid 14 days after the last scheduled dose. The combination of one dose of Vaxzevria (AstraZeneca) with one dose of Comirnaty (BioNTech and Pfizer) is also accepted; Proof of recovery from COVID-19. Validity: between 11 and 180 days after the positive result to a COVID-19 test). Negative result to a pre-departure COVID-19 test. Accepted tests: molecular (PCR) test, valid 72 hours, and rapid antigen tests, valid 48 hours.','For travellers from green and orange countries (according to Bulgaria''s national classification) who do not provide the documents required, a 10-day quarantine is imposed.','For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_HRV','Sweden','Croatia','Passengers coming directly from the countries and/or regions of the European Union, i.e. countries and/or regions of the Schengen area and Schengen associated countries, regardless of their citizenship, will be allowed entry into the Republic of Croatia if they possess a valid EU Digital COVID Certificate.','or if they perform PCR testing or rapid antigen testing - RAT for SARS-CoV-2 immediately upon their arrival in the Republic of Croatia (at their own expense), with the obligation to stay in self-isolation until they obtain a negative test result. In case they cannot get tested, they have to self-isolate for seven (7) days.','For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_CYP','Sweden','Cyprus',NULL,NULL,NULL,NULL,'Required','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_CZE','Sweden','Czech Republic','All persons traveling to the territory of the Czech Republic from EU countries, if they have not spent at least 12 hours in the last 14 days in a country outside the European Union, a) are required to complete Public Health Passenger Locator Form before the start of the transportation; b) are required to have the following before the start of the transportation: i) the result of an RT-PCR test or RAT test, or ii) national certificate on vaccination that has been carried out or a national certificate of completed vaccination, or iii) medical certificate on suffering COVID-19 disease in the past; c) when requested to do so during a border or residence check, are required to present a document confirming that they filled out the Public Health Passenger Locator Form, the document referred to in letter b), or a written document that an exemption applies to the given person according to this Protective Measure;',NULL,'For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_DNK','Sweden','Denmark','If you are vaccinated or previously infected: There are no travel restrictions when entering Denmark. If you are not vaccinated or previously infected: There are no travel restrictions if you enter from EU or Schengen countries . If you enter from a country outside EU and Schengen, you must take a test at a test centre within 24 hours upon entry (self-tests are not valid for this purpose).','Not required.','No',NULL,'Recommended','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_ENT','Sweden','Estonia','Entry into Estonia for the purposes of work, studying, tourism, sports etc is also allowed for the citizens of other countries (both European Union and third countries’). The citizens of third countries have to have a valid Schengen visa in order to be able to enter the country. In certain cases it is obligatory to stay in self-isolation after entering the country.','People who come from a European country where the infection rate is over 300 have to stay in self-isolation for 7 days. A person who has completed the course of vaccinations and no more than a year has passed from the end of it or who has recovered from COVID-19 within the past six months and have been declared healthy by a doctor is released from the restrictions.',NULL,NULL,'Required','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_FIN','Sweden','Finland','Person may be granted entry into Finland from any country if they present a certificate of a complete and valid vaccination series (either one or two doses depending on the vaccine). OR a single certificate that the person has recovered from covid-19 virus and has gotten one dose of vaccine. OR EU digital COVID certificate that proves the person has recovered from covid-19 within 6 months. All the above-mentioned requirements apply to persons born in 2006 or earlier.','Please note that, based on an individual assessment conducted by a communicable disease control physician, you may be ordered to have a health check or to isolate or quarantine, regardless of the country from which you are coming or what age you are, if this is necessary for preventing the spread of COVID-19. Health checks can also be made mandatory for all travellers under a Regional State Administrative Agency regulation (Communicable Diseases Act 2016/1227).','For COVID certificate only.',NULL,'Recommended','Operating','Open in most area','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_FRA','Sweden','France','For travelers vaccinated within the meaning of European regulations, no more tests is required on departure. Proof of a complete vaccination schedule becomes sufficient to arrive in France, regardless of the country of origin, as was the case before the distribution of the Omicron variant. For unvaccinated travellers, the obligation to present a negative test to travel to France remains, but the measures on arrival (test, isolation) are lifted when they come from countries on the "green" list, characterized by a moderate circulation of the virus. When unvaccinated travelers come from a country on the "orange" list, they must continue to present a compelling reason justifying the need for them to come to mainland France and may still be subject to a random test on arrival. Travelers who test positive will have to isolate themselves, in accordance with the recommendations of the Health Insurance.','Irrespective of their country of departure, travellers presenting symptoms of COVID-19 infection upon arrival in French territory will be required to quarantine, or, if necessary, will be placed and held in isolation by the competent Prefect for the area.','A vaccination pass is necessary in France for everyone aged 16 and older to participate in most social or cultural activities.',NULL,'Required in some cases','Operating','Open','Open','You may be asked to fill two forms before boarding for France • The EU-PLF form is for travellers arriving on the territory of a European Union Member State. While rules to fill the form may vary between EU countries, it is compulsory for travellers who wish to enter France. • The Eos electronic form is for travellers coming from ‘orange’ countries and territories.');

INSERT INTO REGULATION VALUES 
('SWE_DEU','Sweden','Germany','In principle, entry is possible from: a) EU member states b) states associated with Schengen: Iceland, Norway, Switzerland and Liechtenstein c) other countries from which entry is possible in light of the epidemiological situation assessment by the EU.','Under the Ordinance on Coronavirus Entry Regulations, persons entering Germany following a stay in a high-risk area or area of variant of concern in the last ten days must proceed directly to their destination following entry and self-isolate there (quarantine). After a stay in a high-risk area travellers must self-isolate for 10 days, after a stay in an area of variant of concern for 14 days.',NULL,NULL,'Required','Operating','Partially open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_GRC','Sweden','Greece','is permitted by showing the EU Digital COVID Certificate, which contains information about one of the following: a) Vaccination certificate (for those who have completed vaccination for COVID-19 at least fourteen (14) days before arrival) valid for 9 months after the completion of the basic vaccination and without time limit for travellers who have received the booster dose, or b) Certificate of recovery from SARS-CoV-2 infection issued 14 days after the day of the first positive COVID-19 test (PCR or Rapid Antigen test) and valid for 180 days thereafter, or c) Certificate of negative test result, namely, negative molecular test result (PCR) performed up to 72 hours before the scheduled arrival or negative Rapid Antigen test result performed up to 24 hours before the scheduled arrival.','All travellers are subject to random obligatory Covid-19 tests upon arrival. If found positive, a five (5) day quarantine under supervision is required either at home or at a designated temporary residence assigned by the appropriate authorities. The quarantine period starts the next day of their positive diagnosis. Following the five (5) day period and if the symptoms have receded and the travellers are feverless for 24 hours without the use of antipyretics, they are released from quarantine. If the fever insists, the travellers remain in isolation until the fever has fully receded. The above travellers must wear high protection breathing mask (FFP2 or N95) or a combination of two masks for at least 5 days after their release from isolation.','For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_HUN','Sweden','Hungary','Foreign citizens arriving from abroad in passenger traffic – unless otherwise specified by law or government decree – shall not enter Hungary.','In case of a Hungarian citizen, should a medical check not reveal the suspicion of infection and the Hungarian citizen has a home address or residence in Hungary, she/he will be placed into mandatory home quarantine for 10 days; the Hungarian citizen not living abroad and in the absence of home address or residence in Hungary, she/he will be placed into in a quarantine designated by the competent epidemiological authority for 10 days; the Hungarian citizen living abroad without home address or residence in Hungary, she/he will be placed into a quarantine or official home quarantine designated by the competent epidemiological authority for 10 days.','For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_IRL','Sweden','Ireland','Everyone arriving in Ireland must complete a Passenger Locator Form before boarding a flight or taking a boat to Ireland. You must also have one of the following when you arrive in Ireland: An EU Digital COVID Certificate (DCC) that shows you are fully vaccinated with an EMA approved vaccine, or have recovered from COVID-19, or Other acceptable proof that you have been fully vaccinated with an approved vaccine, or you have recovered from COVID-19, or Proof of a negative RT-PCR test taken no more than 72 hours before your arrival','You do not have to quarantine when you arrive in Ireland. You should follow public health advice if you develop symptoms of COVID-19 or if you are a close contact of a confirmed case of COVID-19.','For COVID certificate only.',NULL,'Required in some cases','Reduced','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_ITA','Sweden','Italy','For entry to the national territory, one of the conditions of the Green Pass will be sufficient: certificate of vaccination, certificate of recovery or negative test result.','5 days fiduciary isolation is compulsory only for those who enter Italy without having presented a valid certification and it must be conducted at the address declared in the Passenger Locator Form, with the mandatory duty to undertake a molecular or antigenic swab at the end of the 5 days isolation.','For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_LVA','Sweden','Latvia','Beginning 1 March 2022, one of the following documents must be presented to enter Latvia: 1) the interoperable EU COVID certificate on vaccination or recovery (in a smart device, or in paper format) 2) a certificate of vaccination or recovery issued in USA, the United Kingdom, the Australian Commonwealth, or Canada 3) a negative COVID-19 test result (for an RNA test taken within the past 72 hours, or for an antigen test taken within the past 48 hours)','requirement of going into self-isolation after arrival has been abolished since 12.02.2022.','For COVID certificate only.',NULL,'Required','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_LTU','Sweden','Lithuania','Are no longer the subject to any travel-related COVID-19 management restrictions. This means that arrivals from these countries are not required to complete the questionnaire, to perform a test, to have vaccination or recovery documents.',NULL,'For COVID certificate only.',NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_LUX','Sweden','Luxembourg','for any travel by air transport to the Grand Duchy, persons over the age of 12 years and 2 months, authorised to enter Luxembourg (regardless of nationality), must present, before boarding a flight to Luxembourg: either a vaccination certificate attesting to a complete vaccination pattern against COVID-19. Provided that the vaccine administered is accepted in the Grand-Duchy, vaccination certificates issued by a Member State of the European Union or the Schengen Area (EU27 + Iceland, Liechtenstein, Norway, Switzerland), as well as certificates issued by certain third countries are also accepted. The validity of the vaccination certificate is 9 months from the date when the vaccination pattern is considered complete. The validity of the certificate for the booster vaccination is unlimited (see FAQs); or a recovery certificate issued by a physician or national authority of an EU Member State or Schengen Area Member State (EU27 + Iceland, Liechtenstein, Norway, Switzerland), as well as certificates issued by a number of third countries and accepted by Luxembourg, for persons who have had a recent SARS-CoV-2 infection within 6 months prior to travel and who have completed the applicable isolation period in the respective country with resolution of all symptoms of infection (see FAQ); or the negative result (on paper or electronically)','There is currently no requirement for quarantine on arrival.',NULL,NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_MLT','Sweden','Malta','1. Submit their passenger locator form (PLF) via https://app.euplf.eu/#/, and provide the QR code at check in and on arrival in Malta in digital format A false declaration will be considered a criminal offence. Travellers must then hand their documents to the health staff upon arrival at Malta International Airport or at the Sea Port terminals. 2. Provide proof of valid vaccination certificate​ recognized by the Superintendent of Public Health.','Unless all the above criteria are satisfied, persons will need to undergo a 14 day mandatory quarantine period in accordance with the Standards for Quarantine for Travellers​​​.​(effective from 14th February 2022) With respect to the  quarantine period for passengers in possession of a vaccine certificate with a booster dose issued by the Maltese authorities, in cases where the last dose is administered less than 14 days prior to entering Malta, the traveller can be released from quarantine once 14 days passed from administration of the booster/last dose. Accordingly, for example, if a passenger with a vaccine certificate issued by the Maltese authorities  returns to Malta on the 6th day following administration of booster dose, besides presenting a negative PCR test result prior to boarding, he/she would be asked to go into mandatory quarantine for 8 days.',NULL,NULL,'Required','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_NLD','Sweden','Netherlands','You will need to show proof of vaccination, a Digital COVID Certificate (DCC) based on proof of recovery or a negative test result. If you are travelling by air, complete a health declaration form. Do a self-test after arriving in the Netherlands. Even if you tested negative before travelling.','From 00.01 on 25 February 2022 people travelling to the Netherlands no longer have to self-quarantine on arrival.',NULL,NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_POL','Sweden','Poland','1. Passenger Locator Form2. EU digital COVID certificate','Travellers, regardless of their means of transport (collective or individual, including crossing the border on foot), are subject to a 7-day entry quarantine, unless they meet one of the following conditions: 1) they have completed a full vaccination cycle, and 14 days (counting from the day following the date of the final dose) have passed since their final dose, 2) their vaccination is confirmed by an EU Digital COVID Certificate or by another document in Polish or in English confirming vaccination with a vaccine which has been granted a marketing authorisation within the European Union, 3) they have recovered from a SARS-CoV-2 infection (so-called “convalescents”) at most 6 months before the day on which they cross the border of the Republic of Poland. Convalescents are obliged to present a document confirming recovery from the disease, issued in Polish or in English, e.g. an EU Digital COVID Certificate, 4) they present a negative COVID-19 test result, confirmed by an EU Digital COVID Certificate or by another document in Polish or in English. The test must be performed at most 48 hours before the border is crossed, 5) they are children not older than 12 travelling under the guardianship of adults who are vaccinated against COVID-19 or have a negative COVID-19 test result, 6) they are subject to other exemptions listed in § 3 of the Regulation of the Council of Ministers of 6 may 2021 on the establishment of certain restrictions, orders, and prohibitions in connection with the occurrence of an epidemic.',NULL,NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_PRT','Sweden','Portugal','- A valid vaccination EU Digital COVID Certificate (with a complete vaccination schedule or with a complete vaccination schedule and a vaccine booster)- Or a valid test or recovery EU Digital COVID Certificate,- Or a valid vaccination certificate- Or a negative RT-PCR Test (or similar NAAT test) - 72h before boarding, or- Or a negative Laboratorial Rapid Antigen Test - 24h before boarding',NULL,'For COVID certificate only.',NULL,'Required in some cases','Operating','Partially open','Partially open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_ROU','Sweden','Romania','1) Proof of full vaccination or, 2) Proof of recovery from COVID-19. Validity: 6 months or, 3) Negative result to a molecular (PCR) test. Validity: 72 hours','Travellers from green, yellow and red who do not hold the documents required must quarantine for 10 days.',NULL,NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_SVK','Sweden','Slovakia','need to fill form "Registration at arrival from abroad"','A 14-day self-isolation, which may be ended with a negative RT-PCR test or antigen test result after arrival (for exemptions see below).',NULL,NULL,'Required','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES 
('SWE_SVN','Sweden','Slovenia','As of 19 February 2022, restrictions due to Covid-19 no longer apply when entering Slovenia','travellers are no longer be ordered to quarantine at home.',NULL,NULL,'Required in some cases','Operating','Open','Open',NULL);

INSERT INTO REGULATION VALUES
('SWE_ESP','Sweden','Spain','Everyone entering Spain from other countries, including international transits, regardless of nationality or age, must complete a Health Control Form (FCS) and obtain their QR code to present at boarding, and at health control points on arrival in Spain. If they are also travelling from an at-risk country, in order to enter Spain they will also need to present 1: An EU Digital COVID Certificate (see information). 2: Or a certificate of vaccination, a certificate of diagnosis or a certificate of recovery.','As of December 27th, 2021, no traveler from abroad is subject to quarantine upon arrival in Spain.',NULL,NULL,'Required in some cases','Operating','Open','Open',NULL);


ALTER TABLE `regulation` ADD PRIMARY KEY(`ID`);

CCREATE TABLE SOURCE(
	Regulation_ID VARCHAR(7) NOT NULL,
	Source_link	VARCHAR(255) NOT NULL,
    CONSTRAINT FK_SourceReg FOREIGN KEY (Regulation_ID)
    REFERENCES regulation(ID)
    ON DELETE CASCADE
    ON UPDATE CASCADE
);

INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_IND','https://www.newdelhiairport.in/pdf/RevisedGuidelinesforInternationalArrivaldated20thJanuary2022-new-21-01-22.pdf');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_IND','https://www.newdelhiairport.in/airsuvidha/apho-registration');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_IND','https://www.civilaviation.gov.in/sites/default/files/State_wise_quarantine_regulation-converted.pdf');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_HKG','https://www.coronavirus.gov.hk/eng/inbound-travel.html');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_HKG','https://www.coronavirus.gov.hk/eng/public-transport-faq.html#:~:text=The%20Regulation%20requires%20that%20all,that%20is%20not%20in%20service)');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_TUR','https://www.visasturkey.com/travel-and-entry-restrictions/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_TUR','https://www.visasturkey.com/vaccinations-for-turkey/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_AUT','https://www.austria.info/en/service-and-facts/coronavirus-information/entry-regulations');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_AUT','https://www.austria.info/en/service-and-facts/coronavirus-information#:~:text=The%20Austrian%20Covid%20rules%20from%2019%20February%20to%204%20March&text=FFP2%20masks%20remain%20mandatory%20in,is%20valid%20for%20270%20days.');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_BEL','https://www.info-coronavirus.be/en/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_BGR','https://europa.eu/youreurope/citizens/travel/travel-and-covid/bulgaria/index_en.htm');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_HRV','https://mup.gov.hr/uzg-covid/english/286212');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_HRV','https://hr.usembassy.gov/covid-19-information/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_CYP','https://www.pio.gov.cy/coronavirus/eng');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_CZE','https://www.mvcr.cz/mvcren/article/coronavirus-information-of-moi.aspx');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_DNK','https://en.coronasmitte.dk/travel-rules/covidtravelrules');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_ENT','https://vm.ee/en/information-countries-and-self-isolation-requirements-passengers');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_ENT','https://kriis.ee/en/travelling-crossing-state-border/travelling-estonia/coming-estonia');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_FIN','https://valtioneuvosto.fi/en/information-on-coronavirus/current-restrictions/travel-to-and-from-finland#:~:text=Entry%20into%20the%20country%20is,right%20to%20return%20to%20Finland.');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_FRA','https://www.diplomatie.gouv.fr/en/coming-to-france/coming-to-france-your-covid-19-questions-answered/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_FRA','https://www.interieur.gouv.fr/covid-19-international-travel');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_DEU','https://www.auswaertiges-amt.de/en/visa-service/EinreiseUndAufenthalt#:~:text=Due%20to%20the%20COVID%2D19,on%20the%20place%20of%20departure.');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_GRC','https://www.gov.uk/foreign-travel-advice/greece/entry-requirements');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_GRC','https://travel.gov.gr/#/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_HUN','https://www.police.hu/en/content/information-on-general-rules-of-border-crossing');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_HUN','https://konzuliszolgalat.kormany.hu/en');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_IRL','https://www.citizensinformation.ie/en/travel_and_recreation/travel_to_ireland/travel_to_ireland_during_covid.html');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_ITA','https://www.salute.gov.it/portale/nuovocoronavirus/dettaglioContenutiNuovoCoronavirus.jsp?lingua=english&id=5412&area=nuovoCoronavirus&menu=vuoto');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_LVA','https://www.mfa.gov.lv/en/information-travellers-latvia-provisions-preventing-spread-covid-19');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_LTU','https://www.govilnius.lt/media-news/important-information-regarding-the-coronavirus');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_LUX','https://covid19.public.lu/en/travellers/visiting-luxembourg.html');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_MLT','https://deputyprimeminister.gov.mt/en/health-promotion/covid-19/Pages/travel.aspx');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_NLD','https://www.government.nl/topics/coronavirus-covid-19/visiting-the-netherlands-from-abroad/self-quarantine');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_NLD','https://www.government.nl/topics/coronavirus-covid-19/visiting-the-netherlands-from-abroad/checklist-entry');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_POL','https://www.gov.pl/web/coronavirus/travel');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_PRT','https://www.visitportugal.com/en/content/covid-19-measures-implemented-portugal');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_ROU','https://europa.eu/youreurope/citizens/travel/travel-and-covid/romania/index_en.htm');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_SVK','https://korona.gov.sk/en/travelling-to-slovakia-and-covid19/');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_SVN','https://www.gov.si/en/topics/coronavirus-disease-covid-19/border-crossing/#:~:text=Useful%20links-,As%20of%2019%20February%202022%2C%20restrictions%20due%20to%20Covid%2D19,ordered%20to%20quarantine%20at%20home.');
INSERT INTO SOURCE(Regulation_ID,Source_link) VALUES ('SWE_ESP','https://travelsafe.spain.info/en/');

INSERT INTO COUNTRY (country_name) VALUES ('India');
INSERT INTO COUNTRY (country_name) VALUES ('Turkey');
INSERT INTO COUNTRY (country_name) VALUES ('Hong Kong');
INSERT INTO COUNTRY (country_name) VALUES ('Austria');
INSERT INTO COUNTRY (country_name) VALUES ('Belgium');
INSERT INTO COUNTRY (country_name) VALUES ('Bulgaria');
INSERT INTO COUNTRY (country_name) VALUES ('Croatia');
INSERT INTO COUNTRY (country_name) VALUES ('Cyprus');
INSERT INTO COUNTRY (country_name) VALUES ('Czech Republic');
INSERT INTO COUNTRY (country_name) VALUES ('Denmark');
INSERT INTO COUNTRY (country_name) VALUES ('Estonia');
INSERT INTO COUNTRY (country_name) VALUES ('Finland');
INSERT INTO COUNTRY (country_name) VALUES ('France');
INSERT INTO COUNTRY (country_name) VALUES ('Germany');
INSERT INTO COUNTRY (country_name) VALUES ('Greece');
INSERT INTO COUNTRY (country_name) VALUES ('Hungary');
INSERT INTO COUNTRY (country_name) VALUES ('Ireland');
INSERT INTO COUNTRY (country_name) VALUES ('Italy');
INSERT INTO COUNTRY (country_name) VALUES ('Latvia');
INSERT INTO COUNTRY (country_name) VALUES ('Lithuania');
INSERT INTO COUNTRY (country_name) VALUES ('Luxembourg');
INSERT INTO COUNTRY (country_name) VALUES ('Malta');
INSERT INTO COUNTRY (country_name) VALUES ('Netherlands');
INSERT INTO COUNTRY (country_name) VALUES ('Poland');
INSERT INTO COUNTRY (country_name) VALUES ('Portugal');
INSERT INTO COUNTRY (country_name) VALUES ('Romania');
INSERT INTO COUNTRY (country_name) VALUES ('Slovakia');
INSERT INTO COUNTRY (country_name) VALUES ('Slovenia');
INSERT INTO COUNTRY (country_name) VALUES ('Spain');

ALTER TABLE users ADD username varchar(255) NOT NULL;

DROP TABLE admin;
CREATE TABLE admin (
    admin_id int NOT NULL UNIQUE AUTO_INCREMENT,
    adminname varchar(255) NOT NULL,
    email LONGTEXT,
    password LONGTEXT NOT NULL,
    PRIMARY KEY(admin_id)
    );