SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
-- --------------------------------------------------------
--
-- Table structure for table `ws_ads_management`
--
CREATE TABLE IF NOT EXISTS `ws_ads_management` (
`ad_seq_id` int(11) NOT NULL,
`ad_name` varchar(255) DEFAULT NULL,
`ad_code` text
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_ads_management`
--
INSERT INTO `ws_ads_management` (`ad_seq_id`, `ad_name`, `ad_code`) VALUES
(1, 'Below Menu', ''),
(2, 'In Between Images After - 3 Image (Global)', ''),
(3, 'In Between Images After - 6 Image (Global)', ''),
(5, 'Wallpaper Page - Above Resolutions or Description', ''),
(6, 'Wallpaper Preview Page Below Download Bar', '');
-- --------------------------------------------------------
--
-- Table structure for table `ws_category`
--
CREATE TABLE IF NOT EXISTS `ws_category` (
`category_seq_id` int(11) NOT NULL,
`category_slug` varchar(150) DEFAULT NULL,
`category_name` varchar(150) DEFAULT NULL,
`category_parent_id` int(11) DEFAULT NULL,
`category_status` int(11) DEFAULT '1'
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_category`
--
INSERT INTO `ws_category` (`category_seq_id`, `category_slug`, `category_name`, `category_parent_id`, `category_status`) VALUES
(1, '3d-abstract', '3D & Abstract', NULL, 1),
(2, 'animals-birds', 'Animals & Birds', NULL, 1),
(3, 'cute-animals', 'Cute Animals', 2, 1),
(4, 'tigers', 'Tigers', 2, 1),
(5, 'pets', 'Pets', 2, 1),
(6, 'anime', 'Anime', NULL, 1),
(7, 'beach', 'Beach', NULL, 1),
(8, 'bikes', 'Bikes', NULL, 1),
(9, 'brands-logos', 'Brands & Logos', NULL, 1),
(10, 'apple', 'Apple', 9, 1),
(11, 'windows', 'Windows', 9, 1),
(27, 'celebrations', 'Celebrations', NULL, 1),
(28, 'new-year', 'New Year', 27, 1),
(52, 'games', 'Games', NULL, 1),
(57, 'nature', 'Nature', NULL, 1),
(58, 'others', 'Others', NULL, 1),
(59, 'photography', 'Photography', NULL, 1),
(64, 'xbox', 'Xbox', 52, 1),
(65, 'xbox-one', 'Xbox One', 64, 1);
-- --------------------------------------------------------
--
-- Table structure for table `ws_closures`
--
CREATE TABLE IF NOT EXISTS `ws_closures` (
`id` int(11) NOT NULL,
`ancestor` int(11) NOT NULL,
`descendant` int(11) NOT NULL,
`lvl` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=138 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ws_closures`
--
INSERT INTO `ws_closures` (`id`, `ancestor`, `descendant`, `lvl`) VALUES
(1, 1, 1, 0),
(2, 2, 2, 0),
(3, 2, 3, 1),
(4, 3, 3, 0),
(6, 2, 4, 1),
(7, 4, 4, 0),
(9, 2, 5, 1),
(10, 5, 5, 0),
(12, 6, 6, 0),
(13, 7, 7, 0),
(14, 8, 8, 0),
(15, 9, 9, 0),
(16, 9, 10, 1),
(17, 10, 10, 0),
(19, 9, 11, 1),
(20, 11, 11, 0),
(65, 27, 27, 0),
(66, 27, 28, 1),
(67, 28, 28, 0),
(120, 52, 52, 0),
(125, 57, 57, 0),
(126, 58, 58, 0),
(127, 59, 59, 0),
(132, 52, 64, 1),
(133, 64, 64, 0),
(135, 52, 65, 2),
(136, 64, 65, 1),
(137, 65, 65, 0);
-- --------------------------------------------------------
--
-- Table structure for table `ws_comments_reports`
--
CREATE TABLE IF NOT EXISTS `ws_comments_reports` (
`report_seq_id` int(11) NOT NULL,
`comment_seq_id` int(11) DEFAULT NULL,
`user_seq_id` int(11) DEFAULT NULL,
`report_msg` text,
`report_date` datetime DEFAULT NULL,
`report_status` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_languages`
--
CREATE TABLE IF NOT EXISTS `ws_languages` (
`language_seq_id` int(11) NOT NULL,
`language_name` varchar(45) DEFAULT NULL,
`language_code` varchar(45) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_languages`
--
INSERT INTO `ws_languages` (`language_seq_id`, `language_name`, `language_code`) VALUES
(1, 'Afrikaans', 'af'),
(2, 'Albanian', 'sq'),
(3, 'Arabic', 'ar'),
(4, 'Armenian', 'hy'),
(5, 'Azerbaijani', 'az'),
(6, 'Basque', 'eu'),
(7, 'Belarusian', 'be'),
(8, 'Bengali', 'bn'),
(9, 'Bosnian', 'bs'),
(10, 'Bulgarian', 'bg'),
(11, 'Catalan', 'ca'),
(12, 'Cebuano', 'ceb'),
(13, 'Chinese', 'zh-CN'),
(14, 'Croatian', 'hr'),
(15, 'Czech', 'cs'),
(16, 'Danish', 'da'),
(17, 'Dutch', 'nl'),
(18, 'English', 'en'),
(19, 'Esperanto', 'eo'),
(20, 'Estonian', 'et'),
(21, 'Filipino', 'tl'),
(22, 'Finnish', 'fi'),
(23, 'French', 'fr'),
(24, 'Galician', 'gl'),
(25, 'Georgian', 'ka'),
(26, 'German', 'de'),
(27, 'Greek', 'el'),
(28, 'Gujarati', 'gu'),
(29, 'Haitian Creole', 'ht'),
(30, 'Hausa', 'ha'),
(31, 'Hebrew', 'iw'),
(32, 'Hindi', 'hi'),
(33, 'Hmong', 'hmn'),
(34, 'Hungarian', 'hu'),
(35, 'Icelandic', 'is'),
(36, 'Igbo', 'ig'),
(37, 'Indonesian', 'id'),
(38, 'Irish', 'ga'),
(39, 'Italian', 'it'),
(40, 'Japanese', 'ja'),
(41, 'Javanese', 'jw'),
(42, 'Kannada', 'kn'),
(43, 'Khmer', 'km'),
(44, 'Korean', 'ko'),
(45, 'Lao', 'lo'),
(46, 'Latin', 'la'),
(47, 'Latvian', 'lv'),
(48, 'Lithuanian', 'lt'),
(49, 'Macedonian', 'mk'),
(50, 'Malay', 'ms'),
(51, 'Maltese', 'mt'),
(52, 'Maori', 'mi'),
(53, 'Marathi', 'mr'),
(54, 'Mongolian', 'mn'),
(55, 'Nepali', 'ne'),
(56, 'Norwegian', 'no'),
(57, 'Persian', 'fa'),
(58, 'Polish', 'pl'),
(59, 'Portuguese', 'pt'),
(60, 'Punjabi', 'pa'),
(61, 'Romanian', 'ro'),
(62, 'Russian', 'ru'),
(63, 'Serbian', 'sr'),
(64, 'Slovak', 'sk'),
(65, 'Slovenian', 'sl'),
(66, 'Somali', 'so'),
(67, 'Spanish', 'es'),
(68, 'Swahili', 'sw'),
(69, 'Swedish', 'sv'),
(70, 'Tamil', 'ta'),
(71, 'Telugu', 'te'),
(72, 'Thai', 'th'),
(73, 'Turkish', 'tr'),
(74, 'Ukrainian', 'uk'),
(75, 'Urdu', 'ur'),
(76, 'Vietnamese', 'vi'),
(77, 'Welsh', 'cy'),
(78, 'Yiddish', 'yi'),
(79, 'Yoruba', 'yo'),
(80, 'Zulu', 'zu');
-- --------------------------------------------------------
--
-- Table structure for table `ws_language_grouping`
--
CREATE TABLE IF NOT EXISTS `ws_language_grouping` (
`lg_seq_id` int(11) NOT NULL,
`lg_name` varchar(45) DEFAULT NULL,
`language_seq_id` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_language_grouping`
--
INSERT INTO `ws_language_grouping` (`lg_seq_id`, `lg_name`, `language_seq_id`) VALUES
(1, 'Backend', 62),
(2, 'Frontend', 62);
-- --------------------------------------------------------
--
-- Table structure for table `ws_language_text`
--
CREATE TABLE IF NOT EXISTS `ws_language_text` (
`lt_seq_id` int(11) NOT NULL,
`lt_data_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`lg_seq_id` int(11) DEFAULT NULL,
`lt_data_group` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`lt_default_value` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`lt_key_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_language_text`
--
INSERT INTO `ws_language_text` (`lt_seq_id`, `lt_data_key`, `lg_seq_id`, `lt_data_group`, `lt_default_value`, `lt_key_info`) VALUES
(1, 'account_avatar', 2, 'account', 'Account Avatar', NULL),
(2, 'profile_pic', 2, 'account', 'Profile Pic', NULL),
(3, 'file_upload', 2, 'account', 'File Upload', NULL),
(4, 'minimum_size_required', 2, 'account', 'Minimum Size Required', NULL),
(5, 'account_profile', 2, 'account', 'Account Profile', NULL),
(6, 'my_profile_link', 2, 'account', 'My Profile Link', NULL),
(7, 'user-email-address', 2, 'account', 'User email address', NULL),
(8, 'enter-the-words-above', 2, 'account', 'Enter the words above', NULL),
(9, 'enter-the-numbers-you-hear', 2, 'account', 'Enter the numbers you hear', NULL),
(10, 'incorrect-please-try-again', 2, 'account', 'Incorrect please try again', NULL),
(11, 'remember-me', 2, 'account', 'Remember me', NULL),
(12, 'sign-in-with-facebook', 2, 'account', 'Sign In with Facebook', NULL),
(13, 'sign-up-here', 2, 'account', 'Sign Up Here', NULL),
(14, 'forgotten-password', 2, 'account', 'Forgotten Password', NULL),
(15, 'dont-have-an-account', 2, 'account', 'Don''t have an account', NULL),
(16, 'reset-password', 2, 'account', 'Reset Password', NULL),
(17, 'update-profile', 2, 'account', 'Update Profile', NULL),
(18, 'full-name', 2, 'account', 'Full Name', NULL),
(19, 'others-can-see-my-stuff', 2, 'account', 'Others can see my stuff', NULL),
(20, 'old-password', 2, 'account', 'Old Password', NULL),
(21, 're-type-password', 2, 'account', 'Re-type Password', NULL),
(22, 'update-password', 2, 'account', 'Update Password', NULL),
(23, 'account-settings', 2, 'account', 'Account Settings', NULL),
(24, 'user-full-name', 2, 'account', 'User Full Name', NULL),
(25, 'sign-in-here', 2, 'account', 'Sign In Here', NULL),
(26, 'do-you-have-an-account', 2, 'account', 'Do you have an account', NULL),
(27, 'my-account-details', 2, 'account', 'My Acount Details', NULL),
(28, 'my-account', 2, 'account', 'My Account', NULL),
(29, 'my-wallpapers', 2, 'account', 'My Wallpapers', NULL),
(30, 'my-favorites', 2, 'account', 'My Favorite''s', NULL),
(31, 'wallpapers-i-like', 2, 'account', 'Wallpaper''s I Like', NULL),
(32, 'wallpapers-i-dislike', 2, 'account', 'Wallpaper''s I Dislike', NULL),
(33, 'my-downloads', 2, 'account', 'My Downloads', NULL),
(34, 'update-avatar', 2, 'account', 'Update Avatar', NULL),
(35, 'your-name', 2, 'account', 'Your Name', NULL),
(36, 'your-email-address', 2, 'account', 'Your Email Address', NULL),
(37, 'your-subject', 2, 'account', 'Your Subject', NULL),
(38, 'your-message', 2, 'account', 'Your Message', NULL),
(39, 'send-message', 2, 'account', 'Send Message', NULL),
(40, 'our-office', 2, 'account', 'Our office', NULL),
(41, 'your-email', 2, 'account', 'Your email', NULL),
(42, 'thank-you-for-creating-a', 2, 'account', 'Thank you for creating a', NULL),
(43, 'please-click-below', 2, 'account', 'Please Click below', NULL),
(44, 'activation', 2, 'account', 'activation', NULL),
(45, 'youre-all-ready-to-go', 2, 'account', 'You''re all ready to go', NULL),
(46, 'user-email', 2, 'account', 'User Email', NULL),
(47, 'captcha-code', 2, 'account', 'Captcha Code', NULL),
(48, 'new-password-has-sent-to-your-mail', 2, 'account', 'New password has sent to your mail', NULL),
(49, 'email-address-not-exists-in-or-database', 2, 'account', 'Email address Not exists in or database', NULL),
(50, 'activation-link', 2, 'account', 'Activation Link', NULL),
(51, 'please-check-your-email-we-have-send-you-activation-code', 2, 'account', 'Please Check your email We have Send you activation Code', NULL),
(52, 'user-name', 2, 'account', 'User Name', NULL),
(53, 'user-password', 2, 'account', 'User Password', NULL),
(54, 'invalid-old-password', 2, 'account', 'Invalid Old Password', NULL),
(55, 'user-data-updated-successfully', 2, 'account', 'User Data Updated Successfully', NULL),
(56, 'profile-pic-updated-successfully', 2, 'account', 'Profile Pic Updated Successfully', NULL),
(57, 'unable-to-move-file', 2, 'account', 'Unable to Move File', NULL),
(58, 'login_confirm_msg', 2, 'account', 'Sorry We need to Confirm your email address we have sent you activation code. If you have\\''nt received please', NULL),
(59, 'invalid-username/password', 2, 'account', 'Invalid Username/Password', NULL),
(60, 'registration-has-disabled', 2, 'account', 'Registration has Disabled', NULL),
(61, 'acc_created_success', 2, 'account', 'Account Created Successfully. Please check your Email we have dispatched activation link.', NULL),
(62, 'email-already-exists-in-database', 2, 'account', 'Email Already Exists in database', NULL),
(63, 'author-url', 2, 'account', 'Author URL', NULL),
(64, 'html-data-is-not-allowed', 2, 'comment', 'Html data is not allowed', NULL),
(65, 'you-message-has-been-sent-successfully', 2, 'comment', 'You Message has been Sent Successfully', NULL),
(66, 'guest-name', 2, 'comment', 'Guest Name', NULL),
(67, 'guest-email', 2, 'comment', 'Guest Email', NULL),
(68, 'comment-text', 2, 'comment', 'Comment Text', NULL),
(69, 'your-comment-has-been-submitted', 2, 'comment', 'Your Comment Has been Submitted', NULL),
(70, 'waiting-for-approval', 2, 'comment', '& waiting for approval', NULL),
(71, 'crop-&-set-as-cover-picture', 2, 'crop', 'Crop & Set as Cover Picture', NULL),
(72, 'page-not-found', 2, 'error_404', 'Page Not Found', NULL),
(73, 'back-to-home-page', 2, 'error_404', 'Back to Home Page', NULL),
(74, 'page-not-found-msg', 2, 'error_404', 'We''re Sorry! The page you are looking for doesn''t seem to exist.', NULL),
(75, 'unable-to-connect-to-facebook-now-try-again-later', 2, 'facebook', 'Unable to Connect to facebook Now try again later', NULL),
(76, 'sorry-your-facebook-account-is-not-verified', 2, 'facebook', 'Sorry Your Facebook account is not verified', NULL),
(77, 'sorry-registration-has-disabled', 2, 'facebook', 'Sorry! Registration has Disabled', NULL),
(78, 'unable-to-insert-database-please-try-again-later', 2, 'facebook', 'Unable to insert Database please try again later', NULL),
(79, 'login', 2, 'global', 'Login', NULL),
(80, 'logout', 2, 'global', 'Logout', NULL),
(81, 'administrator', 2, 'global', 'Administrator', NULL),
(82, 'profile', 2, 'global', 'Profile', NULL),
(83, 'account', 2, 'global', 'account', NULL),
(84, 'random', 2, 'global', 'Random', NULL),
(85, 'rating', 2, 'global', 'Rating', NULL),
(86, 'favourites', 2, 'global', 'Favourites', NULL),
(87, 'views', 2, 'global', 'Views', NULL),
(88, 'downloads', 2, 'global', 'Downloads', NULL),
(89, 'latest', 2, 'global', 'Latest', NULL),
(90, 'wallpapers', 2, 'global', 'Wallpapers', NULL),
(91, 'categories', 2, 'global', 'Categories', NULL),
(92, 'search', 2, 'global', 'Search', NULL),
(93, 'tags', 2, 'global', 'Tags', NULL),
(94, 'contact', 2, 'global', 'Contact', NULL),
(95, 'submit_wallpaper', 2, 'global', 'Submit Wallpaper', NULL),
(96, 'upload', 2, 'global', 'Upload', NULL),
(97, 'info', 2, 'global', 'info', NULL),
(98, 'name', 2, 'global', 'Name', NULL),
(99, 'created', 2, 'global', 'Created', NULL),
(100, 'ago', 2, 'global', 'ago', NULL),
(101, 'last_login', 2, 'global', 'Last Login', NULL),
(102, 'email_confirmation', 2, 'global', 'Email Confirmation', NULL),
(103, 'success', 2, 'global', 'Success', NULL),
(104, 'pending', 2, 'global', 'Pending', NULL),
(105, 'password', 2, 'global', 'password', NULL),
(106, 'yes', 2, 'global', 'Yes', NULL),
(107, 'sign-up', 2, 'global', 'Sign Up', NULL),
(108, 'reported', 2, 'global', 'Reported', NULL),
(109, 'awaiting-approval', 2, 'global', 'Awaiting Approval', NULL),
(110, 'contact-us', 2, 'global', 'Contact US', NULL),
(111, 'close', 2, 'global', 'Close', NULL),
(112, 'disabled', 2, 'global', 'Disabled', NULL),
(113, 'not-approved', 2, 'global', 'Not Approved', NULL),
(114, 'images-not-found', 2, 'global', 'Images not found', NULL),
(115, 'edit-image', 2, 'global', 'Edit Image', NULL),
(116, 'delete-image', 2, 'global', 'Delete Image', NULL),
(117, 'sort-by', 2, 'global', 'Sort By', NULL),
(118, 'all-times', 2, 'global', 'All Times', NULL),
(119, 'today', 2, 'global', 'Today', NULL),
(120, 'last-7-days', 2, 'global', 'Last 7 Days', NULL),
(121, 'last-30-days', 2, 'global', 'Last 30 Days', NULL),
(122, 'last-60-days', 2, 'global', 'Last 60 Days', NULL),
(123, 'all', 2, 'global', 'All', NULL),
(124, 'select-category', 2, 'global', 'Select Category', NULL),
(125, 'select-time', 2, 'global', 'Select Time', NULL),
(126, 'select-sort', 2, 'global', 'Select Sort', NULL),
(127, 'found', 2, 'global', 'Found', NULL),
(128, 'tag-title', 2, 'global', 'Tag Title', NULL),
(129, 'tagged-images', 2, 'global', 'Tagged Images', NULL),
(130, 'popularity', 2, 'global', 'Popularity', NULL),
(131, 'view', 2, 'global', 'View', NULL),
(132, 'delete', 2, 'global', 'Delete', NULL),
(133, 'image-name', 2, 'global', 'Image Name', NULL),
(134, 'file', 2, 'global', 'File', NULL),
(135, 'url', 2, 'global', 'URL', NULL),
(136, 'enable', 2, 'global', 'Enable', NULL),
(137, 'disable', 2, 'global', 'Disable', NULL),
(138, 'submit', 2, 'global', 'Submit', NULL),
(139, 'previous', 2, 'global', 'Previous', NULL),
(140, 'next', 2, 'global', 'Next', NULL),
(141, 'share-it', 2, 'global', 'Share It', NULL),
(142, 'edit', 2, 'global', 'Edit', NULL),
(143, 'admin', 2, 'global', 'Admin', NULL),
(144, 'category', 2, 'global', 'Category', NULL),
(145, 'added', 2, 'global', 'Added', NULL),
(146, 'author', 2, 'global', 'Author', NULL),
(147, 'total', 2, 'global', 'Total', NULL),
(148, 'out-of', 2, 'global', 'out of', NULL),
(149, 'download', 2, 'global', 'Download', NULL),
(150, 'yours', 2, 'global', 'Yours', NULL),
(151, 'back', 2, 'global', 'Back', NULL),
(152, 'resolution', 2, 'global', 'Resolution', NULL),
(153, 'home', 2, 'global', 'Home', NULL),
(154, 'resolutions', 2, 'global', 'Resolutions', NULL),
(155, 'subject', 2, 'global', 'Subject', NULL),
(156, 'email', 2, 'global', 'Email', NULL),
(157, 'your-new-password', 2, 'global', 'Your New Password', NULL),
(158, 'thanks', 2, 'global', 'Thanks', NULL),
(159, 'sorry', 2, 'global', 'Sorry', NULL),
(160, 'message', 2, 'global', 'Message', NULL),
(161, 'captcha-code', 2, 'global', 'Captcha Code', NULL),
(162, 'featured-wallpapers', 2, 'home', 'Featured Wallpapers', NULL),
(163, 'latest-wallpapers', 2, 'home', 'Latest Wallpapers', NULL),
(164, 'global-resolution-has-set-successfully', 2, 'js', 'Global Resolution has set Successfully', NULL),
(165, 'GRHRS', 2, 'js', 'Global Resolution has removed Successfully', NULL),
(166, 'wallpaper-hash-doest-exists', 2, 'js', 'Wallpaper Hash Does''t Exists', NULL),
(167, 'wallpaper-ratted-successfully', 2, 'js', 'Wallpaper Ratted Successfully', NULL),
(168, 'wallpaper-has-added-to-your-favourite', 2, 'js', 'Wallpaper has added to your Favourite', NULL),
(169, 'WHRFYYF', 2, 'js', 'Wallpaper has Removed from your your Favourite', NULL),
(170, 'your-msg', 2, 'js', 'Your Msg', NULL),
(171, 'comment-id', 2, 'js', 'Comment ID', NULL),
(172, 'YHSRTCI', 2, 'js', 'You have successfully reported to comment ID', NULL),
(173, 'redirecting-to-login-page', 2, 'js', 'Redirecting to login Page', NULL),
(174, 'redirecting-to-approve-image', 2, 'js', 'Redirecting to Approve Image', NULL),
(175, 'wallpaper-not-found', 2, 'js', 'Wallpaper Not Found', NULL),
(176, 'CHSUTYP', 2, 'js', 'Cover has successfully uploaded to your profile', NULL),
(177, 'welcome-email/activation', 2, 'mail', 'Welcome Email/Activation', NULL),
(178, 'email-already-activated', 2, 'mail', 'Email already Activated', NULL),
(179, 'email-activated-successfully', 2, 'mail', 'Email Activated Successfully', NULL),
(180, 'invalid-activation-code', 2, 'mail', 'Invalid Activation Code', NULL),
(181, 'upload-image', 2, 'upload', 'Upload Image', NULL),
(182, 'edit-image', 2, 'upload', 'Edit Image', NULL),
(183, 'upload-by', 2, 'upload', 'Upload BY', NULL),
(184, 'insert-image-url', 2, 'upload', 'Insert Image URL', NULL),
(185, 'minimum-image-size-required', 2, 'upload', 'Minimum Image Size Required', NULL),
(186, 'no-minimum-size', 2, 'upload', 'No Minimum Size', NULL),
(187, 'select-category', 2, 'upload', 'Select Category', NULL),
(188, 'tags', 2, 'upload', 'Tags', NULL),
(189, 'author-name', 2, 'upload', 'Author Name', NULL),
(190, 'image-position', 2, 'upload', 'Image Position', NULL),
(191, 'author-url', 2, 'upload', 'Author URL', NULL),
(192, 'publish-status', 2, 'upload', 'Publish Status', NULL),
(193, 'optional-data', 2, 'upload', 'Optional Data', NULL),
(194, 'description', 2, 'upload', 'Description', NULL),
(195, 'meta-title', 2, 'upload', 'Meta Title', NULL),
(196, 'meta-description', 2, 'upload', 'Meta Description', NULL),
(197, 'meta-keywords', 2, 'upload', 'Meta Keywords', NULL),
(198, 'save-&-edit', 2, 'upload', 'Save & Edit', NULL),
(199, 'save-&-new', 2, 'upload', 'Save & New', NULL),
(200, 'you-know-you-can-drag-&-drop-file-here', 2, 'upload', 'You Know you can Drag & Drop File Here', NULL),
(201, 'image-name', 2, 'upload', 'Image Name', NULL),
(202, 'image-status', 2, 'upload', 'Image Status', NULL),
(203, 'unable-to-connect-server', 2, 'upload', 'Unable To Connect Server', NULL),
(204, 'IFFAOJOP', 2, 'upload', 'Invalid File Format accepts only JPEG or PNG', NULL),
(205, 'ICISCIINE', 2, 'upload', 'Invalid Category ID: Selected Category ID is not exists', NULL),
(206, 'wallpaper-uploaded-successfully', 2, 'upload', 'Wallpaper Uploaded Successfully', NULL),
(207, 'invalid-wallpaper-hash-id', 2, 'upload', 'Invalid Wallpaper Hash ID', NULL),
(208, 'wallpaper-updated-successfully', 2, 'upload', 'Wallpaper Updated Successfully', NULL),
(209, 'image-removed-successfully', 2, 'upload', 'Image Removed Successfully', NULL),
(210, 'loading-to-vote-up', 2, 'wallpaper', 'Loading to Vote Up', NULL),
(211, 'please-login-in-order-to-vote', 2, 'wallpaper', 'Please Login in order to Vote', NULL),
(212, 'loading-to-vote-down', 2, 'wallpaper', 'Loading to Vote Down', NULL),
(213, 'please-login-to-add-this-in-favorite-list', 2, 'wallpaper', 'Please Login to add this in Favorite list', NULL),
(214, 'loading---adding-this-to-your-favorites', 2, 'wallpaper', 'Loading - Adding this to your Favorites', NULL),
(215, 'loading---removing-this-from-your-favorites', 2, 'wallpaper', 'Loading - Removing this from your Favorites', NULL),
(216, 'make-it-has-cover-picture', 2, 'wallpaper', 'Make it has Cover Picture', NULL),
(217, 'sorry-your-screen-resolution-is-not-available-for-this-wallpaper.', 2, 'wallpaper', 'Sorry Your screen resolution is not available for this wallpaper.', NULL),
(218, 'available-resolutions', 2, 'wallpaper', 'Available Resolutions', NULL),
(219, 'related-wallpapers', 2, 'wallpaper', 'Related Wallpapers', NULL),
(220, 'comments', 2, 'wallpaper', 'Comments', NULL),
(221, 'report-this-comment-id', 2, 'wallpaper', 'Report this comment id', NULL),
(222, 'load-more', 2, 'wallpaper', 'Load More', NULL),
(223, 'to-wallpaper', 2, 'wallpaper', 'to wallpaper', NULL),
(224, 'crop-&-set-as-cover-picture', 2, 'wallpaper', 'Crop & Set as Cover Picture', NULL),
(225, 'facebook---set-as-cover-picture', 2, 'wallpaper', 'Facebook - Set as Cover Picture', NULL),
(226, 'click-here-to-approve-cover', 2, 'wallpaper', 'Click here to approve Cover', NULL),
(227, 'SRSBLTTAR', 2, 'wallpaper', 'Selected Resolution Should be lesser then the available Resolution', NULL),
(228, 'sorry-original-image-doest-exists', 2, 'wallpaper', 'Sorry Original Image Does\\''t Exists', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `ws_language_text_value`
--
CREATE TABLE IF NOT EXISTS `ws_language_text_value` (
`ltv_seq_id` int(11) NOT NULL,
`lt_seq_id` int(11) DEFAULT NULL,
`language_seq_id` int(11) DEFAULT NULL,
`ltv_value` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
) ENGINE=InnoDB AUTO_INCREMENT=511 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_language_text_value`
--
INSERT INTO `ws_language_text_value` (`ltv_seq_id`, `lt_seq_id`, `language_seq_id`, `ltv_value`) VALUES
(1, 1, 18, 'Account Avatar'),
(2, 2, 18, 'Profile Pic'),
(3, 3, 18, 'File Upload'),
(4, 4, 18, 'Minimum Size Required'),
(5, 5, 18, 'Account Profile'),
(6, 6, 18, 'My Profile Link'),
(7, 7, 18, 'User email address'),
(8, 8, 18, 'Enter the words above'),
(9, 9, 18, 'Enter the numbers you hear'),
(10, 10, 18, 'Incorrect please try again'),
(11, 11, 18, 'Remember me'),
(12, 12, 18, 'Sign In with Facebook'),
(13, 13, 18, 'Sign Up Here'),
(14, 14, 18, 'Forgotten Password'),
(15, 15, 18, 'Don''t have an account'),
(16, 16, 18, 'Reset Password'),
(17, 17, 18, 'Update Profile'),
(18, 18, 18, 'Full Name'),
(19, 19, 18, 'Others can see my stuff'),
(20, 20, 18, 'Old Password'),
(21, 21, 18, 'Re-type Password'),
(22, 22, 18, 'Update Password'),
(23, 23, 18, 'Account Settings'),
(24, 24, 18, 'User Full Name'),
(25, 25, 18, 'Sign In Here'),
(26, 26, 18, 'Do you have an account'),
(27, 27, 18, 'My Acount Details'),
(28, 28, 18, 'My Account'),
(29, 29, 18, 'My Wallpapers'),
(30, 30, 18, 'My Favorite''s'),
(31, 31, 18, 'Wallpaper''s I Like'),
(32, 32, 18, 'Wallpaper''s I Dislike'),
(33, 33, 18, 'My Downloads'),
(34, 34, 18, 'Update Avatar'),
(35, 35, 18, 'Your Name'),
(36, 36, 18, 'Your Email Address'),
(37, 37, 18, 'Your Subject'),
(38, 38, 18, 'Your Message'),
(39, 39, 18, 'Send Message'),
(40, 40, 18, 'Our office'),
(41, 41, 18, 'Your email'),
(42, 42, 18, 'Thank you for creating a'),
(43, 43, 18, 'Please Click below'),
(44, 44, 18, 'activation'),
(45, 45, 18, 'You''re all ready to go'),
(46, 46, 18, 'User Email'),
(47, 47, 18, 'Captcha Code'),
(48, 48, 18, 'New password has sent to your mail'),
(49, 49, 18, 'Email address Not exists in or database'),
(50, 50, 18, 'Activation Link'),
(51, 51, 18, 'Please Check your email We have Send you activation Code'),
(52, 52, 18, 'User Name'),
(53, 53, 18, 'User Password'),
(54, 54, 18, 'Invalid Old Password'),
(55, 55, 18, 'User Data Updated Successfully'),
(56, 56, 18, 'Profile Pic Updated Successfully'),
(57, 57, 18, 'Unable to Move File'),
(58, 58, 18, 'Sorry We need to Confirm your email address we have sent you activation code. If you have\\''nt received please'),
(59, 59, 18, 'Invalid Username/Password'),
(60, 60, 18, 'Registration has Disabled'),
(61, 61, 18, 'Account Created Successfully. Please check your Email we have dispatched activation link.'),
(62, 62, 18, 'Email Already Exists in database'),
(63, 63, 18, 'Author URL'),
(64, 64, 18, 'Html data is not allowed'),
(65, 65, 18, 'You Message has been Sent Successfully'),
(66, 66, 18, 'Guest Name'),
(67, 67, 18, 'Guest Email'),
(68, 68, 18, 'Comment Text'),
(69, 69, 18, 'Your Comment Has been Submitted'),
(70, 70, 18, '& waiting for approval'),
(71, 71, 18, 'Crop & Set as Cover Picture'),
(72, 72, 18, 'Page Not Found'),
(73, 73, 18, 'Back to Home Page'),
(74, 74, 18, 'We''re Sorry! The page you are looking for doesn''t seem to exist.'),
(75, 75, 18, 'Unable to Connect to facebook Now try again later'),
(76, 76, 18, 'Sorry Your Facebook account is not verified'),
(77, 77, 18, 'Sorry! Registration has Disabled'),
(78, 78, 18, 'Unable to insert Database please try again later'),
(79, 79, 18, 'Login'),
(80, 80, 18, 'Logout'),
(81, 81, 18, 'Administrator'),
(82, 82, 18, 'Profile'),
(83, 83, 18, 'account'),
(84, 84, 18, 'Random'),
(85, 85, 18, 'Rating'),
(86, 86, 18, 'Favourites'),
(87, 87, 18, 'Views'),
(88, 88, 18, 'Downloads'),
(89, 89, 18, 'Latest'),
(90, 90, 18, 'Wallpapers'),
(91, 91, 18, 'Categories'),
(92, 92, 18, 'Search'),
(93, 93, 18, 'Tags'),
(94, 94, 18, 'Contact'),
(95, 95, 18, 'Submit Wallpaper'),
(96, 96, 18, 'Upload'),
(97, 97, 18, 'info'),
(98, 98, 18, 'Name'),
(99, 99, 18, 'Created'),
(100, 100, 18, 'ago'),
(101, 101, 18, 'Last Login'),
(102, 102, 18, 'Email Confirmation'),
(103, 103, 18, 'Success'),
(104, 104, 18, 'Pending'),
(105, 105, 18, 'password'),
(106, 106, 18, 'Yes'),
(107, 107, 18, 'Sign Up'),
(108, 108, 18, 'Reported'),
(109, 109, 18, 'Awaiting Approval'),
(110, 110, 18, 'Contact US'),
(111, 111, 18, 'Close'),
(112, 112, 18, 'Disabled'),
(113, 113, 18, 'Not Approved'),
(114, 114, 18, 'Images not found'),
(115, 115, 18, 'Edit Image'),
(116, 116, 18, 'Delete Image'),
(117, 117, 18, 'Sort By'),
(118, 118, 18, 'All Times'),
(119, 119, 18, 'Today'),
(120, 120, 18, 'Last 7 Days'),
(121, 121, 18, 'Last 30 Days'),
(122, 122, 18, 'Last 60 Days'),
(123, 123, 18, 'All'),
(124, 124, 18, 'Select Category'),
(125, 125, 18, 'Select Time'),
(126, 126, 18, 'Select Sort'),
(127, 127, 18, 'Found'),
(128, 128, 18, 'Tag Title'),
(129, 129, 18, 'Tagged Images'),
(130, 130, 18, 'Popularity'),
(131, 131, 18, 'View'),
(132, 132, 18, 'Delete'),
(133, 133, 18, 'Image Name'),
(134, 134, 18, 'File'),
(135, 135, 18, 'URL'),
(136, 136, 18, 'Enable'),
(137, 137, 18, 'Disable'),
(138, 138, 18, 'Submit'),
(139, 139, 18, 'Previous'),
(140, 140, 18, 'Next'),
(141, 141, 18, 'Share It'),
(142, 142, 18, 'Edit'),
(143, 143, 18, 'Admin'),
(144, 144, 18, 'Category'),
(145, 145, 18, 'Added'),
(146, 146, 18, 'Author'),
(147, 147, 18, 'Total'),
(148, 148, 18, 'out of'),
(149, 149, 18, 'Download'),
(150, 150, 18, 'Yours'),
(151, 151, 18, 'Back'),
(152, 152, 18, 'Resolution'),
(153, 153, 18, 'Home'),
(154, 154, 18, 'Resolutions'),
(155, 155, 18, 'Subject'),
(156, 156, 18, 'Email'),
(157, 157, 18, 'Your New Password'),
(158, 158, 18, 'Thanks'),
(159, 159, 18, 'Sorry'),
(160, 160, 18, 'Message'),
(161, 161, 18, 'Captcha Code'),
(162, 162, 18, 'Featured Wallpapers'),
(163, 163, 18, 'Latest Wallpapers'),
(164, 164, 18, 'Global Resolution has set Successfully'),
(165, 165, 18, 'Global Resolution has removed Successfully'),
(166, 166, 18, 'Wallpaper Hash Does''t Exists'),
(167, 167, 18, 'Wallpaper Ratted Successfully'),
(168, 168, 18, 'Wallpaper has added to your Favourite'),
(169, 169, 18, 'Wallpaper has Removed from your your Favourite'),
(170, 170, 18, 'Your Msg'),
(171, 171, 18, 'Comment ID'),
(172, 172, 18, 'You have successfully reported to comment ID'),
(173, 173, 18, 'Redirecting to login Page'),
(174, 174, 18, 'Redirecting to Approve Image'),
(175, 175, 18, 'Wallpaper Not Found'),
(176, 176, 18, 'Cover has successfully uploaded to your profile'),
(177, 177, 18, 'Welcome Email/Activation'),
(178, 178, 18, 'Email already Activated'),
(179, 179, 18, 'Email Activated Successfully'),
(180, 180, 18, 'Invalid Activation Code'),
(181, 181, 18, 'Upload Image'),
(182, 182, 18, 'Edit Image'),
(183, 183, 18, 'Upload BY'),
(184, 184, 18, 'Insert Image URL'),
(185, 185, 18, 'Minimum Image Size Required'),
(186, 186, 18, 'No Minimum Size'),
(187, 187, 18, 'Select Category'),
(188, 188, 18, 'Tags'),
(189, 189, 18, 'Author Name'),
(190, 190, 18, 'Image Position'),
(191, 191, 18, 'Author URL'),
(192, 192, 18, 'Publish Status'),
(193, 193, 18, 'Optional Data'),
(194, 194, 18, 'Description'),
(195, 195, 18, 'Meta Title'),
(196, 196, 18, 'Meta Description'),
(197, 197, 18, 'Meta Keywords'),
(198, 198, 18, 'Save & Edit'),
(199, 199, 18, 'Save & New'),
(200, 200, 18, 'You Know you can Drag & Drop File Here'),
(201, 201, 18, 'Image Name'),
(202, 202, 18, 'Image Status'),
(203, 203, 18, 'Unable To Connect Server'),
(204, 204, 18, 'Invalid File Format accepts only JPEG or PNG'),
(205, 205, 18, 'Invalid Category ID: Selected Category ID is not exists'),
(206, 206, 18, 'Wallpaper Uploaded Successfully'),
(207, 207, 18, 'Invalid Wallpaper Hash ID'),
(208, 208, 18, 'Wallpaper Updated Successfully'),
(209, 209, 18, 'Image Removed Successfully'),
(210, 210, 18, 'Loading to Vote Up'),
(211, 211, 18, 'Please Login in order to Vote'),
(212, 212, 18, 'Loading to Vote Down'),
(213, 213, 18, 'Please Login to add this in Favorite list'),
(214, 214, 18, 'Loading - Adding this to your Favorites'),
(215, 215, 18, 'Loading - Removing this from your Favorites'),
(216, 216, 18, 'Make it has Cover Picture'),
(217, 217, 18, 'Sorry Your screen resolution is not available for this wallpaper.'),
(218, 218, 18, 'Available Resolutions'),
(219, 219, 18, 'Related Wallpapers'),
(220, 220, 18, 'Comments'),
(221, 221, 18, 'Report this comment id'),
(222, 222, 18, 'Load More'),
(223, 223, 18, 'to wallpaper'),
(224, 224, 18, 'Crop & Set as Cover Picture'),
(225, 225, 18, 'Facebook - Set as Cover Picture'),
(226, 226, 18, 'Click here to approve Cover'),
(227, 227, 18, 'Selected Resolution Should be lesser then the available Resolution'),
(228, 228, 18, 'Sorry Original Image Does\\''t Exists'),
(256, 1, 62, 'Account Avatar'),
(257, 2, 62, 'Profile Pic'),
(258, 3, 62, 'File Upload'),
(259, 4, 62, 'Minimum Size Required'),
(260, 5, 62, 'Account Profile'),
(261, 6, 62, 'My Profile Link'),
(262, 7, 62, 'User email address'),
(263, 8, 62, 'Enter the words above'),
(264, 9, 62, 'Enter the numbers you hear'),
(265, 10, 62, 'Incorrect please try again'),
(266, 11, 62, 'Remember me'),
(267, 12, 62, 'Sign In with Facebook'),
(268, 13, 62, 'Sign Up Here'),
(269, 14, 62, 'Forgotten Password'),
(270, 15, 62, 'Don''t have an account'),
(271, 16, 62, 'Reset Password'),
(272, 17, 62, 'Update Profile'),
(273, 18, 62, 'Full Name'),
(274, 19, 62, 'Others can see my stuff'),
(275, 20, 62, 'Old Password'),
(276, 21, 62, 'Re-type Password'),
(277, 22, 62, 'Update Password'),
(278, 23, 62, 'Account Settings'),
(279, 24, 62, 'User Full Name'),
(280, 25, 62, 'Sign In Here'),
(281, 26, 62, 'Do you have an account'),
(282, 27, 62, 'My Acount Details'),
(283, 28, 62, 'My Account'),
(284, 29, 62, 'My Wallpapers'),
(285, 30, 62, 'My Favorite''s'),
(286, 31, 62, 'Wallpaper''s I Like'),
(287, 32, 62, 'Wallpaper''s I Dislike'),
(288, 33, 62, 'My Downloads'),
(289, 34, 62, 'Update Avatar'),
(290, 35, 62, 'Your Name'),
(291, 36, 62, 'Your Email Address'),
(292, 37, 62, 'Your Subject'),
(293, 38, 62, 'Your Message'),
(294, 39, 62, 'Send Message'),
(295, 40, 62, 'Our office'),
(296, 41, 62, 'Your email'),
(297, 42, 62, 'Thank you for creating a'),
(298, 43, 62, 'Please Click below'),
(299, 44, 62, 'activation'),
(300, 45, 62, 'You''re all ready to go'),
(301, 46, 62, 'User Email'),
(302, 47, 62, 'Captcha Code'),
(303, 48, 62, 'New password has sent to your mail'),
(304, 49, 62, 'Email address Not exists in or database'),
(305, 50, 62, 'Activation Link'),
(306, 51, 62, 'Please Check your email We have Send you activation Code'),
(307, 52, 62, 'User Name'),
(308, 53, 62, 'User Password'),
(309, 54, 62, 'Invalid Old Password'),
(310, 55, 62, 'User Data Updated Successfully'),
(311, 56, 62, 'Profile Pic Updated Successfully'),
(312, 57, 62, 'Unable to Move File'),
(313, 58, 62, 'Sorry We need to Confirm your email address we have sent you activation code. If you have\\''nt received please'),
(314, 59, 62, 'Invalid Username/Password'),
(315, 60, 62, 'Registration has Disabled'),
(316, 61, 62, 'Account Created Successfully. Please check your Email we have dispatched activation link.'),
(317, 62, 62, 'Email Already Exists in database'),
(318, 63, 62, 'Author URL'),
(319, 64, 62, 'Html data is not allowed'),
(320, 65, 62, 'You Message has been Sent Successfully'),
(321, 66, 62, 'Guest Name'),
(322, 67, 62, 'Guest Email'),
(323, 68, 62, 'Comment Text'),
(324, 69, 62, 'Your Comment Has been Submitted'),
(325, 70, 62, '& waiting for approval'),
(326, 71, 62, 'Crop & Set as Cover Picture'),
(327, 72, 62, 'Page Not Found'),
(328, 73, 62, 'Back to Home Page'),
(329, 74, 62, 'We''re Sorry! The page you are looking for doesn''t seem to exist.'),
(330, 75, 62, 'Unable to Connect to facebook Now try again later'),
(331, 76, 62, 'Sorry Your Facebook account is not verified'),
(332, 77, 62, 'Sorry! Registration has Disabled'),
(333, 78, 62, 'Unable to insert Database please try again later'),
(334, 79, 62, 'Login'),
(335, 80, 62, 'Logout'),
(336, 81, 62, 'Administrator'),
(337, 82, 62, 'Profile'),
(338, 83, 62, 'account'),
(339, 84, 62, 'Random'),
(340, 85, 62, 'Rating'),
(341, 86, 62, 'Favourites'),
(342, 87, 62, 'Views'),
(343, 88, 62, 'Downloads'),
(344, 89, 62, 'Latest'),
(345, 90, 62, 'Wallpapers'),
(346, 91, 62, 'Categories'),
(347, 92, 62, 'Search'),
(348, 93, 62, 'Tags'),
(349, 94, 62, 'Contact'),
(350, 95, 62, 'Submit Wallpaper'),
(351, 96, 62, 'Upload'),
(352, 97, 62, 'info'),
(353, 98, 62, 'Name'),
(354, 99, 62, 'Created'),
(355, 100, 62, 'ago'),
(356, 101, 62, 'Last Login'),
(357, 102, 62, 'Email Confirmation'),
(358, 103, 62, 'Success'),
(359, 104, 62, 'Pending'),
(360, 105, 62, 'password'),
(361, 106, 62, 'Yes'),
(362, 107, 62, 'Sign Up'),
(363, 108, 62, 'Reported'),
(364, 109, 62, 'Awaiting Approval'),
(365, 110, 62, 'Contact US'),
(366, 111, 62, 'Close'),
(367, 112, 62, 'Disabled'),
(368, 113, 62, 'Not Approved'),
(369, 114, 62, 'Images not found'),
(370, 115, 62, 'Edit Image'),
(371, 116, 62, 'Delete Image'),
(372, 117, 62, 'Sort By'),
(373, 118, 62, 'All Times'),
(374, 119, 62, 'Today'),
(375, 120, 62, 'Last 7 Days'),
(376, 121, 62, 'Last 30 Days'),
(377, 122, 62, 'Last 60 Days'),
(378, 123, 62, 'All'),
(379, 124, 62, 'Select Category'),
(380, 125, 62, 'Select Time'),
(381, 126, 62, 'Select Sort'),
(382, 127, 62, 'Found'),
(383, 128, 62, 'Tag Title'),
(384, 129, 62, 'Tagged Images'),
(385, 130, 62, 'Popularity'),
(386, 131, 62, 'View'),
(387, 132, 62, 'Delete'),
(388, 133, 62, 'Image Name'),
(389, 134, 62, 'File'),
(390, 135, 62, 'URL'),
(391, 136, 62, 'Enable'),
(392, 137, 62, 'Disable'),
(393, 138, 62, 'Submit'),
(394, 139, 62, 'Previous'),
(395, 140, 62, 'Next'),
(396, 141, 62, 'Share It'),
(397, 142, 62, 'Edit'),
(398, 143, 62, 'Admin'),
(399, 144, 62, 'Category'),
(400, 145, 62, 'Added'),
(401, 146, 62, 'Author'),
(402, 147, 62, 'Total'),
(403, 148, 62, 'out of'),
(404, 149, 62, 'Download'),
(405, 150, 62, 'Yours'),
(406, 151, 62, 'Back'),
(407, 152, 62, 'Resolution'),
(408, 153, 62, 'Home'),
(409, 154, 62, 'Resolutions'),
(410, 155, 62, 'Subject'),
(411, 156, 62, 'Email'),
(412, 157, 62, 'Your New Password'),
(413, 158, 62, 'Thanks'),
(414, 159, 62, 'Sorry'),
(415, 160, 62, 'Message'),
(416, 161, 62, 'Captcha Code'),
(417, 162, 62, 'Featured Wallpapers'),
(418, 163, 62, 'Latest Wallpapers'),
(419, 164, 62, 'Global Resolution has set Successfully'),
(420, 165, 62, 'Global Resolution has removed Successfully'),
(421, 166, 62, 'Wallpaper Hash Does''t Exists'),
(422, 167, 62, 'Wallpaper Ratted Successfully'),
(423, 168, 62, 'Wallpaper has added to your Favourite'),
(424, 169, 62, 'Wallpaper has Removed from your your Favourite'),
(425, 170, 62, 'Your Msg'),
(426, 171, 62, 'Comment ID'),
(427, 172, 62, 'You have successfully reported to comment ID'),
(428, 173, 62, 'Redirecting to login Page'),
(429, 174, 62, 'Redirecting to Approve Image'),
(430, 175, 62, 'Wallpaper Not Found'),
(431, 176, 62, 'Cover has successfully uploaded to your profile'),
(432, 177, 62, 'Welcome Email/Activation'),
(433, 178, 62, 'Email already Activated'),
(434, 179, 62, 'Email Activated Successfully'),
(435, 180, 62, 'Invalid Activation Code'),
(436, 181, 62, 'Upload Image'),
(437, 182, 62, 'Edit Image'),
(438, 183, 62, 'Upload BY'),
(439, 184, 62, 'Insert Image URL'),
(440, 185, 62, 'Minimum Image Size Required'),
(441, 186, 62, 'No Minimum Size'),
(442, 187, 62, 'Select Category'),
(443, 188, 62, 'Tags'),
(444, 189, 62, 'Author Name'),
(445, 190, 62, 'Image Position'),
(446, 191, 62, 'Author URL'),
(447, 192, 62, 'Publish Status'),
(448, 193, 62, 'Optional Data'),
(449, 194, 62, 'Description'),
(450, 195, 62, 'Meta Title'),
(451, 196, 62, 'Meta Description'),
(452, 197, 62, 'Meta Keywords'),
(453, 198, 62, 'Save & Edit'),
(454, 199, 62, 'Save & New'),
(455, 200, 62, 'You Know you can Drag & Drop File Here'),
(456, 201, 62, 'Image Name'),
(457, 202, 62, 'Image Status'),
(458, 203, 62, 'Unable To Connect Server'),
(459, 204, 62, 'Invalid File Format accepts only JPEG or PNG'),
(460, 205, 62, 'Invalid Category ID: Selected Category ID is not exists'),
(461, 206, 62, 'Wallpaper Uploaded Successfully'),
(462, 207, 62, 'Invalid Wallpaper Hash ID'),
(463, 208, 62, 'Wallpaper Updated Successfully'),
(464, 209, 62, 'Image Removed Successfully'),
(465, 210, 62, 'Loading to Vote Up'),
(466, 211, 62, 'Please Login in order to Vote'),
(467, 212, 62, 'Loading to Vote Down'),
(468, 213, 62, 'Please Login to add this in Favorite list'),
(469, 214, 62, 'Loading - Adding this to your Favorites'),
(470, 215, 62, 'Loading - Removing this from your Favorites'),
(471, 216, 62, 'Make it has Cover Picture'),
(472, 217, 62, 'Sorry Your screen resolution is not available for this wallpaper.'),
(473, 218, 62, 'Available Resolutions'),
(474, 219, 62, 'Related Wallpapers'),
(475, 220, 62, 'Comments'),
(476, 221, 62, 'Report this comment id'),
(477, 222, 62, 'Load More'),
(478, 223, 62, 'to wallpaper'),
(479, 224, 62, 'Crop & Set as Cover Picture'),
(480, 225, 62, 'Facebook - Set as Cover Picture'),
(481, 226, 62, 'Click here to approve Cover'),
(482, 227, 62, 'Selected Resolution Should be lesser then the available Resolution'),
(483, 228, 62, 'Sorry Original Image Does\\''t Exists');
-- --------------------------------------------------------
--
-- Table structure for table `ws_metadata`
--
CREATE TABLE IF NOT EXISTS `ws_metadata` (
`metadata_seq_id` int(11) NOT NULL,
`meta_data_key` varchar(70) DEFAULT NULL,
`lg_seq_id` int(11) DEFAULT NULL,
`meta_data_group` varchar(45) DEFAULT NULL,
`default_value` mediumtext NOT NULL,
`meta_data_keyInfo` text
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_metadata`
--
INSERT INTO `ws_metadata` (`metadata_seq_id`, `meta_data_key`, `lg_seq_id`, `meta_data_group`, `default_value`, `meta_data_keyInfo`) VALUES
(1, '_home_index_title', 2, 'home', 'Home Page Title', 'Put your main keyword term into your Home Page Title Tag'),
(2, '_home_index_description', 2, 'home', 'Home Page Description', 'Home Page Description'),
(3, '_home_index_keywords', 2, 'home', 'Home Page Keywords', 'Home Page Keywords'),
(4, '_error_404_index_title', 2, '404_error', '404 Page Not Found', NULL),
(5, '_error_404_description', 2, '404_error', '', NULL),
(6, '_error_404_index_keywords', 2, '404_error', '', NULL),
(7, '_account_login_title', 2, 'account', 'Account Login', 'Account Login Page Title'),
(8, '_account_login_description', 2, 'account', '', NULL),
(9, '_account_login_keywords', 2, 'account', '', NULL),
(10, '_account_signUp_title', 2, 'account', 'Account Signup', 'Account Signup Page Title'),
(11, '_account_signUp_description', 2, 'account', '', NULL),
(12, '_account_signUp_keywords', 2, 'account', '', NULL),
(13, '_account_index_title', 2, 'account', 'Account Profile', 'Account Profile Page Title'),
(14, '_account_index_description', 2, 'account', '', NULL),
(15, '_account_index_keywords', 2, 'account', '', NULL),
(16, '_account_settings_title', 2, 'account', 'Account Settings', 'Account Settings Page Title'),
(17, '_account_settings_description', 2, 'account', '', NULL),
(18, '_account_settings_keywords', 2, 'account', '', NULL),
(19, '_account_avatar_title', 2, 'account', 'Account Profile Picture', 'Account Avatar Page Title'),
(20, '_account_avatar_description', 2, 'account', '', NULL),
(21, '_account_avatar_keywords', 2, 'account', '', NULL),
(22, '_wallpaper_index_title', 2, 'wallpaper_page', '{WALL_NAME} - Wallpaper', 'Single Wallpaper Page Title: Variable Supports <code>{WALL_NAME} = Wallpaper Name</code> <code>{WALL_CAT_NAME} = Wallpaper Category Name</code>'),
(23, '_wallpaper_index_description', 2, 'wallpaper_page', '', ''),
(62, '_account_reset_title', 2, 'account', 'Reset Account Password', NULL),
(63, '_account_reset_description', 2, 'account', '', NULL),
(64, '_account_reset_keywords', 2, 'account', '', NULL),
(24, '_wallpaper_index_keywords', 2, 'wallpaper_page', '', ''),
(25, '_category_index_title', 2, 'category_page', '{CAT_NAME} {CAT_PARENTS}[ - ][][>]', 'Category Page Title: Variable Supports\n<code>{CAT_NAME}</code> = Category Name,\n<code>{CAT_PARENTS}[][][]</code> = Category Parents names,\n<br>\n<code>[][][] what is this?</code>\nIt is a parameter to pass values but only if the variable exists..\n<br/>\n1st [ ] = ''Prefix'' <br/>\n2nd [ ] = ''Sufix'' <br/>\n3rd [ ] = ''Seperator'' <br/> suppose if the default output is coming like this. "Xbox > Games" you can change the separator by passing through the 3rd parameter. Demo\n<code>"{CAT_NAME} {CAT_PARENTS}[ - ][ - ][ | ] Wallpapers"</code> Output Will Be now <code>"Xbox One - Xbox | Games - Wallpapers"</code>'),
(26, '_category_index_description', 2, 'category_page', '', 'Check "_category_index_title" Help'),
(27, '_category_index_keywords', 2, 'category_page', '', 'Check "_category_index_title" Help'),
(28, '_wallpaper_preview_title', 2, 'wallpaper_page', '{WALL_NAME} - {R_WIDTH} x {R_HEIGHT} Preview Wallpaper', 'Single Wallpaper Preview Page Title: Variable Supports <code>{WALL_NAME}</code> = Wallpaper Name, <code>{WALL_CAT_NAME}</code> = Wallpaper Category Name, <code>{R_WIDTH}</code> = Resolution Width, <code>{R_HEIGHT}</code> = Resolution Height'),
(29, '_wallpaper_preview_description', 2, 'wallpaper_page', '', NULL),
(30, '_wallpaper_preview_keywords', 2, 'wallpaper_page', '', NULL),
(31, '_category_index_home_title', 2, 'category_page', 'Categories', NULL),
(32, '_category_index_home_description', 2, 'category_page', '', NULL),
(33, '_category_index_home_keywords', 2, 'category_page', '', NULL),
(34, '_search_index_title', 2, 'search_page', 'Search - {keyword}', '<code>{keyword}</code> = Input keyword'),
(35, '_global_page_no', 2, 'others', ' Page - {page}', '<code>{page}</code> = Page Number'),
(36, '_search_index_description', 2, 'search_page', '', NULL),
(37, '_search_index_keywords', 2, 'search_page', '', NULL),
(38, '_wallpapers_page_title', 2, 'wallpapers_page', '{type} - wallpapers', '<code>{type}</code> Example: latest or downloads etc'),
(39, '_wallpapers_page_description', 2, 'wallpapers_page', '', NULL),
(40, '_wallpapers_page_keywords', 2, 'wallpapers_page', '', NULL),
(41, '_resolution_page_title', 2, 'resolutions_page', '{width} x {height} - wallpapers', '<code>{width}</code> = Width of the resolution, <code>{height}</code> = Height of the resolution, <code>{resolution_name}</code> = Name of the resolution'),
(42, '_resolution_page_description', 2, 'resolutions_page', '', NULL),
(43, '_resolution_page_keywords', 2, 'resolutions_page', '', NULL),
(44, '_tag_index_title', 2, 'tags_page', 'Tags', NULL),
(45, '_tag_index_description', 2, 'tags_page', '', NULL),
(46, '_tag_index_keywords', 2, 'tags_page', '', NULL),
(47, '_tags_view_title', 2, 'tags_page', 'Tags - {tag}', '<code>{tag}</code> = Selected Tag Name'),
(48, '_tags_view_description', 2, 'tags_page', '', NULL),
(49, '_tags_view_keywords', 2, 'tags_page', '', NULL),
(50, '_account_wallpapers_title', 2, 'account', 'Account My-{type} Wallpapers', '<code>{type}</code> Eaxmple: Uploaded,Downloaded,Liked Etc'),
(51, '_account_wallpapers_description', 2, 'account', '', NULL),
(52, '_account_wallpapers_keywords', 2, 'account', '', NULL),
(53, '_contact_page_title', 2, 'contact', 'Contact US', NULL),
(54, '_contact_page_description', 2, 'contact', '', NULL),
(55, '_contact_page_keywords', 2, 'contact', '', NULL),
(56, '_upload_page_title', 2, 'upload_page', 'Upload Image', NULL),
(57, '_upload_page_description', 2, 'upload_page', '', NULL),
(58, '_upload_page_keyword', 2, 'upload_page', '', NULL),
(59, '_wallpapers_page_facebook_title', 2, 'wallpaper_page', '{WALL_NAME} - Facebook Cover', 'Single Wallpaper Page Title: Variable Supports <code>{WALL_NAME} = Wallpaper Name</code> <code>{WALL_CAT_NAME} = Wallpaper Category Name</code>'),
(60, '_wallpapers_page_facebook_description', 2, 'wallpaper_page', '', NULL),
(61, '_wallpapers_page_facebook_keywords', 2, 'wallpaper_page', '', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `ws_metadata_values`
--
CREATE TABLE IF NOT EXISTS `ws_metadata_values` (
`metadata_value_seq_id` int(11) NOT NULL,
`metadata_seq_id` int(11) DEFAULT NULL,
`language_seq_id` int(11) DEFAULT NULL,
`metadata_value` text CHARACTER SET utf8
) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ws_metadata_values`
--
INSERT INTO `ws_metadata_values` (`metadata_value_seq_id`, `metadata_seq_id`, `language_seq_id`, `metadata_value`) VALUES
(1, 1, 18, 'Home Page Title'),
(2, 2, 18, 'Home Page Description'),
(3, 3, 18, 'Home Page Keywords'),
(4, 4, 18, '404 Page Not Found'),
(5, 5, 18, ''),
(6, 6, 18, ''),
(7, 7, 18, 'Account Login'),
(8, 8, 18, ''),
(9, 9, 18, ''),
(10, 10, 18, 'Account Signup'),
(11, 11, 18, ''),
(12, 12, 18, ''),
(13, 13, 18, 'Account Profile'),
(14, 14, 18, ''),
(15, 15, 18, ''),
(16, 16, 18, 'Account Settings'),
(17, 17, 18, ''),
(18, 18, 18, ''),
(19, 19, 18, 'Account Profile Picture'),
(20, 20, 18, ''),
(21, 21, 18, ''),
(22, 22, 18, '{WALL_NAME} - Wallpaper'),
(23, 23, 18, ''),
(24, 24, 18, ''),
(25, 25, 18, '{CAT_NAME} {CAT_PARENTS}[ - ][][>]'),
(26, 26, 18, ''),
(27, 27, 18, ''),
(28, 28, 18, '{WALL_NAME} - {R_WIDTH} x {R_HEIGHT} Preview Wallpaper'),
(29, 29, 18, ''),
(30, 30, 18, ''),
(31, 31, 18, 'Categories'),
(32, 32, 18, ''),
(33, 33, 18, ''),
(34, 34, 18, 'Search - {keyword}'),
(35, 35, 18, ' Page - {page}'),
(36, 36, 18, ''),
(37, 37, 18, ''),
(38, 38, 18, '{type} - wallpapers'),
(39, 39, 18, ''),
(40, 40, 18, ''),
(41, 41, 18, '{width} x {height} - wallpapers'),
(42, 42, 18, ''),
(43, 43, 18, ''),
(44, 44, 18, 'Tags'),
(45, 45, 18, ''),
(46, 46, 18, ''),
(47, 47, 18, 'Tags - {tag}'),
(48, 48, 18, ''),
(49, 49, 18, ''),
(50, 50, 18, 'Account My-{type} Wallpapers'),
(51, 51, 18, ''),
(52, 52, 18, ''),
(53, 53, 18, 'Contact US'),
(54, 54, 18, ''),
(55, 55, 18, ''),
(56, 56, 18, 'Upload Image'),
(57, 57, 18, ''),
(58, 58, 18, ''),
(59, 59, 18, '{WALL_NAME} - Facebook Cover'),
(60, 60, 18, ''),
(61, 61, 18, ''),
(62, 1, 62, 'Home Page Title'),
(63, 2, 62, 'Home Page Description'),
(64, 3, 62, 'Home Page Keywords'),
(65, 4, 62, '404 Page Not Found'),
(66, 5, 62, ''),
(67, 6, 62, ''),
(68, 7, 62, 'Account Login'),
(69, 8, 62, ''),
(70, 9, 62, ''),
(71, 10, 62, 'Account Signup'),
(72, 11, 62, ''),
(73, 12, 62, ''),
(74, 13, 62, 'Account Profile'),
(75, 14, 62, ''),
(76, 15, 62, ''),
(77, 16, 62, 'Account Settings'),
(78, 17, 62, ''),
(79, 18, 62, ''),
(80, 19, 62, 'Account Profile Picture'),
(81, 20, 62, ''),
(82, 21, 62, ''),
(83, 22, 62, '{WALL_NAME} - Wallpaper'),
(84, 23, 62, ''),
(85, 62, 62, 'Reset Account Password'),
(86, 63, 62, ''),
(87, 64, 62, ''),
(88, 24, 62, ''),
(89, 25, 62, '{CAT_NAME} {CAT_PARENTS}[ - ][][>]'),
(90, 26, 62, ''),
(91, 27, 62, ''),
(92, 28, 62, '{WALL_NAME} - {R_WIDTH} x {R_HEIGHT} Preview Wallpaper'),
(93, 29, 62, ''),
(94, 30, 62, ''),
(95, 31, 62, 'Categories'),
(96, 32, 62, ''),
(97, 33, 62, ''),
(98, 34, 62, 'Search - {keyword}'),
(99, 35, 62, ' Page - {page}'),
(100, 36, 62, ''),
(101, 37, 62, ''),
(102, 38, 62, '{type} - wallpapers'),
(103, 39, 62, ''),
(104, 40, 62, ''),
(105, 41, 62, '{width} x {height} - wallpapers'),
(106, 42, 62, ''),
(107, 43, 62, ''),
(108, 44, 62, 'Tags'),
(109, 45, 62, ''),
(110, 46, 62, ''),
(111, 47, 62, 'Tags - {tag}'),
(112, 48, 62, ''),
(113, 49, 62, ''),
(114, 50, 62, 'Account My-{type} Wallpapers'),
(115, 51, 62, ''),
(116, 52, 62, ''),
(117, 53, 62, 'Contact US'),
(118, 54, 62, ''),
(119, 55, 62, ''),
(120, 56, 62, 'Upload Image'),
(121, 57, 62, ''),
(122, 58, 62, ''),
(123, 59, 62, '{WALL_NAME} - Facebook Cover'),
(124, 60, 62, ''),
(125, 61, 62, '');
-- --------------------------------------------------------
--
-- Table structure for table `ws_resolutions`
--
CREATE TABLE IF NOT EXISTS `ws_resolutions` (
`resolution_seq_id` int(11) NOT NULL,
`resolution_name` varchar(150) DEFAULT NULL,
`resolution_group_seq_id` int(11) DEFAULT NULL,
`resolution_width` int(11) DEFAULT NULL,
`resolution_height` int(11) DEFAULT NULL,
`resolution_status` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_resolutions`
--
INSERT INTO `ws_resolutions` (`resolution_seq_id`, `resolution_name`, `resolution_group_seq_id`, `resolution_width`, `resolution_height`, `resolution_status`) VALUES
(1, '3800 x 600', 1, 3800, 600, 1),
(2, '1024 x 768', 1, 1024, 768, 1),
(3, '1152 x 864', 1, 1152, 864, 1),
(4, '1280 x 960', 1, 1280, 960, 1),
(5, '1400 x 1050', 1, 1400, 1050, 1),
(6, '1440 x 1080', 1, 1440, 1080, 1),
(7, '1600 x 1200', 1, 1600, 1200, 1),
(8, '1680 x 1260', 1, 1680, 1260, 1),
(9, '1920 x 1440', 1, 1920, 1440, 1),
(10, '2048 x 1536', 1, 2048, 1536, 1),
(11, '2560 x 1920', 1, 2560, 1920, 1),
(12, '2800 x 2100', 1, 2800, 2100, 1),
(13, '3200 x 2400', 1, 3200, 2400, 1),
(14, '4096 x 3072', 1, 4096, 3072, 1),
(15, '1280 x 1024', 2, 1280, 1024, 1),
(16, '2560 x 2048', 2, 2560, 2048, 1),
(17, '3750 x 3000', 2, 3750, 3000, 1),
(18, '960 x 600', 3, 960, 600, 1),
(19, '1152 x 720', 3, 1152, 720, 1),
(20, '1280 x 800', 3, 1280, 800, 1),
(21, '1440 x 900', 3, 1440, 900, 1),
(22, '1680 x 1050', 3, 1680, 1050, 1),
(23, '1920 x 1200', 3, 1920, 1200, 1),
(24, '2560 x 1600', 3, 2560, 1600, 1),
(25, '2880 x 1800', 3, 2880, 1800, 1),
(26, '3840 x 2400', 3, 3840, 2400, 1),
(27, '5120 x 3200', 3, 5120, 3200, 1),
(28, '800 x 480', 4, 800, 480, 1),
(29, '1280 x 768', 4, 1280, 768, 1),
(30, '960 x 540', 5, 960, 540, 1),
(31, '1024 x 576', 5, 1024, 576, 1),
(32, '1280 x 720', 5, 1280, 720, 1),
(33, '1366 x 768', 5, 1366, 768, 1),
(34, '1600 x 900', 5, 1600, 900, 1),
(35, '1920 x 1080', 5, 1920, 1080, 1),
(36, '2048 x 1152', 5, 2048, 1152, 1),
(37, '2400 x 1350', 5, 2400, 1350, 1),
(38, '2560 x 1440', 5, 2560, 1440, 1),
(39, '2880 x 1620', 5, 2880, 1620, 1),
(40, '3554 x 1999', 5, 3554, 1999, 1),
(41, '3840 x 2160', 5, 3840, 2160, 1),
(42, '1152 x 768', 6, 1152, 768, 1),
(43, '1440 x 960', 6, 1440, 960, 1),
(44, '2000 x 1333', 6, 2000, 1333, 1),
(45, '240 x 320', 7, 240, 320, 1),
(46, '480 x 640', 7, 480, 640, 1),
(47, '320 x 240', 7, 320, 240, 1),
(48, '640 x 480', 7, 640, 480, 1),
(49, '240 x 400', 8, 240, 400, 1),
(50, '480 x 800', 8, 480, 800, 1),
(51, '400 x 240', 8, 400, 240, 1),
(52, '800 x 480', 8, 800, 480, 1),
(53, '320 x 480', 9, 320, 480, 1),
(54, '480 x 320', 9, 480, 320, 1),
(55, '640 x 960', 9, 640, 960, 1),
(56, '960 x 640', 9, 960, 640, 1);
-- --------------------------------------------------------
--
-- Table structure for table `ws_resolutions_groups`
--
CREATE TABLE IF NOT EXISTS `ws_resolutions_groups` (
`resolution_group_seq_id` int(11) NOT NULL,
`resolution_group_name` varchar(150) DEFAULT NULL,
`resolution_group_status` int(11) DEFAULT NULL,
`resolution_group_sort` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_resolutions_groups`
--
INSERT INTO `ws_resolutions_groups` (`resolution_group_seq_id`, `resolution_group_name`, `resolution_group_status`, `resolution_group_sort`) VALUES
(1, 'Standard 4:3', 1, 1),
(2, 'Standard 5:4', 1, 2),
(3, 'Wide 16:10', 1, 3),
(4, 'Wide 5:3', 1, 4),
(5, 'HD 16:9', 1, 5),
(6, 'DSLR 3:2', 1, 6),
(7, 'Mobile VGA', 1, 7),
(8, 'Mobile WVGA', 1, 8),
(9, 'Mobile iPhone', 1, 9);
-- --------------------------------------------------------
--
-- Table structure for table `ws_routes`
--
CREATE TABLE IF NOT EXISTS `ws_routes` (
`route_seq_id` int(11) NOT NULL,
`route_name` varchar(255) DEFAULT NULL,
`route_controller` varchar(255) DEFAULT NULL,
`route_default_key` varchar(255) DEFAULT NULL,
`route_default_value` varchar(255) DEFAULT NULL,
`route_default_url_structure` varchar(255) DEFAULT NULL,
`route_url_help` varchar(255) DEFAULT NULL,
`route_help` mediumtext,
`lg_seq_id` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_routes`
--
INSERT INTO `ws_routes` (`route_seq_id`, `route_name`, `route_controller`, `route_default_key`, `route_default_value`, `route_default_url_structure`, `route_url_help`, `route_help`, `lg_seq_id`) VALUES
(1, 'wallpaper_page', 'wallpaper_private/index/', 'wallpaper/(:all)/(:any)/(:any)', '$1/$2/$3', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}', '<code>{C_SLUG_FULL}</code> = Category Full Slug ,<code>{C_SLUG}</code> = Category Slug, <code>{W_SLUG}</code> = Wallpaper Slug , <code>{W_HASH}</code> = Wallpaper HASH', '1st Slash is Category Full Slug, 2st Slash is Wallpaper Slug, 3rd Slash is Wallpaper Hash ID', 2),
(2, 'category_page', 'category_private/selected/', 'category/(:all)', '$1', 'category/{C_SLUG_FULL}', '<code>{C_SLUG_FULL}</code> = Category Full SLUG', '1st Slash is Category Full Slug', 2),
(3, 'wallpaper_preview', 'wallpaper_private/preview/', 'wallpaper/(:all)/(:any)/(:any)/(:num)/(:num)', '$1/$2/$3/$4/$5', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}/{R_WIDTH}/{R_HEIGHT}', '<code>{C_SLUG_FULL}</code> = Category Full Slug , <code>{W_SLUG}</code> = Wallpaper Slug , <code>{W_HASH}</code> = Wallpaper HASH ,<code>{R_WIDTH}</code> = Resolution Width, <code>{R_HEIGHT}</code> = Resolution Height', '1st Slash is Category Full Slug, 2st Slash is Wallpaper Slug, 3rd Slash is Wallpaper Hash ID, 4th Slash is Width, 5th is Height', 2),
(4, 'account_logout', 'account_private/logout/', 'account/logout', NULL, 'account/logout', 'None: Logout Url', '', 2),
(5, 'account_login', 'account_private/login/', 'account/login', NULL, 'account/login', 'None: LogIn Url', NULL, 2),
(6, 'account_signup', 'account_private/signup/', 'account/signup', NULL, 'account/signup', 'None: Signup Url', NULL, 2),
(7, 'account_facebook', 'account_private/facebook/', 'account/facebook', NULL, 'account/facebook', 'None: Login/Signup through Facebook', NULL, 2),
(8, 'account_index', 'account_private/index/', 'account', NULL, 'account', 'None: Profile Page', NULL, 2),
(9, 'account_settings', 'account_private/settings/', 'account/settings', NULL, 'account/settings', 'None: Account Settings Page', NULL, 2),
(10, 'upload_wallpaper', 'upload_private/index/', 'upload', NULL, 'upload', 'None: Users Upload Wallpaper Page', NULL, 2),
(11, 'account_avatar', 'account_private/avatar', 'account/avatar', NULL, 'account/avatar', 'Account Profile Picture Page', NULL, 2),
(12, 'wallpapers_page', 'wallpapers_private/index/', 'wallpapers', NULL, 'wallpapers', 'Wallpapers Page', NULL, 2),
(13, 'wallpapers_latest_page', 'wallpapers_private/index/', 'wallpapers/latest', 'latest', 'wallpapers/latest', 'Wallpapers by Latest Page', 'Fixed Value Dont change', 2),
(14, 'wallpaper_preview_download', 'wallpaper_private/preview/', 'wallpaper/(:all)/(:any)/(:any)/(:num)/(:num)/download', '$1/$2/$3/$4/$5/download', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}/{R_WIDTH}/{R_HEIGHT}/download', '<code>{C_SLUG_FULL}</code> = Category Full Slug , <code>{W_SLUG}</code> = Wallpaper Slug , <code>{W_HASH}</code> = Wallpaper HASH ,<code>{R_WIDTH}</code> = Resolution Width, <code>{R_HEIGHT}</code> = Resolution Height', '1st Slash is Category Full Slug, 2st Slash is Wallpaper Slug, 3rd Slash is Wallpaper Hash ID, 4th Slash is Width, 5th is Height', 2),
(15, 'category_page_index', 'category_private/index/', 'category', NULL, 'category', 'All Categories View', NULL, 2),
(16, 'search_page', 'search_private/index/', 'search', NULL, 'search', 'Search Page', NULL, 2),
(17, 'wallpapers_downloads_page', 'wallpapers_private/index/', 'wallpapers/download', 'downloads', 'wallpapers/download', 'Wallpapers by Downloads Page', 'Fixed Value Dont change', 2),
(18, 'wallpapers_views_page', 'wallpapers_private/index/', 'wallpapers/view', 'views', 'wallpapers/view', 'Wallpapers by view Page', 'Fixed Value Dont change', 2),
(19, 'wallpapers_favourites_page', 'wallpapers_private/index/', 'wallpapers/favourite', 'favourites', 'wallpapers/favourite', 'Wallpapers by Favourites Page', 'Fixed Value Dont change', 2),
(20, 'wallpapers_rating_page', 'wallpapers_private/index/', 'wallpapers/rating', 'rating', 'wallpapers/rating', 'Wallpapers by Rating Page', 'Fixed Value Dont change', 2),
(21, 'resolutions_page', 'resolutions_private/index/', 'resolution/(:num)/(:num)', '$1/$2', 'resolution/{width}/{height}', 'Resolution Page', NULL, 2),
(22, 'tags_index_page', 'tags_private/index/', 'tags', '', 'tags', 'Tags Index Page', NULL, 2),
(23, 'tags_view_page', 'tags_private/get/', 'tags/(:any)', '$1', 'tags/{tag}', 'Tags View Page', NULL, 2),
(24, 'account_mywallpapers', 'account_private/wallpapers/', 'account/wallpapers', 'uploaded', 'account/wallpapers', 'User Uploaded Wallpapers', 'Fixed Value Dont change', 2),
(25, 'account_myfavourites', 'account_private/wallpapers/', 'account/favourites', 'favourites', 'account/favourites', 'User favourites Wallpapers', 'Fixed Value Dont change', 2),
(26, 'account_mylike', 'account_private/wallpapers/', 'account/likes', 'likes', 'account/likes', 'User Liked Wallpapers', 'Fixed Value Dont change', 2),
(27, 'account_mydislike', 'account_private/wallpapers/', 'account/dislikes', 'dislikes', 'account/dislikes', 'User Dis-Liked Wallpapers', 'Fixed Value Dont change', 2),
(28, 'account_mydownloads', 'account_private/wallpapers/', 'account/downloads', 'downloads', 'account/downloads', 'User Downloaded Wallpapers', 'Fixed Value Dont change', 2),
(30, 'wallpapers_random_page', 'wallpapers_private/index/', 'wallpapers/random', 'random', 'wallpapers/random', 'Wallpapers by random', NULL, 2),
(31, 'contact_page', 'contact_private/index/', 'contact', NULL, 'contact', 'Contact Page', NULL, 2),
(32, 'wallpapers_page_cover_facebook', 'wallpaper_private/cover/', 'wallpaper/(:all)/(:any)/(:any)/cover/facebook', '$1/$2/$3/facebook', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}/cover/facebook', '<code>{C_SLUG_FULL}</code> = Category Full Slug ,<code>{C_SLUG}</code> = Category Slug, <code>{W_SLUG}</code> = Wallpaper Slug , <code>{W_HASH}</code> = Wallpaper HASH', '1st Slash is Category Full Slug, 2st Slash is Wallpaper Slug, 3rd Slash is Wallpaper Hash ID', 2),
(33, 'upload_wallpaper_edit', 'upload_private/edit/', 'upload/edit/(:any)', '$1', 'upload/edit/{hash}', '<code>{hash}</code> = Hash id of the wallpaper', NULL, 2),
(34, 'upload_wallpaper_delete', 'upload_private/delete/', 'upload/delete/(:any)', '$1', 'upload/delete/{hash}', '<code>{hash}</code> = Hash id of the wallpaper', NULL, 2),
(35, 'account_verify', 'account_private/verify/', 'account/verify', NULL, 'account/verify', 'Email Vefification URL', NULL, 2),
(36, 'account_resend_activation', 'account_private/resend_activation/', 'account/resend-activation', NULL, 'account/resend-activation', 'Resend Activation Email', NULL, 2),
(37, 'account_forgot_password', 'account_private/forgotten_password/', 'account/reset-password', NULL, 'account/reset-password', 'Reset Account Password', NULL, 2);
-- --------------------------------------------------------
--
-- Table structure for table `ws_routes_values`
--
CREATE TABLE IF NOT EXISTS `ws_routes_values` (
`rv_seq_id` int(255) NOT NULL,
`route_seq_id` int(11) DEFAULT NULL,
`language_seq_id` int(11) DEFAULT NULL,
`route_key` varchar(255) DEFAULT NULL,
`route_value` varchar(255) DEFAULT NULL,
`route_url_struture` varchar(255) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_routes_values`
--
INSERT INTO `ws_routes_values` (`rv_seq_id`, `route_seq_id`, `language_seq_id`, `route_key`, `route_value`, `route_url_struture`) VALUES
(1, 1, 18, 'wallpaper/(:all)/(:any)/(:any)', '$1/$2/$3', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}'),
(2, 2, 18, 'category/(:all)', '$1', 'category/{C_SLUG_FULL}'),
(3, 3, 18, 'wallpaper/(:all)/(:any)/(:any)/(:num)/(:num)', '$1/$2/$3/$4/$5', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}/{R_WIDTH}/{R_HEIGHT}'),
(4, 4, 18, 'account/logout', '', 'account/logout'),
(5, 5, 18, 'account/login', '', 'account/login'),
(6, 6, 18, 'account/signup', '', 'account/signup'),
(7, 7, 18, 'account/facebook', '', 'account/facebook'),
(8, 8, 18, 'account', '', 'account'),
(9, 9, 18, 'account/settings', '', 'account/settings'),
(10, 10, 18, 'upload', '', 'upload'),
(11, 11, 18, 'account/avatar', '', 'account/avatar'),
(12, 12, 18, 'wallpapers', '', 'wallpapers'),
(13, 13, 18, 'wallpapers/latest', 'latest', 'wallpapers/latest'),
(14, 14, 18, 'wallpaper/(:all)/(:any)/(:any)/(:num)/(:num)/download', '$1/$2/$3/$4/$5/download', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}/{R_WIDTH}/{R_HEIGHT}/download'),
(15, 15, 18, 'category', '', 'category'),
(16, 16, 18, 'search', '', 'search'),
(17, 17, 18, 'wallpapers/download', 'downloads', 'wallpapers/download'),
(18, 18, 18, 'wallpapers/view', 'views', 'wallpapers/view'),
(19, 19, 18, 'wallpapers/favourite', 'favourites', 'wallpapers/favourite'),
(20, 20, 18, 'wallpapers/rating', 'rating', 'wallpapers/rating'),
(21, 21, 18, 'resolution/(:num)/(:num)', '$1/$2', 'resolution/{width}/{height}'),
(22, 22, 18, 'tags', '', 'tags'),
(23, 23, 18, 'tags/(:any)', '$1', 'tags/{tag}'),
(24, 24, 18, 'account/wallpapers', 'uploaded', 'account/wallpapers'),
(25, 25, 18, 'account/favourites', 'favourites', 'account/favourites'),
(26, 26, 18, 'account/likes', 'likes', 'account/likes'),
(27, 27, 18, 'account/dislikes', 'dislikes', 'account/dislikes'),
(28, 28, 18, 'account/downloads', 'downloads', 'account/downloads'),
(29, 30, 18, 'wallpapers/random', 'random', 'wallpapers/random'),
(30, 31, 18, 'contact', '', 'contact'),
(31, 32, 18, 'wallpaper/(:all)/(:any)/(:any)/cover/facebook', '$1/$2/$3/facebook', 'wallpaper/{C_SLUG_FULL}/{W_SLUG}/{W_HASH}/cover/facebook'),
(32, 33, 18, 'upload/edit/(:any)', '$1', 'upload/edit/{hash}'),
(33, 34, 18, 'upload/delete/(:any)', '$1', 'upload/delete/{hash}'),
(34, 35, 18, 'account/verify', '', 'account/verify'),
(35, 36, 18, 'account/resend_activation', '', 'account/resend_activation'),
(36, 37, 18, 'account/reset-password', '', 'account/reset-password');
-- --------------------------------------------------------
--
-- Table structure for table `ws_setting`
--
CREATE TABLE IF NOT EXISTS `ws_setting` (
`setting_seq_id` int(11) NOT NULL,
`setting_key` varchar(45) DEFAULT NULL,
`setting_value` text,
`setting_private` int(11) DEFAULT '0',
`input_type` varchar(45) DEFAULT NULL,
`helpblock` mediumtext
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_setting`
--
INSERT INTO `ws_setting` (`setting_seq_id`, `setting_key`, `setting_value`, `setting_private`, `input_type`, `helpblock`) VALUES
(1, 'encryption_key', 'e6e6a831521ef36dafbf8695a7448c6e6dc4c50921e72fe80822954e8c', 1, 'text', 'Private Session Encryption Key. Don''t Change the key unless the first time.'),
(2, 'frontendTheme', 'default', 1, 'private', 'Default Frontend Theme'),
(4, 'site_name', 'Phpwscript.com', 0, 'text', 'Example: Page Title - Site Name'),
(6, 'hashIDSession_key', '60cd04e21e1b38bc41b843c85e18cb750fef67399810700ff341e5486b', 0, 'text', 'HashId key used to Encrypt Login Session ID. Suggested to change key atleast twice a month. <span class="keyGenerate" data-id="hashIDSession_key"><i class="fa fa-refresh"></i> Generate</span>'),
(7, 'admin_email', 'admin@domain.com', 0, 'text', 'Comma Seperate for Multiple ID'),
(8, 'items_per_page', '21', 0, 'number', 'Wallpapers Per Page'),
(9, 'tracking_code', '', 0, 'textarea', 'Your Tracking Codes. If the code is javascript code.. You have to include javascript tag <code><script>....</script></code>'),
(10, 'enable_captcha', 'TRUE', 0, 'checkbox', 'Display Human Verification Code on Frontend form Submission.'),
(11, 'disable_registration', 'TRUE', 0, 'checkbox', 'Disable Registering new users to site.'),
(12, 'user_email_confirm', 'TRUE', 0, 'checkbox', 'Confirm Email address before logging in to site.'),
(16, 'minify_output', 'TRUE', 0, 'checkbox', 'Removes extra characters (usually unnecessary spaces) from your output for faster page load speeds. Makes your outputted HTML source code less readable.'),
(17, 'user_can_upload_wallpaper', 'TRUE', 0, 'checkbox', 'Users can Upload wallpapers'),
(18, 'user_can_post_comments', 'TRUE', 0, 'checkbox', 'Users can post comments on wallpapers'),
(19, 'comment_has_to_be_moderated', 'TRUE', 0, 'checkbox', 'Wallpaper comments need to be moderated. If it''s not enabled each new comment will auto publish.'),
(20, 'image_quality', '78', 0, 'number', 'Set Image Qaulity between 75 to 100'),
(22, 'bad_words', 'wallpapers?,2g1c,2 girls 1 cup,acrotomophilia,anal,anilingus,anus,arsehole,ass,asshole,assmunch,auto erotic,autoerotic,babeland,baby batter,ball gag,ball gravy,ball kicking,ball licking,ball sack,ball sucking,bangbros,bareback,barely legal,barenaked,bastardo,bastinado,bbw,bdsm,beaver cleaver,beaver lips,bestiality,bi curious,big black,big breasts,big knockers,big tits,bimbos,birdlock,bitch,black cock,blonde action,blonde on blonde action,blow j,blow your l,blue waffle,blumpkin,bollocks,bondage,boner,boob,boobs,booty call,brown showers,brunette action,bukkake,bulldyke,bullet vibe,bung hole,bunghole,busty,butt,buttcheeks,butthole,camel toe,camgirl,camslut,camwhore,carpet muncher,carpetmuncher,chocolate rosebuds,circlejerk,cleveland steamer,clit,clitoris,clover clamps,clusterfuck,cock,cocks,coprolagnia,coprophilia,cornhole,cum,cumming,cunnilingus,cunt,darkie,date rape,daterape,deep throat,deepthroat,dick,dildo,dirty pillows,dirty sanchez,doggie style,doggiestyle,doggy style,doggystyle,dog style,dolcett,domination,dominatrix,dommes,donkey punch,double dong,double penetration,dp action,eat my ass,ecchi,ejaculation,erotic,erotism,escort,ethical slut,eunuch,faggot,fecal,felch,fellatio,feltch,female squirting,femdom,figging,fingering,fisting,foot fetish,footjob,frotting,fuck,fuck buttons,fudge packer,fudgepacker,futanari,gang bang,gay sex,genitals,giant cock,girl on,girl on top,girls gone wild,goatcx,goatse,gokkun,golden shower,goodpoop,goo girl,goregasm,grope,group sex,g-spot,guro,hand job,handjob,hard core,hardcore,hentai,homoerotic,honkey,hooker,hot chick,how to kill,how to murder,huge fat,humping,incest,intercourse,jack off,jail bait,jailbait,jerk off,jigaboo,jiggaboo,jiggerboo,jizz,juggs,kike,kinbaku,kinkster,kinky,knobbing,leather restraint,leather straight jacket,lemon party,lolita,lovemaking,make me come,male squirting,masturbate,menage a trois,milf,missionary position,motherfucker,mound of venus,mr hands,muff diver,muffdiving,nambla,nawashi,negro,neonazi,nigga,nigger,nig nog,nimphomania,nipple,nipples,nsfw images,nude,nudity,nympho,nymphomania,octopussy,omorashi,one cup two girls,one guy one jar,orgasm,orgy,paedophile,panties,panty,pedobear,pedophile,pegging,penis,phone sex,piece of shit,pissing,piss pig,pisspig,playboy,pleasure chest,pole smoker,ponyplay,poof,poop chute,poopchute,porn,porno,pornography,prince albert piercing,pthc,pubes,pussy,queaf,raghead,raging boner,rape,raping,rapist,rectum,reverse cowgirl,rimjob,rimming,rosy palm,rosy palm and her 5 sisters,rusty trombone,sadism,scat,schlong,scissoring,semen,sex,sexo,sexy,shaved beaver,shaved pussy,shemale,shibari,shit,shota,shrimping,slanteye,slut,s&m,smut,snatch,snowballing,sodomize,sodomy,spic,spooge,spread legs,strap on,strapon,strappado,strip club,style doggy,suck,sucks,suicide girls,sultry women,swastika,swinger,tainted love,taste my,tea bagging,threesome,throating,tied up,tight white,tit,tits,titties,titty,tongue in a,topless,tosser,towelhead,tranny,tribadism,tub girl,tubgirl,tushy,twat,twink,twinkie,two girls one cup,undressing,upskirt,urethra play,urophilia,vagina,venus mound,vibrator,violet blue,violet wand,vorarephilia,voyeur,vulva,wank,wetback,wet dream,white power,women rapping,wrapping men,wrinkled starfish,xx,xxx,yaoi,yellow showers,yiffy,zoophilia', 0, 'textarea', 'Enter Your Custom Bad Words that you want to filter. Comma Seperate ",". This also supports Regualar Expression (This is not a search and replace, it only delete what you have added in this list) & Take a look on below website for more bad words on diffrent languages. <code>https://github.com/shutterstock/List-of-Dirty-Naughty-Obscene-and-Otherwise-Bad-Words</code>'),
(23, 'minimum_width', '1024', 0, 'number', 'Minimum Width of the image upload. Zero "<code>0</code>" of any Resolution'),
(24, 'minimum_height', '768', 0, 'number', 'Minimum Height of the image upload. Zero "<code>0</code>" of any Resolution'),
(25, 'recaptcha_private_code', '', 0, 'text', 'reCAPTCHA is a free service to protect your website from spam and abuse. Get your own Key <code>https://www.google.com/recaptcha/intro/index.html</code>'),
(26, 'recaptcha_public_code', '', 0, 'text', NULL),
(27, 'facebook_appId', '', 0, 'text', 'Facebook App ID. Create your own <code>https://developers.facebook.com/apps</code>'),
(28, 'facebook_secret', '', 0, 'text', 'Facebook secret Code'),
(29, 'display_only_available_resolutions', '0', 0, 'checkbox', 'Display Resolutions which are only exits on wallpapers'),
(30, 'display_only_available_category', '0', 0, 'checkbox', 'Display Categories which are only exits on wallpapers'),
(31, 'display_wallpaper_view_page', 'TRUE', 0, 'checkbox', 'This option is to show wallpaper view page instead of direct download.'),
(32, 'facebook_comment', '0', 0, 'checkbox', 'Replace System Comment System to Facebook Comments'),
(33, 'comment_limit', '5', 0, 'number', 'Number of comment that you want to show when page load.'),
(34, 'set_global_time_zone', 'Asia/Kolkata', 0, 'text', 'Visit this plage to check list of supported timezone. <code>http://www.php.net/manual/en/timezones.php</code>'),
(35, 'related_wallpaper_limit', '4', 0, 'number', 'Number of max Related Wallpaper'),
(37, 'rss_limit', '10', 0, 'number', 'Number of Rss Wallpapers Limit..'),
(38, 'office_address', '<strong>Twitter, Inc.</strong><br>\r\n795 Folsom Ave, Suite 600<br>\r\nSan Francisco, CA 94107<br>\r\n<abbr title=''Phone''>\r\n P:</abbr>\r\n(123) 456-7890', 0, 'textarea', 'Office Adress HTML Support'),
(39, 'contact_email', 'admin@domain.com', 0, 'text', 'Email address if someone tries to contact you. '),
(40, 'auto_approve_users_updated_wallpapers', 'TRUE', 0, 'checkbox', 'Auto Approve every New wallpaper from a user'),
(42, 'xml_sitemap_limit', '25000', 0, 'number', NULL),
(43, 'last_check', '{"date":"2015-01-26","v":"1.0.2"}', 1, NULL, NULL),
(44, 'current_version', '1.0.2', 1, 'number', NULL),
(45, 'backendTheme', 'default', 1, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `ws_user`
--
CREATE TABLE IF NOT EXISTS `ws_user` (
`user_seq_id` int(11) NOT NULL,
`user_type_seq_id` int(11) DEFAULT NULL,
`user_email` varchar(45) DEFAULT NULL,
`user_password` varchar(70) DEFAULT NULL,
`user_name` varchar(150) DEFAULT NULL,
`user_created` timestamp NULL DEFAULT NULL,
`user_lastLogin` datetime DEFAULT NULL,
`user_emailConfirm` int(1) DEFAULT NULL,
`user_emailCode` varchar(70) DEFAULT NULL,
`user_status_seq_id` int(11) DEFAULT NULL,
`user_public_profile` int(1) DEFAULT '1',
`user_profile_pic` varchar(255) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_user`
--
INSERT INTO `ws_user` (`user_seq_id`, `user_type_seq_id`, `user_email`, `user_password`, `user_name`, `user_created`, `user_lastLogin`, `user_emailConfirm`, `user_emailCode`, `user_status_seq_id`, `user_public_profile`, `user_profile_pic`) VALUES
(1, 2, 'admin@domain.com', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', NULL, '2015-01-25 12:41:02', NULL, 1, 'f8d1d33807f5ff4f8b93fa089ff379df67ead1eb', 1, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `ws_user_status`
--
CREATE TABLE IF NOT EXISTS `ws_user_status` (
`user_status_seq_id` int(11) NOT NULL,
`user_status_name` varchar(45) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_user_status`
--
INSERT INTO `ws_user_status` (`user_status_seq_id`, `user_status_name`) VALUES
(1, 'Enabled'),
(2, 'Disabled'),
(3, 'Banned');
-- --------------------------------------------------------
--
-- Table structure for table `ws_user_type`
--
CREATE TABLE IF NOT EXISTS `ws_user_type` (
`user_type_seq_id` int(11) NOT NULL,
`user_type_name` varchar(45) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_user_type`
--
INSERT INTO `ws_user_type` (`user_type_seq_id`, `user_type_name`) VALUES
(1, 'Member'),
(2, 'Administrator');
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers` (
`wallpaper_seq_id` int(11) NOT NULL,
`wallpaper_name` varchar(150) DEFAULT NULL,
`wallpaper_slug` varchar(150) DEFAULT NULL,
`wallpaper_hash` varchar(100) DEFAULT NULL,
`user_seq_id` int(11) DEFAULT NULL,
`category_seq_id` int(11) DEFAULT NULL,
`wallpaper_image_path` varchar(250) DEFAULT NULL,
`wallpaper_width` int(11) DEFAULT NULL,
`wallpaper_height` int(11) DEFAULT NULL,
`wallpaper_status` int(11) NOT NULL DEFAULT '1',
`wallpaper_featured` int(11) DEFAULT NULL,
`wallpaper_crop_position` varchar(10) DEFAULT NULL,
`wallpaper_description` mediumtext,
`wallpaper_date_created` timestamp NULL DEFAULT NULL,
`wallpaper_date_modified` timestamp NULL DEFAULT NULL,
`wallpaper_metatitle` varchar(200) DEFAULT NULL,
`wallpaper_metadescription` mediumtext,
`wallpaper_metakeywords` varchar(250) DEFAULT NULL,
`wallpaper_author` varchar(255) DEFAULT NULL,
`wallpaper_author_site` varchar(500) DEFAULT NULL,
`wallpaper_approved` int(11) DEFAULT '1'
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_colors`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_colors` (
`wc_seq_id` int(11) NOT NULL,
`wallpaper_seq_id` int(11) DEFAULT NULL,
`count` decimal(30,15) NOT NULL,
`hex_code` varchar(10) DEFAULT NULL,
`hue` int(3) DEFAULT NULL,
`saturation` decimal(30,15) DEFAULT NULL,
`lightness` decimal(30,15) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_comments`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_comments` (
`comment_seq_id` int(11) NOT NULL,
`wallpaper_seq_id` int(11) DEFAULT NULL,
`user_seq_id` int(11) DEFAULT NULL,
`guest_name` varchar(255) DEFAULT NULL,
`guest_email` varchar(255) DEFAULT NULL,
`comment_description` text,
`comment_date` datetime DEFAULT NULL,
`comment_status` int(11) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_downloads`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_downloads` (
`wd_seq_id` int(11) NOT NULL,
`wd_date` datetime DEFAULT NULL,
`wd_ip` int(11) DEFAULT NULL,
`wd_uid` int(11) DEFAULT NULL,
`wd_wid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_favourites`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_favourites` (
`wf_seq_id` int(11) NOT NULL,
`wf_date` datetime DEFAULT NULL,
`wf_ip` int(11) DEFAULT NULL,
`wf_uid` int(11) DEFAULT NULL,
`wf_wid` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_path`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_path` (
`wp_seq_id` int(11) NOT NULL,
`wallpaper_seq_id` int(11) DEFAULT NULL,
`category_seq_id` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_tags`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_tags` (
`tag_seq_id` int(11) NOT NULL,
`tag_name` varchar(255) DEFAULT NULL,
`wallpaper_seq_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_views`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_views` (
`wv_seq_id` int(11) NOT NULL,
`wv_date` datetime DEFAULT NULL,
`wv_ip` int(11) DEFAULT NULL,
`wv_uid` int(11) DEFAULT NULL,
`wv_wid` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ws_wallpapers_votes`
--
CREATE TABLE IF NOT EXISTS `ws_wallpapers_votes` (
`vote_seq_id` int(11) NOT NULL,
`vote_up` int(11) DEFAULT NULL,
`vote_down` int(11) DEFAULT NULL,
`vote_wid` int(11) DEFAULT NULL,
`vote_date` datetime DEFAULT NULL,
`vote_uid` int(11) DEFAULT NULL,
`vote_ip` int(11) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `ws_ads_management`
--
ALTER TABLE `ws_ads_management`
ADD PRIMARY KEY (`ad_seq_id`);
--
-- Indexes for table `ws_category`
--
ALTER TABLE `ws_category`
ADD PRIMARY KEY (`category_seq_id`), ADD KEY `category_seq_id` (`category_seq_id`), ADD KEY `category_slug` (`category_slug`), ADD KEY `category_name` (`category_name`), ADD KEY `category_parent_id` (`category_parent_id`);
--
-- Indexes for table `ws_closures`
--
ALTER TABLE `ws_closures`
ADD PRIMARY KEY (`id`), ADD KEY `index` (`ancestor`,`descendant`,`lvl`);
--
-- Indexes for table `ws_comments_reports`
--
ALTER TABLE `ws_comments_reports`
ADD PRIMARY KEY (`report_seq_id`);
--
-- Indexes for table `ws_languages`
--
ALTER TABLE `ws_languages`
ADD PRIMARY KEY (`language_seq_id`);
--
-- Indexes for table `ws_language_grouping`
--
ALTER TABLE `ws_language_grouping`
ADD PRIMARY KEY (`lg_seq_id`);
--
-- Indexes for table `ws_language_text`
--
ALTER TABLE `ws_language_text`
ADD PRIMARY KEY (`lt_seq_id`);
--
-- Indexes for table `ws_language_text_value`
--
ALTER TABLE `ws_language_text_value`
ADD PRIMARY KEY (`ltv_seq_id`);
--
-- Indexes for table `ws_metadata`
--
ALTER TABLE `ws_metadata`
ADD PRIMARY KEY (`metadata_seq_id`);
--
-- Indexes for table `ws_metadata_values`
--
ALTER TABLE `ws_metadata_values`
ADD PRIMARY KEY (`metadata_value_seq_id`);
--
-- Indexes for table `ws_resolutions`
--
ALTER TABLE `ws_resolutions`
ADD PRIMARY KEY (`resolution_seq_id`);
--
-- Indexes for table `ws_resolutions_groups`
--
ALTER TABLE `ws_resolutions_groups`
ADD PRIMARY KEY (`resolution_group_seq_id`);
--
-- Indexes for table `ws_routes`
--
ALTER TABLE `ws_routes`
ADD PRIMARY KEY (`route_seq_id`), ADD UNIQUE KEY `route_name_UNIQUE` (`route_name`);
--
-- Indexes for table `ws_routes_values`
--
ALTER TABLE `ws_routes_values`
ADD PRIMARY KEY (`rv_seq_id`);
--
-- Indexes for table `ws_setting`
--
ALTER TABLE `ws_setting`
ADD PRIMARY KEY (`setting_seq_id`), ADD UNIQUE KEY `setting_key` (`setting_key`);
--
-- Indexes for table `ws_user`
--
ALTER TABLE `ws_user`
ADD PRIMARY KEY (`user_seq_id`);
--
-- Indexes for table `ws_user_status`
--
ALTER TABLE `ws_user_status`
ADD PRIMARY KEY (`user_status_seq_id`);
--
-- Indexes for table `ws_user_type`
--
ALTER TABLE `ws_user_type`
ADD PRIMARY KEY (`user_type_seq_id`);
--
-- Indexes for table `ws_wallpapers`
--
ALTER TABLE `ws_wallpapers`
ADD PRIMARY KEY (`wallpaper_seq_id`), ADD FULLTEXT KEY `wallpaper_name` (`wallpaper_name`);
--
-- Indexes for table `ws_wallpapers_colors`
--
ALTER TABLE `ws_wallpapers_colors`
ADD PRIMARY KEY (`wc_seq_id`), ADD KEY `wallpaper_seq_id` (`wallpaper_seq_id`), ADD KEY `hex_code` (`hex_code`), ADD KEY `count` (`count`), ADD KEY `saturation` (`hue`,`saturation`,`lightness`);
--
-- Indexes for table `ws_wallpapers_comments`
--
ALTER TABLE `ws_wallpapers_comments`
ADD PRIMARY KEY (`comment_seq_id`), ADD KEY `wallpaper_seq_id` (`wallpaper_seq_id`), ADD KEY `user_seq_id` (`user_seq_id`);
--
-- Indexes for table `ws_wallpapers_downloads`
--
ALTER TABLE `ws_wallpapers_downloads`
ADD PRIMARY KEY (`wd_seq_id`), ADD KEY `wallpaper_seq_id` (`wd_wid`), ADD KEY `user_seq_id` (`wd_uid`);
--
-- Indexes for table `ws_wallpapers_favourites`
--
ALTER TABLE `ws_wallpapers_favourites`
ADD PRIMARY KEY (`wf_seq_id`), ADD KEY `user_seq_id` (`wf_uid`), ADD KEY `wallpaper_seq_id` (`wf_wid`);
--
-- Indexes for table `ws_wallpapers_path`
--
ALTER TABLE `ws_wallpapers_path`
ADD PRIMARY KEY (`wp_seq_id`), ADD KEY `wallpaper_seq_id` (`wallpaper_seq_id`), ADD KEY `category_seq_id` (`category_seq_id`);
--
-- Indexes for table `ws_wallpapers_tags`
--
ALTER TABLE `ws_wallpapers_tags`
ADD PRIMARY KEY (`tag_seq_id`), ADD KEY `wallpaper_seq_id` (`wallpaper_seq_id`), ADD KEY `tag_name` (`tag_name`);
--
-- Indexes for table `ws_wallpapers_views`
--
ALTER TABLE `ws_wallpapers_views`
ADD PRIMARY KEY (`wv_seq_id`), ADD KEY `wallpaper_seq_id` (`wv_wid`), ADD KEY `user_seq_id` (`wv_uid`);
--
-- Indexes for table `ws_wallpapers_votes`
--
ALTER TABLE `ws_wallpapers_votes`
ADD PRIMARY KEY (`vote_seq_id`), ADD KEY `wallpaper_seq_id` (`vote_wid`), ADD KEY `user_seq_id` (`vote_uid`), ADD KEY `vote_up` (`vote_up`), ADD KEY `vote_down` (`vote_down`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `ws_ads_management`
--
ALTER TABLE `ws_ads_management`
MODIFY `ad_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `ws_category`
--
ALTER TABLE `ws_category`
MODIFY `category_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=66;
--
-- AUTO_INCREMENT for table `ws_closures`
--
ALTER TABLE `ws_closures`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=138;
--
-- AUTO_INCREMENT for table `ws_comments_reports`
--
ALTER TABLE `ws_comments_reports`
MODIFY `report_seq_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_languages`
--
ALTER TABLE `ws_languages`
MODIFY `language_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81;
--
-- AUTO_INCREMENT for table `ws_language_grouping`
--
ALTER TABLE `ws_language_grouping`
MODIFY `lg_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `ws_language_text`
--
ALTER TABLE `ws_language_text`
MODIFY `lt_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=229;
--
-- AUTO_INCREMENT for table `ws_language_text_value`
--
ALTER TABLE `ws_language_text_value`
MODIFY `ltv_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=511;
--
-- AUTO_INCREMENT for table `ws_metadata`
--
ALTER TABLE `ws_metadata`
MODIFY `metadata_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=65;
--
-- AUTO_INCREMENT for table `ws_metadata_values`
--
ALTER TABLE `ws_metadata_values`
MODIFY `metadata_value_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=126;
--
-- AUTO_INCREMENT for table `ws_resolutions`
--
ALTER TABLE `ws_resolutions`
MODIFY `resolution_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT for table `ws_resolutions_groups`
--
ALTER TABLE `ws_resolutions_groups`
MODIFY `resolution_group_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `ws_routes`
--
ALTER TABLE `ws_routes`
MODIFY `route_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=38;
--
-- AUTO_INCREMENT for table `ws_routes_values`
--
ALTER TABLE `ws_routes_values`
MODIFY `rv_seq_id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table `ws_setting`
--
ALTER TABLE `ws_setting`
MODIFY `setting_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=46;
--
-- AUTO_INCREMENT for table `ws_user`
--
ALTER TABLE `ws_user`
MODIFY `user_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `ws_user_status`
--
ALTER TABLE `ws_user_status`
MODIFY `user_status_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `ws_user_type`
--
ALTER TABLE `ws_user_type`
MODIFY `user_type_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `ws_wallpapers`
--
ALTER TABLE `ws_wallpapers`
MODIFY `wallpaper_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `ws_wallpapers_colors`
--
ALTER TABLE `ws_wallpapers_colors`
MODIFY `wc_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `ws_wallpapers_comments`
--
ALTER TABLE `ws_wallpapers_comments`
MODIFY `comment_seq_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_wallpapers_downloads`
--
ALTER TABLE `ws_wallpapers_downloads`
MODIFY `wd_seq_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_wallpapers_favourites`
--
ALTER TABLE `ws_wallpapers_favourites`
MODIFY `wf_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `ws_wallpapers_path`
--
ALTER TABLE `ws_wallpapers_path`
MODIFY `wp_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `ws_wallpapers_tags`
--
ALTER TABLE `ws_wallpapers_tags`
MODIFY `tag_seq_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ws_wallpapers_views`
--
ALTER TABLE `ws_wallpapers_views`
MODIFY `wv_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `ws_wallpapers_votes`
--
ALTER TABLE `ws_wallpapers_votes`
MODIFY `vote_seq_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
/*!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 */;