dbScripter/database_setup_script at master · mpmcpherson/dbScripter · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
-- people
create table people
(
	id int auto_increment,
	first_name nvarchar(20) not null,
	last_name nvarchar(20) not null,
    constraint people_pk
		primary key (id)
);

create unique index people_id_uindex
	on people (id);

-- places

create table places
(
	id int auto_increment,
	address_line_one nvarchar(200) not null,
	address_line_two nvarchar(200) not null,
	notes nvarchar(350) null,
    constraint places_pk
		primary key (id)
);

create unique index places_id_uindex
	on places (id);


-- industry
create table industry
(
	id int auto_increment,
	industry_name nvarchar(45) not null,
    constraint industry_pk
		primary key (id)
);

create unique index industry_id_uindex
	on industry (id);


-- company
create table company
(
	id int auto_increment,
	company_name nvarchar(100) not null,
	constraint company_pk
		primary key (id)
);

create unique index company_id_uindex
	on company (id);