· 2 years ago · Aug 21, 2023, 02:40 AM
1-- phpMyAdmin SQL Dump
2-- version 5.2.0
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Aug 21, 2023 at 04:27 AM
7-- Server version: 10.4.24-MariaDB
8-- PHP Version: 8.1.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11START TRANSACTION;
12SET time_zone = "+00:00";
13
14
15/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18/*!40101 SET NAMES utf8mb4 */;
19
20--
21-- Database: `db_mikrotik_2022`
22--
23
24-- --------------------------------------------------------
25
26--
27-- Table structure for table `t_bandwith`
28--
29
30CREATE TABLE `t_bandwith` (
31 `id_bandwith` int(11) NOT NULL,
32 `bandwith` int(11) NOT NULL,
33 `price` double NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
35
36-- --------------------------------------------------------
37
38--
39-- Table structure for table `t_client`
40--
41
42CREATE TABLE `t_client` (
43 `id_client` int(11) NOT NULL,
44 `nama` varchar(77) NOT NULL,
45 `tgl_pasang` date NOT NULL,
46 `id_jenis` int(11) NOT NULL,
47 `id_bandwith` int(11) NOT NULL
48) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `t_jenis`
54--
55
56CREATE TABLE `t_jenis` (
57 `id_jenis` int(11) NOT NULL,
58 `jenis` varchar(55) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
60
61--
62-- Dumping data for table `t_jenis`
63--
64
65INSERT INTO `t_jenis` (`id_jenis`, `jenis`) VALUES
66(1, 'Kabel FO'),
67(2, 'Kabel LAN'),
68(3, 'PTP (Point To Point)'),
69(4, 'PTMP (Point To Multi Point)');
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `t_payment`
75--
76
77CREATE TABLE `t_payment` (
78 `id_payment` int(11) NOT NULL,
79 `id_client` int(11) NOT NULL,
80 `jml_pay` double NOT NULL,
81 `tgl_bayar` date NOT NULL
82) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
83
84-- --------------------------------------------------------
85
86--
87-- Stand-in structure for view `view_client`
88-- (See below for the actual view)
89--
90CREATE TABLE `view_client` (
91`id_client` int(11)
92,`nama` varchar(77)
93,`tgl_pasang` date
94,`id_jenis` int(11)
95,`id_bandwith` int(11)
96,`jenis` varchar(55)
97,`price` double
98,`bandwith` int(11)
99);
100
101-- --------------------------------------------------------
102
103--
104-- Stand-in structure for view `view_payment`
105-- (See below for the actual view)
106--
107CREATE TABLE `view_payment` (
108`id_payment` int(11)
109,`id_client` int(11)
110,`jml_pay` double
111,`tgl_bayar` date
112,`nama` varchar(77)
113,`price` double
114,`bandwith` int(11)
115,`tgl_pasang` date
116);
117
118-- --------------------------------------------------------
119
120--
121-- Structure for view `view_client`
122--
123DROP TABLE IF EXISTS `view_client`;
124
125CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_client` AS SELECT `t_client`.`id_client` AS `id_client`, `t_client`.`nama` AS `nama`, `t_client`.`tgl_pasang` AS `tgl_pasang`, `t_client`.`id_jenis` AS `id_jenis`, `t_client`.`id_bandwith` AS `id_bandwith`, `t_jenis`.`jenis` AS `jenis`, `t_bandwith`.`price` AS `price`, `t_bandwith`.`bandwith` AS `bandwith` FROM ((`t_client` join `t_jenis`) join `t_bandwith`) WHERE `t_client`.`id_jenis` = `t_jenis`.`id_jenis` AND `t_bandwith`.`id_bandwith` <> 00 ;
126
127-- --------------------------------------------------------
128
129--
130-- Structure for view `view_payment`
131--
132DROP TABLE IF EXISTS `view_payment`;
133
134CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_payment` AS SELECT `t_payment`.`id_payment` AS `id_payment`, `t_payment`.`id_client` AS `id_client`, `t_payment`.`jml_pay` AS `jml_pay`, `t_payment`.`tgl_bayar` AS `tgl_bayar`, `view_client`.`nama` AS `nama`, `view_client`.`price` AS `price`, `view_client`.`bandwith` AS `bandwith`, `view_client`.`tgl_pasang` AS `tgl_pasang` FROM (`t_payment` join `view_client`) WHERE `t_payment`.`id_client` = `view_client`.`id_client``id_client` ;
135
136--
137-- Indexes for dumped tables
138--
139
140--
141-- Indexes for table `t_bandwith`
142--
143ALTER TABLE `t_bandwith`
144 ADD PRIMARY KEY (`id_bandwith`);
145
146--
147-- Indexes for table `t_client`
148--
149ALTER TABLE `t_client`
150 ADD PRIMARY KEY (`id_client`);
151
152--
153-- Indexes for table `t_jenis`
154--
155ALTER TABLE `t_jenis`
156 ADD PRIMARY KEY (`id_jenis`);
157
158--
159-- Indexes for table `t_payment`
160--
161ALTER TABLE `t_payment`
162 ADD PRIMARY KEY (`id_payment`);
163
164--
165-- AUTO_INCREMENT for dumped tables
166--
167
168--
169-- AUTO_INCREMENT for table `t_bandwith`
170--
171ALTER TABLE `t_bandwith`
172 MODIFY `id_bandwith` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
173
174--
175-- AUTO_INCREMENT for table `t_client`
176--
177ALTER TABLE `t_client`
178 MODIFY `id_client` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
179
180--
181-- AUTO_INCREMENT for table `t_jenis`
182--
183ALTER TABLE `t_jenis`
184 MODIFY `id_jenis` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
185
186--
187-- AUTO_INCREMENT for table `t_payment`
188--
189ALTER TABLE `t_payment`
190 MODIFY `id_payment` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
191COMMIT;
192
193/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
194/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
195/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
196