SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; CREATE TABLE IF NOT EXISTS commit_info ( id UUID DEFAULT uuid_generate_v4 () PRIMARY KEY, org_id INT8 NOT NULL, sha TEXT NOT NULL, CONSTRAINT unique_org_sha UNIQUE (org_id, sha) ); CREATE TABLE IF NOT EXISTS sources ( id UUID DEFAULT uuid_generate_v4 () PRIMARY KEY, name TEXT NOT NULL, CONSTRAINT unique_org_sha UNIQUE (name) ); CREATE TABLE IF NOT EXISTS commit_source ( id UUID DEFAULT uuid_generate_v4 () PRIMARY KEY, commit_id UUID REFERENCES commit_info NOT NULL, source_id UUID REFERENCES sources NOT NULL, CONSTRAINT unique_commit_source UNIQUE (commit_id, source_id) );
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear