11 lines
609 B
SQL
11 lines
609 B
SQL
CREATE TABLE IF NOT EXISTS frontend_signals
|
|
(
|
|
project_id bigint NOT NULL,
|
|
user_id text NOT NULL,
|
|
timestamp bigint NOT NULL,
|
|
action text NOT NULL,
|
|
source text NOT NULL,
|
|
category text NOT NULL,
|
|
data json
|
|
);
|
|
CREATE INDEX IF NOT EXISTS frontend_signals_user_id_idx ON frontend_signals (user_id);
|