avatar
Untitled

Guest 42 15th Jan, 2020

MARKUP 3.00 KB
                                           
                         -- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 15.01.2020 klo 10:58
-- Palvelimen versio: 10.4.11-MariaDB
-- PHP Version: 7.4.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
/*!40101 SET @[email protected]@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `hamssfi_tunti`
--

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

--
-- Rakenne taululle `work`
--

CREATE TABLE `work` (
  `WorkID` int(11) NOT NULL,
  `UserID` int(11) NOT NULL,
  `Dates` int(11) NOT NULL,
  `Startime` int(6) NOT NULL,
  `Endtime` int(6) NOT NULL,
  `Duration` int(6) NOT NULL,
  `Description` varchar(200) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
  `Employer` varchar(30) CHARACTER SET utf8 COLLATE utf8_swedish_ci DEFAULT NULL,
  `Worknumber` varchar(30) CHARACTER SET utf8 COLLATE utf8_swedish_ci DEFAULT NULL,
  `Status` varchar(20) CHARACTER SET utf8 COLLATE utf8_swedish_ci DEFAULT 'Avoin',
  `Salary` tinyint(1) NOT NULL DEFAULT 0,
  `Checked` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Vedos taulusta `work`
--

INSERT INTO `work` (`WorkID`, `UserID`, `Dates`, `Startime`, `Endtime`, `Duration`, `Description`, `Employer`, `Worknumber`, `Status`, `Salary`, `Checked`) VALUES
(376, 15, 1579734000, 405, 885, 480, 'Final test', NULL, NULL, 'Avoin', 0, 0),
(377, 15, 1577919600, 390, 570, 180, 'terpal', '', '', 'Avoin', 1, 1),
(378, 22, 1579129200, 420, 600, 180, 'Teest form 6', '', '', 'Avoin', 1, 1),
(379, 22, 1579215600, 540, 600, 60, 'Testi testi 2020202', '', '', 'Avoin', 1, 1),
(380, 22, 1579042800, 390, 510, 120, 'Test eero', '', '', 'Avoin', 1, 1),
(381, 22, 1579474800, 375, 735, 360, 'testetetesrt', '', '', 'Avoin', 1, 1),
(382, 22, 1581548400, 405, 915, 510, 'xcxfxcfx', '', '', 'Avoin', 0, 1),
(383, 23, 1579302000, 480, 930, 450, 'test2ääää', NULL, NULL, 'Avoin', 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `work`
--
ALTER TABLE `work`
  ADD PRIMARY KEY (`WorkID`),
  ADD KEY `UserID` (`UserID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `work`
--
ALTER TABLE `work`
  MODIFY `WorkID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=384;

--
-- Rajoitteet vedostauluille
--

--
-- Rajoitteet taululle `work`
--
ALTER TABLE `work`
  ADD CONSTRAINT `work_ibfk_1` FOREIGN KEY (`UserID`) REFERENCES `user` (`UserID`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

/*!40101 SET [email protected]_CHARACTER_SET_CLIENT */;
/*!40101 SET [email protected]_CHARACTER_SET_RESULTS */;
/*!40101 SET [email protected]_COLLATION_CONNECTION */;
                      
                                       
To share this paste please copy this url and send to your friends
RAW Paste Data
Recent Pastes