CREATE TABLE IF NOT EXISTS `site_service_identity_net` ( `identity_net_id` int(11) NOT NULL DEFAULT '0', `c_id` int(11) NOT NULL DEFAULT '0', `entry_gender` char(1) NOT NULL DEFAULT '', `entry_civ` varchar(6) NOT NULL DEFAULT '', `entry_firstname` varchar(32) NOT NULL DEFAULT '', `entry_lastname` varchar(32) NOT NULL DEFAULT '', `entry_mail` varchar(32) NOT NULL DEFAULT '', `entry_www` varchar(64) NOT NULL DEFAULT '', `entry_ip_address` varchar(32) NOT NULL COMMENT 'contient l''adresse ip de creation au format iduser::ip_address', PRIMARY KEY (`identity_net_id`), KEY `idx_address_book_customers_id` (`c_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;