github.com/muhammadn/cortex@v1.9.1-0.20220510110439-46bb7000d03d/cmd/cortex/migrations/001_initial_schema.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS traceable (
     2    created_at timestamp with time zone not null default now(),
     3    updated_at timestamp with time zone not null default now(),
     4    deleted_at timestamp with time zone
     5  );
     6  
     7  CREATE TABLE IF NOT EXISTS configs (
     8    id text NOT NULL,
     9    type text NOT NULL,
    10    subsystem text NOT NULL,
    11    config jsonb NOT NULL,
    12    PRIMARY KEY (id, type, subsystem)
    13  ) inherits(traceable);