shu/Themenmanagement
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
Files
master
Themenmanagement/Implementierung_Mai_2013/Tabellen.sql
Stefan Hutter abc7a01a22 Initial commit
2020-10-21 10:49:38 +02:00

1102 lines
65 KiB
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
USE [TIM]
GO
/****** Object: Table [dbo].[Application] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_applikation] PRIMARY KEY CLUSTERED
(
[applikationsnr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Auswertung] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Auswertung](
[AuswertungNr] [int] NOT NULL,
[Bezeichnung] [varchar](50) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Report] [bit] NULL,
[Filename] [varchar](255) NULL,
[Excel_Report] [bit] NULL,
[SQL] [varchar](1024) NULL,
[SQLType] [varchar](50) NULL,
[Beschreibung] [varchar](1024) NULL,
[Connectionstring_Subreport] [varchar](255) NULL,
CONSTRAINT [PK_Auswertung] PRIMARY KEY CLUSTERED
(
[AuswertungNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[AuswertungAuswertungParameter] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AuswertungAuswertungParameter](
[AuswertungAuswertungparameternr] [int] NOT NULL,
[Auswertungnr] [int] NULL,
[Auswertungparameternr] [int] NULL,
[DBfeldname] [varchar](255) NULL,
[Reihenfolge] [int] NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_AuswertungAuswertungParameter] PRIMARY KEY CLUSTERED
(
[AuswertungAuswertungparameternr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[AuswertungGruppe] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AuswertungGruppe](
[AuswertungGruppeNr] [int] NOT NULL,
[Bezeichnung] [varchar](50) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Parentid] [int] NULL,
CONSTRAINT [PK_AuswertungGruppe] PRIMARY KEY CLUSTERED
(
[AuswertungGruppeNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[AuswertungGruppeAuswertung] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AuswertungGruppeAuswertung](
[AuswertungGruppeAuswertungNr] [int] NOT NULL,
[AuswertungGruppeNr] [int] NULL,
[AuswertungNr] [int] NULL,
[Aktiv] [bit] NULL,
[Erstllt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_AuswertungGruppeAuswertung] PRIMARY KEY CLUSTERED
(
[AuswertungGruppeAuswertungNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[AuswertungRptDatei] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AuswertungRptDatei](
[AuswertungDateiNr] [int] NOT NULL,
[Filename] [varchar](255) NULL,
[Reportname] [varchar](50) NULL,
[Reportfile] [image] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_AuswertungRptDatei] PRIMARY KEY CLUSTERED
(
[AuswertungDateiNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Auswertungsparameter] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Auswertungsparameter](
[Auswertungparameternr] [int] NOT NULL,
[Bezeichnung] [varchar](50) NULL,
[Operator] [varchar](50) NULL,
[Feldbezug] [varchar](200) NULL,
[Wert] [varchar](50) NULL,
[ParamName] [varchar](50) NULL,
[ParamType] [varchar](50) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Fix] [bit] NULL,
[FixOperator] [varchar](255) NULL,
[Visible] [bit] NULL,
[Defaultvalue] [varchar](255) NULL,
[Editable] [bit] NULL,
[Param_Name] [varchar](50) NULL,
CONSTRAINT [PK_Auswertungsparameter] PRIMARY KEY CLUSTERED
(
[Auswertungparameternr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Dokument] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Dokument](
[DokumentNr] [int] NOT NULL,
[KeyValue] [int] NULL,
[DokType] [int] NULL,
[DokumenttypNr] [int] NULL,
[Bezeichnung] [varchar](50) NULL,
[Beschreibung] [varchar](2048) NULL,
[Filename] [varchar](255) NULL,
[OriginalFilename_incl_Path] [varchar](255) NULL,
[Version] [varchar](50) NULL,
[VersionsNr] [varchar](50) NULL,
[Versionsdatum] [datetime] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Aktiv] [bit] NULL,
[SpeichertypNr] [int] NULL,
[DocImage] [image] NULL,
CONSTRAINT [PK_Dokument] PRIMARY KEY CLUSTERED
(
[DokumentNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[DokumentAblageort] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DokumentAblageort](
[DokumentablageortNr] [int] NOT NULL,
[DokumentablagetypNr] [int] NULL,
[DokumentNr] [int] NULL,
[Ablageort] [varchar](255) NULL,
[Beschreibung] [varchar](255) NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Aktiv] [bit] NULL,
[MandantNr] [int] NULL,
CONSTRAINT [PK_DokumentAblageort] PRIMARY KEY CLUSTERED
(
[DokumentablageortNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[DokumentAblageTyp] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DokumentAblageTyp](
[DokumentAblageTypNr] [int] NOT NULL,
[Bezeichnung] [varchar](255) NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Aktiv] [bit] NULL,
[MandantNr] [int] NULL,
CONSTRAINT [PK_DokumentAblageTyp] PRIMARY KEY CLUSTERED
(
[DokumentAblageTypNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Dokumenttyp] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Dokumenttyp](
[Dokumenttypnr] [int] NOT NULL,
[Bezeichnung] [varchar](255) NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Aktiv] [bit] NULL,
CONSTRAINT [PK_Dokumenttyp] PRIMARY KEY CLUSTERED
(
[Dokumenttypnr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[FulltextData] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FulltextData](
[nreintrag] [int] IDENTITY(1,1) NOT NULL,
[Themanr] [int] NULL,
[KeyValue] [int] NULL,
[Fulltext] [varchar](4986) NULL,
[Type] [int] NULL,
CONSTRAINT [PK_FulltextData] PRIMARY KEY CLUSTERED
(
[nreintrag] 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].[Funktion] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Funktion](
[FunktionNr] [int] NOT NULL,
[Bezeichnung] [varchar](255) NULL,
[Beschreibung] [varchar](255) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_Funktion] PRIMARY KEY CLUSTERED
(
[FunktionNr] 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: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_funktionsgruppe] PRIMARY KEY CLUSTERED
(
[funktionsgruppenr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Funktionsgruppe_auswertungGruppe] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Funktionsgruppe_auswertungGruppe](
[Funktionsgruppe_AuswertungGruppenr] [int] NOT NULL,
[funktionsgruppenr] [int] NULL,
[AuswertungGruppeNr] [int] NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_Funktionsgruppe_auswertungGruppe] PRIMARY KEY CLUSTERED
(
[Funktionsgruppe_AuswertungGruppenr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[funktionsgruppe_rolle] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_funktionsgruppe_rolle] PRIMARY KEY CLUSTERED
(
[Funktionsgrupperollenr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Journal] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Journal](
[Journaleintragnr] [int] IDENTITY(1,1) NOT NULL,
[Themanr] [int] NULL,
[Beschreibung] [varchar](2559) NULL,
[Mutierer] [varchar](255) NULL,
[Erstellt_am] [datetime] NULL,
CONSTRAINT [PK_Journal] PRIMARY KEY CLUSTERED
(
[Journaleintragnr] 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].[Kategorie] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Kategorie](
[KategorieNr] [int] NOT NULL,
[Parentid] [int] NULL,
[Bezeichnung] [varchar](255) NULL,
[Beschreibung] [varchar](1024) NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_Kategorie] PRIMARY KEY CLUSTERED
(
[KategorieNr] 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].[key_tabelle] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_key_tabelle] PRIMARY KEY CLUSTERED
(
[keynr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Kommunikation] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Kommunikation](
[KommunikationNr] [int] NOT NULL,
[ThemaNr] [int] NULL,
[Bezeichnung] [varchar](255) NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_Kommunikation] PRIMARY KEY CLUSTERED
(
[KommunikationNr] 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].[KommunikationAuspraegung_Zielgruppe] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KommunikationAuspraegung_Zielgruppe](
[KommAuspraegungZielgruppeNr] [int] NOT NULL,
[Kommunikationauspraegungnr] [int] NULL,
[Zielgruppenr] [int] NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_KommunikationAuspraegung_Zielgruppe] PRIMARY KEY CLUSTERED
(
[KommAuspraegungZielgruppeNr] 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].[KommunkationAuspraegung] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KommunkationAuspraegung](
[KommunikationAuspraegungNr] [int] NOT NULL,
[KommunikationNr] [int] NULL,
[Bezeichnung] [varchar](255) NULL,
[Beschreibung] [varchar](255) NULL,
[Dokument] [image] NULL,
[RTFText] [varchar](max) NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_KommunkationAuspraegung] PRIMARY KEY CLUSTERED
(
[KommunikationAuspraegungNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[meldungstexte] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_meldungstexte] 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, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mitarbeiter] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
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,
CONSTRAINT [PK_mitarbeiter] PRIMARY KEY CLUSTERED
(
[mitarbeiternr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[mitarbeiter_funktionsgruppe] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_mitarbeiter_funktionsgruppe] 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, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Nebenkategorie] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Nebenkategorie](
[NebenkategorieNr] [int] IDENTITY(1,1) NOT NULL,
[KategorieNr] [int] NULL,
[Themanr] [int] NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_Nebenkategorie] PRIMARY KEY CLUSTERED
(
[NebenkategorieNr] 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].[Pendenz] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Pendenz](
[PendenzNr] [int] NOT NULL,
[Themanr] [int] NULL,
[Verantwortlich] [varchar](50) NULL,
[PendenzStatusNr] [int] NULL,
[Bezeichnung] [varchar](50) NULL,
[Beschreibung] [varchar](255) NULL,
[Termin] [datetime] NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[MandantNr] [int] NULL,
CONSTRAINT [PK_Pendenz] PRIMARY KEY CLUSTERED
(
[PendenzNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Pendenzstatus] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Pendenzstatus](
[PendenzStatusNr] [int] NOT NULL,
[Bezeichnung] [varchar](50) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[Mandantnr] [int] NULL,
[Pendenz_Aktivieren] [bit] NULL,
[Pendenz_Inaktivieren] [bit] NULL,
CONSTRAINT [PK_Pendenzstatus] PRIMARY KEY CLUSTERED
(
[PendenzStatusNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[pendenzuebersicht] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pendenzuebersicht](
[PendenzNr] [int] NOT NULL,
[themanr] [int] NULL,
[Verantwortlich] [varchar](50) NULL,
[PendenzStatusNr] [int] NULL,
[Bezeichnung] [varchar](50) NULL,
[Beschreibung] [varchar](255) NULL,
[Termin] [datetime] NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
[MandantNr] [int] NULL,
[Pendenzstatus] [varchar](50) NULL,
[Thema] [varchar](255) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Person] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Person](
[PersonNr] [int] NOT NULL,
[Firma] [varchar](50) NULL,
[Name] [varchar](50) NULL,
[Vorname] [varchar](50) NULL,
[Strasse] [varchar](50) NULL,
[Postfach] [varchar](50) NULL,
[Plz] [varchar](50) NULL,
[Ort] [varchar](50) NULL,
[Telefon] [varchar](50) NULL,
[Telefax] [varchar](50) NULL,
[EMail] [varchar](50) NULL,
[Internet] [varchar](50) NULL,
[Bemerkung] [varchar](255) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED
(
[PersonNr] 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] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [pk_rolle] PRIMARY KEY CLUSTERED
(
[rollenr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Rolle_SecurityObject] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_Rolle_SecurityObject] 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, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[rolle_sysadminfunktion] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [pk_rolle_sysadminfunktion] 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, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[SecurityObject] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_Security_Object] PRIMARY KEY CLUSTERED
(
[SecurityObjectNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[spalten] Script Date: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_spalten] PRIMARY KEY CLUSTERED
(
[eintragnr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SpeicherTyp] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SpeicherTyp](
[SpeicherTypNr] [int] NOT NULL,
[Bezeichnung] [varchar](255) NULL,
[Beschreibung] [varchar](1024) NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_SpeicherTyp] PRIMARY KEY CLUSTERED
(
[SpeicherTypNr] 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: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_sysadminfunktion] PRIMARY KEY CLUSTERED
(
[sysadminfnktnr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Thema] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Thema](
[ThemanNr] [int] NOT NULL,
[Titel] [varchar](255) NULL,
[KategorieNr] [int] NULL,
[Beschreibung] [varchar](1024) NULL,
[Suchbegriffe] [varchar](1024) NULL,
[Gueltig_ab] [datetime] NULL,
[Gueltig_bis] [datetime] NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_Thema] PRIMARY KEY CLUSTERED
(
[ThemanNr] 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].[ThemaEntwicklung] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ThemaEntwicklung](
[ThemaEntwicklungNr] [int] NOT NULL,
[ThemaNr] [int] NULL,
[Bezeichnung] [varchar](255) NULL,
[Dokument] [image] NULL,
[RTFText] [varchar](max) NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_ThemaEintrag] PRIMARY KEY CLUSTERED
(
[ThemaEntwicklungNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ThemaEntwicklungJournal] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ThemaEntwicklungJournal](
[ThemaEntwicklungJournalNr] [int] IDENTITY(1,1) NOT NULL,
[ThemaEntwicklungNr] [int] NULL,
[Journaldatum] [datetime] NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_ThemaEntwicklungJournal] PRIMARY KEY CLUSTERED
(
[ThemaEntwicklungJournalNr] 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].[ThemaPerson] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ThemaPerson](
[ThemaPersonNr] [int] NOT NULL,
[ThemaNr] [int] NULL,
[PersonNr] [int] NULL,
[FunktionNr] [int] NULL,
[Bemerkung] [varchar](255) NULL,
[Aktiv] [bit] NULL,
[Erstellt_am] [datetime] NULL,
[Mutiert_am] [datetime] NULL,
[Mutierer] [int] NULL,
CONSTRAINT [PK_ThemaPerson] PRIMARY KEY CLUSTERED
(
[ThemaPersonNr] 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: 12.05.2013 10:10:00 ******/
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,
CONSTRAINT [PK_ToolTip] PRIMARY KEY CLUSTERED
(
[ToolTipNr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Zielgruppe] Script Date: 12.05.2013 10:10:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Zielgruppe](
[ZielgruppeNr] [int] NOT NULL,
[Bezeichnung] [varchar](255) NULL,
[Beschreibung] [varchar](255) NULL,
[aktiv] [bit] NULL,
[erstellt_am] [datetime] NULL,
[mutiert_am] [datetime] NULL,
[mutierer] [int] NULL,
CONSTRAINT [PK_Zielgruppe] PRIMARY KEY CLUSTERED
(
[ZielgruppeNr] 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
Reference in New Issue View Git Blame Copy Permalink