Companies and addresses MySQL
-- ---------------------------- 
            -- Table structure for adresses 
            -- ---------------------------- 
            DROP TABLE IF EXISTS `adresses`; 
            CREATE TABLE `adresses` ( 
            `adress_id` int(11) NOT NULL AUTO_INCREMENT, 
            `adress_adress` varchar(255) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_adressnumber` varchar(5) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_zipcode` varchar(20) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_city` varchar(30) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_postbus` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, 
            `adress_country` varchar(30) COLLATE utf8_unicode_ci NOT NULL, 
            `adress_building` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, 
            `adress_unit` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, 
            `company_id` int(11) DEFAULT NULL, 
            `addresss_role` tinyint(4) DEFAULT NULL COMMENT 'Role 1 for company may be and 2 for comapny postal, feel free', 
            PRIMARY KEY (`adress_id`) 
            ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

            -- ---------------------------- 
            -- Records of adresses 
            -- ---------------------------- 
            INSERT INTO `adresses` VALUES ('1', '1324234', '', '', '', null, '', null, null, '1', '2'); 
            INSERT INTO `adresses` VALUES ('2', '67856785678', '', '', '', null, '', null, null, '1', '1'); 

            -- ---------------------------- 
            -- Table structure for companies 
            -- ---------------------------- 
            DROP TABLE IF EXISTS `companies`; 
            CREATE TABLE `companies` ( 
            `company_id` int(11) NOT NULL AUTO_INCREMENT, 
            `company_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, 
            `company_adress_id` int(11) NOT NULL, 
            `company_postadress_id` int(11) NOT NULL, 
            PRIMARY KEY (`company_id`), 
            KEY `company_adress_id` (`company_adress_id`,`company_postadress_id`), 
            KEY `company_adress_id_2` (`company_adress_id`,`company_postadress_id`), 
            KEY `company_postadress_id` (`company_postadress_id`), 
            CONSTRAINT `address` FOREIGN KEY (`company_adress_id`) REFERENCES `adresses` (`adress_id`) ON DELETE CASCADE ON UPDATE CASCADE, 
            CONSTRAINT `postal_address` FOREIGN KEY (`company_postadress_id`) REFERENCES `adresses` (`adress_id`) ON DELETE CASCADE ON UPDATE CASCADE 
            ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

            -- ---------------------------- 
            -- Records of companies 
            -- ---------------------------- 
            INSERT INTO `companies` VALUES ('1', 'sdfgsdf', '1', '2');