Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 918 → Rev 919

/trunk/setup/sql/example_access.sql
1,5 → 1,17
INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.32488192274','example',0,0);
 
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A', 'aid:', 'International identifiers', NULL, NULL, '0', '29.07.2022 15:11:17', '29.07.2022 15:11:30');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A000000151', 'aid:A', 'GlobalPlatform', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:49', '29.07.2022 15:13:29');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A0000001510000', 'aid:A000000151', 'Global Platform Security Domain AID GP Card Manager', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:13:02', '29.07.2022 15:13:22');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D', 'aid:', 'National identifiers', NULL, NULL, '0', '29.07.2022 15:06:37', '29.07.2022 15:06:53');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276', 'aid:D', 'Germany', '<p><span style="color: #e03e2d;">This RID prefix is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:06:58', '29.07.2022 15:14:07');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276000022', 'aid:D276', 'IBM Laboratories', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:07:26', '29.07.2022 15:10:43');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000001', 'aid:D276000022', 'SCT LOYALTY - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:22', '29.07.2022 15:10:50');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000002', 'aid:D276000022', 'BUSINESS CARD - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:45', '29.07.2022 15:10:57');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000060', 'aid:D276000022', 'PKCS#11 Token - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:55', '29.07.2022 15:11:04');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F', 'aid:', 'Proprietary, non-registered identifiers', NULL, NULL, '0', '29.07.2022 15:11:12', '29.07.2022 15:17:01');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C127', 'aid:F', 'ViaThinkSoft (RID)', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:11:47', '29.07.2022 15:13:37');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C1274558414D504C4501', 'aid:F82549C127', 'Example AID #1', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:02', '29.07.2022 15:13:46');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000','doi:','DOI Foundation (Example)','<p><strong>DOI Foundation</strong></p>' + CHR(13) + '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:29','2019-03-10 22:42:31');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000/182','doi:10.1000','DOI Handbook','<p><b>DOI Handbook</b></p>' + CHR(13) + '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:20',NULL);
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1371','doi:','CNRI (Example)','<p><strong>Corporation for National Research Initiatives (CNRI)</strong></p>' + CHR(13) + '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:40','2019-03-10 22:42:37');
/trunk/setup/sql/example_mssql.sql
2,6 → 2,18
 
