ip_check/ip_check.sql

12 lines
354 B
SQL

DROP TABLE IF EXISTS acl;
CREATE TABLE acl (
id int(11) NOT NULL auto_increment,
flags int(11) NOT NULL default '0',
ip int(10) unsigned NOT NULL default '0',
mask int(11) NOT NULL default '0',
url varchar(128) NOT NULL default '',
info varchar(32) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY unique01 (ip,mask,url)
) TYPE=MyISAM;