Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement