sakila.mwb

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

  `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`category_id`)
) 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">{A359E7F0-BCAD-4FCD-A92D-7B771D9283C4}</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">{7B5DE48E-B894-4DEE-A0DC-EDC561077882}</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">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">{BC13EF72-473E-49DA-AD20-9FB3A4FAB3B7}</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">city</value>
                  <value type="string" key="oldName">city</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">{E8B45A8D-E639-4356-9503-78DB6FF087D8}</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">country_id</value>
                  <value type="string" key="oldName">country_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">{DC4B86E9-CA08-4C45-AED8-F0A695A4D67A}</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; (`country_id`) REFER `sakila/country`(`country_id`) ON UPD</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">{FF967531-7929-4F92-810F-1DD55B8D2B55}</value>
                  <value type="list" content-type="string" content-struct-name="db.mysql.Column" key="columns" option="ref">
                    <value type="string">{E8B45A8D-E639-4356-9503-78DB6FF087D8}</value>
                  </value>
                  <value type="string" key="deleteRule">RESTRICT</value>
                  <value type="string" key="name">fk_city_country</value>
                  <value type="string" key="oldName">fk_city_country</value>
                  <value type="list" content-type="string" key="referedColumnNames">
                    <value type="string">country_id</value>
                  </value>
                  <value type="list" content-type="string" content-struct-name="db.mysql.Column" key="referedColumns" option="ref">
                    <value type="string">{71BC5C46-365A-4780-A33E-7443D93220CF}</value>
                  </value>
                  <value type="string" key="referedTable" option="ref">{CF71E51D-C384-4E55-9622-B79DF93C3AC3}</value>
                  <value type="string" key="referedTableName">country</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">{91067C70-ADE6-45DD-B569-78B9D4B2AA54}</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">{A597ACA3-5687-414A-8A47-E0EC74FCF7EE}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">city_id</value>
                      <value type="string" key="owner" option="ref">{91067C70-ADE6-45DD-B569-78B9D4B2AA54}</value>
                      <value type="string" key="referedColumn" option="ref">{7B5DE48E-B894-4DEE-A0DC-EDC561077882}</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">{A359E7F0-BCAD-4FCD-A92D-7B771D9283C4}</value>
                  <value type="int" key="unique">1</value>
                </value>
                <value type="dict" struct-name="db.mysql.Index">
                  <value type="string" key="_id">{0D4B7CD4-A7E7-416E-A5FE-776DB7EFA1D0}</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">{C0715BB9-4DEF-4403-8F0E-2AB41C2827CD}</value>
                      <value type="int" key="descend">0</value>
                      <value type="string" key="name">country_id</value>
                      <value type="string" key="owner" option="ref">{0D4B7CD4-A7E7-416E-A5FE-776DB7EFA1D0}</value>
                      <value type="string" key="referedColumn" option="ref">{E8B45A8D-E639-4356-9503-78DB6FF087D8}</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_country_id</value>
                  <value type="string" key="oldName">idx_fk_country_id</value>
                  <value type="string" key="owner" option="ref">{A359E7F0-BCAD-4FCD-A92D-7B771D9283C4}</value>
                  <value type="int" key="unique">0</value>
                </value>
              </value>
              <value type="int" key="isTemporary">0</value>
              <value type="string" key="name">city</value>
              <value type="string" key="nextAutoInc">601</value>
              <value type="string" key="oldName">city</value>
              <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value>
              <value type="string" key="primaryKey" option="ref">{91067C70-ADE6-45DD-B569-78B9D4B2AA54}</value>
              <value type="string" key="rowFormat">Compact</value>
              <value type="string" key="sql">CREATE TABLE `city` (
  `city_id` smallint(5) unsigned NOT NULL auto_increment,
  `city` varchar(50) NOT NULL,
  `country_id` smallint(5) unsigned NOT NULL,
  `last_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`city_id`),
  KEY `idx_fk_country_id` (`country_id`),
  CONSTRAINT `fk_city_country` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_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">{CF71E51D-C384-4E55-9622-B79DF93C3AC3}</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">{71BC5C46-365A-4780-A33E-7443D93220CF}</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">country_id</value>
                  <value type="string" key="oldName">country_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">{FBA836FB-014E-4E53-BF89-3A705376CD16}</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">country</value>
                  <value type="string" key="oldName">country</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">{F7AEAFFD-CF8D-4ECD-B193-1CF27661BDF5}</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>
              </va