/****** Object:  Database CodePpcApp    Script Date: 07/08/2002 17:59:29 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'CodePpcApp')
	DROP DATABASE [CodePpcApp]
GO

CREATE DATABASE [CodePpcApp]  ON (NAME = N'CodePpcApp_Data', FILENAME = N'C:\CodePpc\Db\CodePpcApp_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'CodePpcApp_Log', FILENAME = N'C:\CodePpc\Db\CodePpcApp_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE SQL_Latin1_General_CP850_CI_AS
GO

exec sp_dboption N'CodePpcApp', N'autoclose', N'false'
GO

exec sp_dboption N'CodePpcApp', N'bulkcopy', N'false'
GO

exec sp_dboption N'CodePpcApp', N'trunc. log', N'false'
GO

exec sp_dboption N'CodePpcApp', N'torn page detection', N'true'
GO

exec sp_dboption N'CodePpcApp', N'read only', N'false'
GO

exec sp_dboption N'CodePpcApp', N'dbo use', N'false'
GO

exec sp_dboption N'CodePpcApp', N'single', N'false'
GO

exec sp_dboption N'CodePpcApp', N'autoshrink', N'false'
GO

exec sp_dboption N'CodePpcApp', N'ANSI null default', N'false'
GO

exec sp_dboption N'CodePpcApp', N'recursive triggers', N'false'
GO

exec sp_dboption N'CodePpcApp', N'ANSI nulls', N'false'
GO

exec sp_dboption N'CodePpcApp', N'concat null yields null', N'false'
GO

exec sp_dboption N'CodePpcApp', N'cursor close on commit', N'false'
GO

exec sp_dboption N'CodePpcApp', N'default to local cursor', N'false'
GO

exec sp_dboption N'CodePpcApp', N'quoted identifier', N'false'
GO

exec sp_dboption N'CodePpcApp', N'ANSI warnings', N'false'
GO

exec sp_dboption N'CodePpcApp', N'auto create statistics', N'true'
GO

exec sp_dboption N'CodePpcApp', N'auto update statistics', N'true'
GO

use [CodePpcApp]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ARTICLE_AUTEUR]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[JOURNAL] DROP CONSTRAINT FK_ARTICLE_AUTEUR
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CLIENT_SPORT_CLIENT]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CLISPO] DROP CONSTRAINT FK_CLIENT_SPORT_CLIENT
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CLIENT_SPORT_SPORT]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CLISPO] DROP CONSTRAINT FK_CLIENT_SPORT_SPORT
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CLIENT_SPORT_ARTICLE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CLISPO] DROP CONSTRAINT FK_CLIENT_SPORT_ARTICLE
GO

/****** Object:  Table [dbo].[CLISPO]    Script Date: 07/08/2002 17:59:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CLISPO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CLISPO]
GO

/****** Object:  Table [dbo].[JOURNAL]    Script Date: 07/08/2002 17:59:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[JOURNAL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[JOURNAL]
GO

/****** Object:  Table [dbo].[AUTEUR]    Script Date: 07/08/2002 17:59:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AUTEUR]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[AUTEUR]
GO

/****** Object:  Table [dbo].[CLIENT]    Script Date: 07/08/2002 17:59:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CLIENT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CLIENT]
GO

/****** Object:  Table [dbo].[SPORT]    Script Date: 07/08/2002 17:59:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SPORT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SPORT]
GO

/****** Object:  Table [dbo].[AUTEUR]    Script Date: 07/08/2002 17:59:38 ******/
CREATE TABLE [dbo].[AUTEUR] (
	[AUT_ID] [int] NOT NULL ,
	[AUT_NAME] [nvarchar] (50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[CLIENT]    Script Date: 07/08/2002 17:59:44 ******/
CREATE TABLE [dbo].[CLIENT] (
	[CLI_ID] [int] NOT NULL ,
	[CLI_FIRSTNAME] [nvarchar] (50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[CLI_LASTNAME] [nvarchar] (25) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[CLI_ADRESSE] [nvarchar] (100) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[CLI_VILLE] [nvarchar] (25) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[CLI_CP] [nvarchar] (15) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[CLI_TEL] [nvarchar] (15) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[SPORT]    Script Date: 07/08/2002 17:59:46 ******/
CREATE TABLE [dbo].[SPORT] (
	[SPO_ID] [int] NOT NULL ,
	[SPO_NAME] [nvarchar] (25) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[JOURNAL]    Script Date: 07/08/2002 17:59:46 ******/
CREATE TABLE [dbo].[JOURNAL] (
	[JOU_ID] [int] NOT NULL ,
	[SPO_ID] [int] NOT NULL ,
	[AUT_ID] [int] NULL ,
	[ART_TITLE] [nvarchar] (50) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
	[ART_DATE] [datetime] NULL ,
	[rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[CLISPO]    Script Date: 07/08/2002 17:59:46 ******/
CREATE TABLE [dbo].[CLISPO] (
	[CLI_ID] [int] NOT NULL ,
	[SPO_ID] [int] NOT NULL ,
	[rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[AUTEUR] WITH NOCHECK ADD 
	CONSTRAINT [PK_AUTEUR] PRIMARY KEY  CLUSTERED 
	(
		[AUT_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD 
	CONSTRAINT [PK_CLIENT] PRIMARY KEY  CLUSTERED 
	(
		[CLI_ID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SPORT] WITH NOCHECK ADD 
	CONSTRAINT [PK_SPORT] PRIMARY KEY  CLUSTERED 
	(
		[SPO_ID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[JOURNAL] WITH NOCHECK ADD 
	CONSTRAINT [PK_ARTICLE] PRIMARY KEY  CLUSTERED 
	(
		[JOU_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CLISPO] WITH NOCHECK ADD 
	CONSTRAINT [PK_CLIENT_SPORT] PRIMARY KEY  CLUSTERED 
	(
		[CLI_ID],
		[SPO_ID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[CLIENT] WITH NOCHECK ADD 
	CONSTRAINT [DF__CLIENT__rowguid__5441852A] DEFAULT (newid()) FOR [rowguid]
GO

 CREATE  UNIQUE  INDEX [index_1993058136] ON [dbo].[CLIENT]([rowguid]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SPORT] WITH NOCHECK ADD 
	CONSTRAINT [DF__SPORT__rowguid__4E88ABD4] DEFAULT (newid()) FOR [rowguid]
GO

 CREATE  UNIQUE  INDEX [index_2009058193] ON [dbo].[SPORT]([rowguid]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[JOURNAL] WITH NOCHECK ADD 
	CONSTRAINT [DF__JOURNAL__rowguid__59FA5E80] DEFAULT (newid()) FOR [rowguid]
GO

 CREATE  UNIQUE  INDEX [index_2025058250] ON [dbo].[JOURNAL]([rowguid]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CLISPO] WITH NOCHECK ADD 
	CONSTRAINT [DF__CLISPO__rowguid__5FB337D6] DEFAULT (newid()) FOR [rowguid]
GO

 CREATE  UNIQUE  INDEX [index_2041058307] ON [dbo].[CLISPO]([rowguid]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[JOURNAL] ADD 
	CONSTRAINT [FK_ARTICLE_AUTEUR] FOREIGN KEY 
	(
		[AUT_ID]
	) REFERENCES [dbo].[AUTEUR] (
		[AUT_ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO

ALTER TABLE [dbo].[CLISPO] ADD 
	CONSTRAINT [FK_CLIENT_SPORT_ARTICLE] FOREIGN KEY 
	(
		[SPO_ID]
	) REFERENCES [dbo].[JOURNAL] (
		[JOU_ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE ,
	CONSTRAINT [FK_CLIENT_SPORT_CLIENT] FOREIGN KEY 
	(
		[CLI_ID]
	) REFERENCES [dbo].[CLIENT] (
		[CLI_ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE ,
	CONSTRAINT [FK_CLIENT_SPORT_SPORT] FOREIGN KEY 
	(
		[SPO_ID]
	) REFERENCES [dbo].[SPORT] (
		[SPO_ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO