ikan Uploader :
Directory : /var/www/html/agusttya.com/blog/database/
Upload File : |
| Current File : /var/www/html/agusttya.com/blog/database/customblog_db.sql |
/*
SQLyog Community Edition- MySQL GUI v6.56
MySQL - 5.6.10-log : Database - customblog_db
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`customblog_db` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `customblog_db`;
/*Table structure for table `history` */
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`activity` varchar(255) NOT NULL,
`username` varchar(150) DEFAULT NULL,
`time` int(10) unsigned NOT NULL,
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip_address` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*Data for the table `history` */
/*Table structure for table `su_seo_pages` */
DROP TABLE IF EXISTS `su_seo_pages`;
CREATE TABLE `su_seo_pages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(250) NOT NULL,
`h1_tag` varchar(250) DEFAULT NULL,
`description` text NOT NULL,
`keywords` text NOT NULL,
`custom` varchar(250) NOT NULL,
`slug` varchar(100) DEFAULT NULL,
`display_order` int(11) DEFAULT NULL,
`status` enum('1','0') NOT NULL DEFAULT '1',
`is_deleted` enum('1','0') NOT NULL DEFAULT '0',
`createdon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `su_seo_pages` */
/*Table structure for table `tbl_academic_record` */
DROP TABLE IF EXISTS `tbl_academic_record`;
CREATE TABLE `tbl_academic_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip_address` varchar(100) DEFAULT NULL,
`last_login` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `tbl_academic_record` */
/*Table structure for table `tbl_access_master` */
DROP TABLE IF EXISTS `tbl_access_master`;
CREATE TABLE `tbl_access_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`access_name` varchar(220) DEFAULT NULL,
`custom` varchar(200) DEFAULT NULL,
`display_name` varchar(250) DEFAULT NULL,
`display_icon` varchar(250) DEFAULT NULL,
`display_order` tinyint(4) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_access_master` */
insert into `tbl_access_master`(`id`,`access_name`,`custom`,`display_name`,`display_icon`,`display_order`,`status`,`is_deleted`,`createdon`,`modifiedon`) values (1,'Add Record','add',NULL,'icon ic_b_sql',NULL,1,0,'2020-10-13 10:34:25','2020-10-13 10:34:25'),(2,'Edit Record','edit',NULL,'fa fa-edit',NULL,1,0,'2020-10-13 10:34:25','2020-10-13 10:34:25'),(3,'View Record','view',NULL,'icon ic_eye',NULL,1,0,'2020-10-13 10:34:57','2020-10-13 10:34:57'),(4,'Delete Record','delete',NULL,'fa fa-trash',NULL,1,0,'2020-10-13 10:34:57','2020-10-13 10:34:57'),(5,'Export Record','export',NULL,'icon ic_b_tblexport',NULL,1,0,'2020-10-13 10:35:25','2020-10-13 10:35:25'),(6,'Import Record','import',NULL,'icon ic_b_tblimport',NULL,1,0,'2020-10-13 10:35:25','2020-10-13 10:35:25');
/*Table structure for table `tbl_admin` */
DROP TABLE IF EXISTS `tbl_admin`;
CREATE TABLE `tbl_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`employee_id` varchar(20) DEFAULT NULL,
`userName` varchar(120) DEFAULT NULL,
`password` varchar(200) DEFAULT NULL,
`first_name` varchar(200) DEFAULT NULL,
`last_name` varchar(150) DEFAULT NULL,
`school_id` tinyint(4) DEFAULT NULL,
`contact_number` varchar(15) DEFAULT NULL,
`department_id` int(10) DEFAULT NULL,
`email_id` varchar(210) DEFAULT NULL,
`role_id` varchar(50) DEFAULT NULL,
`access_id` varchar(200) DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`city` varchar(200) DEFAULT NULL,
`institution` varchar(200) DEFAULT NULL,
`job_role` varchar(200) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip_address` varchar(100) DEFAULT NULL,
`last_login` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`added_by` tinyint(4) DEFAULT NULL,
`xls_update_by` int(10) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_admin` */
insert into `tbl_admin`(`id`,`employee_id`,`userName`,`password`,`first_name`,`last_name`,`school_id`,`contact_number`,`department_id`,`email_id`,`role_id`,`access_id`,`country`,`city`,`institution`,`job_role`,`status`,`is_deleted`,`createdon`,`ip_address`,`last_login`,`last_modifiedon`,`added_by`,`xls_update_by`) values (1,'0','SuperAdmin','superadmin123','Super','Admin',14,'9999999999',5,'superadmin@sharda.ac.in','1','1,2,3',NULL,NULL,NULL,NULL,1,0,'2021-08-13 14:13:53',NULL,'2020-10-09 09:26:00','2020-10-15 14:05:46',NULL,0),(2,'0','amitverma','123456','Amit','Verma',14,'8920976831',5,'amit.verma@shardatech.org','1','1,2,3',NULL,NULL,NULL,NULL,1,0,'2021-08-13 14:12:16',NULL,'2020-10-12 07:35:47','2020-10-15 14:05:46',NULL,0);
/*Table structure for table `tbl_banner_master` */
DROP TABLE IF EXISTS `tbl_banner_master`;
CREATE TABLE `tbl_banner_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`banner_name` varchar(250) NOT NULL,
`banner_url` varchar(250) NOT NULL,
`banner_code` varchar(50) NOT NULL,
`alt_tag` varchar(120) DEFAULT NULL,
`banner_image` varchar(100) NOT NULL,
`banner_type` char(3) DEFAULT NULL,
`banner_text` text,
`display_order` char(3) DEFAULT NULL,
`button_url2` varchar(200) DEFAULT NULL,
`button_url` varchar(200) DEFAULT NULL,
`button_label2` varchar(200) DEFAULT NULL,
`button_label` varchar(200) DEFAULT NULL,
`status` enum('1','0') NOT NULL DEFAULT '1',
`banner_for` enum('0','1','2','3') DEFAULT '0',
`is_deleted` enum('1','0') NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_banner_master` */
/*Table structure for table `tbl_blog_author` */
DROP TABLE IF EXISTS `tbl_blog_author`;
CREATE TABLE `tbl_blog_author` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`author_name` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`author_image` text,
`author_email` text,
`author_mobile` text,
`author_descr` text,
`slug` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_blog_author` */
insert into `tbl_blog_author`(`id`,`author_name`,`display_name`,`author_image`,`author_email`,`author_mobile`,`author_descr`,`slug`,`status`,`is_deleted`,`createdon`,`modifiedon`,`display_order`) values (1,'Admin','Admin',NULL,'admin@gmail.com','9876543210','','Admin',1,0,'2021-08-03 12:07:44','2021-08-03 06:37:44',1);
/*Table structure for table `tbl_blog_category` */
DROP TABLE IF EXISTS `tbl_blog_category`;
CREATE TABLE `tbl_blog_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_name` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`slug` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_blog_category` */
insert into `tbl_blog_category`(`id`,`category_name`,`display_name`,`slug`,`status`,`is_deleted`,`createdon`,`modifiedon`,`display_order`) values (1,'About','About','About',1,0,'2021-08-03 12:00:20','2021-08-03 06:30:20',1),(2,'Academic','Academic','Academic',1,0,'2021-08-03 12:00:48','2021-08-03 06:30:48',2),(3,'Admissions','Admissions','Admissions',1,0,'2021-08-03 12:01:14','2021-08-03 06:31:14',3),(4,'Campus Life','Campus Life','campus-life',1,0,'2021-08-03 12:01:47','2021-08-03 06:31:47',4),(5,'Connect','Connect','Connect',1,0,'2021-08-03 12:02:13','2021-08-03 06:32:13',5),(6,'Exams','Exams','Exams',1,0,'2021-08-03 12:02:30','2021-08-03 06:32:30',6),(7,'Higher Education','Higher Education','higher-education',1,0,'2021-08-03 12:03:08','2021-08-03 06:33:08',7),(8,'News','News','News',1,0,'2021-08-03 12:03:28','2021-08-03 06:33:28',8),(9,'Study Abroad','Study Abroad','study-abroad',1,0,'2021-08-03 12:03:59','2021-08-03 06:33:59',9),(10,'Uncategorized','Uncategorized','Uncategorized',1,0,'2021-08-03 12:04:37','2021-08-03 12:04:46',10);
/*Table structure for table `tbl_blog_tags` */
DROP TABLE IF EXISTS `tbl_blog_tags`;
CREATE TABLE `tbl_blog_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_name` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`slug` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_blog_tags` */
insert into `tbl_blog_tags`(`id`,`tag_name`,`display_name`,`slug`,`status`,`is_deleted`,`createdon`,`modifiedon`,`display_order`) values (1,'Best in Class Higher Education','Best in Class Higher Education','best-in-class-higher-education',1,0,'2021-08-03 12:06:03','2021-08-03 06:36:03',1),(2,'Educational Hub for African','Educational Hub For African','Educational Hub for African',1,0,'2021-08-03 12:06:37','2021-08-13 02:48:26',2);
/*Table structure for table `tbl_blog_type` */
DROP TABLE IF EXISTS `tbl_blog_type`;
CREATE TABLE `tbl_blog_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`blogtype_name` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`slug` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `tbl_blog_type` */
/*Table structure for table `tbl_blogs` */
DROP TABLE IF EXISTS `tbl_blogs`;
CREATE TABLE `tbl_blogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`blog_title` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`blog_slug` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`blog_short_descr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`blog_descr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`blog_date` date DEFAULT NULL,
`blog_image` varchar(150) DEFAULT NULL,
`blogtype_name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`category_name` text,
`tag_name` text,
`author_name` text,
`url_1` text,
`url_2` text,
`url_3` text,
`url_4` text,
`url_5` text,
`url_6` text,
`hit_count` int(11) DEFAULT '0',
`title` varchar(250) NOT NULL,
`description` text NOT NULL,
`keywords` text NOT NULL,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
`status` enum('1','0') NOT NULL DEFAULT '1',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`category_id` varchar(250) DEFAULT NULL,
`tag_id` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_blogs` */
/*Table structure for table `tbl_campus` */
DROP TABLE IF EXISTS `tbl_campus`;
CREATE TABLE `tbl_campus` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`campus_name` varchar(250) NOT NULL,
`campus_code` varchar(50) NOT NULL,
`display_order` int(11) DEFAULT NULL,
`status` enum('1','0') NOT NULL DEFAULT '1',
`is_deleted` enum('1','0') NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`is_display` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_campus` */
insert into `tbl_campus`(`id`,`campus_name`,`campus_code`,`display_order`,`status`,`is_deleted`,`createdon`,`modifiedon`,`is_display`) values (1,'Sharda University Greater Noida','SUGC',NULL,'1','0','2020-11-24 09:09:58','2020-11-24 09:08:42',1),(2,'Sharda University Agra Capus','SUAC',NULL,'1','0','2020-11-24 09:10:26','2020-11-24 09:10:26',1),(3,'Sharda University Uzbekistan Capus','SUUZC',NULL,'1','0','2020-11-24 09:11:18','2020-11-24 09:11:18',1);
/*Table structure for table `tbl_category` */
DROP TABLE IF EXISTS `tbl_category`;
CREATE TABLE `tbl_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_name` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`slug` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
`tags` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `tbl_category` */
/*Table structure for table `tbl_issue_master` */
DROP TABLE IF EXISTS `tbl_issue_master`;
CREATE TABLE `tbl_issue_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`issue_type` varchar(220) DEFAULT NULL,
`custom` varchar(210) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip_address` varchar(100) DEFAULT NULL,
`last_login` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `tbl_issue_master` */
/*Table structure for table `tbl_module_master` */
DROP TABLE IF EXISTS `tbl_module_master`;
CREATE TABLE `tbl_module_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`module_name` varchar(220) DEFAULT NULL,
`custom` varchar(200) DEFAULT NULL,
`display_name` varchar(250) DEFAULT NULL,
`display_icon` varchar(250) DEFAULT NULL,
`display_order` tinyint(4) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_module_master` */
insert into `tbl_module_master`(`id`,`module_name`,`custom`,`display_name`,`display_icon`,`display_order`,`status`,`is_deleted`,`createdon`,`modifiedon`) values (12,'N/A',NULL,'Advance Settings','fa fa-cog',12,1,0,'2020-10-16 03:05:35','2020-10-13 05:43:00'),(17,'dashboard',NULL,'Dashboard','fas fa-fw fa-tachometer-alt',0,1,0,'2020-10-13 09:45:23','2020-10-13 09:45:23'),(26,'manageblog/manageblog',NULL,'Manage Blogs','fa fa-users',1,1,0,'2021-07-21 11:41:46','2021-07-21 05:18:39'),(27,'manageblog/managecategory',NULL,'Manage Blog Category','fa fa-users',2,1,0,'2021-07-21 08:57:44','2021-07-21 08:11:36'),(28,'manageblog/managetags',NULL,'Manage Blog Tags','fa fa-users',3,1,0,'2021-07-21 09:27:20','2021-07-21 08:12:08'),(29,'manageblog/managetype',NULL,'Manage Blog Type','fa fa-users',4,0,0,'2021-07-28 05:53:10','2021-07-21 08:12:39'),(30,'manageblog/manageauthors',NULL,'Manage Blog Authors','fa fa-users',5,1,0,'2021-07-21 09:40:11','2021-07-21 08:13:13'),(31,'manageseo/manageseo',NULL,'Custom SEO','fa fa-users',6,1,0,'2021-07-30 14:52:26','2021-07-30 14:52:09'),(32,'banners',NULL,'Manage Banner','fa fa-calendar',10,1,0,'2021-08-12 11:48:01','2021-08-12 06:18:01');
/*Table structure for table `tbl_role_master` */
DROP TABLE IF EXISTS `tbl_role_master`;
CREATE TABLE `tbl_role_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(120) DEFAULT NULL,
`custom` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`display_order` tinyint(4) DEFAULT NULL,
`module_ids` varchar(250) DEFAULT NULL,
`display_icon` varchar(250) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_role_master` */
insert into `tbl_role_master`(`id`,`role_name`,`custom`,`display_name`,`display_order`,`module_ids`,`display_icon`,`status`,`is_deleted`,`createdon`,`modifiedon`) values (1,'Super Admin',NULL,NULL,NULL,'All',NULL,1,0,'2020-10-13 05:20:15','2020-10-12 06:43:19'),(2,'Admin',NULL,NULL,NULL,'17,26,27,28,30',NULL,1,0,'2021-07-26 06:32:27','2020-10-12 06:43:19');
/*Table structure for table `tbl_status_master` */
DROP TABLE IF EXISTS `tbl_status_master`;
CREATE TABLE `tbl_status_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`event_status` enum('0','1') NOT NULL DEFAULT '0',
`icon` varchar(200) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*Data for the table `tbl_status_master` */
insert into `tbl_status_master`(`id`,`title`,`display_name`,`event_status`,`icon`,`status`,`is_deleted`,`createdon`) values (1,'Save','Save','0',NULL,1,0,'2021-02-24 09:41:10'),(2,'Draft','Draft','0',NULL,1,0,'2021-02-24 09:41:10'),(3,'Archive','Archive','0',NULL,1,0,'2021-02-24 09:41:44'),(4,'Publish','Publish','0',NULL,1,0,'2021-02-24 09:41:44'),(5,'Approved','Approved','1',NULL,1,0,'2021-02-24 10:58:28'),(6,'Decline','Decline','1',NULL,1,0,'2021-02-24 10:58:28');
/*Table structure for table `tbl_sub_category` */
DROP TABLE IF EXISTS `tbl_sub_category`;
CREATE TABLE `tbl_sub_category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`category_id` int(10) DEFAULT '0',
`sub_category_name` varchar(200) DEFAULT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`counselling_status` tinyint(2) NOT NULL DEFAULT '0',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `tbl_sub_category` */
/*Table structure for table `tbl_subject_master` */
DROP TABLE IF EXISTS `tbl_subject_master`;
CREATE TABLE `tbl_subject_master` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`subject_name` varchar(250) NOT NULL,
`plan_id` tinyint(4) NOT NULL DEFAULT '0',
`subject_code` varchar(50) DEFAULT NULL,
`banner_image` varchar(150) DEFAULT NULL,
`display_order` int(11) DEFAULT NULL,
`status` enum('0','1') NOT NULL DEFAULT '1',
`is_deleted` enum('0','1') NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`modifiedon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*Data for the table `tbl_subject_master` */
insert into `tbl_subject_master`(`id`,`subject_name`,`plan_id`,`subject_code`,`banner_image`,`display_order`,`status`,`is_deleted`,`createdon`,`modifiedon`) values (2,'C Programming',2,'CP001',NULL,NULL,'1','0','2020-11-26 06:49:01','2020-11-26 06:49:01'),(3,'Workshop Processes',7,'ME2P001',NULL,NULL,'1','0','2020-11-26 07:13:03','2020-11-26 07:13:03'),(4,'Fluid Mechanics',7,'FM',NULL,NULL,'1','0','2020-11-26 07:13:19','2020-11-26 07:13:19');
/*Table structure for table `tbl_tags` */
DROP TABLE IF EXISTS `tbl_tags`;
CREATE TABLE `tbl_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tag_name` varchar(200) DEFAULT NULL,
`display_name` varchar(200) DEFAULT NULL,
`slug` varchar(200) NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '1',
`is_deleted` tinyint(4) NOT NULL DEFAULT '0',
`createdon` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`display_order` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `tbl_tags` */
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Kontol Shell Bypass