BCbX9RCs

1DROP TABLE IF EXISTS Incident;
2
3CREATE TABLE IF NOT EXISTS Incident (
4	CrimeID INT (12) NOT NULL,
5    CrimeType VARCHAR (30) NOT NULL,
6    DateOfIncident Date NOT NULL,
7    LSOACode INT (12) NULL,
8    OfficerID INT (12) NOT NULL,
9    SearchID INT (10) NULL,
10    OutcomeType VARCHAR (30) NOT NULL,
11    ReportedBy VARCHAR (30) NULL,
12    Legislation VARCHAR (30) NULL,
13    PRIMARY KEY (CrimeID)
14    
15);
16
17
18INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
19VALUES ('a51b35e26be', 'Drugs', '21/08/2016', 'E01012574', 'BETA237890', 'OCTB582102', 'Offender given a caution', 'Lancashire Constabulary','')
20
21INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
22VALUES ('99c01b94bae3', 'Vehicle Crime', '21/12/2016', 'E1012635', 'BETA546921', 'DECM302192', 'Investigation complete', 'Lancashire Constabulary', '')
23
24INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
25VALUES ('bf791d109', 'Drugs', '17/09/2017' 'E102587', 'BETA546932', 'SEPT302192', 'Offender given a caution', 'Lancashire Constabulary', '')
26
27INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
28VALUES ('585b89b3e19e', 'Domestic', '06,21,2017', '', 'EPSI793123', 'SEPT492102', 'Investigation complete', 'Lancashire Constabulary', '')
29
30INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
31VALUES ('e24403597633', 'Criminal Damage and arson', '23/09/2017', 'E01012634', 'ESPI205482', 'SEPT972123', 'Investigation complete', 'Lancashire Constabulary', '',)
32
33INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
34VALUES ('204bf5e7f8c5', 'Buglary', '15/09/2017', '', 'ALPHA2365342', 'SEPT349282', 'Under investigation', 'Lancashire Constabulary', '')
35
36INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
37VALUES ('789e4596a1d3', 'Drugs', '20/09/2017', '', 'BETA583102', 'SEPT492910', 'Under investigation', 'Lancashire Constbulary', '')
38
39INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
40VALUES ('f127b5e68110', 'Buglary', '14/02/2017', 'E01024909', 'EPSI482102', 'SEPT794203', 'Under investigatoin', '')
41
42INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
43VALUES ('88d1d01e3f5a', 'Theft', '06/09/2017', 'E01024873', 'ALPHA124642', 'SEPT394103', 'Investigation complete', 'Lancashire Contsabulary', '')
44
45INSERT INTO Incident (CrimeID, CrimeType, DateOfIncident, LSOACode, OfficerID, SearchID, OutcomeType, ReportedBy, Legislation)
46VALUES ('958d5f2e89ae', 'Theft', '03/09/2017', 'E01024909', 'ALPHA1231237', 'SEPT146123', 'Investigation complete', 'Lancashire Constabulary','')