Database Update

Migrations

Version	Migration	Status	Action
1	Initial schema with positions, categories, parts 2024-01-01	Applied	-
2	Add brands and models tables 2024-01-02	Applied	-
3	Add cars table with brand/model references 2024-01-03	Applied	-
4	Add foreign keys to parts table 2024-01-04	Applied	-
5	Add auction tables 2024-01-05	Applied	-
6	Insert default positions 2024-01-06	Applied	-
7	Insert default categories 2024-01-07	Applied	-
8	Insert default brands 2024-01-08	Applied	-
9	Fix cars table structure - add missing columns 2024-01-09	Applied	-
10	Remove old cars table columns (brand, model, year, trim) 2024-01-10	Applied	-
11	Add link column to parts table 2024-01-11	Applied	-
12	Add services and fees master tables 2024-01-12	Applied	-
13	Update Auction Fee to 1000 and add Dealer Fee 2024-01-13	Applied	-
14	Replace auction_location with delivery_price 2024-01-14	Applied	-
15	Add paint_prices table 2024-01-15	Applied	-
16	Add car_id to auction_calc for editing 2024-01-16	Applied	-
17	Add link column to auction_selected_parts 2024-01-17	Applied	-
18	Add car_prices table for market price lookup 2024-01-18	Applied	-
19	Add image column to auction_calc 2024-01-19	Applied	-
20	Add settings table for eBay API configuration 2024-01-20	Applied	-
21	Add eBay OAuth tokens table 2024-01-21	Applied	-
22	Add paint price columns to auction_selected_parts 2024-01-22	Applied	-