sakila.mwb

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

                  <value type="int" key="unsigned">0</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{0A11A691-18A5-4E43-94DE-EE5C4F74B643}</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">phone</value>
                  <value type="string" key="oldName">phone</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">{3C87C42B-3DB4-469C-8D56-5318258EDEFD}</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; (`city_id`) REFER `sakila/city`(`city_id`) ON UPDATE CASCA</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="dict" struct-name="db.mysql.ForeignKey">
                  <value type="string" key="_id">{D3116CB6-4B2E-47D8-9E3A-D6A7D9E403A5}</value>
                  <value type="list" content-type="string" content-struct-name="db.mysql.Column" key="columns" option="ref">
                    <value type="string">{4B8C6FAF-9283-4B52-9E04-FFA739AD9760}</value>
                  </value>
                  <value type="string" key="deleteRule">RESTRICT</value>
                  <value type="string" key="name">fk_address_city</value>
                  <value type="string" key="oldName">fk_address_city</value>
                  <value type="list" content-type="string" key="referedColumnNames">
                    <value type="string">city_id</value>
                  </value>
                  <value type="list" content-type="string" content-struct-name="db.mysql.Column" key="referedColumns" option="ref">
                    <value type="string">{7B5DE48E-B894-4DEE-A0DC-EDC561077882}</value>
                  </value>
                  <value type="string" key="referedTable" option="ref">{A359E7F0-BCAD-4FCD-A92D-7B771D9283C4}</value>
                  <value type="string" key="referedTableName">city</value>
                  <value type="string" key="updateRule">CASCADE</value>
                </value>
              </value>
              <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">{668B7671-6C28-40E6-9DAB-0F9C12B3FABC}</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">{ADDE86BD-13B0-460B-A49B-2603F5E1EA11}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">address_id</value>
                      <value type="string" key="owner" option="ref">{668B7671-6C28-40E6-9DAB-0F9C12B3FABC}</value>
                      <value type="string" key="referedColumn" option="ref">{F71C80BD-8778-44D0-AB46-7D3923FDA1C5}</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">{09101CD4-4F4E-4128-804D-DE894DC1AEE7}</value>
                  <value type="int" key="unique">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Index">
                  <value type="string" key="_id">{0BFF6B13-6630-4C19-871B-06987412F7C3}</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">{F32493B3-4263-48B8-B738-542225A7C604}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">city_id</value>
                      <value type="string" key="owner" option="ref">{0BFF6B13-6630-4C19-871B-06987412F7C3}</value>
                      <value type="string" key="referedColumn" option="ref">{4B8C6FAF-9283-4B52-9E04-FFA739AD9760}</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_fk_city_id</value>
                  <value type="string" key="oldName">idx_fk_city_id</value>
                  <value type="string" key="owner" option="ref">{09101CD4-4F4E-4128-804D-DE894DC1AEE7}</value>
                  <value type="int" key="unique">0</value>
                </value>
              </value>
              <value type="int" key="isTemporary">0</value>
              <value type="string" key="name">address</value>
              <value type="string" key="nextAutoInc">606</value>
              <value type="string" key="oldName">address</value>
              <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value>
              <value type="string" key="primaryKey" option="ref">{668B7671-6C28-40E6-9DAB-0F9C12B3FABC}</value>
              <value type="string" key="rowFormat">Compact</value>
              <value type="string" key="sql">CREATE TABLE `address` (
  `address_id` smallint(5) unsigned NOT NULL auto_increment,
  `address` varchar(50) NOT NULL,
  `address2` varchar(50) default NULL,
  `district` varchar(20) NOT NULL,
  `city_id` smallint(5) unsigned NOT NULL,
  `postal_code` varchar(10) default NULL,
  `phone` varchar(20) NOT NULL,
  `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`address_id`),
  KEY `idx_fk_city_id` (`city_id`),
  CONSTRAINT `fk_address_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`) ON UPDATE CASCADE
) 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">{BE985A57-844A-4EC9-8B43-2052524C94C4}</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">{3576B0FC-3B60-4FAB-9207-ACE8CD562324}</value>
                  <value type="int" key="autoIncrement">1</value>
                  <value type="string" key="comment"></value>
                  <value type="string" key="datatypeName">TINYINT</value>
                  <value type="int" key="defaultValueIsNull">1</value>
                  <value type="int" key="isNullable">0</value>
                  <value type="string" key="name">category_id</value>
                  <value type="string" key="oldName">category_id</value>
                  <value type="int" key="precision">3</value>
                  <value type="int" key="scale">0</value>
                  <value type="string" key="simpleType" option="ref">{3C75C19F-FCA4-44DE-8881-F477FEA32E62}</value>
                  <value type="int" key="unsigned">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Column">
                  <value type="string" key="_id">{0129D3CB-50D6-41D8-9FD5-A1779659E625}</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">25</value>
                  <value type="string" key="name">name</value>
                  <value type="string" key="oldName">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">{9F24038A-F67F-46DD-9E3A-DDFB31CA8940}</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">{BF82CE3E-6842-41A1-A169-23A1477365B5}</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">{01018920-A6EA-4D91-B21B-D3176A5684DA}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">category_id</value>
                      <value type="string" key="owner" option="ref">{BF82CE3E-6842-41A1-A169-23A1477365B5}</value>
                      <value type="string" key="referedColumn" option="ref">{3576B0FC-3B60-4FAB-9207-ACE8CD562324}</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">{BE985A57-844A-4EC9-8B43-2052524C94C4}</value>
                  <value type="int" key="unique">1</value>
                </value>
              </value>
              <value type="int" key="isTemporary">0</value>
              <value type="string" key="name">category</value>
              <value type="string" key="nextAutoInc">17</value>
              <value type="string" key="oldName">category</value>
              <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value>
              <value type="string" key="primaryKey" option="ref">{BF82CE3E-6842-41A1-A169-23A1477365B5}</value>
              <value type="string" key="rowFormat">Compact</value>
              <value type="string" key="sql">CREATE TABLE `category` (
  `category_id` tinyint(3) unsigned NOT NULL auto_increment,
  `name` varchar(25) NOT NULL,