|
|
USE [_Raster]
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[Application] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[Application](
|
|
|
[applikationsnr] [int] NOT NULL,
|
|
|
[version] [varchar](4) NULL,
|
|
|
[showlogin] [bit] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
[tmp_filepath] [varchar](255) NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[applikationsnr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[funktionsgruppe] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[funktionsgruppe](
|
|
|
[funktionsgruppenr] [int] NOT NULL,
|
|
|
[bezeichnung] [varchar](50) NULL,
|
|
|
[beschreibung] [varchar](50) NULL,
|
|
|
[zugehoerigkeit] [varchar](255) NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[funktionsgruppenr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[funktionsgruppe_rolle] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[funktionsgruppe_rolle](
|
|
|
[Funktionsgrupperollenr] [int] NOT NULL,
|
|
|
[funktionsgruppenr] [int] NULL,
|
|
|
[rollenr] [int] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[Funktionsgrupperollenr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[key_tabelle] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[key_tabelle](
|
|
|
[keynr] [int] IDENTITY(1,1) NOT NULL,
|
|
|
[beschreibung] [varchar](255) NOT NULL,
|
|
|
[key_wert] [int] NOT NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[keynr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[meldungstexte] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[meldungstexte](
|
|
|
[meldungstextnr] [int] NOT NULL,
|
|
|
[sprache] [int] NOT NULL,
|
|
|
[inhalt] [varchar](1024) NULL,
|
|
|
[Beschreibung] [varchar](255) NULL,
|
|
|
[aktiv] [bit] NOT NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[meldungstextnr] ASC,
|
|
|
[sprache] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[mitarbeiter] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[mitarbeiter](
|
|
|
[mitarbeiternr] [int] NOT NULL,
|
|
|
[vorname] [varchar](50) NULL,
|
|
|
[name] [varchar](50) NULL,
|
|
|
[tgnummer] [varchar](50) NULL,
|
|
|
[email] [varchar](50) NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[mitarbeiternr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[mitarbeiter_funktionsgruppe] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[mitarbeiter_funktionsgruppe](
|
|
|
[mitarbeiter_funktionsgruppenr] [int] NOT NULL,
|
|
|
[mitarbeiternr] [int] NULL,
|
|
|
[funktionsgruppenr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[mitarbeiter_funktionsgruppenr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[rolle] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[rolle](
|
|
|
[rollenr] [int] NOT NULL,
|
|
|
[bezeichnung] [varchar](255) NULL,
|
|
|
[beschreibung] [varchar](255) NULL,
|
|
|
[sysadminrolle] [bit] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[rollenr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[Rolle_SecurityObject] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[Rolle_SecurityObject](
|
|
|
[rolle_securityobjectnr] [int] NOT NULL,
|
|
|
[rollenr] [int] NULL,
|
|
|
[securityobjectnr] [int] NULL,
|
|
|
[readonly] [bit] NULL,
|
|
|
[invisible] [bit] NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[rolle_securityobjectnr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[rolle_sysadminfunktion] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[rolle_sysadminfunktion](
|
|
|
[rolle_sysadminfnktnr] [int] NOT NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
[sysadminfnktnr] [int] NULL,
|
|
|
[rollenr] [int] NULL,
|
|
|
[mandant] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[rolle_sysadminfnktnr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[SecurityObject] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[SecurityObject](
|
|
|
[SecurityObjectNr] [int] NOT NULL,
|
|
|
[SecurityForm] [varchar](50) NULL,
|
|
|
[SecurityObjectType] [varchar](50) NULL,
|
|
|
[SecurityObject] [varchar](50) NULL,
|
|
|
[SecurityObjectItem] [varchar](50) NULL,
|
|
|
[SecurityObjectDescriotion] [varchar](50) NULL,
|
|
|
[Level] [int] NULL,
|
|
|
[Aktiv] [bit] NULL,
|
|
|
[Erstellt_am] [datetime] NULL,
|
|
|
[Mutiert_am] [datetime] NULL,
|
|
|
[Mutierer] [int] NULL,
|
|
|
[Mandantnr] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[SecurityObjectNr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[spalten] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[spalten](
|
|
|
[eintragnr] [int] NOT NULL,
|
|
|
[tabelle] [varchar](255) NULL,
|
|
|
[tabellenspalte] [varchar](255) NULL,
|
|
|
[spalte] [varchar](255) NULL,
|
|
|
[Readonly] [bit] NOT NULL,
|
|
|
[alsHacken] [bit] NOT NULL,
|
|
|
[Breite] [int] NULL,
|
|
|
[Reihenfolge] [int] NULL,
|
|
|
[tiptext] [varchar](255) NULL,
|
|
|
[aktiv] [bit] NOT NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
[mandantnr] [int] NULL,
|
|
|
[NumberFormat] [varchar](255) NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[eintragnr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[sysadminfunktion] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[sysadminfunktion](
|
|
|
[sysadminfnktnr] [int] NOT NULL,
|
|
|
[bezeichnung] [varchar](255) NULL,
|
|
|
[ParentID] [int] NULL,
|
|
|
[Sort] [int] NULL,
|
|
|
[ImageIndex] [int] NULL,
|
|
|
[ImageIndexOpen] [int] NULL,
|
|
|
[ftop] [int] NULL,
|
|
|
[fleft] [int] NULL,
|
|
|
[fwidth] [int] NULL,
|
|
|
[fheight] [int] NULL,
|
|
|
[beschreibung] [varchar](255) NULL,
|
|
|
[mandantnr] [int] NOT NULL,
|
|
|
[sprache] [int] NOT NULL,
|
|
|
[aktiv] [bit] NULL,
|
|
|
[erstellt_am] [datetime] NULL,
|
|
|
[mutiert_am] [datetime] NULL,
|
|
|
[mutierer] [int] NULL,
|
|
|
[Domaintable] [varchar](255) NULL,
|
|
|
[KeyFields] [varchar](255) NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[sysadminfnktnr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
|
|
/****** Object: Table [dbo].[ToolTip] Script Date: 09.10.2015 07:35:08 ******/
|
|
|
SET ANSI_NULLS ON
|
|
|
GO
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
|
GO
|
|
|
SET ANSI_PADDING ON
|
|
|
GO
|
|
|
CREATE TABLE [dbo].[ToolTip](
|
|
|
[ToolTipNr] [int] NOT NULL,
|
|
|
[FormularName] [varchar](50) NULL,
|
|
|
[ControlName] [varchar](50) NULL,
|
|
|
[ToolTip] [varchar](1024) NULL,
|
|
|
[Aktiv] [bit] NULL,
|
|
|
[Erstellt_am] [datetime] NULL,
|
|
|
[Mutiert_am] [datetime] NULL,
|
|
|
[Mutierer] [int] NULL,
|
|
|
PRIMARY KEY CLUSTERED
|
|
|
(
|
|
|
[ToolTipNr] ASC
|
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
|
) ON [PRIMARY]
|
|
|
|
|
|
GO
|
|
|
SET ANSI_PADDING OFF
|
|
|
GO
|
