24.3.2019-2

-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 24, 2019 at 11:11 AM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.3.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `artify`
--
CREATE DATABASE IF NOT EXISTS `artify` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `artify`;

-- --------------------------------------------------------

--
-- Table structure for table `apply`
--

CREATE TABLE `apply` (
  `apply_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `imgPath` text NOT NULL,
  `approval` int(3) NOT NULL DEFAULT '0',
  `requestedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apply`
--

INSERT INTO `apply` (`apply_id`, `usr_id`, `content`, `imgPath`, `approval`, `requestedDateTime`) VALUES
(1, 2, 'This is a Test', '../image/Apply/RyanSu/1.jpg', 1, '2019-03-10 17:17:56'),
(2, 1, 'This is another Test', '../image/Apply/jyling16/1.png', 1, '2019-03-10 17:17:56'),
(5, 5, 'I Just want to be a artist Please', '../image/Apply/Peter/1.jpg', 1, '2019-03-11 18:11:46'),
(6, 4, 'LoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsuLoremIpsu', '../image/Apply/NewUser/1.png', 1, '2019-03-12 09:31:51'),
(7, 4, 'This is a test', '../image/Apply/NewUser/2.jpg', 1, '2019-03-16 12:22:37'),
(8, 4, 'efewfsffesfs', '../image/Apply/NewUser/3.jpg', 1, '2019-03-16 12:38:27'),
(9, 4, 'seffs', '../image/Apply/NewUser/4.jpg', 1, '2019-03-16 12:42:59'),
(10, 4, 'efesfwefew', '../image/Apply/NewUser/5.jpg', 1, '2019-03-16 12:53:30'),
(11, 1, 'Testing, i want to be a artist', '../image/Apply/jyling16/4.png', 1, '2019-03-19 14:26:00'),
(12, 1, 'rgergrgergegee', '../image/Apply/jyling16/5.png', 1, '2019-03-19 14:32:38');

-- --------------------------------------------------------

--
-- Table structure for table `art_category`
--

CREATE TABLE `art_category` (
  `category_id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `art_category`
--

INSERT INTO `art_category` (`category_id`, `name`) VALUES
(1, 'Digital Art'),
(2, '3D Art'),
(3, 'Animation'),
(4, 'Drawings & Paintings'),
(5, 'Pixel Art'),
(6, 'Text Art'),
(7, 'Vector'),
(8, 'Traditional Art'),
(9, 'Photography'),
(10, 'Designs & Interfaces\r\n'),
(11, 'Cartoons & Comics'),
(12, 'Manga & Anime'),
(13, 'Fan Art'),
(14, 'Line Art');

-- --------------------------------------------------------

--
-- Table structure for table `art_purchase`
--

CREATE TABLE `art_purchase` (
  `purchase_id` int(11) NOT NULL,
  `usr_id` int(11) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `artPath` varchar(255) NOT NULL,
  `compressedImg` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `art_purchase`
--

INSERT INTO `art_purchase` (`purchase_id`, `usr_id`, `post_id`, `artPath`, `compressedImg`) VALUES
(5, 4, 11, '../image/Post/Peter/13.jpg', '../image/Post/Peter/compressed/1553142045.png'),
(6, 4, NULL, '../image/Post/Jack Desu/1.jpg', '../image/Post/Jack Desu/compressed/1553142698.png'),
(7, 1, 8, '../image/Post/Peter/10.png', '../image/Post/Peter/compressed/1552718228.png'),
(8, 3, 2, '../image/Post/Peter/4.jpg', '../image/Post/Peter/compressed/2.png'),
(9, 3, 7, '../image/Post/Peter/9.png', '../image/Post/Peter/compressed/1552716192.png');

-- --------------------------------------------------------

--
-- Table structure for table `ban`
--

CREATE TABLE `ban` (
  `ban_id` int(11) NOT NULL,
  `ban_date` datetime NOT NULL,
  `ban_till` datetime NOT NULL,
  `ban_reason` text NOT NULL,
  `usr_id` int(11) NOT NULL,
  `valid` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ban`
--

INSERT INTO `ban` (`ban_id`, `ban_date`, `ban_till`, `ban_reason`, `usr_id`, `valid`) VALUES
(1, '2019-03-11 16:30:10', '2019-03-12 01:00:00', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test for a REALLY LOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOONG STRING                ', 4, 0),
(2, '2019-03-12 08:07:41', '2019-03-12 08:07:41', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test                ', 4, 0),
(3, '2019-03-12 15:42:08', '2019-03-12 15:42:08', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test                ', 4, 0),
(4, '2019-03-12 16:04:10', '2019-03-12 16:04:10', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test                ', 4, 0),
(5, '2019-03-12 16:05:54', '2019-03-12 16:05:54', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test                ', 4, 0),
(6, '2019-03-12 16:07:40', '2019-03-13 16:07:40', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test                ', 4, 0),
(7, '2019-03-12 16:09:09', '2019-03-12 16:09:09', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test                ', 4, 0),
(8, '2019-03-14 16:07:44', '2019-03-15 16:07:44', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nTesting                ', 4, 0),
(9, '2019-03-14 16:08:07', '2019-03-14 16:17:07', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nTesting                ', 4, 0),
(10, '2019-03-14 16:26:46', '2019-03-15 16:26:46', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nTesting                ', 4, 0),
(11, '2019-03-16 12:32:53', '2019-03-16 12:32:53', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nadeadefeafe                ', 4, 0),
(12, '2019-03-16 12:40:29', '2019-03-16 12:40:29', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nadeadefeafe                ', 4, 0),
(13, '2019-03-16 12:44:06', '2019-03-16 12:44:06', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nadeadefeafe                ', 4, 0),
(14, '2019-03-19 14:28:29', '2019-03-19 14:28:29', 'Reason for Ban:\r\nYou broke the Rules\r\n\r\nReport Type : Harassment\r\nDescription :\r\nThis is a Test for reporting user                ', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `comment_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `commented_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` (`comment_id`, `usr_id`, `post_id`, `content`, `commented_time`) VALUES
(23, 4, 8, 'it works, YUUUUSSSS', '2019-03-16 14:38:23'),
(24, 4, 6, 'test 1', '2019-03-16 17:11:41'),
(25, 4, 6, 'test 2', '2019-03-16 17:11:52'),
(26, 4, 6, 'test 3', '2019-03-16 17:12:03'),
(27, 4, 6, 'test 3', '2019-03-16 17:14:18'),
(28, 4, 6, 'Test 4', '2019-03-16 17:15:06'),
(29, 3, 6, 'Test 5', '2019-03-17 11:59:20'),
(30, 3, 6, 'Test 4', '2019-03-17 12:01:31'),
(31, 3, 6, 'aaa', '2019-03-17 12:01:59'),
(32, 3, 6, 'bbbb', '2019-03-17 12:02:38'),
(33, 3, 6, 'test 6', '2019-03-17 12:03:27'),
(34, 3, 6, 'test 1', '2019-03-17 12:29:10'),
(35, 3, 6, 'test 2', '2019-03-17 12:30:22'),
(36, 3, 6, 'test 3', '2019-03-17 12:33:59'),
(37, 3, 6, 'Test 4', '2019-03-19 08:55:12'),
(38, 1, 7, 'Hello World', '2019-03-19 14:18:50'),
(39, 1, 7, 'Test 3', '2019-03-19 14:19:05'),
(40, 1, 7, 'Test', '2019-03-19 14:19:24'),
(41, 1, 6, 'Test 5', '2019-03-19 14:19:44'),
(42, 1, 6, 'Test 6', '2019-03-19 14:19:55'),
(44, 1, 7, 'Test 4', '2019-03-19 14:37:23'),
(45, 3, 9, 'hello world', '2019-03-23 09:59:02');

-- --------------------------------------------------------

--
-- Table structure for table `discussion`
--

CREATE TABLE `discussion` (
  `comment_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `commented_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `discussion`
--

INSERT INTO `discussion` (`comment_id`, `usr_id`, `target_id`, `content`, `commented_time`) VALUES
(1, 3, 5, 'Hello', '2019-03-14 15:06:31'),
(2, 3, 5, 'This is a Test', '2019-03-14 15:06:56'),
(3, 3, 5, 'hahaha', '2019-03-14 15:07:16'),
(4, 3, 5, 'Test', '2019-03-14 15:08:43'),
(5, 3, 5, 'Hello', '2019-03-14 15:09:53'),
(6, 3, 5, 'this is a test', '2019-03-14 15:10:05'),
(7, 3, 3, 'Own Profile Test', '2019-03-14 15:14:38'),
(8, 4, 3, 'Samuel is a nerd, NERRRRRRRRRRRRRRRRRRDDDDDDD', '2019-03-14 15:16:33'),
(9, 4, 3, 'is this double ?', '2019-03-14 15:19:51'),
(10, 4, 3, 'wut?', '2019-03-14 15:20:02'),
(11, 4, 4, 'No, You are the real nerd', '2019-03-14 15:21:00'),
(12, 3, 3, 'NO U', '2019-03-15 08:49:22'),
(13, 3, 3, 'test', '2019-03-17 12:38:34'),
(14, 1, 1, 'Testing', '2019-03-19 14:23:57'),
(15, 1, 1, 'Test 2', '2019-03-19 14:24:28');

-- --------------------------------------------------------

--
-- Table structure for table `follow`
--

CREATE TABLE `follow` (
  `id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `follow`
--

INSERT INTO `follow` (`id`, `usr_id`, `target_id`) VALUES
(1, 4, 3),
(2, 3, 3),
(3, 3, 4),
(4, 3, 5),
(5, 1, 5);

-- --------------------------------------------------------

--
-- Table structure for table `likes`
--

CREATE TABLE `likes` (
  `like_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `value` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `likes`
--

INSERT INTO `likes` (`like_id`, `usr_id`, `post_id`, `value`) VALUES
(3, 3, 9, 1),
(5, 3, 8, 1),
(6, 1, 7, 1),
(8, 1, 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `package`
--

CREATE TABLE `package` (
  `id` int(11) NOT NULL,
  `package` varchar(255) NOT NULL,
  `cost` int(11) NOT NULL,
  `coins` int(11) NOT NULL,
  `imgPath` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `package`
--

INSERT INTO `package` (`id`, `package`, `cost`, `coins`, `imgPath`) VALUES
(1, '100 coins', 3500, 100, '../asset/icons/coin-1.png'),
(2, '200 coins', 6000, 200, '../asset/icons/coin-2.png'),
(3, '340 coins', 11500, 340, '../asset/icons/coin-3.png'),
(4, '450 coins', 15000, 450, '../asset/icons/coin-4.png');

-- --------------------------------------------------------

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `collab` text NOT NULL,
  `edited_date` datetime DEFAULT NULL,
  `posted_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `title` varchar(32) NOT NULL,
  `content` text NOT NULL,
  `category_id` int(11) NOT NULL,
  `artPathRaw` text NOT NULL,
  `artThumbnail` text NOT NULL,
  `artCompressed` text NOT NULL,
  `cost` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`post_id`, `usr_id`, `collab`, `edited_date`, `posted_date`, `title`, `content`, `category_id`, `artPathRaw`, `artThumbnail`, `artCompressed`, `cost`) VALUES
(1, 3, '', NULL, '2019-03-15 19:17:41', 'This is a test for Compression', 'Testing', 1, '../image/Post/Peter/1.png', '../image/Post/Peter//thumbnail/1.png', '../image/Post/Peter//compressed/1.png', 25),
(2, 4, '', NULL, '2019-03-16 12:54:05', 'This is a Test', 'This is another test', 1, '../image/Post/Peter/4.jpg', '../image/Post/Peter/thumbnail/2.png', '../image/Post/Peter/compressed/2.png', 25),
(3, 4, '', NULL, '2019-03-16 13:53:10', 'This is a Test 2', 'This is another Test', 1, '../image/Post/Peter/5.png', '../image/Post/Peter/thumbnail/1552715589.png', '../image/Post/Peter/compressed/1552715590.png', 0),
(4, 3, '', NULL, '2019-03-16 13:59:15', 'png transparent test', 'essgsgsegsegs', 1, '../image/Post/Peter/6.png', '../image/Post/Peter/thumbnail/1552715955.png', '../image/Post/Peter/compressed/1552715955.png', 25),
(5, 3, '', NULL, '2019-03-16 13:59:57', 'Png transparent 2', 'fsefefsfsef', 1, '../image/Post/Peter/7.png', '../image/Post/Peter/thumbnail/1552715996.png', '../image/Post/Peter/compressed/1552715996.png', 25),
(6, 3, '', NULL, '2019-03-16 14:00:43', 'Png transparent test 3', 'esfseffesfefse', 1, '../image/Post/Peter/8.png', '../image/Post/Peter/thumbnail/1552716042.png', '../image/Post/Peter/compressed/1552716043.png', 25),
(7, 4, '', NULL, '2019-03-16 14:03:12', 'Very Low Quality Thumnail', 'Very Low Quality Thumnail', 1, '../image/Post/Peter/9.png', '../image/Post/Peter/thumbnail/1552716191.png', '../image/Post/Peter/compressed/1552716192.png', 250),
(8, 3, '', NULL, '2019-03-16 14:37:08', 'Discussion 4', 'More watermark testing', 12, '../image/Post/Peter/10.png', '../image/Post/Peter/thumbnail/1552718227.png', '../image/Post/Peter/compressed/1552718228.png', 25),
(9, 3, '', NULL, '2019-03-16 16:58:33', 'portrait mode', 'Testewff', 1, '../image/Post/Peter/11.jpg', '../image/Post/Peter/thumbnail/1552726713.png', '../image/Post/Peter/compressed/1552726713.png', 25),
(11, 3, '', NULL, '2019-03-21 12:20:45', 'Buy Test', 'This is a buy test<b>Hello</b>', 14, '../image/Post/Jack Desu/6.jpg', '../image/Post/Jack Desu/thumbnail/1553414038.png', '../image/Post/Jack Desu/compressed/1553414038.png', 25),
(12, 3, '', NULL, '2019-03-21 12:25:02', 'Discussion 4', 'egwgwgegwg', 1, '../image/Post/Peter/14.png', '../image/Post/Peter/thumbnail/1553142302.png', '../image/Post/Peter/compressed/1553142302.png', 0);

-- --------------------------------------------------------

--
-- Table structure for table `report_post`
--

CREATE TABLE `report_post` (
  `report_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `report_type` varchar(64) NOT NULL,
  `report_content` text NOT NULL,
  `reportedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `report_user`
--

CREATE TABLE `report_user` (
  `report_id` int(11) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `report_type` varchar(64) NOT NULL,
  `report_title` varchar(64) DEFAULT NULL,
  `report_content` text NOT NULL,
  `reportedDateTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dismiss` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report_user`
--

INSERT INTO `report_user` (`report_id`, `usr_id`, `target_id`, `report_type`, `report_title`, `report_content`, `reportedDateTime`, `dismiss`) VALUES
(1, 3, 1, 'Harassment', 'This is a Test', 'This is a Test for reporting user', '2019-03-11 11:16:13', 0),
(2, 3, 4, 'Harassment', 'Discussion 4', 'This is another Test', '2019-03-11 11:27:52', 2),
(3, 3, 4, 'Others', 'This is a test for others', 'This is a test for others', '2019-03-11 11:28:59', 2),
(4, 3, 4, 'Harassment', NULL, 'This is a Test for a REALLY LOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOONG STRING', '2019-03-11 11:35:44', 2),
(5, 5, 4, 'Spam', NULL, 'He spams alot in the comment section', '2019-03-11 18:25:17', 0),
(6, 5, 4, 'Harassment', NULL, 'This is a Test', '2019-03-12 08:06:37', 0),
(7, 3, 4, 'Harassment', NULL, 'Testing', '2019-03-14 15:56:34', 0),
(8, 3, 4, 'Harassment', NULL, 'adeadefeafe', '2019-03-16 12:31:18', 0),
(9, 3, 1, 'Harassment', NULL, 'Ban hammer', '2019-03-19 14:28:12', 0);

-- --------------------------------------------------------

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` varchar(255) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `cus_id` varchar(255) NOT NULL,
  `package` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `usr_id`, `cus_id`, `package`, `amount`, `currency`, `status`, `created`) VALUES
('ch_1EFaxEF0CW8e8rzonAw3pFyP', 3, 'cus_Ej33hGBnfzFKLW', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 13:57:42'),
('ch_1EFbD1F0CW8e8rzo44NHi1Wb', 4, 'cus_Ej3JonfltorKYL', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 14:14:02'),
('ch_1EFbeoF0CW8e8rzoP4krpwrP', 1, 'cus_Ej3m1wiNB5qQG1', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 14:42:45'),
('ch_1EFEl1F0CW8e8rzoKKHUg3cR', 3, 'cus_Eig7uPnlBEAtHK', '100 coins', '3500', 'myr', '0', '2019-03-18 14:15:37'),
('ch_1EFFRGF0CW8e8rzo37jEZl25', 3, 'cus_EigoX1uBAnkKKk', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 14:59:15'),
('ch_1EFGKJF0CW8e8rzo7AuQ92aw', 3, 'cus_Eihjl0ho53QKIS', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 15:56:09'),
('ch_1EFIPrF0CW8e8rzoAueuJ8wv', 3, 'cus_Eijt0lZpAQ0mf1', '200 coins', '6000', 'myr', 'succeeded', '2019-03-18 18:10:00'),
('ch_1EFLgKF0CW8e8rzo6BnCgfw9', 1, 'cus_EinGk6j2PlLvoa', '100 coins', '3500', 'myr', 'succeeded', '2019-03-18 21:39:13'),
('ch_1EFLXDF0CW8e8rzo9gQNIBdw', 1, 'cus_Ein7wKqfINwMKg', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 21:29:50'),
('ch_1EFLXMF0CW8e8rzoBf3EGHtx', 1, 'cus_Ein70oIg1aIecT', '450 coins', '15000', 'myr', 'succeeded', '2019-03-18 21:29:58'),
('ch_1EFWKOF0CW8e8rzozayq5kRo', 3, 'cus_EiyGRhxcNzQS07', '450 coins', '15000', 'myr', 'succeeded', '2019-03-19 09:01:19'),
('ch_1EGz6NF0CW8e8rzoqI6ZSXbF', 3, 'cus_EkU4Vj2KPQpDGE', '450 coins', '15000', 'myr', 'succeeded', '2019-03-23 09:56:52');

-- --------------------------------------------------------

--
-- Table structure for table `usr`
--

CREATE TABLE `usr` (
  `usr_id` int(11) NOT NULL,
  `profileImgPath` varchar(255) NOT NULL DEFAULT '../image/Profile/default/1.png',
  `usrnm` varchar(32) NOT NULL,
  `pwd` varchar(64) NOT NULL,
  `nickname` varchar(32) NOT NULL,
  `email` varchar(64) NOT NULL,
  `joined` datetime NOT NULL,
  `score` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usr`
--

INSERT INTO `usr` (`usr_id`, `profileImgPath`, `usrnm`, `pwd`, `nickname`, `email`, `joined`, `score`) VALUES
(1, '../image/Profile/jyling16/8.png', 'jyling16', '$2y$10$UhyBDQscUpMk5U3actM2m.oCw17gzmAD9Ak8P4eT25FArvAs1dll2', 'Jack', 's.gm@gmail.com', '2019-03-05 08:57:41', 0.9),
(2, '../image/Profile/default/1.png', 'RyanSu', '$2y$10$2v/wPA77ClZPSRgqija7juG6vtw8KOGjtmzGfh9nKgaEl6ubPOWz.', 'Jedi', 's.gm@a.com', '2019-03-05 09:00:37', 0.9),
(3, '../image/Profile/Jack Desu/1553421774.png', 'Jack Desu', '$2y$10$.j1Uq5G7NFmQTr3KFPjdhOrz94ri3X5/DMleGLGn8o/svq2X3tvBa', 'Samuel Ling', 's.gm@3.com', '2019-03-05 09:00:58', 0.9),
(4, '../image/Profile/default/1.png', 'NewUser', '$2y$10$YgMeQcQ4ZLs9ENo3xb12j.zHUP5qa.tglh7MZxIo/x3dGR81tOJvC', 'missingNo', 's.gm@hotmail.com', '2019-03-06 00:33:39', 0.9),
(5, '../image/Profile/default/1.png', 'Peter', '$2y$10$DSx20zySU9FhgyQpaV8JMewL8uFVv00imwZnb5UysxOGHVlV38wma', 'Peter', 's.gm@3.com', '2019-03-11 18:08:29', 0.9);

-- --------------------------------------------------------

--
-- Table structure for table `usr_coin`
--

CREATE TABLE `usr_coin` (
  `usr_id` int(11) NOT NULL,
  `coins` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usr_coin`
--

INSERT INTO `usr_coin` (`usr_id`, `coins`) VALUES
(1, 425),
(3, 675),
(4, 350);

-- --------------------------------------------------------

--
-- Table structure for table `usr_group`
--

CREATE TABLE `usr_group` (
  `usr_id` int(11) NOT NULL,
  `permission` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usr_group`
--

INSERT INTO `usr_group` (`usr_id`, `permission`) VALUES
(1, '{\"usr\":{\"accType\":\"artist\",\"permission\":{\"post\":true,\"comment\":true}}}'),
(2, '{\r\n                          \"usr\": {\r\n                            \"accType\" : \"normal\",\r\n                            \"permission\": {\r\n                              \"post\": false,\r\n                              \"comment\": false\r\n                            }\r\n                          }\r\n                        }'),
(3, '{\r\n                          \"usr\": {\r\n                            \"accType\" : \"admin\",\r\n                            \"permission\": {\r\n                              \"post\": true,\r\n                              \"comment\": false\r\n                            }\r\n                          }\r\n                        }'),
(4, '{\"usr\":{\"accType\":\"artist\",\"permission\":{\"post\":true,\"comment\":true}}}'),
(5, '{\"usr\":{\"accType\":\"artist\",\"permission\":{\"post\":true,\"comment\":false}}}');

-- --------------------------------------------------------

--
-- Table structure for table `usr_order`
--

CREATE TABLE `usr_order` (
  `id` varchar(255) NOT NULL,
  `usr_id` int(11) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `package_id` int(11) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usr_order`
--

INSERT INTO `usr_order` (`id`, `usr_id`, `fname`, `lname`, `package_id`, `created`) VALUES
('cus_Eig7uPnlBEAtHK', 3, 'Samuel', 'Ling', 1, '2019-03-18 14:15:37'),
('cus_EigoX1uBAnkKKk', 3, 'Samuel', 'Ling', 4, '2019-03-18 14:59:15'),
('cus_Eihjl0ho53QKIS', 3, 'Samuel', 'Ling', 4, '2019-03-18 15:56:09'),
('cus_Eijt0lZpAQ0mf1', 3, 'Samuel', 'Ling', 2, '2019-03-18 18:10:00'),
('cus_Ein70oIg1aIecT', 1, 'Peter', 'Chang', 4, '2019-03-18 21:29:58'),
('cus_Ein7wKqfINwMKg', 1, 'Peter', 'Chang', 4, '2019-03-18 21:29:50'),
('cus_EinGk6j2PlLvoa', 1, 'Peter', 'Chang', 1, '2019-03-18 21:39:13'),
('cus_EiyGRhxcNzQS07', 3, 'Samuel', 'Ling', 4, '2019-03-19 09:01:19'),
('cus_Ej33hGBnfzFKLW', 3, 'Samuel', 'Ling', 4, '2019-03-19 13:57:42'),
('cus_Ej3JonfltorKYL', 4, 'Samuel', 'Ong', 4, '2019-03-19 14:14:02'),
('cus_Ej3m1wiNB5qQG1', 1, 'Peter', 'Chang', 4, '2019-03-19 14:42:45'),
('cus_EkU4Vj2KPQpDGE', 3, 'Samuel', 'Ling', 4, '2019-03-23 09:56:52');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `apply`
--
ALTER TABLE `apply`
  ADD PRIMARY KEY (`apply_id`),
  ADD KEY `usr_id` (`usr_id`);

--
-- Indexes for table `art_category`
--
ALTER TABLE `art_category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `art_purchase`
--
ALTER TABLE `art_purchase`
  ADD PRIMARY KEY (`purchase_id`),
  ADD KEY `usr_id` (`usr_id`,`post_id`),
  ADD KEY `post_id_fk` (`post_id`);

--
-- Indexes for table `ban`
--
ALTER TABLE `ban`
  ADD PRIMARY KEY (`ban_id`),
  ADD KEY `usr_id` (`usr_id`);

--
-- Indexes for table `comment`
--
ALTER TABLE `comment`
  ADD PRIMARY KEY (`comment_id`),
  ADD KEY `usr_id` (`usr_id`,`post_id`),
  ADD KEY `comment_ibfk_2` (`post_id`);

--
-- Indexes for table `discussion`
--
ALTER TABLE `discussion`
  ADD PRIMARY KEY (`comment_id`),
  ADD KEY `usr_id` (`usr_id`,`target_id`),
  ADD KEY `comment_ibfk_2` (`target_id`);

--
-- Indexes for table `follow`
--
ALTER TABLE `follow`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`usr_id`),
  ADD KEY `target_id` (`target_id`);

--
-- Indexes for table `likes`
--
ALTER TABLE `likes`
  ADD PRIMARY KEY (`like_id`),
  ADD KEY `usr_id` (`usr_id`,`post_id`),
  ADD KEY `likes_ibfk_1` (`post_id`);

--
-- Indexes for table `package`
--
ALTER TABLE `package`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`),
  ADD KEY `usr_id` (`usr_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `report_post`
--
ALTER TABLE `report_post`
  ADD PRIMARY KEY (`report_id`),
  ADD KEY `usr_id` (`usr_id`,`post_id`),
  ADD KEY `target_id` (`post_id`);

--
-- Indexes for table `report_user`
--
ALTER TABLE `report_user`
  ADD PRIMARY KEY (`report_id`),
  ADD KEY `usr_id` (`usr_id`,`target_id`),
  ADD KEY `target_id` (`target_id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`id`),
  ADD KEY `usr_id` (`usr_id`),
  ADD KEY `cus_id` (`cus_id`);

--
-- Indexes for table `usr`
--
ALTER TABLE `usr`
  ADD PRIMARY KEY (`usr_id`);

--
-- Indexes for table `usr_coin`
--
ALTER TABLE `usr_coin`
  ADD UNIQUE KEY `usr_id_2` (`usr_id`),
  ADD KEY `usr_id` (`usr_id`);

--
-- Indexes for table `usr_group`
--
ALTER TABLE `usr_group`
  ADD UNIQUE KEY `usr_id_3` (`usr_id`),
  ADD KEY `usr_id` (`usr_id`),
  ADD KEY `usr_id_2` (`usr_id`);

--
-- Indexes for table `usr_order`
--
ALTER TABLE `usr_order`
  ADD PRIMARY KEY (`id`),
  ADD KEY `usr_id` (`usr_id`),
  ADD KEY `package_id` (`package_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `apply`
--
ALTER TABLE `apply`
  MODIFY `apply_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `art_category`
--
ALTER TABLE `art_category`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `art_purchase`
--
ALTER TABLE `art_purchase`
  MODIFY `purchase_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `ban`
--
ALTER TABLE `ban`
  MODIFY `ban_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `discussion`
--
ALTER TABLE `discussion`
  MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `follow`
--
ALTER TABLE `follow`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `likes`
--
ALTER TABLE `likes`
  MODIFY `like_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `package`
--
ALTER TABLE `package`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `report_post`
--
ALTER TABLE `report_post`
  MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `report_user`
--
ALTER TABLE `report_user`
  MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `usr`
--
ALTER TABLE `usr`
  MODIFY `usr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `apply`
--
ALTER TABLE `apply`
  ADD CONSTRAINT `apply_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`);

--
-- Constraints for table `art_purchase`
--
ALTER TABLE `art_purchase`
  ADD CONSTRAINT `post_id_fk` FOREIGN KEY (`post_id`) REFERENCES `post` (`post_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `usr_id_fk` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `ban`
--
ALTER TABLE `ban`
  ADD CONSTRAINT `ban_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`);

--
-- Constraints for table `comment`
--
ALTER TABLE `comment`
  ADD CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `discussion`
--
ALTER TABLE `discussion`
  ADD CONSTRAINT `discussion_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `discussion_ibfk_2` FOREIGN KEY (`target_id`) REFERENCES `usr` (`usr_id`);

--
-- Constraints for table `follow`
--
ALTER TABLE `follow`
  ADD CONSTRAINT `follow_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `follow_ibfk_2` FOREIGN KEY (`target_id`) REFERENCES `usr` (`usr_id`);

--
-- Constraints for table `likes`
--
ALTER TABLE `likes`
  ADD CONSTRAINT `likes_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `post` (`post_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `likes_ibfk_2` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `post`
--
ALTER TABLE `post`
  ADD CONSTRAINT `post_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `post_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `art_category` (`category_id`);

--
-- Constraints for table `report_post`
--
ALTER TABLE `report_post`
  ADD CONSTRAINT `report_post_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `report_post_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `post` (`post_id`);

--
-- Constraints for table `report_user`
--
ALTER TABLE `report_user`
  ADD CONSTRAINT `report_user_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `report_user_ibfk_2` FOREIGN KEY (`target_id`) REFERENCES `usr` (`usr_id`);

--
-- Constraints for table `transaction`
--
ALTER TABLE `transaction`
  ADD CONSTRAINT `transaction_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `transaction_ibfk_2` FOREIGN KEY (`cus_id`) REFERENCES `usr_order` (`id`);

--
-- Constraints for table `usr_group`
--
ALTER TABLE `usr_group`
  ADD CONSTRAINT `usr_group_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`);

--
-- Constraints for table `usr_order`
--
ALTER TABLE `usr_order`
  ADD CONSTRAINT `usr_order_ibfk_1` FOREIGN KEY (`usr_id`) REFERENCES `usr` (`usr_id`),
  ADD CONSTRAINT `usr_order_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `package` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;