8 lines
230 B
MySQL
8 lines
230 B
MySQL
|
-- Schema
|
||
|
|
CREATE TABLE IF NOT EXISTS transactions (
|
||
|
|
id BIGINT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
|
||
|
|
membre_id VARCHAR(7) NOT NULL,
|
||
|
|
given_at TIMESTAMP DEFAULT current_timestamp,
|
||
|
|
is_perpetual BOOLEAN NOT NULL
|
||
|
|
);
|