sakila.mwb

这是MySQL官方测试用的数据库

                  <value type="int" key="precision">5</value>
                  <value type="int" key="scale">0</value>
                  <value type="string" key="simpleType" option="ref">{B98335A2-603F-4042-9D59-88248D987309}</value>
                  <value type="int" key="unsigned">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{B91AF3E0-C997-492B-A7DC-3A90CEC0F52F}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="collationName">utf8_general_ci</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">VARCHAR</value>
                  <value type="string" key="defaultValue">''</value>
                  <value type="int" key="defaultValueIsNull">0</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="int" key="length">45</value>
                  <value type="string" key="name">first_name</value>
                  <value type="string" key="oldName">first_name</value>
                  <value type="string" key="simpleType" option="ref">{7198A7BD-968D-4BD9-B85C-4DE7504F0D83}</value>
                  <value type="int" key="unsigned">0</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{D1364709-ACC4-4CBC-8A01-B8CD675E1F7F}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="collationName">utf8_general_ci</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">VARCHAR</value>
                  <value type="string" key="defaultValue">''</value>
                  <value type="int" key="defaultValueIsNull">0</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="int" key="length">45</value>
                  <value type="string" key="name">last_name</value>
                  <value type="string" key="oldName">last_name</value>
                  <value type="string" key="simpleType" option="ref">{7198A7BD-968D-4BD9-B85C-4DE7504F0D83}</value>
                  <value type="int" key="unsigned">0</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{73E909CE-6B87-4185-A262-8DE6430B1D78}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">TIMESTAMP</value>
                  <value type="string" key="defaultValue">CURRENT_TIMESTAMP</value>
                  <value type="int" key="defaultValueIsNull">0</value>
                  <value type="int" key="isNullable">1</value>
                  <value type="string" key="name">last_update</value>
                  <value type="string" key="oldName">last_update</value>
                  <value type="string" key="simpleType" option="ref">{D8A1FD40-794F-464E-8E4A-E14C38D9C924}</value>
                  <value type="int" key="unsigned">0</value>
                </value>
              </value>
              <value type="string" key="comment">InnoDB free: 6144 kB</value>
              <value type="string" key="defaultCharacterSetName">utf8</value>
              <value type="string" key="defaultCollationName">utf8_general_ci</value>
              <value type="list" content-type="dict" content-struct-name="db.mysql.ForeignKey" key="foreignKeys"/>
              <value type="list" content-type="dict" content-struct-name="db.mysql.Index" key="indices">
                <value type="dict" struct-name="db.mysql.Index">
                  <value type="string" key="_id">{50ABBA17-7C07-421C-ADE7-D69ECD08C23E}</value>
                  <value type="list" content-type="dict" content-struct-name="db.IndexColumn" key="columns">
                    <value type="dict" struct-name="db.mysql.IndexColumn">
                      <value type="string" key="_id">{5B68B792-A865-460D-93C6-9908921E099D}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">actor_id</value>
                      <value type="string" key="owner" option="ref">{50ABBA17-7C07-421C-ADE7-D69ECD08C23E}</value>
                      <value type="string" key="referedColumn" option="ref">{545E727B-A55B-4E9B-B6F4-FAFFC8C0E4A7}</value>
                    </value>
                  </value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="indexKind">PRIMARY</value>
                  <value type="string" key="indexType">BTREE</value>
                  <value type="int" key="isPrimary">1</value>
                  <value type="string" key="name">PRIMARY</value>
                  <value type="string" key="oldName">PRIMARY</value>
                  <value type="string" key="owner" option="ref">{D618AACE-8414-4FDB-92A6-EB49D25267F4}</value>
                  <value type="int" key="unique">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Index">
                  <value type="string" key="_id">{CED441C8-43B2-42E8-BA70-C035AA549B46}</value>
                  <value type="list" content-type="dict" content-struct-name="db.IndexColumn" key="columns">
                    <value type="dict" struct-name="db.mysql.IndexColumn">
                      <value type="string" key="_id">{942ED794-75D9-4F48-8BF6-593CC26FD5D1}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">last_name</value>
                      <value type="string" key="owner" option="ref">{CED441C8-43B2-42E8-BA70-C035AA549B46}</value>
                      <value type="string" key="referedColumn" option="ref">{D1364709-ACC4-4CBC-8A01-B8CD675E1F7F}</value>
                    </value>
                  </value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="indexKind"></value>
                  <value type="string" key="indexType">BTREE</value>
                  <value type="string" key="name">idx_actor_last_name</value>
                  <value type="string" key="oldName">idx_actor_last_name</value>
                  <value type="string" key="owner" option="ref">{D618AACE-8414-4FDB-92A6-EB49D25267F4}</value>
                  <value type="int" key="unique">0</value>
                </value>
              </value>
              <value type="int" key="isTemporary">0</value>
              <value type="string" key="name">actor</value>
              <value type="string" key="nextAutoInc">201</value>
              <value type="string" key="oldName">actor</value>
              <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value>
              <value type="string" key="primaryKey" option="ref">{50ABBA17-7C07-421C-ADE7-D69ECD08C23E}</value>
              <value type="string" key="rowFormat">Compact</value>
              <value type="string" key="sql">CREATE TABLE `actor` (
  `actor_id` smallint(5) unsigned NOT NULL auto_increment,
  `first_name` varchar(45) NOT NULL,
  `last_name` varchar(45) NOT NULL,
  `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`actor_id`),
  KEY `idx_actor_last_name` (`last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8</value>
              <value type="string" key="tableEngine">InnoDB</value>
              <value type="list" content-type="dict" content-struct-name="db.mysql.Trigger" key="triggers"/>
            </value>
            <value type="dict" struct-name="db.mysql.Table">
              <value type="string" key="_id">{09101CD4-4F4E-4128-804D-DE894DC1AEE7}</value>
              <value type="list" content-type="dict" content-struct-name="db.mysql.Column" key="columns">
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{F71C80BD-8778-44D0-AB46-7D3923FDA1C5}</value>
                  <value type="int" key="autoIncrement">1</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">SMALLINT</value>
                  <value type="int" key="defaultValueIsNull">1</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="string" key="name">address_id</value>
                  <value type="string" key="oldName">address_id</value>
                  <value type="int" key="precision">5</value>
                  <value type="int" key="scale">0</value>
                  <value type="string" key="simpleType" option="ref">{B98335A2-603F-4042-9D59-88248D987309}</value>
                  <value type="int" key="unsigned">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{AB7BD94E-6D2C-4C58-A2D9-198F819CCBEB}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="collationName">utf8_general_ci</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">VARCHAR</value>
                  <value type="string" key="defaultValue">''</value>
                  <value type="int" key="defaultValueIsNull">0</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="int" key="length">50</value>
                  <value type="string" key="name">address</value>
                  <value type="string" key="oldName">address</value>
                  <value type="string" key="simpleType" option="ref">{7198A7BD-968D-4BD9-B85C-4DE7504F0D83}</value>
                  <value type="int" key="unsigned">0</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{0925FCB2-B80C-41F1-A1EC-1F4EB263F2D7}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="collationName">utf8_general_ci</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">VARCHAR</value>
                  <value type="int" key="defaultValueIsNull">1</value>
                  <value type="int" key="isNullable">1</value>
                  <value type="int" key="length">50</value>
                  <value type="string" key="name">address2</value>
                  <value type="string" key="oldName">address2</value>
                  <value type="string" key="simpleType" option="ref">{7198A7BD-968D-4BD9-B85C-4DE7504F0D83}</value>
                  <value type="int" key="unsigned">0</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{472BDB44-C02F-46CE-9E97-2F23DAD95CCE}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="collationName">utf8_general_ci</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">VARCHAR</value>
                  <value type="string" key="defaultValue">''</value>
                  <value type="int" key="defaultValueIsNull">0</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="int" key="length">20</value>
                  <value type="string" key="name">district</value>
                  <value type="string" key="oldName">district</value>
                  <value type="string" key="simpleType" option="ref">{7198A7BD-968D-4BD9-B85C-4DE7504F0D83}</value>
                  <value type="int" key="unsigned">0</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{4B8C6FAF-9283-4B52-9E04-FFA739AD9760}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">SMALLINT</value>
                  <value type="string" key="defaultValue">''</value>
                  <value type="int" key="defaultValueIsNull">0</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="string" key="name">city_id</value>
                  <value type="string" key="oldName">city_id</value>
                  <value type="int" key="precision">5</value>
                  <value type="int" key="scale">0</value>
                  <value type="string" key="simpleType" option="ref">{B98335A2-603F-4042-9D59-88248D987309}</value>
                  <value type="int" key="unsigned">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{B5E9F6AC-BC17-4ADA-B255-BA08DCDA4319}</value>
                  <value type="int" key="autoIncrement">0</value>
                  <value type="string" key="collationName">utf8_general_ci</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">VARCHAR</value>
                  <value type="int" key="defaultValueIsNull">1</value>
                  <value type="int" key="isNullable">1</value>
                  <value type="int" key="length">10</value>
                  <value type="string" key="name">postal_code</value>
                  <value type="string" key="oldName">postal_code</value>
                  <value type="string" key="simpleType" option="ref">{7198A7BD-968D-4BD9-B85C-4DE7504F0D83}</value>