CREATE TABLE [dbo].[Operatorzy](
	[Ope_OpeID]           [int] IDENTITY(1,1) NOT NULL,
	[Ope_Kod]             [varchar](20) NOT NULL UNIQUE,
	[Ope_Imie]            [varchar](30) NOT NULL,
	[Ope_Nazwisko]        [varchar](30) NOT NULL,
	[Ope_Haslo]           [varchar](255) NOT NULL,
	[Ope_HasloChk]        [varchar](64) NOT NULL DEFAULT(''),
	[Ope_Nieaktywny]      [bit] NOT NULL DEFAULT(0),
	[Ope_Administrator]   [bit] NOT NULL DEFAULT(0),
	[Ope_Uprawnienia]     [int] NOT NULL DEFAULT(0),
	CONSTRAINT [PK_Operatorzy] PRIMARY KEY CLUSTERED 
	(
		[Ope_OpeID] ASC
	)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

CREATE TABLE [dbo].[KlnGrupy](
	[KlG_KlGID]           [int] IDENTITY(1,1) NOT NULL,
	[KlG_Kod]             [varchar](40) NOT NULL UNIQUE,
	[KlG_KlGParent]       [int] NULL DEFAULT(NULL), 
	[KlG_Nazwa]           [varchar](255) NOT NULL DEFAULT '',
	CONSTRAINT [PK_KlnGrupy] PRIMARY KEY CLUSTERED 
	(
		[KlG_KlGID] ASC
	)WITH (PAD_INDEX  = ON, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY],

	CONSTRAINT [FK_KlnGrupy_KlnGrupy] FOREIGN KEY([KlG_KlGParent]) REFERENCES [dbo].[KlnGrupy] ([KlG_KlGID]),
	CONSTRAINT [CK_KlGParentNotSelf] CHECK(KlG_KlGParent <> KlG_KlGID) 
) ON [PRIMARY]

quote:

---

Originally posted by Wodzu

Thank you!

You are a life saver ;)

---