'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'DraftID', ), 'GDN_Invitation' => array ( 'fields' => array ( 'InvitationID' => array ( 'field_data' => array ( 'field' => 'InvitationID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Email' => array ( 'field_data' => array ( 'field' => 'Email', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(50)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RoleIDs' => array ( 'field_data' => array ( 'field' => 'RoleIDs', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Code' => array ( 'field_data' => array ( 'field' => 'Code', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'UNI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AcceptedUserID' => array ( 'field_data' => array ( 'field' => 'AcceptedUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateAccepted' => array ( 'field_data' => array ( 'field' => 'DateAccepted', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateExpires' => array ( 'field_data' => array ( 'field' => 'DateExpires', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'InvitationID', ), 'GDN_Log' => array ( 'fields' => array ( 'LogID' => array ( 'field_data' => array ( 'field' => 'LogID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Operation' => array ( 'field_data' => array ( 'field' => 'Operation', 'type' => 'enum(\'Delete\',\'Edit\',\'Spam\',\'Moderate\',\'Pending\',\'Ban\',\'Error\')', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RecordType' => array ( 'field_data' => array ( 'field' => 'RecordType', 'type' => 'enum(\'Discussion\',\'Comment\',\'User\',\'Registration\',\'Activity\',\'ActivityComment\',\'Configuration\',\'Group\',\'Event\')', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TransactionLogID' => array ( 'field_data' => array ( 'field' => 'TransactionLogID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RecordID' => array ( 'field_data' => array ( 'field' => 'RecordID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RecordUserID' => array ( 'field_data' => array ( 'field' => 'RecordUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RecordDate' => array ( 'field_data' => array ( 'field' => 'RecordDate', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RecordIPAddress' => array ( 'field_data' => array ( 'field' => 'RecordIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'OtherUserIDs' => array ( 'field_data' => array ( 'field' => 'OtherUserIDs', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ParentRecordID' => array ( 'field_data' => array ( 'field' => 'ParentRecordID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Data' => array ( 'field_data' => array ( 'field' => 'Data', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountGroup' => array ( 'field_data' => array ( 'field' => 'CountGroup', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'LogID', ), 'GDN_Media' => array ( 'fields' => array ( 'MediaID' => array ( 'field_data' => array ( 'field' => 'MediaID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Path' => array ( 'field_data' => array ( 'field' => 'Path', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Size' => array ( 'field_data' => array ( 'field' => 'Size', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ForeignTable' => array ( 'field_data' => array ( 'field' => 'ForeignTable', 'type' => 'varchar(24)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ImageWidth' => array ( 'field_data' => array ( 'field' => 'ImageWidth', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ImageHeight' => array ( 'field_data' => array ( 'field' => 'ImageHeight', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ThumbWidth' => array ( 'field_data' => array ( 'field' => 'ThumbWidth', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ThumbHeight' => array ( 'field_data' => array ( 'field' => 'ThumbHeight', 'type' => 'smallint(5) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ThumbPath' => array ( 'field_data' => array ( 'field' => 'ThumbPath', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'MediaID', ), 'GDN_Message' => array ( 'fields' => array ( 'MessageID' => array ( 'field_data' => array ( 'field' => 'MessageID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Content' => array ( 'field_data' => array ( 'field' => 'Content', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Format' => array ( 'field_data' => array ( 'field' => 'Format', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AllowDismiss' => array ( 'field_data' => array ( 'field' => 'AllowDismiss', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Enabled' => array ( 'field_data' => array ( 'field' => 'Enabled', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Application' => array ( 'field_data' => array ( 'field' => 'Application', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Controller' => array ( 'field_data' => array ( 'field' => 'Controller', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Method' => array ( 'field_data' => array ( 'field' => 'Method', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'IncludeSubcategories' => array ( 'field_data' => array ( 'field' => 'IncludeSubcategories', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'AssetTarget' => array ( 'field_data' => array ( 'field' => 'AssetTarget', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CssClass' => array ( 'field_data' => array ( 'field' => 'CssClass', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Sort' => array ( 'field_data' => array ( 'field' => 'Sort', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'MessageID', ), 'GDN_Permission' => array ( 'fields' => array ( 'PermissionID' => array ( 'field_data' => array ( 'field' => 'PermissionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'RoleID' => array ( 'field_data' => array ( 'field' => 'RoleID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'JunctionTable' => array ( 'field_data' => array ( 'field' => 'JunctionTable', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'JunctionColumn' => array ( 'field_data' => array ( 'field' => 'JunctionColumn', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'JunctionID' => array ( 'field_data' => array ( 'field' => 'JunctionID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Email.View' => array ( 'field_data' => array ( 'field' => 'Garden.Email.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Settings.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Settings.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Settings.View' => array ( 'field_data' => array ( 'field' => 'Garden.Settings.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.SignIn.Allow' => array ( 'field_data' => array ( 'field' => 'Garden.SignIn.Allow', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Add' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Edit' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Delete' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Users.Approve' => array ( 'field_data' => array ( 'field' => 'Garden.Users.Approve', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Activity.Delete' => array ( 'field_data' => array ( 'field' => 'Garden.Activity.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Activity.View' => array ( 'field_data' => array ( 'field' => 'Garden.Activity.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Profiles.View' => array ( 'field_data' => array ( 'field' => 'Garden.Profiles.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Profiles.Edit' => array ( 'field_data' => array ( 'field' => 'Garden.Profiles.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Curation.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Curation.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Moderation.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Moderation.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.PersonalInfo.View' => array ( 'field_data' => array ( 'field' => 'Garden.PersonalInfo.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.AdvancedNotifications.Allow' => array ( 'field_data' => array ( 'field' => 'Garden.AdvancedNotifications.Allow', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Community.Manage' => array ( 'field_data' => array ( 'field' => 'Garden.Community.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Garden.Tokens.Add' => array ( 'field_data' => array ( 'field' => 'Garden.Tokens.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Tagging.Add' => array ( 'field_data' => array ( 'field' => 'Vanilla.Tagging.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Conversations.Moderation.Manage' => array ( 'field_data' => array ( 'field' => 'Conversations.Moderation.Manage', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Conversations.Conversations.Add' => array ( 'field_data' => array ( 'field' => 'Conversations.Conversations.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Approval.Require' => array ( 'field_data' => array ( 'field' => 'Vanilla.Approval.Require', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Me' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Me', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.View' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.View', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Add' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Edit' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Announce' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Announce', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Sink' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Sink', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Close' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Close', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Discussions.Delete' => array ( 'field_data' => array ( 'field' => 'Vanilla.Discussions.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Add' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Add', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Edit' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Edit', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Vanilla.Comments.Delete' => array ( 'field_data' => array ( 'field' => 'Vanilla.Comments.Delete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'PermissionID', ), 'GDN_Regarding' => array ( 'fields' => array ( 'RegardingID' => array ( 'field_data' => array ( 'field' => 'RegardingID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignType' => array ( 'field_data' => array ( 'field' => 'ForeignType', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignID' => array ( 'field_data' => array ( 'field' => 'ForeignID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'OriginalContent' => array ( 'field_data' => array ( 'field' => 'OriginalContent', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ParentType' => array ( 'field_data' => array ( 'field' => 'ParentType', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ParentID' => array ( 'field_data' => array ( 'field' => 'ParentID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ForeignURL' => array ( 'field_data' => array ( 'field' => 'ForeignURL', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Comment' => array ( 'field_data' => array ( 'field' => 'Comment', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Reports' => array ( 'field_data' => array ( 'field' => 'Reports', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'RegardingID', ), 'GDN_Role' => array ( 'fields' => array ( 'RoleID' => array ( 'field_data' => array ( 'field' => 'RoleID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Description' => array ( 'field_data' => array ( 'field' => 'Description', 'type' => 'varchar(500)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'enum(\'guest\',\'unconfirmed\',\'applicant\',\'member\',\'moderator\',\'administrator\')', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Sort' => array ( 'field_data' => array ( 'field' => 'Sort', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Deletable' => array ( 'field_data' => array ( 'field' => 'Deletable', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'CanSession' => array ( 'field_data' => array ( 'field' => 'CanSession', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'PersonalInfo' => array ( 'field_data' => array ( 'field' => 'PersonalInfo', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'RoleID', ), 'GDN_Session' => array ( 'fields' => array ( 'SessionID' => array ( 'field_data' => array ( 'field' => 'SessionID', 'type' => 'char(32)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateExpires' => array ( 'field_data' => array ( 'field' => 'DateExpires', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'SessionID', ), 'GDN_Spammer' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountSpam' => array ( 'field_data' => array ( 'field' => 'CountSpam', 'type' => 'smallint(5) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountDeletedSpam' => array ( 'field_data' => array ( 'field' => 'CountDeletedSpam', 'type' => 'smallint(5) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_Tag' => array ( 'fields' => array ( 'TagID' => array ( 'field_data' => array ( 'field' => 'TagID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'FullName' => array ( 'field_data' => array ( 'field' => 'FullName', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Type' => array ( 'field_data' => array ( 'field' => 'Type', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => 'MUL', 'default' => '', 'extra' => '', ), 'escape_type' => 2, ), 'ParentTagID' => array ( 'field_data' => array ( 'field' => 'ParentTagID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '-1', 'extra' => '', ), 'escape_type' => 1, ), 'CountDiscussions' => array ( 'field_data' => array ( 'field' => 'CountDiscussions', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'TagID', ), 'GDN_TagDiscussion' => array ( 'fields' => array ( 'TagID' => array ( 'field_data' => array ( 'field' => 'TagID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'TagID', ), 'GDN_User' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Password' => array ( 'field_data' => array ( 'field' => 'Password', 'type' => 'varbinary(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'HashMethod' => array ( 'field_data' => array ( 'field' => 'HashMethod', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Photo' => array ( 'field_data' => array ( 'field' => 'Photo', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Title' => array ( 'field_data' => array ( 'field' => 'Title', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Location' => array ( 'field_data' => array ( 'field' => 'Location', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'About' => array ( 'field_data' => array ( 'field' => 'About', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Email' => array ( 'field_data' => array ( 'field' => 'Email', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ShowEmail' => array ( 'field_data' => array ( 'field' => 'ShowEmail', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Gender' => array ( 'field_data' => array ( 'field' => 'Gender', 'type' => 'enum(\'u\',\'m\',\'f\')', 'null' => 'NO', 'key' => '', 'default' => 'u', 'extra' => '', ), 'escape_type' => 2, ), 'CountVisits' => array ( 'field_data' => array ( 'field' => 'CountVisits', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountInvitations' => array ( 'field_data' => array ( 'field' => 'CountInvitations', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountNotifications' => array ( 'field_data' => array ( 'field' => 'CountNotifications', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'InviteUserID' => array ( 'field_data' => array ( 'field' => 'InviteUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DiscoveryText' => array ( 'field_data' => array ( 'field' => 'DiscoveryText', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Preferences' => array ( 'field_data' => array ( 'field' => 'Preferences', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Permissions' => array ( 'field_data' => array ( 'field' => 'Permissions', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateSetInvitations' => array ( 'field_data' => array ( 'field' => 'DateSetInvitations', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateOfBirth' => array ( 'field_data' => array ( 'field' => 'DateOfBirth', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateFirstVisit' => array ( 'field_data' => array ( 'field' => 'DateFirstVisit', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateLastActive' => array ( 'field_data' => array ( 'field' => 'DateLastActive', 'type' => 'datetime', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'LastIPAddress' => array ( 'field_data' => array ( 'field' => 'LastIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertIPAddress' => array ( 'field_data' => array ( 'field' => 'InsertIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateIPAddress' => array ( 'field_data' => array ( 'field' => 'UpdateIPAddress', 'type' => 'varbinary(16)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'HourOffset' => array ( 'field_data' => array ( 'field' => 'HourOffset', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Admin' => array ( 'field_data' => array ( 'field' => 'Admin', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Confirmed' => array ( 'field_data' => array ( 'field' => 'Confirmed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'Verified' => array ( 'field_data' => array ( 'field' => 'Verified', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Banned' => array ( 'field_data' => array ( 'field' => 'Banned', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Deleted' => array ( 'field_data' => array ( 'field' => 'Deleted', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Points' => array ( 'field_data' => array ( 'field' => 'Points', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'CountUnreadConversations' => array ( 'field_data' => array ( 'field' => 'CountUnreadConversations', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountDiscussions' => array ( 'field_data' => array ( 'field' => 'CountDiscussions', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountUnreadDiscussions' => array ( 'field_data' => array ( 'field' => 'CountUnreadDiscussions', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountComments' => array ( 'field_data' => array ( 'field' => 'CountComments', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountDrafts' => array ( 'field_data' => array ( 'field' => 'CountDrafts', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountBookmarks' => array ( 'field_data' => array ( 'field' => 'CountBookmarks', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_UserAuthentication' => array ( 'fields' => array ( 'ForeignUserKey' => array ( 'field_data' => array ( 'field' => 'ForeignUserKey', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ProviderKey' => array ( 'field_data' => array ( 'field' => 'ProviderKey', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'ForeignUserKey', ), 'GDN_UserAuthenticationNonce' => array ( 'fields' => array ( 'Nonce' => array ( 'field_data' => array ( 'field' => 'Nonce', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Token' => array ( 'field_data' => array ( 'field' => 'Token', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Timestamp' => array ( 'field_data' => array ( 'field' => 'Timestamp', 'type' => 'timestamp', 'null' => 'NO', 'key' => 'MUL', 'default' => 'current_timestamp()', 'extra' => 'on update current_timestamp()', ), 'escape_type' => 2, ), ), 'primary_key' => 'Nonce', ), 'GDN_UserAuthenticationProvider' => array ( 'fields' => array ( 'AuthenticationKey' => array ( 'field_data' => array ( 'field' => 'AuthenticationKey', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AuthenticationSchemeAlias' => array ( 'field_data' => array ( 'field' => 'AuthenticationSchemeAlias', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(50)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'URL' => array ( 'field_data' => array ( 'field' => 'URL', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AssociationSecret' => array ( 'field_data' => array ( 'field' => 'AssociationSecret', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AssociationHashMethod' => array ( 'field_data' => array ( 'field' => 'AssociationHashMethod', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'AuthenticateUrl' => array ( 'field_data' => array ( 'field' => 'AuthenticateUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RegisterUrl' => array ( 'field_data' => array ( 'field' => 'RegisterUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'SignInUrl' => array ( 'field_data' => array ( 'field' => 'SignInUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'SignOutUrl' => array ( 'field_data' => array ( 'field' => 'SignOutUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'PasswordUrl' => array ( 'field_data' => array ( 'field' => 'PasswordUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ProfileUrl' => array ( 'field_data' => array ( 'field' => 'ProfileUrl', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Active' => array ( 'field_data' => array ( 'field' => 'Active', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'IsDefault' => array ( 'field_data' => array ( 'field' => 'IsDefault', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'AuthenticationKey', ), 'GDN_UserAuthenticationToken' => array ( 'fields' => array ( 'Token' => array ( 'field_data' => array ( 'field' => 'Token', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ProviderKey' => array ( 'field_data' => array ( 'field' => 'ProviderKey', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'ForeignUserKey' => array ( 'field_data' => array ( 'field' => 'ForeignUserKey', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TokenSecret' => array ( 'field_data' => array ( 'field' => 'TokenSecret', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TokenType' => array ( 'field_data' => array ( 'field' => 'TokenType', 'type' => 'enum(\'request\',\'access\')', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Authorized' => array ( 'field_data' => array ( 'field' => 'Authorized', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Timestamp' => array ( 'field_data' => array ( 'field' => 'Timestamp', 'type' => 'timestamp', 'null' => 'NO', 'key' => 'MUL', 'default' => 'current_timestamp()', 'extra' => 'on update current_timestamp()', ), 'escape_type' => 2, ), 'Lifetime' => array ( 'field_data' => array ( 'field' => 'Lifetime', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'Token', ), 'GDN_UserCategory' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateMarkedRead' => array ( 'field_data' => array ( 'field' => 'DateMarkedRead', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Followed' => array ( 'field_data' => array ( 'field' => 'Followed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Unfollow' => array ( 'field_data' => array ( 'field' => 'Unfollow', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_UserComment' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CommentID' => array ( 'field_data' => array ( 'field' => 'CommentID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateLastViewed' => array ( 'field_data' => array ( 'field' => 'DateLastViewed', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserConversation' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ConversationID' => array ( 'field_data' => array ( 'field' => 'ConversationID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'CountReadMessages' => array ( 'field_data' => array ( 'field' => 'CountReadMessages', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'LastMessageID' => array ( 'field_data' => array ( 'field' => 'LastMessageID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateLastViewed' => array ( 'field_data' => array ( 'field' => 'DateLastViewed', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateCleared' => array ( 'field_data' => array ( 'field' => 'DateCleared', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Bookmarked' => array ( 'field_data' => array ( 'field' => 'Bookmarked', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Deleted' => array ( 'field_data' => array ( 'field' => 'Deleted', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateConversationUpdated' => array ( 'field_data' => array ( 'field' => 'DateConversationUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserDiscussion' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DiscussionID' => array ( 'field_data' => array ( 'field' => 'DiscussionID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Score' => array ( 'field_data' => array ( 'field' => 'Score', 'type' => 'float', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'CountComments' => array ( 'field_data' => array ( 'field' => 'CountComments', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'DateLastViewed' => array ( 'field_data' => array ( 'field' => 'DateLastViewed', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Dismissed' => array ( 'field_data' => array ( 'field' => 'Dismissed', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Bookmarked' => array ( 'field_data' => array ( 'field' => 'Bookmarked', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'Participated' => array ( 'field_data' => array ( 'field' => 'Participated', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'GDN_UserIP' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'IPAddress' => array ( 'field_data' => array ( 'field' => 'IPAddress', 'type' => 'varbinary(16)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserMerge' => array ( 'fields' => array ( 'MergeID' => array ( 'field_data' => array ( 'field' => 'MergeID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'OldUserID' => array ( 'field_data' => array ( 'field' => 'OldUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'NewUserID' => array ( 'field_data' => array ( 'field' => 'NewUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateInserted' => array ( 'field_data' => array ( 'field' => 'DateInserted', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'InsertUserID' => array ( 'field_data' => array ( 'field' => 'InsertUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'DateUpdated' => array ( 'field_data' => array ( 'field' => 'DateUpdated', 'type' => 'datetime', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'UpdateUserID' => array ( 'field_data' => array ( 'field' => 'UpdateUserID', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Attributes' => array ( 'field_data' => array ( 'field' => 'Attributes', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'MergeID', ), 'GDN_UserMergeItem' => array ( 'fields' => array ( 'MergeID' => array ( 'field_data' => array ( 'field' => 'MergeID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Table' => array ( 'field_data' => array ( 'field' => 'Table', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Column' => array ( 'field_data' => array ( 'field' => 'Column', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'RecordID' => array ( 'field_data' => array ( 'field' => 'RecordID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'OldUserID' => array ( 'field_data' => array ( 'field' => 'OldUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'NewUserID' => array ( 'field_data' => array ( 'field' => 'NewUserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'GDN_UserMeta' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Name' => array ( 'field_data' => array ( 'field' => 'Name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Value' => array ( 'field_data' => array ( 'field' => 'Value', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'UserID', ), 'GDN_UserPoints' => array ( 'fields' => array ( 'SlotType' => array ( 'field_data' => array ( 'field' => 'SlotType', 'type' => 'enum(\'d\',\'w\',\'m\',\'y\',\'a\')', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'TimeSlot' => array ( 'field_data' => array ( 'field' => 'TimeSlot', 'type' => 'datetime', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'Source' => array ( 'field_data' => array ( 'field' => 'Source', 'type' => 'varchar(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => 'Total', 'extra' => '', ), 'escape_type' => 2, ), 'CategoryID' => array ( 'field_data' => array ( 'field' => 'CategoryID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'Points' => array ( 'field_data' => array ( 'field' => 'Points', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'SlotType', ), 'GDN_UserRole' => array ( 'fields' => array ( 'UserID' => array ( 'field_data' => array ( 'field' => 'UserID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'RoleID' => array ( 'field_data' => array ( 'field' => 'RoleID', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'UserID', ), 'average_ratings' => array ( 'fields' => array ( 'ep_combo_id' => array ( 'field_data' => array ( 'field' => 'ep_combo_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'average_rating' => array ( 'field_data' => array ( 'field' => 'average_rating', 'type' => 'decimal(7,4)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => NULL, ), 'click_outs' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_type' => array ( 'field_data' => array ( 'field' => 'data_type', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'ip' => array ( 'field_data' => array ( 'field' => 'ip', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'comments_vanilla_connect' => array ( 'fields' => array ( 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_comment_id' => array ( 'field_data' => array ( 'field' => 'vanilla_comment_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'comments_vanilla_votes' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_comment_id' => array ( 'field_data' => array ( 'field' => 'vanilla_comment_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'vote' => array ( 'field_data' => array ( 'field' => 'vote', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'delete_it' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'discussion_vanilla_votes' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_discussion_id' => array ( 'field_data' => array ( 'field' => 'vanilla_discussion_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'vote' => array ( 'field_data' => array ( 'field' => 'vote', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'discussions_vanilla_connect' => array ( 'fields' => array ( 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_discussion_id' => array ( 'field_data' => array ( 'field' => 'vanilla_discussion_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'vanilla_discussion_id', ), 'experiment_bookmarks' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_option_id' => array ( 'field_data' => array ( 'field' => 'experiment_option_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'experiment_circle' => array ( 'fields' => array ( 'experiment_circle_id' => array ( 'field_data' => array ( 'field' => 'experiment_circle_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'experiment_circle_id', ), 'experiment_circleBAK' => array ( 'fields' => array ( 'experiment_circle_id' => array ( 'field_data' => array ( 'field' => 'experiment_circle_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'experiment_circle_id', ), 'experiment_combos' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'experiment_option_id' => array ( 'field_data' => array ( 'field' => 'experiment_option_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'link_to_combo_id' => array ( 'field_data' => array ( 'field' => 'link_to_combo_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'product_id' => array ( 'field_data' => array ( 'field' => 'product_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'author_email' => array ( 'field_data' => array ( 'field' => 'author_email', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'author_pubmed_url' => array ( 'field_data' => array ( 'field' => 'author_pubmed_url', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'publication_status' => array ( 'field_data' => array ( 'field' => 'publication_status', 'type' => 'int(1) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'tips_upstream' => array ( 'field_data' => array ( 'field' => 'tips_upstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'tips_protocol' => array ( 'field_data' => array ( 'field' => 'tips_protocol', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'tips_downstream' => array ( 'field_data' => array ( 'field' => 'tips_downstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'publication_protocol' => array ( 'field_data' => array ( 'field' => 'publication_protocol', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'youtube_video_id' => array ( 'field_data' => array ( 'field' => 'youtube_video_id', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'exclude_product_youtube_video_id' => array ( 'field_data' => array ( 'field' => 'exclude_product_youtube_video_id', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'experiment_endpoints' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'experiment_endpoints_bak' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'experiment_endpoints_bak2' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => '0', 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'experiment_options' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_id' => array ( 'field_data' => array ( 'field' => 'experiment_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'parent_id' => array ( 'field_data' => array ( 'field' => 'parent_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'alt_step_title' => array ( 'field_data' => array ( 'field' => 'alt_step_title', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'alt_subtype_label' => array ( 'field_data' => array ( 'field' => 'alt_subtype_label', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'order' => array ( 'field_data' => array ( 'field' => 'order', 'type' => 'tinyint(4)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => 'MUL', 'default' => 'active', 'extra' => '', ), 'escape_type' => 2, ), 'experiment_challenge' => array ( 'field_data' => array ( 'field' => 'experiment_challenge', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'experiment_questions' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_id' => array ( 'field_data' => array ( 'field' => 'experiment_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'order' => array ( 'field_data' => array ( 'field' => 'order', 'type' => 'tinyint(4)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'experiment_suggestions' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_email' => array ( 'field_data' => array ( 'field' => 'suggester_email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_name' => array ( 'field_data' => array ( 'field' => 'suggester_name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'experiment_titles' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'experiments' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'step_titles' => array ( 'field_data' => array ( 'field' => 'step_titles', 'type' => 'varchar(2048)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'active' => array ( 'field_data' => array ( 'field' => 'active', 'type' => 'tinyint(3) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'launch_leads' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'experiment' => array ( 'field_data' => array ( 'field' => 'experiment', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pubmed_links' => array ( 'field_data' => array ( 'field' => 'pubmed_links', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'login_history' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'manufacturers' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'bio' => array ( 'field_data' => array ( 'field' => 'bio', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'website' => array ( 'field_data' => array ( 'field' => 'website', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'missed_searches' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'search' => array ( 'field_data' => array ( 'field' => 'search', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'notifications' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'enum(\'1\',\'2\')', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 2, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'secondary_user_id' => array ( 'field_data' => array ( 'field' => 'secondary_user_id', 'type' => 'int(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'secondary_item_id' => array ( 'field_data' => array ( 'field' => 'secondary_item_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'system_code' => array ( 'field_data' => array ( 'field' => 'system_code', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'description' => array ( 'field_data' => array ( 'field' => 'description', 'type' => 'varchar(1024)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'url' => array ( 'field_data' => array ( 'field' => 'url', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'mail_status' => array ( 'field_data' => array ( 'field' => 'mail_status', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'product_categories' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(64)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'products' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'category_id' => array ( 'field_data' => array ( 'field' => 'category_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'manufacturer_id' => array ( 'field_data' => array ( 'field' => 'manufacturer_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'website' => array ( 'field_data' => array ( 'field' => 'website', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_email' => array ( 'field_data' => array ( 'field' => 'suggester_email', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'suggester_name' => array ( 'field_data' => array ( 'field' => 'suggester_name', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => 'active', 'extra' => '', ), 'escape_type' => 2, ), 'youtube_video_id_product' => array ( 'field_data' => array ( 'field' => 'youtube_video_id_product', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'external_product_id' => array ( 'field_data' => array ( 'field' => 'external_product_id', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'deeplink_url' => array ( 'field_data' => array ( 'field' => 'deeplink_url', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'publications' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'experiment_combo_id' => array ( 'field_data' => array ( 'field' => 'experiment_combo_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'url' => array ( 'field_data' => array ( 'field' => 'url', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'title' => array ( 'field_data' => array ( 'field' => 'title', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'abstract' => array ( 'field_data' => array ( 'field' => 'abstract', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'materials_and_methods' => array ( 'field_data' => array ( 'field' => 'materials_and_methods', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'author_1' => array ( 'field_data' => array ( 'field' => 'author_1', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'raw_xml' => array ( 'field_data' => array ( 'field' => 'raw_xml', 'type' => 'mediumtext', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'registrations' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'password' => array ( 'field_data' => array ( 'field' => 'password', 'type' => 'varchar(128)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'rank' => array ( 'field_data' => array ( 'field' => 'rank', 'type' => 'varchar(64)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'first_name' => array ( 'field_data' => array ( 'field' => 'first_name', 'type' => 'varchar(64)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'last_name' => array ( 'field_data' => array ( 'field' => 'last_name', 'type' => 'varchar(64)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'activation_hash' => array ( 'field_data' => array ( 'field' => 'activation_hash', 'type' => 'varchar(41)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'review_discussions' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'review_id' => array ( 'field_data' => array ( 'field' => 'review_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'message' => array ( 'field_data' => array ( 'field' => 'message', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'review_products' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'review_id' => array ( 'field_data' => array ( 'field' => 'review_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'product_id' => array ( 'field_data' => array ( 'field' => 'product_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol' => array ( 'field_data' => array ( 'field' => 'protocol', 'type' => 'varchar(10)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjustment' => array ( 'field_data' => array ( 'field' => 'protocol_adjustment', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjusted_upstream' => array ( 'field_data' => array ( 'field' => 'protocol_adjusted_upstream', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol_details_upstream' => array ( 'field_data' => array ( 'field' => 'protocol_details_upstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjusted_protocol' => array ( 'field_data' => array ( 'field' => 'protocol_adjusted_protocol', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol_details_protocol' => array ( 'field_data' => array ( 'field' => 'protocol_details_protocol', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_adjusted_downstream' => array ( 'field_data' => array ( 'field' => 'protocol_adjusted_downstream', 'type' => 'tinyint(1)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'protocol_details_downstream' => array ( 'field_data' => array ( 'field' => 'protocol_details_downstream', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'protocol_desc' => array ( 'field_data' => array ( 'field' => 'protocol_desc', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'comments' => array ( 'field_data' => array ( 'field' => 'comments', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_friendly' => array ( 'field_data' => array ( 'field' => 'user_friendly', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'time' => array ( 'field_data' => array ( 'field' => 'time', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'quality' => array ( 'field_data' => array ( 'field' => 'quality', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'pro_1' => array ( 'field_data' => array ( 'field' => 'pro_1', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pro_2' => array ( 'field_data' => array ( 'field' => 'pro_2', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pro_3' => array ( 'field_data' => array ( 'field' => 'pro_3', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'con_1' => array ( 'field_data' => array ( 'field' => 'con_1', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'con_2' => array ( 'field_data' => array ( 'field' => 'con_2', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'con_3' => array ( 'field_data' => array ( 'field' => 'con_3', 'type' => 'varchar(100)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'recommend' => array ( 'field_data' => array ( 'field' => 'recommend', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => 'id', ), 'review_ratings' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'review_id' => array ( 'field_data' => array ( 'field' => 'review_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'rating_complete' => array ( 'field_data' => array ( 'field' => 'rating_complete', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'rating_product' => array ( 'field_data' => array ( 'field' => 'rating_product', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'rating_explanation' => array ( 'field_data' => array ( 'field' => 'rating_explanation', 'type' => 'tinyint(4)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'reviews' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'experiment_endpoint_id' => array ( 'field_data' => array ( 'field' => 'experiment_endpoint_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'ep_combo_id' => array ( 'field_data' => array ( 'field' => 'ep_combo_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'additional_info' => array ( 'field_data' => array ( 'field' => 'additional_info', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'pubmed_link' => array ( 'field_data' => array ( 'field' => 'pubmed_link', 'type' => 'tinytext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(20)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'scientific_name' => array ( 'field_data' => array ( 'field' => 'scientific_name', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email_address' => array ( 'field_data' => array ( 'field' => 'email_address', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'root_tables' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'options' => array ( 'field_data' => array ( 'field' => 'options', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'synonyms' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'type' => array ( 'field_data' => array ( 'field' => 'type', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'word' => array ( 'field_data' => array ( 'field' => 'word', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'synonym' => array ( 'field_data' => array ( 'field' => 'synonym', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'system_history' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'system_code' => array ( 'field_data' => array ( 'field' => 'system_code', 'type' => 'varchar(32)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'description' => array ( 'field_data' => array ( 'field' => 'description', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'test' => array ( 'fields' => array ( 'a' => array ( 'field_data' => array ( 'field' => 'a', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'b' => array ( 'field_data' => array ( 'field' => 'b', 'type' => 'int(11)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), ), 'primary_key' => NULL, ), 'user_activity' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'data_type' => array ( 'field_data' => array ( 'field' => 'data_type', 'type' => 'varchar(20)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'data_id' => array ( 'field_data' => array ( 'field' => 'data_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'ip' => array ( 'field_data' => array ( 'field' => 'ip', 'type' => 'varchar(30)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'user_connections' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'user_connection_id' => array ( 'field_data' => array ( 'field' => 'user_connection_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'type' => array ( 'field_data' => array ( 'field' => 'type', 'type' => 'tinyint(1)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'tinyint(1)', 'null' => 'NO', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'user_profiles' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(11)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(11)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'oauth_provider' => array ( 'field_data' => array ( 'field' => 'oauth_provider', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'oauth_uid' => array ( 'field_data' => array ( 'field' => 'oauth_uid', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'scientific_name' => array ( 'field_data' => array ( 'field' => 'scientific_name', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'fname' => array ( 'field_data' => array ( 'field' => 'fname', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'lname' => array ( 'field_data' => array ( 'field' => 'lname', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'location' => array ( 'field_data' => array ( 'field' => 'location', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'country' => array ( 'field_data' => array ( 'field' => 'country', 'type' => 'varchar(50)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'picture_url' => array ( 'field_data' => array ( 'field' => 'picture_url', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'profile_url' => array ( 'field_data' => array ( 'field' => 'profile_url', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'function_title' => array ( 'field_data' => array ( 'field' => 'function_title', 'type' => 'varchar(200)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'company' => array ( 'field_data' => array ( 'field' => 'company', 'type' => 'varchar(200)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'bio' => array ( 'field_data' => array ( 'field' => 'bio', 'type' => 'mediumtext', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_type' => array ( 'field_data' => array ( 'field' => 'user_type', 'type' => 'varchar(10)', 'null' => 'YES', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_institution' => array ( 'field_data' => array ( 'field' => 'user_institution', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_department' => array ( 'field_data' => array ( 'field' => 'user_department', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_company' => array ( 'field_data' => array ( 'field' => 'user_company', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_division' => array ( 'field_data' => array ( 'field' => 'user_division', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'user_position' => array ( 'field_data' => array ( 'field' => 'user_position', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'modified' => array ( 'field_data' => array ( 'field' => 'modified', 'type' => 'datetime', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'email_discussion' => array ( 'field_data' => array ( 'field' => 'email_discussion', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'email_circle' => array ( 'field_data' => array ( 'field' => 'email_circle', 'type' => 'tinyint(1) unsigned', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 1, ), 'linkedin_url' => array ( 'field_data' => array ( 'field' => 'linkedin_url', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'expertise_experiment_id' => array ( 'field_data' => array ( 'field' => 'expertise_experiment_id', 'type' => 'int(10) unsigned', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'pubmed_links' => array ( 'field_data' => array ( 'field' => 'pubmed_links', 'type' => 'text', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'salt_1' => array ( 'field_data' => array ( 'field' => 'salt_1', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'salt_2' => array ( 'field_data' => array ( 'field' => 'salt_2', 'type' => 'varchar(255)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'user_status_updates' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'user_id' => array ( 'field_data' => array ( 'field' => 'user_id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'MUL', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'content' => array ( 'field_data' => array ( 'field' => 'content', 'type' => 'text', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'NO', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'users' => array ( 'fields' => array ( 'id' => array ( 'field_data' => array ( 'field' => 'id', 'type' => 'int(10) unsigned', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => 'auto_increment', ), 'escape_type' => 1, ), 'created' => array ( 'field_data' => array ( 'field' => 'created', 'type' => 'timestamp', 'null' => 'YES', 'key' => '', 'default' => 'current_timestamp()', 'extra' => '', ), 'escape_type' => 2, ), 'status' => array ( 'field_data' => array ( 'field' => 'status', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => '', 'default' => 'active', 'extra' => '', ), 'escape_type' => 2, ), 'registration_status' => array ( 'field_data' => array ( 'field' => 'registration_status', 'type' => 'enum(\'1\',\'2\')', 'null' => 'YES', 'key' => '', 'default' => '1', 'extra' => '', ), 'escape_type' => 2, ), 'email' => array ( 'field_data' => array ( 'field' => 'email', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'password' => array ( 'field_data' => array ( 'field' => 'password', 'type' => 'varchar(255)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'rank' => array ( 'field_data' => array ( 'field' => 'rank', 'type' => 'varchar(32)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), 'name' => array ( 'field_data' => array ( 'field' => 'name', 'type' => 'varchar(128)', 'null' => 'YES', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'id', ), 'users_vanilla_connect' => array ( 'fields' => array ( 'labettor_user_id' => array ( 'field_data' => array ( 'field' => 'labettor_user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'PRI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_user_id' => array ( 'field_data' => array ( 'field' => 'vanilla_user_id', 'type' => 'int(10)', 'null' => 'NO', 'key' => 'UNI', 'default' => NULL, 'extra' => '', ), 'escape_type' => 1, ), 'vanilla_access_token' => array ( 'field_data' => array ( 'field' => 'vanilla_access_token', 'type' => 'varchar(100)', 'null' => 'NO', 'key' => '', 'default' => NULL, 'extra' => '', ), 'escape_type' => 2, ), ), 'primary_key' => 'labettor_user_id', ), );

ChIP acH3 Rat Canine

- Found 2437 results

Rat Adiponectin ELISA Kit (ab108784) Product

Get tips on using Rat Adiponectin ELISA Kit (ab108784) to perform ELISA Rat - Adiponectin

Products Abcam Rat Adiponectin ELISA Kit (ab108784)

Rat Transferrin ELISA Kit (ab137993) Product

Get tips on using Rat Transferrin ELISA Kit (ab137993) to perform ELISA Rat - Transferrin (Tf)

Products Abcam Rat Transferrin ELISA Kit (ab137993)

Rat Transferrin ELISA Kit (Colorimetric) Product

Get tips on using Rat Transferrin ELISA Kit (Colorimetric) to perform ELISA Rat - Transferrin (Tf)

Products Novus Biologicals Rat Transferrin ELISA Kit (Colorimetric)

Rat beta-NGF DuoSet ELISA Product

Get tips on using Rat beta-NGF DuoSet ELISA to perform ELISA Rat - beta-NGF

Products R&D Systems Rat beta-NGF DuoSet ELISA

HO-1 (rat), ELISA kit Product

Get tips on using HO-1 (rat), ELISA kit to perform ELISA Rat - HO-1

Products Enzo Life Sciences HO-1 (rat), ELISA kit

SimpleChIP® Plus Enzymatic Chromatin IP Kit (Magnetic Beads) #9005 Product

Get tips on using SimpleChIP® Plus Enzymatic Chromatin IP Kit (Magnetic Beads) #9005 to perform ChIP Rat - Mesenteric arteries

Products Cell Signaling Technology SimpleChIP® Plus Enzymatic Chromatin IP Kit (Magnetic Beads) #9005

Site Directed Mutagenesis (SDM) Rat - Point mutation Rat-2 MMP-9 promoter Experiment

Site-directed mutagenesis (SDM) can be challenging, particularly during detection/confirmation of (SDM) in colonies by sequencing or PCR techniques. This common issue in SDM is heavily relying on designing of mutagenic primer pairs. The best solution is to design the mutagenic primers that have extended 3'-ends/3'-overhang. This would provide the annealing region between the mutagenic primer pair is essentially shorter. and hence ensure a lower annealing temperature for the primer pair along with a higher chance of annealing to the template.

DNA Site Directed Mutagenesis (SDM) Rat Point mutation Rat-2 MMP-9 promoter

ON-TARGETplus Rat Fyn siRNA Product

Get tips on using ON-TARGETplus Rat Fyn siRNA to perform siRNA / miRNA gene silencing Rat - Schwann cells Fyn

Products Dharmacon ON-TARGETplus Rat Fyn siRNA

siGENOME Rat Gata1 (25172) siRNA - SMARTpool Product

Get tips on using siGENOME Rat Gata1 (25172) siRNA - SMARTpool to perform siRNA / miRNA gene silencing Rat - C6 (rat glioma) Gata1

Products Horizon Discovery Ltd. siGENOME Rat Gata1 (25172) siRNA - SMARTpool

Immunohistochemistry Rat - Experiment

Proteins Immunohistochemistry Rat

Outsource your experiment

Fill out your contact details and receive price quotes in your Inbox

Outsource experiment

Become shareholder Discussions About us Contact Privacy Terms