ROUTE_SQL

/*
SQLyog Ultimate v9.51
MySQL - 5.1.53-community : Database - track
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`track` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `track`;

/*Table structure for table `admin_users` */

DROP TABLE IF EXISTS `admin_users`;

CREATE TABLE `admin_users` (
  `a_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `a_username` VARCHAR(60) NOT NULL,
  `a_password` VARCHAR(64) NOT NULL,
  `a_name` VARCHAR(60) NOT NULL,
  `a_email` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `admin_users` */

INSERT  INTO `admin_users`(`a_id`,`a_username`,`a_password`,`a_name`,`a_email`) VALUES (1,'admin','7b902e6ff1db9f560443f2048974fd7d386975b0','mws admin','mws@gmail.com'),(2,'hjdgh','a6b8b600c27ce95ddcf867cfc503564c89fe816a','ghj','hkh@gmail.com'),(3,'admin12','7b902e6ff1db9f560443f2048974fd7d386975b0','ad min','ad@gmail.com');

/*Table structure for table `driver_route` */

DROP TABLE IF EXISTS `driver_route`;

CREATE TABLE `driver_route` (
  `d_id` BIGINT(20) UNSIGNED NOT NULL,
  `route_id` BIGINT(20) UNSIGNED NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` VARCHAR(10) NOT NULL,
  KEY `d_id` (`d_id`),
  KEY `d_id_2` (`d_id`),
  KEY `d_id_3` (`d_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `driver_route` */

/*Table structure for table `drivers` */

DROP TABLE IF EXISTS `drivers`;

CREATE TABLE `drivers` (
  `d_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `d_username` VARCHAR(60) NOT NULL,
  `d_password` VARCHAR(64) NOT NULL,
  `d_name` VARCHAR(60) NOT NULL,
  `d_contact_no` VARCHAR(15) NOT NULL,
  `d_vehicle_number` VARCHAR(15) NOT NULL,
  `d_address` VARCHAR(500) NOT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `drivers` */

INSERT  INTO `drivers`(`d_id`,`d_username`,`d_password`,`d_name`,`d_contact_no`,`d_vehicle_number`,`d_address`) VALUES (1,'john12','9631c1ef976a1d3c728f1b10ced27243631943ff','John k','9988778899','4mariuei434','hello'),(2,'jack','3e4f460cd80c65b5333c528a8e37e72ed56eb9d6','Jack k','9966775544','ojfrwo67677','bangalore');

/*Table structure for table `route_stop` */

DROP TABLE IF EXISTS `route_stop`;

CREATE TABLE `route_stop` (
  `route_id` BIGINT(20) UNSIGNED NOT NULL,
  `stop_id` BIGINT(20) UNSIGNED NOT NULL,
  `stop_position` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `route_stop` */

INSERT  INTO `route_stop`(`route_id`,`stop_id`,`stop_position`) VALUES (8,16,1),(8,17,2),(9,18,1),(9,19,2),(9,20,3);

/*Table structure for table `routes` */

DROP TABLE IF EXISTS `routes`;

CREATE TABLE `routes` (
  `route_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `route_name` VARCHAR(20) NOT NULL,
  `total_stop` INT(20) NOT NULL,
  PRIMARY KEY (`route_id`),
  KEY `route_id` (`route_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

/*Data for the table `routes` */

INSERT  INTO `routes`(`route_id`,`route_name`,`total_stop`) VALUES (7,'root3',0),(8,'root5',2),(9,'root6',3);

/*Table structure for table `stops` */

DROP TABLE IF EXISTS `stops`;

CREATE TABLE `stops` (
  `stop_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `stop_name` VARCHAR(15) NOT NULL,
  `stop_address` VARCHAR(100) NOT NULL,
  `stop_latitude` DOUBLE(17,14) NOT NULL,
  `stop_longitude` DOUBLE(17,14) NOT NULL,
  `stop_status` VARCHAR(10) NOT NULL,
  PRIMARY KEY (`stop_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

/*Data for the table `stops` */

INSERT  INTO `stops`(`stop_id`,`stop_name`,`stop_address`,`stop_latitude`,`stop_longitude`,`stop_status`) VALUES (13,'stop1','National Highway 3, Sikandar Pur, Uttar Pradesh 283124, India',27.01080818040833,77.99213647842407,'Active'),(14,'hjghjgh','National Highway 3, Birai, Uttar Pradesh 283124, India',26.98572376319716,77.94269800186157,'Active'),(15,'stop6','MDR 130W, Dhimsiri, Uttar Pradesh 283125, India',27.01753719389000,78.17890405654910,'Active'),(16,'stop5','MDR 127W, Naraul, Uttar Pradesh 283119, India',27.04750699403400,77.80124902725220,'Active'),(17,'agara','Nai basti, Rakabganj, Agra, Uttar Pradesh, India',27.17280401607547,78.01616907119751,'Active'),(18,'mwa','MDR 130W, Dhimsiri, Uttar Pradesh 283125, India',26.98021667890923,78.18714380264282,'Active'),(19,'dwe','Fatehabad Road, Dauki, Uttar Pradesh 283111, India',27.11781284232123,78.22422266006473,'Active'),(20,'Gamari','State Highway 39, Uttar Pradesh 283102, India',27.11047864179215,77.92209863662720,'Active');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;