INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values (10157, 'EPSG', 10157, '+proj=longlat +ellps=GRS80 +vunits=m +no_defs +type=crs', 'COMPD_CS["ETRS89 + CD UK & Ireland VORF08 depth",GEOGCS["ETRS89",DATUM["European_Terrestrial_Reference_System_1989",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6258"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4258"]],VERT_CS["CD UK & Ireland VORF08 depth",VERT_DATUM["Chart Datum UK & Ireland VORF08",2005,AUTHORITY["EPSG","1331"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Depth",DOWN],AUTHORITY["EPSG","10151"]],AUTHORITY["EPSG","10157"]]');