Advertisement
AviEzerzer

Untitled

Apr 20th, 2018
336
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 17.59 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.0.1
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Apr 20, 2018 at 11:05 AM
  7. -- Server version: 10.1.28-MariaDB
  8. -- PHP Version: 7.1.10
  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: `schoolcrm2`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `courses`
  29. --
  30.  
  31. CREATE TABLE `courses` (
  32.   `id` int(5) NOT NULL,
  33.   `name` varchar(50) NOT NULL,
  34.   `description` text NOT NULL,
  35.   `start_date` date NOT NULL,
  36.   `end_date` date NOT NULL,
  37.   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  38.   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  39.   `active` tinyint(1) NOT NULL DEFAULT '1',
  40.   `added_by` varchar(50) NOT NULL
  41. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  42.  
  43. --
  44. -- Dumping data for table `courses`
  45. --
  46.  
  47. INSERT INTO `courses` (`id`, `name`, `description`, `start_date`, `end_date`, `created_at`, `updated_at`, `active`, `added_by`) VALUES
  48. (1, 'Course test 2', 'Course test 2 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus sodales sapien non posuere blandit. Mauris et mauris in nibh condimentum pellentesque et at leo. Sed tristique, magna sagittis semper commodo, quam lorem euismod tellus, ac mattis neque leo sit amet velit. Sed consectetur varius varius. Duis justo quam, lacinia vel suscipit vitae, commodo sed lorem. Etiam eu turpis at lectus feugiat sagittis. Pellentesque auctor et nisi ac congue. Mauris malesuada pretium sem ac tincidunt. Suspendisse ornare orci vel sapien rutrum blandit. Mauris sed mattis eros. Fusce vitae enim blandit est porta viverra.\r\n\r\nDonec a eros vel est viverra vehicula faucibus at erat. Pellentesque pretium vel nisi vitae vestibulum. Etiam sapien sapien, pellentesque vitae lectus at, tempor fringilla urna. Aenean nibh lorem, venenatis a justo in, interdum varius sapien. Vestibulum dignissim eros turpis, at scelerisque elit semper sed. In in pulvinar diam. Aliquam gravida interdum urna quis malesuada. Donec tristique nisi gravida odio porttitor ullamcorper. Praesent elit ex, venenatis vel congue sit amet, sagittis ac metus.\r\n\r\nEtiam porta felis purus, nec pellentesque ex egestas a. Nunc nec eros vel purus pulvinar porttitor. Aliquam ac gravida erat. Vivamus consectetur odio vel magna maximus, in egestas arcu tincidunt. Donec rutrum nisl sapien, ac pulvinar est fringilla a. Vivamus scelerisque ante nulla, quis pharetra nisi lacinia a. Sed luctus augue eu aliquet ullamcorper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.\r\n\r\nQuisque aliquet risus ut quam laoreet molestie. Ut eget convallis lacus, a imperdiet nibh. Sed euismod consequat lectus ut elementum. Vestibulum congue enim arcu, ac tristique augue auctor vel. Maecenas maximus maximus laoreet. Donec fermentum dolor non sapien congue tempus. Ut sem velit, euismod nec felis sed, convallis eleifend diam. Duis porta vitae erat eu volutpat. Praesent sed vehicula odio.\r\n\r\nDonec ac sagittis enim, eget interdum mauris. Mauris vel mauris pulvinar, tincidunt nunc eget, cursus dolor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut volutpat sit amet neque in scelerisque. Nullam efficitur turpis mauris, sit amet suscipit sem vestibulum et. Vestibulum nibh nisl, ultricies a diam vel, tempor eleifend dui. In hac habitasse platea dictumst. Curabitur quis eros ut erat ornare bibendum. Nulla neque massa, semper nec consectetur ac, fermentum sit amet mi.', '2018-04-19', '2018-04-30', '2018-04-20 06:50:58', '2018-04-20 06:50:58', 1, 'tester mcnuts'),
  49. (2, 'Course test 3', 'Course test 3 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus sodales sapien non posuere blandit. Mauris et mauris in nibh condimentum pellentesque et at leo. Sed tristique, magna sagittis semper commodo, quam lorem euismod tellus, ac mattis neque leo sit amet velit. Sed consectetur varius varius. Duis justo quam, lacinia vel suscipit vitae, commodo sed lorem. Etiam eu turpis at lectus feugiat sagittis. Pellentesque auctor et nisi ac congue. Mauris malesuada pretium sem ac tincidunt. Suspendisse ornare orci vel sapien rutrum blandit. Mauris sed mattis eros. Fusce vitae enim blandit est porta viverra.\r\n\r\nDonec a eros vel est viverra vehicula faucibus at erat. Pellentesque pretium vel nisi vitae vestibulum. Etiam sapien sapien, pellentesque vitae lectus at, tempor fringilla urna. Aenean nibh lorem, venenatis a justo in, interdum varius sapien. Vestibulum dignissim eros turpis, at scelerisque elit semper sed. In in pulvinar diam. Aliquam gravida interdum urna quis malesuada. Donec tristique nisi gravida odio porttitor ullamcorper. Praesent elit ex, venenatis vel congue sit amet, sagittis ac metus.\r\n\r\nEtiam porta felis purus, nec pellentesque ex egestas a. Nunc nec eros vel purus pulvinar porttitor. Aliquam ac gravida erat. Vivamus consectetur odio vel magna maximus, in egestas arcu tincidunt. Donec rutrum nisl sapien, ac pulvinar est fringilla a. Vivamus scelerisque ante nulla, quis pharetra nisi lacinia a. Sed luctus augue eu aliquet ullamcorper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.\r\n\r\nQuisque aliquet risus ut quam laoreet molestie. Ut eget convallis lacus, a imperdiet nibh. Sed euismod consequat lectus ut elementum. Vestibulum congue enim arcu, ac tristique augue auctor vel. Maecenas maximus maximus laoreet. Donec fermentum dolor non sapien congue tempus. Ut sem velit, euismod nec felis sed, convallis eleifend diam. Duis porta vitae erat eu volutpat. Praesent sed vehicula odio.\r\n\r\nDonec ac sagittis enim, eget interdum mauris. Mauris vel mauris pulvinar, tincidunt nunc eget, cursus dolor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut volutpat sit amet neque in scelerisque. Nullam efficitur turpis mauris, sit amet suscipit sem vestibulum et. Vestibulum nibh nisl, ultricies a diam vel, tempor eleifend dui. In hac habitasse platea dictumst. Curabitur quis eros ut erat ornare bibendum. Nulla neque massa, semper nec consectetur ac, fermentum sit amet mi.', '2018-04-19', '2018-04-30', '2018-04-20 06:50:58', '2018-04-20 06:50:58', 1, 'tester mcnuts'),
  50. (3, 'Course test 4', 'Course test 4 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus sodales sapien non posuere blandit. Mauris et mauris in nibh condimentum pellentesque et at leo. Sed tristique, magna sagittis semper commodo, quam lorem euismod tellus, ac mattis neque leo sit amet velit. Sed consectetur varius varius. Duis justo quam, lacinia vel suscipit vitae, commodo sed lorem. Etiam eu turpis at lectus feugiat sagittis. Pellentesque auctor et nisi ac congue. Mauris malesuada pretium sem ac tincidunt. Suspendisse ornare orci vel sapien rutrum blandit. Mauris sed mattis eros. Fusce vitae enim blandit est porta viverra.\r\n\r\nDonec a eros vel est viverra vehicula faucibus at erat. Pellentesque pretium vel nisi vitae vestibulum. Etiam sapien sapien, pellentesque vitae lectus at, tempor fringilla urna. Aenean nibh lorem, venenatis a justo in, interdum varius sapien. Vestibulum dignissim eros turpis, at scelerisque elit semper sed. In in pulvinar diam. Aliquam gravida interdum urna quis malesuada. Donec tristique nisi gravida odio porttitor ullamcorper. Praesent elit ex, venenatis vel congue sit amet, sagittis ac metus.\r\n\r\nEtiam porta felis purus, nec pellentesque ex egestas a. Nunc nec eros vel purus pulvinar porttitor. Aliquam ac gravida erat. Vivamus consectetur odio vel magna maximus, in egestas arcu tincidunt. Donec rutrum nisl sapien, ac pulvinar est fringilla a. Vivamus scelerisque ante nulla, quis pharetra nisi lacinia a. Sed luctus augue eu aliquet ullamcorper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.\r\n\r\nQuisque aliquet risus ut quam laoreet molestie. Ut eget convallis lacus, a imperdiet nibh. Sed euismod consequat lectus ut elementum. Vestibulum congue enim arcu, ac tristique augue auctor vel. Maecenas maximus maximus laoreet. Donec fermentum dolor non sapien congue tempus. Ut sem velit, euismod nec felis sed, convallis eleifend diam. Duis porta vitae erat eu volutpat. Praesent sed vehicula odio.\r\n\r\nDonec ac sagittis enim, eget interdum mauris. Mauris vel mauris pulvinar, tincidunt nunc eget, cursus dolor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut volutpat sit amet neque in scelerisque. Nullam efficitur turpis mauris, sit amet suscipit sem vestibulum et. Vestibulum nibh nisl, ultricies a diam vel, tempor eleifend dui. In hac habitasse platea dictumst. Curabitur quis eros ut erat ornare bibendum. Nulla neque massa, semper nec consectetur ac, fermentum sit amet mi.', '2018-04-19', '2018-04-30', '2018-04-20 06:50:58', '2018-04-20 06:50:58', 1, 'tester mcnuts'),
  51. (4, 'Course test 5', 'Course test 5 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus sodales sapien non posuere blandit. Mauris et mauris in nibh condimentum pellentesque et at leo. Sed tristique, magna sagittis semper commodo, quam lorem euismod tellus, ac mattis neque leo sit amet velit. Sed consectetur varius varius. Duis justo quam, lacinia vel suscipit vitae, commodo sed lorem. Etiam eu turpis at lectus feugiat sagittis. Pellentesque auctor et nisi ac congue. Mauris malesuada pretium sem ac tincidunt. Suspendisse ornare orci vel sapien rutrum blandit. Mauris sed mattis eros. Fusce vitae enim blandit est porta viverra.\r\n\r\nDonec a eros vel est viverra vehicula faucibus at erat. Pellentesque pretium vel nisi vitae vestibulum. Etiam sapien sapien, pellentesque vitae lectus at, tempor fringilla urna. Aenean nibh lorem, venenatis a justo in, interdum varius sapien. Vestibulum dignissim eros turpis, at scelerisque elit semper sed. In in pulvinar diam. Aliquam gravida interdum urna quis malesuada. Donec tristique nisi gravida odio porttitor ullamcorper. Praesent elit ex, venenatis vel congue sit amet, sagittis ac metus.\r\n\r\nEtiam porta felis purus, nec pellentesque ex egestas a. Nunc nec eros vel purus pulvinar porttitor. Aliquam ac gravida erat. Vivamus consectetur odio vel magna maximus, in egestas arcu tincidunt. Donec rutrum nisl sapien, ac pulvinar est fringilla a. Vivamus scelerisque ante nulla, quis pharetra nisi lacinia a. Sed luctus augue eu aliquet ullamcorper. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos.\r\n\r\nQuisque aliquet risus ut quam laoreet molestie. Ut eget convallis lacus, a imperdiet nibh. Sed euismod consequat lectus ut elementum. Vestibulum congue enim arcu, ac tristique augue auctor vel. Maecenas maximus maximus laoreet. Donec fermentum dolor non sapien congue tempus. Ut sem velit, euismod nec felis sed, convallis eleifend diam. Duis porta vitae erat eu volutpat. Praesent sed vehicula odio.\r\n\r\nDonec ac sagittis enim, eget interdum mauris. Mauris vel mauris pulvinar, tincidunt nunc eget, cursus dolor. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut volutpat sit amet neque in scelerisque. Nullam efficitur turpis mauris, sit amet suscipit sem vestibulum et. Vestibulum nibh nisl, ultricies a diam vel, tempor eleifend dui. In hac habitasse platea dictumst. Curabitur quis eros ut erat ornare bibendum. Nulla neque massa, semper nec consectetur ac, fermentum sit amet mi.', '2018-04-19', '2018-04-30', '2018-04-20 06:50:58', '2018-04-20 06:50:58', 1, 'tester mcnuts');
  52.  
  53. -- --------------------------------------------------------
  54.  
  55. --
  56. -- Table structure for table `enrollments`
  57. --
  58.  
  59. CREATE TABLE `enrollments` (
  60.   `id` int(5) NOT NULL,
  61.   `student_id` int(11) NOT NULL,
  62.   `course_id` int(11) NOT NULL,
  63.   `user_id` int(11) DEFAULT NULL,
  64.   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  65.   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  66.   `student_active` tinyint(1) NOT NULL DEFAULT '1',
  67.   `course_active` tinyint(1) NOT NULL DEFAULT '1',
  68.   `added_by` varchar(50) NOT NULL
  69. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  70.  
  71. --
  72. -- Dumping data for table `enrollments`
  73. --
  74.  
  75. INSERT INTO `enrollments` (`id`, `student_id`, `course_id`, `user_id`, `created_at`, `updated_at`, `student_active`, `course_active`, `added_by`) VALUES
  76. (1, 1, 1, 1, '2018-04-20 07:16:00', '2018-04-20 07:16:00', 1, 1, 'tester'),
  77. (2, 1, 2, 1, '2018-04-20 07:16:00', '2018-04-20 07:16:00', 1, 1, 'tester'),
  78. (3, 2, 2, 3, '2018-04-20 07:16:00', '2018-04-20 07:16:00', 1, 1, 'tester');
  79.  
  80. -- --------------------------------------------------------
  81.  
  82. --
  83. -- Table structure for table `students`
  84. --
  85.  
  86. CREATE TABLE `students` (
  87.   `id` int(5) NOT NULL,
  88.   `email` varchar(40) NOT NULL,
  89.   `name` varchar(30) NOT NULL,
  90.   `phone` varchar(30) NOT NULL,
  91.   `password` varchar(255) NOT NULL,
  92.   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  93.   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  94.   `active` tinyint(1) NOT NULL DEFAULT '1',
  95.   `added_by` varchar(50) NOT NULL
  96. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  97.  
  98. --
  99. -- Dumping data for table `students`
  100. --
  101.  
  102. INSERT INTO `students` (`id`, `email`, `name`, `phone`, `password`, `created_at`, `updated_at`, `active`, `added_by`) VALUES
  103. (1, 'test1@ts.ts', 'test one student', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  104. (2, 'test2@ts.ts', 'test two student', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  105. (3, 'test3@ts.ts', 'test three student', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  106. (4, 'test4@ts.ts', 'test four student', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  107. (5, 'test5@ts.ts', 'test five student', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself');
  108.  
  109. -- --------------------------------------------------------
  110.  
  111. --
  112. -- Table structure for table `users`
  113. --
  114.  
  115. CREATE TABLE `users` (
  116.   `id` int(5) NOT NULL,
  117.   `email` varchar(50) NOT NULL,
  118.   `name` varchar(50) NOT NULL,
  119.   `phone` varchar(30) NOT NULL,
  120.   `password` varchar(255) NOT NULL,
  121.   `role` enum('1','2','3') DEFAULT NULL,
  122.   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  123.   `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  124.   `active` tinyint(1) NOT NULL DEFAULT '1',
  125.   `added_by` varchar(50) NOT NULL
  126. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  127.  
  128. --
  129. -- Dumping data for table `users`
  130. --
  131.  
  132. INSERT INTO `users` (`id`, `email`, `name`, `phone`, `password`, `role`, `created_at`, `updated_at`, `active`, `added_by`) VALUES
  133. (1, 'test1@ts.ts', 'test one user', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '1', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  134. (2, 'test2@ts.ts', 'test two user', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '2', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  135. (3, 'test3@ts.ts', 'test three user', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '3', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  136. (4, 'test4@ts.ts', 'test four user', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '1', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself'),
  137. (5, 'test5@ts.ts', 'test five user', '0505556677', '$2y$10$S7.v0IVAKy9Mah3gdSBpae1GXciYyFInx8VHIP9ocYI5/q9ieGKbOv', '1', '2018-04-20 06:50:57', '2018-04-20 06:50:57', 1, 'himself');
  138.  
  139. --
  140. -- Indexes for dumped tables
  141. --
  142.  
  143. --
  144. -- Indexes for table `courses`
  145. --
  146. ALTER TABLE `courses`
  147.   ADD PRIMARY KEY (`id`),
  148.   ADD KEY `course_active` (`active`),
  149.   ADD KEY `c_active` (`active`);
  150.  
  151. --
  152. -- Indexes for table `enrollments`
  153. --
  154. ALTER TABLE `enrollments`
  155.   ADD PRIMARY KEY (`id`),
  156.   ADD KEY `enrollments_to_courses` (`course_active`),
  157.   ADD KEY `enrollments_to_students` (`student_active`);
  158.  
  159. --
  160. -- Indexes for table `students`
  161. --
  162. ALTER TABLE `students`
  163.   ADD PRIMARY KEY (`id`),
  164.   ADD UNIQUE KEY `email` (`email`),
  165.   ADD KEY `student_active` (`active`),
  166.   ADD KEY `s_active` (`active`);
  167.  
  168. --
  169. -- Indexes for table `users`
  170. --
  171. ALTER TABLE `users`
  172.   ADD PRIMARY KEY (`id`),
  173.   ADD UNIQUE KEY `email` (`email`);
  174.  
  175. --
  176. -- AUTO_INCREMENT for dumped tables
  177. --
  178.  
  179. --
  180. -- AUTO_INCREMENT for table `courses`
  181. --
  182. ALTER TABLE `courses`
  183.   MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  184.  
  185. --
  186. -- AUTO_INCREMENT for table `enrollments`
  187. --
  188. ALTER TABLE `enrollments`
  189.   MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  190.  
  191. --
  192. -- AUTO_INCREMENT for table `students`
  193. --
  194. ALTER TABLE `students`
  195.   MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  196.  
  197. --
  198. -- AUTO_INCREMENT for table `users`
  199. --
  200. ALTER TABLE `users`
  201.   MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  202.  
  203. --
  204. -- Constraints for dumped tables
  205. --
  206.  
  207. --
  208. -- Constraints for table `enrollments`
  209. --
  210. ALTER TABLE `enrollments`
  211.   ADD CONSTRAINT `enrollments_to_courses` FOREIGN KEY (`course_active`) REFERENCES `courses` (`active`) ON UPDATE CASCADE,
  212.   ADD CONSTRAINT `enrollments_to_students` FOREIGN KEY (`student_active`) REFERENCES `students` (`active`) ON UPDATE CASCADE;
  213. COMMIT;
  214.  
  215. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  216. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  217. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement