API tools faq
paste
Advertisement
Guest User

Sisters DB

a guest
Jun 6th, 2017
138
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 19.04 KB | None | 0 0
raw download clone embed print report
  1. -- --------------------------------------------------------
  2. -- Хост:                         ricky.heliohost.org
  3. -- Версия сервера:               5.6.35 - MySQL Community Server (GPL)
  4. -- Операционная система:         Linux
  5. -- HeidiSQL Версия:              9.4.0.5125
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14.  
  15. -- Дамп структуры базы данных evesst_database
  16. CREATE DATABASE IF NOT EXISTS `evesst_database` /*!40100 DEFAULT CHARACTER SET latin1 */;
  17. USE `evesst_database`;
  18.  
  19. -- Дамп структуры для функция evesst_database.regionCreate
  20. DELIMITER //
  21. //
  22. DELIMITER ;
  23.  
  24. -- Дамп структуры для таблица evesst_database.regions
  25. CREATE TABLE IF NOT EXISTS `regions` (
  26.   `id` int(11) NOT NULL AUTO_INCREMENT,
  27.   `name` varchar(30) NOT NULL,
  28.   PRIMARY KEY (`id`)
  29. ) ENGINE=InnoDB AUTO_INCREMENT=10000065 DEFAULT CHARSET=utf8;
  30.  
  31. -- Дамп данных таблицы evesst_database.regions: ~8 rows (приблизительно)
  32. /*!40000 ALTER TABLE `regions` DISABLE KEYS */;
  33. INSERT INTO `regions` (`id`, `name`) VALUES
  34.     (1, 'Unknown space'),
  35.     (10, 'testRegion'),
  36.     (10000002, 'The Forge'),
  37.     (10000016, 'Lonetrek'),
  38.     (10000025, 'Immensea'),
  39.     (10000033, 'The Citadel'),
  40.     (10000043, 'Domain'),
  41.     (10000064, 'Essence');
  42. /*!40000 ALTER TABLE `regions` ENABLE KEYS */;
  43.  
  44. -- Дамп структуры для функция evesst_database.sigNameByByteCode
  45. DELIMITER //
  46. //
  47. DELIMITER ;
  48.  
  49. -- Дамп структуры для функция evesst_database.sigNameByName
  50. DELIMITER //
  51. //
  52. DELIMITER ;
  53.  
  54. -- Дамп структуры для функция evesst_database.signatureCreate
  55. DELIMITER //
  56. //
  57. DELIMITER ;
  58.  
  59. -- Дамп структуры для таблица evesst_database.signatures
  60. CREATE TABLE IF NOT EXISTS `signatures` (
  61.   `id` int(11) NOT NULL AUTO_INCREMENT,
  62.   `systemID` int(11) NOT NULL,
  63.   `code` varchar(7) NOT NULL,
  64.   `typeID` int(11) NOT NULL,
  65.   `nameID` int(11) NOT NULL,
  66.   `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  67.   `lastCheck` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  68.   PRIMARY KEY (`id`),
  69.   KEY `system` (`systemID`,`code`),
  70.   KEY `signatures_ibfk_2` (`typeID`),
  71.   KEY `signatures_ibfk_3` (`nameID`),
  72.   CONSTRAINT `signatures_ibfk_1` FOREIGN KEY (`systemID`) REFERENCES `systems` (`id`) ON DELETE CASCADE,
  73.   CONSTRAINT `signatures_ibfk_2` FOREIGN KEY (`typeID`) REFERENCES `signaturestypes` (`id`) ON DELETE CASCADE,
  74.   CONSTRAINT `signatures_ibfk_3` FOREIGN KEY (`nameID`) REFERENCES `signaturesnames` (`id`) ON DELETE CASCADE
  75. ) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;
  76.  
  77. -- Дамп данных таблицы evesst_database.signatures: ~104 rows (приблизительно)
  78. /*!40000 ALTER TABLE `signatures` DISABLE KEYS */;
  79. INSERT INTO `signatures` (`id`, `systemID`, `code`, `typeID`, `nameID`, `created`, `lastCheck`) VALUES
  80.     (1, 1, 'AAA-000', 2, 6, '2017-06-02 15:57:41', '2017-06-03 16:45:04'),
  81.     (18, 8, 'AAA-000', 1, 2, '2017-05-31 01:32:21', '2017-05-31 01:32:21'),
  82.     (19, 8, 'AAA-001', 1, 2, '2017-06-02 17:09:44', '2017-06-02 17:09:44'),
  83.     (20, 30005017, 'TQW-503', 1, 5, '2017-06-02 17:15:12', '2017-06-02 17:15:12'),
  84.     (21, 31001118, 'TVG-946', 1, 5, '2017-06-02 17:16:08', '2017-06-02 17:16:08'),
  85.     (22, 31001118, 'MCV-000', 1, 5, '2017-06-02 17:16:08', '2017-06-02 17:16:08'),
  86.     (23, 31001118, 'FZX-829', 1, 5, '2017-06-02 17:16:08', '2017-06-02 17:16:08'),
  87.     (24, 30005017, 'TPQ-400', 1, 5, '2017-06-02 18:03:56', '2017-06-02 18:03:56'),
  88.     (25, 30005017, 'DVN-713', 1, 5, '2017-06-02 19:19:58', '2017-06-02 19:19:58'),
  89.     (26, 30005018, 'RTC-365', 1, 5, '2017-06-02 19:24:24', '2017-06-02 19:24:24'),
  90.     (27, 30005016, 'GCD-870', 1, 5, '2017-06-02 19:26:57', '2017-06-02 19:26:57'),
  91.     (28, 30002764, 'VOG-925', 2, 7, '2017-06-02 19:36:37', '2017-06-03 00:02:32'),
  92.     (29, 30002764, 'EIY-900', 2, 6, '2017-06-02 19:36:38', '2017-06-03 17:22:08'),
  93.     (30, 31000284, 'ZKS-745', 1, 5, '2017-06-02 19:40:01', '2017-06-02 19:40:01'),
  94.     (31, 31000284, 'PKY-230', 1, 5, '2017-06-02 19:40:02', '2017-06-02 19:40:02'),
  95.     (32, 30002763, 'QVY-726', 1, 5, '2017-06-03 00:04:50', '2017-06-03 00:04:50'),
  96.     (33, 30002763, 'DNK-431', 1, 5, '2017-06-03 00:04:50', '2017-06-03 00:04:50'),
  97.     (34, 30002765, 'EQH-448', 1, 5, '2017-06-03 00:23:07', '2017-06-03 00:23:07'),
  98.     (35, 30002765, 'DDX-722', 1, 5, '2017-06-03 16:03:21', '2017-06-03 16:03:21'),
  99.     (36, 30002762, 'GCQ-980', 1, 5, '2017-06-03 17:35:32', '2017-06-03 17:35:32'),
  100.     (37, 30002762, 'WQX-340', 2, 6, '2017-06-03 17:35:32', '2017-06-03 17:43:13'),
  101.     (38, 31000378, 'XSC-344', 2, 6, '2017-06-03 17:43:16', '2017-06-03 17:44:00'),
  102.     (39, 31000378, 'PQU-530', 1, 5, '2017-06-03 17:43:16', '2017-06-03 17:43:16'),
  103.     (40, 31000378, 'BLB-738', 1, 5, '2017-06-03 17:43:16', '2017-06-03 17:43:16'),
  104.     (41, 31000378, 'OOJ-808', 1, 5, '2017-06-03 17:43:16', '2017-06-03 17:43:16'),
  105.     (42, 31000378, 'OUP-702', 1, 5, '2017-06-03 17:43:16', '2017-06-03 17:43:16'),
  106.     (43, 30002762, 'BFA-192', 2, 7, '2017-06-04 16:48:29', '2017-06-04 23:55:22'),
  107.     (44, 30002762, 'XRN-035', 1, 5, '2017-06-04 21:41:55', '2017-06-04 21:41:55'),
  108.     (45, 30002762, 'NTQ-333', 1, 5, '2017-06-04 22:29:48', '2017-06-04 22:29:48'),
  109.     (46, 30004974, 'XAB-892', 2, 7, '2017-06-05 00:04:12', '2017-06-05 02:28:10'),
  110.     (47, 30004974, 'JBP-036', 2, 6, '2017-06-05 00:30:55', '2017-06-05 02:28:10'),
  111.     (48, 30004973, 'GUT-046', 2, 7, '2017-06-05 01:32:20', '2017-06-05 04:24:08'),
  112.     (49, 30004975, 'EAH-832', 3, 9, '2017-06-05 04:24:12', '2017-06-05 05:11:36'),
  113.     (50, 30004975, 'IIW-480', 1, 5, '2017-06-05 04:24:12', '2017-06-05 04:24:12'),
  114.     (51, 30004975, 'ZFE-027', 3, 5, '2017-06-05 04:41:18', '2017-06-05 05:11:35'),
  115.     (52, 30004975, 'LOK-850', 1, 5, '2017-06-05 05:14:49', '2017-06-05 05:14:49'),
  116.     (53, 30002762, 'LHF-628', 1, 5, '2017-06-05 05:17:43', '2017-06-05 05:17:43'),
  117.     (54, 30002768, 'LQV-175', 1, 5, '2017-06-05 05:20:58', '2017-06-05 05:20:58'),
  118.     (55, 30000139, 'NYY-580', 1, 5, '2017-06-05 05:27:16', '2017-06-05 05:27:16'),
  119.     (56, 30000144, 'SKZ-054', 1, 5, '2017-06-05 05:28:08', '2017-06-05 05:28:08'),
  120.     (57, 30000142, 'KJA-300', 1, 5, '2017-06-05 05:28:53', '2017-06-05 05:28:53'),
  121.     (58, 30000140, 'OCI-610', 1, 5, '2017-06-05 07:09:10', '2017-06-05 07:09:10'),
  122.     (59, 30000140, 'OOT-720', 1, 5, '2017-06-05 07:09:38', '2017-06-05 07:09:38'),
  123.     (60, 30000140, 'RYE-304', 1, 5, '2017-06-05 07:09:42', '2017-06-05 07:09:42'),
  124.     (61, 30001389, 'HHH-482', 2, 5, '2017-06-05 08:12:24', '2017-06-05 08:13:56'),
  125.     (62, 30001368, 'JJS-902', 3, 10, '2017-06-05 08:17:48', '2017-06-05 08:27:33'),
  126.     (63, 30001368, 'NKF-563', 2, 7, '2017-06-05 08:17:49', '2017-06-05 08:27:34'),
  127.     (64, 30001368, 'ADM-450', 2, 5, '2017-06-05 08:17:49', '2017-06-05 08:25:04'),
  128.     (65, 30001369, 'MSM-688', 6, 5, '2017-06-05 08:27:38', '2017-06-05 08:29:48'),
  129.     (66, 30001369, 'YTI-680', 2, 5, '2017-06-05 08:27:39', '2017-06-05 08:29:03'),
  130.     (67, 30001369, 'SUA-230', 2, 5, '2017-06-05 08:27:39', '2017-06-05 08:29:40'),
  131.     (68, 30002750, 'EPP-132', 2, 5, '2017-06-05 08:39:54', '2017-06-05 09:00:01'),
  132.     (69, 30002750, 'OWB-560', 2, 7, '2017-06-05 08:39:54', '2017-06-05 09:00:02'),
  133.     (70, 30002750, 'ZOJ-775', 3, 11, '2017-06-05 08:41:09', '2017-06-05 08:42:32'),
  134.     (71, 30002739, 'STX-924', 2, 7, '2017-06-05 09:00:05', '2017-06-05 09:01:14'),
  135.     (72, 30002740, 'FKE-880', 6, 5, '2017-06-05 09:08:43', '2017-06-05 09:10:10'),
  136.     (73, 30002740, 'TIU-788', 6, 5, '2017-06-05 09:08:43', '2017-06-05 09:10:10'),
  137.     (74, 30002739, 'YQX-588', 3, 12, '2017-06-05 09:10:48', '2017-06-05 09:11:51'),
  138.     (75, 30002752, 'CQU-498', 3, 11, '2017-06-05 09:13:02', '2017-06-05 09:14:15'),
  139.     (76, 30002775, 'DKK-624', 2, 5, '2017-06-05 09:14:19', '2017-06-05 09:25:11'),
  140.     (77, 30002775, 'QRD-776', 3, 13, '2017-06-05 09:14:19', '2017-06-05 09:21:57'),
  141.     (78, 30002775, 'WOW-190', 2, 5, '2017-06-05 09:14:20', '2017-06-05 09:50:36'),
  142.     (79, 30002775, 'XEM-517', 7, 5, '2017-06-05 09:14:20', '2017-06-05 09:25:12'),
  143.     (80, 30002776, 'MEJ-400', 7, 5, '2017-06-05 09:26:02', '2017-06-05 09:48:34'),
  144.     (81, 30002776, 'VXM-091', 7, 14, '2017-06-05 09:26:03', '2017-06-05 09:26:58'),
  145.     (82, 30002777, 'DJR-700', 2, 5, '2017-06-05 09:27:18', '2017-06-05 09:43:27'),
  146.     (83, 30002777, 'JUF-262', 3, 15, '2017-06-05 09:27:18', '2017-06-05 09:35:13'),
  147.     (84, 30002778, 'WIX-460', 3, 12, '2017-06-05 09:43:31', '2017-06-05 09:44:39'),
  148.     (85, 30002779, 'HPK-319', 2, 5, '2017-06-05 09:44:44', '2017-06-05 09:45:23'),
  149.     (86, 30002776, 'HXI-193', 7, 5, '2017-06-05 09:47:50', '2017-06-05 09:48:33'),
  150.     (87, 30002775, 'EWP-280', 7, 14, '2017-06-05 09:49:24', '2017-06-05 09:50:36'),
  151.     (88, 30001379, 'DEY-995', 2, 5, '2017-06-05 09:51:41', '2017-06-05 09:52:38'),
  152.     (89, 30001377, 'PJV-406', 3, 16, '2017-06-05 09:52:42', '2017-06-05 09:53:42'),
  153.     (90, 30002781, 'KQN-732', 7, 17, '2017-06-05 09:53:45', '2017-06-05 09:57:52'),
  154.     (91, 30002781, 'LWJ-670', 2, 7, '2017-06-05 09:53:46', '2017-06-05 09:57:53'),
  155.     (92, 30002781, 'ONL-060', 2, 7, '2017-06-05 09:53:46', '2017-06-05 09:57:38'),
  156.     (93, 30002781, 'UFI-720', 2, 5, '2017-06-05 09:53:47', '2017-06-05 09:57:39'),
  157.     (94, 30002781, 'WBO-568', 2, 5, '2017-06-05 09:53:48', '2017-06-05 09:57:04'),
  158.     (95, 30002781, 'ZQI-860', 6, 5, '2017-06-05 09:55:08', '2017-06-05 09:57:40'),
  159.     (96, 30002783, 'SYR-742', 3, 18, '2017-06-05 09:57:56', '2017-06-05 10:01:01'),
  160.     (97, 30002783, 'VVX-456', 7, 5, '2017-06-05 09:57:57', '2017-06-05 10:01:02'),
  161.     (98, 30002783, 'YPG-426', 2, 5, '2017-06-05 09:57:58', '2017-06-05 10:01:02'),
  162.     (99, 30002783, 'ZGU-587', 2, 5, '2017-06-05 09:57:58', '2017-06-05 10:01:03'),
  163.     (100, 30002787, 'GPO-396', 3, 13, '2017-06-05 10:01:17', '2017-06-05 10:02:51'),
  164.     (101, 30002787, 'QEO-112', 6, 5, '2017-06-05 10:01:18', '2017-06-05 10:02:52'),
  165.     (102, 30002783, 'YFQ-606', 2, 5, '2017-06-05 10:06:37', '2017-06-05 15:03:56'),
  166.     (103, 30002781, 'SVL-496', 1, 5, '2017-06-05 10:56:04', '2017-06-05 10:56:04'),
  167.     (104, 30002783, 'MKI-976', 7, 5, '2017-06-05 13:09:00', '2017-06-05 15:03:56'),
  168.     (105, 30002783, 'DVK-747', 1, 5, '2017-06-05 15:01:34', '2017-06-05 15:01:34'),
  169.     (106, 30002123, 'MDT-142', 6, 5, '2017-06-06 01:39:27', '2017-06-06 01:47:38'),
  170.     (107, 30002123, 'VNQ-496', 1, 5, '2017-06-06 01:39:28', '2017-06-06 01:39:28'),
  171.     (108, 30002117, 'IFB-990', 1, 5, '2017-06-06 01:55:31', '2017-06-06 01:55:31'),
  172.     (109, 30002117, 'VGX-286', 6, 5, '2017-06-06 01:55:32', '2017-06-06 01:56:51'),
  173.     (110, 30002117, 'ZJC-855', 1, 5, '2017-06-06 01:55:32', '2017-06-06 01:55:32'),
  174.     (111, 30002122, 'JLU-289', 7, 20, '2017-06-06 01:58:15', '2017-06-06 02:00:36'),
  175.     (112, 30002103, 'NIC-810', 2, 7, '2017-06-06 02:00:39', '2017-06-06 02:03:23'),
  176.     (113, 30003480, 'GXF-072', 1, 5, '2017-06-06 02:03:28', '2017-06-06 02:03:28'),
  177.     (114, 30002105, 'XLK-742', 2, 7, '2017-06-06 02:04:29', '2017-06-06 02:08:20'),
  178.     (115, 31002348, 'ADP-720', 1, 5, '2017-06-06 02:08:24', '2017-06-06 02:08:24'),
  179.     (116, 31002348, 'GPW-380', 1, 5, '2017-06-06 02:08:25', '2017-06-06 02:08:25'),
  180.     (117, 31002348, 'GZG-128', 1, 5, '2017-06-06 02:08:25', '2017-06-06 02:08:25'),
  181.     (118, 31002348, 'PDI-737', 1, 5, '2017-06-06 02:08:26', '2017-06-06 02:08:26'),
  182.     (119, 31002348, 'QAX-176', 1, 5, '2017-06-06 02:08:26', '2017-06-06 02:08:26'),
  183.     (120, 31002348, 'RKA-070', 1, 5, '2017-06-06 02:08:27', '2017-06-06 02:08:27'),
  184.     (121, 31002348, 'UYV-984', 1, 5, '2017-06-06 02:08:27', '2017-06-06 02:08:27'),
  185.     (122, 31002348, 'VWT-900', 1, 5, '2017-06-06 02:08:28', '2017-06-06 02:08:28'),
  186.     (123, 31002348, 'ZQD-491', 1, 5, '2017-06-06 02:08:28', '2017-06-06 02:08:28');
  187. /*!40000 ALTER TABLE `signatures` ENABLE KEYS */;
  188.  
  189. -- Дамп структуры для таблица evesst_database.signaturesnames
  190. CREATE TABLE IF NOT EXISTS `signaturesnames` (
  191.   `id` int(11) NOT NULL AUTO_INCREMENT,
  192.   `english` varchar(50) DEFAULT NULL,
  193.   `russian` varchar(50) DEFAULT NULL,
  194.   `russianByteCode` varchar(32) DEFAULT NULL,
  195.   `french` varchar(50) DEFAULT NULL,
  196.   `frenchByteCode` varchar(32) DEFAULT NULL,
  197.   `german` varchar(50) DEFAULT NULL,
  198.   `germanByteCode` varchar(32) DEFAULT NULL,
  199.   `chinese` varchar(50) DEFAULT NULL,
  200.   `chineseByteCode` varchar(32) DEFAULT NULL,
  201.   PRIMARY KEY (`id`)
  202. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
  203.  
  204. -- Дамп данных таблицы evesst_database.signaturesnames: ~18 rows (приблизительно)
  205. /*!40000 ALTER TABLE `signaturesnames` DISABLE KEYS */;
  206. INSERT INTO `signaturesnames` (`id`, `english`, `russian`, `russianByteCode`, `french`, `frenchByteCode`, `german`, `germanByteCode`, `chinese`, `chineseByteCode`) VALUES
  207.     (1, 'test', 'тест', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  208.     (2, 'noname', 'noname', NULL, 'noname', NULL, 'noname', NULL, 'noname', NULL),
  209.     (3, 'TestName0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  210.     (4, 'TestName1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  211.     (5, 'Cosmic Signature', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  212.     (6, 'Wormhole', NULL, '51de88520acd18308c64b5b3295f504c', NULL, NULL, NULL, '10 10 20 10', NULL, NULL),
  213.     (7, 'Unstable Wormhole', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  214.     (8, 'Combat Site', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  215.     (9, 'Serpentis Phi-Outpost', NULL, '3e5215582a74dab724eda3eac673d199', NULL, NULL, NULL, NULL, NULL, NULL),
  216.     (10, 'Chemical Yard', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  217.     (11, 'Guristas Watch', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  218.     (12, 'Gurista Hideout', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  219.     (13, 'Rogue Drone Asteroid Infestation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  220.     (14, 'Local Guristas Virus Test Site', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  221.     (15, 'Guristas Vigil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  222.     (16, 'Pith-Robux Asteroid Mining Co.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  223.     (17, 'Local Guristas Production Installation', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  224.     (18, 'Gurista Lookout', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  225.     (19, 'Data Site', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  226.     (20, 'Improved Angel Covert Research Facility', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  227. /*!40000 ALTER TABLE `signaturesnames` ENABLE KEYS */;
  228.  
  229. -- Дамп структуры для функция evesst_database.signaturesnameUpdateFrom
  230. DELIMITER //
  231. //
  232. DELIMITER ;
  233.  
  234. -- Дамп структуры для таблица evesst_database.signaturestypes
  235. CREATE TABLE IF NOT EXISTS `signaturestypes` (
  236.   `id` int(11) NOT NULL AUTO_INCREMENT,
  237.   `typeEnglish` varchar(20) DEFAULT NULL,
  238.   `typeRussian` varchar(20) DEFAULT NULL,
  239.   `typeFrench` varchar(20) DEFAULT NULL,
  240.   `typeGerman` varchar(20) DEFAULT NULL,
  241.   `typeChinese` varchar(20) DEFAULT NULL,
  242.   PRIMARY KEY (`id`)
  243. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  244.  
  245. -- Дамп данных таблицы evesst_database.signaturestypes: ~7 rows (приблизительно)
  246. /*!40000 ALTER TABLE `signaturestypes` DISABLE KEYS */;
  247. INSERT INTO `signaturestypes` (`id`, `typeEnglish`, `typeRussian`, `typeFrench`, `typeGerman`, `typeChinese`) VALUES
  248.     (1, 'Unknow', NULL, NULL, NULL, NULL),
  249.     (2, 'Wormhole', NULL, NULL, NULL, NULL),
  250.     (3, 'Combat site', NULL, NULL, NULL, NULL),
  251.     (4, 'Ore site', NULL, NULL, NULL, NULL),
  252.     (5, 'Gas site', NULL, NULL, NULL, NULL),
  253.     (6, 'Relic site', NULL, NULL, NULL, NULL),
  254.     (7, 'Data site', NULL, NULL, NULL, NULL);
  255. /*!40000 ALTER TABLE `signaturestypes` ENABLE KEYS */;
  256.  
  257. -- Дамп структуры для функция evesst_database.signatureUpdate
  258. DELIMITER //
  259. //
  260. DELIMITER ;
  261.  
  262. -- Дамп структуры для функция evesst_database.systemCreate
  263. DELIMITER //
  264. //
  265. DELIMITER ;
  266.  
  267. -- Дамп структуры для таблица evesst_database.systems
  268. CREATE TABLE IF NOT EXISTS `systems` (
  269.   `id` int(11) NOT NULL AUTO_INCREMENT,
  270.   `name` varchar(30) DEFAULT NULL,
  271.   `security` float NOT NULL,
  272.   `regionID` int(11) DEFAULT '4',
  273.   PRIMARY KEY (`id`),
  274.   KEY `id` (`id`),
  275.   KEY `systems_ibfk_1` (`regionID`),
  276.   CONSTRAINT `systems_ibfk_1` FOREIGN KEY (`regionID`) REFERENCES `regions` (`id`) ON DELETE CASCADE
  277. ) ENGINE=InnoDB AUTO_INCREMENT=31002349 DEFAULT CHARSET=utf8;
  278.  
  279. -- Дамп данных таблицы evesst_database.systems: ~59 rows (приблизительно)
  280. /*!40000 ALTER TABLE `systems` DISABLE KEYS */;
  281. INSERT INTO `systems` (`id`, `name`, `security`, `regionID`) VALUES
  282.     (1, 'nosystem', -0.2, 1),
  283.     (8, 'testSystem0', -1, 10),
  284.     (80, 'testSystem3', -1, 10),
  285.     (100, 'testSystem1', -1, 10),
  286.     (101, 'testSystem2', -1, 10),
  287.     (30000139, 'Urlen', 1, 10000002),
  288.     (30000140, 'Maurasi', 0.9, 10000002),
  289.     (30000142, 'Jita', 0.9, 10000002),
  290.     (30000144, 'Perimeter', 1, 10000002),
  291.     (30001363, 'Sobaseki', 0.8, 10000016),
  292.     (30001368, 'Uemisaisen', 0.6, 10000016),
  293.     (30001369, 'Sotrentaira', 0.5, 10000016),
  294.     (30001374, 'Iidoken', 0.8, 10000016),
  295.     (30001377, 'Sarekuwa', 0.9, 10000016),
  296.     (30001379, 'Tunttaras', 0.9, 10000016),
  297.     (30001389, 'Isanamo', 0.6, 10000016),
  298.     (30001400, 'Litiura', 0.5, 10000016),
  299.     (30002103, 'NS2L-4', -0.6, 10000025),
  300.     (30002104, 'QI-S9W', -0.3, 10000025),
  301.     (30002105, 'B-S347', -0.6, 10000025),
  302.     (30002117, 'Z8-81T', -0.2, 10000025),
  303.     (30002119, 'DY-P7Q', -0.2, 10000025),
  304.     (30002122, 'XVV-21', -0.3, 10000025),
  305.     (30002123, 'GXK-7F', -0.3, 10000025),
  306.     (30002737, 'Konola', 0.7, 10000033),
  307.     (30002739, 'Isaziwa', 0.7, 10000033),
  308.     (30002740, 'Eitu', 0.5, 10000033),
  309.     (30002750, 'Oiniken', 0.7, 10000033),
  310.     (30002752, 'Ahynada', 0.8, 10000033),
  311.     (30002753, 'Aikoro', 0.8, 10000033),
  312.     (30002754, 'Alikara', 0.7, 10000033),
  313.     (30002761, 'Kassigainen', 0.9, 10000033),
  314.     (30002762, 'Yashunen', 1, 10000033),
  315.     (30002763, 'Tennen', 0.9, 10000033),
  316.     (30002764, 'Hatakani', 0.9, 10000033),
  317.     (30002765, 'Sivala', 0.6, 10000033),
  318.     (30002768, 'Uedama', 0.5, 10000033),
  319.     (30002775, 'Paara', 0.8, 10000033),
  320.     (30002776, 'Annaro', 0.8, 10000033),
  321.     (30002777, 'Isutaka', 0.8, 10000033),
  322.     (30002778, 'Tasabeshi', 0.8, 10000033),
  323.     (30002779, 'Ono', 0.8, 10000033),
  324.     (30002781, 'Halaima', 0.7, 10000033),
  325.     (30002783, 'Sankkasen', 0.7, 10000033),
  326.     (30002786, 'Ikao', 0.6, 10000033),
  327.     (30002787, 'Waira', 0.5, 10000033),
  328.     (30002800, 'Haatomo', 0.6, 10000033),
  329.     (30002801, 'Suroken', 0.7, 10000033),
  330.     (30002802, 'Kusomonmon', 0.8, 10000033),
  331.     (30003480, 'Amod', 0.3, 10000043),
  332.     (30004973, 'Caslemon', 0.6, 10000064),
  333.     (30004974, 'Jolevier', 0.9, 10000064),
  334.     (30004975, 'Mesybier', 0.5, 10000064),
  335.     (30005015, 'Synchelle', 0.9, 10000064),
  336.     (30005016, 'Wysalan', 0.8, 10000064),
  337.     (30005017, 'Yona', 0.8, 10000064),
  338.     (30005018, 'Noghere', 0.7, 10000064),
  339.     (31000284, 'J153311', -1, 1),
  340.     (31000378, 'J124219', -1, 1),
  341.     (31001118, 'J101500', -1, 1),
  342.     (31002348, 'J141032', -1, 1);
  343. /*!40000 ALTER TABLE `systems` ENABLE KEYS */;
  344.  
  345. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  346. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  347. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!