diff --git a/sql/swh-data.sql b/sql/swh-data.sql index f09be9c6..24ff30cc 100644 --- a/sql/swh-data.sql +++ b/sql/swh-data.sql @@ -1,871 +1,874 @@ insert into entity_history (uuid, parent, name, type, description, homepage, active, generated, validity) values ('5f4d4c51-498a-4e28-88b3-b3e4e8396cba', NULL, 'softwareheritage', 'organization', 'Software Heritage', 'http://www.softwareheritage.org/', true, false, ARRAY[now()]), ('6577984d-64c8-4fab-b3ea-3cf63ebb8589', NULL, 'gnu', 'organization', 'GNU is not UNIX', 'https://gnu.org/', true, false, ARRAY[now()]), ('7c33636b-8f11-4bda-89d9-ba8b76a42cec', '6577984d-64c8-4fab-b3ea-3cf63ebb8589', 'GNU Hosting', 'group_of_entities', 'GNU Hosting facilities', NULL, true, false, ARRAY[now()]), ('4706c92a-8173-45d9-93d7-06523f249398', '6577984d-64c8-4fab-b3ea-3cf63ebb8589', 'GNU rsync mirror', 'hosting', 'GNU rsync mirror', 'rsync://mirror.gnu.org/', true, false, ARRAY[now()]), ('5cb20137-c052-4097-b7e9-e1020172c48e', '6577984d-64c8-4fab-b3ea-3cf63ebb8589', 'GNU Projects', 'group_of_entities', 'GNU Projects', 'https://gnu.org/software/', true, false, ARRAY[now()]), ('4bfb38f6-f8cd-4bc2-b256-5db689bb8da4', NULL, 'GitHub', 'organization', 'GitHub', 'https://github.org/', true, false, ARRAY[now()]), ('aee991a0-f8d7-4295-a201-d1ce2efc9fb2', '4bfb38f6-f8cd-4bc2-b256-5db689bb8da4', 'GitHub Hosting', 'group_of_entities', 'GitHub Hosting facilities', 'https://github.org/', true, false, ARRAY[now()]), ('34bd6b1b-463f-43e5-a697-785107f598e4', 'aee991a0-f8d7-4295-a201-d1ce2efc9fb2', 'GitHub git hosting', 'hosting', 'GitHub git hosting', 'https://github.org/', true, false, ARRAY[now()]), ('e8c3fc2e-a932-4fd7-8f8e-c40645eb35a7', 'aee991a0-f8d7-4295-a201-d1ce2efc9fb2', 'GitHub asset hosting', 'hosting', 'GitHub asset hosting', 'https://github.org/', true, false, ARRAY[now()]), ('9f7b34d9-aa98-44d4-8907-b332c1036bc3', '4bfb38f6-f8cd-4bc2-b256-5db689bb8da4', 'GitHub Organizations', 'group_of_entities', 'GitHub Organizations', 'https://github.org/', true, false, ARRAY[now()]), ('ad6df473-c1d2-4f40-bc58-2b091d4a750e', '4bfb38f6-f8cd-4bc2-b256-5db689bb8da4', 'GitHub Users', 'group_of_entities', 'GitHub Users', 'https://github.org/', true, false, ARRAY[now()]); insert into listable_entity (uuid, list_engine) values ('34bd6b1b-463f-43e5-a697-785107f598e4', 'swh.lister.github'); insert into fossology_license (name) values ('3DFX'), ('3DFX-PL'), ('AAL'), ('ACAA'), ('ACDL'), ('ACE'), ('Adaptec-GPL'), ('Adaptec.RESTRICTED'), ('Adobe'), ('Adobe-AFM'), ('Adobe-EULA'), ('Adobe-SCLA'), ('AFL'), ('AFL-1.0'), ('AFL-1.1'), ('AFL-1.2'), ('AFL-2.0'), ('AFL-2.1'), ('AFL-3.0'), ('AFPL-Ghostscript'), ('AgainstDRM'), ('AGE-Logic'), ('Agere-EULA'), ('AGFA-EULA'), ('AGFA(RESTRICTED)'), ('AGPL'), ('AGPL-1.0'), ('AGPL-1.0+'), ('AGPL-3.0'), ('AGPL-3.0+'), ('AGFA.RESTRICTED'), ('Aladdin'), ('Alfresco'), ('Alfresco-FLOSS'), ('Algorithmics'), ('AMD'), ('AMD-EULA'), ('AML'), ('AndroidFraunhofer.Commercial'), ('AndroidSDK.Commercial'), ('ANTLR-PD'), ('AOL-EULA'), ('Apache'), ('Apache-1.0'), ('Apache-1.1'), ('Apache-2.0'), ('Apache-style'), ('Apache-v1.0'), ('APL'), ('APL-1.0'), ('Apple'), ('Apple-EULA'), ('Apple.FontForge'), ('Apple.Sample'), ('APSL'), ('APSL-1.0'), ('APSL-1.1'), ('APSL-1.2'), ('APSL-2.0'), ('APSL-style'), ('Aptana'), ('Aptana-1.0'), ('ARJ'), ('Arphic-Font-PL'), ('Arphic-style'), ('Artifex'), ('Artistic-1.0'), ('Artistic-1.0-cl8'), ('Artistic-1.0-Perl'), ('Artistic-2.0'), ('Ascender-EULA'), ('ATI-EULA'), ('ATMEL-FW'), ('ATT'), ('ATT.Non-commercial'), ('ATT-Source'), ('ATT-Source-1.0'), ('ATT-Source-1.2d'), ('ATT-style'), ('AVM'), ('Baekmuk-Font'), ('Baekmuk.Hwan'), ('BancTec'), ('BEA'), ('Beerware'), ('Bellcore'), ('Bellcore-style'), ('BH-Font'), ('BH-Font-style'), ('BISON'), ('Bitstream'), ('BitTorrent'), ('BitTorrent-1.0'), ('BitTorrent-1.1'), ('BIZNET'), ('BIZNET-style'), ('BrainStorm-EULA'), ('Broadcom.Commercial'), ('Broadcom-EULA'), ('BSD'), ('BSD-2-Clause'), ('BSD-2-Clause-FreeBSD'), ('BSD-2-Clause-NetBSD'), ('BSD-3-Clause'), ('BSD-3-Clause-Clear'), ('BSD-3-Clause-Severability'), ('BSD-4-Clause'), ('BSD-4-Clause-UC'), ('BSD.non-commercial'), ('BSD-style'), ('BSL-1.0'), ('BSL-style'), ('CA'), ('Cadence'), ('Catharon'), ('CATOSL'), ('CATOSL-1.1'), ('CC0-1.0'), ('CC-BY'), ('CC-BY-1.0'), ('CC-BY-2.0'), ('CC-BY-2.5'), ('CC-BY-3.0'), ('CC-BY-4.0'), ('CC-BY-NC-1.0'), ('CC-BY-NC-2.0'), ('CC-BY-NC-2.5'), ('CC-BY-NC-3.0'), ('CC-BY-NC-4.0'), ('CC-BY-NC-ND-1.0'), ('CC-BY-NC-ND-2.0'), ('CC-BY-NC-ND-2.5'), ('CC-BY-NC-ND-3.0'), ('CC-BY-NC-ND-4.0'), ('CC-BY-NC-SA-1.0'), ('CC-BY-NC-SA-2.0'), ('CC-BY-NC-SA-2.5'), ('CC-BY-NC-SA-3.0'), ('CC-BY-NC-SA-4.0'), ('CC-BY-ND-1.0'), ('CC-BY-ND-2.0'), ('CC-BY-ND-2.5'), ('CC-BY-ND-3.0'), ('CC-BY-ND-4.0'), ('CC-BY-SA'), ('CC-BY-SA-1.0'), ('CC-BY-SA-2.0'), ('CC-BY-SA-2.5'), ('CC-BY-SA-3.0'), ('CC-BY-SA-4.0'), ('CC-LGPL'), ('CC-LGPL-2.1'), ('CCLRC'), ('CCPL'), ('CDDL'), ('CDDL-1.0'), ('CDDL-1.1'), ('CECILL'), ('CECILL-1.0'), ('CECILL-1.1'), ('CECILL-2.0'), ('CECILL-B'), ('CECILL-C'), ('CECILL(dual)'), ('Cisco'), ('Cisco-style'), ('Citrix'), ('ClArtistic'), ('ClearSilver'), ('CMake'), ('CMU'), ('CMU-style'), ('CNRI-Python'), ('CNRI-Python-GPL-Compatible'), ('Combined_OpenSSL+SSLeay'), ('COMMERCIAL'), ('CompuServe'), ('Comtrol'), ('Condor-1.0'), ('Condor-1.1'), ('CopyLeft[1]'), ('CopyLeft[2]'), ('CPAL'), ('CPAL-1.0'), ('CPL'), ('CPL-0.5'), ('CPL-1.0'), ('CPOL'), ('CPOL-1.02'), ('Cryptogams'), ('CUA-OPL-1.0'), ('CUPS'), ('CUPS-EULA'), ('Cygnus-eCos-1.0'), ('Cylink-ISC'), ('Cypress-FW'), ('DARPA'), ('DARPA-Cougaar'), ('Debian-social-DFSG'), ('Debian-SPI'), ('Debian-SPI-style'), ('D.E.Knuth'), ('D-FSL-1.0'), ('DMTF'), ('DOCBOOK'), ('DOCBOOK-style'), ('DPTC'), ('DSCT'), ('DSL'), ('Dual-license'), ('Dyade'), ('EBT-style'), ('ECL-1.0'), ('ECL-2.0'), ('eCos-2.0'), ('EDL-1.0'), ('EFL'), ('EFL-1.0'), ('EFL-2.0'), ('eGenix'), ('Entessa'), ('Epinions'), ('EPL'), ('EPL-1.0'), ('Epson-EULA'), ('Epson-PL'), ('ErlPL-1.1'), ('EUDatagrid'), ('EUPL-1.0'), ('EUPL-1.1'), ('FaCE'), ('Fair'), ('Fair-style'), ('FAL-1.0'), ('FAL-1.3'), ('Fedora'), ('FedoraCLA'), ('Flash2xml-1.0'), ('Flora'), ('Flora-1.0'), ('Flora-1.1'), ('Frameworx'), ('Frameworx-1.0'), ('FreeBSD-Doc'), ('Free-PL'), ('Free-SW'), ('Free-SW.run-COMMAND'), ('FSF'), ('FTL'), ('FTL-style'), ('Fujitsu'), ('Garmin-EULA'), ('GFDL'), ('GFDL-1.1'), ('GFDL-1.1+'), ('GFDL-1.2'), ('GFDL-1.2+'), ('GFDL-1.3'), ('GFDL-v1.2'), ('Genivia.Commercial'), ('Ghostscript-GPL'), ('Ghostscript-GPL-1.1'), ('Giftware'), ('GNU-copyleft'), ('GNU-Ghostscript'), ('GNU-javamail-exception'), ('GNU-Manpages'), ('GNU-style.EXECUTE'), ('GNU-style.interactive'), ('Google'), ('Google-BSD'), ('Govt-restrict'), ('Govt-rights'), ('Govt-work'), ('GPDL'), ('GPL'), ('GPL-1.0'), ('GPL-1.0+'), ('GPL-2.0'), ('GPL-2.0+'), ('GPL-2.0-with-autoconf-exception'), ('GPL-2.0-with-bison-exception'), ('GPL-2.0+-with-bison-exception'), ('GPL-2.0-with-classpath-exception'), ('GPL-2.0+-with-classpath-exception'), ('GPL-2.0-with-font-exception'), ('GPL-2.0-with-GCC-exception'), ('GPL-2.0-with-trolltech-exception'), ('GPL-2.0+-with-UPX-exception'), ('GPL-3.0'), ('GPL-3.0+'), ('GPL-3.0-with-autoconf-exception'), ('GPL-3.0+-with-autoconf-exception'), ('GPL-3.0-with-bison-exception'), ('GPL-3.0+-with-bison-exception'), ('GPL-3.0-with-classpath-exception'), ('GPL-3.0+-with-classpath-exception'), ('GPL-3.0-with-GCC-exception'), ('GPL-3.0+-with-GCC-exception'), ('GPL-exception'), ('GPL-or-LGPL'), ('GPL(rms)'), ('GPL-with-autoconf-exception'), ('gSOAP'), ('gSOAP-1.3b'), ('H2'), ('H2-1.0'), ('Hacktivismo'), ('Hauppauge'), ('Helix.RealNetworks-EULA'), ('HP'), ('HP-Compaq'), ('HP-DEC'), ('HP-DEC-style'), ('HP-EULA'), ('HP+IBM'), ('HPND'), ('HP-Proprietary'), ('HP-style'), ('HSQLDB'), ('IBM'), ('IBM-Courier'), ('IBM-EULA'), ('IBM-JCL'), ('IBM-pibs'), ('IBM-reciprocal'), ('ICU'), ('ID-EULA'), ('IDPL'), ('IDPL-1.0'), ('IEEE-Doc'), ('IETF'), ('IETF-style'), ('IJG'), ('ImageMagick'), ('ImageMagick-style'), ('Imlib2'), ('InfoSeek'), ('info-zip'), ('InnerNet'), ('InnerNet-2.00'), ('InnerNet-style'), ('Intel'), ('Intel.Commercial'), ('Intel-EULA'), ('Intel-other'), ('Intel.RESTRICTED'), ('Intel-WLAN'), ('Interbase-1.0'), ('Interbase-PL'), ('Interlink-EULA'), ('Intranet-only'), ('IOS'), ('IoSoft.COMMERCIAL'), ('IPA'), ('IPA-Font-EULA'), ('IP-claim'), ('IPL'), ('IPL-1.0'), ('IPL-2.0'), ('IPTC'), ('IronDoc'), ('ISC'), ('Jabber'), ('Jabber-1.0'), ('Java-Multi-Corp'), ('Java-WSDL4J'), ('Java-WSDL-Policy'), ('Java-WSDL-Schema'), ('Java-WSDL-Spec'), ('JISP'), ('JPEG.netpbm'), ('JPNIC'), ('JSON'), ('KDE'), ('KD-Tools-EULA'), ('Keyspan-FW'), ('KnowledgeTree-1.1'), ('Knuth-style'), ('Lachman-Proprietary'), ('Larabie-EULA'), ('LDP'), ('LDP-1A'), ('LDP-2.0'), ('Legato'), ('Leptonica'), ('LGPL'), ('LGPL-1.0'), ('LGPL-1.0+'), ('LGPL-2.0'), ('LGPL-2.0+'), ('LGPL-2.1'), ('LGPL-2.1+'), ('LGPL-3.0'), ('LGPL-3.0+'), ('LIBGCJ'), ('Libpng'), ('Link-exception'), ('LinuxDoc'), ('Linux-HOWTO'), ('Logica-OSL-1.0'), ('LPL-1.0'), ('LPL-1.02'), ('LPPL'), ('LPPL-1.0'), ('LPPL-1.0+'), ('LPPL-1.1'), ('LPPL-1.1+'), ('LPPL-1.2'), ('LPPL-1.2+'), ('LPPL-1.3'), ('LPPL-1.3+'), ('LPPL-1.3a'), ('LPPL-1.3a+'), ('LPPL-1.3b'), ('LPPL-1.3b+'), ('LPPL-1.3c'), ('LPPL-1.3c+'), ('MacroMedia-RPSL'), ('Macrovision'), ('Macrovision-EULA'), ('Majordomo'), ('Majordomo-1.1'), ('Mandriva'), ('Mellanox'), ('MetroLink'), ('MetroLink-nonfree'), ('Mibble'), ('Mibble-2.8'), ('Microsoft'), ('Migemo'), ('MindTerm'), ('MirOS'), ('MIT'), ('MIT.BSD'), ('MIT&BSD'), ('MITEM'), ('Mitre'), ('MitreCVW'), ('MitreCVW-style'), ('MIT-style'), ('Motorola'), ('Motosoto'), ('MPEG3-decoder'), ('MPL'), ('MPL-1.0'), ('MPL-1.1'), ('MPL-1.1+'), ('MPL-1.1-style'), ('MPL-2.0'), ('MPL-2.0-no-copyleft-exception'), ('MPL-EULA-1.1'), ('MPL-EULA-2.0'), ('MPL-EULA-3.0'), ('MPL-style'), ('MPL.TPL'), ('MPL.TPL-1.0'), ('M-Plus-Project'), ('MRL'), ('MS-EULA'), ('MS-indemnity'), ('MS-IP'), ('MS-LPL'), ('MS-LRL'), ('MS-PL'), ('MS-RL'), ('MS-SSL'), ('Multics'), ('MX4J'), ('MX4J-1.0'), ('MySQL-0.3'), ('MySQL.FLOSS'), ('MySQL-style'), ('NASA'), ('NASA-1.3'), ('Naumen'), ('NBPL-1.0'), ('nCipher'), ('NCSA'), ('NESSUS-EULA'), ('NGPL'), ('Nokia'), ('No_license_found'), ('non-ATT-BSD'), ('Non-commercial'), ('Non-profit'), ('NOSL'), ('NOSL-1.0'), ('Not-for-sale'), ('Not-Free'), ('Not-Internet'), ('Not-OpenSource'), ('NOT-Open-Source'), ('NotreDame'), ('NotreDame-style'), ('Novell'), ('Novell-EULA'), ('Novell-IP'), ('NPL'), ('NPL-1.0'), ('NPL-1.1'), ('NPL-1.1+'), ('NPL-EULA'), ('NPOSL-3.0'), ('NRL'), ('NTP'), ('Nvidia'), ('Nvidia-EULA'), ('OASIS'), ('OCL'), ('OCL-1.0'), ('OCLC'), ('OCLC-1.0'), ('OCLC-2.0'), ('OCL-style'), ('ODbL-1.0'), ('ODL'), ('OFL-1.0'), ('OFL-1.1'), ('OGTSL'), ('OLDAP'), ('OLDAP-1.1'), ('OLDAP-1.2'), ('OLDAP-1.3'), ('OLDAP-1.4'), ('OLDAP-2.0'), ('OLDAP-2.0.1'), ('OLDAP-2.1'), ('OLDAP-2.2'), ('OLDAP-2.2.1'), ('OLDAP-2.2.2'), ('OLDAP-2.3'), ('OLDAP-2.4'), ('OLDAP-2.5'), ('OLDAP-2.6'), ('OLDAP-2.7'), ('OLDAP-2.8'), ('OLDAP-style'), ('OMF'), ('OMRON'), ('Ontopia'), ('OpenCASCADE-PL'), ('OpenGroup'), ('OpenGroup-Proprietary'), ('OpenGroup-style'), ('OpenMap'), ('OpenMarket'), ('Open-PL'), ('Open-PL-0.4'), ('Open-PL-1.0'), ('Open-PL-style'), ('OpenSSL'), ('OpenSSL-exception'), ('OPL-1.0'), ('OPL-style'), ('Oracle-Berkeley-DB'), ('Oracle-Dev'), ('Oracle-EULA'), ('OReilly'), ('OReilly-style'), ('OSD'), ('OSF'), ('OSF-style'), ('OSL'), ('OSL-1.0'), ('OSL-1.1'), ('OSL-2.0'), ('OSL-2.1'), ('OSL-3.0'), ('Paradigm'), ('Patent-ref'), ('PDDL-1.0'), ('Phorum'), ('PHP'), ('PHP-2.0'), ('PHP-2.0.2'), ('PHP-3.0'), ('PHP-3.01'), ('PHP-style'), ('Piriform'), ('Pixware-EULA'), ('Platform-Computing(RESTRICTED)'), ('Polyserve-CONFIDENTIAL'), ('Postfix'), ('PostgreSQL'), ('Powder-Proprietary'), ('Princeton'), ('Princeton-style'), ('Proprietary'), ('Public-domain'), ('Public-domain(C)'), ('Public-domain-ref'), ('Public-Use'), ('Public-Use-1.0'), ('Python'), ('Python-2.0'), ('Python-2.0.1'), ('Python-2.0.2'), ('Python-2.1.1'), ('Python-2.1.3'), ('Python-2.2'), ('Python-2.2.3'), ('Python-2.2.7'), ('Python-2.3'), ('Python-2.3.7'), ('Python-2.4.4'), ('Python-style'), ('Qmail'), ('QPL'), ('QPL-1.0'), ('QT.Commercial'), ('QuarterDeck'), ('Quest-EULA'), ('RCSL'), ('RCSL-1.0'), ('RCSL-2.0'), ('RCSL-3.0'), ('RealNetworks-EULA'), ('RedHat'), ('RedHat-EULA'), ('RedHat.Non-commercial'), ('RedHat-specific'), ('Redland'), ('Restricted-rights'), ('RHeCos-1.1'), ('Riverbank-EULA'), ('RPL'), ('RPL-1.0'), ('RPL-1.1'), ('RPL-1.5'), ('RPSL'), ('RPSL-1.0'), ('RPSL-2.0'), ('RPSL-3.0'), ('RSA-DNS'), ('RSA-Security'), ('RSCPL'), ('Ruby'), ('Same-license-as'), ('SAX-PD'), ('SciTech'), ('SCO.commercial'), ('SCSL'), ('SCSL-2.3'), ('SCSL-3.0'), ('SCSL-TSA'), ('SCSL-TSA-1.0'), ('See-doc.OTHER'), ('See-file'), ('See-file.COPYING'), ('See-file.LICENSE'), ('See-file.README'), ('See-URL'), ('Sendmail'), ('SGI'), ('SGI-B-1.0'), ('SGI-B-1.1'), ('SGI-B-2.0'), ('SGI-Freeware'), ('SGI_GLX'), ('SGI_GLX-1.0'), ('SGI-Proprietary'), ('SGI-style'), ('SGML'), ('SimPL-2.0'), ('SISSL'), ('SISSL-1.1'), ('SISSL-1.2'), ('Skype-EULA'), ('Sleepycat'), ('Sleepycat.Non-commercial'), ('SMLNJ'), ('SNIA'), ('SNIA-1.0'), ('SNIA-1.1'), ('SpikeSource'), ('SPL'), ('SPL-1.0'), ('Stanford'), ('Stanford-style'), ('SugarCRM-1.1.3'), ('Sun'), ('SUN'), ('Sun-BCLA'), ('Sun-BCLA-1.5.0'), ('Sun-EULA'), ('Sun-IP'), ('Sun-Java'), ('Sun.Non-commercial'), ('SunPro'), ('Sun-Proprietary'), ('Sun.RESTRICTED'), ('Sun-RPC'), ('Sun-SCA'), ('Sun(tm)'), ('SW-Research'), ('Tapjoy'), ('TCL'), ('Tektronix'), ('Tektronix-style'), ('TeX-exception'), ('Trident-EULA'), ('Trolltech'), ('TrueCrypt-3.0'), ('U-BC'), ('U-Cambridge'), ('U-Cambridge-style'), ('UCAR'), ('UCAR-style'), ('U-Chicago'), ('U-Columbia'), ('UCWare-EULA'), ('U-Del'), ('U-Del-style'), ('U-Edinburgh'), ('U-Edinburgh-style'), ('U-Michigan'), ('U-Mich-style'), ('U-Monash'), ('Unicode'), ('Unidex'), ('UnitedLinux-EULA'), ('Unix-Intl'), ('Unlicense'), ('unRAR restriction'), ('URA.govt'), ('USC'), ('USC.Non-commercial'), ('USC-style'), ('US-Export-restrict'), ('USL-Europe'), ('U-Utah'), ('U-Wash.Free-Fork'), ('U-Washington'), ('U-Wash-style'), ('VIM'), ('Vixie'), ('Vixie-license'), ('VMware-EULA'), ('VSL-1.0'), ('W3C'), ('W3C-IP'), ('W3C-style'), ('Wash-U-StLouis'), ('Wash-U-style'), ('Watcom'), ('Watcom-1.0'), ('WebM'), ('Wintertree'), ('WordNet-3.0'), ('WTFPL'), ('WTI.Not-free'), ('WXwindows'), ('X11'), ('X11-style'), ('Xerox'), ('Xerox-style'), ('XFree86'), ('XFree86-1.0'), ('XFree86-1.1'), ('Ximian'), ('Ximian-1.0'), ('XMLDB-1.0'), ('Xnet'), ('X/Open'), ('XOPEN-EULA'), ('X/Open-style'), ('Yahoo-EULA'), ('YaST.SuSE'), ('YPL'), ('YPL-1.0'), ('YPL-1.1'), ('Zend-1.0'), ('Zend-2.0'), ('Zeus'), ('Zimbra'), ('Zimbra-1.2'), ('Zimbra-1.3'), ('Zlib'), ('Zlib-possibility'), ('ZoneAlarm-EULA'), ('ZPL'), ('ZPL-1.0'), ('ZPL-1.1'), ('ZPL-2.0'), ('ZPL-2.1'), ('Zveno'), ('Affero-possibility'), ('Apache-possibility'), ('Apache_v2-possibility'), ('Artistic-possibility'), ('BSD-possibility'), ('CMU-possibility'), ('CPL-possibility'), ('Freeware'), ('FSF-possibility'), ('GPL-2.0+:3.0'), ('GPL-2.0+&GPL-3.0+'), ('GPL-2.1[sic]'), ('GPL-2.1+[sic]'), ('GPL-possibility'), ('HP-possibility'), ('IBM-possibility'), ('ISC-possibility'), ('LGPL-possibility'), ('LGPL_v3-possibility'), ('Microsoft-possibility'), ('MIT-possibility'), ('NOT-public-domain'), ('Perl-possibility'), ('PHP-possibility'), ('RSA-possibility'), ('Sun-possibility'), ('Trademark-ref'), ('UnclassifiedLicense'), ('W3C-possibility'), ('X11-possibility'); insert into indexer_configuration(tool_name, tool_version, tool_configuration) values ('nomos', '3.1.0rc2-31-ga2cbb8c', '{"command_line": "nomossa "}'); insert into indexer_configuration(tool_name, tool_version, tool_configuration) values ('file', '5.22', '{"command_line": "file --mime "}'); insert into indexer_configuration(tool_name, tool_version, tool_configuration) values ('universal-ctags', '~git7859817b', '{"command_line": "ctags --fields=+lnz --sort=no --links=no --output-format=json "}'); insert into indexer_configuration(tool_name, tool_version, tool_configuration) values ('pygments', '2.0.1+dfsg-1.1+deb8u1', '{"type": "library", "debian-package": "python3-pygments"}'); + +insert into indexer_configuration(tool_name, tool_version, tool_configuration) +values ('pygments', '2.0.1+dfsg-1.1+deb8u1', '{"type": "library", "debian-package": "python3-pygments", "max_content_size": 10240}'); diff --git a/sql/swh-indexes.sql b/sql/swh-indexes.sql index 9f7d06b1..7055bfc4 100644 --- a/sql/swh-indexes.sql +++ b/sql/swh-indexes.sql @@ -1,274 +1,274 @@ -- content create unique index concurrently content_pkey on content(sha1); create unique index concurrently on content(sha1_git); create index concurrently on content(sha256); create index concurrently on content(blake2s256); create index concurrently on content(ctime); -- TODO use a BRIN index here (postgres >= 9.5) create index concurrently on content(object_id); alter table content add primary key using index content_pkey; -- entity_history create unique index concurrently entity_history_pkey on entity_history(id); create index concurrently on entity_history(uuid); create index concurrently on entity_history(name); alter table entity_history add primary key using index entity_history_pkey; -- entity create unique index concurrently entity_pkey on entity(uuid); create index concurrently on entity(name); create index concurrently on entity using gin(lister_metadata jsonb_path_ops); alter table entity add primary key using index entity_pkey; alter table entity add constraint entity_parent_fkey foreign key (parent) references entity(uuid) deferrable initially deferred not valid; alter table entity validate constraint entity_parent_fkey; alter table entity add constraint entity_last_id_fkey foreign key (last_id) references entity_history(id) not valid; alter table entity validate constraint entity_last_id_fkey; -- entity_equivalence create unique index concurrently entity_equivalence_pkey on entity_equivalence(entity1, entity2); alter table entity_equivalence add primary key using index entity_equivalence_pkey; alter table entity_equivalence add constraint "entity_equivalence_entity1_fkey" foreign key (entity1) references entity(uuid) not valid; alter table entity_equivalence validate constraint entity_equivalence_entity1_fkey; alter table entity_equivalence add constraint "entity_equivalence_entity2_fkey" foreign key (entity2) references entity(uuid) not valid; alter table entity_equivalence validate constraint entity_equivalence_entity2_fkey; alter table entity_equivalence add constraint "order_entities" check (entity1 < entity2) not valid; alter table entity_equivalence validate constraint order_entities; -- listable_entity create unique index concurrently listable_entity_pkey on listable_entity(uuid); alter table listable_entity add primary key using index listable_entity_pkey; alter table listable_entity add constraint listable_entity_uuid_fkey foreign key (uuid) references entity(uuid) not valid; alter table listable_entity validate constraint listable_entity_uuid_fkey; -- list_history create unique index concurrently list_history_pkey on list_history(id); alter table list_history add primary key using index list_history_pkey; alter table list_history add constraint list_history_entity_fkey foreign key (entity) references listable_entity(uuid) not valid; alter table list_history validate constraint list_history_entity_fkey; -- origin create unique index concurrently origin_pkey on origin(id); alter table origin add primary key using index origin_pkey; create index concurrently on origin(type, url); alter table origin add constraint origin_lister_fkey foreign key (lister) references listable_entity(uuid) not valid; alter table origin validate constraint origin_lister_fkey; alter table origin add constraint origin_project_fkey foreign key (project) references entity(uuid) not valid; alter table origin validate constraint origin_project_fkey; -- skipped_content alter table skipped_content add constraint skipped_content_sha1_sha1_git_sha256_key unique (sha1, sha1_git, sha256); create unique index concurrently on skipped_content(sha1); create unique index concurrently on skipped_content(sha1_git); create index concurrently on skipped_content(sha256); create index concurrently on skipped_content(blake2s256); create index concurrently on skipped_content(object_id); alter table skipped_content add constraint skipped_content_origin_fkey foreign key (origin) references origin(id) not valid; alter table skipped_content validate constraint skipped_content_origin_fkey; -- fetch_history create unique index concurrently fetch_history_pkey on fetch_history(id); alter table fetch_history add primary key using index fetch_history_pkey; alter table fetch_history add constraint fetch_history_origin_fkey foreign key (origin) references origin(id) not valid; alter table fetch_history validate constraint fetch_history_origin_fkey; -- directory create unique index concurrently directory_pkey on directory(id); alter table directory add primary key using index directory_pkey; create index concurrently on directory using gin (dir_entries); create index concurrently on directory using gin (file_entries); create index concurrently on directory using gin (rev_entries); create index concurrently on directory(object_id); -- directory_entry_dir create unique index concurrently directory_entry_dir_pkey on directory_entry_dir(id); alter table directory_entry_dir add primary key using index directory_entry_dir_pkey; create unique index concurrently on directory_entry_dir(target, name, perms); -- directory_entry_file create unique index concurrently directory_entry_file_pkey on directory_entry_file(id); alter table directory_entry_file add primary key using index directory_entry_file_pkey; create unique index concurrently on directory_entry_file(target, name, perms); -- directory_entry_rev create unique index concurrently directory_entry_rev_pkey on directory_entry_rev(id); alter table directory_entry_rev add primary key using index directory_entry_rev_pkey; create unique index concurrently on directory_entry_rev(target, name, perms); -- person create unique index concurrently person_pkey on person(id); alter table person add primary key using index person_pkey; create unique index concurrently on person(fullname); create index concurrently on person(name); create index concurrently on person(email); -- revision create unique index concurrently revision_pkey on revision(id); alter table revision add primary key using index revision_pkey; alter table revision add constraint revision_author_fkey foreign key (author) references person(id) not valid; alter table revision validate constraint revision_author_fkey; alter table revision add constraint revision_committer_fkey foreign key (committer) references person(id) not valid; alter table revision validate constraint revision_committer_fkey; create index concurrently on revision(directory); create index concurrently on revision(object_id); -- revision_history create unique index concurrently revision_history_pkey on revision_history(id, parent_rank); alter table revision_history add primary key using index revision_history_pkey; create index concurrently on revision_history(parent_id); alter table revision_history add constraint revision_history_id_fkey foreign key (id) references revision(id) not valid; alter table revision_history validate constraint revision_history_id_fkey; -- origin_visit create unique index concurrently origin_visit_pkey on origin_visit(origin, visit); alter table origin_visit add primary key using index origin_visit_pkey; create index concurrently on origin_visit(date); alter table origin_visit add constraint origin_visit_origin_fkey foreign key (origin) references origin(id) not valid; alter table origin_visit validate constraint origin_visit_origin_fkey; -- occurrence_history create unique index concurrently occurrence_history_pkey on occurrence_history(object_id); alter table occurrence_history add primary key using index occurrence_history_pkey; create index concurrently on occurrence_history(target, target_type); create index concurrently on occurrence_history(origin, branch); create unique index concurrently on occurrence_history(origin, branch, target, target_type); alter table occurrence_history add constraint occurrence_history_origin_fkey foreign key (origin) references origin(id) not valid; alter table occurrence_history validate constraint occurrence_history_origin_fkey; -- occurrence create unique index concurrently occurrence_pkey on occurrence(origin, branch); alter table occurrence add primary key using index occurrence_pkey; alter table occurrence add constraint occurrence_origin_fkey foreign key (origin) references origin(id) not valid; alter table occurrence validate constraint occurrence_origin_fkey; -- release create unique index concurrently release_pkey on release(id); alter table release add primary key using index release_pkey; create index concurrently on release(target, target_type); create index concurrently on release(object_id); alter table release add constraint release_author_fkey foreign key (author) references person(id) not valid; alter table release validate constraint release_author_fkey; -- cache_content_revision create unique index concurrently cache_content_revision_pkey on cache_content_revision(content); alter table cache_content_revision add primary key using index cache_content_revision_pkey; alter table cache_content_revision add constraint cache_content_revision_content_fkey foreign key (content) references content(sha1_git) not valid; alter table cache_content_revision validate constraint cache_content_revision_content_fkey; -- cache_content_revision_processed create unique index concurrently cache_content_revision_processed_pkey on cache_content_revision_processed(revision); alter table cache_content_revision_processed add primary key using index cache_content_revision_processed_pkey; alter table cache_content_revision_processed add constraint cache_content_revision_processed_revision_fkey foreign key (revision) references revision(id) not valid; alter table cache_content_revision_processed validate constraint cache_content_revision_processed_revision_fkey; -- cache_revision_origin create unique index concurrently cache_revision_origin_pkey on cache_revision_origin(revision, origin, visit); alter table cache_revision_origin add primary key using index cache_revision_origin_pkey; alter table cache_revision_origin add constraint cache_revision_origin_revision_fkey foreign key (revision) references revision(id) not valid; alter table cache_revision_origin validate constraint cache_revision_origin_revision_fkey; alter table cache_revision_origin add constraint cache_revision_origin_origin_fkey foreign key (origin, visit) references origin_visit(origin, visit) not valid; alter table cache_revision_origin validate constraint cache_revision_origin_origin_fkey; create index concurrently on cache_revision_origin(revision); -- indexer_configuration create unique index concurrently indexer_configuration_pkey on indexer_configuration(id); alter table indexer_configuration add primary key using index indexer_configuration_pkey; -create unique index on indexer_configuration(tool_name, tool_version); +create unique index on indexer_configuration(tool_name, tool_version, tool_configuration); -- content_mimetype create unique index concurrently content_mimetype_pkey on content_mimetype(id, indexer_configuration_id); alter table content_mimetype add primary key using index content_mimetype_pkey; alter table content_mimetype add constraint content_mimetype_id_fkey foreign key (id) references content(sha1) not valid; alter table content_mimetype validate constraint content_mimetype_id_fkey; alter table content_mimetype add constraint content_mimetype_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; alter table content_mimetype validate constraint content_mimetype_indexer_configuration_id_fkey; -- content_language create unique index concurrently content_language_pkey on content_language(id, indexer_configuration_id); alter table content_language add primary key using index content_language_pkey; alter table content_language add constraint content_language_id_fkey foreign key (id) references content(sha1) not valid; alter table content_language validate constraint content_language_id_fkey; alter table content_language add constraint content_language_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; alter table content_language validate constraint content_language_indexer_configuration_id_fkey; -- content_ctags create index concurrently on content_ctags(id); create index concurrently on content_ctags(hash_sha1(name)); create unique index concurrently on content_ctags(id, hash_sha1(name), kind, line, lang, indexer_configuration_id); alter table content_ctags add constraint content_ctags_id_fkey foreign key (id) references content(sha1) not valid; alter table content_ctags validate constraint content_ctags_id_fkey; alter table content_ctags add constraint content_ctags_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; alter table content_ctags validate constraint content_ctags_indexer_configuration_id_fkey; -- fossology_license create unique index concurrently fossology_license_pkey on fossology_license(id); alter table fossology_license add primary key using index fossology_license_pkey; create unique index on fossology_license(name); -- content_fossology_license create unique index concurrently content_fossology_license_pkey on content_fossology_license(id, license_id, indexer_configuration_id); alter table content_fossology_license add primary key using index content_fossology_license_pkey; alter table content_fossology_license add constraint content_fossology_license_id_fkey foreign key (id) references content(sha1) not valid; alter table content_fossology_license validate constraint content_fossology_license_id_fkey; alter table content_fossology_license add constraint content_fossology_license_license_id_fkey foreign key (license_id) references fossology_license(id) not valid; alter table content_fossology_license validate constraint content_fossology_license_license_id_fkey; alter table content_fossology_license add constraint content_fossology_license_indexer_configuration_id_fkey foreign key (indexer_configuration_id) references indexer_configuration(id) not valid; alter table content_fossology_license validate constraint content_fossology_license_indexer_configuration_id_fkey;