-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_salaries.sql
56 lines (49 loc) · 3.55 KB
/
create_salaries.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
CREATE DATABASE IF NOT EXISTS `testdb` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `testdb`;
-- MySQL dump 10.13 Distrib 8.0.34, for Linux (x86_64)
--
-- Host: 172.17.0.2 Database: testdb
-- ------------------------------------------------------
-- Server version 8.1.0
/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `salaries`
--
DROP TABLE IF EXISTS `salaries`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `salaries` (
`id` int NOT NULL AUTO_INCREMENT,
`hourly_pay` decimal(4,2) NOT NULL,
`employee_id` int NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_salaries_employee` (`employee_id`),
CONSTRAINT `fk_salaries_employee` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `salaries`
--
LOCK TABLES `salaries` WRITE;
/*!40000 ALTER TABLE `salaries` DISABLE KEYS */;
INSERT INTO `salaries` VALUES (1,36.25,1),(2,32.30,2),(3,49.38,3),(4,20.64,4),(5,60.32,5),(6,23.75,6),(7,78.19,7),(8,37.60,8),(9,32.64,9),(10,54.65,10),(11,48.84,11),(12,22.01,12),(13,64.52,13),(14,48.41,14),(15,62.15,15),(16,40.51,16),(17,65.99,17),(18,58.96,18),(19,58.92,19),(20,66.53,20),(21,72.91,21),(22,22.53,22),(23,73.18,23),(24,70.58,24),(25,56.30,25),(26,40.52,26),(27,20.97,27),(28,39.35,28),(29,69.05,29),(30,29.35,30),(31,19.46,31),(32,50.73,32),(33,62.96,33),(34,73.97,34),(35,24.72,35),(36,72.43,36),(37,49.09,37),(38,37.58,38),(39,70.64,39),(40,64.02,40),(41,33.83,41),(42,78.03,42),(43,74.08,43),(44,60.31,44),(45,32.58,45),(46,77.15,46),(47,26.52,47),(48,36.47,48),(49,38.18,49),(50,58.78,50),(51,77.03,51),(52,70.18,52),(53,70.93,53),(54,64.15,54),(55,22.95,55),(56,44.85,56),(57,23.01,57),(58,67.88,58),(59,69.25,59),(60,76.86,60),(61,78.94,61),(62,67.70,62),(63,59.38,63),(64,78.75,64),(65,25.53,65),(66,18.29,66),(67,64.89,67),(68,71.32,68),(69,67.54,69),(70,40.28,70),(71,62.99,71),(72,38.59,72),(73,25.40,73),(74,16.89,74),(75,19.67,75),(76,23.28,76),(77,15.23,77),(78,71.48,78),(79,60.57,79),(80,66.07,80),(81,68.10,81),(82,79.03,82),(83,50.58,83),(84,54.88,84),(85,63.14,85),(86,33.55,86),(87,68.74,87),(88,27.21,88),(89,42.64,89),(90,16.18,90),(91,70.34,91),(92,44.06,92),(93,24.59,93),(94,55.03,94),(95,77.13,95),(96,21.81,96),(97,50.93,97),(98,75.14,98),(99,55.65,99),(100,64.67,100);
/*!40000 ALTER TABLE `salaries` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2023-09-09 12:10:19