8 lines
247 B
MySQL
8 lines
247 B
MySQL
|
-- Schema
|
||
|
|
CREATE TABLE IF NOT EXISTS transactions (
|
||
|
|
given_at TIMESTAMP DEFAULT current_timestamp,
|
||
|
|
membre_id VARCHAR(7) NOT NULL CHECK (length(membre_id) > 0),
|
||
|
|
is_perpetual BOOLEAN NOT NULL,
|
||
|
|
PRIMARY KEY (membre_id, is_perpetual)
|
||
|
|
);
|