if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PLANNING]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PLANNING]
GO

CREATE TABLE [dbo].[PLANNING] (
	[FDV_COD] [varchar] (6) COLLATE French_CI_AS NOT NULL ,
	[PLA_DAT] [datetime] NOT NULL ,
	[PLA_HH] [varchar] (5) COLLATE French_CI_AS NOT NULL ,
	[CL_COD] [varchar] (12) COLLATE French_CI_AS NULL ,
	[PLA_TOPVIS] [varchar] (1) COLLATE French_CI_AS NULL ,
	[ACT_COD] [varchar] (5) COLLATE French_CI_AS NULL ,
	[ACT_TYP] [varchar] (1) COLLATE French_CI_AS NULL ,
	[PLA_CMT] [varchar] (30) COLLATE French_CI_AS NULL ,
	[PLA_RDV] [varchar] (1) COLLATE French_CI_AS NULL ,
	[PLA_AVP] [varchar] (1) COLLATE French_CI_AS NULL ,
	[PLA_VPT] [varchar] (1) COLLATE French_CI_AS NULL ,
	[PLA_STA] [varchar] (1) COLLATE French_CI_AS NULL ,
	[WTV_COD] [varchar] (3) COLLATE French_CI_AS NULL ,
	[TPMAJ] [varchar] (1) COLLATE French_CI_AS NULL ,
	[TRMAJ] [varchar] (1) COLLATE French_CI_AS NULL ,
	[ORMAJ] [varchar] (6) COLLATE French_CI_AS NULL ,
	[DHMAJ] [datetime] NULL 
) ON [PRIMARY]
GO