Page MenuHomeSoftware Heritage

0-schema.sql
No OneTemporary

0-schema.sql

-- schema version table which won't get truncated
create table dbversion (
version int primary key,
release timestamptz,
description text
);
-- a people table which won't get truncated
create table people (
fullname text not null
);
-- a fun table which will get truncated for each test
create table fun (
time timestamptz not null
);
-- one sequence to check for reset as well
create sequence serial;

File Metadata

Mime Type
text/plain
Expires
Jun 4 2025, 6:53 PM (11 w, 4 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3237455

Event Timeline