use master;
go
if DB_ID (N'lab12') is not null
drop database lab12;
go
create database lab12
on (
NAME = lab12dat,
FILENAME = 'C:\DB\lab12\lab12dat.mdf',
SIZE = 10,
MAXSIZE = 25,
FILEGROWTH = 5
)
log on (
NAME = lab12log,
FILENAME = 'C:\DB\lab12\lab12log.ldf',
SIZE = 5,
MAXSIZE = 20,
FILEGROWTH = 5
);
go

use lab12;
go


if OBJECT_ID(N'Squad',N'U') is NOT NULL
	DROP TABLE Squad;
go

CREATE TABLE Squad (
	Squad_ID int IDENTITY(1,1) PRIMARY KEY,
	Surname char(30) NOT NULL,
	Name char(30) NOT NULL,
	Position char(3),
	Number numeric(2)
);
go

INSERT INTO Squad(Surname,Name,Position, Number)
VALUES (N'Аррисабалага',N'Кепа', N'ВРТ', 1),
	   (N'Алонсо',N'Маркос', N'ЛЗ', 3),
	   (N'Рюдигер',N'Антонио', N'ЦЗ', 2),
	   (N'Томори',N'Фикайо', N'ЦЗ', 29),
	   (N'Аспиликуэта',N'Сесар', N'ПЗ', 28),
	   (N'Канте',N'Н’Голо', N'ЦПЗ', 7),
	   (N'Маунт',N'Мейсон', N'ЦАП', 19),
	   (N'Абрахам',N'Тэмми', N'ФРВ', 9),
	   (N'Пулишич',N'Кристиан', N'ЛФА', 22)
go

SELECT * FROM Squad
go