Refactor: Build

[paulfryer]

Refactor Description

I want to show the ability to migrate from SQL server stored procedures to Postgress, so the first thing I need you to do is build me a database for AdventureWorks, create the DDL SQL table files as .sql per table and store them in:

/adventureworks/tables/{table-name}.sql

Then create several stored procedures that are Specific to SQL Server. Store them in this pattern:

/adventureworks/procedures/{procedure-name}.sql

I will do the migration stuff later, just focus on getting the SQL Server tables and stored procedures built out now.

Scope Patterns

!*

Source Branch

main

[genval-github-integration[bot]]

Pre Refactor Summary

Property	Value
Proposed Branch Name	feature/create-adventureworks-database
Total Files in Scope	0
Estimated Input Tokens	1360

Details

Scope Patterns

```text !* ```

Files in Scope

| File | Estimated Tokens | |------|------------------|

[genval-github-integration[bot]]

File Name	Action	Summary of Changes
/adventureworks/tables/Customer.sql	CREATE	Created Customer table SQL script
/adventureworks/tables/Product.sql	CREATE	Created Product table SQL script
/adventureworks/tables/SalesOrderHeader.sql	CREATE	Created SalesOrderHeader table SQL script
/adventureworks/tables/SalesOrderDetail.sql	CREATE	Created SalesOrderDetail table SQL script
/adventureworks/procedures/GetCustomerOrders.sql	CREATE	Created GetCustomerOrders stored procedure
/adventureworks/procedures/UpdateProductInventory.sql	CREATE	Created UpdateProductInventory stored procedure
/adventureworks/procedures/CalculateOrderTotal.sql	CREATE	Created CalculateOrderTotal stored procedure