dump.struktur

sifi-0.1.6.tar.gz 出自http://www.ifi.unizh.ch/ikm/SINUS/firewall/ 一个linux的防火墙工具。

#
# mSQL Dump  (requires mSQL 2.0 Beta 5 or newer)
#
# Host: localhost    Database: firewall
#--------------------------------------------------------


#
# Table structure for table 'F_LOG'
#
CREATE TABLE F_LOG (
  datum INT,
  rule_type CHAR(10),
  rule_number CHAR(40),
  action CHAR(20),
  protocol CHAR(100),
  source_ip CHAR(21),
  source_port CHAR(100),
  source_name CHAR(100),
  source_net CHAR(17),
  source_dom CHAR(100),
  destination_ip CHAR(21),
  destination_port CHAR(100),
  destination_name CHAR(100),
  destination_net CHAR(17),
  destination_dom CHAR(100)
) \g

CREATE   INDEX IPXsource_ip ON F_LOG (
	source_ip
) \g

CREATE   INDEX IPXsource_name ON F_LOG (
	source_name
) \g

CREATE   INDEX IPXsource_net ON F_LOG (
	source_net
) \g

CREATE   INDEX IPXsource_dom ON F_LOG (
	source_dom
) \g

CREATE   INDEX IPXdestination_ip ON F_LOG (
	destination_ip
) \g

CREATE   INDEX IPXdestination_port ON F_LOG (
	destination_port
) \g

CREATE   INDEX IPXdestination_name ON F_LOG (
	destination_name
) \g

CREATE   INDEX IPXdestination_net ON F_LOG (
	destination_net
) \g

CREATE   INDEX IPXdestination_dom ON F_LOG (
	destination_dom
) \g


#
# Dumping data for table 'F_LOG'
#


#
# Table structure for table 'REST'
#
CREATE TABLE REST (
  line TEXT(100)
) \g


#
# Dumping data for table 'REST'
#


#
# Table structure for table 'A_SOURCEIP'
#
CREATE TABLE A_SOURCEIP (
  name CHAR(21),
  anz INT
) \g

CREATE UNIQUE INDEX IPXip ON A_SOURCEIP (
	name
) \g


#
# Dumping data for table 'A_SOURCEIP'
#


#
# Table structure for table 'A_SOURCENET'
#
CREATE TABLE A_SOURCENET (
  name CHAR(17),
  anz INT
) \g

CREATE UNIQUE INDEX IPXnet ON A_SOURCENET (
	name
) \g


#
# Dumping data for table 'A_SOURCENET'
#


#
# Table structure for table 'A_SOURCEDOM'
#
CREATE TABLE A_SOURCEDOM (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXdom ON A_SOURCEDOM (
	name
) \g


#
# Dumping data for table 'A_SOURCEDOM'
#


#
# Table structure for table 'A_SOURCENAME'
#
CREATE TABLE A_SOURCENAME (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE INDEX IPXname ON A_SOURCENAME (
	name
) \g


#
# Dumping data for table 'A_SOURCENAME'
#


#
# Table structure for table 'A_DESTIP'
#
CREATE TABLE A_DESTIP (
  name CHAR(21),
  anz INT
) \g

CREATE UNIQUE INDEX IPXip ON A_DESTIP (
	name
) \g


#
# Dumping data for table 'A_DESTIP'
#


#
# Table structure for table 'A_DESTNET'
#
CREATE TABLE A_DESTNET (
  name CHAR(17),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXnet ON A_DESTNET (
	name
) \g


#
# Dumping data for table 'A_DESTNET'
#


#
# Table structure for table 'A_DESTDOM'
#
CREATE TABLE A_DESTDOM (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE INDEX IPXdom ON A_DESTDOM (
	name
) \g


#
# Dumping data for table 'A_DESTDOM'
#


#
# Table structure for table 'A_DESTNAME'
#
CREATE TABLE A_DESTNAME (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXname ON A_DESTNAME (
	name
) \g


#
# Dumping data for table 'A_DESTNAME'
#


#
# Table structure for table 'A_RULETYPE'
#
CREATE TABLE A_RULETYPE (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXname ON A_RULETYPE (
	name
) \g
#
# Table structure for table 'A_DESTNAME'
#
CREATE TABLE A_RULENUMBER (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXname ON A_RULENUMBER (
	name
) \g
#
# Table structure for table 'A_DESTNAME'
#
CREATE TABLE A_ACTION (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXname ON A_ACTION (
	name
) \g
#
# Table structure for table 'A_DESTNAME'
#
CREATE TABLE A_PROTOCOL (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXname ON A_PROTOCOL (
	name
) \g
#
# Table structure for table 'A_DESTNAME'
#
CREATE TABLE A_DESTPORT (
  name CHAR(100),
  anz INT
) \g

CREATE UNIQUE  INDEX IPXname ON A_DESTPORT (
	name
) \g