forked from Jcouls29/Development-Project-CSharp
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathLocalSetup.Inventory.sql
More file actions
30 lines (25 loc) · 1.68 KB
/
Copy pathLocalSetup.Inventory.sql
File metadata and controls
30 lines (25 loc) · 1.68 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
:on error exit
IF DB_ID(N'inventory') IS NULL
BEGIN
CREATE DATABASE [inventory];
END
GO
USE [inventory];
GO
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Instances.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Transactions\Transactions.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Table Types\IntegerList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Table Types\StringList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Table Types\CustomAttributeList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Table Types\CorrelatedIntegerList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Table Types\CorrelatedStringList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Table Types\CorrelatedCustomAttributeList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Table Types\CorrelatedListItemList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Table Types\CorrelatedProductInstanceList.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Tables\Categories.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Tables\Products.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Tables\CategoryAttributes.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Tables\ProductAttributes.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Tables\ProductCategories.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Instances\Tables\CategoryCategories.sql"
:r ".\Development Project\Sparcpoint.Inventory.Database\Transactions\Tables\InventoryTransactions.sql"