USE [master]

CREATE DATABASE [Kadry] ON PRIMARY
( NAME = 'kadry',
FILENAME = 'C:\kadry\kadry.mdf',
SIZE = 10240KB, MAXSIZE = UNLIMITED,
FILEGROWTH = 10240KB)
LOG ON
(NAME = 'kadry_log',
FILENAME = 'C:\kadry\kadry_log.ldf',
SIZE = 1024KB, MAXSIZE = 2048GB, FILEGROWTH = 10%);

use [Kadry]

CREATE TABLE [Pracownicy] (
	[Id_p] [int] IDENTITY(1,1) NOT NULL,
	[Imie] [varchar](30) NOT NULL,
	[Nazwisko] [varchar](50) NOT NULL,
	[Wiek] [int] NULL,
	PRIMARY KEY (id_p)
);