INSERT INTO [asn1id] (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.32488192274','example',0,0);
 
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A', 'aid:', 'International identifiers', NULL, NULL, '0', '29.07.2022 15:11:17', '29.07.2022 15:11:30');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A000000151', 'aid:A', 'GlobalPlatform', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:49', '29.07.2022 15:13:29');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A0000001510000', 'aid:A000000151', 'Global Platform Security Domain AID GP Card Manager', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:13:02', '29.07.2022 15:13:22');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D', 'aid:', 'National identifiers', NULL, NULL, '0', '29.07.2022 15:06:37', '29.07.2022 15:06:53');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276', 'aid:D', 'Germany', '<p><span style="color: #e03e2d;">This RID prefix is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:06:58', '29.07.2022 15:14:07');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276000022', 'aid:D276', 'IBM Laboratories', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:07:26', '29.07.2022 15:10:43');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000001', 'aid:D276000022', 'SCT LOYALTY - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:22', '29.07.2022 15:10:50');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000002', 'aid:D276000022', 'BUSINESS CARD - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:45', '29.07.2022 15:10:57');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000060', 'aid:D276000022', 'PKCS#11 Token - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:55', '29.07.2022 15:11:04');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F', 'aid:', 'Proprietary, non-registered identifiers', NULL, NULL, '0', '29.07.2022 15:11:12', '29.07.2022 15:17:01');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C127', 'aid:F', 'ViaThinkSoft (RID)', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:11:47', '29.07.2022 15:13:37');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C1274558414D504C4501', 'aid:F82549C127', 'Example AID #1', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:02', '29.07.2022 15:13:46');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000','doi:','DOI Foundation (Example)','<p><strong>DOI Foundation</strong></p>' + CHAR(13) + '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:29','2019-03-10 22:42:31');
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000/182','doi:10.1000','DOI Handbook','<p><b>DOI Handbook</b></p>' + CHAR(13) + '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:20',NULL);
INSERT INTO [objects] (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1371','doi:','CNRI (Example)','<p><strong>Corporation for National Research Initiatives (CNRI)</strong></p>' + CHAR(13) + '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:40','2019-03-10 22:42:37');
/trunk/setup/sql/example_mysql.sql
Cannot display: file marked as a binary type.
svn:mime-type = application/x-sql
/trunk/setup/sql/example_oracle.sql
3,6 → 3,18
 
INSERT INTO "ASN1ID" (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.32488192274','example',0,0);
 
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A', 'aid:', 'International identifiers', NULL, NULL, '0', '29.07.2022 15:11:17', '29.07.2022 15:11:30');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A000000151', 'aid:A', 'GlobalPlatform', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:49', '29.07.2022 15:13:29');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A0000001510000', 'aid:A000000151', 'Global Platform Security Domain AID GP Card Manager', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:13:02', '29.07.2022 15:13:22');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D', 'aid:', 'National identifiers', NULL, NULL, '0', '29.07.2022 15:06:37', '29.07.2022 15:06:53');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276', 'aid:D', 'Germany', '<p><span style="color: #e03e2d;">This RID prefix is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:06:58', '29.07.2022 15:14:07');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276000022', 'aid:D276', 'IBM Laboratories', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:07:26', '29.07.2022 15:10:43');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000001', 'aid:D276000022', 'SCT LOYALTY - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:22', '29.07.2022 15:10:50');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000002', 'aid:D276000022', 'BUSINESS CARD - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:45', '29.07.2022 15:10:57');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000060', 'aid:D276000022', 'PKCS#11 Token - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:55', '29.07.2022 15:11:04');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F', 'aid:', 'Proprietary, non-registered identifiers', NULL, NULL, '0', '29.07.2022 15:11:12', '29.07.2022 15:17:01');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C127', 'aid:F', 'ViaThinkSoft (RID)', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:11:47', '29.07.2022 15:13:37');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C1274558414D504C4501', 'aid:F82549C127', 'Example AID #1', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:02', '29.07.2022 15:13:46');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000','doi:','DOI Foundation (Example)','<p><strong>DOI Foundation</strong></p>' || chr(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,TIMESTAMP '2018-09-30 22:47:29',TIMESTAMP '2019-03-10 22:42:31');
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000/182','doi:10.1000','DOI Handbook','<p><b>DOI Handbook</b></p>' || chr(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,TIMESTAMP '2018-09-30 22:47:20',NULL);
INSERT INTO "OBJECTS" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1371','doi:','CNRI (Example)','<p><strong>Corporation for National Research Initiatives (CNRI)</strong></p>' || chr(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,TIMESTAMP '2018-09-30 22:47:40',TIMESTAMP '2019-03-10 22:42:37');
/trunk/setup/sql/example_pgsql.sql
1,5 → 1,17
INSERT INTO "asn1id" (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.32488192274','example',false,false);
 
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A', 'aid:', 'International identifiers', NULL, NULL, '0', '29.07.2022 15:11:17', '29.07.2022 15:11:30');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A000000151', 'aid:A', 'GlobalPlatform', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:49', '29.07.2022 15:13:29');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A0000001510000', 'aid:A000000151', 'Global Platform Security Domain AID GP Card Manager', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:13:02', '29.07.2022 15:13:22');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D', 'aid:', 'National identifiers', NULL, NULL, '0', '29.07.2022 15:06:37', '29.07.2022 15:06:53');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276', 'aid:D', 'Germany', '<p><span style="color: #e03e2d;">This RID prefix is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:06:58', '29.07.2022 15:14:07');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276000022', 'aid:D276', 'IBM Laboratories', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:07:26', '29.07.2022 15:10:43');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000001', 'aid:D276000022', 'SCT LOYALTY - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:22', '29.07.2022 15:10:50');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000002', 'aid:D276000022', 'BUSINESS CARD - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:45', '29.07.2022 15:10:57');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000060', 'aid:D276000022', 'PKCS#11 Token - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:55', '29.07.2022 15:11:04');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F', 'aid:', 'Proprietary, non-registered identifiers', NULL, NULL, '0', '29.07.2022 15:11:12', '29.07.2022 15:17:01');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C127', 'aid:F', 'ViaThinkSoft (RID)', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:11:47', '29.07.2022 15:13:37');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C1274558414D504C4501', 'aid:F82549C127', 'Example AID #1', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:02', '29.07.2022 15:13:46');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000','doi:','DOI Foundation (Example)','<p><strong>DOI Foundation</strong></p>' || chr(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',false,'2018-09-30 22:47:29','2019-03-10 22:42:31');
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000/182','doi:10.1000','DOI Handbook','<p><b>DOI Handbook</b></p>' || chr(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',false,'2018-09-30 22:47:20',NULL);
INSERT INTO "objects" (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1371','doi:','CNRI (Example)','<p><strong>Corporation for National Research Initiatives (CNRI)</strong></p>' || chr(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',false,'2018-09-30 22:47:40','2019-03-10 22:42:37');
/trunk/setup/sql/example_sqlite.sql
1,5 → 1,17
INSERT INTO `asn1id` (oid, name, standardized, well_known) VALUES ('oid:1.3.6.1.4.1.37553.8.32488192274','example',0,0);
 
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A', 'aid:', 'International identifiers', NULL, NULL, '0', '29.07.2022 15:11:17', '29.07.2022 15:11:30');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A000000151', 'aid:A', 'GlobalPlatform', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:49', '29.07.2022 15:13:29');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:A0000001510000', 'aid:A000000151', 'Global Platform Security Domain AID GP Card Manager', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:13:02', '29.07.2022 15:13:22');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D', 'aid:', 'National identifiers', NULL, NULL, '0', '29.07.2022 15:06:37', '29.07.2022 15:06:53');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276', 'aid:D', 'Germany', '<p><span style="color: #e03e2d;">This RID prefix is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:06:58', '29.07.2022 15:14:07');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D276000022', 'aid:D276', 'IBM Laboratories', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:07:26', '29.07.2022 15:10:43');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000001', 'aid:D276000022', 'SCT LOYALTY - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:22', '29.07.2022 15:10:50');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000002', 'aid:D276000022', 'BUSINESS CARD - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:45', '29.07.2022 15:10:57');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:D27600002200000060', 'aid:D276000022', 'PKCS#11 Token - IBM Test card from the book "Smart Card Application Development Using Java"', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:09:55', '29.07.2022 15:11:04');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F', 'aid:', 'Proprietary, non-registered identifiers', NULL, NULL, '0', '29.07.2022 15:11:12', '29.07.2022 15:17:01');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C127', 'aid:F', 'ViaThinkSoft (RID)', '<p><span style="color: #e03e2d;">This RID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:11:47', '29.07.2022 15:13:37');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('aid:F82549C1274558414D504C4501', 'aid:F82549C127', 'Example AID #1', '<p><span style="color: #e03e2d;">This AID is only included as an example.</span><br /><span style="color: #e03e2d;">Please delete this object once your database goes online.</span></p>', NULL, '0', '29.07.2022 15:12:02', '29.07.2022 15:13:46');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000','doi:','DOI Foundation (Example)','<p><strong>DOI Foundation</strong></p>' || char(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:29','2019-03-10 22:42:31');
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1000/182','doi:10.1000','DOI Handbook','<p><b>DOI Handbook</b></p>' || char(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:20',NULL);
INSERT INTO `objects` (id, parent, title, description, ra_email, confidential, created, updated) VALUES ('doi:10.1371','doi:','CNRI (Example)','<p><strong>Corporation for National Research Initiatives (CNRI)</strong></p>' || char(10) || '<p>This DOI is only included as an example.<br />Please delete this object once your database goes online.</p>','',0,'2018-09-30 22:47:40','2019-03-10 22:42:37');