· 9 years ago · Jan 25, 2017, 04:48 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.7
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 25, 2017 at 11:45 AM
7-- Server version: 5.6.28-0ubuntu0.15.04.1
8-- PHP Version: 5.6.4-4ubuntu6.4
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `bulancinta`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `post`
27--
28
29CREATE TABLE IF NOT EXISTS `post` (
30 `id` bigint(20) NOT NULL,
31 `user_id` bigint(20) NOT NULL,
32 `media_id` varchar(100) NOT NULL,
33 `url` varchar(255) NOT NULL,
34 `author` varchar(100) NOT NULL,
35 `avatar` varchar(255) NOT NULL,
36 `image` varchar(255) NOT NULL,
37 `likes_count` int(11) NOT NULL DEFAULT '0',
38 `vote_count` int(11) NOT NULL DEFAULT '0',
39 `is_active` tinyint(1) NOT NULL DEFAULT '1',
40 `created_at` datetime NOT NULL
41) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
42
43--
44-- Dumping data for table `post`
45--
46
47INSERT INTO `post` (`id`, `user_id`, `media_id`, `url`, `author`, `avatar`, `image`, `likes_count`, `vote_count`, `is_active`, `created_at`) VALUES
48(1, 5, '1430480806610204057_1648180548', 'https://www.instagram.com/p/BPaFrbwA_WZ/', 'ihsan', 'https://s3-ap-southeast-1.amazonaws.com/assets.orori.com/indonesia/img/promo/special-pick/UP-2028/item1.png', 'https://s3-ap-southeast-1.amazonaws.com/assets.orori.com/indonesia/img/promo/special-pick/UP-2028/item1.png', 54, 0, 1, '2017-01-24 15:23:19');
49
50-- --------------------------------------------------------
51
52--
53-- Table structure for table `subscriber`
54--
55
56CREATE TABLE IF NOT EXISTS `subscriber` (
57 `id` bigint(20) NOT NULL,
58 `email` varchar(100) NOT NULL,
59 `created_at` datetime NOT NULL
60) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
61
62--
63-- Dumping data for table `subscriber`
64--
65
66INSERT INTO `subscriber` (`id`, `email`, `created_at`) VALUES
67(1, 'ihsan@orori.com', '2017-01-24 15:54:34');
68
69-- --------------------------------------------------------
70
71--
72-- Table structure for table `user`
73--
74
75CREATE TABLE IF NOT EXISTS `user` (
76 `id` bigint(20) NOT NULL,
77 `fullname` varchar(100) NOT NULL,
78 `email` varchar(100) NOT NULL,
79 `date_of_birth` date NOT NULL,
80 `phone` varchar(100) NOT NULL,
81 `gender` varchar(10) NOT NULL DEFAULT 'FEMALE',
82 `password` varchar(100) NOT NULL,
83 `hash` varchar(100) NOT NULL,
84 `join_date` datetime NOT NULL,
85 `city` varchar(100) NOT NULL
86) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
87
88--
89-- Dumping data for table `user`
90--
91
92INSERT INTO `user` (`id`, `fullname`, `email`, `date_of_birth`, `phone`, `gender`, `password`, `hash`, `join_date`, `city`) VALUES
93(5, 'ihsan', 'ihsan@orori.com', '1989-01-10', '1231231231', 'MALE', 'c59aa47388a54566a50ce1c08152107d09a47a52', 'ecc43a15d7a77b26bdad6ba610762fd77e2037a6', '2017-01-24 15:13:16', 'disni');
94
95-- --------------------------------------------------------
96
97--
98-- Table structure for table `vote`
99--
100
101CREATE TABLE IF NOT EXISTS `vote` (
102 `id` bigint(20) NOT NULL,
103 `email` varchar(100) NOT NULL,
104 `post_id` bigint(20) NOT NULL,
105 `created_at` datetime NOT NULL
106) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
107
108--
109-- Dumping data for table `vote`
110--
111
112INSERT INTO `vote` (`id`, `email`, `post_id`, `created_at`) VALUES
113(1, 'ihsan@orori.com', 1, '2017-01-24 17:36:08');
114
115--
116-- Indexes for dumped tables
117--
118
119--
120-- Indexes for table `post`
121--
122ALTER TABLE `post`
123 ADD PRIMARY KEY (`id`);
124
125--
126-- Indexes for table `subscriber`
127--
128ALTER TABLE `subscriber`
129 ADD PRIMARY KEY (`id`);
130
131--
132-- Indexes for table `user`
133--
134ALTER TABLE `user`
135 ADD PRIMARY KEY (`id`);
136
137--
138-- Indexes for table `vote`
139--
140ALTER TABLE `vote`
141 ADD PRIMARY KEY (`id`);
142
143--
144-- AUTO_INCREMENT for dumped tables
145--
146
147--
148-- AUTO_INCREMENT for table `post`
149--
150ALTER TABLE `post`
151 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
152--
153-- AUTO_INCREMENT for table `subscriber`
154--
155ALTER TABLE `subscriber`
156 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
157--
158-- AUTO_INCREMENT for table `user`
159--
160ALTER TABLE `user`
161 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
162--
163-- AUTO_INCREMENT for table `vote`
164--
165ALTER TABLE `vote`
166 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
167/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
168/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
169/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;