· 10 years ago · Feb 02, 2016, 06:18 AM
1CREATE TABLE IF NOT EXISTS `email_alamat` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `subjekEmail` varchar(200) NOT NULL,
4 `email` varchar(100) NOT NULL,
5 `namaEmail` varchar(75) NOT NULL,
6 `groupEmail` varchar(65) NOT NULL,
7 `statusEmail` char(1) NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
10
11-- --------------------------------------------------------
12
13--
14-- Table structure for table `email_broadcast`
15--
16
17CREATE TABLE IF NOT EXISTS `email_broadcast` (
18 `idEmail` int(11) NOT NULL AUTO_INCREMENT,
19 `tanggalEmail` datetime NOT NULL,
20 `subjekEmail` varchar(200) NOT NULL,
21 `isiEmail` text NOT NULL,
22 `Email` varchar(70) NOT NULL,
23 `namaEmail` varchar(75) NOT NULL,
24 `kategoriEmail` varchar(50) NOT NULL,
25 `file` varchar(200) NOT NULL,
26 `createdDate` datetime NOT NULL,
27 `createdBy` varchar(65) NOT NULL,
28 PRIMARY KEY (`idEmail`)
29) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;
30
31--
32-- Dumping data for table `email_broadcast`
33--
34
35INSERT INTO `email_broadcast` (`idEmail`, `tanggalEmail`, `subjekEmail`, `isiEmail`, `Email`, `namaEmail`, `kategoriEmail`, `file`, `createdDate`, `createdBy`) VALUES
36(3, '2016-01-26 14:34:58', 'TEST SUBJEK', 'test dulu', 'anggitinside@gmail.com', '', 'Satu', '', '2016-01-26 14:34:58', 'superadmin'),
37(6, '2016-01-26 14:39:07', 'test group', 'test group', 'anggitinside@gmail.com', '', 'Group', '', '2016-01-26 14:39:07', 'superadmin'),
38(7, '2016-01-26 14:39:07', 'test group', 'test group', 'maffandibintang@gmail.com', '', 'Group', '', '2016-01-26 14:39:07', 'superadmin'),
39(8, '2016-01-26 14:39:07', 'test group', 'test group', 'anggitinside@gmail.com', '', 'Group', '', '2016-01-26 14:39:07', 'superadmin'),
40(9, '2016-01-26 14:39:08', 'test group', 'test group', 'maffandibintang@gmail.com', '', 'Group', '', '2016-01-26 14:39:08', 'superadmin');
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `email_group`
46--
47
48CREATE TABLE IF NOT EXISTS `email_group` (
49 `idGroup` int(11) NOT NULL AUTO_INCREMENT,
50 `emailGroup` varchar(35) NOT NULL,
51 `namaGroup` varchar(65) NOT NULL,
52 `namaEmail` varchar(100) NOT NULL,
53 `statusGroup` char(1) NOT NULL,
54 PRIMARY KEY (`idGroup`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
56
57--
58-- Dumping data for table `email_group`
59--
60
61INSERT INTO `email_group` (`idGroup`, `emailGroup`, `namaGroup`, `namaEmail`, `statusGroup`) VALUES
62(1, 'anggitinside@gmail.com', 'test', 'Anggit', 't'),
63(2, 'maffandibintang@gmail.com', 'test', 'Bintang', 't');
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `sms_broadcast`
69--
70
71CREATE TABLE IF NOT EXISTS `sms_broadcast` (
72 `idSms` int(11) NOT NULL AUTO_INCREMENT,
73 `idKirim` int(11) NOT NULL,
74 `tanggalSms` datetime NOT NULL,
75 `isiSms` text NOT NULL,
76 `tujuanSms` varchar(35) NOT NULL,
77 `namaSms` varchar(75) NOT NULL,
78 `kategoriSms` varchar(50) NOT NULL,
79 `createdDate` datetime NOT NULL,
80 `createdBy` varchar(65) NOT NULL,
81 PRIMARY KEY (`idSms`)
82) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=843 ;
83
84--
85-- Dumping data for table `sms_broadcast`
86--
87
88INSERT INTO `sms_broadcast` (`idSms`, `idKirim`, `tanggalSms`, `isiSms`, `tujuanSms`, `namaSms`, `kategoriSms`, `createdDate`, `createdBy`) VALUES
89(836, 1, '2016-02-01 15:01:19', 'test', '085890247605', '', 'Banyak', '2016-02-01 15:01:19', 'superadmin'),
90(837, 2, '2016-02-01 15:01:53', 'test', '085890247605', '', 'Banyak', '2016-02-01 15:01:53', 'superadmin'),
91(838, 2, '2016-02-01 15:01:53', 'test', '0851511216021', '', 'Banyak', '2016-02-01 15:01:53', 'superadmin'),
92(839, 0, '2016-02-01 19:01:37', 'Helloo apa kabar ...udah shalat blum ?', '081382498904', '', 'Satu', '2016-02-01 19:01:37', 'superadmin'),
93(840, 0, '2016-02-02 12:07:13', 'HEI STRANGER', '085890247605', '', 'Satu', '2016-02-02 12:07:13', 'superadmin');
94
95-- --------------------------------------------------------
96
97--
98-- Table structure for table `sms_group`
99--
100
101CREATE TABLE IF NOT EXISTS `sms_group` (
102 `idGroup` int(11) NOT NULL AUTO_INCREMENT,
103 `nomorGroup` varchar(35) NOT NULL,
104 `namaGroup` varchar(65) NOT NULL,
105 `namaSms` varchar(50) NOT NULL,
106 `statusGroup` char(1) NOT NULL,
107 PRIMARY KEY (`idGroup`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
109
110--
111-- Dumping data for table `sms_group`
112--
113
114INSERT INTO `sms_group` (`idGroup`, `nomorGroup`, `namaGroup`, `namaSms`, `statusGroup`) VALUES
115(1, '085890247605', 'test', 'Anggit', 't'),
116(3, '082298857224', 'SESUMBAR', 'BINTANG', 't'),
117(4, '089691025631', 'SESUMBAR', 'IRVAN', 't'),
118(5, '085890247605', 'SESUMBAR', 'Anggit', 't');
119
120-- --------------------------------------------------------
121
122--
123-- Table structure for table `sms_nomor`
124--
125
126CREATE TABLE IF NOT EXISTS `sms_nomor` (
127 `id` int(11) NOT NULL AUTO_INCREMENT,
128 `nomorSms` varchar(35) NOT NULL,
129 `namaSms` varchar(75) NOT NULL,
130 `groupSms` varchar(65) NOT NULL,
131 `statusNomor` char(1) NOT NULL,
132 PRIMARY KEY (`id`)
133) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
134
135--
136-- Dumping data for table `sms_nomor`
137--
138
139INSERT INTO `sms_nomor` (`id`, `nomorSms`, `namaSms`, `groupSms`, `statusNomor`) VALUES
140(1, '082298857224', 'BINTANG', 'SESUMBAR', ''),
141(2, '089691025631', 'IRVAN', 'SESUMBAR', ''),
142(3, '085890247605', 'Anggit', 'SESUMBAR', '');
143
144-- --------------------------------------------------------
145
146--
147-- Table structure for table `sms_template`
148--
149
150CREATE TABLE IF NOT EXISTS `sms_template` (
151 `idTemplate` int(11) NOT NULL AUTO_INCREMENT,
152 `tipeTemplate` int(11) NOT NULL,
153 `isiTemplate` text NOT NULL,
154 `status` char(1) NOT NULL,
155 `createdDate` datetime NOT NULL,
156 `createdBy` varchar(75) NOT NULL,
157 PRIMARY KEY (`idTemplate`)
158) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
159
160--
161-- Dumping data for table `sms_template`
162--
163
164INSERT INTO `sms_template` (`idTemplate`, `tipeTemplate`, `isiTemplate`, `status`, `createdDate`, `createdBy`) VALUES
165(2, 1, 'hai [nama], rumah kamu ada di [alamat]', 't', '2015-12-03 16:33:12', 'superadmin'),
166(4, 0, 'HEI STRANGER', 't', '2016-01-21 11:07:51', 'superadmin'),
167(5, 1, 'HEI STRANGER', 'f', '2016-01-21 11:11:27', 'superadmin');