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

START TRANSACTION;



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

--
-- Table structure for table `tbl_ads_placement`
--

CREATE TABLE `tbl_ads_placement` (
  `ads_placement_id` int(11) NOT NULL DEFAULT 1,
  `banner_home` int(11) NOT NULL DEFAULT 1,
  `banner_post_details` int(11) NOT NULL DEFAULT 1,
  `banner_category_details` int(11) NOT NULL DEFAULT 1,
  `banner_search` int(11) NOT NULL DEFAULT 1,
  `interstitial_post_list` int(11) NOT NULL DEFAULT 1,
  `rewarded_post_details` int(11) NOT NULL DEFAULT 1,
  `native_ad_post_list` int(11) NOT NULL DEFAULT 1,
  `native_ad_exit_dialog` int(11) NOT NULL DEFAULT 1,
  `app_open_ad_on_start` int(11) NOT NULL DEFAULT 1,
  `app_open_ad_on_resume` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_ads_placement`
--

INSERT INTO `tbl_ads_placement` (`ads_placement_id`, `banner_home`, `banner_post_details`, `banner_category_details`, `banner_search`, `interstitial_post_list`, `rewarded_post_details`, `native_ad_post_list`, `native_ad_exit_dialog`, `app_open_ad_on_start`, `app_open_ad_on_resume`) VALUES
(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);

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

--
-- Table structure for table `tbl_ads_status`
--

CREATE TABLE `tbl_ads_status` (
  `ads_status_id` int(11) NOT NULL,
  `banner_ad_on_home_page` int(11) NOT NULL,
  `banner_ad_on_search_page` int(11) NOT NULL,
  `banner_ad_on_wallpaper_detail` int(11) NOT NULL,
  `banner_ad_on_wallpaper_by_category` int(11) NOT NULL,
  `interstitial_ad_on_click_wallpaper` int(11) NOT NULL,
  `interstitial_ad_on_wallpaper_detail` int(11) NOT NULL,
  `native_ad_on_wallpaper_list` int(11) NOT NULL,
  `native_ad_on_exit_dialog` int(11) NOT NULL,
  `app_open_ad` int(11) NOT NULL,
  `last_update_ads_status` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_ads_status`
--

INSERT INTO `tbl_ads_status` (`ads_status_id`, `banner_ad_on_home_page`, `banner_ad_on_search_page`, `banner_ad_on_wallpaper_detail`, `banner_ad_on_wallpaper_by_category`, `interstitial_ad_on_click_wallpaper`, `interstitial_ad_on_wallpaper_detail`, `native_ad_on_wallpaper_list`, `native_ad_on_exit_dialog`, `app_open_ad`, `last_update_ads_status`) VALUES
(1, 1, 1, 1, 1, 1, 1, 1, 1, 0, '2023-07-19 09:20:14');

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

--
-- Table structure for table `tbl_app_config`
--

CREATE TABLE `tbl_app_config` (
  `id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `status` varchar(5) NOT NULL,
  `redirect_url` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `cid` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_image` varchar(255) NOT NULL,
  `category_status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`cid`, `category_name`, `category_image`, `category_status`) VALUES
(1, 'Google', '4261-2021-04-03.jpg', 1),
(2, 'Android', '8694-2021-04-03.jpg', 1),
(3, 'Apple', '7971-2021-04-03.jpg', 1),
(4, 'Samsung', '2853-2021-04-03.jpg', 1),
(5, 'Nokia', '2448-2021-04-03.jpg', 1);

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

--
-- Table structure for table `tbl_fcm_template`
--

CREATE TABLE `tbl_fcm_template` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT 'Notification',
  `message` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_fcm_template`
--

INSERT INTO `tbl_fcm_template` (`id`, `title`, `message`, `image`, `link`) VALUES
(1, 'Material Wallpaper', 'Hello world, this is Material Wallpaper, you can purchase this item on Codecanyon', '1690670089_img_featured.jpg', 'https://codecanyon.net/item/material-wallpaper/11637956'),
(2, 'Material Wallpaper', 'New update version is available now', '', 'https://play.google.com/store/apps/details?id=com.solodroid.solowallpaper');

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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE `tbl_gallery` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `view_count` int(11) NOT NULL DEFAULT 0,
  `download_count` int(11) NOT NULL DEFAULT 0,
  `image_url` text NOT NULL,
  `type` varchar(45) NOT NULL DEFAULT 'upload',
  `featured` varchar(10) NOT NULL DEFAULT 'no',
  `tags` text NOT NULL,
  `image_name` varchar(255) NOT NULL DEFAULT 'none',
  `image_resolution` varchar(255) NOT NULL DEFAULT '0',
  `image_size` varchar(255) NOT NULL DEFAULT '0',
  `image_extension` varchar(45) NOT NULL,
  `image_status` int(11) NOT NULL DEFAULT 1,
  `image_thumb` varchar(500) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp(),
  `rewarded` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_gallery`
--

INSERT INTO `tbl_gallery` (`id`, `cat_id`, `image`, `view_count`, `download_count`, `image_url`, `type`, `featured`, `tags`, `image_name`, `image_resolution`, `image_size`, `image_extension`, `image_status`, `image_thumb`, `last_update`, `rewarded`) VALUES
(1, 1, '1617458543_6897_Google Pixel 5 Wallpaper 10.jpg', 0, 0, '', 'upload', 'yes', 'google,pixel 5,stock wallpaper', 'Pixel 5', '1080 x 2280', '228.72 KB', 'image/jpeg', 1, '', '2023-01-04 03:34:41', 1),
(2, 1, '1617458544_22575_Google Pixel 5 Wallpaper 12.jpg', 0, 0, '', 'upload', 'no', 'google,pixel 5,stock wallpaper', 'Pixel 5', '1080 x 2280', '212.47 KB', 'image/jpeg', 1, '', '2021-04-12 03:43:02', 0),
(3, 1, '1617458544_36093_Google Pixel 5 Wallpaper 11.jpg', 0, 0, '', 'upload', 'no', 'google,pixel 5,stock wallpaper', 'Pixel 5', '1080 x 2280', '243.52 KB', 'image/jpeg', 1, '', '2021-04-03 14:06:33', 0),
(4, 1, '1617458544_88897_Google Pixel 5 Wallpaper 1.jpg', 0, 0, '', 'upload', 'no', 'google,pixel 5,stock wallpaper', 'Pixel 5', '1080 x 2280', '350.04 KB', 'image/jpeg', 1, '', '2021-04-03 14:06:55', 0),
(5, 1, '1617458544_97959_Google Pixel 5 Wallpaper 3.jpg', 0, 0, '', 'upload', 'no', 'google,pixel 5,stock wallpaper', 'Pixel 5', '1080 x 2280', '184.18 KB', 'image/jpeg', 1, '', '2023-01-04 03:32:56', 0),
(6, 2, '1690645580_default_image.gif', 0, 0, '', 'upload', 'no', 'Android,live wallpaper', 'Falling star', '423 x 757', '76.72 KB', 'image/gif', 1, '', '2023-07-28 11:53:38', 1),
(7, 2, '1617458708_20186_Android 11 Wallpaper 5.jpg', 0, 0, '', 'upload', 'no', 'android,android 11,android wallpaper,stock wallpaper', 'Android 11', '1048 x 1344', '42.24 KB', 'image/jpeg', 1, '', '2021-04-03 14:05:08', 0),
(9, 2, '1617458708_49073_Android 11 Wallpaper 4.jpg', 0, 0, '', 'upload', 'yes', 'android,android 11,android wallpaper,stock wallpaper', 'Android 11', '1048 x 1344', '33.98 KB', 'image/jpeg', 1, '', '2021-04-05 04:45:52', 1),
(10, 2, '1617458708_85493_Android 11 Wallpaper 2.jpg', 0, 0, '', 'upload', 'no', 'android,android 11,android wallpaper,stock wallpaper', 'Android 11', '1048 x 1344', '32.53 KB', 'image/jpeg', 1, '', '2021-04-12 03:31:27', 0),
(11, 3, '1617458945_5580_Apple iPhone 12 Wallpaper 6.jpg', 0, 0, '', 'upload', 'no', 'apple,ios,iphone 12,stock wallpaper', 'iPhone 12', '1356 x 2934', '172.79 KB', 'image/jpeg', 1, '', '2021-09-22 14:24:07', 0),
(12, 3, '1617458945_12990_Apple iPhone 12 Wallpaper 4.jpg', 0, 0, '', 'upload', 'yes', 'apple,ios,iphone 12,stock wallpaper', 'iPhone 12', '1356 x 2934', '159.57 KB', 'image/jpeg', 1, '', '2021-09-25 10:11:28', 1),
(13, 3, '1617458946_87715_Apple iPhone 12 Wallpaper 9.jpg', 0, 0, '', 'upload', 'no', 'apple,ios,iphone 12,stock wallpaper', 'iPhone 12', '1356 x 2934', '145.49 KB', 'image/jpeg', 1, '', '2021-09-25 10:47:46', 0),
(14, 3, '1617458946_95507_Apple iPhone 12 Wallpaper 2.jpg', 0, 0, '', 'upload', 'yes', 'apple,ios,iphone 12,stock wallpaper', 'iPhone 12', '1356 x 2934', '161.54 KB', 'image/jpeg', 1, '', '2021-12-02 21:55:49', 1),
(15, 3, '1617458946_95865_Apple iPhone 12 Wallpaper 10.jpg', 0, 0, '', 'upload', 'yes', 'apple,ios,iphone 12,stock wallpaper', 'iPhone 12', '1356 x 2934', '147.53 KB', 'image/jpeg', 1, '', '2023-01-04 03:06:46', 1),
(16, 4, '1617459033_26758_Samsung Galaxy S20 FE Wallpaper (Dex) 1.jpg', 0, 0, '', 'upload', 'yes', 'samsung,galaxy s20,stock wallpaper', 'Galaxy S20', '1080 x 1920', '249.35 KB', 'image/jpeg', 1, '', '2023-07-29 17:49:00', 1),
(17, 4, '1617459034_34186_Samsung Galaxy S20 FE Wallpaper 4.jpg', 0, 0, '', 'upload', 'yes', 'samsung,galaxy s20,stock wallpaper', 'Galaxy S20', '1350 x 2400', '265.23 KB', 'image/jpeg', 1, '', '2023-07-29 17:48:57', 1),
(18, 4, '', 0, 0, 'https://raw.githubusercontent.com/solodroid-id/sample-data/master/galaxy-s20-live-purple.mp4', 'url', 'yes', 'android,samsung,galaxy s20,live wallpaper,stock wallpaper', 'Galaxy S20+', '1440 x 3200', '11.98 MB', 'application/octet-stream', 1, '1690669626_galaxy s20 live purple.jpg', '2023-07-29 17:42:47', 1),
(19, 4, '1617459076_37465_Samsung Galaxy Note 20 Dex Wallpaper 3 Exclusive.jpg', 0, 0, '', 'upload', 'no', 'samsung,galaxy note 20,stock wallpaper', 'Galaxy Note 20 Ultra', '1080 x 1920', '330.36 KB', 'image/jpeg', 1, '', '2021-09-25 10:47:41', 0),
(20, 4, '1617459076_87504_Samsung Galaxy Note 20 Dex Wallpaper 2 Exclusive.jpg', 0, 0, '', 'upload', 'yes', 'samsung,galaxy note 20,stock wallpaper', 'Galaxy Note 20 Ultra', '1080 x 1920', '300.55 KB', 'image/jpeg', 1, '', '2022-02-13 08:58:55', 1),
(21, 5, '1617459160_40168_Nokia 1.3 Wallpaper 3.jpg', 0, 0, '', 'upload', 'yes', 'nokia,nokia 1.3,stock wallpaper', 'Nokia 1.3', '856 x 1520', '185.12 KB', 'image/jpeg', 1, '', '2021-09-25 10:47:39', 1),
(22, 5, '1617459161_60387_Nokia 1.3 Wallpaper 5.jpg', 0, 0, '', 'upload', 'no', 'nokia,nokia 1.3,stock wallpaper', 'Nokia 1.3', '856 x 1520', '118.78 KB', 'image/jpeg', 1, '', '2021-11-29 13:40:48', 0),
(23, 5, '1617459211_52569_Nokia 5.3 Wallpaper 2.jpg', 0, 0, '', 'upload', 'yes', 'nokia,nokia 2.4,stock wallpaper', 'Nokia 2.4', '900 x 1600', '111.94 KB', 'image/jpeg', 1, '', '2022-02-14 02:16:13', 1),
(24, 4, '', 0, 0, 'https://raw.githubusercontent.com/solodroid-id/sample-data/master/galaxy-s21-live-violet.mp4', 'url', 'yes', 'android,samsung,galaxy s21,live wallpaper,stock wallpaper', 'Galaxy S21', '1440 x 3200', '11.68 MB', 'application/octet-stream', 1, '1690669969_galaxy s21 live violet.jpg', '2023-07-29 17:42:49', 1),
(25, 5, '1617459211_46414_Nokia 8.3 5G Wallpaper.jpg', 0, 0, '', 'upload', 'no', 'nokia,nokia 2.4,stock wallpaper', 'Nokia 2.4', '938 x 1666', '350.02 KB', 'image/jpeg', 1, '', '2021-11-29 13:40:40', 0),
(26, 5, '1617598117_39183_Nokia 2.4 Wallpaper 1.jpg', 0, 0, '', 'upload', 'no', 'nokia,nokia 2.4,stock wallpaper,nature', 'Nokia 2.4', '900 x 1600', '256.45 KB', 'image/jpeg', 1, '', '2022-02-17 22:26:01', 0);

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

--
-- Table structure for table `tbl_license`
--

CREATE TABLE `tbl_license` (
  `id` int(11) NOT NULL,
  `purchase_code` varchar(255) NOT NULL,
  `item_id` int(11) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `buyer` varchar(255) NOT NULL,
  `license_type` varchar(45) NOT NULL,
  `purchase_date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE `tbl_menu` (
  `menu_id` int(11) NOT NULL,
  `menu_title` varchar(255) NOT NULL,
  `menu_order` varchar(255) NOT NULL,
  `menu_filter` varchar(255) NOT NULL,
  `menu_category` varchar(255) NOT NULL DEFAULT '0',
  `menu_status` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_menu`
--

INSERT INTO `tbl_menu` (`menu_id`, `menu_title`, `menu_order`, `menu_filter`, `menu_category`, `menu_status`) VALUES
(1, 'Recent', 'recent', 'wallpaper', '0', 1),
(2, 'Featured', 'featured', 'both', '0', 1),
(3, 'Popular', 'popular', 'wallpaper', '0', 1),
(4, 'Random', 'random', 'wallpaper', '0', 1),
(5, 'Live Wallpaper', 'recent', 'live', '0', 1);

--
-- Indexes for table `tbl_ads_placement`
--
ALTER TABLE `tbl_ads_placement`
  ADD PRIMARY KEY (`ads_placement_id`);

--
-- Indexes for table `tbl_ads_status`
--
ALTER TABLE `tbl_ads_status`
  ADD PRIMARY KEY (`ads_status_id`);

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

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`cid`);

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

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

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

--
-- Indexes for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- AUTO_INCREMENT for table `tbl_ads_status`
--
ALTER TABLE `tbl_ads_status`
  MODIFY `ads_status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_app_config`
--
ALTER TABLE `tbl_app_config`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

--
-- AUTO_INCREMENT for table `tbl_license`
--
ALTER TABLE `tbl_license`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

