· 9 years ago · Jan 24, 2017, 12:24 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.7
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jan 24, 2017 at 07:23 PM
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-- Database: `bulancinta`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `post`
21--
22
23CREATE TABLE IF NOT EXISTS `post` (
24 `id` bigint(20) NOT NULL,
25 `user_id` bigint(20) NOT NULL,
26 `media_id` varchar(100) NOT NULL,
27 `url` varchar(255) NOT NULL,
28 `author` varchar(100) NOT NULL,
29 `avatar` varchar(255) NOT NULL,
30 `image` varchar(255) NOT NULL,
31 `likes_count` int(11) NOT NULL DEFAULT '0',
32 `vote_count` int(11) NOT NULL DEFAULT '0',
33 `is_active` tinyint(1) NOT NULL DEFAULT '1',
34 `created_at` datetime NOT NULL
35) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `post`
39--
40
41INSERT INTO `post` (`id`, `user_id`, `media_id`, `url`, `author`, `avatar`, `image`, `likes_count`, `vote_count`, `is_active`, `created_at`) VALUES
42(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');
43
44--
45-- Indexes for dumped tables
46--
47
48--
49-- Indexes for table `post`
50--
51ALTER TABLE `post`
52 ADD PRIMARY KEY (`id`);
53
54--
55-- AUTO_INCREMENT for dumped tables
56--
57
58--
59-- AUTO_INCREMENT for table `post`
60--
61ALTER TABLE `post`
62 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;