| CREATE TABLE IF NOT EXISTS customers ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| first_name TEXT NOT NULL, | |
| last_name TEXT NOT NULL, | |
| email TEXT UNIQUE NOT NULL, | |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| CREATE TABLE IF NOT EXISTS orders ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| customer_id INTEGER NOT NULL, | |
| product_name TEXT NOT NULL, | |
| amount REAL NOT NULL, | |
| status TEXT NOT NULL, | |
| order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP, | |
| FOREIGN KEY (customer_id) REFERENCES customers(id) | |
| ); | |