class RecOwner - jcobban/Genealogy GitHub Wiki

CREATE TABLE RecOwners ( RO_Index BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, RO_UserName VARCHAR(64) NOT NULL DEFAULT '', RO_Table VARCHAR(16) CHARACTER SET latin1 DEFAULT NULL, RO_KeyName VARCHAR(16) CHARACTER SET latin1 DEFAULT NULL, RO_KeyValue INT(10) UNSIGNED DEFAULT NULL, PRIMARY KEY (RO_Index), UNIQUE KEY RO_Index (RO_Index), KEY RO_UserName (RO_UserName), KEY RO_UserName_2 (RO_UserName), KEY RO_UserName_3 (RO_UserName), KEY RO_UserName_4 (RO_UserName), KEY RO_Table (RO_Table), KEY RO_KeyName (RO_KeyName), KEY RO_KeyValue (RO_KeyValue) ) ENGINE=InnoDB AUTO_INCREMENT=86546 DEFAULT CHARSET=utf8