-- 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 */;
