· 6 years ago · Apr 06, 2019, 01:12 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas generowania: 06 Kwi 2019, 03:07
7-- Wersja serwera: 10.1.29-MariaDB-1~jessie
8-- Wersja PHP: 5.6.30-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Baza danych: `zap363964-1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `fine_types`
27--
28
29CREATE TABLE IF NOT EXISTS `fine_types` (
30`id` int(11) NOT NULL,
31 `label` varchar(255) DEFAULT NULL,
32 `amount` int(11) DEFAULT NULL,
33 `category` int(11) DEFAULT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;
35
36--
37-- Zrzut danych tabeli `fine_types`
38--
39
40INSERT INTO `fine_types` (`id`, `label`, `amount`, `category`) VALUES
41(1, 'Misuse of a horn', 30, 0),
42(2, 'Illegally Crossing a continuous Line', 40, 0),
43(3, 'Driving on the wrong side of the road', 250, 0),
44(4, 'Illegal U-Turn', 250, 0),
45(5, 'Illegally Driving Off-road', 170, 0),
46(6, 'Refusing a Lawful Command', 30, 0),
47(7, 'Illegally Stopping a Vehicle', 150, 0),
48(8, 'Illegal Parking', 70, 0),
49(9, 'Failing to Yield to the right', 70, 0),
50(10, 'Failure to comply with Vehicle Information', 90, 0),
51(11, 'Failing to stop at a Stop Sign ', 105, 0),
52(12, 'Failing to stop at a Red Light', 130, 0),
53(13, 'Illegal Passing', 100, 0),
54(14, 'Driving an illegal Vehicle', 100, 0),
55(15, 'Driving without a License', 1500, 0),
56(16, 'Hit and Run', 800, 0),
57(17, 'Exceeding Speeds Over < 5 mph', 90, 0),
58(18, 'Exceeding Speeds Over 5-15 mph', 120, 0),
59(19, 'Exceeding Speeds Over 15-30 mph', 180, 0),
60(20, 'Exceeding Speeds Over > 30 mph', 300, 0),
61(21, 'Impeding traffic flow', 110, 1),
62(22, 'Public Intoxication', 90, 1),
63(23, 'Disorderly conduct', 90, 1),
64(24, 'Obstruction of Justice', 130, 1),
65(25, 'Insults towards Civilans', 75, 1),
66(26, 'Disrespecting of an LEO', 110, 1),
67(27, 'Verbal Threat towards a Civilan', 90, 1),
68(28, 'Verbal Threat towards an LEO', 150, 1),
69(29, 'Providing False Information', 250, 1),
70(30, 'Attempt of Corruption', 1500, 1),
71(31, 'Brandishing a weapon in city Limits', 120, 2),
72(32, 'Brandishing a Lethal Weapon in city Limits', 300, 2),
73(33, 'No Firearms License', 600, 2),
74(34, 'Possession of an Illegal Weapon', 700, 2),
75(35, 'Possession of Burglary Tools', 300, 2),
76(36, 'Grand Theft Auto', 1800, 2),
77(37, 'Intent to Sell/Distrube of an illegal Substance', 1500, 2),
78(38, 'Frabrication of an Illegal Substance', 1500, 2),
79(39, 'Possession of an Illegal Substance ', 650, 2),
80(40, 'Kidnapping of a Civilan', 1500, 2),
81(41, 'Kidnapping of an LEO', 2000, 2),
82(42, 'Robbery', 650, 2),
83(43, 'Armed Robbery of a Store', 650, 2),
84(44, 'Armed Robbery of a Bank', 1500, 2),
85(45, 'Assault on a Civilian', 2000, 3),
86(46, 'Assault of an LEO', 2500, 3),
87(47, 'Attempt of Murder of a Civilian', 3000, 3),
88(48, 'Attempt of Murder of an LEO', 5000, 3),
89(49, 'Murder of a Civilian', 10000, 3),
90(50, 'Murder of an LEO', 30000, 3),
91(51, 'Involuntary manslaughter', 1800, 3),
92(52, 'Fraud', 2000, 2);
93
94--
95-- Indeksy dla zrzutów tabel
96--
97
98--
99-- Indexes for table `fine_types`
100--
101ALTER TABLE `fine_types`
102 ADD PRIMARY KEY (`id`);
103
104--
105-- AUTO_INCREMENT for dumped tables
106--
107
108--
109-- AUTO_INCREMENT dla tabeli `fine_types`
110--
111ALTER TABLE `fine_types`
112MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=53;
113/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
114/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
115/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;