SHARE
TWEET

Untitled

a guest Dec 6th, 2019 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.9.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Gazdă: 127.0.0.1
  6. -- Timp de generare: dec. 06, 2019 la 10:05 AM
  7. -- Versiune server: 10.4.8-MariaDB
  8. -- Versiune PHP: 7.3.11
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET 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. -- Bază de date: `laborator`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Structură tabel pentru tabel `discipline`
  29. --
  30.  
  31. CREATE TABLE `discipline` (
  32.   `id` int(11) NOT NULL,
  33.   `nume` text NOT NULL
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  35.  
  36. --
  37. -- Eliminarea datelor din tabel `discipline`
  38. --
  39.  
  40. INSERT INTO `discipline` (`id`, `nume`) VALUES
  41. (4, 'Matematica'),
  42. (5, 'E-Marketing');
  43.  
  44. -- --------------------------------------------------------
  45.  
  46. --
  47. -- Structură tabel pentru tabel `medii`
  48. --
  49.  
  50. CREATE TABLE `medii` (
  51.   `id` int(11) NOT NULL,
  52.   `medie` double NOT NULL,
  53.   `iddisciplina` int(11) NOT NULL,
  54.   `idstudent` int(11) NOT NULL
  55. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  56.  
  57. --
  58. -- Eliminarea datelor din tabel `medii`
  59. --
  60.  
  61. INSERT INTO `medii` (`id`, `medie`, `iddisciplina`, `idstudent`) VALUES
  62. (4, 8.5, 4, 4),
  63. (5, 9.5, 5, 4);
  64.  
  65. -- --------------------------------------------------------
  66.  
  67. --
  68. -- Structură tabel pentru tabel `note`
  69. --
  70.  
  71. CREATE TABLE `note` (
  72.   `id` int(11) NOT NULL,
  73.   `data` date NOT NULL,
  74.   `iddisciplina` int(11) NOT NULL,
  75.   `idstudent` int(11) NOT NULL,
  76.   `nota` double NOT NULL
  77. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  78.  
  79. --
  80. -- Eliminarea datelor din tabel `note`
  81. --
  82.  
  83. INSERT INTO `note` (`id`, `data`, `iddisciplina`, `idstudent`, `nota`) VALUES
  84. (6, '2109-12-05', 4, 4, 9),
  85. (7, '2109-12-06', 4, 4, 8),
  86. (8, '2109-12-06', 5, 4, 10),
  87. (9, '2109-12-06', 5, 4, 9);
  88.  
  89. -- --------------------------------------------------------
  90.  
  91. --
  92. -- Structură tabel pentru tabel `student`
  93. --
  94.  
  95. CREATE TABLE `student` (
  96.   `id` int(11) NOT NULL,
  97.   `nume` text NOT NULL,
  98.   `varsta` int(11) NOT NULL,
  99.   `media` double NOT NULL
  100. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  101.  
  102. --
  103. -- Eliminarea datelor din tabel `student`
  104. --
  105.  
  106. INSERT INTO `student` (`id`, `nume`, `varsta`, `media`) VALUES
  107. (4, 'Vancea Corina', 22, 9),
  108. (5, 'Mutter Roland', 23, 10);
  109.  
  110. --
  111. -- Indexuri pentru tabele eliminate
  112. --
  113.  
  114. --
  115. -- Indexuri pentru tabele `discipline`
  116. --
  117. ALTER TABLE `discipline`
  118.   ADD PRIMARY KEY (`id`);
  119.  
  120. --
  121. -- Indexuri pentru tabele `medii`
  122. --
  123. ALTER TABLE `medii`
  124.   ADD PRIMARY KEY (`id`);
  125.  
  126. --
  127. -- Indexuri pentru tabele `note`
  128. --
  129. ALTER TABLE `note`
  130.   ADD PRIMARY KEY (`id`);
  131.  
  132. --
  133. -- Indexuri pentru tabele `student`
  134. --
  135. ALTER TABLE `student`
  136.   ADD PRIMARY KEY (`id`);
  137.  
  138. --
  139. -- AUTO_INCREMENT pentru tabele eliminate
  140. --
  141.  
  142. --
  143. -- AUTO_INCREMENT pentru tabele `discipline`
  144. --
  145. ALTER TABLE `discipline`
  146.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  147.  
  148. --
  149. -- AUTO_INCREMENT pentru tabele `medii`
  150. --
  151. ALTER TABLE `medii`
  152.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  153.  
  154. --
  155. -- AUTO_INCREMENT pentru tabele `note`
  156. --
  157. ALTER TABLE `note`
  158.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  159.  
  160. --
  161. -- AUTO_INCREMENT pentru tabele `student`
  162. --
  163. ALTER TABLE `student`
  164.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  165. COMMIT;
  166.  
  167. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  168. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  169. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top