Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `users` (
  2. `id` int NOT NULL AUTO_INCREMENT,
  3. `name` varchar(60) NOT NULL,
  4. `surname` varchar(60) NOT NULL,
  5. `email` varchar(60) NOT NULL,
  6. `phone` varchar(20) NOT NULL,
  7. PRIMARY KEY (`id`)
  8. );
  9.  
  10. CREATE TABLE IF NOT EXISTS `clients` (
  11. `id` int NOT NULL,
  12. `name` varchar(60) NOT NULL,
  13. `surname` varchar(60) NOT NULL,
  14. `email` varchar(60) NOT NULL,
  15. `phone` varchar(20) NOT NULL,
  16. `age` int NOT NULL,
  17. `security_number` varchar(0) NOT NULL,
  18. `birthdate` date NOT NULL
  19. );
  20.  
  21. ALTER TABLE `clients` ADD CONSTRAINT `id` FOREIGN KEY () REFERENCES `users` (`id`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement