|  Nieuw lid |  | probeer hem zo eens: 
 
    
    
        
            
                CREATE TABLE `address_book` (
`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL ,
`entry_gender` char( 1 ) COLLATE latin1_general_ci NOT NULL ,
`entry_company` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_firstname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL ,
`entry_lastname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL ,
`entry_street_address` varchar( 64 ) COLLATE latin1_general_ci NOT NULL ,
`entry_suburb` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_postcode` varchar( 10 ) COLLATE latin1_general_ci NOT NULL ,
`entry_city` varchar( 32 ) COLLATE latin1_general_ci NOT NULL ,
`entry_state` varchar( 32 ) COLLATE latin1_general_ci 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 ; CREATE TABLE `address_book` ( `address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,`customers_id` int( 11 ) NOT NULL ,`entry_gender` char( 1 ) COLLATE latin1_general_ci NOT NULL ,`entry_company` varchar( 32 ) COLLATE latin1_general_ci DEFAULT NULL ,`entry_firstname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL ,`entry_lastname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL ,`entry_street_address` varchar( 64 ) COLLATE latin1_general_ci NOT NULL ,`entry_suburb` varchar( 32 ) COLLATE latin1_general_ci DEFAULT NULL ,`entry_postcode` varchar( 10 ) COLLATE latin1_general_ci NOT NULL ,`entry_city` varchar( 32 ) COLLATE latin1_general_ci NOT NULL ,`entry_state` varchar( 32 ) COLLATE latin1_general_ci 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 ;
   |