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
| voici le debut du script/****** Object: Schema [ASPNET] Script Date: 03/11/2006 12:14:42 ******/
--IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'ASPNET')
--EXEC sys.sp_executesql N'CREATE SCHEMA [ASPNET] AUTHORIZATION [XXXXXXXXX\ASPNET]'
/****** Object: StoredProcedure [dbo].[object_grp] Script Date: 03/11/2006 12:14:42 ******/
SET ANSI_NULLS OFF;
SET QUOTED_IDENTIFIER OFF;
/****** Object: Table [dbo].[LIST_USERS] Script Date: 03/11/2006 12:14:43 ******/
SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LIST_USERS]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[LIST_USERS](
[LIST_ID] [int] NOT NULL,
[USER_ID] [int] NOT NULL,
CONSTRAINT [IX_LIST_USERS] UNIQUE NONCLUSTERED
(
[LIST_ID] ASC,
[USER_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
/****** Object: Table [dbo].[PEOPLE] Script Date: 03/11/2006 12:14:43 ******/
SET ANSI_NULLS ON;
SET QUOTED_IDENTIFIER ON;
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PEOPLE]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PEOPLE](
[ID_PEOPLE] [int] IDENTITY(1,1) NOT NULL,
[NOM] [varchar](20) NOT NULL,
[PRENOM] [varchar](20) NOT NULL,
[PASSWORD] [varchar](10) NOT NULL,
[NBR_LOGIN] [int] NOT NULL,
[LAST_LOG] [datetime] NULL,
[FONCTION] [varchar](40) NOT NULL,
[LANG] [varchar](3) NULL,
[EMAIL] [varchar](100) NULL,
[SERVICE] [int] NULL,
[DEF_GRP] [int] NULL,
[TELEPHONE] [varchar](15) NULL,
[COMMENTAIRES] [nvarchar](400) NULL,
CONSTRAINT [IX_PEOPLE] PRIMARY KEY NONCLUSTERED
(
[ID_PEOPLE] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END |
Partager