-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `video_learning_app`
--

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level` int(11) NOT NULL DEFAULT 1,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 10,
  `image` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `level`, `parent_id`, `name`, `priority`, `status`, `image`) VALUES
(1, 1, 0, 'Vehicle', 1, 10, '15947938351096_20200715_061715_445b632327.png'),
(2, 1, 0, 'Electronics', 2, 10, '15947938591920_20200715_061739_d199225b72.png'),
(3, 1, 0, 'Mobiles', 3, 10, '15947938699294_20200715_061749_02c63af59a.png'),
(4, 1, 0, 'Furniture', 4, 10, '15947938962788_20200715_061816_8aa05ba719.png'),
(5, 1, 0, 'Fashion', 5, 10, '15947939065300_20200715_061826_4302396647.png'),
(6, 1, 0, 'Real Estate', 6, 10, '15947939176732_20200715_061837_c47b593d4a.png'),
(7, 1, 0, 'Animals', 7, 10, '15947939274792_20200715_061847_79625efa9f.png'),
(8, 1, 0, 'Education', 8, 10, '15947939376983_20200715_061857_19a04c667b.png'),
(9, 1, 0, 'Baby products', 9, 10, '15947939481750_20200715_061908_17ca6e5b89.png'),
(10, 1, 0, 'Services', 10, 10, '15947939567139_20200715_061916_db7b489086.png'),
(11, 2, 1, 'Car', 0, 10, NULL),
(12, 2, 1, 'Moter Cycle', 0, 10, NULL),
(13, 2, 2, 'TV', 0, 10, NULL),
(14, 2, 2, 'Laptop', 0, 10, NULL),
(15, 2, 4, 'Bed', 0, 10, NULL);

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

--
-- Table structure for table `gallary`
--

CREATE TABLE IF NOT EXISTS `gallary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 10 COMMENT '10=active,0=deleted,9=inactive',
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `gallary`
--

INSERT INTO `gallary` (`id`, `image`, `status`, `created_at`, `updated_at`) VALUES
(3, '16181498146487_20210411_140334_461cce92ca.jpg', 10, 1618149814, NULL),
(16, '16181503973081_20210411_141317_6f1343fca4.jpg', 10, 1618150397, NULL),
(4, '16181498146508_20210411_140334_546426a856.jpg', 10, 1618149814, NULL),
(5, '16181501621261_20210411_140922_0524c46c7d.jpg', 10, 1618150162, NULL),
(6, '16181501621283_20210411_140922_0fc5898a08.jpg', 10, 1618150162, NULL),
(7, '16181501621529_20210411_140922_7633932fe2.png', 10, 1618150162, NULL),
(8, '16181501621565_20210411_140922_6e6bd95dd5.png', 10, 1618150162, NULL),
(9, '16181501621599_20210411_140922_1904518a9d.jpg', 10, 1618150162, NULL),
(10, '16181501621625_20210411_140922_d322cfd62c.jpg', 10, 1618150162, NULL),
(11, '16181502837247_20210411_141123_792a9575a8.png', 10, 1618150283, NULL),
(12, '16181502837260_20210411_141123_555dcc1487.png', 10, 1618150283, NULL),
(13, '16181502837273_20210411_141123_a328d353ea.png', 10, 1618150283, NULL),
(14, '16181502837289_20210411_141123_8ed91b3a83.png', 10, 1618150283, NULL),
(15, '16181502837312_20210411_141123_58bc9c8616.png', 10, 1618150283, NULL),
(17, '16181504166806_20210411_141336_48d01cbc68.jpg', 10, 1618150416, NULL),
(18, '16286118205812_20210810_161020_5585714491.png', 10, 1628611820, NULL);

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

--
-- Table structure for table `migration`
--

CREATE TABLE IF NOT EXISTS `migration` (
  `version` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `apply_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migration`
--

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1592158836),
('m130524_201442_init', 1592159285),
('m190124_110200_add_verification_token_column_to_user_table', 1592159285);

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

--
-- Table structure for table `payment`
--

CREATE TABLE IF NOT EXISTS `payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `transaction_type` int(11) NOT NULL DEFAULT 1 COMMENT '1=credit, 2= debit',
  `payment_type` int(11) NOT NULL DEFAULT 1 COMMENT '1=package subsciption,2=feature ad,3=banner ad',
  `payment_mode` int(11) NOT NULL COMMENT '1=in app purchase,2=paypal',
  `transaction_id` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` float NOT NULL,
  `created_at` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE IF NOT EXISTS `post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `title` varchar(256) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `video_source` int(11) NOT NULL DEFAULT 1 COMMENT '1=manual upload,2=ftp upload',
  `video` varchar(256) DEFAULT NULL,
  `image` varchar(256) DEFAULT NULL,
  `is_premium` int(11) NOT NULL DEFAULT 0,
  `status` int(11) NOT NULL DEFAULT 10,
  `created_at` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(265) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `in_app_purchase_id` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pinterest` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `site_name`, `email`, `phone`, `in_app_purchase_id`, `facebook`, `youtube`, `twitter`, `linkedin`, `pinterest`, `instagram`) VALUES
(1, 'Video Learning', 'baljt.develper@gmal.com', '941649265', '', 'http://facebook.com/', '', 'https://twitter.com/', '', '', '');
COMMIT;

