-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `free_theme`
--

CREATE TABLE IF NOT EXISTS `free_theme` (
  `ft_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `total_download` int(11) NOT NULL,
  `add_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ft_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `free_theme`
--

INSERT INTO `free_theme` (`ft_id`, `title`, `image`, `file`, `total_download`, `add_on`) VALUES
(2, 'This is test theme', 'img_1329278045_.png', 'theme_1625537196_.zip', 3, '2021-07-06 02:06:36'),
(3, 'The technology is goingtbn to big', 'img_1344523181_.jpg', 'theme_1625538595_.zip', 2, '2021-07-06 02:29:55');

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

--
-- Table structure for table `premium_theme`
--

CREATE TABLE IF NOT EXISTS `premium_theme` (
  `pt_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `cat_id_fk` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `add_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`pt_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `premium_theme`
--

INSERT INTO `premium_theme` (`pt_id`, `title`, `cat_id_fk`, `image`, `url`, `add_on`) VALUES
(1, 'Nijar - Bootstrap Admin Template', 1, 'img_1409207812_.png', 'https://themeforest.net/item/nijar-responsive-bootstrap-admin-template/30562860', '2021-07-05 23:39:18'),
(4, 'Cotrak - Coronavirus Live Tracker Admin Dashboard Template', 2, 'img_1173441914_.png', 'https://themeforest.net/item/cotrak-coronavirus-live-traker-admin-dashboard/26339620', '2021-07-05 23:58:35');

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

--
-- Table structure for table `theme_categories`
--

CREATE TABLE IF NOT EXISTS `theme_categories` (
  `t_cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) NOT NULL,
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`t_cat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `theme_categories`
--

INSERT INTO `theme_categories` (`t_cat_id`, `cat_name`, `added_on`) VALUES
(1, 'Admin Theme', '2021-07-05 22:10:27'),
(2, 'Landing', '2021-07-06 01:00:08'),
(9, 'School Theme', '2021-07-06 02:55:38');

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

--
-- Table structure for table `visitors`
--

CREATE TABLE IF NOT EXISTS `visitors` (
  `visitor_id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(255) NOT NULL,
  `add_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `visitors`
--

INSERT INTO `visitors` (`visitor_id`, `ip_address`, `add_on`) VALUES
(6, '127.0.0.1', '2021-07-05 19:40:23');

