Query
CREATE TABLE product_variants (
id INTEGER PRIMARY KEY AUTOINCREMENT,
product_id INTEGER NOT NULL,
sku TEXT,
color TEXT,
size TEXT,
price REAL,
stock_quantity INTEGER DEFAULT 0,
is_available INTEGER DEFAULT 1,
created_at TEXT NOT NULL,
updated_at TEXT,
FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE
)