· 9 years ago · Jan 12, 2017, 09:16 AM
1-- Adminer 4.2.5 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8CREATE DATABASE `isign_data` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
9USE `isign_data`;
10
11DROP TABLE IF EXISTS `out_train`;
12CREATE TABLE `out_train` (
13 `id` int(11) NOT NULL AUTO_INCREMENT,
14 `code` int(11) NOT NULL,
15 `target` varchar(35) COLLATE utf8_bin NOT NULL,
16 `time` varchar(35) COLLATE utf8_bin NOT NULL,
17 `line_number` varchar(10) COLLATE utf8_bin NOT NULL,
18 `platform_number` varchar(10) COLLATE utf8_bin NOT NULL,
19 `status` varchar(35) COLLATE utf8_bin NOT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
22
23INSERT INTO `out_train` (`id`, `code`, `target`, `time`, `line_number`, `platform_number`, `status`) VALUES
24(1, 119, 'تهران', '11:00', '1', '1', 'مساÙرگیری'),
25(2, 120, 'شاهرود', '13:30', '-', '-', 'منتظر اعلام'),
26(3, 121, 'سمنان', '13:30', '-', '-', 'منتظر اعلام'),
27(4, 122, 'تبریز', '14:30', '-', '-', 'منتظر اعلام'),
28(5, 123, 'تبریز', '16:30', '1', '2', 'با تاخیر'),
29(6, 124, 'بندرعباس', '17:30', '-', '-', 'منتظر اعلام');
30
31-- 2017-01-12 12:40:20