-- https://www.phpmyadmin.net
--




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

--
-- Table structure for table `assignproject`
--

CREATE TABLE IF NOT EXISTS `assignproject` (
  `id` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `userid` varchar(255) NOT NULL,
  `total` varchar(250) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assignproject`
--

INSERT INTO `assignproject` (`id`, `projectid`, `userid`, `total`, `created`) VALUES
(1, 2, '2,3,4', '200', '2022-03-07 10:04:27'),
(2, 4, '2,3,4', '500', '2022-03-07 10:28:05'),
(3, 5, '3,4,6', '123', '2022-03-07 10:28:18'),
(4, 10, '2,3,4,5,6', '450', '2022-03-07 10:28:34'),
(5, 11, '3,4,5', '15', '2022-03-11 04:15:27');

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

--
-- Table structure for table `project`
--

CREATE TABLE IF NOT EXISTS `project` (
  `id` int(11) NOT NULL,
  `project` text NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project`
--

INSERT INTO `project` (`id`, `project`, `created`) VALUES
(2, 'test', '2022-02-21 08:36:27'),
(4, 'testtt', '2022-02-17 06:41:15'),
(5, 'tew', '2022-02-17 06:43:54'),
(6, 'teswe', '2022-02-21 12:18:57'),
(7, 'erwe', '2022-02-21 12:26:15'),
(8, 'test32dd', '2022-02-21 12:34:53'),
(9, 'rdfpromject', '2022-02-23 12:32:58'),
(10, 'rfc project', '2022-03-03 09:43:56'),
(11, 'hardware protocol', '2022-03-11 04:14:40'),
(12, 'file format', '2022-03-11 04:55:24'),
(13, 'vlsi', '2022-03-11 04:55:36'),
(14, 'application', '2022-03-11 04:55:53'),
(15, 'frent end', '2022-03-11 04:56:06');

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

--
-- Table structure for table `report`
--

CREATE TABLE IF NOT EXISTS `report` (
  `id` int(11) NOT NULL,
  `projectid` int(11) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `entry` varchar(100) NOT NULL,
  `balanced` int(11) NOT NULL,
  `completed` int(11) NOT NULL,
  `total` int(11) NOT NULL,
  `entrydate` date NOT NULL,
  `enter time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report`
--

INSERT INTO `report` (`id`, `projectid`, `userid`, `entry`, `balanced`, `completed`, `total`, `entrydate`, `enter time`) VALUES
(1, 11, '3,4,5', '12,56,23', 12, 56, 565, '2022-03-01', '2022-03-16 12:22:51'),
(2, 11, '3,4', '2,4', 65, 69, 2, '2022-03-02', '2022-03-16 12:25:04');

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

--
-- Table structure for table `sumentrybyreport`
--

CREATE TABLE IF NOT EXISTS `sumentrybyreport` (
  `id` int(11) NOT NULL,
  `reportid` int(11) NOT NULL,
  `completed` int(11) NOT NULL,
  `balanced` int(11) NOT NULL,
  `total` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sumentrybyreport`
--

INSERT INTO `sumentrybyreport` (`id`, `reportid`, `completed`, `balanced`, `total`) VALUES
(1, 1, 4, 43, 3);

--
-- Indexes for table `assignproject`
--
ALTER TABLE `assignproject`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `project`
--
ALTER TABLE `project`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `report`
--
ALTER TABLE `report`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sumentrybyreport`
--
ALTER TABLE `sumentrybyreport`
  ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for table `assignproject`
--
ALTER TABLE `assignproject`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `project`
--
ALTER TABLE `project`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `report`
--
ALTER TABLE `report`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `sumentrybyreport`
--
ALTER TABLE `sumentrybyreport`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
