SQL/iekstudents.sql at main · SynergOps/SQL · GitHub

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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
-- Copyright (c) 2025, Salih Emin
-- License: GPL-3.0
-- Generation Time: May 22, 2025 at 11:24 AM
-- Server version: 10.11.11-MariaDB-ubu2204
-- PHP Version: 8.2.28

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

/*!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: `iekstudents`
--
CREATE DATABASE IF NOT EXISTS `iekstudents` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `iekstudents`;
--
--

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

--
-- Table structure for table `dinners`
--
DROP TABLE IF EXISTS `dinners`;
CREATE TABLE `dinners` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` varchar(30) DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `entree` varchar(30) DEFAULT NULL,
  `side` varchar(30) DEFAULT NULL,
  `dessert` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dinners`
--
DROP TABLE IF EXISTS `tourneys`;
INSERT INTO `dinners` (`id`, `name`, `birthdate`, `entree`, `side`, `dessert`) VALUES
(1, 'Manolis', '2003-01-19', 'steak', 'salad', 'cake'),
(2, 'Thanos', '2003-01-25', 'chicken', 'fries', 'ice cream'),
(3, 'Sara', '2005-02-18', 'tofu', 'fries', 'cake'),
(4, 'Elpida', '2004-12-25', 'tofu', 'salad', 'ice cream'),
(5, 'Georgia', '2006-05-28', 'steak', 'fries', 'ice cream'),
(6, 'Sali', '1990-01-01', 'chicken', 'fries', 'ice cream');
COMMIT;
-- --------------------------------------------------------

--
-- Table structure for table `tourneys`
--
DROP TABLE IF EXISTS `tourneys`;
CREATE TABLE `tourneys` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `NAME` varchar(30) DEFAULT NULL,
  `wins` double DEFAULT NULL,
  `best` double DEFAULT NULL,
  `size` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tourneys`
--

INSERT INTO `tourneys` (`id`, `NAME`, `wins`, `best`, `size`) VALUES
(1, 'Manolis', 7, 245, 44),
(2, 'Thanos', 4, 280, 45),
(3, 'Sara', 9, 266, 38),
(4, 'Elpida', 2, 200, 37),
(5, 'Georgia', 2, 197, 37),
(6, 'Sali', 13, 283, 46);
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 */;