mm-auth-service/sql/V14__Create_Usage_Table.sql
2025-07-25 18:00:13 +07:00

13 lines
502 B
SQL

ALTER TABLE applications DROP COLUMN "application_id_threescale";
CREATE TABLE usage_users (
id UUID PRIMARY KEY,
user_id UUID NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE usage_organizations (
id UUID PRIMARY KEY,
"org_name" varchar(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);