Re: UNIQUE issue at mysql 4.* and mysql 5.*

2005-08-02 Thread Gleb Paharenko
Hello. It works for me on MySQL 5.0.10: mysql> CREATE TABLE `manager_new` ( -> `id` bigint(20) NOT NULL auto_increment, -> `id_from_hits` bigint(20) default NULL, -> `from_ip` varchar(15) default NULL, -> `pool` char(1) NOT NULL default 'n', -> `to_ip` varcha

UNIQUE issue at mysql 4.* and mysql 5.*

2005-08-02 Thread Yariv Graf
Hi all I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow | manager_new | CREATE TABLE `manager_new` ( `id` bigint(20) NOT NULL auto_increment, `id_from_hits` bigint(20) default NULL, `from_ip` varchar(15) default NULL, `pool` char(1) NOT NULL default 'n', `to_ip` varchar

UNIQUE issue at mysql 4.* and mysql 5.*

2005-08-02 Thread Yariv Graf
Hi all I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow | manager_new | CREATE TABLE `manager_new` ( `id` bigint(20) NOT NULL auto_increment, `id_from_hits` bigint(20) default NULL, `from_ip` varchar(15) default NULL, `pool` char(1) NOT NULL default 'n', `to_ip` varchar