CREATETABLE `users` (`country_id`INTEGER UNSIGNED NOT NULL, CONSTRAINT `fk_users_country_id` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
)
primaryKey
Create a primary key constraint from one or more columns.
CREATETABLE `posts_users` (`post_id`VARCHAR(255) NOT NULL,`user_id`VARCHAR(255) NOT NULL,INDEX`idx_users_full_name` (`first_name`, `last_name`), CONSTRAINT `fk_posts_users_post_id` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT `fk_posts_users_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT""pk_users_first_name_last_name""PRIMARY KEY (""first_name"", ""last_name""))
unique
Create a unique constraint from one or more columns.