Created
July 29, 2016 11:02
-
-
Save 3355844/f9ab6f9a739fc834aa566330fda81220 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UserProgect |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="ArtifactManager"> | |
<artifact type="exploded-war" name="UserProgect:war exploded"> | |
<output-path>$PROJECT_DIR$/out/artifacts/UserProgect_war_exploded</output-path> | |
<root id="root"> | |
<element id="directory" name="WEB-INF"> | |
<element id="directory" name="classes"> | |
<element id="module-output" name="UserProgect" /> | |
</element> | |
<element id="directory" name="lib"> | |
<element id="library" level="project" name="jstl:jstl:1.2" /> | |
</element> | |
</element> | |
<element id="javaee-facet-resources" facet="UserProgect/web/Web" /> | |
</root> | |
</artifact> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="CompilerConfiguration"> | |
<resourceExtensions /> | |
<wildcardResourcePatterns> | |
<entry name="!?*.java" /> | |
<entry name="!?*.form" /> | |
<entry name="!?*.class" /> | |
<entry name="!?*.groovy" /> | |
<entry name="!?*.scala" /> | |
<entry name="!?*.flex" /> | |
<entry name="!?*.kt" /> | |
<entry name="!?*.clj" /> | |
<entry name="!?*.aj" /> | |
</wildcardResourcePatterns> | |
<annotationProcessing> | |
<profile default="true" name="Default" enabled="false"> | |
<processorPath useClasspath="true" /> | |
</profile> | |
<profile default="false" name="Annotation profile for UserProgect" enabled="true"> | |
<sourceOutputDir name="target/generated-sources/annotations" /> | |
<sourceTestOutputDir name="target\generated-test-sources\test-annotations" /> | |
<outputRelativeToContentRoot value="true" /> | |
<processorPath useClasspath="true" /> | |
<module name="UserProgect" /> | |
</profile> | |
</annotationProcessing> | |
<bytecodeTargetLevel> | |
<module name="UserProgect" target="1.7" /> | |
</bytecodeTargetLevel> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="CopyrightManager"> | |
<settings default="" /> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<component name="dataSourceStorage"> | |
<data-source name="MySQL - @localhost [2]" uuid="e10a677f-a0d6-45ec-a73e-acfa35c74480"> | |
<database-info product="MySQL" version="5.7.13-log" jdbc-version="4.0" driver-name="MySQL Connector Java" driver-version="mysql-connector-java-5.1.35 ( Revision: 5fb9c5849535c13917c2cf9baaece6ef9693ef27 )"> | |
<extra-name-characters>#@</extra-name-characters> | |
<identifier-quote-string>`</identifier-quote-string> | |
</database-info> | |
<case-sensitivity plain-identifiers="lower" quoted-identifiers="lower"/> | |
<database-model serializer="dbm" rdbms="MYSQL" format-version="2.2"> | |
<schema id="1" name="mysql"/> | |
<table id="2" parent="1" name="columns_priv"/> | |
<table id="3" parent="1" name="db"/> | |
<table id="4" parent="1" name="engine_cost"/> | |
<table id="5" parent="1" name="event"/> | |
<table id="6" parent="1" name="func"/> | |
<table id="7" parent="1" name="general_log"/> | |
<table id="8" parent="1" name="gtid_executed"/> | |
<table id="9" parent="1" name="help_category"/> | |
<table id="10" parent="1" name="help_keyword"/> | |
<table id="11" parent="1" name="help_relation"/> | |
<table id="12" parent="1" name="help_topic"/> | |
<table id="13" parent="1" name="innodb_index_stats"/> | |
<table id="14" parent="1" name="innodb_table_stats"/> | |
<table id="15" parent="1" name="ndb_binlog_index"/> | |
<table id="16" parent="1" name="plugin"/> | |
<table id="17" parent="1" name="proc"/> | |
<table id="18" parent="1" name="procs_priv"/> | |
<table id="19" parent="1" name="proxies_priv"/> | |
<table id="20" parent="1" name="server_cost"/> | |
<table id="21" parent="1" name="servers"/> | |
<table id="22" parent="1" name="slave_master_info"/> | |
<table id="23" parent="1" name="slave_relay_log_info"/> | |
<table id="24" parent="1" name="slave_worker_info"/> | |
<table id="25" parent="1" name="slow_log"/> | |
<table id="26" parent="1" name="tables_priv"/> | |
<table id="27" parent="1" name="time_zone"/> | |
<table id="28" parent="1" name="time_zone_leap_second"/> | |
<table id="29" parent="1" name="time_zone_name"/> | |
<table id="30" parent="1" name="time_zone_transition"/> | |
<table id="31" parent="1" name="time_zone_transition_type"/> | |
<table id="32" parent="1" name="user"/> | |
<column id="33" parent="2" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="34" parent="2" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="35" parent="2" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="36" parent="2" name="Table_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="37" parent="2" name="Column_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="38" parent="2" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="39" parent="2" name="Column_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Select', 'Insert', 'Update', 'References')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="40" parent="2" name="PRIMARY"> | |
<columns>Host | |
Db | |
User | |
Table_name | |
Column_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="41" parent="3" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="42" parent="3" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="43" parent="3" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="44" parent="3" name="Select_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="45" parent="3" name="Insert_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="46" parent="3" name="Update_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="47" parent="3" name="Delete_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="48" parent="3" name="Create_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="49" parent="3" name="Drop_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="50" parent="3" name="Grant_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="51" parent="3" name="References_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="52" parent="3" name="Index_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="53" parent="3" name="Alter_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="54" parent="3" name="Create_tmp_table_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="55" parent="3" name="Lock_tables_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="56" parent="3" name="Create_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="57" parent="3" name="Show_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="58" parent="3" name="Create_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="59" parent="3" name="Alter_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="60" parent="3" name="Execute_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="61" parent="3" name="Event_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="62" parent="3" name="Trigger_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<key id="63" parent="3" name="PRIMARY"> | |
<columns>Host | |
Db | |
User</columns> | |
<primary>1</primary> | |
</key> | |
<column id="64" parent="4" name="engine_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="65" parent="4" name="device_type"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="66" parent="4" name="cost_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="67" parent="4" name="cost_value"> | |
<data-type>float</data-type> | |
</column> | |
<column id="68" parent="4" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="69" parent="4" name="comment"> | |
<data-type>varchar(1024)</data-type> | |
</column> | |
<key id="70" parent="4" name="PRIMARY"> | |
<columns>cost_name | |
engine_name | |
device_type</columns> | |
<primary>1</primary> | |
</key> | |
<column id="71" parent="5" name="db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="72" parent="5" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="73" parent="5" name="body"> | |
<mandatory>1</mandatory> | |
<data-type>longblob</data-type> | |
</column> | |
<column id="74" parent="5" name="definer"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="75" parent="5" name="execute_at"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="76" parent="5" name="interval_value"> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="77" parent="5" name="interval_field"> | |
<data-type>enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')</data-type> | |
</column> | |
<column id="78" parent="5" name="created"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="79" parent="5" name="modified"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'0000-00-00 00:00:00'</default-expression> | |
</column> | |
<column id="80" parent="5" name="last_executed"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="81" parent="5" name="starts"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="82" parent="5" name="ends"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="83" parent="5" name="status"> | |
<mandatory>1</mandatory> | |
<data-type>enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')</data-type> | |
<default-expression>'ENABLED'</default-expression> | |
</column> | |
<column id="84" parent="5" name="on_completion"> | |
<mandatory>1</mandatory> | |
<data-type>enum('DROP', 'PRESERVE')</data-type> | |
<default-expression>'DROP'</default-expression> | |
</column> | |
<column id="85" parent="5" name="sql_mode"> | |
<mandatory>1</mandatory> | |
<data-type>set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="86" parent="5" name="comment"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="87" parent="5" name="originator"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="88" parent="5" name="time_zone"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>'SYSTEM'</default-expression> | |
</column> | |
<column id="89" parent="5" name="character_set_client"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="90" parent="5" name="collation_connection"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="91" parent="5" name="db_collation"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="92" parent="5" name="body_utf8"> | |
<data-type>longblob</data-type> | |
</column> | |
<key id="93" parent="5" name="PRIMARY"> | |
<columns>db | |
name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="94" parent="6" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="95" parent="6" name="ret"> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="96" parent="6" name="dl"> | |
<mandatory>1</mandatory> | |
<data-type>char(128)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="97" parent="6" name="type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('function', 'aggregate')</data-type> | |
</column> | |
<key id="98" parent="6" name="PRIMARY"> | |
<columns>name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="99" parent="7" name="event_time"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp(6)</data-type> | |
<default-expression>'CURRENT_TIMESTAMP(6)'</default-expression> | |
</column> | |
<column id="100" parent="7" name="user_host"> | |
<mandatory>1</mandatory> | |
<data-type>mediumtext</data-type> | |
</column> | |
<column id="101" parent="7" name="thread_id"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(21) unsigned</data-type> | |
</column> | |
<column id="102" parent="7" name="server_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="103" parent="7" name="command_type"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="104" parent="7" name="argument"> | |
<mandatory>1</mandatory> | |
<data-type>mediumblob</data-type> | |
</column> | |
<column id="105" parent="8" name="source_uuid"> | |
<comment>uuid of the source where the transaction was originally executed.</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(36)</data-type> | |
</column> | |
<column id="106" parent="8" name="interval_start"> | |
<comment>First number of interval.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<column id="107" parent="8" name="interval_end"> | |
<comment>Last number of interval.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<key id="108" parent="8" name="PRIMARY"> | |
<columns>source_uuid | |
interval_start</columns> | |
<primary>1</primary> | |
</key> | |
<column id="109" parent="9" name="help_category_id"> | |
<mandatory>1</mandatory> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="110" parent="9" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="111" parent="9" name="parent_category_id"> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="112" parent="9" name="url"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<index id="113" parent="9" name="name"> | |
<columns>name</columns> | |
<unique>1</unique> | |
</index> | |
<key id="114" parent="9" name="name"> | |
<columns>name</columns> | |
<underlying-index>name</underlying-index> | |
</key> | |
<key id="115" parent="9" name="PRIMARY"> | |
<columns>help_category_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="116" parent="10" name="help_keyword_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="117" parent="10" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<index id="118" parent="10" name="name"> | |
<columns>name</columns> | |
<unique>1</unique> | |
</index> | |
<key id="119" parent="10" name="name"> | |
<columns>name</columns> | |
<underlying-index>name</underlying-index> | |
</key> | |
<key id="120" parent="10" name="PRIMARY"> | |
<columns>help_keyword_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="121" parent="11" name="help_topic_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="122" parent="11" name="help_keyword_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<key id="123" parent="11" name="PRIMARY"> | |
<columns>help_keyword_id | |
help_topic_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="124" parent="12" name="help_topic_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="125" parent="12" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="126" parent="12" name="help_category_id"> | |
<mandatory>1</mandatory> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="127" parent="12" name="description"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="128" parent="12" name="example"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="129" parent="12" name="url"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<index id="130" parent="12" name="name"> | |
<columns>name</columns> | |
<unique>1</unique> | |
</index> | |
<key id="131" parent="12" name="name"> | |
<columns>name</columns> | |
<underlying-index>name</underlying-index> | |
</key> | |
<key id="132" parent="12" name="PRIMARY"> | |
<columns>help_topic_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="133" parent="13" name="database_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="134" parent="13" name="table_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="135" parent="13" name="index_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="136" parent="13" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="137" parent="13" name="stat_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="138" parent="13" name="stat_value"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="139" parent="13" name="sample_size"> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="140" parent="13" name="stat_description"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(1024)</data-type> | |
</column> | |
<key id="141" parent="13" name="PRIMARY"> | |
<columns>database_name | |
table_name | |
index_name | |
stat_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="142" parent="14" name="database_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="143" parent="14" name="table_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="144" parent="14" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="145" parent="14" name="n_rows"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="146" parent="14" name="clustered_index_size"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="147" parent="14" name="sum_of_other_index_sizes"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<key id="148" parent="14" name="PRIMARY"> | |
<columns>database_name | |
table_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="149" parent="15" name="Position"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="150" parent="15" name="File"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(255)</data-type> | |
</column> | |
<column id="151" parent="15" name="epoch"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="152" parent="15" name="inserts"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="153" parent="15" name="updates"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="154" parent="15" name="deletes"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="155" parent="15" name="schemaops"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="156" parent="15" name="orig_server_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="157" parent="15" name="orig_epoch"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="158" parent="15" name="gci"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="159" parent="15" name="next_position"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="160" parent="15" name="next_file"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(255)</data-type> | |
</column> | |
<key id="161" parent="15" name="PRIMARY"> | |
<columns>epoch | |
orig_server_id | |
orig_epoch</columns> | |
<primary>1</primary> | |
</key> | |
<column id="162" parent="16" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="163" parent="16" name="dl"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(128)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="164" parent="16" name="PRIMARY"> | |
<columns>name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="165" parent="17" name="db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="166" parent="17" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="167" parent="17" name="type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('FUNCTION', 'PROCEDURE')</data-type> | |
</column> | |
<column id="168" parent="17" name="specific_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="169" parent="17" name="language"> | |
<mandatory>1</mandatory> | |
<data-type>enum('SQL')</data-type> | |
<default-expression>'SQL'</default-expression> | |
</column> | |
<column id="170" parent="17" name="sql_data_access"> | |
<mandatory>1</mandatory> | |
<data-type>enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')</data-type> | |
<default-expression>'CONTAINS_SQL'</default-expression> | |
</column> | |
<column id="171" parent="17" name="is_deterministic"> | |
<mandatory>1</mandatory> | |
<data-type>enum('YES', 'NO')</data-type> | |
<default-expression>'NO'</default-expression> | |
</column> | |
<column id="172" parent="17" name="security_type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('INVOKER', 'DEFINER')</data-type> | |
<default-expression>'DEFINER'</default-expression> | |
</column> | |
<column id="173" parent="17" name="param_list"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="174" parent="17" name="returns"> | |
<mandatory>1</mandatory> | |
<data-type>longblob</data-type> | |
</column> | |
<column id="175" parent="17" name="body"> | |
<mandatory>1</mandatory> | |
<data-type>longblob</data-type> | |
</column> | |
<column id="176" parent="17" name="definer"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="177" parent="17" name="created"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="178" parent="17" name="modified"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'0000-00-00 00:00:00'</default-expression> | |
</column> | |
<column id="179" parent="17" name="sql_mode"> | |
<mandatory>1</mandatory> | |
<data-type>set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="180" parent="17" name="comment"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="181" parent="17" name="character_set_client"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="182" parent="17" name="collation_connection"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="183" parent="17" name="db_collation"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="184" parent="17" name="body_utf8"> | |
<data-type>longblob</data-type> | |
</column> | |
<key id="185" parent="17" name="PRIMARY"> | |
<columns>db | |
name | |
type</columns> | |
<primary>1</primary> | |
</key> | |
<column id="186" parent="18" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="187" parent="18" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="188" parent="18" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="189" parent="18" name="Routine_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="190" parent="18" name="Routine_type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('FUNCTION', 'PROCEDURE')</data-type> | |
</column> | |
<column id="191" parent="18" name="Grantor"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="192" parent="18" name="Proc_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Execute', 'Alter Routine', 'Grant')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="193" parent="18" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<key id="194" parent="18" name="PRIMARY"> | |
<columns>Host | |
Db | |
User | |
Routine_name | |
Routine_type</columns> | |
<primary>1</primary> | |
</key> | |
<column id="195" parent="19" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="196" parent="19" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="197" parent="19" name="Proxied_host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="198" parent="19" name="Proxied_user"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="199" parent="19" name="With_grant"> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="200" parent="19" name="Grantor"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="201" parent="19" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<key id="202" parent="19" name="PRIMARY"> | |
<columns>Host | |
User | |
Proxied_host | |
Proxied_user</columns> | |
<primary>1</primary> | |
</key> | |
<column id="203" parent="20" name="cost_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="204" parent="20" name="cost_value"> | |
<data-type>float</data-type> | |
</column> | |
<column id="205" parent="20" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="206" parent="20" name="comment"> | |
<data-type>varchar(1024)</data-type> | |
</column> | |
<key id="207" parent="20" name="PRIMARY"> | |
<columns>cost_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="208" parent="21" name="Server_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="209" parent="21" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="210" parent="21" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="211" parent="21" name="Username"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="212" parent="21" name="Password"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="213" parent="21" name="Port"> | |
<mandatory>1</mandatory> | |
<data-type>int(4)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="214" parent="21" name="Socket"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="215" parent="21" name="Wrapper"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="216" parent="21" name="Owner"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="217" parent="21" name="PRIMARY"> | |
<columns>Server_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="218" parent="22" name="Number_of_lines"> | |
<comment>Number of lines in the file.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="219" parent="22" name="Master_log_name"> | |
<comment>The name of the master binary log currently being read from the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="220" parent="22" name="Master_log_pos"> | |
<comment>The master log position of the last read event.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="221" parent="22" name="Host"> | |
<comment>The host name of the master.</comment> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="222" parent="22" name="User_name"> | |
<comment>The user name used to connect to the master.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="223" parent="22" name="User_password"> | |
<comment>The password used to connect to the master.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="224" parent="22" name="Port"> | |
<comment>The network port used to connect to the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="225" parent="22" name="Connect_retry"> | |
<comment>The period (in seconds) that the slave will wait before trying to reconnect to the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="226" parent="22" name="Enabled_ssl"> | |
<comment>Indicates whether the server supports SSL connections.</comment> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
</column> | |
<column id="227" parent="22" name="Ssl_ca"> | |
<comment>The file used for the Certificate Authority (CA) certificate.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="228" parent="22" name="Ssl_capath"> | |
<comment>The path to the Certificate Authority (CA) certificates.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="229" parent="22" name="Ssl_cert"> | |
<comment>The name of the SSL certificate file.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="230" parent="22" name="Ssl_cipher"> | |
<comment>The name of the cipher in use for the SSL connection.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="231" parent="22" name="Ssl_key"> | |
<comment>The name of the SSL key file.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="232" parent="22" name="Ssl_verify_server_cert"> | |
<comment>Whether to verify the server certificate.</comment> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
</column> | |
<column id="233" parent="22" name="Heartbeat"> | |
<mandatory>1</mandatory> | |
<data-type>float</data-type> | |
</column> | |
<column id="234" parent="22" name="Bind"> | |
<comment>Displays which interface is employed when connecting to the MySQL server</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="235" parent="22" name="Ignored_server_ids"> | |
<comment>The number of server IDs to be ignored, followed by the actual server IDs</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="236" parent="22" name="Uuid"> | |
<comment>The master server uuid.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="237" parent="22" name="Retry_count"> | |
<comment>Number of reconnect attempts, to the master, before giving up.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="238" parent="22" name="Ssl_crl"> | |
<comment>The file used for the Certificate Revocation List (CRL)</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="239" parent="22" name="Ssl_crlpath"> | |
<comment>The path used for Certificate Revocation List (CRL) files</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="240" parent="22" name="Enabled_auto_position"> | |
<comment>Indicates whether GTIDs will be used to retrieve events from the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
</column> | |
<column id="241" parent="22" name="Channel_name"> | |
<comment>The channel on which the slave is connected to a source. Used in Multisource Replication</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="242" parent="22" name="Tls_version"> | |
<comment>Tls version</comment> | |
<data-type>text</data-type> | |
</column> | |
<key id="243" parent="22" name="PRIMARY"> | |
<columns>Channel_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="244" parent="23" name="Number_of_lines"> | |
<comment>Number of lines in the file or rows in the table. Used to version table definitions.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="245" parent="23" name="Relay_log_name"> | |
<comment>The name of the current relay log file.</comment> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="246" parent="23" name="Relay_log_pos"> | |
<comment>The relay log position of the last executed event.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="247" parent="23" name="Master_log_name"> | |
<comment>The name of the master binary log file from which the events in the relay log file were read.</comment> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="248" parent="23" name="Master_log_pos"> | |
<comment>The master log position of the last executed event.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="249" parent="23" name="Sql_delay"> | |
<comment>The number of seconds that the slave must lag behind the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="250" parent="23" name="Number_of_workers"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="251" parent="23" name="Id"> | |
<comment>Internal Id that uniquely identifies this record.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="252" parent="23" name="Channel_name"> | |
<comment>The channel on which the slave is connected to a source. Used in Multisource Replication</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<key id="253" parent="23" name="PRIMARY"> | |
<columns>Channel_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="254" parent="24" name="Id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="255" parent="24" name="Relay_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="256" parent="24" name="Relay_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="257" parent="24" name="Master_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="258" parent="24" name="Master_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="259" parent="24" name="Checkpoint_relay_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="260" parent="24" name="Checkpoint_relay_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="261" parent="24" name="Checkpoint_master_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="262" parent="24" name="Checkpoint_master_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="263" parent="24" name="Checkpoint_seqno"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="264" parent="24" name="Checkpoint_group_size"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="265" parent="24" name="Checkpoint_group_bitmap"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="266" parent="24" name="Channel_name"> | |
<comment>The channel on which the slave is connected to a source. Used in Multisource Replication</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<key id="267" parent="24" name="PRIMARY"> | |
<columns>Channel_name | |
Id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="268" parent="25" name="start_time"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp(6)</data-type> | |
<default-expression>'CURRENT_TIMESTAMP(6)'</default-expression> | |
</column> | |
<column id="269" parent="25" name="user_host"> | |
<mandatory>1</mandatory> | |
<data-type>mediumtext</data-type> | |
</column> | |
<column id="270" parent="25" name="query_time"> | |
<mandatory>1</mandatory> | |
<data-type>time(6)</data-type> | |
</column> | |
<column id="271" parent="25" name="lock_time"> | |
<mandatory>1</mandatory> | |
<data-type>time(6)</data-type> | |
</column> | |
<column id="272" parent="25" name="rows_sent"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="273" parent="25" name="rows_examined"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="274" parent="25" name="db"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(512)</data-type> | |
</column> | |
<column id="275" parent="25" name="last_insert_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="276" parent="25" name="insert_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="277" parent="25" name="server_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="278" parent="25" name="sql_text"> | |
<mandatory>1</mandatory> | |
<data-type>mediumblob</data-type> | |
</column> | |
<column id="279" parent="25" name="thread_id"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(21) unsigned</data-type> | |
</column> | |
<column id="280" parent="26" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="281" parent="26" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="282" parent="26" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="283" parent="26" name="Table_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="284" parent="26" name="Grantor"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="285" parent="26" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="286" parent="26" name="Table_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="287" parent="26" name="Column_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Select', 'Insert', 'Update', 'References')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="288" parent="26" name="PRIMARY"> | |
<columns>Host | |
Db | |
User | |
Table_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="289" parent="27" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="290" parent="27" name="Use_leap_seconds"> | |
<mandatory>1</mandatory> | |
<data-type>enum('Y', 'N')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<key id="291" parent="27" name="PRIMARY"> | |
<columns>Time_zone_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="292" parent="28" name="Transition_time"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<column id="293" parent="28" name="Correction"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<key id="294" parent="28" name="PRIMARY"> | |
<columns>Transition_time</columns> | |
<primary>1</primary> | |
</key> | |
<column id="295" parent="29" name="Name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="296" parent="29" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<key id="297" parent="29" name="PRIMARY"> | |
<columns>Name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="298" parent="30" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="299" parent="30" name="Transition_time"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<column id="300" parent="30" name="Transition_type_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<key id="301" parent="30" name="PRIMARY"> | |
<columns>Time_zone_id | |
Transition_time</columns> | |
<primary>1</primary> | |
</key> | |
<column id="302" parent="31" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="303" parent="31" name="Transition_type_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="304" parent="31" name="Offset"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="305" parent="31" name="Is_DST"> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(3) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="306" parent="31" name="Abbreviation"> | |
<mandatory>1</mandatory> | |
<data-type>char(8)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="307" parent="31" name="PRIMARY"> | |
<columns>Time_zone_id | |
Transition_type_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="308" parent="32" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="309" parent="32" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="310" parent="32" name="Select_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="311" parent="32" name="Insert_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="312" parent="32" name="Update_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="313" parent="32" name="Delete_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="314" parent="32" name="Create_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="315" parent="32" name="Drop_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="316" parent="32" name="Reload_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="317" parent="32" name="Shutdown_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="318" parent="32" name="Process_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="319" parent="32" name="File_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="320" parent="32" name="Grant_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="321" parent="32" name="References_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="322" parent="32" name="Index_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="323" parent="32" name="Alter_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="324" parent="32" name="Show_db_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="325" parent="32" name="Super_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="326" parent="32" name="Create_tmp_table_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="327" parent="32" name="Lock_tables_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="328" parent="32" name="Execute_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="329" parent="32" name="Repl_slave_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="330" parent="32" name="Repl_client_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="331" parent="32" name="Create_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="332" parent="32" name="Show_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="333" parent="32" name="Create_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="334" parent="32" name="Alter_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="335" parent="32" name="Create_user_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="336" parent="32" name="Event_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="337" parent="32" name="Trigger_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="338" parent="32" name="Create_tablespace_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="339" parent="32" name="ssl_type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('', 'ANY', 'X509', 'SPECIFIED')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="340" parent="32" name="ssl_cipher"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="341" parent="32" name="x509_issuer"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="342" parent="32" name="x509_subject"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="343" parent="32" name="max_questions"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="344" parent="32" name="max_updates"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="345" parent="32" name="max_connections"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="346" parent="32" name="max_user_connections"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="347" parent="32" name="plugin"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>'mysql_native_password'</default-expression> | |
</column> | |
<column id="348" parent="32" name="authentication_string"> | |
<data-type>text</data-type> | |
</column> | |
<column id="349" parent="32" name="password_expired"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="350" parent="32" name="password_last_changed"> | |
<data-type>timestamp</data-type> | |
</column> | |
<column id="351" parent="32" name="password_lifetime"> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="352" parent="32" name="account_locked"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<key id="353" parent="32" name="PRIMARY"> | |
<columns>Host | |
User</columns> | |
<primary>1</primary> | |
</key> | |
</database-model> | |
</data-source> | |
<data-source name="MySQL - mysql@localhost" uuid="e8658cf6-f50b-4bb3-8e76-03fda272f61b"> | |
<database-info product="MySQL" version="5.7.13-log" jdbc-version="4.0" driver-name="MySQL Connector Java" driver-version="mysql-connector-java-5.1.35 ( Revision: 5fb9c5849535c13917c2cf9baaece6ef9693ef27 )"> | |
<extra-name-characters>#@</extra-name-characters> | |
<identifier-quote-string>`</identifier-quote-string> | |
</database-info> | |
<case-sensitivity plain-identifiers="lower" quoted-identifiers="lower"/> | |
<database-model serializer="dbm" rdbms="MYSQL" format-version="2.2"> | |
<schema id="1" name="mysql"/> | |
<table id="2" parent="1" name="columns_priv"/> | |
<table id="3" parent="1" name="db"/> | |
<table id="4" parent="1" name="engine_cost"/> | |
<table id="5" parent="1" name="event"/> | |
<table id="6" parent="1" name="func"/> | |
<table id="7" parent="1" name="general_log"/> | |
<table id="8" parent="1" name="gtid_executed"/> | |
<table id="9" parent="1" name="help_category"/> | |
<table id="10" parent="1" name="help_keyword"/> | |
<table id="11" parent="1" name="help_relation"/> | |
<table id="12" parent="1" name="help_topic"/> | |
<table id="13" parent="1" name="innodb_index_stats"/> | |
<table id="14" parent="1" name="innodb_table_stats"/> | |
<table id="15" parent="1" name="ndb_binlog_index"/> | |
<table id="16" parent="1" name="plugin"/> | |
<table id="17" parent="1" name="proc"/> | |
<table id="18" parent="1" name="procs_priv"/> | |
<table id="19" parent="1" name="proxies_priv"/> | |
<table id="20" parent="1" name="server_cost"/> | |
<table id="21" parent="1" name="servers"/> | |
<table id="22" parent="1" name="slave_master_info"/> | |
<table id="23" parent="1" name="slave_relay_log_info"/> | |
<table id="24" parent="1" name="slave_worker_info"/> | |
<table id="25" parent="1" name="slow_log"/> | |
<table id="26" parent="1" name="tables_priv"/> | |
<table id="27" parent="1" name="time_zone"/> | |
<table id="28" parent="1" name="time_zone_leap_second"/> | |
<table id="29" parent="1" name="time_zone_name"/> | |
<table id="30" parent="1" name="time_zone_transition"/> | |
<table id="31" parent="1" name="time_zone_transition_type"/> | |
<table id="32" parent="1" name="user"/> | |
<column id="33" parent="2" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="34" parent="2" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="35" parent="2" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="36" parent="2" name="Table_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="37" parent="2" name="Column_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="38" parent="2" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="39" parent="2" name="Column_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Select', 'Insert', 'Update', 'References')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="40" parent="2" name="PRIMARY"> | |
<columns>Host | |
Db | |
User | |
Table_name | |
Column_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="41" parent="3" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="42" parent="3" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="43" parent="3" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="44" parent="3" name="Select_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="45" parent="3" name="Insert_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="46" parent="3" name="Update_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="47" parent="3" name="Delete_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="48" parent="3" name="Create_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="49" parent="3" name="Drop_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="50" parent="3" name="Grant_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="51" parent="3" name="References_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="52" parent="3" name="Index_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="53" parent="3" name="Alter_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="54" parent="3" name="Create_tmp_table_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="55" parent="3" name="Lock_tables_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="56" parent="3" name="Create_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="57" parent="3" name="Show_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="58" parent="3" name="Create_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="59" parent="3" name="Alter_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="60" parent="3" name="Execute_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="61" parent="3" name="Event_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="62" parent="3" name="Trigger_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<key id="63" parent="3" name="PRIMARY"> | |
<columns>Host | |
Db | |
User</columns> | |
<primary>1</primary> | |
</key> | |
<column id="64" parent="4" name="engine_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="65" parent="4" name="device_type"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="66" parent="4" name="cost_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="67" parent="4" name="cost_value"> | |
<data-type>float</data-type> | |
</column> | |
<column id="68" parent="4" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="69" parent="4" name="comment"> | |
<data-type>varchar(1024)</data-type> | |
</column> | |
<key id="70" parent="4" name="PRIMARY"> | |
<columns>cost_name | |
engine_name | |
device_type</columns> | |
<primary>1</primary> | |
</key> | |
<column id="71" parent="5" name="db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="72" parent="5" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="73" parent="5" name="body"> | |
<mandatory>1</mandatory> | |
<data-type>longblob</data-type> | |
</column> | |
<column id="74" parent="5" name="definer"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="75" parent="5" name="execute_at"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="76" parent="5" name="interval_value"> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="77" parent="5" name="interval_field"> | |
<data-type>enum('YEAR', 'QUARTER', 'MONTH', 'DAY', 'HOUR', 'MINUTE', 'WEEK', 'SECOND', 'MICROSECOND', 'YEAR_MONTH', 'DAY_HOUR', 'DAY_MINUTE', 'DAY_SECOND', 'HOUR_MINUTE', 'HOUR_SECOND', 'MINUTE_SECOND', 'DAY_MICROSECOND', 'HOUR_MICROSECOND', 'MINUTE_MICROSECOND', 'SECOND_MICROSECOND')</data-type> | |
</column> | |
<column id="78" parent="5" name="created"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="79" parent="5" name="modified"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'0000-00-00 00:00:00'</default-expression> | |
</column> | |
<column id="80" parent="5" name="last_executed"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="81" parent="5" name="starts"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="82" parent="5" name="ends"> | |
<data-type>datetime</data-type> | |
</column> | |
<column id="83" parent="5" name="status"> | |
<mandatory>1</mandatory> | |
<data-type>enum('ENABLED', 'DISABLED', 'SLAVESIDE_DISABLED')</data-type> | |
<default-expression>'ENABLED'</default-expression> | |
</column> | |
<column id="84" parent="5" name="on_completion"> | |
<mandatory>1</mandatory> | |
<data-type>enum('DROP', 'PRESERVE')</data-type> | |
<default-expression>'DROP'</default-expression> | |
</column> | |
<column id="85" parent="5" name="sql_mode"> | |
<mandatory>1</mandatory> | |
<data-type>set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="86" parent="5" name="comment"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="87" parent="5" name="originator"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="88" parent="5" name="time_zone"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>'SYSTEM'</default-expression> | |
</column> | |
<column id="89" parent="5" name="character_set_client"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="90" parent="5" name="collation_connection"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="91" parent="5" name="db_collation"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="92" parent="5" name="body_utf8"> | |
<data-type>longblob</data-type> | |
</column> | |
<key id="93" parent="5" name="PRIMARY"> | |
<columns>db | |
name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="94" parent="6" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="95" parent="6" name="ret"> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="96" parent="6" name="dl"> | |
<mandatory>1</mandatory> | |
<data-type>char(128)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="97" parent="6" name="type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('function', 'aggregate')</data-type> | |
</column> | |
<key id="98" parent="6" name="PRIMARY"> | |
<columns>name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="99" parent="7" name="event_time"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp(6)</data-type> | |
<default-expression>'CURRENT_TIMESTAMP(6)'</default-expression> | |
</column> | |
<column id="100" parent="7" name="user_host"> | |
<mandatory>1</mandatory> | |
<data-type>mediumtext</data-type> | |
</column> | |
<column id="101" parent="7" name="thread_id"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(21) unsigned</data-type> | |
</column> | |
<column id="102" parent="7" name="server_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="103" parent="7" name="command_type"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="104" parent="7" name="argument"> | |
<mandatory>1</mandatory> | |
<data-type>mediumblob</data-type> | |
</column> | |
<column id="105" parent="8" name="source_uuid"> | |
<comment>uuid of the source where the transaction was originally executed.</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(36)</data-type> | |
</column> | |
<column id="106" parent="8" name="interval_start"> | |
<comment>First number of interval.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<column id="107" parent="8" name="interval_end"> | |
<comment>Last number of interval.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<key id="108" parent="8" name="PRIMARY"> | |
<columns>source_uuid | |
interval_start</columns> | |
<primary>1</primary> | |
</key> | |
<column id="109" parent="9" name="help_category_id"> | |
<mandatory>1</mandatory> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="110" parent="9" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="111" parent="9" name="parent_category_id"> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="112" parent="9" name="url"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<index id="113" parent="9" name="name"> | |
<columns>name</columns> | |
<unique>1</unique> | |
</index> | |
<key id="114" parent="9" name="name"> | |
<columns>name</columns> | |
<underlying-index>name</underlying-index> | |
</key> | |
<key id="115" parent="9" name="PRIMARY"> | |
<columns>help_category_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="116" parent="10" name="help_keyword_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="117" parent="10" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<index id="118" parent="10" name="name"> | |
<columns>name</columns> | |
<unique>1</unique> | |
</index> | |
<key id="119" parent="10" name="name"> | |
<columns>name</columns> | |
<underlying-index>name</underlying-index> | |
</key> | |
<key id="120" parent="10" name="PRIMARY"> | |
<columns>help_keyword_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="121" parent="11" name="help_topic_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="122" parent="11" name="help_keyword_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<key id="123" parent="11" name="PRIMARY"> | |
<columns>help_keyword_id | |
help_topic_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="124" parent="12" name="help_topic_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="125" parent="12" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="126" parent="12" name="help_category_id"> | |
<mandatory>1</mandatory> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="127" parent="12" name="description"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="128" parent="12" name="example"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="129" parent="12" name="url"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<index id="130" parent="12" name="name"> | |
<columns>name</columns> | |
<unique>1</unique> | |
</index> | |
<key id="131" parent="12" name="name"> | |
<columns>name</columns> | |
<underlying-index>name</underlying-index> | |
</key> | |
<key id="132" parent="12" name="PRIMARY"> | |
<columns>help_topic_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="133" parent="13" name="database_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="134" parent="13" name="table_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="135" parent="13" name="index_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="136" parent="13" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="137" parent="13" name="stat_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="138" parent="13" name="stat_value"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="139" parent="13" name="sample_size"> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="140" parent="13" name="stat_description"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(1024)</data-type> | |
</column> | |
<key id="141" parent="13" name="PRIMARY"> | |
<columns>database_name | |
table_name | |
index_name | |
stat_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="142" parent="14" name="database_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="143" parent="14" name="table_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="144" parent="14" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="145" parent="14" name="n_rows"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="146" parent="14" name="clustered_index_size"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="147" parent="14" name="sum_of_other_index_sizes"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<key id="148" parent="14" name="PRIMARY"> | |
<columns>database_name | |
table_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="149" parent="15" name="Position"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="150" parent="15" name="File"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(255)</data-type> | |
</column> | |
<column id="151" parent="15" name="epoch"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="152" parent="15" name="inserts"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="153" parent="15" name="updates"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="154" parent="15" name="deletes"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="155" parent="15" name="schemaops"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="156" parent="15" name="orig_server_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="157" parent="15" name="orig_epoch"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="158" parent="15" name="gci"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="159" parent="15" name="next_position"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="160" parent="15" name="next_file"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(255)</data-type> | |
</column> | |
<key id="161" parent="15" name="PRIMARY"> | |
<columns>epoch | |
orig_server_id | |
orig_epoch</columns> | |
<primary>1</primary> | |
</key> | |
<column id="162" parent="16" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="163" parent="16" name="dl"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(128)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="164" parent="16" name="PRIMARY"> | |
<columns>name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="165" parent="17" name="db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="166" parent="17" name="name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="167" parent="17" name="type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('FUNCTION', 'PROCEDURE')</data-type> | |
</column> | |
<column id="168" parent="17" name="specific_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="169" parent="17" name="language"> | |
<mandatory>1</mandatory> | |
<data-type>enum('SQL')</data-type> | |
<default-expression>'SQL'</default-expression> | |
</column> | |
<column id="170" parent="17" name="sql_data_access"> | |
<mandatory>1</mandatory> | |
<data-type>enum('CONTAINS_SQL', 'NO_SQL', 'READS_SQL_DATA', 'MODIFIES_SQL_DATA')</data-type> | |
<default-expression>'CONTAINS_SQL'</default-expression> | |
</column> | |
<column id="171" parent="17" name="is_deterministic"> | |
<mandatory>1</mandatory> | |
<data-type>enum('YES', 'NO')</data-type> | |
<default-expression>'NO'</default-expression> | |
</column> | |
<column id="172" parent="17" name="security_type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('INVOKER', 'DEFINER')</data-type> | |
<default-expression>'DEFINER'</default-expression> | |
</column> | |
<column id="173" parent="17" name="param_list"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="174" parent="17" name="returns"> | |
<mandatory>1</mandatory> | |
<data-type>longblob</data-type> | |
</column> | |
<column id="175" parent="17" name="body"> | |
<mandatory>1</mandatory> | |
<data-type>longblob</data-type> | |
</column> | |
<column id="176" parent="17" name="definer"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="177" parent="17" name="created"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="178" parent="17" name="modified"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'0000-00-00 00:00:00'</default-expression> | |
</column> | |
<column id="179" parent="17" name="sql_mode"> | |
<mandatory>1</mandatory> | |
<data-type>set('REAL_AS_FLOAT', 'PIPES_AS_CONCAT', 'ANSI_QUOTES', 'IGNORE_SPACE', 'NOT_USED', 'ONLY_FULL_GROUP_BY', 'NO_UNSIGNED_SUBTRACTION', 'NO_DIR_IN_CREATE', 'POSTGRESQL', 'ORACLE', 'MSSQL', 'DB2', 'MAXDB', 'NO_KEY_OPTIONS', 'NO_TABLE_OPTIONS', 'NO_FIELD_OPTIONS', 'MYSQL323', 'MYSQL40', 'ANSI', 'NO_AUTO_VALUE_ON_ZERO', 'NO_BACKSLASH_ESCAPES', 'STRICT_TRANS_TABLES', 'STRICT_ALL_TABLES', 'NO_ZERO_IN_DATE', 'NO_ZERO_DATE', 'INVALID_DATES', 'ERROR_FOR_DIVISION_BY_ZERO', 'TRADITIONAL', 'NO_AUTO_CREATE_USER', 'HIGH_NOT_PRECEDENCE', 'NO_ENGINE_SUBSTITUTION', 'PAD_CHAR_TO_FULL_LENGTH')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="180" parent="17" name="comment"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="181" parent="17" name="character_set_client"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="182" parent="17" name="collation_connection"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="183" parent="17" name="db_collation"> | |
<data-type>char(32)</data-type> | |
</column> | |
<column id="184" parent="17" name="body_utf8"> | |
<data-type>longblob</data-type> | |
</column> | |
<key id="185" parent="17" name="PRIMARY"> | |
<columns>db | |
name | |
type</columns> | |
<primary>1</primary> | |
</key> | |
<column id="186" parent="18" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="187" parent="18" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="188" parent="18" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="189" parent="18" name="Routine_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="190" parent="18" name="Routine_type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('FUNCTION', 'PROCEDURE')</data-type> | |
</column> | |
<column id="191" parent="18" name="Grantor"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="192" parent="18" name="Proc_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Execute', 'Alter Routine', 'Grant')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="193" parent="18" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<key id="194" parent="18" name="PRIMARY"> | |
<columns>Host | |
Db | |
User | |
Routine_name | |
Routine_type</columns> | |
<primary>1</primary> | |
</key> | |
<column id="195" parent="19" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="196" parent="19" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="197" parent="19" name="Proxied_host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="198" parent="19" name="Proxied_user"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="199" parent="19" name="With_grant"> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="200" parent="19" name="Grantor"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="201" parent="19" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<key id="202" parent="19" name="PRIMARY"> | |
<columns>Host | |
User | |
Proxied_host | |
Proxied_user</columns> | |
<primary>1</primary> | |
</key> | |
<column id="203" parent="20" name="cost_name"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(64)</data-type> | |
</column> | |
<column id="204" parent="20" name="cost_value"> | |
<data-type>float</data-type> | |
</column> | |
<column id="205" parent="20" name="last_update"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="206" parent="20" name="comment"> | |
<data-type>varchar(1024)</data-type> | |
</column> | |
<key id="207" parent="20" name="PRIMARY"> | |
<columns>cost_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="208" parent="21" name="Server_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="209" parent="21" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="210" parent="21" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="211" parent="21" name="Username"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="212" parent="21" name="Password"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="213" parent="21" name="Port"> | |
<mandatory>1</mandatory> | |
<data-type>int(4)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="214" parent="21" name="Socket"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="215" parent="21" name="Wrapper"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="216" parent="21" name="Owner"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="217" parent="21" name="PRIMARY"> | |
<columns>Server_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="218" parent="22" name="Number_of_lines"> | |
<comment>Number of lines in the file.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="219" parent="22" name="Master_log_name"> | |
<comment>The name of the master binary log currently being read from the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="220" parent="22" name="Master_log_pos"> | |
<comment>The master log position of the last read event.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="221" parent="22" name="Host"> | |
<comment>The host name of the master.</comment> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="222" parent="22" name="User_name"> | |
<comment>The user name used to connect to the master.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="223" parent="22" name="User_password"> | |
<comment>The password used to connect to the master.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="224" parent="22" name="Port"> | |
<comment>The network port used to connect to the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="225" parent="22" name="Connect_retry"> | |
<comment>The period (in seconds) that the slave will wait before trying to reconnect to the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="226" parent="22" name="Enabled_ssl"> | |
<comment>Indicates whether the server supports SSL connections.</comment> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
</column> | |
<column id="227" parent="22" name="Ssl_ca"> | |
<comment>The file used for the Certificate Authority (CA) certificate.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="228" parent="22" name="Ssl_capath"> | |
<comment>The path to the Certificate Authority (CA) certificates.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="229" parent="22" name="Ssl_cert"> | |
<comment>The name of the SSL certificate file.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="230" parent="22" name="Ssl_cipher"> | |
<comment>The name of the cipher in use for the SSL connection.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="231" parent="22" name="Ssl_key"> | |
<comment>The name of the SSL key file.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="232" parent="22" name="Ssl_verify_server_cert"> | |
<comment>Whether to verify the server certificate.</comment> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
</column> | |
<column id="233" parent="22" name="Heartbeat"> | |
<mandatory>1</mandatory> | |
<data-type>float</data-type> | |
</column> | |
<column id="234" parent="22" name="Bind"> | |
<comment>Displays which interface is employed when connecting to the MySQL server</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="235" parent="22" name="Ignored_server_ids"> | |
<comment>The number of server IDs to be ignored, followed by the actual server IDs</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="236" parent="22" name="Uuid"> | |
<comment>The master server uuid.</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="237" parent="22" name="Retry_count"> | |
<comment>Number of reconnect attempts, to the master, before giving up.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="238" parent="22" name="Ssl_crl"> | |
<comment>The file used for the Certificate Revocation List (CRL)</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="239" parent="22" name="Ssl_crlpath"> | |
<comment>The path used for Certificate Revocation List (CRL) files</comment> | |
<data-type>text</data-type> | |
</column> | |
<column id="240" parent="22" name="Enabled_auto_position"> | |
<comment>Indicates whether GTIDs will be used to retrieve events from the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(1)</data-type> | |
</column> | |
<column id="241" parent="22" name="Channel_name"> | |
<comment>The channel on which the slave is connected to a source. Used in Multisource Replication</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="242" parent="22" name="Tls_version"> | |
<comment>Tls version</comment> | |
<data-type>text</data-type> | |
</column> | |
<key id="243" parent="22" name="PRIMARY"> | |
<columns>Channel_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="244" parent="23" name="Number_of_lines"> | |
<comment>Number of lines in the file or rows in the table. Used to version table definitions.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="245" parent="23" name="Relay_log_name"> | |
<comment>The name of the current relay log file.</comment> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="246" parent="23" name="Relay_log_pos"> | |
<comment>The relay log position of the last executed event.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="247" parent="23" name="Master_log_name"> | |
<comment>The name of the master binary log file from which the events in the relay log file were read.</comment> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="248" parent="23" name="Master_log_pos"> | |
<comment>The master log position of the last executed event.</comment> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="249" parent="23" name="Sql_delay"> | |
<comment>The number of seconds that the slave must lag behind the master.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="250" parent="23" name="Number_of_workers"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="251" parent="23" name="Id"> | |
<comment>Internal Id that uniquely identifies this record.</comment> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="252" parent="23" name="Channel_name"> | |
<comment>The channel on which the slave is connected to a source. Used in Multisource Replication</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<key id="253" parent="23" name="PRIMARY"> | |
<columns>Channel_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="254" parent="24" name="Id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="255" parent="24" name="Relay_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="256" parent="24" name="Relay_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="257" parent="24" name="Master_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="258" parent="24" name="Master_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="259" parent="24" name="Checkpoint_relay_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="260" parent="24" name="Checkpoint_relay_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="261" parent="24" name="Checkpoint_master_log_name"> | |
<mandatory>1</mandatory> | |
<data-type>text</data-type> | |
</column> | |
<column id="262" parent="24" name="Checkpoint_master_log_pos"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20) unsigned</data-type> | |
</column> | |
<column id="263" parent="24" name="Checkpoint_seqno"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="264" parent="24" name="Checkpoint_group_size"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="265" parent="24" name="Checkpoint_group_bitmap"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="266" parent="24" name="Channel_name"> | |
<comment>The channel on which the slave is connected to a source. Used in Multisource Replication</comment> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<key id="267" parent="24" name="PRIMARY"> | |
<columns>Channel_name | |
Id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="268" parent="25" name="start_time"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp(6)</data-type> | |
<default-expression>'CURRENT_TIMESTAMP(6)'</default-expression> | |
</column> | |
<column id="269" parent="25" name="user_host"> | |
<mandatory>1</mandatory> | |
<data-type>mediumtext</data-type> | |
</column> | |
<column id="270" parent="25" name="query_time"> | |
<mandatory>1</mandatory> | |
<data-type>time(6)</data-type> | |
</column> | |
<column id="271" parent="25" name="lock_time"> | |
<mandatory>1</mandatory> | |
<data-type>time(6)</data-type> | |
</column> | |
<column id="272" parent="25" name="rows_sent"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="273" parent="25" name="rows_examined"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="274" parent="25" name="db"> | |
<mandatory>1</mandatory> | |
<data-type>varchar(512)</data-type> | |
</column> | |
<column id="275" parent="25" name="last_insert_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="276" parent="25" name="insert_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<column id="277" parent="25" name="server_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="278" parent="25" name="sql_text"> | |
<mandatory>1</mandatory> | |
<data-type>mediumblob</data-type> | |
</column> | |
<column id="279" parent="25" name="thread_id"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(21) unsigned</data-type> | |
</column> | |
<column id="280" parent="26" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="281" parent="26" name="Db"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="282" parent="26" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="283" parent="26" name="Table_name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="284" parent="26" name="Grantor"> | |
<mandatory>1</mandatory> | |
<data-type>char(93)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="285" parent="26" name="Timestamp"> | |
<mandatory>1</mandatory> | |
<data-type>timestamp</data-type> | |
<default-expression>'CURRENT_TIMESTAMP'</default-expression> | |
</column> | |
<column id="286" parent="26" name="Table_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Select', 'Insert', 'Update', 'Delete', 'Create', 'Drop', 'Grant', 'References', 'Index', 'Alter', 'Create View', 'Show view', 'Trigger')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="287" parent="26" name="Column_priv"> | |
<mandatory>1</mandatory> | |
<data-type>set('Select', 'Insert', 'Update', 'References')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="288" parent="26" name="PRIMARY"> | |
<columns>Host | |
Db | |
User | |
Table_name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="289" parent="27" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="290" parent="27" name="Use_leap_seconds"> | |
<mandatory>1</mandatory> | |
<data-type>enum('Y', 'N')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<key id="291" parent="27" name="PRIMARY"> | |
<columns>Time_zone_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="292" parent="28" name="Transition_time"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<column id="293" parent="28" name="Correction"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
</column> | |
<key id="294" parent="28" name="PRIMARY"> | |
<columns>Transition_time</columns> | |
<primary>1</primary> | |
</key> | |
<column id="295" parent="29" name="Name"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
</column> | |
<column id="296" parent="29" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<key id="297" parent="29" name="PRIMARY"> | |
<columns>Name</columns> | |
<primary>1</primary> | |
</key> | |
<column id="298" parent="30" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="299" parent="30" name="Transition_time"> | |
<mandatory>1</mandatory> | |
<data-type>bigint(20)</data-type> | |
</column> | |
<column id="300" parent="30" name="Transition_type_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<key id="301" parent="30" name="PRIMARY"> | |
<columns>Time_zone_id | |
Transition_time</columns> | |
<primary>1</primary> | |
</key> | |
<column id="302" parent="31" name="Time_zone_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="303" parent="31" name="Transition_type_id"> | |
<mandatory>1</mandatory> | |
<data-type>int(10) unsigned</data-type> | |
</column> | |
<column id="304" parent="31" name="Offset"> | |
<mandatory>1</mandatory> | |
<data-type>int(11)</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="305" parent="31" name="Is_DST"> | |
<mandatory>1</mandatory> | |
<data-type>tinyint(3) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="306" parent="31" name="Abbreviation"> | |
<mandatory>1</mandatory> | |
<data-type>char(8)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<key id="307" parent="31" name="PRIMARY"> | |
<columns>Time_zone_id | |
Transition_type_id</columns> | |
<primary>1</primary> | |
</key> | |
<column id="308" parent="32" name="Host"> | |
<mandatory>1</mandatory> | |
<data-type>char(60)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="309" parent="32" name="User"> | |
<mandatory>1</mandatory> | |
<data-type>char(32)</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="310" parent="32" name="Select_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="311" parent="32" name="Insert_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="312" parent="32" name="Update_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="313" parent="32" name="Delete_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="314" parent="32" name="Create_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="315" parent="32" name="Drop_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="316" parent="32" name="Reload_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="317" parent="32" name="Shutdown_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="318" parent="32" name="Process_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="319" parent="32" name="File_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="320" parent="32" name="Grant_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="321" parent="32" name="References_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="322" parent="32" name="Index_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="323" parent="32" name="Alter_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="324" parent="32" name="Show_db_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="325" parent="32" name="Super_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="326" parent="32" name="Create_tmp_table_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="327" parent="32" name="Lock_tables_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="328" parent="32" name="Execute_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="329" parent="32" name="Repl_slave_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="330" parent="32" name="Repl_client_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="331" parent="32" name="Create_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="332" parent="32" name="Show_view_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="333" parent="32" name="Create_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="334" parent="32" name="Alter_routine_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="335" parent="32" name="Create_user_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="336" parent="32" name="Event_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="337" parent="32" name="Trigger_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="338" parent="32" name="Create_tablespace_priv"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="339" parent="32" name="ssl_type"> | |
<mandatory>1</mandatory> | |
<data-type>enum('', 'ANY', 'X509', 'SPECIFIED')</data-type> | |
<default-expression>''</default-expression> | |
</column> | |
<column id="340" parent="32" name="ssl_cipher"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="341" parent="32" name="x509_issuer"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="342" parent="32" name="x509_subject"> | |
<mandatory>1</mandatory> | |
<data-type>blob</data-type> | |
</column> | |
<column id="343" parent="32" name="max_questions"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="344" parent="32" name="max_updates"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="345" parent="32" name="max_connections"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="346" parent="32" name="max_user_connections"> | |
<mandatory>1</mandatory> | |
<data-type>int(11) unsigned</data-type> | |
<default-expression>'0'</default-expression> | |
</column> | |
<column id="347" parent="32" name="plugin"> | |
<mandatory>1</mandatory> | |
<data-type>char(64)</data-type> | |
<default-expression>'mysql_native_password'</default-expression> | |
</column> | |
<column id="348" parent="32" name="authentication_string"> | |
<data-type>text</data-type> | |
</column> | |
<column id="349" parent="32" name="password_expired"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<column id="350" parent="32" name="password_last_changed"> | |
<data-type>timestamp</data-type> | |
</column> | |
<column id="351" parent="32" name="password_lifetime"> | |
<data-type>smallint(5) unsigned</data-type> | |
</column> | |
<column id="352" parent="32" name="account_locked"> | |
<mandatory>1</mandatory> | |
<data-type>enum('N', 'Y')</data-type> | |
<default-expression>'N'</default-expression> | |
</column> | |
<key id="353" parent="32" name="PRIMARY"> | |
<columns>Host | |
User</columns> | |
<primary>1</primary> | |
</key> | |
</database-model> | |
</data-source> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="DataSourceManagerImpl" format="xml" hash="3732063901"> | |
<data-source source="LOCAL" name="MySQL - @localhost [2]" uuid="e10a677f-a0d6-45ec-a73e-acfa35c74480"> | |
<driver-ref>mysql</driver-ref> | |
<synchronize>true</synchronize> | |
<jdbc-driver>com.mysql.jdbc.Driver</jdbc-driver> | |
<jdbc-url>jdbc:mysql://localhost:3306/mysql</jdbc-url> | |
<driver-properties> | |
<property name="zeroDateTimeBehavior" value="convertToNull" /> | |
<property name="tinyInt1isBit" value="false" /> | |
<property name="characterEncoding" value="utf8" /> | |
<property name="characterSetResults" value="utf8" /> | |
<property name="yearIsDateType" value="false" /> | |
</driver-properties> | |
</data-source> | |
<data-source source="LOCAL" name="MySQL - mysql@localhost" uuid="e8658cf6-f50b-4bb3-8e76-03fda272f61b"> | |
<driver-ref>mysql</driver-ref> | |
<synchronize>true</synchronize> | |
<jdbc-driver>com.mysql.jdbc.Driver</jdbc-driver> | |
<jdbc-url>jdbc:mysql://localhost:3306/mysql</jdbc-url> | |
<driver-properties> | |
<property name="zeroDateTimeBehavior" value="convertToNull" /> | |
<property name="tinyInt1isBit" value="false" /> | |
<property name="characterEncoding" value="utf8" /> | |
<property name="characterSetResults" value="utf8" /> | |
<property name="yearIsDateType" value="false" /> | |
</driver-properties> | |
</data-source> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Encoding"> | |
<file url="PROJECT" charset="UTF-8" /> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="libraryTable"> | |
<library name="Java EE 6-Java EE 6"> | |
<CLASSES> | |
<root url="jar://$PROJECT_DIR$/lib/javax.annotation.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.ejb.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.jms.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.persistence.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.transaction.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.resource.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.servlet.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.servlet.jsp.jar!/" /> | |
<root url="jar://$PROJECT_DIR$/lib/javax.servlet.jsp.jstl.jar!/" /> | |
</CLASSES> | |
<JAVADOC /> | |
<SOURCES /> | |
</library> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="libraryTable"> | |
<library name="jstl:jstl:1.2" type="repository"> | |
<properties maven-id="jstl:jstl:1.2" /> | |
<CLASSES> | |
<root url="jar://$MAVEN_REPOSITORY$/jstl/jstl/1.2/jstl-1.2.jar!/" /> | |
</CLASSES> | |
<JAVADOC /> | |
<SOURCES /> | |
</library> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="libraryTable"> | |
<library name="Maven: mysql:mysql-connector-java:5.1.39"> | |
<CLASSES> | |
<root url="jar://$MAVEN_REPOSITORY$/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39.jar!/" /> | |
</CLASSES> | |
<JAVADOC> | |
<root url="jar://$MAVEN_REPOSITORY$/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39-javadoc.jar!/" /> | |
</JAVADOC> | |
<SOURCES> | |
<root url="jar://$MAVEN_REPOSITORY$/mysql/mysql-connector-java/5.1.39/mysql-connector-java-5.1.39-sources.jar!/" /> | |
</SOURCES> | |
</library> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="EntryPointsManager"> | |
<entry_points version="2.0" /> | |
</component> | |
<component name="MavenProjectsManager"> | |
<option name="originalFiles"> | |
<list> | |
<option value="$PROJECT_DIR$/pom.xml" /> | |
</list> | |
</option> | |
</component> | |
<component name="ProjectLevelVcsManager" settingsEditedManually="false"> | |
<OptionsSetting value="true" id="Add" /> | |
<OptionsSetting value="true" id="Remove" /> | |
<OptionsSetting value="true" id="Checkout" /> | |
<OptionsSetting value="true" id="Update" /> | |
<OptionsSetting value="true" id="Status" /> | |
<OptionsSetting value="true" id="Edit" /> | |
<ConfirmationsSetting value="0" id="Add" /> | |
<ConfirmationsSetting value="0" id="Remove" /> | |
</component> | |
<component name="ProjectRootManager" version="2" languageLevel="JDK_1_8" default="true" assert-keyword="true" jdk-15="true" project-jdk-name="1.8" project-jdk-type="JavaSDK"> | |
<output url="file://$PROJECT_DIR$/out" /> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="ProjectModuleManager"> | |
<modules> | |
<module fileurl="file://$PROJECT_DIR$/UserProgect.iml" filepath="$PROJECT_DIR$/UserProgect.iml" /> | |
</modules> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Palette2"> | |
<group name="Swing"> | |
<item class="com.intellij.uiDesigner.HSpacer" tooltip-text="Horizontal Spacer" icon="/com/intellij/uiDesigner/icons/hspacer.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="1" hsize-policy="6" anchor="0" fill="1" /> | |
</item> | |
<item class="com.intellij.uiDesigner.VSpacer" tooltip-text="Vertical Spacer" icon="/com/intellij/uiDesigner/icons/vspacer.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="1" anchor="0" fill="2" /> | |
</item> | |
<item class="javax.swing.JPanel" icon="/com/intellij/uiDesigner/icons/panel.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JScrollPane" icon="/com/intellij/uiDesigner/icons/scrollPane.png" removable="false" auto-create-binding="false" can-attach-label="true"> | |
<default-constraints vsize-policy="7" hsize-policy="7" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JButton" icon="/com/intellij/uiDesigner/icons/button.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="0" fill="1" /> | |
<initial-values> | |
<property name="text" value="Button" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JRadioButton" icon="/com/intellij/uiDesigner/icons/radioButton.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="RadioButton" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JCheckBox" icon="/com/intellij/uiDesigner/icons/checkBox.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="CheckBox" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JLabel" icon="/com/intellij/uiDesigner/icons/label.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="0" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="Label" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JTextField" icon="/com/intellij/uiDesigner/icons/textField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JPasswordField" icon="/com/intellij/uiDesigner/icons/passwordField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JFormattedTextField" icon="/com/intellij/uiDesigner/icons/formattedTextField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTextArea" icon="/com/intellij/uiDesigner/icons/textArea.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTextPane" icon="/com/intellij/uiDesigner/icons/textPane.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JEditorPane" icon="/com/intellij/uiDesigner/icons/editorPane.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JComboBox" icon="/com/intellij/uiDesigner/icons/comboBox.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="2" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JTable" icon="/com/intellij/uiDesigner/icons/table.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JList" icon="/com/intellij/uiDesigner/icons/list.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="2" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTree" icon="/com/intellij/uiDesigner/icons/tree.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTabbedPane" icon="/com/intellij/uiDesigner/icons/tabbedPane.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3"> | |
<preferred-size width="200" height="200" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JSplitPane" icon="/com/intellij/uiDesigner/icons/splitPane.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3"> | |
<preferred-size width="200" height="200" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JSpinner" icon="/com/intellij/uiDesigner/icons/spinner.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JSlider" icon="/com/intellij/uiDesigner/icons/slider.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JSeparator" icon="/com/intellij/uiDesigner/icons/separator.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JProgressBar" icon="/com/intellij/uiDesigner/icons/progressbar.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="0" fill="1" /> | |
</item> | |
<item class="javax.swing.JToolBar" icon="/com/intellij/uiDesigner/icons/toolbar.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="0" fill="1"> | |
<preferred-size width="-1" height="20" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JToolBar$Separator" icon="/com/intellij/uiDesigner/icons/toolbarSeparator.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="0" anchor="0" fill="1" /> | |
</item> | |
<item class="javax.swing.JScrollBar" icon="/com/intellij/uiDesigner/icons/scrollbar.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="0" anchor="0" fill="2" /> | |
</item> | |
</group> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="VcsDirectoryMappings"> | |
<mapping directory="$PROJECT_DIR$" vcs="Git" /> | |
</component> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PK ��5< |