1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
CREATE TABLE `address_book` ( `address_book_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `entry_gender` char(1) NOT NULL default '', `entry_company` varchar(32) default NULL, `entry_firstname` varchar(32) NOT NULL default '', `entry_lastname` varchar(32) NOT NULL default '', `entry_street_address` varchar(64) NOT NULL default '', `entry_suburb` varchar(32) default NULL, `entry_postcode` varchar(10) NOT NULL default '', `entry_city` varchar(32) NOT NULL default '', `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`)) TYPE=MyISAM;
INSERT INTO address_book VALUES('3', '4', 'm', 'lycée de la colline', 'marcel', 'dupont', 'rue des plantes', '', '75001', 'paris', 'ille de france', '74', '0');
INSERT INTO address_book VALUES('2', '3', 'm', 'ddddddddd', 'ddddddd', 'ddddddddddddd', 'ffffffff', '', '23454', 'Honfleur', 'normandie', '26', '0');
INSERT INTO address_book VALUES('6', '7', 'm', 'lycée de la colline', '***', '***', 'rue des ***s', '', '76490', 'rouen', 'haute normandie', '73', '0');
INSERT INTO address_book VALUES('7', '6', 'm', '', 'djfgs', 'kljfdekjlds', 'fgkjlfgkjlfg', '', 'kldsfklds', 'fdsjdfskjldsf', 'dfjklfds', '74', '0');
CREATE TABLE `address_format` ( `address_format_id` int(11) NOT NULL auto_increment, `address_format` varchar(128) NOT NULL default '', `address_summary` varchar(48) NOT NULL default '', PRIMARY KEY (`address_format_id`)) TYPE=MyISAM;
INSERT INTO address_format VALUES('1', '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country');
INSERT INTO address_format VALUES('2', '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country', '$city, $state / $country');
INSERT INTO address_format VALUES('3', '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country');
INSERT INTO address_format VALUES('4', '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
INSERT INTO address_format VALUES('5', '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country'); |
Partager