· 7 years ago · Nov 22, 2018, 02:24 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.7.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: 22 Nov 2018 pada 03.19
7-- Versi Server: 5.6.20
8-- PHP Version: 5.5.15
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `ibos`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Struktur dari tabel `acara`
21--
22
23CREATE TABLE IF NOT EXISTS `acara` (
24`id` int(11) NOT NULL,
25 `tanggal` date NOT NULL,
26 `waktu` time NOT NULL,
27 `nama` varchar(250) NOT NULL,
28 `deskripsi` text,
29 `type` int(11) NOT NULL,
30 `img` varchar(250) DEFAULT NULL,
31 `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
32 `date_updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
33 `user_created` varchar(200) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
35
36--
37-- Dumping data untuk tabel `acara`
38--
39
40INSERT INTO `acara` (`id`, `tanggal`, `waktu`, `nama`, `deskripsi`, `type`, `img`, `date_created`, `date_updated`, `user_created`) VALUES
41(2, '2018-12-10', '09:00:00', 'Launching Produk A', 'Pengenalan Produk A kepada Seluruh Customer di Jawa Barat', 1, 'https://baeorbit.id/bos/wp-content/uploads/bos-product-neuven-320x213.jpeg', '2018-11-12 06:20:55', '2018-11-12 06:33:43', 'BOS-A000000'),
42(3, '2018-12-20', '09:00:00', 'Launching Produk A', 'Pengenalan Produk A kepada Seluruh Customer di Sumatra', 1, 'https://baeorbit.id/bos/wp-content/uploads/bos-product-neuven-320x213.jpeg', '2018-11-12 06:21:08', '2018-11-12 06:33:50', 'BOS-A000000');
43
44-- --------------------------------------------------------
45
46--
47-- Struktur dari tabel `acara_peserta`
48--
49
50CREATE TABLE IF NOT EXISTS `acara_peserta` (
51`id` int(11) NOT NULL,
52 `acara_id` int(11) NOT NULL,
53 `undangan_id` int(11) NOT NULL,
54 `userid` varchar(200) NOT NULL
55) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
56
57-- --------------------------------------------------------
58
59--
60-- Struktur dari tabel `acara_undangan`
61--
62
63CREATE TABLE IF NOT EXISTS `acara_undangan` (
64`id` int(11) NOT NULL,
65 `acara_id` int(11) NOT NULL,
66 `dari` varchar(150) NOT NULL,
67 `kepada` varchar(150) NOT NULL,
68 `catatan` text NOT NULL,
69 `status` int(11) NOT NULL,
70 `konfirmasi` int(11) NOT NULL,
71 `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
72) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
73
74--
75-- Dumping data untuk tabel `acara_undangan`
76--
77
78INSERT INTO `acara_undangan` (`id`, `acara_id`, `dari`, `kepada`, `catatan`, `status`, `konfirmasi`, `date_created`) VALUES
79(1, 2, 'BOS-A000000', 'TES', 'Test Notes', 0, 0, '2018-11-21 18:40:50');
80
81--
82-- Indexes for dumped tables
83--
84
85--
86-- Indexes for table `acara`
87--
88ALTER TABLE `acara`
89 ADD PRIMARY KEY (`id`);
90
91--
92-- Indexes for table `acara_peserta`
93--
94ALTER TABLE `acara_peserta`
95 ADD PRIMARY KEY (`id`);
96
97--
98-- Indexes for table `acara_undangan`
99--
100ALTER TABLE `acara_undangan`
101 ADD PRIMARY KEY (`id`);
102
103--
104-- AUTO_INCREMENT for dumped tables
105--
106
107--
108-- AUTO_INCREMENT for table `acara`
109--
110ALTER TABLE `acara`
111MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
112--
113-- AUTO_INCREMENT for table `acara_peserta`
114--
115ALTER TABLE `acara_peserta`
116MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
117--
118-- AUTO_INCREMENT for table `acara_undangan`
119--
120ALTER TABLE `acara_undangan`
121MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;