mc_zefirka

Database: `test_db`

Apr 4th, 2021
553
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.3
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1:3306
  6. -- Generation Time: Mar 31, 2021 at 06:50 PM
  7. -- Server version: 5.6.41
  8. -- PHP Version: 5.5.38
  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. -- Database: `test_db`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `univer`
  29. --
  30.  
  31. CREATE TABLE `univer` (
  32.   `ID` int(11) NOT NULL,
  33.   `name` varchar(32) NOT NULL,
  34.   `location` varchar(128) NOT NULL,
  35.   `rate` decimal(10,1) NOT NULL
  36. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  37.  
  38. --
  39. -- Dumping data for table `univer`
  40. --
  41.  
  42. INSERT INTO `univer` (`ID`, `name`, `location`, `rate`) VALUES
  43. (1, 'BSUIR', 'Minsk', '5.0'),
  44. (2, 'BNTU', 'Minsk', '4.0');
  45.  
  46. --
  47. -- Indexes for dumped tables
  48. --
  49.  
  50. --
  51. -- Indexes for table `univer`
  52. --
  53. ALTER TABLE `univer`
  54.   ADD PRIMARY KEY (`ID`);
  55.  
  56. --
  57. -- AUTO_INCREMENT for dumped tables
  58. --
  59.  
  60. --
  61. -- AUTO_INCREMENT for table `univer`
  62. --
  63. ALTER TABLE `univer`
  64.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  65. COMMIT;
  66.  
  67. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  68. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  69. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  70.  
  71.  
  72.  
  73.  
  74. ---------------------------------------------------------------------------------------------
  75.  
  76. -- phpMyAdmin SQL Dump
  77. -- version 4.8.3
  78. -- https://www.phpmyadmin.net/
  79. --
  80. -- Host: 127.0.0.1:3306
  81. -- Generation Time: Mar 31, 2021 at 06:51 PM
  82. -- Server version: 5.6.41
  83. -- PHP Version: 5.5.38
  84.  
  85. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  86. SET AUTOCOMMIT = 0;
  87. START TRANSACTION;
  88. SET time_zone = "+00:00";
  89.  
  90.  
  91. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  92. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  93. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  94. /*!40101 SET NAMES utf8mb4 */;
  95.  
  96. --
  97. -- Database: `test_db`
  98. --
  99.  
  100. -- --------------------------------------------------------
  101.  
  102. --
  103. -- Table structure for table `students`
  104. --
  105.  
  106. CREATE TABLE `students` (
  107.   `STUDENT_ID` int(11) NOT NULL,
  108.   `name` varchar(32) NOT NULL,
  109.   `course` int(11) NOT NULL DEFAULT '1',
  110.   `avg` decimal(10,1) NOT NULL,
  111.   `age` int(11) NOT NULL,
  112.   `B_Date` date NOT NULL,
  113.   `UNIVER_ID` int(11) NOT NULL,
  114.   `Created_TS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
  115. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  116.  
  117. --
  118. -- Dumping data for table `students`
  119. --
  120.  
  121. INSERT INTO `students` (`STUDENT_ID`, `name`, `course`, `avg`, `age`, `B_Date`, `UNIVER_ID`, `Created_TS`) VALUES
  122. (1, 'Mary', 2, '7.2', 22, '2021-03-01', 1, '2021-03-22 18:02:09'),
  123. (2, 'Jack', 1, '8.4', 21, '2021-03-03', 2, '2021-03-22 18:02:42');
  124.  
  125. --
  126. -- Indexes for dumped tables
  127. --
  128.  
  129. --
  130. -- Indexes for table `students`
  131. --
  132. ALTER TABLE `students`
  133.   ADD PRIMARY KEY (`STUDENT_ID`),
  134.   ADD KEY `STUDENTS_FK_UNIVER` (`UNIVER_ID`);
  135.  
  136. --
  137. -- AUTO_INCREMENT for dumped tables
  138. --
  139.  
  140. --
  141. -- AUTO_INCREMENT for table `students`
  142. --
  143. ALTER TABLE `students`
  144.   MODIFY `STUDENT_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  145.  
  146. --
  147. -- Constraints for dumped tables
  148. --
  149.  
  150. --
  151. -- Constraints for table `students`
  152. --
  153. ALTER TABLE `students`
  154.   ADD CONSTRAINT `STUDENTS_FK_UNIVER` FOREIGN KEY (`UNIVER_ID`) REFERENCES `univer` (`ID`);
  155. COMMIT;
  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 */;
  160.  
  161.  
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×