sqlite3 ~/Library/Application\ddressBook/AddressBook-v22.abcddb '.schema ZABCDEMAILADDRESS'

CREATE TABLE ZABCDEMAILADDRESS ( Z_ENT INTEGER, Z_PK INTEGER PRIMARY KEY, Z_OPT INTEGER, ZORDERINGINDEX INTEGER, ZISPRIMARY INTEGER, ZOWNER INTEGER, Z19_OWNER INTEGER, ZISPRIVATE INTEGER, ZADDRESS VARCHAR, ZADDRESSNORMALIZED VARCHAR, ZUNIQUEID VARCHAR, ZLABEL VARCHAR );
CREATE INDEX ZABCDEMAILADDRESS_ZADDRESSNORMALIZED_INDEX ON ZABCDEMAILADDRESS (ZADDRESSNORMALIZED);
CREATE INDEX ZABCDEMAILADDRESS_ZADDRESS_INDEX ON ZABCDEMAILADDRESS (ZADDRESS);
CREATE INDEX ZABCDEMAILADDRESS_ZOWNER_INDEX ON ZABCDEMAILADDRESS (ZOWNER);