-- Create all tables use OLIs CREATE TABLE [oli].[Angler] ( [AnglerGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [StammGuid] [uniqueidentifier] NOT NULL , [Angler] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [Versionsnummer] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL , [gescannt] [bit] NOT NULL , [datum] [datetime] NULL , [Beschreibung] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [oli].[Code] ( [CodeGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [PostItGuid] [uniqueidentifier] NOT NULL , [StammGuid] [uniqueidentifier] NOT NULL , [CodeZust] [int] NULL , [Kommentar] [nvarchar] (250) COLLATE Latin1_General_CI_AS NULL , [gescannt] [bit] NOT NULL , [Versionsnummer] [char] (10) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [oli].[Löcher] ( [LochGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [AnglerGuid] [uniqueidentifier] NULL , [NetzGuid] [uniqueidentifier] NOT NULL , [KnotenGuid] [uniqueidentifier] NOT NULL , [BaumGuid] [uniqueidentifier] NULL , [ZweigGuid] [uniqueidentifier] NULL , [ILOs] [int] NOT NULL , [Fit] [int] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [oli].[PostIt] Script Date: 02.07.2005 00:46:32 ******/ CREATE TABLE [oli].[PostIt] ( [PostItGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [Titel] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [PostIt] [varchar] (3000) COLLATE Latin1_General_CI_AS NOT NULL , [Datum] [datetime] NULL , [KooK] [money] NULL , [PostItZust] [int] NULL , [URL] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [Datei] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [Hits] [int] NOT NULL , [Typ] [char] (3) COLLATE Latin1_General_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [oli].[Q] ( [QID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Q] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [S] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [w] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [P] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [A] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [x] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [C] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [R] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [L] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [T] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [N] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [K] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [B] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [Z] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [O] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [g] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [I] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [f] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [S_P] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [S_A] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [A_L] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [A_X] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [X_T] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [S_T] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [P_S] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [P_C] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [P_X] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [C_R] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [C_X] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [P_T] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [oli].[Ringe] ( [RingGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [CodeGuid] [uniqueidentifier] NOT NULL , [NetzGuid] [uniqueidentifier] NOT NULL , [KnotenGuid] [uniqueidentifier] NOT NULL , [BaumGuid] [uniqueidentifier] NULL , [ZweigGuid] [uniqueidentifier] NULL , [OLIs] [int] NOT NULL , [Get] [int] NOT NULL ) ON [PRIMARY] GO /****** Objekt: Tabelle [oli].[Spiegel] Skriptdatum: 28.12.2003 02:16:40 ******/ CREATE TABLE [oli].[Spiegel] ( [CodeGuid] [uniqueidentifier] NOT NULL , [AnglerGuid] [uniqueidentifier] NOT NULL , [status] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [zeit] [datetime] NULL , [gelesen] [datetime] NULL ) GO CREATE TABLE [oli].[Stamm] ( [StammGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [Stamm] [nvarchar] (50) COLLATE Latin1_General_CI_AS NOT NULL , [gebDate] [datetime] NULL , [Tel] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [eMail] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [KooK] [money] NULL , [Datum] [datetime] NULL , [Unterschrift] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [Versionsnummer] [nvarchar] (10) COLLATE Latin1_General_CI_AS NULL , [Bank] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [BLZ] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [Kto] [nvarchar] (50) COLLATE Latin1_General_CI_AS NULL , [Datei] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [Beschreibung] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [Link] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [zuQID] [int] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [oli].[TopLab] Script Date: 03.07.2005 22:41:47 ******/ CREATE TABLE [oli].[TopLab] ( [TopLabGuid] uniqueidentifier ROWGUIDCOL NOT NULL , [StammGuid] [uniqueidentifier] NOT NULL , [PostItGuid] [uniqueidentifier] NOT NULL , [Titel] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [TopLab] [nvarchar] (3000) COLLATE Latin1_General_CI_AS NOT NULL , [URL] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [Lohn] [money] NOT NULL , [datum] [datetime] NULL , [datei] [nvarchar] (255) COLLATE Latin1_General_CI_AS NULL , [TopTopLabGuid] [uniqueidentifier] NULL , [Typ] [char] (3) COLLATE Latin1_General_CI_AS NOT NULL ) ON [PRIMARY] GO /****** Objekt: Tabelle [oli].[Wurzeln] Skriptdatum: 07.09.2003 23:30:22 ******/ CREATE TABLE [oli].[Wurzeln] ( [StammGuid] [uniqueidentifier] NOT NULL , [PostItGuid] [uniqueidentifier] NOT NULL , [StammZust] [int] NOT NULL , [bezahlt] [money] NOT NULL , [Frist] [datetime] NULL , [gemailt] [bit] NOT NULL , [closed] [bit] NOT NULL ) GO