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
| CREATE TABLE #Z_Perm_Temp(
[UserCode] [varchar](18),
[IdAcces] [int] NOT NULL,
[Niveau] [int] NOT NULL DEFAULT (0),
[Ordre] [smallint] NOT NULL DEFAULT (0),
[Parm] [char](20) NOT NULL DEFAULT (''),
[SousNiveau] [int] NOT NULL DEFAULT (0),
[TypeMenu] [smallint] NOT NULL DEFAULT (0),
[TypeAct] [smallint] NOT NULL DEFAULT (0),
[CF_Descr] [varchar](40) NOT NULL DEFAULT (''),
[Status] [int])
CREATE TABLE [dbo].[Z_Menu](
[Niveau] [int] NOT NULL CONSTRAINT [DF__Z_Menu_Tm__Nivea__4381D8D3] DEFAULT (0),
[Ordre] [smallint] NOT NULL CONSTRAINT [DF__Z_Menu_Tm__Ordre__4475FD0C] DEFAULT (0),
[NomDll] [char](8) NOT NULL CONSTRAINT [DF__Z_Menu_Tm__NomDl__456A2145] DEFAULT (''),
[Parm] [char](20) NOT NULL CONSTRAINT [DF__Z_Menu_Tmp__Parm__465E457E] DEFAULT (''),
[IdAcces] [int] NOT NULL CONSTRAINT [DF__Z_Menu_Tm__IdAcc__475269B7] DEFAULT (0),
[SousNiveau] [int] NOT NULL CONSTRAINT [DF__Z_Menu_Tm__SousN__48468DF0] DEFAULT (0),
[TypeMenu] [smallint] NOT NULL CONSTRAINT [DF__Z_Menu_Tm__TypeM__493AB229] DEFAULT (0),
[TypeAct] [smallint] NOT NULL CONSTRAINT [DF__Z_Menu_Tm__TypeA__4A2ED662] DEFAULT (0),
[CF_Descr] [varchar](40) NOT NULL CONSTRAINT [DF__Z_Menu_Tm__CF_De__4B22FA9B] DEFAULT (''),
[US_Descr] [varchar](40) NOT NULL CONSTRAINT [DF__Z_Menu_Tm__US_De__4C171ED4] DEFAULT (''),
[PageWeb] [char](255) NOT NULL CONSTRAINT [DF__Z_Menu_Tm__PageW__4D0B430D] DEFAULT ('')
) ON [DATA]
CREATE TABLE [dbo].[Z_Perm](
[UserCode] [varchar](18) NOT NULL,
[IdAcces] [int] NOT NULL CONSTRAINT [DF_Z_Perm_IdAcces] DEFAULT (0)
) ON [DATA] |
Partager