· 8 years ago · Mar 13, 2018, 11:12 PM
1CREATE TABLE IF NOT EXISTS `clients` (
2 `id` int(6) unsigned NOT NULL,
3 `name` varchar(200) NOT NULL,
4 `city` varchar(200) NOT NULL,
5 `state` varchar(200) NOT NULL,
6 PRIMARY KEY (`id`)
7);
8
9CREATE TABLE IF NOT EXISTS `users` (
10 `id` int(6) unsigned NOT NULL,
11 `name` varchar(200) NOT NULL,
12 `client_id` int(6) unsigned NOT NULL,
13 `avatar_link` varchar(200) NOT NULL,
14 PRIMARY KEY (`id`),
15 FOREIGN KEY (`client_id`) REFERENCES clients(id)
16);
17
18INSERT INTO `clients` (`id`, `name`, `city`, `state`) VALUES
19 ('1', 'Shanes Law Firm', 'Dallas', 'TX'),
20 ('2', 'Gate City Bank', 'Fargo', 'ND'),
21 ('3', 'Bell State Bank', 'Minneapolis', 'MN'),
22 ('4', 'Bobs Tire Shop', 'Austin', 'TX');
23
24 INSERT INTO `users` (`id`, `name`, `client_id`, `avatar_link`) VALUES
25 ('1', 'Shane', '1', 'https://i.ytimg.com/vi/7RMQksXpQSk/maxresdefault.jpg'),
26 ('2', 'Auggie', '1', 'http://cdn.akc.org/content/hero/gsd_police_dog_hero.jpg'),
27 ('3', 'Molly', '4', 'http://idosersoftware.com/images/Molly.jpg'),
28 ('4', 'Isreal', '3', 'https://s4.reutersmedia.net/resources/r/?m=02&d=20180102&t=2&i=1218743430&r=LYNXMPEE0105V&w=940');