Page MenuHomeSoftware Heritage
Paste P361

(An Untitled Masterwork)
ActivePublic

Authored by seirl on Feb 19 2019, 11:48 AM.
Old :
CREATE TABLE public.directory (
id public.sha1_git NOT NULL,
dir_entries bigint[],
file_entries bigint[],
rev_entries bigint[],
object_id bigint NOT NULL
);
CREATE TABLE public.directory_entry_dir (
id bigint NOT NULL,
target public.sha1_git,
name public.unix_path,
perms public.file_perms
);
New :
CREATE TABLE public.directory (
id public.sha1_git NOT NULL,
object_id bigint NOT NULL
);
CREATE TABLE public.directory_entry_dir (
dir_id bigint NOT NULL REFERENCES directory.object_id,
target public.sha1_git,
name public.unix_path,
perms public.file_perms
);