forked from nbarnwell/OrderManagementSystem
- Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy pathCreate.sql
More file actions
Latest commit
30 lines (25 loc) · 588 Bytes
/
Copy pathCreate.sql
File metadata and controls
30 lines (25 loc) · 588 Bytes
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
createdatabase DddCqrsEsExample_ReadStore
go
use DddCqrsEsExample_ReadStore
go
createtable SalesOrder (
Id varchar(50) notnull,
OrderValue floatnotnull,
Currency smallintnotnull
)
createtable SalesOrderLine (
SalesOrderId varchar(50) notnull,
Sku varchar(50) notnull,
Quantity intnotnull,
UnitPrice moneynotnull,
Currency smallintnotnull
)
createtable MonthlySalesFigure (
[Year] intnotnull,
[Month] intnotnull,
Amount moneynotnull,
Currency smallintnotnull
)
select*from SalesOrder
select*from SalesOrderLine
select*from MonthlySalesFigure