CreateSystemLogTable Class Reference

Inheritance diagram for CreateSystemLogTable:

Public Member Functions
	change ()
	CREATE TABLE prefix_system_log ( id int(11) NOT NULL AUTO_INCREMENT, object_id int(11) NOT NULL, object_class varchar(50) NOT NULL, object_type varchar(50) NOT NULL, object_subtype varchar(50) NOT NULL, event varchar(50) NOT NULL, performed_by_guid bigint(20) unsigned NOT NULL, owner_guid bigint(20) unsigned NOT NULL, access_id int(11) NOT NULL, enabled enum('yes','no') NOT NULL DEFAULT 'yes', time_created int(11) NOT NULL, ip_address varchar(46) NOT NULL, PRIMARY KEY (id), KEY object_id (object_id), KEY object_class (object_class), KEY object_type (object_type), KEY object_subtype (object_subtype), KEY event (event), KEY performed_by_guid (performed_by_guid), KEY access_id (access_id), KEY time_created (time_created), KEY river_key (object_type,object_subtype,event) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;. More...

Detailed Description

Definition at line 6 of file 20170728075232_create_system_log_table.php.

Member Function Documentation

CreateSystemLogTable::change

(

)

CREATE TABLE prefix_system_log ( id int(11) NOT NULL AUTO_INCREMENT, object_id int(11) NOT NULL, object_class varchar(50) NOT NULL, object_type varchar(50) NOT NULL, object_subtype varchar(50) NOT NULL, event varchar(50) NOT NULL, performed_by_guid bigint(20) unsigned NOT NULL, owner_guid bigint(20) unsigned NOT NULL, access_id int(11) NOT NULL, enabled enum('yes','no') NOT NULL DEFAULT 'yes', time_created int(11) NOT NULL, ip_address varchar(46) NOT NULL, PRIMARY KEY (id), KEY object_id (object_id), KEY object_class (object_class), KEY object_type (object_type), KEY object_subtype (object_subtype), KEY event (event), KEY performed_by_guid (performed_by_guid), KEY access_id (access_id), KEY time_created (time_created), KEY river_key (object_type,object_subtype,event) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;.

Definition at line 33 of file 20170728075232_create_system_log_table.php.

---

The documentation for this class was generated from the following file:

• engine/schema/migrations/20170728075232_create_system_log_table.php