Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- )
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement