This repository has been archived by the owner on Sep 22, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
renkaat.sql
76 lines (66 loc) · 3 KB
/
renkaat.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Palvelin: localhost
-- Luontiaika: 25.11.2020 klo 13:47
-- Palvelimen versio: 5.5.38-0ubuntu0.14.04.1
-- PHP:n versio: 5.5.9-1ubuntu4.5
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Tietokanta: `jp`
--
-- --------------------------------------------------------
--
-- Rakenne taululle `renkaat`
--
CREATE TABLE IF NOT EXISTS `renkaat` (
`RengasID` int(11) NOT NULL AUTO_INCREMENT,
`Merkki` varchar(255) NOT NULL,
`Malli` varchar(255) NOT NULL,
`Tyyppi` varchar(255) NOT NULL,
`Koko` varchar(20) NOT NULL,
`Hinta` decimal(10,2) NOT NULL,
`Saldo` int(11) NOT NULL,
PRIMARY KEY (`RengasID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=29 ;
--
-- Vedos taulusta `renkaat`
--
INSERT INTO `renkaat` (`RengasID`, `Merkki`, `Malli`, `Tyyppi`, `Koko`, `Hinta`, `Saldo`) VALUES
(1, 'Nokian', 'Hakkapeliitta 8', 'Nasta', '165/55-14', 65.50, 15),
(2, 'Nokian', 'Hakkapeliitta 8', 'Nasta', '165/65-14', 65.75, 15),
(3, 'Nokian', 'Hakkapeliitta 9', 'Kitka', '165/55-15', 74.55, 50),
(4, 'Nokian', 'Hakkapeliitta R3', 'Kitka', '175/65-15', 78.94, 3),
(5, 'Kumho', 'Wi31+', 'Nasta', '185/65-15', 125.45, 80),
(6, 'Kumho', 'Wi31+', 'Nasta', '205/65-16', 132.53, 14),
(7, 'Kumho', 'WS71', 'Kitka', '175/65-15', 86.45, 23),
(8, 'Kumho', 'WS71', 'Kitka', '165/55-14', 75.88, 3),
(9, 'Hankook', 'RW11', 'Kitka', '165/65-14', 98.12, 2),
(10, 'Hankook', 'RW11', 'Kitka', '175/65-15', 99.49, 12),
(11, 'Hankook', 'RW11', 'Kitka', '205/65-16', 102.24, 50),
(12, 'Nokian', 'Nordman RS2', 'Kitka', '185/65-15', 78.50, 60),
(13, 'Nokian', 'Nordman RS2', 'Kitka', '175/65-14', 88.34, 16),
(14, 'Nokian', 'Nordman RS2', 'Kitka', '185/65-14', 87.32, 5),
(15, 'Kumho', 'WS71', 'Kitka', '235/65-17', 199.93, 7),
(16, 'Kumho', 'WS71', 'Kitka', '235/60-18', 213.05, 8),
(17, 'Nokian', 'Hakkapeliitta 9', 'Nasta', '185/65-15', 81.20, 16),
(18, 'Nokian', 'Hakkapeliitta 9', 'Nasta', '195/65-15', 99.00, 20),
(19, 'Nokian', 'Hakkapeliitta 8 SUV', 'Kitka', '225/55-18', 234.40, 7),
(20, 'Kumho', 'WS71', 'Kitka', '235/60-17', 134.90, 30),
(21, 'Kumho', 'WS71', 'Kitka', '255/50-19', 144.10, 8),
(22, 'Hankook', 'K425', 'Kesä', '205/55-16', 55.00, 34),
(23, 'Hankook', 'K125', 'Kesä', '205/55-16', 61.00, 12),
(24, 'Nokian', '91H', 'Kesä', '205/55-16', 63.00, 1),
(25, 'Hankook', 'Ventus Prime 3 K125', 'Kesä', '185/55-15', 75.00, 32),
(26, 'Hankook', 'Ventus Prime 3 K125', 'Kesä', '195/55-15', 82.00, 12),
(27, 'Kumho', 'Ecowing ES-31', 'Kesä', '195/55-15', 81.00, 16),
(28, 'Nokian ', 'Hakka Blue 2', 'Kesä', '195/55-15', 91.00, 3);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;