-
Notifications
You must be signed in to change notification settings - Fork 4
/
db.sql
123 lines (104 loc) · 3.7 KB
/
db.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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.5.5-10.1.38-MariaDB)
# Database: hp
# Generation Time: 2019-11-04 17:02:51 +0000
# ************************************************************
/*!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 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table hp
# ------------------------------------------------------------
DROP TABLE IF EXISTS `hp`;
CREATE TABLE `hp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nama_hp` varchar(255) NOT NULL,
`harga` int(11) NOT NULL,
`ram` decimal(10,0) NOT NULL,
`memori_internal` int(11) NOT NULL,
`mp_kamera_depan` decimal(10,0) NOT NULL,
`mp_kamera_belakang` decimal(10,0) NOT NULL,
`core` int(11) NOT NULL,
`baterai` int(11) NOT NULL,
`layar` float NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `hp` WRITE;
/*!40000 ALTER TABLE `hp` DISABLE KEYS */;
INSERT INTO `hp` (`id`, `nama_hp`, `harga`, `ram`, `memori_internal`, `mp_kamera_depan`, `mp_kamera_belakang`, `core`, `baterai`, `layar`)
VALUES
(1,'Vivo V9',4000000,4,64,24,13,8,3260,6.3),
(2,'OPPO F7',4200000,4,64,25,16,8,3400,6.23),
(3,'Apple iPhone 5s',1825000,1,32,1,8,2,1560,4),
(4,'Samsung S7 Edge Dual',5761000,4,32,12,5,8,3600,5.5),
(5,'Apple iPhone 6s',8450000,2,64,12,5,2,1715,4.7),
(6,'Xiaomi Redmi Note 5 PRO',3000000,4,64,13,12,8,4000,5.99),
(7,'Asus Zenfone 5 ZE620KL',5500000,6,64,12,8,8,3300,6.2),
(8,'Asus Zenfone Max Plus (M1) ZB570TL',2800000,4,64,8,16,8,4130,5.7),
(9,'Xiami Mi 8 Explorer',10400000,8,128,20,12,8,3000,6.21),
(10,'Lenovo S5',2980000,4,64,16,13,8,3000,5.7),
(11,'Motorola Moto C',700000,1,8,5,8,2,2000,5),
(12,'Huawei Honor 2',1200000,2,16,2,8,4,2300,4.5),
(13,'ZTE T98',950000,1,16,2,5,4,2000,7),
(14,'Lava Iris Atom 3',450000,1,8,0,2,2,1200,4),
(15,'Xiaomi Redmi Note 4',1999500,3,32,8,16,8,4100,5.5),
(22,'ZTE Axon M',3120000,4,64,0,0,8,3180,5.2),
(23,'Xiaomi Redmi 4A',1300000,2,16,5,0,8,3120,5),
(24,'vivo V9 6GB',6950000,6,64,12,0,8,3260,6.3),
(25,'Xiaomi Redmi 2 Prime',954000,2,16,2,0,4,2200,4.7);
/*!40000 ALTER TABLE `hp` ENABLE KEYS */;
UNLOCK TABLES;
# Dump of table link_youtube
# ------------------------------------------------------------
DROP TABLE IF EXISTS `link_youtube`;
CREATE TABLE `link_youtube` (
`id_hp` int(11) unsigned NOT NULL AUTO_INCREMENT,
`link_youtube` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_hp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
LOCK TABLES `link_youtube` WRITE;
/*!40000 ALTER TABLE `link_youtube` DISABLE KEYS */;
INSERT INTO `link_youtube` (`id_hp`, `link_youtube`)
VALUES
(1,NULL),
(2,NULL),
(3,NULL),
(4,NULL),
(5,NULL),
(6,NULL),
(7,NULL),
(8,NULL),
(9,NULL),
(10,NULL),
(11,NULL),
(12,NULL),
(13,NULL),
(14,NULL),
(15,NULL),
(16,NULL),
(17,NULL),
(18,NULL),
(19,NULL),
(20,NULL),
(21,NULL),
(22,NULL),
(23,NULL),
(24,NULL),
(25,NULL);
/*!40000 ALTER TABLE `link_youtube` ENABLE KEYS */;
UNLOCK TABLES;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!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 */;