xref: /netbsd-src/external/bsd/openldap/dist/servers/slapd/back-sql/rdbms_depend/mssql/testdb_create.sql (revision 2de962bd804263c16657f586aa00f1704045df8e)
1
2CREATE TABLE authors_docs (
3	pers_id int NOT NULL ,
4	doc_id int NOT NULL
5)
6GO
7
8CREATE TABLE documents (
9	id int IDENTITY (1, 1) NOT NULL ,
10	abstract varchar (255) NULL ,
11	title varchar (255) NULL ,
12	body binary (255) NULL
13)
14GO
15
16CREATE TABLE institutes (
17	id int IDENTITY (1, 1) NOT NULL ,
18	name varchar (255) NOT NULL
19)
20GO
21
22
23CREATE TABLE persons (
24	id int IDENTITY (1, 1) NOT NULL ,
25	name varchar (255) NULL ,
26	surname varchar (255) NULL ,
27	password varchar (64) NULL
28)
29GO
30
31CREATE TABLE phones (
32	id int IDENTITY (1, 1) NOT NULL ,
33	phone varchar (255) NOT NULL ,
34	pers_id int NOT NULL
35)
36GO
37
38ALTER TABLE authors_docs WITH NOCHECK ADD
39	CONSTRAINT PK_authors_docs PRIMARY KEY
40	(
41		pers_id,
42		doc_id
43	)
44GO
45
46ALTER TABLE documents WITH NOCHECK ADD
47	CONSTRAINT PK_documents PRIMARY KEY
48	(
49		id
50	)
51GO
52
53ALTER TABLE institutes WITH NOCHECK ADD
54	CONSTRAINT PK_institutes PRIMARY KEY
55	(
56		id
57	)
58GO
59
60
61ALTER TABLE persons WITH NOCHECK ADD
62	CONSTRAINT PK_persons PRIMARY KEY
63	(
64		id
65	)
66GO
67
68ALTER TABLE phones WITH NOCHECK ADD
69	CONSTRAINT PK_phones PRIMARY KEY
70	(
71		id
72	)
73GO
74
75