Elgg
Version master
|
Public Member Functions | |
change () | |
CREATE TABLE prefix_annotations ( id int(11) NOT NULL AUTO_INCREMENT, entity_guid bigint(20) unsigned NOT NULL, name text NOT NULL, value LONGTEXT NOT NULL, value_type enum('integer','text') NOT NULL, owner_guid bigint(20) unsigned NOT NULL, access_id int(11) NOT NULL, time_created int(11) NOT NULL, enabled enum('yes','no') NOT NULL DEFAULT 'yes', PRIMARY KEY (id ), KEY entity_guid (entity_guid ), KEY name (name (50)), KEY value (value (50)), KEY owner_guid (owner_guid ), KEY access_id (access_id ) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;. More... | |
Definition at line 6 of file 20170728073706_create_annotations_table.php.
CreateAnnotationsTable::change | ( | ) |
CREATE TABLE prefix_annotations
( id
int(11) NOT NULL AUTO_INCREMENT, entity_guid
bigint(20) unsigned NOT NULL, name
text NOT NULL, value
LONGTEXT NOT NULL, value_type
enum('integer','text') NOT NULL, owner_guid
bigint(20) unsigned NOT NULL, access_id
int(11) NOT NULL, time_created
int(11) NOT NULL, enabled
enum('yes','no') NOT NULL DEFAULT 'yes', PRIMARY KEY (id
), KEY entity_guid
(entity_guid
), KEY name
(name
(50)), KEY value
(value
(50)), KEY owner_guid
(owner_guid
), KEY access_id
(access_id
) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;.
Definition at line 26 of file 20170728073706_create_annotations_table.php.