-- phpMyAdmin SQL Dump -- version 4.7.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 30, 2019 at 12:23 PM -- Server version: 10.1.26-MariaDB -- PHP Version: 7.1.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!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: `teachers` -- -- -------------------------------------------------------- -- -- Table structure for table `city` -- CREATE TABLE `city` ( `Id` int(11) NOT NULL, `name` varchar(140) NOT NULL, `spendsId` int(11) NOT NULL, `insert_by` varchar(84) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `city` -- INSERT INTO `city` (`Id`, `name`, `spendsId`, `insert_by`, `created_at`) VALUES (2, 'city', 3, 'admin', '2019-05-08 03:36:03'); -- -------------------------------------------------------- -- -- Table structure for table `classes` -- CREATE TABLE `classes` ( `Id` int(11) NOT NULL, `name` varchar(128) NOT NULL, `name_ar` varchar(128) NOT NULL, `name_fr` varchar(128) NOT NULL, `insert_by` varchar(128) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `classes` -- INSERT INTO `classes` (`Id`, `name`, `name_ar`, `name_fr`, `insert_by`, `created_at`) VALUES (1, 'test', 'test ar', 'test fr', 'admin', '2019-05-04 06:14:55'), (2, 'Classes 2', 'Classes 2 ', 'Classes 2', 'admin', '2019-05-08 03:38:15'), (3, 'Classes 2', 'Classes 2', 'Classes 2', 'admin', '2019-05-08 03:38:22'); -- -------------------------------------------------------- -- -- Table structure for table `classes_teacher` -- CREATE TABLE `classes_teacher` ( `Id` int(11) NOT NULL, `teacher_Id` int(11) NOT NULL, `class_Id` int(11) NOT NULL, `insert_at` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `classes_teacher` -- INSERT INTO `classes_teacher` (`Id`, `teacher_Id`, `class_Id`, `insert_at`) VALUES (1, 15, 1, 2019), (2, 15, 2, 2019), (3, 15, 3, 2019); -- -------------------------------------------------------- -- -- Table structure for table `education` -- CREATE TABLE `education` ( `Id` int(11) NOT NULL, `name` varchar(128) NOT NULL, `name_ar` varchar(128) NOT NULL, `name_fr` varchar(128) NOT NULL, `insert_by` varchar(128) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `education` -- INSERT INTO `education` (`Id`, `name`, `name_ar`, `name_fr`, `insert_by`, `created_at`) VALUES (1, 'Education', 'Education', 'Education', 'admin', '2019-05-13 06:23:59'); -- -------------------------------------------------------- -- -- Table structure for table `experience` -- CREATE TABLE `experience` ( `Id` int(11) NOT NULL, `name` varchar(128) NOT NULL, `name_ar` varchar(128) NOT NULL, `name_fr` varchar(128) NOT NULL, `insert_by` varchar(128) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `experience` -- INSERT INTO `experience` (`Id`, `name`, `name_ar`, `name_fr`, `insert_by`, `created_at`) VALUES (1, '0-2', '0-2', '0-2', 'admin', '2019-05-16 05:25:57'), (2, '2-5', '2-5', '2-5', 'admin', '2019-05-16 05:55:46'); -- -------------------------------------------------------- -- -- Table structure for table `governorate` -- CREATE TABLE `governorate` ( `Id` int(11) NOT NULL, `name` varchar(140) NOT NULL, `insert_by` varchar(84) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `governorate` -- INSERT INTO `governorate` (`Id`, `name`, `insert_by`, `created_at`) VALUES (1, 'TEST', 'admin', '2019-04-23 09:15:00'), (2, 'Governorate', 'admin', '2019-05-08 03:35:23'); -- -------------------------------------------------------- -- -- Table structure for table `language` -- CREATE TABLE `language` ( `Id` int(11) NOT NULL, `name` varchar(128) NOT NULL, `name_ar` varchar(128) NOT NULL, `name_fr` varchar(128) NOT NULL, `insert_by` varchar(128) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `language` -- INSERT INTO `language` (`Id`, `name`, `name_ar`, `name_fr`, `insert_by`, `created_at`) VALUES (1, 'test', 'test', 'test', 'admin', '2019-05-14 03:16:02'), (2, 'test 2', 'test 3 ', 'test 4', 'admin', '2019-05-14 03:16:14'); -- -------------------------------------------------------- -- -- Table structure for table `language_teacher` -- CREATE TABLE `language_teacher` ( `Id` int(11) NOT NULL, `languageId` varchar(128) NOT NULL, `teacherId` varchar(128) NOT NULL, `insert_by` varchar(128) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `language_teacher` -- INSERT INTO `language_teacher` (`Id`, `languageId`, `teacherId`, `insert_by`, `created_at`) VALUES (1, '1', '10', 'admin', '2019-05-14 03:20:36'), (2, '2', '10', 'admin', '2019-05-14 03:20:36'), (3, '1', '11', 'admin', '2019-05-17 01:24:12'), (4, '2', '11', 'admin', '2019-05-17 01:24:12'), (5, '1', '12', 'admin', '2019-05-17 01:29:44'), (6, '2', '12', 'admin', '2019-05-17 01:29:44'), (7, '1', '13', 'admin', '2019-05-17 01:30:47'), (8, '2', '13', 'admin', '2019-05-17 01:30:47'), (9, '1', '14', 'admin', '2019-05-17 01:31:01'), (10, '2', '14', 'admin', '2019-05-17 01:31:01'), (11, '1', '15', 'admin', '2019-06-30 12:05:44'), (12, '2', '15', 'admin', '2019-06-30 12:05:44'); -- -------------------------------------------------------- -- -- Table structure for table `spends` -- CREATE TABLE `spends` ( `Id` int(11) NOT NULL, `name` varchar(140) NOT NULL, `governorateId` int(11) NOT NULL, `insert_by` varchar(84) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `spends` -- INSERT INTO `spends` (`Id`, `name`, `governorateId`, `insert_by`, `created_at`) VALUES (1, 'test', 1, 'admin', '2019-04-23 10:10:15'), (2, 'test 2', 1, 'admin', '2019-04-23 10:10:58'), (3, 'Spend', 2, 'admin', '2019-05-08 03:35:38'); -- -------------------------------------------------------- -- -- Table structure for table `teacher` -- CREATE TABLE `teacher` ( `Id` int(11) NOT NULL, `name` varchar(256) NOT NULL, `phone` varchar(32) NOT NULL, `email` varchar(128) NOT NULL, `experienceId` int(11) NOT NULL, `educationId` int(11) NOT NULL, `cityId` int(11) NOT NULL, `facebook` text NOT NULL, `twitter` text NOT NULL, `instagram` text NOT NULL, `linkedin` text NOT NULL, `display` int(1) NOT NULL, `insert_by` varchar(128) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `teacher` -- INSERT INTO `teacher` (`Id`, `name`, `phone`, `email`, `experienceId`, `educationId`, `cityId`, `facebook`, `twitter`, `instagram`, `linkedin`, `display`, `insert_by`, `created_at`) VALUES (15, '1', '2', '3@g.s', 1, 1, 2, '4', '6', '7', '5', 0, 'admin', '2019-06-30 12:05:44'); -- -- Indexes for dumped tables -- -- -- Indexes for table `city` -- ALTER TABLE `city` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `classes` -- ALTER TABLE `classes` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `classes_teacher` -- ALTER TABLE `classes_teacher` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `education` -- ALTER TABLE `education` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `experience` -- ALTER TABLE `experience` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `governorate` -- ALTER TABLE `governorate` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `language` -- ALTER TABLE `language` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `language_teacher` -- ALTER TABLE `language_teacher` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `spends` -- ALTER TABLE `spends` ADD PRIMARY KEY (`Id`); -- -- Indexes for table `teacher` -- ALTER TABLE `teacher` ADD PRIMARY KEY (`Id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `city` -- ALTER TABLE `city` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `classes` -- ALTER TABLE `classes` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `classes_teacher` -- ALTER TABLE `classes_teacher` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `education` -- ALTER TABLE `education` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `experience` -- ALTER TABLE `experience` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `governorate` -- ALTER TABLE `governorate` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `language` -- ALTER TABLE `language` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `language_teacher` -- ALTER TABLE `language_teacher` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `spends` -- ALTER TABLE `spends` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `teacher` -- ALTER TABLE `teacher` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; 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 */;