y9r4hpGV

1/* 
2*  DB Script Tool
3*  SQL Server - 2021-06-17 14:29:12
4*  Demo: Sales database
5*/ 
6CREATE DATABASE dbSalesDemo
7 ON PRIMARY 
8 ( 
9     NAME='dbSalesDemo', 
10     FILENAME='dbSalesDemo.mdf', 
11     SIZE=3048, 
12     MAXSIZE=UNLIMITED, 
13     FILEGROWTH=1024KB 
14 ) 
15 LOG ON 
16 ( 
17     NAME='dbSalesDemo_log', 
18     FILENAME='dbSalesDemo_log.ldf', 
19     SIZE=1024KB, 
20     MAXSIZE=2048KB, 
21     FILEGROWTH=10% 
22 ) 
23
24GO 
25
26USE dbSalesDemo;
27
28
29
30/* 
31*  category
32*  Demo: Table for categories
33*/ 
34IF EXISTS (SELECT * FROM sys.objects WHERE name = 'category') 
35   DROP TABLE dbo.category; 
36GO
37
38IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'category') 
39CREATE TABLE dbo.category (
40    id INT  IDENTITY(1, 1),
41    name NVARCHAR(20) NOT NULL,
42    coeythegoat MONEY NOT NULL,
43 CONSTRAINT PK_category PRIMARY KEY (id)
44); 
45GO
46
47CREATE UNIQUE INDEX idx_category_coeythegoat ON category (coeythegoat);
48GO
49
50
51
52/* 
53*  product
54*  Demo: Table for products
55*/ 
56IF EXISTS (SELECT * FROM sys.objects WHERE name = 'product') 
57   DROP TABLE dbo.product; 
58GO
59
60IF NOT EXISTS (SELECT * FROM sys.objects WHERE name = 'product') 
61CREATE TABLE dbo.product (
62    id INT  IDENTITY(1, 1),
63    name NVARCHAR(100) NOT NULL,
64    category_id INT NOT NULL,
65    stock INT NOT NULL DEFAULT 0,
66    cost MONEY NOT NULL DEFAULT 0,
67    price MONEY NOT NULL DEFAULT 0,
68    status BIT NOT NULL DEFAULT 1,
69    brand NVARCHAR(100),
70 CONSTRAINT PK_product PRIMARY KEY (id),
71CONSTRAINT fk_rel_category_product FOREIGN KEY (category_id) REFERENCES category(id) ON DELETE CASCADE
72); 
73GO