Broadcast bridge
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

161 lines
8.8KB

  1. -- MySQL dump 10.10
  2. --
  3. -- Host: localhost Database: bridge
  4. -- ------------------------------------------------------
  5. -- Server version 5.0.24a-Debian_9-log
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  11. /*!40103 SET TIME_ZONE='+00:00' */;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. --
  17. -- Table structure for table `bridge`
  18. --
  19. DROP TABLE IF EXISTS `bridge`;
  20. CREATE TABLE `bridge` (
  21. `id` int(11) NOT NULL auto_increment,
  22. `name` varchar(32) NOT NULL,
  23. `ctrldev` varchar(16) NOT NULL,
  24. `ctrlip` int(10) unsigned NOT NULL default '0',
  25. `ctrlmask` varchar(16) NOT NULL,
  26. `ctrlgw` int(10) unsigned NOT NULL default '0',
  27. `basemac` varchar(32) NOT NULL default '00:00:00:00:00:00',
  28. PRIMARY KEY (`id`),
  29. UNIQUE KEY `name` (`name`),
  30. UNIQUE KEY `basemac` (`basemac`),
  31. UNIQUE KEY `ctrlip` (`ctrlip`)
  32. ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
  33. --
  34. -- Dumping data for table `bridge`
  35. --
  36. /*!40000 ALTER TABLE `bridge` DISABLE KEYS */;
  37. LOCK TABLES `bridge` WRITE;
  38. INSERT INTO `bridge` VALUES (22,'Bridge #1','eth0',168492644,'255.255.0.0',168491770,'00:DE:AD:BE:EF:00');
  39. UNLOCK TABLES;
  40. /*!40000 ALTER TABLE `bridge` ENABLE KEYS */;
  41. --
  42. -- Table structure for table `forward`
  43. --
  44. DROP TABLE IF EXISTS `forward`;
  45. CREATE TABLE `forward` (
  46. `id` int(11) NOT NULL auto_increment,
  47. `flags` int(11) NOT NULL,
  48. `portlo` int(11) NOT NULL,
  49. `porthi` int(11) NOT NULL,
  50. `name` varchar(64) NOT NULL,
  51. PRIMARY KEY (`id`)
  52. ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
  53. --
  54. -- Dumping data for table `forward`
  55. --
  56. /*!40000 ALTER TABLE `forward` DISABLE KEYS */;
  57. LOCK TABLES `forward` WRITE;
  58. INSERT INTO `forward` VALUES (1,1,27960,27963,'Quake3'),(2,1,27015,27024,'Halflife'),(3,1,1716,1727,'Americas Army Operations'),(4,1,2092,0,'Descent 3'),(5,1,2234,2245,'Operation Flashpoint'),(6,1,2299,0,'Age of Empires 3'),(7,1,2302,2313,'Operation Flashpoint: Resistance'),(8,1,2346,0,'Ghost Recon'),(9,1,2350,2360,'Trackmania'),(10,1,5120,5131,'Neverwinter Nights'),(11,1,5678,0,'FarCry'),(12,1,6073,0,'Freelancer'),(13,1,6111,0,'StarCraft'),(14,1,6112,0,'Warcraft 3'),(15,1,7075,0,'Siedler 5'),(16,1,7777,7788,'Unreal Tournament'),(17,1,8086,0,'Command Conquer: Generals'),(18,1,8086,8093,'Schlacht um Mittelerde'),(19,1,8777,8786,'Ravenshield'),(20,1,9999,0,'Need for Speed Underground 2'),(21,1,10481,10482,'SWAT 4'),(22,1,10777,0,'Unreal Tournament 2004'),(23,1,12203,12218,'Medal of Honor: Spearhead'),(24,1,12299,12310,'Medal of Honor: Allied Assault'),(25,1,15250,0,'Ghost Recon'),(26,1,20000,0,'Söldner'),(27,1,20099,20110,'Soldier of Fortune 2'),(28,1,22000,22010,'Battlefield 1942'),(29,1,22450,0,'Sin'),(30,1,23756,23757,'Flatout (?)'),(31,1,25299,25310,'Command Conquer: Renegade'),(32,1,25601,25621,'Serious Sam 2'),(33,1,26000,0,'Quake'),(34,1,26001,26010,'IGI2: Covert Ops'),(35,1,26900,0,'Hexen 2'),(36,1,27500,0,'QuakeWorld'),(37,1,27665,27676,'Doom 3'),(38,1,27887,27898,'Aliens vs. Predators 2'),(39,1,27910,0,'Quake 2'),(40,1,27950,27953,'Enemy Territory'),(41,1,28000,0,'Tribes 2'),(42,1,28001,0,'StarSiege'),(43,1,28004,28008,'Quake 4'),(44,1,28069,28080,'Jedi Knight 2'),(45,1,28960,28963,'Call of Duty'),(46,1,29252,29263,'Elite Force 2'),(47,1,29900,29910,'Battlefield 2'),(48,1,31510,0,'KingPin'),(49,1,47624,0,'Total Annihilation'),(50,1,61220,61230,'Need for Speed: Hot Pursuit');
  59. UNLOCK TABLES;
  60. /*!40000 ALTER TABLE `forward` ENABLE KEYS */;
  61. --
  62. -- Table structure for table `hlsw`
  63. --
  64. DROP TABLE IF EXISTS `hlsw`;
  65. CREATE TABLE `hlsw` (
  66. `id` int(11) NOT NULL auto_increment,
  67. `vlanid` int(11) NOT NULL,
  68. `flags` int(11) NOT NULL,
  69. `ip` int(10) unsigned NOT NULL,
  70. `name` varchar(32) NOT NULL,
  71. PRIMARY KEY (`id`),
  72. UNIQUE KEY `ip` (`ip`),
  73. UNIQUE KEY `name` (`name`)
  74. ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  75. --
  76. -- Dumping data for table `hlsw`
  77. --
  78. /*!40000 ALTER TABLE `hlsw` DISABLE KEYS */;
  79. LOCK TABLES `hlsw` WRITE;
  80. INSERT INTO `hlsw` VALUES (8,607,0,168427551,'hbuss?'),(10,607,0,168492644,'bridge');
  81. UNLOCK TABLES;
  82. /*!40000 ALTER TABLE `hlsw` ENABLE KEYS */;
  83. --
  84. -- Table structure for table `trunk`
  85. --
  86. DROP TABLE IF EXISTS `trunk`;
  87. CREATE TABLE `trunk` (
  88. `id` int(11) NOT NULL auto_increment,
  89. `bridgeid` int(11) NOT NULL,
  90. `flags` int(11) NOT NULL,
  91. `name` varchar(16) NOT NULL,
  92. PRIMARY KEY (`id`),
  93. UNIQUE KEY `bridgeid` (`bridgeid`,`name`)
  94. ) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;
  95. --
  96. -- Dumping data for table `trunk`
  97. --
  98. /*!40000 ALTER TABLE `trunk` DISABLE KEYS */;
  99. LOCK TABLES `trunk` WRITE;
  100. INSERT INTO `trunk` VALUES (55,22,0,'eth3'),(46,22,0,'eth1'),(47,22,0,'eth2'),(62,22,0,'eth4');
  101. UNLOCK TABLES;
  102. /*!40000 ALTER TABLE `trunk` ENABLE KEYS */;
  103. --
  104. -- Table structure for table `vlan`
  105. --
  106. DROP TABLE IF EXISTS `vlan`;
  107. CREATE TABLE `vlan` (
  108. `id` int(11) NOT NULL auto_increment,
  109. `trunkid` int(11) NOT NULL,
  110. `flags` int(11) NOT NULL,
  111. `vlannum` int(11) NOT NULL,
  112. `bandwidth` int(11) NOT NULL,
  113. `mac` varchar(32) NOT NULL default '00:00:00:00:00:00',
  114. PRIMARY KEY (`id`),
  115. UNIQUE KEY `trunkid` (`trunkid`,`vlannum`)
  116. ) ENGINE=MyISAM AUTO_INCREMENT=936 DEFAULT CHARSET=latin1;
  117. --
  118. -- Dumping data for table `vlan`
  119. --
  120. /*!40000 ALTER TABLE `vlan` DISABLE KEYS */;
  121. LOCK TABLES `vlan` WRITE;
  122. INSERT INTO `vlan` VALUES (607,46,0,1,400,'00:DE:AD:BE:EF:01'),(935,47,0,323,400,'00:DE:AD:BE:EF:2F'),(934,47,0,322,400,'00:DE:AD:BE:EF:2E'),(799,55,0,1,400,'00:DE:AD:BE:EF:30'),(798,47,0,123,400,'00:DE:AD:BE:EF:18'),(797,47,0,122,400,'00:DE:AD:BE:EF:17'),(776,47,0,101,400,'00:DE:AD:BE:EF:02'),(777,47,0,102,400,'00:DE:AD:BE:EF:03'),(778,47,0,103,400,'00:DE:AD:BE:EF:04'),(779,47,0,104,400,'00:DE:AD:BE:EF:05'),(780,47,0,105,400,'00:DE:AD:BE:EF:06'),(781,47,0,106,400,'00:DE:AD:BE:EF:07'),(782,47,0,107,400,'00:DE:AD:BE:EF:08'),(783,47,0,108,400,'00:DE:AD:BE:EF:09'),(784,47,0,109,400,'00:DE:AD:BE:EF:0A'),(785,47,0,110,400,'00:DE:AD:BE:EF:0B'),(786,47,0,111,400,'00:DE:AD:BE:EF:0C'),(787,47,0,112,400,'00:DE:AD:BE:EF:0D'),(788,47,0,113,400,'00:DE:AD:BE:EF:0E'),(789,47,0,114,400,'00:DE:AD:BE:EF:0F'),(790,47,0,115,400,'00:DE:AD:BE:EF:10'),(791,47,0,116,400,'00:DE:AD:BE:EF:11'),(792,47,0,117,400,'00:DE:AD:BE:EF:12'),(793,47,0,118,400,'00:DE:AD:BE:EF:13'),(794,47,0,119,400,'00:DE:AD:BE:EF:14'),(795,47,0,120,400,'00:DE:AD:BE:EF:15'),(796,47,0,121,400,'00:DE:AD:BE:EF:16'),(933,47,0,321,400,'00:DE:AD:BE:EF:2D'),(932,47,0,320,400,'00:DE:AD:BE:EF:2C'),(931,47,0,319,400,'00:DE:AD:BE:EF:2B'),(930,47,0,318,400,'00:DE:AD:BE:EF:2A'),(929,47,0,317,400,'00:DE:AD:BE:EF:29'),(928,47,0,316,400,'00:DE:AD:BE:EF:28'),(927,47,0,315,400,'00:DE:AD:BE:EF:27'),(926,47,0,314,400,'00:DE:AD:BE:EF:26'),(925,47,0,313,400,'00:DE:AD:BE:EF:25'),(924,47,0,312,400,'00:DE:AD:BE:EF:24'),(923,47,0,311,400,'00:DE:AD:BE:EF:23'),(922,47,0,310,400,'00:DE:AD:BE:EF:22'),(921,47,0,309,400,'00:DE:AD:BE:EF:21'),(920,47,0,308,400,'00:DE:AD:BE:EF:20'),(919,47,0,307,400,'00:DE:AD:BE:EF:1F'),(918,47,0,306,400,'00:DE:AD:BE:EF:1E'),(917,47,0,305,400,'00:DE:AD:BE:EF:1D'),(916,47,0,304,400,'00:DE:AD:BE:EF:1C'),(915,47,0,303,400,'00:DE:AD:BE:EF:1B'),(914,47,0,302,400,'00:DE:AD:BE:EF:1A'),(913,47,0,301,400,'00:DE:AD:BE:EF:19'),(890,62,0,501,400,'00:DE:AD:BE:EF:31'),(891,62,0,502,400,'00:DE:AD:BE:EF:32'),(892,62,0,503,400,'00:DE:AD:BE:EF:33'),(893,62,0,504,400,'00:DE:AD:BE:EF:34'),(894,62,0,505,400,'00:DE:AD:BE:EF:35'),(895,62,0,506,400,'00:DE:AD:BE:EF:36'),(896,62,0,507,400,'00:DE:AD:BE:EF:37'),(897,62,0,508,400,'00:DE:AD:BE:EF:38'),(898,62,0,509,400,'00:DE:AD:BE:EF:39'),(899,62,0,510,400,'00:DE:AD:BE:EF:3A'),(900,62,0,511,400,'00:DE:AD:BE:EF:3B'),(901,62,0,512,400,'00:DE:AD:BE:EF:3C'),(902,62,0,513,400,'00:DE:AD:BE:EF:3D'),(903,62,0,514,400,'00:DE:AD:BE:EF:3E'),(904,62,0,515,400,'00:DE:AD:BE:EF:3F'),(905,62,0,516,400,'00:DE:AD:BE:EF:40'),(906,62,0,517,400,'00:DE:AD:BE:EF:41'),(907,62,0,518,400,'00:DE:AD:BE:EF:42'),(908,62,0,519,400,'00:DE:AD:BE:EF:43'),(909,62,0,520,400,'00:DE:AD:BE:EF:44'),(910,62,0,521,400,'00:DE:AD:BE:EF:45'),(911,62,0,522,400,'00:DE:AD:BE:EF:46'),(912,62,0,523,400,'00:DE:AD:BE:EF:47');
  123. UNLOCK TABLES;
  124. /*!40000 ALTER TABLE `vlan` ENABLE KEYS */;
  125. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  126. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  127. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  128. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  129. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  130. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  131. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  132. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;