Changeset View
Changeset View
Standalone View
Standalone View
swh/indexer/tests/data/dumps/swh-indexer.sql
| Show First 20 Lines • Show All 1,392 Lines • ▼ Show 20 Lines | |||||
| -- | -- | ||||
| -- Name: indexer_configuration_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | -- Name: indexer_configuration_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | ||||
| -- | -- | ||||
| ALTER SEQUENCE public.indexer_configuration_id_seq OWNED BY public.indexer_configuration.id; | ALTER SEQUENCE public.indexer_configuration_id_seq OWNED BY public.indexer_configuration.id; | ||||
| -- | -- | ||||
| -- Name: origin_metadata_translation; Type: TABLE; Schema: public; Owner: - | -- Name: origin_intrinsic_metadata; Type: TABLE; Schema: public; Owner: - | ||||
| -- | -- | ||||
| CREATE TABLE public.origin_metadata_translation ( | CREATE TABLE public.origin_intrinsic_metadata ( | ||||
| id bigint NOT NULL, | id bigint NOT NULL, | ||||
| result jsonb, | result jsonb, | ||||
| tool_id bigint | tool_id bigint | ||||
| ); | ); | ||||
| -- | -- | ||||
| -- Name: TABLE origin_metadata_translation; Type: COMMENT; Schema: public; Owner: - | -- Name: TABLE origin_intrinsic_metadata; Type: COMMENT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COMMENT ON TABLE public.origin_metadata_translation IS 'keeps translated for an origin_metadata entry'; | COMMENT ON TABLE public.origin_intrinsic_metadata IS 'keeps translated for an origin_intrinsic_metadata entry'; | ||||
| -- | -- | ||||
| -- Name: COLUMN origin_metadata_translation.id; Type: COMMENT; Schema: public; Owner: - | -- Name: COLUMN origin_intrinsic_metadata.id; Type: COMMENT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COMMENT ON COLUMN public.origin_metadata_translation.id IS 'the entry id in origin_metadata'; | COMMENT ON COLUMN public.origin_intrinsic_metadata.id IS 'the entry id in origin_intrinsic_metadata'; | ||||
| -- | -- | ||||
| -- Name: COLUMN origin_metadata_translation.result; Type: COMMENT; Schema: public; Owner: - | -- Name: COLUMN origin_intrinsic_metadata.result; Type: COMMENT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COMMENT ON COLUMN public.origin_metadata_translation.result IS 'translated_metadata result after translation with tool'; | COMMENT ON COLUMN public.origin_intrinsic_metadata.result IS 'translated_metadata result after translation with tool'; | ||||
| -- | -- | ||||
| -- Name: COLUMN origin_metadata_translation.tool_id; Type: COMMENT; Schema: public; Owner: - | -- Name: COLUMN origin_intrinsic_metadata.tool_id; Type: COMMENT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COMMENT ON COLUMN public.origin_metadata_translation.tool_id IS 'tool used for translation'; | COMMENT ON COLUMN public.origin_intrinsic_metadata.tool_id IS 'tool used for translation'; | ||||
| -- | -- | ||||
| -- Name: origin_metadata_translation_id_seq; Type: SEQUENCE; Schema: public; Owner: - | -- Name: origin_intrinsic_metadata_id_seq; Type: SEQUENCE; Schema: public; Owner: - | ||||
| -- | -- | ||||
| CREATE SEQUENCE public.origin_metadata_translation_id_seq | CREATE SEQUENCE public.origin_intrinsic_metadata_id_seq | ||||
| START WITH 1 | START WITH 1 | ||||
| INCREMENT BY 1 | INCREMENT BY 1 | ||||
| NO MINVALUE | NO MINVALUE | ||||
| NO MAXVALUE | NO MAXVALUE | ||||
| CACHE 1; | CACHE 1; | ||||
| -- | -- | ||||
| -- Name: origin_metadata_translation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | -- Name: origin_intrinsic_metadata_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | ||||
| -- | -- | ||||
| ALTER SEQUENCE public.origin_metadata_translation_id_seq OWNED BY public.origin_metadata_translation.id; | ALTER SEQUENCE public.origin_intrinsic_metadata_id_seq OWNED BY public.origin_intrinsic_metadata.id; | ||||
| -- | -- | ||||
| -- Name: revision_metadata; Type: TABLE; Schema: public; Owner: - | -- Name: revision_metadata; Type: TABLE; Schema: public; Owner: - | ||||
| -- | -- | ||||
| CREATE TABLE public.revision_metadata ( | CREATE TABLE public.revision_metadata ( | ||||
| id public.sha1_git NOT NULL, | id public.sha1_git NOT NULL, | ||||
| ▲ Show 20 Lines • Show All 47 Lines • ▼ Show 20 Lines | |||||
| -- | -- | ||||
| -- Name: indexer_configuration id; Type: DEFAULT; Schema: public; Owner: - | -- Name: indexer_configuration id; Type: DEFAULT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| ALTER TABLE ONLY public.indexer_configuration ALTER COLUMN id SET DEFAULT nextval('public.indexer_configuration_id_seq'::regclass); | ALTER TABLE ONLY public.indexer_configuration ALTER COLUMN id SET DEFAULT nextval('public.indexer_configuration_id_seq'::regclass); | ||||
| -- | -- | ||||
| -- Name: origin_metadata_translation id; Type: DEFAULT; Schema: public; Owner: - | -- Name: origin_intrinsic_metadata id; Type: DEFAULT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| ALTER TABLE ONLY public.origin_metadata_translation ALTER COLUMN id SET DEFAULT nextval('public.origin_metadata_translation_id_seq'::regclass); | ALTER TABLE ONLY public.origin_intrinsic_metadata ALTER COLUMN id SET DEFAULT nextval('public.origin_intrinsic_metadata_id_seq'::regclass); | ||||
| -- | -- | ||||
| -- Data for Name: content_ctags; Type: TABLE DATA; Schema: public; Owner: - | -- Data for Name: content_ctags; Type: TABLE DATA; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COPY public.content_ctags (id, name, kind, line, lang, indexer_configuration_id) FROM stdin; | COPY public.content_ctags (id, name, kind, line, lang, indexer_configuration_id) FROM stdin; | ||||
| \. | \. | ||||
| ▲ Show 20 Lines • Show All 61 Lines • ▼ Show 20 Lines | |||||
| 6 swh-metadata-translator 0.0.1 {"type": "local", "context": "npm"} | 6 swh-metadata-translator 0.0.1 {"type": "local", "context": "npm"} | ||||
| 7 swh-metadata-detector 0.0.1 {"type": "local", "context": ["npm", "codemeta"]} | 7 swh-metadata-detector 0.0.1 {"type": "local", "context": ["npm", "codemeta"]} | ||||
| 8 swh-deposit 0.0.1 {"sword_version": "2"} | 8 swh-deposit 0.0.1 {"sword_version": "2"} | ||||
| 9 file 1:5.30-1+deb9u1 {"type": "library", "debian-package": "python3-magic"} | 9 file 1:5.30-1+deb9u1 {"type": "library", "debian-package": "python3-magic"} | ||||
| \. | \. | ||||
| -- | -- | ||||
| -- Data for Name: origin_metadata_translation; Type: TABLE DATA; Schema: public; Owner: - | -- Data for Name: origin_intrinsic_metadata; Type: TABLE DATA; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COPY public.origin_metadata_translation (id, result, tool_id) FROM stdin; | COPY public.origin_intrinsic_metadata (id, result, tool_id) FROM stdin; | ||||
| \. | \. | ||||
| -- | -- | ||||
| -- Data for Name: revision_metadata; Type: TABLE DATA; Schema: public; Owner: - | -- Data for Name: revision_metadata; Type: TABLE DATA; Schema: public; Owner: - | ||||
| -- | -- | ||||
| COPY public.revision_metadata (id, translated_metadata, indexer_configuration_id) FROM stdin; | COPY public.revision_metadata (id, translated_metadata, indexer_configuration_id) FROM stdin; | ||||
| Show All 17 Lines | |||||
| -- | -- | ||||
| -- Name: indexer_configuration_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | -- Name: indexer_configuration_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | ||||
| -- | -- | ||||
| SELECT pg_catalog.setval('public.indexer_configuration_id_seq', 9, true); | SELECT pg_catalog.setval('public.indexer_configuration_id_seq', 9, true); | ||||
| -- | -- | ||||
| -- Name: origin_metadata_translation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | -- Name: origin_intrinsic_metadata_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - | ||||
| -- | -- | ||||
| SELECT pg_catalog.setval('public.origin_metadata_translation_id_seq', 1, false); | SELECT pg_catalog.setval('public.origin_intrinsic_metadata_id_seq', 1, false); | ||||
| -- | -- | ||||
| -- Name: content_fossology_license content_fossology_license_pkey; Type: CONSTRAINT; Schema: public; Owner: - | -- Name: content_fossology_license content_fossology_license_pkey; Type: CONSTRAINT; Schema: public; Owner: - | ||||
| -- | -- | ||||
| ALTER TABLE ONLY public.content_fossology_license | ALTER TABLE ONLY public.content_fossology_license | ||||
| ADD CONSTRAINT content_fossology_license_pkey PRIMARY KEY (id, license_id, indexer_configuration_id); | ADD CONSTRAINT content_fossology_license_pkey PRIMARY KEY (id, license_id, indexer_configuration_id); | ||||
| ▲ Show 20 Lines • Show All 153 Lines • Show Last 20 Lines | |||||