10 lines
341 B
SQL
10 lines
341 B
SQL
CREATE TABLE rewards_cards (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
|
|
store_name TEXT NOT NULL,
|
|
number TEXT NOT NULL,
|
|
symbology TEXT NOT NULL DEFAULT 'code128',
|
|
created_at INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE INDEX rewards_cards_user_idx ON rewards_cards(user_id); |