I wanted to create a column to store ipv6 addresses in binary. I accidentally created a column of 128 bytes (instead of 128 bit). Then I found out I was unable to delete rows by using the checkboxes and delete button.
My table definition is:
operation enum('authenticate','release') CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 'authenticate',
user_id int(10) unsigned NOT NULL DEFAULT '0',
attempt_ip binary(128) NOT NULL,
attempt_time datetime NOT NULL,
success tinyint(3) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
I'm using Apache 2.2.22, MySQL 5.5.24, PHP 5.4.3
Log in to post a comment.