161 lines
8.8 KiB
SQL
161 lines
8.8 KiB
SQL
-- MySQL dump 10.10
|
|
--
|
|
-- Host: localhost Database: bridge
|
|
-- ------------------------------------------------------
|
|
-- Server version 5.0.24a-Debian_9-log
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!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 */;
|
|
|
|
--
|
|
-- Table structure for table `bridge`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `bridge`;
|
|
CREATE TABLE `bridge` (
|
|
`id` int(11) NOT NULL auto_increment,
|
|
`name` varchar(32) NOT NULL,
|
|
`ctrldev` varchar(16) NOT NULL,
|
|
`ctrlip` int(10) unsigned NOT NULL default '0',
|
|
`ctrlmask` varchar(16) NOT NULL,
|
|
`ctrlgw` int(10) unsigned NOT NULL default '0',
|
|
`basemac` varchar(32) NOT NULL default '00:00:00:00:00:00',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `name` (`name`),
|
|
UNIQUE KEY `basemac` (`basemac`),
|
|
UNIQUE KEY `ctrlip` (`ctrlip`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `bridge`
|
|
--
|
|
|
|
|
|
/*!40000 ALTER TABLE `bridge` DISABLE KEYS */;
|
|
LOCK TABLES `bridge` WRITE;
|
|
INSERT INTO `bridge` VALUES (22,'Bridge #1','eth0',168492644,'255.255.0.0',168491770,'00:DE:AD:BE:EF:00');
|
|
UNLOCK TABLES;
|
|
/*!40000 ALTER TABLE `bridge` ENABLE KEYS */;
|
|
|
|
--
|
|
-- Table structure for table `forward`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `forward`;
|
|
CREATE TABLE `forward` (
|
|
`id` int(11) NOT NULL auto_increment,
|
|
`flags` int(11) NOT NULL,
|
|
`portlo` int(11) NOT NULL,
|
|
`porthi` int(11) NOT NULL,
|
|
`name` varchar(64) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `forward`
|
|
--
|
|
|
|
|
|
/*!40000 ALTER TABLE `forward` DISABLE KEYS */;
|
|
LOCK TABLES `forward` WRITE;
|
|
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');
|
|
UNLOCK TABLES;
|
|
/*!40000 ALTER TABLE `forward` ENABLE KEYS */;
|
|
|
|
--
|
|
-- Table structure for table `hlsw`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `hlsw`;
|
|
CREATE TABLE `hlsw` (
|
|
`id` int(11) NOT NULL auto_increment,
|
|
`vlanid` int(11) NOT NULL,
|
|
`flags` int(11) NOT NULL,
|
|
`ip` int(10) unsigned NOT NULL,
|
|
`name` varchar(32) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `ip` (`ip`),
|
|
UNIQUE KEY `name` (`name`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `hlsw`
|
|
--
|
|
|
|
|
|
/*!40000 ALTER TABLE `hlsw` DISABLE KEYS */;
|
|
LOCK TABLES `hlsw` WRITE;
|
|
INSERT INTO `hlsw` VALUES (8,607,0,168427551,'hbuss?'),(10,607,0,168492644,'bridge');
|
|
UNLOCK TABLES;
|
|
/*!40000 ALTER TABLE `hlsw` ENABLE KEYS */;
|
|
|
|
--
|
|
-- Table structure for table `trunk`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `trunk`;
|
|
CREATE TABLE `trunk` (
|
|
`id` int(11) NOT NULL auto_increment,
|
|
`bridgeid` int(11) NOT NULL,
|
|
`flags` int(11) NOT NULL,
|
|
`name` varchar(16) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `bridgeid` (`bridgeid`,`name`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `trunk`
|
|
--
|
|
|
|
|
|
/*!40000 ALTER TABLE `trunk` DISABLE KEYS */;
|
|
LOCK TABLES `trunk` WRITE;
|
|
INSERT INTO `trunk` VALUES (55,22,0,'eth3'),(46,22,0,'eth1'),(47,22,0,'eth2'),(62,22,0,'eth4');
|
|
UNLOCK TABLES;
|
|
/*!40000 ALTER TABLE `trunk` ENABLE KEYS */;
|
|
|
|
--
|
|
-- Table structure for table `vlan`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `vlan`;
|
|
CREATE TABLE `vlan` (
|
|
`id` int(11) NOT NULL auto_increment,
|
|
`trunkid` int(11) NOT NULL,
|
|
`flags` int(11) NOT NULL,
|
|
`vlannum` int(11) NOT NULL,
|
|
`bandwidth` int(11) NOT NULL,
|
|
`mac` varchar(32) NOT NULL default '00:00:00:00:00:00',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `trunkid` (`trunkid`,`vlannum`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=936 DEFAULT CHARSET=latin1;
|
|
|
|
--
|
|
-- Dumping data for table `vlan`
|
|
--
|
|
|
|
|
|
/*!40000 ALTER TABLE `vlan` DISABLE KEYS */;
|
|
LOCK TABLES `vlan` WRITE;
|
|
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');
|
|
UNLOCK TABLES;
|
|
/*!40000 ALTER TABLE `vlan` ENABLE KEYS */;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|