
/* Strukturinitialisierung für die Datenbank FKL der mobilen Datenerfassung
	Generierung: Hauptdatenbank skripten und Benutzerrollen durch public ersetzen

	2024-03-30	erstellt
	*/

use FKL
go

CREATE SCHEMA [GDT] AUTHORIZATION [dbo]
go
CREATE SCHEMA [GDV] AUTHORIZATION [dbo]
GO

/****** Object:  Table [dbo].[abschnitt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[abschnitt](
	[aID] [int] IDENTITY(1,1) NOT NULL,
	[aWasserkoerper] [int] NULL,
	[aBezeichnung] [varchar](80) NULL,
	[aOrdnung] [int] NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[aHMWB] [char](1) NULL,
	[aHost] [int] NULL,
	[aHostID] [int] NULL,
	[aImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[abschnitt] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[abschnitt] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[abschnitt] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[abschnitt] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[abschnitt] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[bewertung]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[bewertung](
	[bID] [int] IDENTITY(1,1) NOT NULL,
	[bAbschnitt] [int] NOT NULL,
	[bDatum] [datetime] NULL,
	[bNote] [float] NULL,
	[bPraedikat] [int] NULL,
	[bAnmerkungen] [text] NULL,
	[bNachbefischen] [char](1) NULL,
	[bGesamtbewertung] [int] NULL,
	[bHost] [int] NULL,
	[bHostID] [int] NULL,
	[bImportiert] [char](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[bewertung] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[bewertung] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[bewertung] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[bewertung] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[bewertung] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[cons]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cons](
	[cID] [int] IDENTITY(1,1) NOT NULL,
	[cTabelle] [varchar](35) NOT NULL,
	[cGeloescht] [int] NOT NULL,
	[cKonsolidiert] [int] NOT NULL,
	[cHost] [int] NULL,
	[cHostID] [int] NULL,
	[cImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[cons] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[cons] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[cons] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[cons] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[cons] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[dtproperties]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dtproperties](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[objectid] [int] NULL,
	[property] [varchar](64) NOT NULL,
	[value] [varchar](255) NULL,
	[uvalue] [nvarchar](255) NULL,
	[lvalue] [image] NULL,
	[version] [int] NOT NULL,
 CONSTRAINT [pk_dtproperties] PRIMARY KEY CLUSTERED 
(
	[id] ASC,
	[property] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[dtproperties] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[dtproperties] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[dtproperties] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[dtproperties] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[dtproperties] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[dummy]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dummy](
	[dmID] [int] IDENTITY(1,1) NOT NULL,
	[dmReferenz] [int] NULL,
	[dmBewertung] [int] NULL,
	[dmOn] [char](1) NULL,
	[dmHost] [int] NULL,
	[dmHostID] [int] NULL,
	[dmImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[dummy] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[dummy] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[dummy] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[dummy] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[dummy] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[einrichtung]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[einrichtung](
	[erID] [int] IDENTITY(1,1) NOT NULL,
	[erEinrichtungsart] [char](1) NULL,
	[erBezeichnung] [varchar](80) NULL,
	[erPerson_vname] [varchar](40) NULL,
	[erPerson_name] [varchar](40) NULL,
	[erStrasse] [varchar](80) NULL,
	[erPLZ] [varchar](10) NULL,
	[erOrt] [varchar](40) NULL,
	[erTelefon] [varchar](20) NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[erImportiert] [char](1) NULL,
	[erHost] [int] NULL,
	[erHostID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[einrichtung] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[einrichtung] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[einrichtung] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[einrichtung] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[einrichtung] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[fangprot]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fangprot](
	[fpID] [int] IDENTITY(1,1) NOT NULL,
	[fpProbestelle] [int] NOT NULL,
	[fpFischart] [int] NOT NULL,
	[fpAnz_1_4] [int] NULL,
	[fpAnz_5_9] [int] NULL,
	[fpAnz_10_14] [int] NULL,
	[fpAnz_15_19] [int] NULL,
	[fpAnz_20_24] [int] NULL,
	[fpAnz_25_29] [int] NULL,
	[fpAnz_30_39] [int] NULL,
	[fpAnz_40_49] [int] NULL,
	[fpAnz_50_59] [int] NULL,
	[fpAnz_60_69] [int] NULL,
	[fpAnz_70_n] [int] NULL,
	[fpAnz_ges] [int] NULL,
	[fpAnz_ha] [float] NULL,
	[fpAnz_100m] [float] NULL,
	[fpGewicht_ges] [float] NULL,
	[fpGewicht_ha] [float] NULL,
	[fpGewicht_100m] [float] NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[fpAnz_0_2] [int] NULL,
	[fpImportiert] [char](1) NULL,
	[fpHost] [int] NULL,
	[fpHostID] [int] NULL,
	[fpWeibchen] [int] NULL,
	[fpGewicht_max] [float] NULL,
	[fpGewicht_avg] [float] NULL,
	[fpHochgerechnet] [char](1) NULL,
	[fpIDUrwerte] [int] NULL,
	[fpAnz_zusatz] [int] NULL,
	[fpWeibchenRel] [float] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[fangprot] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[fangprot] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[fangprot] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[fangprot] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[fangprot] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[fangprot_wiss]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fangprot_wiss](
	[fpwID] [int] IDENTITY(1,1) NOT NULL,
	[fpwProbestelle] [int] NOT NULL,
	[fpwFischart] [int] NOT NULL,
	[fpwStueckmasse] [int] NULL,
	[fpwTotallaenge] [float] NULL,
	[fpwSchuppenprobe] [char](1) NULL,
	[fpwDarmprobe] [char](1) NULL,
	[fpwBemerkung] [varchar](125) NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[fpwStueckmasse_g] [float] NULL,
	[fpwImportiert] [char](1) NULL,
	[fpwHost] [int] NULL,
	[fpwHostID] [int] NULL,
	[fpwGeraetNr] [int] NULL,
	[fpwStueckNr] [int] NULL,
	[fpwGeschlecht] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[fangprot_wiss] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[fangprot_wiss] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[fangprot_wiss] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[fangprot_wiss] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[fangprot_wiss] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[fischart]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[fischart](
	[fID] [int] IDENTITY(1,1) NOT NULL,
	[fKuerzel] [varchar](10) NULL,
	[fBez_deutsch] [varchar](80) NULL,
	[fBez_latein] [varchar](80) NULL,
	[fGueltig] [char](1) NULL,
	[fFaktor] [float] NULL,
	[fExponent] [float] NULL,
	[fFormel] [varchar](80) NULL,
	[fVon_cm] [int] NULL,
	[fBis_cm] [int] NULL,
	[fGattung] [char](1) NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[fGefaehrdung] [varchar](10) NULL,
	[fReferenz] [int] NULL,
	[fImportiert] [char](1) NULL,
	[fHost] [int] NULL,
	[fHostID] [int] NULL,
	[fAdultAb_cm] [int] NULL,
	[fDVNr] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[fischart] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[fischart] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[fischart] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[fischart] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[fischart] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[gebiet]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gebiet](
	[gtID] [int] IDENTITY(1,1) NOT NULL,
	[gtBezeichnung] [varchar](255) NULL,
	[gtWKMuster] [varchar](255) NULL,
	[gtHost] [int] NULL,
	[gtHostID] [int] NULL,
	[gtImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[gebiet] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[gebiet] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[gebiet] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[gebiet] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[gebiet] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[gebiets_kz]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gebiets_kz](
	[gID] [int] IDENTITY(1,1) NOT NULL,
	[gGewaesser] [varchar](80) NULL,
	[gGebiets_kz] [varchar](20) NULL,
	[gGueltig] [char](1) NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[gTyp] [int] NULL,
	[gStandard] [char](1) NULL,
	[gBezeichnungszusatz] [varchar](80) NULL,
	[gBeginn] [varchar](80) NULL,
	[gEnde] [varchar](80) NULL,
	[gLaenge] [float] NULL,
	[gFlaecheEZG] [float] NULL,
	[gFlaecheEigenEZG] [float] NULL,
	[gImportiert] [char](1) NULL,
	[gHost] [int] NULL,
	[gHostID] [int] NULL,
	[gOWK] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[gebiets_kz] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[gebiets_kz] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[gebiets_kz] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[gebiets_kz] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[gebiets_kz] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[gemeinde]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gemeinde](
	[gemID] [int] IDENTITY(1,1) NOT NULL,
	[gemNr] [varchar](10) NULL,
	[gemName] [varchar](40) NULL,
	[gemKreis] [varchar](40) NULL,
	[gemGueltig] [char](1) NULL,
	[gemNrFrueher] [varchar](10) NULL,
	[gemNameFrueher] [varchar](40) NULL,
	[gemImportiert] [char](1) NULL,
	[gemHost] [int] NULL,
	[gemHostID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[gemeinde] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[gemeinde] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[gemeinde] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[gemeinde] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[gemeinde] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[gesamtbewertung]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[gesamtbewertung](
	[gbID] [int] IDENTITY(1,1) NOT NULL,
	[gbWasserkoerper] [int] NULL,
	[gbDatum] [datetime] NULL,
	[gbNote] [float] NULL,
	[gbPraedikat] [int] NULL,
	[gbHost] [int] NULL,
	[gbHostID] [int] NULL,
	[gbImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[gesamtbewertung] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[gesamtbewertung] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[gesamtbewertung] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[gesamtbewertung] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[gesamtbewertung] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[k2ps_msel]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[k2ps_msel](
	[k2ps_mselProbestelle] [int] NOT NULL,
	[k2ps_mselKatalog] [int] NOT NULL,
	[k2ps_mselDelete] [char](1) NULL,
	[k2ps_mselID] [int] IDENTITY(1,1) NOT NULL,
	[k2ps_mselImportiert] [char](1) NULL,
	[k2ps_mselHost] [int] NULL,
	[k2ps_mselHostID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[k2ps_msel] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[k2ps_msel] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[k2ps_msel] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[k2ps_msel] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[k2ps_msel] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[katalog]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[katalog](
	[kID] [int] IDENTITY(1,1) NOT NULL,
	[kKatalogart] [varchar](20) NULL,
	[kDaten] [varchar](80) NULL,
	[kGueltig] [char](1) NULL,
	[kOrdnung] [int] NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[kImportiert] [char](1) NULL,
	[kHost] [int] NULL,
	[kHostID] [int] NULL,
	[kFarbe] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[katalog] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[katalog] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[katalog] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[katalog] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[katalog] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[masz]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[masz](
	[mID] [int] IDENTITY(1,1) NOT NULL,
	[mBezeichnung] [varchar](80) NOT NULL,
	[mKlassifikation] [varchar](10) NULL,
	[mOrdnung] [int] NULL,
	[mIndex] [int] NULL,
	[mHost] [int] NULL,
	[mHostID] [int] NULL,
	[mImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[masz] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[masz] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[masz] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[masz] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[masz] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[mg_translation]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mg_translation](
	[mgtID] [int] IDENTITY(1,1) NOT NULL,
	[mgtBezeichnung] [varchar](40) NULL,
	[mgtID1] [int] NULL,
	[mgtID2] [int] NULL,
	[mgtP11] [nvarchar](255) NULL,
	[mgtP12] [nvarchar](255) NULL,
	[mgtP13] [nvarchar](255) NULL,
	[mgtP21] [nvarchar](255) NULL,
	[mgtP22] [nvarchar](255) NULL,
	[mgtP23] [nvarchar](255) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[mg_translation] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[mg_translation] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[mg_translation] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[mg_translation] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[mg_translation] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[pbcatcol]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pbcatcol](
	[pbc_tnam] [char](30) NULL,
	[pbc_tid] [int] NULL,
	[pbc_ownr] [char](30) NULL,
	[pbc_cnam] [char](30) NULL,
	[pbc_cid] [smallint] NULL,
	[pbc_labl] [varchar](254) NULL,
	[pbc_lpos] [smallint] NULL,
	[pbc_hdr] [varchar](254) NULL,
	[pbc_hpos] [smallint] NULL,
	[pbc_jtfy] [smallint] NULL,
	[pbc_mask] [varchar](31) NULL,
	[pbc_case] [smallint] NULL,
	[pbc_hght] [smallint] NULL,
	[pbc_wdth] [smallint] NULL,
	[pbc_ptrn] [varchar](31) NULL,
	[pbc_bmap] [char](1) NULL,
	[pbc_init] [varchar](254) NULL,
	[pbc_cmnt] [varchar](254) NULL,
	[pbc_edit] [varchar](31) NULL,
	[pbc_tag] [varchar](254) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[pbcatcol] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[pbcatcol] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[pbcatcol] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[pbcatcol] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[pbcatcol] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[pbcatedt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pbcatedt](
	[pbe_name] [varchar](30) NOT NULL,
	[pbe_edit] [varchar](254) NULL,
	[pbe_type] [smallint] NOT NULL,
	[pbe_cntr] [int] NULL,
	[pbe_seqn] [smallint] NOT NULL,
	[pbe_flag] [int] NULL,
	[pbe_work] [char](32) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[pbcatedt] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[pbcatedt] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[pbcatedt] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[pbcatedt] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[pbcatedt] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[pbcatfmt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pbcatfmt](
	[pbf_name] [varchar](30) NOT NULL,
	[pbf_frmt] [varchar](254) NOT NULL,
	[pbf_type] [smallint] NOT NULL,
	[pbf_cntr] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[pbcatfmt] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[pbcatfmt] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[pbcatfmt] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[pbcatfmt] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[pbcatfmt] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[pbcattbl]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pbcattbl](
	[pbt_tnam] [char](30) NULL,
	[pbt_tid] [int] NULL,
	[pbt_ownr] [char](30) NULL,
	[pbd_fhgt] [smallint] NULL,
	[pbd_fwgt] [smallint] NULL,
	[pbd_fitl] [char](1) NULL,
	[pbd_funl] [char](1) NULL,
	[pbd_fchr] [smallint] NULL,
	[pbd_fptc] [smallint] NULL,
	[pbd_ffce] [char](32) NULL,
	[pbh_fhgt] [smallint] NULL,
	[pbh_fwgt] [smallint] NULL,
	[pbh_fitl] [char](1) NULL,
	[pbh_funl] [char](1) NULL,
	[pbh_fchr] [smallint] NULL,
	[pbh_fptc] [smallint] NULL,
	[pbh_ffce] [char](32) NULL,
	[pbl_fhgt] [smallint] NULL,
	[pbl_fwgt] [smallint] NULL,
	[pbl_fitl] [char](1) NULL,
	[pbl_funl] [char](1) NULL,
	[pbl_fchr] [smallint] NULL,
	[pbl_fptc] [smallint] NULL,
	[pbl_ffce] [char](32) NULL,
	[pbt_cmnt] [varchar](254) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[pbcattbl] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[pbcattbl] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[pbcattbl] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[pbcattbl] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[pbcattbl] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[pbcatvld]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pbcatvld](
	[pbv_name] [varchar](30) NOT NULL,
	[pbv_vald] [varchar](254) NOT NULL,
	[pbv_type] [smallint] NOT NULL,
	[pbv_cntr] [int] NULL,
	[pbv_msg] [varchar](254) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[pbcatvld] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[pbcatvld] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[pbcatvld] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[pbcatvld] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[pbcatvld] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[probestelle](
	[psID] [int] IDENTITY(1,1) NOT NULL,
	[psGebiets_kz] [int] NULL,
	[psEinrichtung_F] [int] NULL,
	[psEinrichtung_B] [int] NULL,
	[psTKnr_name] [int] NULL,
	[psProbestellennr] [varchar](40) NULL,
	[psLfdnr] [int] NULL,
	[psDatum] [datetime] NULL,
	[psBetreff] [int] NULL,
	[psProbestrecke] [varchar](80) NULL,
	[psErfass_Kat] [int] NULL,
	[psBewirtart] [int] NULL,
	[psGKK_R] [float] NULL,
	[psGKK_H] [float] NULL,
	[psGwTyp] [char](1) NULL,
	[psGwTypbez] [int] NULL,
	[psFischreg] [int] NULL,
	[psFischreg_Bem] [varchar](255) NULL,
	[psWasserstand] [int] NULL,
	[psStroemung] [int] NULL,
	[psStruktur] [varchar](125) NULL,
	[psBewuchs] [varchar](125) NULL,
	[psLinienfuehrung] [int] NULL,
	[psUmland] [varchar](125) NULL,
	[psUferverbauung] [char](1) NULL,
	[psQuerverbauung] [char](1) NULL,
	[psBeeintr] [varchar](125) NULL,
	[psOekowert] [int] NULL,
	[psFangmethode] [int] NULL,
	[psFanggeraet] [varchar](80) NULL,
	[psGwBreite] [float] NULL,
	[psGwTiefe] [float] NULL,
	[psGwFlaeche] [float] NULL,
	[psHoehenlage] [float] NULL,
	[psHoehenlage_Bem] [varchar](80) NULL,
	[psGwStrecke_eff] [float] NULL,
	[psGwBreite_eff] [float] NULL,
	[psFangquote] [int] NULL,
	[psWassertemp] [float] NULL,
	[psLeitfaehigkeit] [int] NULL,
	[psFangprot_wiss] [char](1) NULL,
	[psFangprot_Bem] [text] NULL,
	[psGISsel] [char](1) NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[psImportiert] [char](1) NULL,
	[psHost] [int] NULL,
	[psHostID] [int] NULL,
	[psAbschnitt] [int] NULL,
	[psBilddatei] [varchar](255) NULL,
	[psGattung] [char](1) NULL,
	[psFanggeraete] [int] NULL,
	[psLeereFanggeraete] [int] NULL,
	[psFangzahl] [int] NULL,
	[psGemeinde] [int] NULL,
	[psNichtBerechnen] [char](1) NULL,
	[psPHWert] [float] NULL,
	[psHochgerechnet] [char](1) NULL,
	[psBefischungsrichtung] [varchar](10) NULL,
	[psUTM_R] [int] NULL,
	[psUTM_H] [int] NULL,
	[psNummer] [varchar](30) NULL,
	[psUTM_Zone32] [char](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[probestelle] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[profiler]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[profiler](
	[pfZeit] [datetime] NULL,
	[pfAktion] [varchar](255) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[profiler] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[profiler] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[profiler] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[profiler] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[profiler] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[ps2b]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ps2b](
	[ps2bID] [int] IDENTITY(1,1) NOT NULL,
	[ps2bProbestelle] [int] NOT NULL,
	[ps2bBewertung] [int] NOT NULL,
	[ps2bHost] [int] NULL,
	[ps2bHostID] [int] NULL,
	[ps2bImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[ps2b] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[ps2b] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[ps2b] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[ps2b] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[ps2b] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[referenz]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[referenz](
	[rID] [int] IDENTITY(1,1) NOT NULL,
	[rBezeichnung] [varchar](80) NULL,
	[rOrdnung] [int] NULL,
	[rImportiert] [char](1) NULL,
	[rHost] [int] NULL,
	[rHostID] [int] NULL,
	[rKuerzel] [varchar](10) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[referenz] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[referenz] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[referenz] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[referenz] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[referenz] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[referenzwert]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[referenzwert](
	[rwID] [int] IDENTITY(1,1) NOT NULL,
	[rwReferenz] [int] NOT NULL,
	[rwAbschnitt] [int] NOT NULL,
	[rwBetrag] [float] NULL,
	[rwHost] [int] NULL,
	[rwHostID] [int] NULL,
	[rwImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[referenzwert] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[referenzwert] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[referenzwert] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[referenzwert] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[referenzwert] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[tknr_name]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tknr_name](
	[tkID] [int] IDENTITY(1,1) NOT NULL,
	[tkNummer] [varchar](10) NULL,
	[tkName] [varchar](40) NULL,
	[UPD_TIME] [datetime] NULL,
	[UPD_USER] [varchar](40) NULL,
	[tkImportiert] [char](1) NULL,
	[tkHost] [int] NULL,
	[tkHostID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[tknr_name] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[tknr_name] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[tknr_name] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[tknr_name] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[tknr_name] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[wasserkoerper]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[wasserkoerper](
	[wkID] [int] IDENTITY(1,1) NOT NULL,
	[wkGebietsKz] [int] NOT NULL,
	[wkNummer] [varchar](20) NOT NULL,
	[wkBezeichnung] [varchar](80) NULL,
	[wkImportiert] [char](1) NULL,
	[wkHost] [int] NULL,
	[wkHostID] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[wasserkoerper] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[wasserkoerper] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[wasserkoerper] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[wasserkoerper] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[wasserkoerper] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[wert]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[wert](
	[wID] [int] IDENTITY(1,1) NOT NULL,
	[wMasz] [int] NOT NULL,
	[wBewertung] [int] NOT NULL,
	[wBetrag] [float] NULL,
	[wBezeichnung] [varchar](40) NULL,
	[wHost] [int] NULL,
	[wHostID] [int] NULL,
	[wImportiert] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[wert] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[wert] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[wert] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[wert] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[wert] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_benutzer]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_benutzer](
	[zvbID] [int] NOT NULL,
	[zvbRolle] [int] NULL,
	[zvbDomaene] [int] NULL,
	[zvbLogin] [varchar](35) NULL,
	[zvbPasswort] [varchar](35) NULL,
	[zvbName] [varchar](35) NULL,
	[zvbVorname] [varchar](35) NULL,
	[zvbOrgEinheit] [varchar](35) NULL,
	[zvbTelefon] [varchar](35) NULL,
	[zvbRaum] [varchar](35) NULL,
	[zvbMandant] [int] NULL,
	[zvbSPID] [int] NULL,
	[zvbGruppe] [int] NULL,
	[zvbVersteckt] [char](1) NULL,
	[zvbImportiert] [char](1) NULL,
	[zvbIDQuelle] [int] NULL,
	[zvbHost] [int] NULL,
	[zvbMitLogin2] [char](1) NULL,
	[zvbLogin2] [varchar](35) NULL,
	[zvbComputername] [varchar](40) NULL,
	[zvbComputername2] [nvarchar](40) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_benutzer] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_benutzer] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_benutzer] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_benutzer] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_benutzer] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_einstellung]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_einstellung](
	[zveID] [int] IDENTITY(1,1) NOT NULL,
	[zveBenutzer] [int] NULL,
	[zveCharWert] [varchar](1) NULL,
	[zveTextWert] [varchar](255) NULL,
	[zveEinstellungstyp] [int] NULL,
	[zveMandant] [int] NULL,
	[zveIntWert] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_einstellung] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_einstellung] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_einstellung] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_einstellung] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_einstellung] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_einstellungstyp]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_einstellungstyp](
	[zvetID] [int] NOT NULL,
	[zvetBezeichnung] [varchar](255) NULL,
	[zvetAllgemein] [char](1) NULL,
	[zvetGruppe] [varchar](80) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_einstellungstyp] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_einstellungstyp] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_einstellungstyp] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_einstellungstyp] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_einstellungstyp] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_funktion]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_funktion](
	[zvfID] [int] NOT NULL,
	[zvfBezeichnung] [varchar](80) NOT NULL,
	[zvfStandard] [char](1) NULL,
	[zvfAnwendung] [int] NULL,
	[zvfBearbeitbar] [char](1) NULL,
	[zvfMitOption1] [char](1) NULL,
	[zvfOption1] [varchar](80) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_funktion] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_funktion] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_funktion] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_funktion] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_funktion] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_kontext]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_kontext](
	[zvkID] [int] IDENTITY(1,1) NOT NULL,
	[zvkBenutzer] [int] NULL,
	[zvkTyp] [varchar](80) NULL,
	[zvkWert] [int] NULL,
	[zvkWert2] [int] NULL,
	[zvkStringWert] [varchar](80) NULL,
	[zvkOrdnung] [int] NULL,
	[zvkAlle] [char](1) NULL,
	[zvkStringWert2] [varchar](255) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_kontext] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_kontext] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_kontext] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_kontext] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_kontext] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_kontextX]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_kontextX](
	[zvkxID] [int] IDENTITY(1,1) NOT NULL,
	[zvkxBenutzer] [int] NULL,
	[zvkxTyp] [varchar](80) NULL,
	[zvkxListe1] [text] NULL,
	[zvkxListe2] [text] NULL,
	[zvkxOption] [char](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_kontextX] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_kontextX] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_kontextX] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_kontextX] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_kontextX] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_lokation]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_lokation](
	[zvlID] [int] IDENTITY(1,1) NOT NULL,
	[zvlKuerzel] [varchar](10) NULL,
	[zvlBezeichnung] [varchar](255) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_lokation] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_lokation] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_lokation] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_lokation] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_lokation] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_rolle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_rolle](
	[zvrID] [int] IDENTITY(1,1) NOT NULL,
	[zvrBezeichnung] [varchar](80) NOT NULL,
	[zvrBeschreibung] [text] NULL,
	[zvrStandard] [char](1) NULL,
	[zvrExklusiv] [char](1) NULL,
	[zvrMandant] [int] NULL,
	[zvrVersteckt] [char](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_rolle] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_rolle] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_rolle] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_rolle] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_rolle] TO public AS [dbo]
GO
/****** Object:  Table [dbo].[zv_x2r]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[zv_x2r](
	[zvx2rID] [int] IDENTITY(1,1) NOT NULL,
	[zvx2rRolle] [int] NOT NULL,
	[zvx2rTyp] [varchar](20) NULL,
	[zvx2rWert] [int] NULL,
	[zvx2rOn] [char](1) NULL,
	[zvx2rBearbeiten] [char](1) NULL,
	[zvx2rOption1] [char](1) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[zv_x2r] TO public AS [dbo]
GO
GRANT DELETE ON [dbo].[zv_x2r] TO public AS [dbo]
GO
GRANT INSERT ON [dbo].[zv_x2r] TO public AS [dbo]
GO
GRANT SELECT ON [dbo].[zv_x2r] TO public AS [dbo]
GO
GRANT UPDATE ON [dbo].[zv_x2r] TO public AS [dbo]
GO
/****** Object:  Table [GDT].[Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[Art](
	[AID] [int] IDENTITY(1,1) NOT NULL,
	[Bezeichnung] [varchar](80) NOT NULL,
	[Gefaehrdung] [varchar](10) NULL,
	[Stueckzahl] [int] NULL,
	[LID] [int] NULL,
	[_Kontext] [int] NOT NULL,
	[_Fischart] [int] NOT NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[Client]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[Client](
	[clID] [int] IDENTITY(1,1) NOT NULL,
	[clNummer] [int] NULL,
	[clName] [nvarchar](40) NULL
	, clBenutzer nvarchar(40) null
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[Client] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[Client] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[Client] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Client] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[Client] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Client] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[Lokation]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[Lokation](
	[LID] [int] IDENTITY(1,1) NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Korr] [char](1) NULL,
	[_Kontext] [int] NOT NULL,
	[_Probestelle] [int] NOT NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[Lokation] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[Lokation] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[Lokation] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Lokation] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[Lokation] TO public AS [dbo]
GO
/****** Object:  Table [GDT].[Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[Probestelle](
	[PSID] [int] IDENTITY(1,1) NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL,
	[LID] [int] NOT NULL,
	[_Kontext] [int] NOT NULL,
	[_Probestelle] [int] NOT NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T01Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T01Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T01Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T01Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T01Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T01Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T01Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T01Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T01ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T01ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T01ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T01ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T01ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T01ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T01ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T01ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T01Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T01Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T01Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T01Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T01Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T01Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T01Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T01Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T02Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T02Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T02Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T02Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T02Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T02Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T02Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T02Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T02ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T02ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T02ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T02ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T02ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T02ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T02ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T02ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T02Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T02Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T02Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T02Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T02Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T02Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T02Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T02Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T03Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T03Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T03Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T03Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T03Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T03Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T03Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T03Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T03ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T03ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T03ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T03ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T03ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T03ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T03ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T03ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T03Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T03Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T03Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T03Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T03Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T03Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T03Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T03Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T04Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T04Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T04Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T04Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T04Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T04Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T04Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T04Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T04ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T04ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T04ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T04ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T04ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T04ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T04ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T04ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T04Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T04Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T04Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T04Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T04Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T04Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T04Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T04Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T05Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T05Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T05Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T05Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T05Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T05Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T05Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T05Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T05ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T05ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T05ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T05ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T05ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T05ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T05ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T05ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T05Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T05Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T05Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T05Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T05Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T05Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T05Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T05Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T06Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T06Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T06Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T06Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T06Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T06Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T06Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T06Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T06ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T06ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T06ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T06ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T06ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T06ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T06ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T06ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T06Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T06Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T06Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T06Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T06Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T06Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T06Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T06Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T07Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T07Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T07Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T07Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T07Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T07Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T07Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T07Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T07ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T07ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T07ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T07ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T07ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T07ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T07ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T07ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T07Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T07Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T07Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T07Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T07Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T07Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T07Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T07Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T08Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T08Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T08Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T08Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T08Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T08Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T08Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T08Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T08ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T08ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T08ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T08ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T08ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T08ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T08ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T08ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T08Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T08Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T08Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T08Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T08Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T08Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T08Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T08Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T09Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T09Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T09Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T09Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T09Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T09Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T09Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T09Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T09ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T09ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T09ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T09ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T09ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T09ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T09ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T09ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T09Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T09Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T09Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T09Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T09Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T09Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T09Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T09Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T10Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T10Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T10Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T10Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T10Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T10Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T10Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T10Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T10ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T10ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T10ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T10ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T10ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T10ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T10ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T10ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T10Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T10Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T10Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T10Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T10Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T10Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T10Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T10Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T11Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T11Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T11Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T11Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T11Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T11Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T11Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T11Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T11ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T11ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T11ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T11ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T11ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T11ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T11ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T11ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T11Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T11Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T11Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T11Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T11Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T11Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T11Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T11Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T12Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T12Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T12Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T12Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T12Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T12Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T12Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T12Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T12ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T12ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T12ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T12ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T12ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T12ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T12ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T12ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T12Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T12Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T12Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T12Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T12Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T12Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T12Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T12Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T13Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T13Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T13Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T13Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T13Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T13Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T13Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T13Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T13ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T13ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T13ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T13ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T13ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T13ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T13ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T13ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T13Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T13Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T13Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T13Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T13Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T13Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T13Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T13Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T14Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T14Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T14Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T14Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T14Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T14Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T14Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T14Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T14ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T14ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T14ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T14ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T14ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T14ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T14ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T14ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T14Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T14Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T14Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T14Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T14Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T14Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T14Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T14Probestelle] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T15Art]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T15Art](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T15Art] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T15Art] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T15Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T15Art] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T15Art] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T15Art] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T15ArtGesamt]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T15ArtGesamt](
	[A2PSID] [int] IDENTITY(1,1) NOT NULL,
	[AID] [int] NOT NULL,
	[PSID] [int] NOT NULL,
	[Bezeichnung] [nvarchar](80) NOT NULL,
	[BezeichnungUndStueckzahl] [nvarchar](80) NOT NULL,
	[Gefaehrdung] [nvarchar](10) NULL,
	[Stueckzahl] [int] NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T15ArtGesamt] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T15ArtGesamt] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T15ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T15ArtGesamt] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T15ArtGesamt] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T15ArtGesamt] TO [public] AS [dbo]
GO
/****** Object:  Table [GDT].[T15Probestelle]    Script Date: 28.03.2024 16:36:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [GDT].[T15Probestelle](
	[PSID] [int] NOT NULL,
	[X] [float] NOT NULL,
	[Y] [float] NOT NULL,
	[Befischungsdatum] [datetime] NULL,
	[Befischungsjahr] [int] NULL,
	[Probestrecke] [varchar](80) NULL,
	[GesamtmasseProHa] [int] NULL,
	[Fischereiregion] [varchar](30) NULL,
	[oekologischerWert] [varchar](30) NULL,
	[Fischereiausuebender] [varchar](80) NULL,
	[GEWKZ] [varchar](20) NULL,
	[OWKName] [varchar](80) NULL,
	[OWKID] [varchar](20) NULL,
	[Bewertungspraedikat] [varchar](30) NULL,
	[Bewertungsnote] [varchar](5) NULL,
	[Befischungsanlass] [varchar](30) NULL,
	[Fangquote] [int] NULL,
	[befischteStrecke] [float] NULL,
	[Befischungsrichtung] [varchar](10) NULL,
	[Landkreis] [varchar](40) NULL,
	[Gemeinde] [varchar](40) NULL,
	[Bilddatei] [varchar](255) NULL,
	[Bemerkung] [varchar](255) NULL,
	[Bewertet] [char](1) NULL,
	[Multigroup] [varchar](5) NULL
) ON [PRIMARY]
GO
GRANT SELECT ON [GDT].[T15Probestelle] TO public AS [dbo]
GO
GRANT DELETE ON [GDT].[T15Probestelle] TO public AS [dbo]
GO
GRANT INSERT ON [GDT].[T15Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T15Probestelle] TO public AS [dbo]
GO
GRANT UPDATE ON [GDT].[T15Probestelle] TO public AS [dbo]
GO
GRANT SELECT ON [GDT].[T15Probestelle] TO [public] AS [dbo]
GO
ALTER TABLE [dbo].[dtproperties] ADD  DEFAULT ((0)) FOR [version]
GO
