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/create-sqlserver-tables-and-procedures
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 for AdventureWorks
/adventureworks/tables/Product.sql	CREATE	Created Product table SQL for AdventureWorks
/adventureworks/tables/SalesOrderHeader.sql	CREATE	Created SalesOrderHeader table SQL for AdventureWorks
/adventureworks/procedures/usp_GetCustomerOrders.sql	CREATE	Created stored procedure to get customer orders
/adventureworks/procedures/usp_UpdateProductInventory.sql	CREATE	Created stored procedure to update product inventory
/adventureworks/procedures/usp_GetTopSellingProducts.sql	CREATE	Created stored procedure to get top selling products