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