Create Adventureworks

[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/setup-adventureworks-sqlserver-schema
Total Files in Scope	0
Estimated Input Tokens	1358

Details

Scope Patterns

```text !* ```

Files in Scope

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

[genval-github-integration[bot]]

File Name	Action	Summary of Changes
adventureworks/tables/Person.sql	CREATE	Created Person table SQL for AdventureWorks database
adventureworks/tables/Product.sql	CREATE	Created Product table SQL for AdventureWorks database
adventureworks/tables/Customer.sql	CREATE	Created Customer table SQL for AdventureWorks database
adventureworks/tables/SalesOrderHeader.sql	CREATE	Created SalesOrderHeader table SQL for AdventureWorks database
adventureworks/procedures/usp_GetCustomersByTerritory.sql	CREATE	Created stored procedure to get customers by territory
adventureworks/procedures/usp_UpdateProductListPrices.sql	CREATE	Created stored procedure to update product list prices
adventureworks/procedures/usp_GetSalesOrdersByDateRange.sql	CREATE	Created stored procedure to get sales orders by date range