Whenever I create a new job or project on this webpage it gives me an error saying that it failed to save the data.
I wanted it to save the projects that I make or create and enter them onto the SQL database under the project_list table accordingly. I do not know what to do currently and I have tried everything I could to fix areas I thought that are creating the issue.
ajax.php
<?php
ob_start();
date_default_timezone_set("Asia/Manila");
$action = $_GET['action'];
include 'admin_class.php';
$crud = new Action();
if($action == 'login'){
$login = $crud->login();
if($login)
echo $login;
}
if($action == 'login2'){
$login = $crud->login2();
if($login)
echo $login;
}
if($action == 'logout'){
$logout = $crud->logout();
if($logout)
echo $logout;
}
if($action == 'logout2'){
$logout = $crud->logout2();
if($logout)
echo $logout;
}
if($action == 'signup'){
$save = $crud->signup();
if($save)
echo $save;
}
if($action == 'save_user'){
$save = $crud->save_user();
if($save)
echo $save;
}
if($action == 'update_user'){
$save = $crud->update_user();
if($save)
echo $save;
}
if($action == 'delete_user'){
$save = $crud->delete_user();
if($save)
echo $save;
}
if($action == 'save_project'){
$save = $crud->save_project();
if($save)
echo $save;
}
if($action == 'delete_project'){
$save = $crud->delete_project();
if($save)
echo $save;
}
if($action == 'save_client'){
$save = $crud->save_client();
if($save)
echo $save;
}
if($action == 'delete_client'){
$save = $crud->delete_client();
if($save)
echo $save;
}
if($action == 'save_task'){
$save = $crud->save_task();
if($save)
echo $save;
}
if($action == 'delete_task'){
$save = $crud->delete_task();
if($save)
echo $save;
}
if($action == 'save_progress'){
$save = $crud->save_progress();
if($save)
echo $save;
}
if($action == 'delete_progress'){
$save = $crud->delete_progress();
if($save)
echo $save;
}
if($action == 'get_report'){
$get = $crud->get_report();
if($get)
echo $get;
}
ob_end_flush();
?>
new_project.php
<?php if(!isset($conn)){ include 'db_connect.php'; } ?>
<div class="col-lg-12">
<div class="card card-outline card-primary">
<div class="card-body">
<form action="" id="manage-project">
<input type="hidden" name="id" value="<?php echo isset($id) ? $id : '' ?>">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="" class="control-label">Client Name</label>
<select class="form-control form-control-sm" name="client_id">
<option value="">Select a client</option>
<?php
$clients = $conn->query("SELECT id, client FROM client_list ORDER BY client ASC");
while ($row = $clients->fetch_assoc()) {
echo '<option value="' . $row['id'] . '" ' . (isset($client_id) && $client_id == $row['id'] ? 'selected' : '') . '>' . ucwords($row['client']) . '</option>';
}
?>
</select>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="">Status</label>
<select name="status" id="status" class="custom-select custom-select-sm">
<option value="0" <?php echo isset($status) && $status == 0 ? 'selected' : '' ?>>Work in Progress</option>
<option value="3" <?php echo isset($status) && $status == 3 ? 'selected' : '' ?>>Under Review</option>
<option value="5" <?php echo isset($status) && $status == 5 ? 'selected' : '' ?>>Done</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label for="" class="control-label">Start Date</label>
<input type="date" class="form-control form-control-sm" autocomplete="off" name="start_date" value="<?php echo isset($start_date) ? date("Y-m-d",strtotime($start_date)) : '' ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="" class="control-label">End Date</label>
<input type="date" class="form-control form-control-sm" autocomplete="off" name="end_date" value="<?php echo isset($end_date) ? date("Y-m-d",strtotime($end_date)) : '' ?>">
</div>
</div>
</div>
<div class="row">
<?php if($_SESSION['login_type'] == 1 ): ?>
<div class="col-md-6">
<div class="form-group">
<label for="" class="control-label">Partner</label>
<select class="form-control form-control-sm select2" name="manager_id">
<option></option>
<?php
$managers = $conn->query("SELECT *,concat(firstname,' ',lastname) as name FROM users where type = 1 order by concat(firstname,' ',lastname) asc ");
while($row= $managers->fetch_assoc()):
?>
<option value="<?php echo $row['id'] ?>" <?php echo isset($manager_id) && $manager_id == $row['id'] ? "selected" : '' ?>><?php echo ucwords($row['name']) ?></option>
<?php endwhile; ?>
</select>
</div>
</div>
<?php else: ?>
<input type="hidden" name="manager_id" value="<?php echo $_SESSION['login_id'] ?>">
<?php endif; ?>
<div class="col-md-6">
<div class="form-group">
<label for="" class="control-label">Audit Members</label>
<select class="form-control form-control-sm select2" name="audit_id">
<option></option>
<?php
$audit = $conn->query("SELECT *,concat(firstname,' ',lastname) as name FROM users where type = 3 order by concat(firstname,' ',lastname) asc ");
while($row= $audit->fetch_assoc()):
?>
<option value="<?php echo $row['id'] ?>" <?php echo isset($audit_id) && $audit_id == $row['id'] ? "selected" : '' ?>><?php echo ucwords($row['name']) ?></option>
<?php endwhile; ?>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-10">
</div>
</div>
</form>
</div>
<div class="card-footer border-info">
<div class="d-flex w-100 justify-content-center align-items-center">
<button class="btn btn-flat bg-gradient-primary mx-2" form="manage-project">Save</button>
<button class="btn btn-flat bg-gradient-secondary mx-2" type="button" onclick="location.href='index.php?page=project_list'">Cancel</button>
</div>
</div>
</div>
</div>
<script>
$('#manage-project').submit(function(e) {
e.preventDefault();
start_load();
$.ajax({
url: 'ajax.php?action=save_project',
data: new FormData($(this)[0]),
cache: false,
contentType: false,
processData: false,
method: 'POST',
type: 'POST',
success: function(resp) {
console.log('Response:', resp); // Log response
if (resp == 1) {
alert_toast('Data successfully saved', "success");
setTimeout(function() {
location.href = 'index.php?page=project_list';
}, 2000);
} else {
alert_toast('Failed to save data', 'danger');
}
},
error: function(xhr, status, error) {
console.error('AJAX Error:', status, error); // Log AJAX errors
}
});
});
</script>
admin_class.php
<?php
session_start();
ini_set('display_errors', 1);
Class Action {
private $db;
public function __construct() {
ob_start();
include 'db_connect.php';
$this->db = $conn;
}
function __destruct() {
$this->db->close();
ob_end_flush();
}
function login(){
extract($_POST);
$qry = $this->db->query("SELECT *,concat(firstname,' ',lastname) as name FROM users where email = '".$email."' and password = '".md5($password)."' ");
if($qry->num_rows > 0){
foreach ($qry->fetch_array() as $key => $value) {
if($key != 'password' && !is_numeric($key))
$_SESSION['login_'.$key] = $value;
}
return 1;
}else{
return 2;
}
}
function logout(){
session_destroy();
foreach ($_SESSION as $key => $value) {
unset($_SESSION[$key]);
}
header("location:login.php");
}
function login2(){
extract($_POST);
$qry = $this->db->query("SELECT *,concat(lastname,', ',firstname,' ',middlename) as name FROM students where student_code = '".$student_code."' ");
if($qry->num_rows > 0){
foreach ($qry->fetch_array() as $key => $value) {
if($key != 'password' && !is_numeric($key))
$_SESSION['rs_'.$key] = $value;
}
return 1;
}else{
return 3;
}
}
function save_user(){
extract($_POST);
$data = "";
foreach($_POST as $k => $v){
if(!in_array($k, array('id','cpass','password')) && !is_numeric($k)){
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
if(!empty($password)){
$data .= ", password=md5('$password') ";
}
$check = $this->db->query("SELECT * FROM users where email ='$email' ".(!empty($id) ? " and id != {$id} " : ''))->num_rows;
if($check > 0){
return 2;
exit;
}
if(isset($_FILES['img']) && $_FILES['img']['tmp_name'] != ''){
$fname = strtotime(date('y-m-d H:i')).'_'.$_FILES['img']['name'];
$move = move_uploaded_file($_FILES['img']['tmp_name'],'assets/uploads/'. $fname);
$data .= ", avatar = '$fname' ";
}
if(empty($id)){
$save = $this->db->query("INSERT INTO users set $data");
}else{
$save = $this->db->query("UPDATE users set $data where id = $id");
}
if($save){
return 1;
}
}
function signup(){
extract($_POST);
$data = "";
foreach($_POST as $k => $v){
if(!in_array($k, array('id','cpass')) && !is_numeric($k)){
if($k =='password'){
if(empty($v))
continue;
$v = md5($v);
}
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
$check = $this->db->query("SELECT * FROM users where email ='$email' ".(!empty($id) ? " and id != {$id} " : ''))->num_rows;
if($check > 0){
return 2;
exit;
}
if(isset($_FILES['img']) && $_FILES['img']['tmp_name'] != ''){
$fname = strtotime(date('y-m-d H:i')).'_'.$_FILES['img']['name'];
$move = move_uploaded_file($_FILES['img']['tmp_name'],'assets/uploads/'. $fname);
$data .= ", avatar = '$fname' ";
}
if(empty($id)){
$save = $this->db->query("INSERT INTO users set $data");
}else{
$save = $this->db->query("UPDATE users set $data where id = $id");
}
if($save){
if(empty($id))
$id = $this->db->insert_id;
foreach ($_POST as $key => $value) {
if(!in_array($key, array('id','cpass','password')) && !is_numeric($key))
$_SESSION['login_'.$key] = $value;
}
$_SESSION['login_id'] = $id;
if(isset($_FILES['img']) && !empty($_FILES['img']['tmp_name']))
$_SESSION['login_avatar'] = $fname;
return 1;
}
}
function update_user(){
extract($_POST);
$data = "";
foreach($_POST as $k => $v){
if(!in_array($k, array('id','cpass','table','password')) && !is_numeric($k)){
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
$check = $this->db->query("SELECT * FROM users where email ='$email' ".(!empty($id) ? " and id != {$id} " : ''))->num_rows;
if($check > 0){
return 2;
exit;
}
if(isset($_FILES['img']) && $_FILES['img']['tmp_name'] != ''){
$fname = strtotime(date('y-m-d H:i')).'_'.$_FILES['img']['name'];
$move = move_uploaded_file($_FILES['img']['tmp_name'],'assets/uploads/'. $fname);
$data .= ", avatar = '$fname' ";
}
if(!empty($password))
$data .= " ,password=md5('$password') ";
if(empty($id)){
$save = $this->db->query("INSERT INTO users set $data");
}else{
$save = $this->db->query("UPDATE users set $data where id = $id");
}
if($save){
foreach ($_POST as $key => $value) {
if($key != 'password' && !is_numeric($key))
$_SESSION['login_'.$key] = $value;
}
if(isset($_FILES['img']) && !empty($_FILES['img']['tmp_name']))
$_SESSION['login_avatar'] = $fname;
return 1;
}
}
function delete_user(){
extract($_POST);
$delete = $this->db->query("DELETE FROM users where id = ".$id);
if($delete)
return 1;
}
function save_system_settings(){
extract($_POST);
$data = '';
foreach($_POST as $k => $v){
if(!is_numeric($k)){
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
if($_FILES['cover']['tmp_name'] != ''){
$fname = strtotime(date('y-m-d H:i')).'_'.$_FILES['cover']['name'];
$move = move_uploaded_file($_FILES['cover']['tmp_name'],'../assets/uploads/'. $fname);
$data .= ", cover_img = '$fname' ";
}
$chk = $this->db->query("SELECT * FROM system_settings");
if($chk->num_rows > 0){
$save = $this->db->query("UPDATE system_settings set $data where id =".$chk->fetch_array()['id']);
}else{
$save = $this->db->query("INSERT INTO system_settings set $data");
}
if($save){
foreach($_POST as $k => $v){
if(!is_numeric($k)){
$_SESSION['system'][$k] = $v;
}
}
if($_FILES['cover']['tmp_name'] != ''){
$_SESSION['system']['cover_img'] = $fname;
}
return 1;
}
}
function save_image(){
extract($_FILES['file']);
if(!empty($tmp_name)){
$fname = strtotime(date("Y-m-d H:i"))."_".(str_replace(" ","-",$name));
$move = move_uploaded_file($tmp_name,'assets/uploads/'. $fname);
$protocol = strtolower(substr($_SERVER["SERVER_PROTOCOL"],0,5))=='https'?'https':'http';
$hostName = $_SERVER['HTTP_HOST'];
$path =explode('/',$_SERVER['PHP_SELF']);
$currentPath = '/'.$path[1];
if($move){
return $protocol.'://'.$hostName.$currentPath.'/assets/uploads/'.$fname;
}
}
}
function save_project() {
extract($_POST);
$data = array();
// Use prepared statements to avoid SQL injection
$stmt = $this->db->prepare("INSERT INTO project_list (name, description, status, start_date, end_date, manager_id, user_ids) VALUES (?, ?, ?, ?, ?, ?, ?)");
$description = htmlentities(str_replace("'", "’", $description));
$user_ids = isset($user_ids) ? implode(',', $user_ids) : '';
$stmt->bind_param("ssissii", $name, $description, $status, $start_date, $end_date, $manager_id, $user_ids);
if ($stmt->execute()) {
return 1;
} else {
// Log SQL error details
error_log("SQL Error: " . $this->db->error);
return "Failed to save project: " . $this->db->error;
}
}
function save_client(){
extract($_POST);
$data = "";
foreach($_POST as $k => $v){
if(!in_array($k, array('id')) && !is_numeric($k)){
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
if(empty($id)){
$save = $this->db->query("INSERT INTO client_list SET $data");
}else{
$save = $this->db->query("UPDATE client_list SET $data WHERE id = $id");
}
if($save){
return 1;
} else {
return 0;
}
}
function delete_project(){
extract($_POST);
$delete = $this->db->query("DELETE FROM project_list where id = $id");
if($delete){
return 1;
}
}
function delete_client(){
extract($_POST);
$delete = $this->db->query("DELETE FROM client_list WHERE id = $id");
if($delete){
return 1;
}
}
function save_task(){
extract($_POST);
$data = "";
foreach($_POST as $k => $v){
if(!in_array($k, array('id')) && !is_numeric($k)){
if($k == 'description')
$v = htmlentities(str_replace("'","’",$v));
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
if(empty($id)){
$save = $this->db->query("INSERT INTO task_list set $data");
}else{
$save = $this->db->query("UPDATE task_list set $data where id = $id");
}
if($save){
return 1;
}
}
function delete_task(){
extract($_POST);
$delete = $this->db->query("DELETE FROM task_list where id = $id");
if($delete){
return 1;
}
}
function save_progress(){
extract($_POST);
$data = "";
foreach($_POST as $k => $v){
if(!in_array($k, array('id')) && !is_numeric($k)){
if($k == 'comment')
$v = htmlentities(str_replace("'","’",$v));
if(empty($data)){
$data .= " $k='$v' ";
}else{
$data .= ", $k='$v' ";
}
}
}
$dur = abs(strtotime("2020-01-01 ".$end_time)) - abs(strtotime("2020-01-01 ".$start_time));
$dur = $dur / (60 * 60);
$data .= ", time_rendered='$dur' ";
// echo "INSERT INTO user_productivity set $data"; exit;
if(empty($id)){
$data .= ", user_id={$_SESSION['login_id']} ";
$save = $this->db->query("INSERT INTO user_productivity set $data");
}else{
$save = $this->db->query("UPDATE user_productivity set $data where id = $id");
}
if($save){
return 1;
}
}
function delete_progress(){
extract($_POST);
$delete = $this->db->query("DELETE FROM user_productivity where id = $id");
if($delete){
return 1;
}
}
function get_report(){
extract($_POST);
$data = array();
$get = $this->db->query("SELECT t.*,p.name as ticket_for FROM ticket_list t inner join pricing p on p.id = t.pricing_id where date(t.date_created) between '$date_from' and '$date_to' order by unix_timestamp(t.date_created) desc ");
while($row= $get->fetch_assoc()){
$row['date_created'] = date("M d, Y",strtotime($row['date_created']));
$row['name'] = ucwords($row['name']);
$row['adult_price'] = number_format($row['adult_price'],2);
$row['child_price'] = number_format($row['child_price'],2);
$row['amount'] = number_format($row['amount'],2);
$data[]=$row;
}
return json_encode($data);
}
}
tms_db.sql
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 03, 2020 at 08:37 AM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 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 */;
--
-- Database: `tms_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `project_list`
--
CREATE TABLE `client_list` (
`id` int(30) NOT NULL,
`client` text NOT NULL,
`mail` varchar(200) NOT NULL,
`box` text NOT NULL,
`code` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `project_list`
--
INSERT INTO `client_list` (`id`, `client`, `mail`, `box`, `code`) VALUES
(1, 'Mangrove Matrix', '[email protected]', '00100-21685', 'M-77-A'),
(2, 'Manda Matrix', '[email protected]', '00100-26645', 'M-79-A');
-- --------------------------------------------------------
--
-- Table structure for table `project_list`
--
CREATE TABLE `project_list` (
`id` int(30) NOT NULL,
`name` varchar(200) NOT NULL,
`description` text NOT NULL,
`status` tinyint(2) NOT NULL,
`start_date` date NOT NULL,
`end_date` date NOT NULL,
`manager_id` int(30) NOT NULL,
`user_ids` text NOT NULL,
`date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `project_list`
--
INSERT INTO `project_list` (`id`, `name`, `description`, `status`, `start_date`, `end_date`, `manager_id`, `user_ids`, `date_created`) VALUES
(1, 'sample', 'Sample Only', 0, '2020-11-03', '2021-01-20', 2, '3,4,5', '2020-12-03 09:56:56'),
(2, 'sample', 'Sample Only', 0, '2020-12-02', '2020-12-31', 2, '3', '2020-12-03 13:51:54');
-- --------------------------------------------------------
--
-- Table structure for table `system_settings`
--
CREATE TABLE `system_settings` (
`id` int(30) NOT NULL,
`name` text NOT NULL,
`email` varchar(200) NOT NULL,
`contact` varchar(20) NOT NULL,
`address` text NOT NULL,
`cover_img` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `system_settings`
--
INSERT INTO `system_settings` (`id`, `name`, `email`, `contact`, `address`, `cover_img`) VALUES
(1, 'Task Management System', '[email protected]', '+6948 8542 623', '2102 Caldwell Road, Rochester, New York, 14608', '');
-- --------------------------------------------------------
--
-- Table structure for table `task_list`
--
CREATE TABLE `task_list` (
`id` int(30) NOT NULL,
`project_id` int(30) NOT NULL,
`task` varchar(200) NOT NULL,
`description` text NOT NULL,
`status` tinyint(4) NOT NULL,
`date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `task_list`
--
INSERT INTO `task_list` (`id`, `project_id`, `task`, `description`, `status`, `date_created`) VALUES
(1, 1, 'Sample Task 1', ' <span style="color: rgb(0, 0, 0); font-family: "Open Sans", Arial, sans-serif; font-size: 14px; text-align: justify;">Fusce ullamcorper mattis semper. Nunc vel risus ipsum. Sed maximus dapibus nisl non laoreet. Pellentesque quis mauris odio. Donec fermentum facilisis odio, sit amet aliquet purus scelerisque eget. </span> ', 3, '2020-12-03 11:08:58'),
(2, 1, 'Sample Task 2', 'Sample Task 2 ', 1, '2020-12-03 13:50:15'),
(3, 2, 'Task Test', 'Sample', 1, '2020-12-03 13:52:25'),
(4, 2, 'test 23', 'Sample test 23', 1, '2020-12-03 13:52:40');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(30) NOT NULL,
`firstname` varchar(200) NOT NULL,
`lastname` varchar(200) NOT NULL,
`email` varchar(200) NOT NULL,
`password` text NOT NULL,
`type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = admin, 2 = staff',
`avatar` text NOT NULL DEFAULT 'no-image-available.png',
`date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `password`, `type`, `avatar`, `date_created`) VALUES
(1, 'Assif', 'Din', 'assif', '1234', 1, 'no-image-available.png', '2020-11-26 10:57:04'),
(2, 'Amrita', 'Virdee', 'amrita', '1234', 2, 'no-image-available.png', '2020-12-03 09:26:03'),
(3, 'Tirth', 'Patel', '1366', '1234', 3, 'no-image-available.png', '2020-12-03 09:26:42'),
(5, 'Mohammed', 'Yassin', '1367', '1234', 3, 'no-image-available.png', '2020-12-03 10:47:06');
-- --------------------------------------------------------
--
-- Table structure for table `user_productivity`
--
CREATE TABLE `user_productivity` (
`id` int(30) NOT NULL,
`project_id` int(30) NOT NULL,
`task_id` int(30) NOT NULL,
`comment` text NOT NULL,
`subject` varchar(200) NOT NULL,
`date` date NOT NULL,
`start_time` time NOT NULL,
`end_time` time NOT NULL,
`user_id` int(30) NOT NULL,
`time_rendered` float NOT NULL,
`date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `user_productivity`
--
INSERT INTO `user_productivity` (`id`, `project_id`, `task_id`, `comment`, `subject`, `date`, `start_time`, `end_time`, `user_id`, `time_rendered`, `date_created`) VALUES
(1, 1, 1, ' <p>Sample Progress</p><ul><li>Test 1</li><li>Test 2</li><li>Test 3</li></ul> ', 'Sample Progress', '2020-12-03', '08:00:00', '10:00:00', 1, 2, '2020-12-03 12:13:28'),
(2, 1, 1, ' Sample Progress ', 'Sample Progress 2', '2020-12-03', '13:00:00', '14:00:00', 1, 1, '2020-12-03 13:48:28'),
(3, 1, 2, ' Sample ', 'Test', '2020-12-03', '08:00:00', '09:00:00', 5, 1, '2020-12-03 13:57:22'),
(4, 1, 2, 'asdasdasd', 'Sample Progress', '2020-12-02', '08:00:00', '10:00:00', 2, 2, '2020-12-03 14:36:30');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `client_list`
--
ALTER TABLE `client_list`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `project_list`
--
ALTER TABLE `project_list`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `task_list`
--
ALTER TABLE `task_list`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user_productivity`
--
ALTER TABLE `user_productivity`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `client_list`
--
ALTER TABLE `client_list`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `project_list`
--
ALTER TABLE `project_list`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `system_settings`
--
ALTER TABLE `system_settings`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `task_list`
--
ALTER TABLE `task_list`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `user_productivity`
--
ALTER TABLE `user_productivity`
MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
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 */;