Codice: Seleziona tutto
DROP TABLE IF EXISTS `address_book`;
CREATE TABLE `address_book` (
`address_book_id` int(11) NOT NULL auto_increment,
`customers_id` int(11) NOT NULL,
`entry_gender` char(1) NOT NULL,
`entry_company` varchar(32) default NULL,
`entry_cf` varchar(16) NOT NULL default '',
`entry_piva` varchar(11) NOT NULL default '',
`entry_firstname` varchar(32) NOT NULL,
`entry_lastname` varchar(32) NOT NULL,
`entry_street_address` varchar(64) NOT NULL,
`entry_suburb` varchar(32) default NULL,
`entry_postcode` varchar(10) NOT NULL,
`entry_city` varchar(32) NOT NULL,
`entry_state` varchar(32) default NULL,
`entry_country_id` int(11) NOT NULL default '0',
`entry_zone_id` int(11) NOT NULL default '0',
PRIMARY KEY (`address_book_id`),
KEY `idx_address_book_customers_id` (`customers_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;