github.com/uvalib/orcid-access-ws@v0.0.0-20250612130209-7d062dbabf9d/sql/orcids.sql (about)

     1  -- drop the table if it exists
     2  DROP TABLE IF EXISTS orcids;
     3  
     4  -- and create the new one
     5  CREATE TABLE orcids(
     6     id          INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
     7     cid         VARCHAR( 32 ) NOT NULL DEFAULT '',
     8     orcid       VARCHAR( 32 ) NOT NULL DEFAULT '',
     9     created_at  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    10     updated_at  TIMESTAMP NULL,
    11     UNIQUE KEY( cid )
    12  ) CHARACTER SET utf8 COLLATE utf8_bin;
    13  
    14  -- set of degree mapping values (manually created)
    15  INSERT INTO orcids( cid, orcid ) VALUES( "dpg3k", "0000-0002-0566-4186" );
    16  INSERT INTO orcids( cid, orcid ) VALUES( "ecr2c", "0000-0003-4520-4923" );