21 lines
589 B
SQL
21 lines
589 B
SQL
DROP TABLE IF EXISTS `user_address`;
|
|
|
|
CREATE TABLE `user_address` (
|
|
`user_address_id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
`user_id` INT NOT NULL,
|
|
`first_name` TEXT NOT NULL,
|
|
`last_name` TEXT NOT NULL,
|
|
`company` TEXT NOT NULL,
|
|
`address_1` TEXT NOT NULL,
|
|
`address_2` TEXT NOT NULL,
|
|
`city` TEXT NOT NULL,
|
|
`post_code` TEXT NOT NULL,
|
|
`country_id` INT NOT NULL DEFAULT '0',
|
|
`region_id` INT NOT NULL DEFAULT '0',
|
|
`default_address` tinyint unsigned NOT NULL DEFAULT 0,
|
|
`fields` text NOT NULL
|
|
-- PRIMARY KEY (`user_address_id`)
|
|
);
|
|
|
|
CREATE INDEX `user_address_user_id` ON `user_address` (`user_id`);
|