· 6 years ago · Jul 19, 2019, 04:40 AM
1CREATE 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,
7PRIMARY KEY (`id`)
8);
9
10CREATE 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
21ALTER TABLE `clients` ADD CONSTRAINT `id` FOREIGN KEY () REFERENCES `users` (`id`);