/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'); |