CQR0vcBm

1USE master
2GO
3
4IF DB_ID (N'lab5') IS NOT NULL
5DROP DATABASE lab5;
6GO
7
8
9CREATE DATABASE lab5
10ON (NAME = MarketLab, FILENAME =
11'/Users/umamirzoeva/DataBases/lab5/MarketLab.mdf',
12SIZE = 10, MAXSIZE = UNLIMITED, FILEGROWTH = 5% )
13LOG ON ( NAME = MarketLab2, FILENAME = '/Users/umamirzoeva/DataBases/lab5/MarketLab2.ldf',
14SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB);
15GO
16
17-- IF SERVERPROPERTY('ProductVersion') > '12'
18--  ALTER DATABASE lab5 SET QUERY_STORE=ON;
19-- GO
20
21
22USE lab5;
23GO 
24
25DROP TABLE IF EXISTS OrderMarket
26GO
27
28USE lab5;
29GO 
30
31CREATE TABLE OrderMarket
32(
33  OrderId int IDENTITY(1,1) NOT NULL PRIMARY KEY,
34  DateOrder DATETIME NOT NULL,
35  Tax Money NOT NULL,
36  Amount Money NOT NULL,
37)
38GO
39  
40
41USE master;
42GO
43ALTER DATABASE lab5
44ADD FILEGROUP OrdersAll;
45GO
46ALTER DATABASE lab5
47ADD FILE
48(
49	NAME = FirstOrder,
50	FILENAME = '/Users/umamirzoeva/DataBases/lab5/FirstOrder.ndf',
51	SIZE = 5MB,
52	MAXSIZE = 100MB,
53	FILEGROWTH = 5MB
54)
55TO FILEGROUP OrdersAll;
56GO
57
58USE master;
59GO
60ALTER DATABASE lab5
61MODIFY FILEGROUP OrdersAll DEFAULT;
62GO
63
64USE lab5
65GO
66IF OBJECT_ID (N'Client') IS NOT NULL
67DROP TABLE Client;
68GO
69
70USE lab5
71GO
72CREATE TABLE Client
73(
74    ClientID int,
75	NumberPhone VARCHAR(15),
76    AddressClient VARCHAR(255),
77    BirthdayClient DATETIME,
78    Email VARCHAR(255),
79    SurnameClient VARCHAR(100),
80    NameClient VARCHAR(100),
81    PatronymicClient VARCHAR(100),
82)
83GO
84
85Select* from Client
86GO
87CREATE UNIQUE CLUSTERED INDEX Client
88ON [dbo].[Client] (ClientID, NumberPhone, AddressClient, BirthdayClient, Email, SurnameClient, NameClient, PatronymicClient)
89ON [Primary]
90
91ALTER DATABASE lab5
92MODIFY FILEGROUP [Primary] DEFAULT;
93GO
94
95USE master
96ALTER DATABASE lab5
97REMOVE FILE FirstOrder;
98GO
99
100ALTER DATABASE lab5
101REMOVE FILEGROUP OrdersAll;
102GO
103
104-- USE [lab5]
105-- GO
106-- DROP SCHEMA IF EXISTS MarketName
107-- GO
108
109USE lab5
110GO
111CREATE SCHEMA MarketName;
112GO
113ALTER SCHEMA MarketName TRANSFER dbo.Client;
114GO
115ALTER SCHEMA dbo TRANSFER MarketName.Client;
116GO
117DROP SCHEMA MarketName