-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : jeu. 18 jan. 2024 à 22:07
-- Version du serveur :  5.7.31
-- Version de PHP : 7.2.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 utf8mb4 */;

--
-- Base de données : `task_manager`
--

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

--
-- Structure de la table `blog_post`
--

DROP TABLE IF EXISTS `blog_post`;
CREATE TABLE IF NOT EXISTS `blog_post` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(120) NOT NULL,
  `description` text NOT NULL,
  `sort_order` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `blog_post`
--

INSERT INTO `blog_post` (`id`, `title`, `description`, `sort_order`) VALUES
(1, 'aaaa', 'toto', 0),
(2, 'aqkjhjj', 'rien de rien', 1);

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

--
-- Structure de la table `burndown`
--

DROP TABLE IF EXISTS `burndown`;
CREATE TABLE IF NOT EXISTS `burndown` (
  `jour` varchar(255) NOT NULL,
  `valeur` int(11) DEFAULT NULL,
  PRIMARY KEY (`jour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `burndown`
--

INSERT INTO `burndown` (`jour`, `valeur`) VALUES
('01', 200),
('02', 160),
('03', 160),
('04', 140),
('05', 90),
('06', 90),
('07', 80);

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

--
-- Structure de la table `files`
--

DROP TABLE IF EXISTS `files`;
CREATE TABLE IF NOT EXISTS `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `uploaded_on` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `files`
--

INSERT INTO `files` (`id`, `title`, `description`, `uploaded_on`) VALUES
(1, 'techy', 'how ar u', '2021-01-03 11:36:43'),
(2, 'cretin', 'zoulou', '2024-01-10 20:34:50'),
(3, 'title1', 'description', '2021-01-03 11:40:15'),
(4, 'title', 'description', '2021-01-02 15:53:03'),
(5, 'no', 'yes', '2021-01-02 15:55:11'),
(6, 'hii', 'Ashish', '2021-01-02 20:28:08'),
(7, 'test1', 'how are you guys', '2021-01-03 12:06:29'),
(8, 'test12', 'complete\n', '2021-01-03 12:06:21');

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

--
-- Structure de la table `graph01`
--

DROP TABLE IF EXISTS `graph01`;
CREATE TABLE IF NOT EXISTS `graph01` (
  `jour` varchar(255) NOT NULL,
  `val1` int(11) DEFAULT NULL,
  `val2` int(11) DEFAULT NULL,
  PRIMARY KEY (`jour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `graph01`
--

INSERT INTO `graph01` (`jour`, `val1`, `val2`) VALUES
('01', 200, 100),
('02', 160, 100),
('03', 160, 100),
('04', 140, 100),
('05', 110, 100),
('06', 90, 100),
('07', 68, 100);

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

--
-- Structure de la table `graph02`
--

DROP TABLE IF EXISTS `graph02`;
CREATE TABLE IF NOT EXISTS `graph02` (
  `id` int(11) DEFAULT NULL,
  `jour` varchar(255) NOT NULL,
  `val1` int(11) DEFAULT NULL,
  `val2` int(11) DEFAULT NULL,
  PRIMARY KEY (`jour`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `graph02`
--

INSERT INTO `graph02` (`id`, `jour`, `val1`, `val2`) VALUES
(1, '12-01-2024 ', 250, 220),
(2, '13-01-2024 ', 220, 200),
(3, '14-01-2024 ', 200, 100),
(4, '15-01-2024 ', 180, 100),
(5, '16-01-2024 ', 160, 50),
(6, '17-01-2024 ', 135, 220),
(7, '18-01-2024 ', 120, 200),
(8, '19-01-2024 ', 100, 100),
(9, '20-01-2024 ', 82, 100),
(10, '21-01-2024 ', 70, 50);

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

--
-- Structure de la table `php_questions`
--

DROP TABLE IF EXISTS `php_questions`;
CREATE TABLE IF NOT EXISTS `php_questions` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `display_order` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `php_questions`
--

INSERT INTO `php_questions` (`id`, `question`, `answer`, `display_order`) VALUES
(1, 'What is PHP?', 'PHP (Hypertext Preprocessor) is a server side scripting\r\n language that is embedded in HTML. It is used to manage dynamic content,\r\n databases, session tracking, even build entire e-commerce sites.', '0'),
(2, ' What is the purpose of php.ini file?', ' It is a PHP \r\nconfiguration file that controls and effect PHP’s functionality. \r\nThe php.ini file is read each time when PHP is initialized. \r\nYou can check settings of php.ini by calling phpinfo() function in PHP script.', '4'),
(3, 'What are the differences between PHP constants and variables?', '', '5'),
(4, 'How will you find the length of a string in PHP?', '', '2'),
(5, 'What is the difference between single quoted string and double quoted string?', '', '1'),
(6, 'How do you create a cookie, add data to it, and remove data from a cookie?', '', '3');

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

--
-- Structure de la table `sorting_items`
--

DROP TABLE IF EXISTS `sorting_items`;
CREATE TABLE IF NOT EXISTS `sorting_items` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(120) NOT NULL,
  `description` text NOT NULL,
  `position_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `studentinfo`
--

DROP TABLE IF EXISTS `studentinfo`;
CREATE TABLE IF NOT EXISTS `studentinfo` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(80) NOT NULL,
  `Roll` int(5) NOT NULL,
  `Position` int(2) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `studentinfo`
--

INSERT INTO `studentinfo` (`Id`, `Name`, `Roll`, `Position`) VALUES
(5, 'Vivek Moyal', 5, 3),
(6, 'Vikas Moyal', 8, 2),
(7, 'Divya Moyal', 10, 1),
(8, 'Khusbu Moyal', 9, 5),
(9, 'Savya Moyal', 10, 4);

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

--
-- Structure de la table `students`
--

DROP TABLE IF EXISTS `students`;
CREATE TABLE IF NOT EXISTS `students` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `age` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `students`
--

INSERT INTO `students` (`id`, `first_name`, `last_name`, `age`) VALUES
(1, 'aaa', 'bbb', 35);

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

--
-- Structure de la table `tbl_lists`
--

DROP TABLE IF EXISTS `tbl_lists`;
CREATE TABLE IF NOT EXISTS `tbl_lists` (
  `list_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `list_name` varchar(50) NOT NULL,
  `list_description` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `tbl_lists`
--

INSERT INTO `tbl_lists` (`list_id`, `list_name`, `list_description`) VALUES
(1, 'To Do', 'All the tasks that must be done soon'),
(2, 'In Progress', 'All the Tasks that are currently in progress'),
(3, 'Completed', 'All the Tasks that are completed  '),
(9, 'Submitted', 'All the task that are completed and submitted.');

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

--
-- Structure de la table `tbl_tasks`
--

DROP TABLE IF EXISTS `tbl_tasks`;
CREATE TABLE IF NOT EXISTS `tbl_tasks` (
  `task_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `task_name` varchar(150) NOT NULL,
  `task_description` text NOT NULL,
  `list_id` int(11) NOT NULL,
  `priority` varchar(10) NOT NULL,
  `deadline` date NOT NULL,
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;

--
-- Déchargement des données de la table `tbl_tasks`
--

INSERT INTO `tbl_tasks` (`task_id`, `task_name`, `task_description`, `list_id`, `priority`, `deadline`) VALUES
(2, 'Logo Design', 'Logo Design for Nepz Technologies Pvt. Ltd.                        ', 1, 'High', '2021-05-12'),
(4, 'Website Design & Development', 'All the Tasks for Web Page Design and Development                                              ', 9, 'Medium', '2021-04-01'),
(5, 'Flutter App Development', 'Need to complete developing app based on quiz app               ', 3, 'Medium', '2021-03-04'),
(9, 'UI/UX', 'UI/UX Design', 2, 'High', '2021-05-07'),
(11, 'Content Writing', 'Content writing on Trending Topics', 1, 'Medium', '2021-05-06'),
(12, 'Mockup', 'Finalize logo mockup', 1, 'High', '2021-05-07'),
(13, 'Regarding Posts', 'Write and Submit Posts                        ', 9, 'High', '2021-05-05'),
(14, 'PSD to HTML Conversion', 'dfsdfdffsdsds\r\ndsfsdfqsfqsdsdggg\r\ngdgdg                                      ', 2, 'Medium', '2021-05-12'),
(15, 'Testings', 'Flutter App Testing', 1, 'High', '2021-05-08');

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

--
-- Structure de la table `visitor_data`
--

DROP TABLE IF EXISTS `visitor_data`;
CREATE TABLE IF NOT EXISTS `visitor_data` (
  `seq` int(11) NOT NULL,
  `month` varchar(30) NOT NULL,
  `year_a` varchar(30) NOT NULL,
  `year_b` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `visitor_data`
--

INSERT INTO `visitor_data` (`seq`, `month`, `year_a`, `year_b`) VALUES
(1, 'Jan', '13000', '9000'),
(2, 'Feb', '14500', '9800'),
(3, 'Mar', '13500', '9500'),
(4, 'Apr', '15000', '13000'),
(5, 'May', '15500', '17000'),
(6, 'Jun', '17650', '11000'),
(7, 'Jul', '19650', '10000'),
(8, 'Aug', '18500', '10500'),
(9, 'Sep', '18000', '15800'),
(10, 'Oct', '19500', '16800'),
(11, 'Nov', '17500', '19500'),
(12, 'Dec', '13500', '17000');
COMMIT;

/*!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 */;
