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
54
55
56
57
58
59
60
61
62
63
64
| -- SQL Manager 2005 Lite for SQL Server (2.2.0.1)
-- ---------------------------------------
-- Host : (local)\SQLEXPRESS
-- Database : dbpersonnes
--
-- Structure for table PERSONNES :
--
CREATE TABLE [dbo].[PERSONNES] (
[ID] int IDENTITY(1, 1) NOT NULL,
[VERSION] int NOT NULL,
[NOM] varchar(30) COLLATE French_CI_AS NOT NULL,
[PRENOM] varchar(30) COLLATE French_CI_AS NOT NULL,
[DATENAISSANCE] datetime NOT NULL,
[MARIE] tinyint NOT NULL,
[NBENFANTS] tinyint NOT NULL,
CONSTRAINT [PERSONNES_ck_NBENFANTS] CHECK ([NBENFANTS]>=(0)),
CONSTRAINT [PERSONNES_ck_NOM] CHECK ([NOM]<>''),
CONSTRAINT [PERSONNES_ck_PRENOM] CHECK ([PRENOM]<>'')
)
ON [PRIMARY]
GO
--
-- Data for table PERSONNES (LIMIT 0,500)
--
SET IDENTITY_INSERT [dbo].[PERSONNES] ON
GO
INSERT INTO [dbo].[PERSONNES] ([ID], [VERSION], [NOM], [PRENOM], [DATENAISSANCE], [MARIE], [NBENFANTS])
VALUES
(1, 1, 'Major', 'Joachim', '19541113', 1, 2)
GO
INSERT INTO [dbo].[PERSONNES] ([ID], [VERSION], [NOM], [PRENOM], [DATENAISSANCE], [MARIE], [NBENFANTS])
VALUES
(2, 1, 'Humbort', 'Mélanie', '19850212', 0, 1)
GO
INSERT INTO [dbo].[PERSONNES] ([ID], [VERSION], [NOM], [PRENOM], [DATENAISSANCE], [MARIE], [NBENFANTS])
VALUES
(3, 1, 'Lemarchand', 'Charles', '19860301', 0, 0)
GO
SET IDENTITY_INSERT [dbo].[PERSONNES] OFF
GO
--
-- Definition for indices :
--
ALTER TABLE [dbo].[PERSONNES]
ADD PRIMARY KEY CLUSTERED ([ID])
WITH (
PAD_INDEX = OFF,
IGNORE_DUP_KEY = OFF,
STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO |
