USE master;
GO

CREATE DATABASE tset1
ON (NAME = tset_dat1, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tset1.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5)
LOG ON ( NAME = tset_log1, FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\tset1.ldf',SIZE = 5, MAXSIZE = 25, FILEGROWTH = 5);
GO

USE tset1;
GO

CREATE TABLE Planet
(
  Planet_id int IDENTITY(5,10) NOT NULL PRIMARY KEY,
  AddedTime datetime NOT NULL DEFAULT (getdate()),
  Name varchar(15) NOT NULL DEFAULT ('Planet'),
  PlanetWeight int,
  CHECK (PlanetWeight > 0)
)
GO

INSERT INTO [dbo].[Planet]
           ([Name])
     VALUES
           ('Kek1')
GO

INSERT INTO [dbo].[Planet]
           ([Name])
     VALUES
           ('Kek2')
GO

INSERT INTO [dbo].[Planet]
           ([Name])
     VALUES
           ('Kek3')
GO


SELECT SCOPE_IDENTITY()
GO

CREATE TABLE Orders  (
CustomerID uniqueidentifier NOT NULL PRIMARY KEY
   DEFAULT newid(),
)
GO

CREATE SCHEMA Audit ;
GO

CREATE SEQUENCE Audit.EventCounter
    AS int
    START WITH 1
    INCREMENT BY 1 ;
GO

CREATE TABLE Audit.ProcessEvents
(
    EventID int PRIMARY KEY DEFAULT (NEXT VALUE FOR Audit.EventCounter),
    EventTime datetime NOT NULL DEFAULT (getdate())
) ;
GO

CREATE TABLE TempSalesReason
   (
      TempID int NOT NULL, Name nvarchar(50)
      , CONSTRAINT PK_TempSales PRIMARY KEY (TempID)
      , CONSTRAINT FK_TempSales_SalesReason FOREIGN KEY (TempID)
        REFERENCES Audit.ProcessEvents (EventID)
        ON DELETE CASCADE
        ON UPDATE CASCADE
   )
;