· 6 years ago · Sep 21, 2019, 11:30 AM
1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3306
6-- Généré le : jeu. 19 sep. 2019 à 16:42
7-- Version du serveur : 5.7.26
8-- Version de PHP : 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données : `ecole`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `course`
29--
30
31DROP TABLE IF EXISTS `course`;
32CREATE TABLE IF NOT EXISTS `course` (
33 `id` varchar(10) COLLATE utf8_latvian_ci NOT NULL,
34 `title` varchar(50) COLLATE utf8_latvian_ci NOT NULL,
35 `credits` decimal(2,0) NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
38
39--
40-- Déchargement des données de la table `course`
41--
42
43INSERT INTO `course` (`id`, `title`, `credits`) VALUES
44('CAI1', 'Communication anglophone contextualisée I', '2'),
45('CAIG3', 'Communication anglophone contextualisée', '3'),
46('CPT1', 'Comptabilité contextualisée I', '2'),
47('DEV1', 'Développement I', '10'),
48('DEV2', 'Développement II', '10'),
49('DON2', 'Persistance des données I', '5'),
50('DRTG3', 'Droit et philosophie contextualisés', '2'),
51('INT1', 'Introductions', '10'),
52('MAT1', 'Mathématique contextualisée', '6'),
53('SYS2', 'Systèmes d\"exploitation I', '5'),
54('STA2', 'Statistique contextualisée', '3');
55
56-- --------------------------------------------------------
57
58--
59-- Structure de la table `program`
60--
61
62DROP TABLE IF EXISTS `program`;
63CREATE TABLE IF NOT EXISTS `program` (
64 `id` decimal(10,0) NOT NULL,
65 `student` decimal(10,0) NOT NULL,
66 `course` varchar(10) COLLATE utf8_latvian_ci NOT NULL,
67 PRIMARY KEY (`id`),
68 KEY `StudentFK` (`student`),
69 KEY `CourseFK` (`course`)
70) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
71
72--
73-- Déchargement des données de la table `program`
74--
75
76INSERT INTO `program` (`id`, `student`, `course`) VALUES
77('1', '1', 'INT1'),
78('2', '1', 'DEV1'),
79('3', '1', 'MAT1'),
80('4', '1', 'CAI1'),
81('5', '1', 'CPT1'),
82('6', '1', 'STA2'),
83('7', '1', 'DEV2'),
84('8', '1', 'DON2'),
85('9', '1', 'SYS2'),
86('11', '16', 'INT1'),
87('12', '16', 'DEV1'),
88('13', '16', 'MAT1'),
89('14', '16', 'CAI1'),
90('15', '16', 'CPT1'),
91('16', '16', 'STA2'),
92('17', '16', 'DEV2'),
93('18', '16', 'DON2'),
94('19', '16', 'SYS2'),
95('22', '25', 'DEV1'),
96('23', '25', 'MAT1'),
97('24', '25', 'CAI1'),
98('25', '25', 'CPT1'),
99('26', '25', 'STA2'),
100('27', '25', 'DEV2'),
101('28', '25', 'DON2'),
102('29', '25', 'SYS2'),
103('30', '25', 'CAIG3'),
104('31', '25', 'DRTG3'),
105('41', '52', 'INT1'),
106('42', '52', 'DEV1'),
107('43', '52', 'MAT1'),
108('44', '52', 'CAI1'),
109('45', '52', 'CPT1'),
110('46', '52', 'STA2'),
111('47', '52', 'DEV2'),
112('48', '52', 'DON2'),
113('49', '52', 'SYS2'),
114('50', '52', 'CAIG3'),
115('51', '52', 'DRTG3'),
116('66', '114', 'STA2'),
117('67', '114', 'DEV2'),
118('68', '114', 'DON2'),
119('69', '114', 'SYS2');
120
121-- --------------------------------------------------------
122
123--
124-- Structure de la table `student`
125--
126
127DROP TABLE IF EXISTS `student`;
128CREATE TABLE IF NOT EXISTS `student` (
129 `id` decimal(10,0) NOT NULL,
130 `name` varchar(20) COLLATE utf8_latvian_ci NOT NULL,
131 PRIMARY KEY (`id`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_latvian_ci;
133
134--
135-- Déchargement des données de la table `student`
136--
137
138INSERT INTO `student` (`id`, `name`) VALUES
139('1', 'Bulbizarre'),
140('16', 'Roucool'),
141('25', 'Pikachu'),
142('52', 'Miaouss'),
143('114', 'Saquedeneu'),
144('128', 'Tauros'),
145('143', 'Ronflex');
146
147-- --------------------------------------------------------
148
149--
150-- Contraintes pour la table `program`
151--
152ALTER TABLE `program`
153 ADD CONSTRAINT `CourseFK` FOREIGN KEY (`course`) REFERENCES `course` (`id`),
154 ADD CONSTRAINT `StudentFK` FOREIGN KEY (`student`) REFERENCES `student` (`id`);
155COMMIT;
156
157/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
158/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
159/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;