MODE
MODE
encryption strategy
All r/w operations on potentially encrypted fields in database should get initiated here.
TODO: would this enum be a good example for other tables? TODO: do we use InnoDB? TODO: do I use the correct character sets? TODO: should we use binary fields and don't use base64? TODO: what mysql datatype is appropriate for base64?
CREATE TABLE safe
(
id
int(11) NOT NULL auto_increment,
val_admin
text collate utf8_unicode_ci NOT NULL,
val_member
text collate utf8_unicode_ci NOT NULL,
id_member
int(11) NOT NULL,
encryption
enum('Y', 'N') collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sensitive data' AUTO_INCREMENT=0;
__construct(int $tablename, int $rownumber, $idMember, $keyMember) : void
tablename and rownumber are required to build the initialization vector
int | $tablename | name of table expressed as an integer,
|
int | $rownumber | number of row in the table afore mentioned |
$idMember | ||
$keyMember |