LE LANGAGE SQL

CREATE DATABASE 'NETWORK';
USE 'NETWORK';

CREATE TABLE RIPE (
   Cookie_Name VARCHAR(30) NOT NULL PRIMARY KEY,
   Purpose VARCHAR(500) NOT NULL,
   Term VARCHAR(60) NOT NULL
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "Serverid,JSESSIONID,PHPSESSID",
     "These cookie identifies the user. It is used for tying the user session to a particular application server. This cookie is set when you visit any of our pages being served from our content management systems. It is used to help our server to handle your requests in the most efficient way and is deleted when you quit your browser.",
     "Expires when the browser session is closed."
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "__utma, ..., __utmz",
     "These cookies are used to collect information about how visitors use our site. We use Google Analytics to compile reports and to help us improve the site. The cookies collect information anonymously and includes the number of visitors to the site, where visitors have come to the site from and the pages they visited on a RIPE NCC website.",
     "Expires after 2 years"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "crowd.token_key",
     "This cookie identifies the user. It is used to authenticate logged-in single-sign-on (RIPE NCC Access) users.",
     "Expires when the browser session is closed"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "_pk_id.4.1234",
     "This cookie is used to keep track of traffic for analytic purposes when accessing a RIPE Meeting website.",
     "Expires after 2 years"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "_pk_ses.4.1234",
     "This cookie is used to keep track traffic for analytic purposes upon accessing RIPE Meeting sites. This information is not shared with third parties.",
     "Expires after 30 minutes"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "lastKnownLocationLng,lastKnownLocationLat,lastKnownLocationZoom",
     "This cookie saves the state of the LIR Locator application. When the user opens the page again, they will find the same location they had in their previous visit.",
     "Expires after 3 months"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "m2mTermsAccepted",
     "This cookie is set when users accept Terms of Service or Terms and Conditions of a service. If this cookie is not set, users will be asked to accept terms every time before they use a RIPE NCC service.",
     "Expires after 3 months"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "firstVisit-beta",
     "This cookie prevents help information from appearing again after the user has discarded it.",
     "Expires after 3 months"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "stat-session,atlasessp",
     "These are standard cookies for user identification and session persistence.",
     "Expires after 2 weeks"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "stat-csrftoken,csrftoken",
     "These cookies enhance security to protect from cross-site scripting attacks. Presently they are used to support comments forms.",
     "Expires after 1 year"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "crowd.ripe.hint",
     "This cookie is used to identify logged in users among RIPE NCC services (Single Sign On).",
     "Expires when the browser session is closed"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "PREF",
     "This cookie is used for YouTube services. It is handling user preferences. It is beyond the RIPE NCC's control. Use of YouTube services like embedded video require that the user request those services from YouTube directly, which in turn sets this cookie. Users interested in Google policies around this cookie should consult their privacy policy site: http://www.google.com/intl/en/policies/",
     "Expires after 10 years"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "VISITOR_INFO1_LIVE",
     "For YouTube services. This cookie is used for YouTube services. It is handling visitor data to aid in streaming quality. It is beyond the RIPE NCC's control. Use of YouTube services like embedded video require that the user request those services from YouTube directly, which in turn sets this cookie. Users interested in Google policies around this cookie should consult their privacy policy site: http://www.google.com/intl/en/policies/",
     "Expires after 1 year"
);

INSERT INTO RIPE (Cookie_Name, Purpose, Term)
   VALUES (
     "_icl_current_*",
     "Cookies set to help display the correct/chosen language to the user on www.enog.org",
     "Expires after 24 hours"
);