1
2
3
4
5
6

CREATE TABLE `cp_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('allow','deny') NOT NULL DEFAULT 'allow',
  `netaddr` varchar(39) CHARACTER SET ascii NOT NULL,  `netmask` varchar(15) CHARACTER SET ascii NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `cp_access` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` enum('allow','deny') NOT NULL DEFAULT 'allow', `netaddr` varchar(39) CHARACTER SET ascii NOT NULL, `netmask` varchar(15) CHARACTER SET ascii NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1