testing/test-suite/data/diff/sakila-db/sakila-schema.xml (4,503 lines of code) (raw):

<?xml version="1.0"?> <data> <value type="object" struct-name="db.mysql.Catalog" id="{0F7C6BD2-338E-4DFC-9D02-F6AE3A3DC716}" struct-checksum="0x349e4fa4"> <value _ptr_="02697C00" type="list" content-type="object" content-struct-name="db.CharacterSet" key="characterSets"/> <value type="string" key="comment"></value> <value _ptr_="02691F90" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName">utf8_general_ci</value> <value _ptr_="02694DD0" type="list" content-type="object" content-struct-name="db.mysql.LogFileGroup" key="logFileGroups"/> <value type="string" key="name"></value> <value type="string" key="oldName"></value> <value _ptr_="02694B00" type="list" content-type="object" content-struct-name="db.Role" key="roles"/> <value _ptr_="02694DE8" type="list" content-type="object" content-struct-name="db.mysql.Schema" key="schemata"> <value type="object" struct-name="db.mysql.Schema" id="{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}" struct-checksum="0x5abd3a2d"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="02698290" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName">utf8_general_ci</value> <value type="string" key="name">sakila</value> <value type="string" key="oldName">sakila</value> <link type="object" struct-name="db.mysql.Catalog" key="owner">{0F7C6BD2-338E-4DFC-9D02-F6AE3A3DC716}</link> <value _ptr_="026981B8" type="list" content-type="object" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"/> <value _ptr_="026980F8" type="list" content-type="object" content-struct-name="db.mysql.Routine" key="routines"> <value type="object" struct-name="db.mysql.Routine" id="{833F49BA-C006-4DA6-85E8-6B2A960B5311}" struct-checksum="0x461bebc2"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3B00" type="dict" key="customData"/> <value type="string" key="name">rewards_report</value> <value type="string" key="oldName">rewards_report</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value _ptr_="026B3E00" type="list" content-type="object" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="object" struct-name="db.mysql.RoutineParam" id="{41FC3C76-DE22-421B-A085-BCD820DEB33E}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">TINYINT UNSIGNED </value> <value type="string" key="name">min_monthly_purchases</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{833F49BA-C006-4DA6-85E8-6B2A960B5311}</link> <value type="string" key="paramType">IN</value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{7A0C2521-27B2-4B4C-BF7F-A222AFC2FF1E}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">DECIMAL ( 10 , 2 ) UNSIGNED </value> <value type="string" key="name">min_dollar_amount_purchased</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{833F49BA-C006-4DA6-85E8-6B2A960B5311}</link> <value type="string" key="paramType">IN</value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{5527FBB1-E1D6-4AE4-B317-ECA0847BBFDE}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">count_rewardees</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{833F49BA-C006-4DA6-85E8-6B2A960B5311}</link> <value type="string" key="paramType">OUT</value> </value> </value> <value type="string" key="returnDatatype"></value> <value type="string" key="routineType">procedure</value> <value type="string" key="security"></value> <value type="string" key="sqlDefinition">CREATE PROCEDURE rewards_report ( IN min_monthly_purchases TINYINT UNSIGNED , IN min_dollar_amount_purchased DECIMAL(10,2) UNSIGNED , OUT count_rewardees INT ) LANGUAGE SQL NOT DETERMINISTIC READS SQL DATA SQL SECURITY DEFINER COMMENT 'Provides a customizable report on best customers' proc: BEGIN DECLARE last_month_start DATE; DECLARE last_month_end DATE; /* Some sanity checks... */ IF min_monthly_purchases = 0 THEN SELECT 'Minimum monthly purchases parameter must be &gt; 0'; LEAVE proc; END IF; IF min_dollar_amount_purchased = 0.00 THEN SELECT 'Minimum monthly dollar amount purchased parameter must be &gt; $0.00'; LEAVE proc; END IF; /* Determine start and end time periods */ SET last_month_start = DATE_SUB(CURRENT_DATE(), INTERVAL 1 MONTH); SET last_month_start = STR_TO_DATE(CONCAT(YEAR(last_month_start),'-',MONTH(last_month_start),'-01'),'%Y-%m-%d'); SET last_month_end = LAST_DAY(last_month_start); /* Create a temporary storage area for Customer IDs. */ CREATE TEMPORARY TABLE tmpCustomer (customer_id SMALLINT UNSIGNED NOT NULL PRIMARY KEY); /* Find all customers meeting the monthly purchase requirements */ INSERT INTO tmpCustomer (customer_id) SELECT p.customer_id FROM payment AS p WHERE DATE(p.payment_date) BETWEEN last_month_start AND last_month_end GROUP BY customer_id HAVING SUM(p.amount) &gt; min_dollar_amount_purchased AND COUNT(customer_id) &gt; min_monthly_purchases; /* Populate OUT parameter with count of found customers */ SELECT COUNT(*) FROM tmpCustomer INTO count_rewardees; /* Output ALL customer information of matching rewardees. Customize output as needed. */ SELECT c.* FROM tmpCustomer AS t INNER JOIN customer AS c ON t.customer_id = c.customer_id; /* Clean up */ DROP TABLE tmpCustomer; END </value> <value type="string" key="temp_sql"></value> </value> <link type="object" struct-name="db.mysql.Routine">{833F49BA-C006-4DA6-85E8-6B2A960B5311}</link> <value type="object" struct-name="db.mysql.Routine" id="{C4D6F63E-B31D-4B9E-B79D-1AC3748FE092}" struct-checksum="0x461bebc2"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3CF8" type="dict" key="customData"/> <value type="string" key="name">get_customer_balance</value> <value type="string" key="oldName">get_customer_balance</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value _ptr_="026B4078" type="list" content-type="object" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="object" struct-name="db.mysql.RoutineParam" id="{B24B107A-8B5A-4FCB-951F-46D6F54A7F33}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_customer_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{C4D6F63E-B31D-4B9E-B79D-1AC3748FE092}</link> <value type="string" key="paramType"></value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{3BEEBA13-0A6F-4927-BBA4-8EB2E7256C67}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">DATETIME </value> <value type="string" key="name">p_effective_date</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{C4D6F63E-B31D-4B9E-B79D-1AC3748FE092}</link> <value type="string" key="paramType"></value> </value> </value> <value type="string" key="returnDatatype">DECIMAL ( 5 , 2 ) </value> <value type="string" key="routineType">function</value> <value type="string" key="security"></value> <value type="string" key="sqlDefinition">CREATE FUNCTION get_customer_balance(p_customer_id INT, p_effective_date DATETIME) RETURNS DECIMAL(5,2) DETERMINISTIC READS SQL DATA BEGIN #OK, WE NEED TO CALCULATE THE CURRENT BALANCE GIVEN A CUSTOMER_ID AND A DATE #THAT WE WANT THE BALANCE TO BE EFFECTIVE FOR. THE BALANCE IS: # 1) RENTAL FEES FOR ALL PREVIOUS RENTALS # 2) ONE DOLLAR FOR EVERY DAY THE PREVIOUS RENTALS ARE OVERDUE # 3) IF A FILM IS MORE THAN RENTAL_DURATION * 2 OVERDUE, CHARGE THE REPLACEMENT_COST # 4) SUBTRACT ALL PAYMENTS MADE BEFORE THE DATE SPECIFIED DECLARE v_rentfees DECIMAL(5,2); #FEES PAID TO RENT THE VIDEOS INITIALLY DECLARE v_overfees INTEGER; #LATE FEES FOR PRIOR RENTALS DECLARE v_payments DECIMAL(5,2); #SUM OF PAYMENTS MADE PREVIOUSLY SELECT IFNULL(SUM(film.rental_rate),0) INTO v_rentfees FROM film, inventory, rental WHERE film.film_id = inventory.film_id AND inventory.inventory_id = rental.inventory_id AND rental.rental_date &lt;= p_effective_date AND rental.customer_id = p_customer_id; SELECT IFNULL(SUM(IF((TO_DAYS(rental.return_date) - TO_DAYS(rental.rental_date)) &gt; film.rental_duration, ((TO_DAYS(rental.return_date) - TO_DAYS(rental.rental_date)) - film.rental_duration),0)),0) INTO v_overfees FROM rental, inventory, film WHERE film.film_id = inventory.film_id AND inventory.inventory_id = rental.inventory_id AND rental.rental_date &lt;= p_effective_date AND rental.customer_id = p_customer_id; SELECT IFNULL(SUM(payment.amount),0) INTO v_payments FROM payment WHERE payment.payment_date &lt;= p_effective_date AND payment.customer_id = p_customer_id; RETURN v_rentfees + v_overfees - v_payments; END </value> <value type="string" key="temp_sql"></value> </value> <link type="object" struct-name="db.mysql.Routine">{C4D6F63E-B31D-4B9E-B79D-1AC3748FE092}</link> <value type="object" struct-name="db.mysql.Routine" id="{1A61A853-4E9B-4D6B-A010-EBC8700BCCFF}" struct-checksum="0x461bebc2"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B41E0" type="dict" key="customData"/> <value type="string" key="name">film_in_stock</value> <value type="string" key="oldName">film_in_stock</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value _ptr_="026B4168" type="list" content-type="object" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="object" struct-name="db.mysql.RoutineParam" id="{868198D0-E3A8-4B54-9527-09EA25F17CAA}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_film_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{1A61A853-4E9B-4D6B-A010-EBC8700BCCFF}</link> <value type="string" key="paramType">IN</value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{AE3435EA-BC40-4329-A504-9769FDB99DD5}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_store_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{1A61A853-4E9B-4D6B-A010-EBC8700BCCFF}</link> <value type="string" key="paramType">IN</value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{08DA1429-BE6F-4004-B2A9-C914BD3E2E0A}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_film_count</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{1A61A853-4E9B-4D6B-A010-EBC8700BCCFF}</link> <value type="string" key="paramType">OUT</value> </value> </value> <value type="string" key="returnDatatype"></value> <value type="string" key="routineType">procedure</value> <value type="string" key="security"></value> <value type="string" key="sqlDefinition">CREATE PROCEDURE film_in_stock(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT) READS SQL DATA BEGIN SELECT inventory_id FROM inventory WHERE film_id = p_film_id AND store_id = p_store_id AND inventory_in_stock(inventory_id); SELECT FOUND_ROWS() INTO p_film_count; END </value> <value type="string" key="temp_sql"></value> </value> <link type="object" struct-name="db.mysql.Routine">{1A61A853-4E9B-4D6B-A010-EBC8700BCCFF}</link> <value type="object" struct-name="db.mysql.Routine" id="{AD6964E6-8E6D-448F-9E20-0B8EBFEBD7EF}" struct-checksum="0x461bebc2"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B42B8" type="dict" key="customData"/> <value type="string" key="name">film_not_in_stock</value> <value type="string" key="oldName">film_not_in_stock</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value _ptr_="026B4420" type="list" content-type="object" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="object" struct-name="db.mysql.RoutineParam" id="{ED007EA5-3F82-44A5-B47E-ADE6EA8251CA}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_film_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{AD6964E6-8E6D-448F-9E20-0B8EBFEBD7EF}</link> <value type="string" key="paramType">IN</value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{97219EED-13D7-48EB-A8E4-83F192A1F31E}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_store_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{AD6964E6-8E6D-448F-9E20-0B8EBFEBD7EF}</link> <value type="string" key="paramType">IN</value> </value> <value type="object" struct-name="db.mysql.RoutineParam" id="{468ABAD3-EE90-4032-856A-51D34824A44C}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_film_count</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{AD6964E6-8E6D-448F-9E20-0B8EBFEBD7EF}</link> <value type="string" key="paramType">OUT</value> </value> </value> <value type="string" key="returnDatatype"></value> <value type="string" key="routineType">procedure</value> <value type="string" key="security"></value> <value type="string" key="sqlDefinition">CREATE PROCEDURE film_not_in_stock(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT) READS SQL DATA BEGIN SELECT inventory_id FROM inventory WHERE film_id = p_film_id AND store_id = p_store_id AND NOT inventory_in_stock(inventory_id); SELECT FOUND_ROWS() INTO p_film_count; END </value> <value type="string" key="temp_sql"></value> </value> <link type="object" struct-name="db.mysql.Routine">{AD6964E6-8E6D-448F-9E20-0B8EBFEBD7EF}</link> <value type="object" struct-name="db.mysql.Routine" id="{76F82B77-70F2-42E6-8014-A6BE80BA5CB5}" struct-checksum="0x461bebc2"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B4510" type="dict" key="customData"/> <value type="string" key="name">inventory_held_by_customer</value> <value type="string" key="oldName">inventory_held_by_customer</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value _ptr_="026B4678" type="list" content-type="object" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="object" struct-name="db.mysql.RoutineParam" id="{049415B8-59D0-4E32-8746-9A8F1A773A35}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_inventory_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{76F82B77-70F2-42E6-8014-A6BE80BA5CB5}</link> <value type="string" key="paramType"></value> </value> </value> <value type="string" key="returnDatatype">INT </value> <value type="string" key="routineType">function</value> <value type="string" key="security"></value> <value type="string" key="sqlDefinition">CREATE FUNCTION inventory_held_by_customer(p_inventory_id INT) RETURNS INT READS SQL DATA BEGIN DECLARE v_customer_id INT; DECLARE EXIT HANDLER FOR NOT FOUND RETURN NULL; SELECT customer_id INTO v_customer_id FROM rental WHERE return_date IS NULL AND inventory_id = p_inventory_id; RETURN v_customer_id; END </value> <value type="string" key="temp_sql"></value> </value> <link type="object" struct-name="db.mysql.Routine">{76F82B77-70F2-42E6-8014-A6BE80BA5CB5}</link> <value type="object" struct-name="db.mysql.Routine" id="{DD6713AC-A745-4A4E-A464-F0F30DF8C909}" struct-checksum="0x461bebc2"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B4738" type="dict" key="customData"/> <value type="string" key="name">inventory_in_stock</value> <value type="string" key="oldName">inventory_in_stock</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value _ptr_="026B48A0" type="list" content-type="object" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="object" struct-name="db.mysql.RoutineParam" id="{EE8A1BBF-1C61-4E2B-A2F5-FCB13CE98FA4}" struct-checksum="0xd83c9554"> <value type="string" key="datatype">INT </value> <value type="string" key="name">p_inventory_id</value> <link type="object" struct-name="db.mysql.Routine" key="owner">{DD6713AC-A745-4A4E-A464-F0F30DF8C909}</link> <value type="string" key="paramType"></value> </value> </value> <value type="string" key="returnDatatype">BOOLEAN </value> <value type="string" key="routineType">function</value> <value type="string" key="security"></value> <value type="string" key="sqlDefinition">CREATE FUNCTION inventory_in_stock(p_inventory_id INT) RETURNS BOOLEAN READS SQL DATA BEGIN DECLARE v_rentals INT; DECLARE v_out INT; #AN ITEM IS IN-STOCK IF THERE ARE EITHER NO ROWS IN THE rental TABLE #FOR THE ITEM OR ALL ROWS HAVE return_date POPULATED SELECT COUNT(*) INTO v_rentals FROM rental WHERE inventory_id = p_inventory_id; IF v_rentals = 0 THEN RETURN TRUE; END IF; SELECT COUNT(rental_id) INTO v_out FROM inventory LEFT JOIN rental USING(inventory_id) WHERE inventory.inventory_id = p_inventory_id AND rental.return_date IS NULL; IF v_out &gt; 0 THEN RETURN FALSE; ELSE RETURN TRUE; END IF; END </value> <value type="string" key="temp_sql"></value> </value> <link type="object" struct-name="db.mysql.Routine">{DD6713AC-A745-4A4E-A464-F0F30DF8C909}</link> </value> <value _ptr_="02697F18" type="list" content-type="object" content-struct-name="db.mysql.Sequence" key="sequences"/> <value _ptr_="026980C8" type="list" content-type="object" content-struct-name="db.mysql.StructuredDatatype" key="structuredTypes"/> <value _ptr_="02697C48" type="list" content-type="object" content-struct-name="db.mysql.Synonym" key="synonyms"/> <value _ptr_="02698218" type="list" content-type="object" content-struct-name="db.mysql.Table" key="tables"> <value type="object" struct-name="db.mysql.Table" id="{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026982A8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{DFA61474-2F17-4767-B583-D2A2C461CE77}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698398" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026984E8" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">actor_id</value> <value type="string" key="oldName">actor_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{B033A97D-45D4-40AA-8AAC-6D3D4728D14E}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698440" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026986E0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">45</value> <value type="string" key="name">first_name</value> <value type="string" key="oldName">first_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{DA2A35A3-B12C-4704-8D5E-E378F2889174}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698698" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026983C8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">45</value> <value type="string" key="name">last_name</value> <value type="string" key="oldName">last_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{730368FF-AD73-4EDF-8DCF-2993C59F136C}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698758" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026985F0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026980E0" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026983F8" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"/> <value _ptr_="02698470" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{AECE2235-4C0B-4ED1-A220-73D6BEED77F4}" struct-checksum="0x416e09b2"> <value _ptr_="02698590" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{4C9621B8-412E-42C0-BF8B-7113607AA268}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">actor_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{AECE2235-4C0B-4ED1-A220-73D6BEED77F4}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{DFA61474-2F17-4767-B583-D2A2C461CE77}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{8AB6A28F-7002-4F09-BCB4-B542743094D8}" struct-checksum="0x416e09b2"> <value _ptr_="026987B8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{601D809A-0F42-492E-94EA-31082BE4364C}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">last_name</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8AB6A28F-7002-4F09-BCB4-B542743094D8}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{DA2A35A3-B12C-4704-8D5E-E378F2889174}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_actor_last_name</value> <value type="string" key="oldName">idx_actor_last_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">actor</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">actor</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="02698458" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{AECE2235-4C0B-4ED1-A220-73D6BEED77F4}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="02698530" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{1879C47C-3195-4D5D-BBB2-52F861850C4A}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="02698890" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{F5230F5F-10C7-4EBC-B166-86BF3095BE95}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698AB8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02698BC0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">address_id</value> <value type="string" key="oldName">address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{F12B1390-16A1-4225-9D40-FB74A496F104}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698A88" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02698AA0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">50</value> <value type="string" key="name">address</value> <value type="string" key="oldName">address</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{9472E08E-0268-47DA-B496-3D308A141840}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698CE0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="02698DD0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">50</value> <value type="string" key="name">address2</value> <value type="string" key="oldName">address2</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{71312439-95A6-4E8D-A297-A1B34D0EE9D0}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698DB8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02698E00" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">20</value> <value type="string" key="name">district</value> <value type="string" key="oldName">district</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{902ECDD0-ACB6-4DEF-88B3-262488EF6E8A}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02698C98" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02699078" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">city_id</value> <value type="string" key="oldName">city_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{7B544189-EADC-41FA-B224-4A085AA11587}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02699048" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="02698F80" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">10</value> <value type="string" key="name">postal_code</value> <value type="string" key="oldName">postal_code</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{2BD8C91A-982B-47B9-84DD-2334BA27B819}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026990F0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02698F50" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">20</value> <value type="string" key="name">phone</value> <value type="string" key="oldName">phone</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{E2E9D4CB-CE17-4AB6-92D0-BBFEDD4E9A05}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02699318" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026991B0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026987D0" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="02698818" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{F3BB0AE9-E466-41F9-A115-4E0ACDD4DFE9}" struct-checksum="0x9784ee86"> <value _ptr_="02699390" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{902ECDD0-ACB6-4DEF-88B3-262488EF6E8A}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_address_city</value> <value type="string" key="oldName">fk_address_city</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value _ptr_="026993C0" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <value type="object" struct-name="db.mysql.Column" id="{8038BFD3-5109-45C9-90CF-51EA618A3160}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="02699B40" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02699C48" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">city_id</value> <value type="string" key="oldName">city_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="02698A28" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{D96BD281-773D-47E6-AB2C-E1A24C07646E}" struct-checksum="0x416e09b2"> <value _ptr_="02699180" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{B42BEB30-838A-4A15-B8DA-CC8CD0F6E346}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">address_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{D96BD281-773D-47E6-AB2C-E1A24C07646E}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{F5230F5F-10C7-4EBC-B166-86BF3095BE95}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{44E8DAA7-8F50-4AA3-83D7-2F79CFC96EDB}" struct-checksum="0x416e09b2"> <value _ptr_="02699378" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{839F2C93-A045-4694-96C3-4ECD5D1706F0}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">city_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{44E8DAA7-8F50-4AA3-83D7-2F79CFC96EDB}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{902ECDD0-ACB6-4DEF-88B3-262488EF6E8A}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_city_id</value> <value type="string" key="oldName">idx_fk_city_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">address</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">address</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="02698AD0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{D96BD281-773D-47E6-AB2C-E1A24C07646E}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="02698B18" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{036772C9-3C95-49F9-8DE5-2F9B14913CDD}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="02699480" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{4D0A9386-8A60-4277-8532-B9E6964F1358}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026997F8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026996A8" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">category_id</value> <value type="string" key="oldName">category_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{036772C9-3C95-49F9-8DE5-2F9B14913CDD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{B632DEE1-0F96-475A-8A88-25EADA6623DC}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026997B0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026996C0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">25</value> <value type="string" key="name">name</value> <value type="string" key="oldName">name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{036772C9-3C95-49F9-8DE5-2F9B14913CDD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{927EDD98-1EA1-4E20-9267-43522E899478}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026998B8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02699A50" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{036772C9-3C95-49F9-8DE5-2F9B14913CDD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="02699558" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026993D8" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"/> <value _ptr_="026994C8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{1573C652-22A5-493F-A461-CB2FCFC5CA92}" struct-checksum="0x416e09b2"> <value _ptr_="02699930" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{03D5F4CF-3B46-49DB-9FF1-0A1551E35A3E}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">category_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{1573C652-22A5-493F-A461-CB2FCFC5CA92}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{4D0A9386-8A60-4277-8532-B9E6964F1358}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{036772C9-3C95-49F9-8DE5-2F9B14913CDD}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">category</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">category</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="02699450" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{1573C652-22A5-493F-A461-CB2FCFC5CA92}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="02699630" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="02699A08" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{8038BFD3-5109-45C9-90CF-51EA618A3160}</link> <value type="object" struct-name="db.mysql.Column" id="{AB62FA38-1503-494B-B474-40F312CCFE7F}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02699B10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02699B28" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">50</value> <value type="string" key="name">city</value> <value type="string" key="oldName">city</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{7DB478FD-7C56-485F-8422-F8207E244DCD}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02699D68" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02699E58" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">country_id</value> <value type="string" key="oldName">country_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{F7CA717C-70E0-4B79-A6A0-806097505B6F}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="02699E28" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="02699ED0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="02699840" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="02699900" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{A5561055-9FBA-4B82-8F37-88BA785F8BA6}" struct-checksum="0x9784ee86"> <value _ptr_="0269A0E0" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{7DB478FD-7C56-485F-8422-F8207E244DCD}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_city_country</value> <value type="string" key="oldName">fk_city_country</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value _ptr_="0269A098" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <value type="object" struct-name="db.mysql.Column" id="{3DA34F05-5C4C-48DA-82CF-45566062D6B3}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269A368" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269A380" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">country_id</value> <value type="string" key="oldName">country_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D4F06406-F13A-4128-993F-4ECA9B57620E}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{D4F06406-F13A-4128-993F-4ECA9B57620E}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="02699AB0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{18BA2C13-AB7B-4074-B51E-AC7153D23E0C}" struct-checksum="0x416e09b2"> <value _ptr_="02699CF0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{FEF9BD6D-7237-48BD-BE78-7799AA75597D}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">city_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{18BA2C13-AB7B-4074-B51E-AC7153D23E0C}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{8038BFD3-5109-45C9-90CF-51EA618A3160}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{FA466D42-2B16-4A5A-A939-F2A461855840}" struct-checksum="0x416e09b2"> <value _ptr_="02699F78" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{29E55D05-3011-4228-8525-A63C2618DDB9}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">country_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{FA466D42-2B16-4A5A-A939-F2A461855840}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{7DB478FD-7C56-485F-8422-F8207E244DCD}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_country_id</value> <value type="string" key="oldName">idx_fk_country_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{988C1362-3F98-4B32-B2CD-E55E1A3DE5E6}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">city</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">city</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="02699B58" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{18BA2C13-AB7B-4074-B51E-AC7153D23E0C}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="02699BA0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{D4F06406-F13A-4128-993F-4ECA9B57620E}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="0269A398" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{3DA34F05-5C4C-48DA-82CF-45566062D6B3}</link> <value type="object" struct-name="db.mysql.Column" id="{3BF24386-8DB5-4F36-8AB1-B76BB8E91729}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269A578" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269A458" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">50</value> <value type="string" key="name">country</value> <value type="string" key="oldName">country</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D4F06406-F13A-4128-993F-4ECA9B57620E}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{52AF49F4-0CA3-4831-8078-79CEF5DCD809}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269A518" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269A548" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D4F06406-F13A-4128-993F-4ECA9B57620E}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="0269A338" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="0269A188" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"/> <value _ptr_="0269A200" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{DEDBD1CD-E29E-4F6C-874B-44F43A20ADA3}" struct-checksum="0x416e09b2"> <value _ptr_="0269A2C0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{94D99E8B-B9B3-40F7-9592-F538DC25B04B}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">country_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{DEDBD1CD-E29E-4F6C-874B-44F43A20ADA3}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{3DA34F05-5C4C-48DA-82CF-45566062D6B3}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D4F06406-F13A-4128-993F-4ECA9B57620E}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">country</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">country</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="0269A410" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{DEDBD1CD-E29E-4F6C-874B-44F43A20ADA3}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="0269A248" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{EED8BABD-0736-4A55-85A9-D2B09B589CC7}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="0269A890" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{B3FAFCA5-8235-4513-90F9-B94FD00D1B2C}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269A488" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269AA70" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">customer_id</value> <value type="string" key="oldName">customer_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{C0B2DD5C-DEC2-4BAE-B6C8-8562FC3A6377}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AA28" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269A9E0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">store_id</value> <value type="string" key="oldName">store_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{46182384-82B8-4CE4-A55B-0067AC600921}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AAA0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269A908" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">45</value> <value type="string" key="name">first_name</value> <value type="string" key="oldName">first_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{DAF610CA-E79C-44E0-B220-091AF2C50DF7}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269ABA8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269AD40" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">45</value> <value type="string" key="name">last_name</value> <value type="string" key="oldName">last_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{15E080BF-3C5E-4CD7-A34E-B9A76F372CCE}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AB60" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="0269AC80" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">50</value> <value type="string" key="name">email</value> <value type="string" key="oldName">email</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{55E08BB7-DAEA-4030-A800-1EFC350ACB20}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AD70" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269AB90" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">address_id</value> <value type="string" key="oldName">address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{B6146337-0C93-44E3-B422-C0FD638C243E}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AED8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">TRUE </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269ADB8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">active</value> <value type="string" key="oldName">active</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.boolean</link> </value> <value type="object" struct-name="db.mysql.Column" id="{100135C7-1A44-47E1-9EA2-CA9D2770EA28}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AE78" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269AEA8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">create_date</value> <value type="string" key="oldName">create_date</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.datetime</link> </value> <value type="object" struct-name="db.mysql.Column" id="{435BC342-909E-448D-93F4-CE1B2D4A2DF7}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269AA58" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269AF68" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="0269A6C8" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="0269A6F8" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{14DD6D3B-76C1-4194-AA85-119A31DD1F6B}" struct-checksum="0x9784ee86"> <value _ptr_="0269B318" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{55E08BB7-DAEA-4030-A800-1EFC350ACB20}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_customer_address</value> <value type="string" key="oldName">fk_customer_address</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value _ptr_="0269B2A0" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{F5230F5F-10C7-4EBC-B166-86BF3095BE95}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{DD4990A4-51D6-4662-9322-6D0136354201}" struct-checksum="0x9784ee86"> <value _ptr_="0269B660" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{C0B2DD5C-DEC2-4BAE-B6C8-8562FC3A6377}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_customer_store</value> <value type="string" key="oldName">fk_customer_store</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value _ptr_="0269B408" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <value type="object" struct-name="db.mysql.Column" id="{46DA8071-7EE7-45A5-9691-6117CFA8E6A1}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2F78" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B3188" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">store_id</value> <value type="string" key="oldName">store_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="0269A8C0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{F4E46634-1C9D-4F9A-B76D-A965FAC46C94}" struct-checksum="0x416e09b2"> <value _ptr_="0269B030" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{495BD2E7-49CD-49FF-AA5C-2B26B05EA739}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">customer_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{F4E46634-1C9D-4F9A-B76D-A965FAC46C94}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{B3FAFCA5-8235-4513-90F9-B94FD00D1B2C}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{97C3BD31-D21E-46DA-B412-DDFCB5891786}" struct-checksum="0x416e09b2"> <value _ptr_="0269B078" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{ED055FC3-E022-4D84-91A4-9FE2176C6FFD}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">store_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{97C3BD31-D21E-46DA-B412-DDFCB5891786}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{C0B2DD5C-DEC2-4BAE-B6C8-8562FC3A6377}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_store_id</value> <value type="string" key="oldName">idx_fk_store_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{012F6C96-D7A2-4617-AF2E-F08F396D55A0}" struct-checksum="0x416e09b2"> <value _ptr_="0269B210" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{1B645F46-B3FD-4704-B6EA-A24EF0693A0F}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">address_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{012F6C96-D7A2-4617-AF2E-F08F396D55A0}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{55E08BB7-DAEA-4030-A800-1EFC350ACB20}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_address_id</value> <value type="string" key="oldName">idx_fk_address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{8B1E2E60-A936-45F4-829B-E09F0ED4C5D3}" struct-checksum="0x416e09b2"> <value _ptr_="0269B2E8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{58F9F44B-4543-41B5-9236-FA68988EF661}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">last_name</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8B1E2E60-A936-45F4-829B-E09F0ED4C5D3}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{DAF610CA-E79C-44E0-B220-091AF2C50DF7}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_last_name</value> <value type="string" key="oldName">idx_last_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">customer</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">customer</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="0269A7E8" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{F4E46634-1C9D-4F9A-B76D-A965FAC46C94}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="0269A698" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{7121305C-D04D-479A-BFE5-D5C01DBA85AF}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="0269B5B8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{DE5F317A-B544-421C-9F5B-D9D505A17F30}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269B900" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269B750" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">film_id</value> <value type="string" key="oldName">film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{5DF0C36E-ECAA-437C-8D53-E2BC47A2C142}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269B8E8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269B8A0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">255</value> <value type="string" key="name">title</value> <value type="string" key="oldName">title</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{769BB39D-4AFB-4A56-848C-7D1FB35C9613}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269B9C0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="0269BBA0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">description</value> <value type="string" key="oldName">description</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.text</link> </value> <value type="object" struct-name="db.mysql.Column" id="{23EA2716-2BB9-49C5-96AA-2D369895B161}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269BA50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="0269BB28" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">release_year</value> <value type="string" key="oldName">release_year</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.year</link> </value> <value type="object" struct-name="db.mysql.Column" id="{255FA0B8-D34C-4D42-BDB9-246275CB779D}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269B960" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269BB40" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">language_id</value> <value type="string" key="oldName">language_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{BD3C8157-34C6-4027-9725-D30FB79DFE1A}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269BD50" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="0269BC48" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">original_language_id</value> <value type="string" key="oldName">original_language_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{757F3DB5-3DAC-4F14-837D-DCBC5F247BE7}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269BCD8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">3 </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269B990" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">rental_duration</value> <value type="string" key="oldName">rental_duration</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{4D3409DC-784B-49F2-B742-0F92FBBE5083}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269BD80" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">4.99 </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269BDB0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">rental_rate</value> <value type="string" key="oldName">rental_rate</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">4</value> <value type="int" key="scale">2</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.decimal</link> </value> <value type="object" struct-name="db.mysql.Column" id="{3F2F069C-BADA-4AF0-98EA-1E462C786647}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269BF90" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="0269BE28" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">length</value> <value type="string" key="oldName">length</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{B9BDC708-834D-4D73-9120-87117CB582DB}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269BF48" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">19.99 </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269BFC0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">replacement_cost</value> <value type="string" key="oldName">replacement_cost</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">5</value> <value type="int" key="scale">2</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.decimal</link> </value> <value type="object" struct-name="db.mysql.Column" id="{52D562F8-30CD-4F7F-B05D-770C635033E3}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269C230" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams">('G','PG','PG-13','R','NC-17')</value> <value type="string" key="defaultValue">'G'</value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269BF78" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">rating</value> <value type="string" key="oldName">rating</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.enum</link> </value> <value type="object" struct-name="db.mysql.Column" id="{72302323-926C-4012-8872-2A726B4156D4}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269C1D0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams">('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')</value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="0269C0E0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">special_features</value> <value type="string" key="oldName">special_features</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link> </value> <value type="object" struct-name="db.mysql.Column" id="{244D224E-FD28-4EFF-A453-CC031AE13F27}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269C2A8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269C488" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="0269B528" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="0269B4C8" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{CD211CE3-80E3-4F60-93C8-0A6E8939E4F0}" struct-checksum="0x9784ee86"> <value _ptr_="0269C5A8" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{255FA0B8-D34C-4D42-BDB9-246275CB779D}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_film_language</value> <value type="string" key="oldName">fk_film_language</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value _ptr_="0269C680" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <value type="object" struct-name="db.mysql.Column" id="{CAC4FBE0-13C0-4848-AB30-BC4224C87A4A}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AFDD0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AFFB0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">language_id</value> <value type="string" key="oldName">language_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{2A6B3F5F-1AD2-4C09-9B65-A61DC6B0CD90}" struct-checksum="0x9784ee86"> <value _ptr_="0269C878" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{BD3C8157-34C6-4027-9725-D30FB79DFE1A}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_film_language_original</value> <value type="string" key="oldName">fk_film_language_original</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value _ptr_="0269C9C8" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{CAC4FBE0-13C0-4848-AB30-BC4224C87A4A}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="0269B4E0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{E9D70028-B42E-4490-85A3-C96C47501D21}" struct-checksum="0x416e09b2"> <value _ptr_="0269C518" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{E627BCE0-50E1-4E44-BC26-CC5C8F9733A5}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{E9D70028-B42E-4490-85A3-C96C47501D21}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{DE5F317A-B544-421C-9F5B-D9D505A17F30}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{99CA94DB-F666-45ED-9AD5-828735CA5554}" struct-checksum="0x416e09b2"> <value _ptr_="0269C3C8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{E9A752D9-389F-43CF-8820-80E76918EDFB}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">title</value> <link type="object" struct-name="db.mysql.Index" key="owner">{99CA94DB-F666-45ED-9AD5-828735CA5554}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{5DF0C36E-ECAA-437C-8D53-E2BC47A2C142}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_title</value> <value type="string" key="oldName">idx_title</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{4A9659A9-0A79-446A-B9F5-B5D800374C7E}" struct-checksum="0x416e09b2"> <value _ptr_="0269C6B0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{0551A51F-DB3D-41F9-9A92-54E445A7E258}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">language_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{4A9659A9-0A79-446A-B9F5-B5D800374C7E}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{255FA0B8-D34C-4D42-BDB9-246275CB779D}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_language_id</value> <value type="string" key="oldName">idx_fk_language_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{6C90C7A2-9317-4F9D-889F-462D95C0D6B1}" struct-checksum="0x416e09b2"> <value _ptr_="0269C578" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{240B7206-F83F-4F05-87D5-48553B56551E}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">original_language_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{6C90C7A2-9317-4F9D-889F-462D95C0D6B1}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{BD3C8157-34C6-4027-9725-D30FB79DFE1A}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_original_language_id</value> <value type="string" key="oldName">idx_fk_original_language_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">film</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">film</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="0269B618" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{E9D70028-B42E-4490-85A3-C96C47501D21}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="0269B5D0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"> <value type="object" struct-name="db.mysql.Trigger" id="{383FAE58-0FB8-495A-B0C4-ED8F793FF197}" struct-checksum="0x7d5a0a32"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="condition"></value> <value _ptr_="026AF068" type="dict" key="customData"/> <value type="string" key="definer"></value> <value type="int" key="enabled">1</value> <value type="string" key="event">INSERT</value> <value type="string" key="name">ins_film</value> <value type="string" key="oldName">ins_film</value> <value type="int" key="order">0</value> <value type="string" key="orientation">ROW</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="string" key="referenceNewRow"></value> <value type="string" key="referenceNewTable"></value> <value type="string" key="referenceOldRow"></value> <value type="string" key="referenceOldTable"></value> <value type="string" key="sqlDefinition">CREATE TRIGGER `ins_film` AFTER INSERT ON `film` FOR EACH ROW BEGIN INSERT INTO film_text (film_id, title, description) VALUES (new.film_id, new.title, new.description); END</value> <value type="string" key="temp_sql"></value> <value type="string" key="timing">AFTER</value> </value> <value type="object" struct-name="db.mysql.Trigger" id="{CD0BA2CA-0E14-4007-BD3D-6F9979C8D7C5}" struct-checksum="0x7d5a0a32"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="condition"></value> <value _ptr_="0269DDB0" type="dict" key="customData"/> <value type="string" key="definer"></value> <value type="int" key="enabled">1</value> <value type="string" key="event">UPDATE</value> <value type="string" key="name">upd_film</value> <value type="string" key="oldName">upd_film</value> <value type="int" key="order">0</value> <value type="string" key="orientation">ROW</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="string" key="referenceNewRow"></value> <value type="string" key="referenceNewTable"></value> <value type="string" key="referenceOldRow"></value> <value type="string" key="referenceOldTable"></value> <value type="string" key="sqlDefinition"> CREATE TRIGGER `upd_film` AFTER UPDATE ON `film` FOR EACH ROW BEGIN IF (old.title != new.title) or (old.description != new.description) THEN UPDATE film_text SET title=new.title, description=new.description, film_id=new.film_id WHERE film_id=old.film_id; END IF; END</value> <value type="string" key="temp_sql"></value> <value type="string" key="timing">AFTER</value> </value> <value type="object" struct-name="db.mysql.Trigger" id="{1E7B0DA4-E300-4FA1-8984-D38B4F881C68}" struct-checksum="0x7d5a0a32"> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="condition"></value> <value _ptr_="026AF0C8" type="dict" key="customData"/> <value type="string" key="definer"></value> <value type="int" key="enabled">1</value> <value type="string" key="event">DELETE</value> <value type="string" key="name">del_film</value> <value type="string" key="oldName">del_film</value> <value type="int" key="order">0</value> <value type="string" key="orientation">ROW</value> <link type="object" struct-name="db.mysql.Table" key="owner">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="string" key="referenceNewRow"></value> <value type="string" key="referenceNewTable"></value> <value type="string" key="referenceOldRow"></value> <value type="string" key="referenceOldTable"></value> <value type="string" key="sqlDefinition"> CREATE TRIGGER `del_film` AFTER DELETE ON `film` FOR EACH ROW BEGIN DELETE FROM film_text WHERE film_id = old.film_id; END</value> <value type="string" key="temp_sql"></value> <value type="string" key="timing">AFTER</value> </value> </value> </value> <value type="object" struct-name="db.mysql.Table" id="{59FAFD3D-1BAA-4006-B20A-B429E626924F}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="0269C8D8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{C9062457-9222-43F8-A156-D50F1B1BE22C}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269CBC0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269CAB8" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">actor_id</value> <value type="string" key="oldName">actor_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{99747BAC-1E30-4AA8-84FF-F16A36925DEA}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269CC20" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269CB78" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">film_id</value> <value type="string" key="oldName">film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{362851E5-B017-482E-BDD0-2719A0846FF5}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269CE48" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269CC50" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="0269C920" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="0269C968" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{46858C11-E1B8-42A5-B431-E418FB3C723A}" struct-checksum="0x9784ee86"> <value _ptr_="0269CF38" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{C9062457-9222-43F8-A156-D50F1B1BE22C}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_film_actor_actor</value> <value type="string" key="oldName">fk_film_actor_actor</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value _ptr_="0269CFC8" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{DFA61474-2F17-4767-B583-D2A2C461CE77}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{9B7AC14A-B6EF-475E-91BE-F16C8F2FA46B}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{51E8D508-67EB-48A8-89F7-B9275782E470}" struct-checksum="0x9784ee86"> <value _ptr_="0269D078" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{99747BAC-1E30-4AA8-84FF-F16A36925DEA}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_film_actor_film</value> <value type="string" key="oldName">fk_film_actor_film</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value _ptr_="0269D0D8" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{DE5F317A-B544-421C-9F5B-D9D505A17F30}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="0269C998" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{283DBE46-C43A-402F-8FAC-8DC9337D603B}" struct-checksum="0x416e09b2"> <value _ptr_="0269CD88" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{697347FE-D33C-4BD5-97EA-98B0DCFBA2FB}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">actor_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{283DBE46-C43A-402F-8FAC-8DC9337D603B}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{C9062457-9222-43F8-A156-D50F1B1BE22C}</link> </value> <value type="object" struct-name="db.mysql.IndexColumn" id="{5D052848-E3A6-4DE1-85AE-F3E33715D966}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{283DBE46-C43A-402F-8FAC-8DC9337D603B}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{99747BAC-1E30-4AA8-84FF-F16A36925DEA}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{8F8A8C67-02DF-4E75-847F-B841F3656D8F}" struct-checksum="0x416e09b2"> <value _ptr_="0269CC80" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{7238735B-1B17-45B3-8662-E90F9AD4C493}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8F8A8C67-02DF-4E75-847F-B841F3656D8F}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{99747BAC-1E30-4AA8-84FF-F16A36925DEA}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_film_id</value> <value type="string" key="oldName">idx_fk_film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{59FAFD3D-1BAA-4006-B20A-B429E626924F}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">film_actor</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">film_actor</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="0269CB18" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{283DBE46-C43A-402F-8FAC-8DC9337D603B}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="0269CB60" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{1D43291D-2537-4D92-998B-E4B9717CF8B8}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="0269D2B8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{7B4DE5AB-4790-48D7-B1E7-CBFF79E38DB4}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269D138" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269D348" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">film_id</value> <value type="string" key="oldName">film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1D43291D-2537-4D92-998B-E4B9717CF8B8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{B2BC06BA-338B-4795-A607-760639DD8BAA}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269D408" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269D528" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">category_id</value> <value type="string" key="oldName">category_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1D43291D-2537-4D92-998B-E4B9717CF8B8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{C30801C5-1547-4149-93A8-562CE3A14BD2}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269D540" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269D4B0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1D43291D-2537-4D92-998B-E4B9717CF8B8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="0269CF68" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="0269D228" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{26827C14-1B00-420A-94CE-60E8A899DE49}" struct-checksum="0x9784ee86"> <value _ptr_="0269D690" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{7B4DE5AB-4790-48D7-B1E7-CBFF79E38DB4}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_film_category_film</value> <value type="string" key="oldName">fk_film_category_film</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1D43291D-2537-4D92-998B-E4B9717CF8B8}</link> <value _ptr_="0269D750" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{DE5F317A-B544-421C-9F5B-D9D505A17F30}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{FC8415FC-ED45-4900-A5C6-F026428AA65E}" struct-checksum="0x9784ee86"> <value _ptr_="0269D660" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{B2BC06BA-338B-4795-A607-760639DD8BAA}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_film_category_category</value> <value type="string" key="oldName">fk_film_category_category</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1D43291D-2537-4D92-998B-E4B9717CF8B8}</link> <value _ptr_="0269D798" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{4D0A9386-8A60-4277-8532-B9E6964F1358}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{036772C9-3C95-49F9-8DE5-2F9B14913CDD}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="0269D360" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{E46EAB27-33A7-4D32-9CA9-14EC67326CA6}" struct-checksum="0x416e09b2"> <value _ptr_="0269D4E0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{F2B8C155-4FB8-4AD5-A3B2-A201FDFAC331}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{E46EAB27-33A7-4D32-9CA9-14EC67326CA6}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{7B4DE5AB-4790-48D7-B1E7-CBFF79E38DB4}</link> </value> <value type="object" struct-name="db.mysql.IndexColumn" id="{D58A3E3B-9801-4143-BA94-E7917727F0CB}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">category_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{E46EAB27-33A7-4D32-9CA9-14EC67326CA6}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{B2BC06BA-338B-4795-A607-760639DD8BAA}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{1D43291D-2537-4D92-998B-E4B9717CF8B8}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">film_category</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">film_category</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="0269D150" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{E46EAB27-33A7-4D32-9CA9-14EC67326CA6}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="0269D1B0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{58DBE5B3-0DB5-47CE-90A5-F71376BB41FE}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="0269D858" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{7EBD936D-103A-4B68-A0D6-E2A0C3785E11}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269DA68" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269DC18" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">film_id</value> <value type="string" key="oldName">film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{58DBE5B3-0DB5-47CE-90A5-F71376BB41FE}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{52F1106A-EBC0-4105-8BC4-6956C23A3F6B}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269DC90" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269DA98" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">255</value> <value type="string" key="name">title</value> <value type="string" key="oldName">title</value> <link type="object" struct-name="db.mysql.Table" key="owner">{58DBE5B3-0DB5-47CE-90A5-F71376BB41FE}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{0876CF2F-F9E7-4FA6-9ADA-9862BE3AFFBF}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="0269DA80" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="0269DAB0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">description</value> <value type="string" key="oldName">description</value> <link type="object" struct-name="db.mysql.Table" key="owner">{58DBE5B3-0DB5-47CE-90A5-F71376BB41FE}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.text</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="0269D9A8" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="0269DA08" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"/> <value _ptr_="0269D8A0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{A6EE038B-CF30-4014-951C-0DECCECD2E0E}" struct-checksum="0x416e09b2"> <value _ptr_="0269DB58" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{50959DBC-489A-4305-946E-865FDD22A4DD}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{A6EE038B-CF30-4014-951C-0DECCECD2E0E}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{7EBD936D-103A-4B68-A0D6-E2A0C3785E11}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{58DBE5B3-0DB5-47CE-90A5-F71376BB41FE}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{EFA5DD1C-3424-4473-8F1A-CD99BC76BD96}" struct-checksum="0x416e09b2"> <value _ptr_="0269DD98" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{16065A4F-DFAF-463C-A2BF-42D0B0BBCA22}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">title</value> <link type="object" struct-name="db.mysql.Index" key="owner">{EFA5DD1C-3424-4473-8F1A-CD99BC76BD96}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{52F1106A-EBC0-4105-8BC4-6956C23A3F6B}</link> </value> <value type="object" struct-name="db.mysql.IndexColumn" id="{784080AD-EA45-4334-BCC5-E2B0391C5942}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">description</value> <link type="object" struct-name="db.mysql.Index" key="owner">{EFA5DD1C-3424-4473-8F1A-CD99BC76BD96}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{0876CF2F-F9E7-4FA6-9ADA-9862BE3AFFBF}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">FULLTEXT KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_title_description</value> <value type="string" key="oldName">idx_title_description</value> <link type="object" struct-name="db.mysql.Table" key="owner">{58DBE5B3-0DB5-47CE-90A5-F71376BB41FE}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">film_text</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">film_text</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="0269DA38" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{A6EE038B-CF30-4014-951C-0DECCECD2E0E}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">MyISAM</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="0269D840" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026AF230" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{E581222B-11BF-4809-A50E-B99993025E06}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AF1D0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AF3E0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">inventory_id</value> <value type="string" key="oldName">inventory_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.mediumint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{6E08BD4B-2D4E-45A3-9745-0F570D5E738E}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AF5A8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AF2F0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">film_id</value> <value type="string" key="oldName">film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{56182A4E-4108-4C34-9793-279E1C8EF83B}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AF5C0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AF488" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">store_id</value> <value type="string" key="oldName">store_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{226DED7D-BCCE-428C-AB4A-4024DD363AC7}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AF650" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AF440" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026AF380" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026AF320" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{6E9BFF05-004F-46E2-9EAC-2C85FC46AA3B}" struct-checksum="0x9784ee86"> <value _ptr_="026AF8D8" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{56182A4E-4108-4C34-9793-279E1C8EF83B}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_inventory_store</value> <value type="string" key="oldName">fk_inventory_store</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value _ptr_="026AF968" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{46DA8071-7EE7-45A5-9691-6117CFA8E6A1}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{1A71FD54-5D1C-4120-8068-C52A25272CD9}" struct-checksum="0x9784ee86"> <value _ptr_="026AFA58" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{6E08BD4B-2D4E-45A3-9745-0F570D5E738E}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_inventory_film</value> <value type="string" key="oldName">fk_inventory_film</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value _ptr_="026AFA70" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{DE5F317A-B544-421C-9F5B-D9D505A17F30}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{7121305C-D04D-479A-BFE5-D5C01DBA85AF}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="026AF278" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{1C6DC1BF-0DA4-4208-B007-80DF83A806F7}" struct-checksum="0x416e09b2"> <value _ptr_="026AF518" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{502528A4-87AE-4787-9E97-A3D6AC03595D}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">inventory_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{1C6DC1BF-0DA4-4208-B007-80DF83A806F7}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{E581222B-11BF-4809-A50E-B99993025E06}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{8D73B7B3-9822-4250-A87E-D110360DE391}" struct-checksum="0x416e09b2"> <value _ptr_="026AF698" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{CE201F57-96BC-414E-9050-8D16E2FFC419}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8D73B7B3-9822-4250-A87E-D110360DE391}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{6E08BD4B-2D4E-45A3-9745-0F570D5E738E}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_film_id</value> <value type="string" key="oldName">idx_fk_film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{238EB137-E26D-4EBF-8290-EC5D3E387D7D}" struct-checksum="0x416e09b2"> <value _ptr_="026AF7D0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{8E7DEA54-D627-45D2-8672-DC1CD23BBB68}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">store_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{238EB137-E26D-4EBF-8290-EC5D3E387D7D}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{56182A4E-4108-4C34-9793-279E1C8EF83B}</link> </value> <value type="object" struct-name="db.mysql.IndexColumn" id="{E37DF2D7-83C9-421A-AEC8-B021A00B0A84}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">film_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{238EB137-E26D-4EBF-8290-EC5D3E387D7D}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{6E08BD4B-2D4E-45A3-9745-0F570D5E738E}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_store_id_film_id</value> <value type="string" key="oldName">idx_store_id_film_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">inventory</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">inventory</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="026AF038" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{1C6DC1BF-0DA4-4208-B007-80DF83A806F7}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="026AF350" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026AFB30" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{CAC4FBE0-13C0-4848-AB30-BC4224C87A4A}</link> <value type="object" struct-name="db.mysql.Column" id="{CA21C808-2FEA-4099-93D7-610033A04A18}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AFE00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AFF98" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">20</value> <value type="string" key="name">name</value> <value type="string" key="oldName">name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.char</link> </value> <value type="object" struct-name="db.mysql.Column" id="{434A527E-2F51-47FA-81A8-DA33A3B1CDDF}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026AFE30" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026AFF80" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026AFC50" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026AFC68" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"/> <value _ptr_="026AFB18" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{4D31758D-6C64-4C57-90D2-C2B33A81EEE1}" struct-checksum="0x416e09b2"> <value _ptr_="026B00A8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{ED6A699A-9DED-48A2-81C6-A4ADE61AD250}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">language_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{4D31758D-6C64-4C57-90D2-C2B33A81EEE1}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{CAC4FBE0-13C0-4848-AB30-BC4224C87A4A}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{CEBA846D-9521-4F3C-88B0-0CA7295BCE9D}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">language</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">language</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="026AFD58" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{4D31758D-6C64-4C57-90D2-C2B33A81EEE1}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="026AFD10" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026AFD88" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <value type="object" struct-name="db.mysql.Column" id="{4F3F62B9-7F2D-4FCF-92FE-B83A9D06E94F}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B03D8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B02D0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">payment_id</value> <value type="string" key="oldName">payment_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{29DE8FE2-30F5-42FC-B9EE-4006834D288F}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B0468" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B0378" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">customer_id</value> <value type="string" key="oldName">customer_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{7BEDB60F-9E9E-42B0-ACEE-8430EBE95992}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B02A0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B0408" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">staff_id</value> <value type="string" key="oldName">staff_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{50621466-A6D2-446B-A0B4-6E362AAEC6AC}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B0528" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="026B0648" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">rental_id</value> <value type="string" key="oldName">rental_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link> </value> <value type="object" struct-name="db.mysql.Column" id="{E7D2C2CD-7076-45D8-89B8-34D504982B88}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B06C0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B06A8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">amount</value> <value type="string" key="oldName">amount</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">5</value> <value type="int" key="scale">2</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.decimal</link> </value> <value type="object" struct-name="db.mysql.Column" id="{E7DCCF19-CAB6-4403-85A0-8DF24B17E4D0}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B0750" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B0930" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">payment_date</value> <value type="string" key="oldName">payment_date</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.datetime</link> </value> <value type="object" struct-name="db.mysql.Column" id="{214AA5B9-D014-4F2B-9A44-9B362326CFD0}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B0810" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B07C8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026B01F8" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026B0168" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{D9F54390-D95C-47D9-A10E-0CC25912E87B}" struct-checksum="0x9784ee86"> <value _ptr_="026B0918" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{50621466-A6D2-446B-A0B4-6E362AAEC6AC}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">SET NULL </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_payment_rental</value> <value type="string" key="oldName">fk_payment_rental</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value _ptr_="026B0B10" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <value type="object" struct-name="db.mysql.Column" id="{DC114147-74A9-4B78-840E-5F268D225B8B}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B0E10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B1050" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">rental_id</value> <value type="string" key="oldName">rental_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.int</link> </value> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{8BA1E72D-F800-40C0-9826-91252AC4D0AB}" struct-checksum="0x9784ee86"> <value _ptr_="026B0D20" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{29DE8FE2-30F5-42FC-B9EE-4006834D288F}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_payment_customer</value> <value type="string" key="oldName">fk_payment_customer</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value _ptr_="026B0CF0" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{B3FAFCA5-8235-4513-90F9-B94FD00D1B2C}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{78D0B7B6-C7E7-486E-B6F1-E4EC063773D0}" struct-checksum="0x9784ee86"> <value _ptr_="026B0D68" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{7BEDB60F-9E9E-42B0-ACEE-8430EBE95992}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_payment_staff</value> <value type="string" key="oldName">fk_payment_staff</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value _ptr_="026B0B40" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <value type="object" struct-name="db.mysql.Column" id="{22323330-FAF7-427C-BD5A-F57D75C4A9EB}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">1</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B20C0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B1E90" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">staff_id</value> <value type="string" key="oldName">staff_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="026B0108" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{18D31416-E551-45EF-8EDC-3830C6EF1A07}" struct-checksum="0x416e09b2"> <value _ptr_="026B07B0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{C769C6B4-11CB-4A45-8EF4-7942FE5E8AAA}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">payment_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{18D31416-E551-45EF-8EDC-3830C6EF1A07}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{4F3F62B9-7F2D-4FCF-92FE-B83A9D06E94F}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{24FB25C6-4E6A-412E-8544-131A91192586}" struct-checksum="0x416e09b2"> <value _ptr_="026B0A98" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{7D9F1BEF-97A9-4F37-8A2A-5D0F9A2D816A}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">staff_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{24FB25C6-4E6A-412E-8544-131A91192586}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{7BEDB60F-9E9E-42B0-ACEE-8430EBE95992}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_staff_id</value> <value type="string" key="oldName">idx_fk_staff_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{43DD7CCD-2D88-42DF-8EF0-5D74FACE4302}" struct-checksum="0x416e09b2"> <value _ptr_="026B0888" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{1D17FEEB-DE0F-4066-87F0-723E8315D166}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">customer_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{43DD7CCD-2D88-42DF-8EF0-5D74FACE4302}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{29DE8FE2-30F5-42FC-B9EE-4006834D288F}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_customer_id</value> <value type="string" key="oldName">idx_fk_customer_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{03750C18-33E1-4DCA-A9C5-C54BB846DEF8}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">payment</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">payment</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="026B01B0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{18D31416-E551-45EF-8EDC-3830C6EF1A07}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="026B01E0" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{AFEF9164-9EE0-46C2-A522-1F811F7DC304}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026B0E70" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{DC114147-74A9-4B78-840E-5F268D225B8B}</link> <value type="object" struct-name="db.mysql.Column" id="{45F2BE61-B298-4BC1-9E81-E7AADC83301A}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B1278" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B0F30" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">rental_date</value> <value type="string" key="oldName">rental_date</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.datetime</link> </value> <value type="object" struct-name="db.mysql.Column" id="{86F02E56-4D8D-4749-93B9-5D2F60BB82C7}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B1188" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B10C8" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">inventory_id</value> <value type="string" key="oldName">inventory_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.mediumint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{48DDC143-7EBD-4CE3-8086-86CB7C09A2AB}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B1140" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B12C0" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">customer_id</value> <value type="string" key="oldName">customer_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{832626BC-3059-4BD5-84DC-F237A9AA30AC}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B14D0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="026B12D8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">return_date</value> <value type="string" key="oldName">return_date</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.datetime</link> </value> <value type="object" struct-name="db.mysql.Column" id="{1317F17E-D55C-42C8-8333-8E529584073D}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B14B8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B1350" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">staff_id</value> <value type="string" key="oldName">staff_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{D5990DB0-8BEF-4737-8107-E6ECD4BBFEC1}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B1518" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B1308" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026B0FC0" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026B0F60" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{ACE1F961-0A4C-4FD9-A6B6-18C0730A0A3C}" struct-checksum="0x9784ee86"> <value _ptr_="026B1A10" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{1317F17E-D55C-42C8-8333-8E529584073D}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_rental_staff</value> <value type="string" key="oldName">fk_rental_staff</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value _ptr_="026B1B18" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{22323330-FAF7-427C-BD5A-F57D75C4A9EB}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{457EB6DC-46D3-4EB7-B481-C91C1DECE22D}" struct-checksum="0x9784ee86"> <value _ptr_="026B1AE8" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{86F02E56-4D8D-4749-93B9-5D2F60BB82C7}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_rental_inventory</value> <value type="string" key="oldName">fk_rental_inventory</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value _ptr_="026B1BD8" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{E581222B-11BF-4809-A50E-B99993025E06}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{D6BAB54F-BFB8-4C6C-BF02-A85162A2F16F}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{62B8DF84-B16F-4025-85B6-32F2D11DA1E6}" struct-checksum="0x9784ee86"> <value _ptr_="026B1D58" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{48DDC143-7EBD-4CE3-8086-86CB7C09A2AB}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_rental_customer</value> <value type="string" key="oldName">fk_rental_customer</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value _ptr_="026B1CC8" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{B3FAFCA5-8235-4513-90F9-B94FD00D1B2C}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{EED8BABD-0736-4A55-85A9-D2B09B589CC7}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="026B0EB8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{6EA45007-2F7E-4095-A46B-4963CAF6CECA}" struct-checksum="0x416e09b2"> <value _ptr_="026B13E0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{B4A5833F-E026-4C37-8673-6477521A5C26}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">rental_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{6EA45007-2F7E-4095-A46B-4963CAF6CECA}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{DC114147-74A9-4B78-840E-5F268D225B8B}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{8045D812-AF27-49D3-A8FC-C73E4588D46B}" struct-checksum="0x416e09b2"> <value _ptr_="026B1560" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{84B82AD0-3110-4B55-803B-F3EE6DD627A6}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">rental_date</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8045D812-AF27-49D3-A8FC-C73E4588D46B}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{45F2BE61-B298-4BC1-9E81-E7AADC83301A}</link> </value> <value type="object" struct-name="db.mysql.IndexColumn" id="{CF5D536B-DC45-4117-A751-00BF0E07695A}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">inventory_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8045D812-AF27-49D3-A8FC-C73E4588D46B}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{86F02E56-4D8D-4749-93B9-5D2F60BB82C7}</link> </value> <value type="object" struct-name="db.mysql.IndexColumn" id="{805F3451-AE60-49D0-91BB-F1DD9FDDDC8E}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">customer_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{8045D812-AF27-49D3-A8FC-C73E4588D46B}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{48DDC143-7EBD-4CE3-8086-86CB7C09A2AB}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">UNIQUE KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name"></value> <value type="string" key="oldName"></value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="unique">1</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{54FCF547-50DC-4B6F-B772-AE8FD028ED21}" struct-checksum="0x416e09b2"> <value _ptr_="026B1980" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{2E4F85AB-466E-4E11-A6ED-62DA4412554D}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">inventory_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{54FCF547-50DC-4B6F-B772-AE8FD028ED21}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{86F02E56-4D8D-4749-93B9-5D2F60BB82C7}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_inventory_id</value> <value type="string" key="oldName">idx_fk_inventory_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{7E12E5A7-46CD-4E7B-9FD2-99FB8ECAEB6A}" struct-checksum="0x416e09b2"> <value _ptr_="026B1818" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{75A35D9A-0E8C-447E-833A-A884C7E952A3}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">customer_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{7E12E5A7-46CD-4E7B-9FD2-99FB8ECAEB6A}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{48DDC143-7EBD-4CE3-8086-86CB7C09A2AB}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_customer_id</value> <value type="string" key="oldName">idx_fk_customer_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{4C5E2EDB-BE93-47EF-A13F-891BAB1E30C7}" struct-checksum="0x416e09b2"> <value _ptr_="026B16C8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{EA728FB3-137A-4505-867E-90F80FAF9ADE}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">staff_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{4C5E2EDB-BE93-47EF-A13F-891BAB1E30C7}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{1317F17E-D55C-42C8-8333-8E529584073D}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_staff_id</value> <value type="string" key="oldName">idx_fk_staff_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{AFEF9164-9EE0-46C2-A522-1F811F7DC304}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">rental</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">rental</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="026B0DB0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{6EA45007-2F7E-4095-A46B-4963CAF6CECA}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="026B0F90" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026B1E00" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{22323330-FAF7-427C-BD5A-F57D75C4A9EB}</link> <value type="object" struct-name="db.mysql.Column" id="{96DC9834-47FE-4512-A825-58D768F1D405}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B1FB0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B1EC0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">45</value> <value type="string" key="name">first_name</value> <value type="string" key="oldName">first_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{3ABA068F-F3D2-41B5-B78F-04053FB761B8}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2078" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B22A0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">45</value> <value type="string" key="name">last_name</value> <value type="string" key="oldName">last_name</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{C6E792A5-E310-4D92-A1C1-7B3DE030DF36}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2270" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B2240" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">address_id</value> <value type="string" key="oldName">address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{E5E4AA0F-8B1E-42D3-A826-5C30C8EE8485}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B22E8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="026B21E0" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">0</value> <value type="string" key="name">picture</value> <value type="string" key="oldName">picture</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.blob</link> </value> <value type="object" struct-name="db.mysql.Column" id="{942D8C09-D21B-471B-8653-58463D83DA42}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B23D8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="026B2570" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">0</value> <value type="int" key="length">50</value> <value type="string" key="name">email</value> <value type="string" key="oldName">email</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{DC606D5D-E2FF-48EE-9343-73B2AE182D6E}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2348" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B2468" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">store_id</value> <value type="string" key="oldName">store_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{831F8CBE-E405-44F0-8160-8E905C7565F6}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2528" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">TRUE </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B2390" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">active</value> <value type="string" key="oldName">active</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.boolean</link> </value> <value type="object" struct-name="db.mysql.Column" id="{11647947-893F-45C3-B756-9AC843E86ACB}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2738" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B25E8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">16</value> <value type="string" key="name">username</value> <value type="string" key="oldName">username</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{B66D1D65-1281-4E85-99CC-D37007E2BEF2}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B26A8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">NULL </value> <value type="int" key="defaultValueIsNull">1</value> <value _ptr_="026B26F0" type="list" content-type="string" key="flags"> <value type="string">BINARY</value> </value> <value type="int" key="isNotNull">0</value> <value type="int" key="length">40</value> <value type="string" key="name">password</value> <value type="string" key="oldName">password</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varchar</link> </value> <value type="object" struct-name="db.mysql.Column" id="{77338C19-D124-4104-ACF9-9643EE25EFF2}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2420" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B29A8" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026B1CF8" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026B1E30" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{62807B04-B932-42A6-8C3F-EC4A32B4DE03}" struct-checksum="0x9784ee86"> <value _ptr_="026B2A98" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{DC606D5D-E2FF-48EE-9343-73B2AE182D6E}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_staff_store</value> <value type="string" key="oldName">fk_staff_store</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value _ptr_="026B2AE0" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{46DA8071-7EE7-45A5-9691-6117CFA8E6A1}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{CF2A2819-DF5A-4BB7-AE7C-88F0FA739132}" struct-checksum="0x9784ee86"> <value _ptr_="026B2C90" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{C6E792A5-E310-4D92-A1C1-7B3DE030DF36}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_staff_address</value> <value type="string" key="oldName">fk_staff_address</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value _ptr_="026B2B40" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{F5230F5F-10C7-4EBC-B166-86BF3095BE95}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="026B1CB0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{CF88C93B-8B57-4B59-B5D1-402A9032F5C8}" struct-checksum="0x416e09b2"> <value _ptr_="026B2A38" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{2CD44EB7-C3E8-4848-B810-5825BB7E1FED}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">staff_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{CF88C93B-8B57-4B59-B5D1-402A9032F5C8}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{22323330-FAF7-427C-BD5A-F57D75C4A9EB}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{1A7552EC-8B74-4D4D-BBB2-02C1EBDBCBBA}" struct-checksum="0x416e09b2"> <value _ptr_="026B28E8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{38B44BD3-9349-48BB-B0F4-574D22F8C2AC}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">store_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{1A7552EC-8B74-4D4D-BBB2-02C1EBDBCBBA}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{DC606D5D-E2FF-48EE-9343-73B2AE182D6E}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_store_id</value> <value type="string" key="oldName">idx_fk_store_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{22892DD5-C969-426A-8377-18DE2C38A6EC}" struct-checksum="0x416e09b2"> <value _ptr_="026B2BD0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{670CE6C8-364B-41E3-A7D0-9325C8616230}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">address_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{22892DD5-C969-426A-8377-18DE2C38A6EC}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{C6E792A5-E310-4D92-A1C1-7B3DE030DF36}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_address_id</value> <value type="string" key="oldName">idx_fk_address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">staff</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">staff</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="026B1BF0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{CF88C93B-8B57-4B59-B5D1-402A9032F5C8}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="026B1C80" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> <value type="object" struct-name="db.mysql.Table" id="{D831B898-EA18-4000-9CBD-60D4A50160BD}" struct-checksum="0xe5282669"> <value type="string" key="avgRowLength"></value> <value type="int" key="checksum">0</value> <value _ptr_="026B2CD8" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{46DA8071-7EE7-45A5-9691-6117CFA8E6A1}</link> <value type="object" struct-name="db.mysql.Column" id="{D6C696D0-A294-4B7F-84E5-4758BD4B4A2D}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2FA8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B3170" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">manager_staff_id</value> <value type="string" key="oldName">manager_staff_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.tinyint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{8A188390-E998-431E-B7F4-E02E4E14EB47}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B2F60" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B3158" type="list" content-type="string" key="flags"> <value type="string">UNSIGNED</value> </value> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">address_id</value> <value type="string" key="oldName">address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.smallint</link> </value> <value type="object" struct-name="db.mysql.Column" id="{E6F69208-BB9E-4B3B-AF6F-9A6224AAF912}" struct-checksum="0xd3ccec73"> <value type="int" key="autoIncrement">0</value> <value type="string" key="characterSetName"></value> <value _ptr_="026B3338" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/> <value type="string" key="collationName"></value> <value type="string" key="comment"></value> <value type="string" key="datatypeExplicitParams"></value> <value type="string" key="defaultValue">CURRENT_TIMESTAMP </value> <value type="int" key="defaultValueIsNull">0</value> <value _ptr_="026B3230" type="list" content-type="string" key="flags"/> <value type="int" key="isNotNull">1</value> <value type="int" key="length">0</value> <value type="string" key="name">last_update</value> <value type="string" key="oldName">last_update</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="precision">0</value> <value type="int" key="scale">0</value> <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.timestamp</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="connectionString"></value> <value _ptr_="026B2DF8" type="dict" key="customData"/> <value type="string" key="defaultCharacterSetName">utf8</value> <value type="string" key="defaultCollationName"></value> <value type="int" key="delayKeyWrite">0</value> <value _ptr_="026B2E10" type="list" content-type="object" content-struct-name="db.ForeignKey" key="foreignKeys"> <value type="object" struct-name="db.mysql.ForeignKey" id="{76F2DD56-BF93-4C72-B683-8C84499D70B8}" struct-checksum="0x9784ee86"> <value _ptr_="026B3500" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{D6C696D0-A294-4B7F-84E5-4758BD4B4A2D}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_store_staff</value> <value type="string" key="oldName">fk_store_staff</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value _ptr_="026B35F0" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{22323330-FAF7-427C-BD5A-F57D75C4A9EB}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{0FCBFC5B-CDCC-4EDA-A97C-BA832E9B1A13}</link> <value type="string" key="updateRule">CASCADE </value> </value> <value type="object" struct-name="db.mysql.ForeignKey" id="{208F4C23-78BD-4C31-9589-C557A66C8F0E}" struct-checksum="0x9784ee86"> <value _ptr_="026B3458" type="list" content-type="object" content-struct-name="db.Column" key="columns"> <link type="object" struct-name="db.mysql.Column">{8A188390-E998-431E-B7F4-E02E4E14EB47}</link> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="deleteRule">RESTRICT </value> <value type="int" key="mandatory">1</value> <value type="int" key="many">0</value> <value type="string" key="name">fk_store_address</value> <value type="string" key="oldName">fk_store_address</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value _ptr_="026B3890" type="list" content-type="object" content-struct-name="db.Column" key="referedColumns"> <link type="object" struct-name="db.mysql.Column">{F5230F5F-10C7-4EBC-B166-86BF3095BE95}</link> </value> <value type="int" key="referedMandatory">1</value> <link type="object" struct-name="db.mysql.Table" key="referedTable">{1879C47C-3195-4D5D-BBB2-52F861850C4A}</link> <value type="string" key="updateRule">CASCADE </value> </value> </value> <value _ptr_="026B2CC0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices"> <value type="object" struct-name="db.mysql.Index" id="{B0D5A050-214F-44F7-A79D-CF6FC4A7238E}" struct-checksum="0x416e09b2"> <value _ptr_="026B30E0" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{A380A5CC-17E3-4F9E-85F4-634F4E3FC0FF}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">store_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{B0D5A050-214F-44F7-A79D-CF6FC4A7238E}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{46DA8071-7EE7-45A5-9691-6117CFA8E6A1}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">PRIMARY KEY </value> <value type="int" key="isPrimary">1</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">PRIMARY</value> <value type="string" key="oldName">PRIMARY</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{CC7DCEB5-60DF-4860-ADE2-305289D05536}" struct-checksum="0x416e09b2"> <value _ptr_="026B3398" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{16B441FB-CA2B-447B-BEA9-F44DBB0D38A9}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">manager_staff_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{CC7DCEB5-60DF-4860-ADE2-305289D05536}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{D6C696D0-A294-4B7F-84E5-4758BD4B4A2D}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">UNIQUE KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_unique_manager</value> <value type="string" key="oldName">idx_unique_manager</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="unique">1</value> <value type="string" key="withParser"></value> </value> <value type="object" struct-name="db.mysql.Index" id="{2ABE8AC5-A3D3-4E78-A1F1-D4B14249E5D8}" struct-checksum="0x416e09b2"> <value _ptr_="026B34B8" type="list" content-type="object" content-struct-name="db.IndexColumn" key="columns"> <value type="object" struct-name="db.mysql.IndexColumn" id="{2DCEFE3A-1595-4F77-A08A-38CE6C3F2794}" struct-checksum="0x64be6f06"> <value type="int" key="columnLength">0</value> <value type="string" key="comment"></value> <value type="int" key="descend">0</value> <value type="string" key="name">address_id</value> <link type="object" struct-name="db.mysql.Index" key="owner">{2ABE8AC5-A3D3-4E78-A1F1-D4B14249E5D8}</link> <link type="object" struct-name="db.mysql.Column" key="referedColumn">{8A188390-E998-431E-B7F4-E02E4E14EB47}</link> </value> </value> <value type="string" key="comment"></value> <value type="int" key="deferability">0</value> <value type="string" key="indexKind"></value> <value type="string" key="indexType">KEY </value> <value type="int" key="isPrimary">0</value> <value type="int" key="keyBlockSize">0</value> <value type="string" key="name">idx_fk_address_id</value> <value type="string" key="oldName">idx_fk_address_id</value> <link type="object" struct-name="db.mysql.Table" key="owner">{D831B898-EA18-4000-9CBD-60D4A50160BD}</link> <value type="int" key="unique">0</value> <value type="string" key="withParser"></value> </value> </value> <value type="int" key="isStub">0</value> <value type="int" key="isSystem">0</value> <value type="int" key="isTemporary">0</value> <value type="string" key="maxRows"></value> <value type="string" key="mergeInsert"></value> <value type="string" key="mergeUnion"></value> <value type="string" key="minRows"></value> <value type="string" key="name">store</value> <value type="string" key="nextAutoInc"></value> <value type="string" key="oldName">store</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="packKeys"></value> <value type="int" key="partitionCount">0</value> <value _ptr_="026B2F00" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/> <value type="string" key="partitionExpression"></value> <value type="string" key="partitionType"></value> <value type="string" key="password"></value> <link type="object" struct-name="db.mysql.Index" key="primaryKey">{B0D5A050-214F-44F7-A79D-CF6FC4A7238E}</link> <value type="string" key="raidChunkSize"></value> <value type="string" key="raidChunks"></value> <value type="string" key="raidType"></value> <value type="string" key="rowFormat"></value> <value type="int" key="subpartitionCount">0</value> <value type="string" key="subpartitionExpression"></value> <value type="string" key="subpartitionType"></value> <value type="string" key="tableDataDir"></value> <value type="string" key="tableEngine">InnoDB</value> <value type="string" key="tableIndexDir"></value> <value type="string" key="temp_sql"></value> <value type="string" key="temporaryScope"></value> <value _ptr_="026B2EB8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/> </value> </value> <value type="string" key="temp_sql"></value> <value _ptr_="026982C0" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"> <value type="object" struct-name="db.mysql.View" id="{26D0EDF4-F722-4FA2-BB79-79674257E7DD}" struct-checksum="0x774b4a09"> <value _ptr_="026B37B8" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B37A0" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">customer_list</value> <value type="string" key="oldName">customer_list</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `customer_list` -- CREATE VIEW customer_list AS SELECT cu.customer_id AS ID, CONCAT(cu.first_name, _utf8' ', cu.last_name) AS name, a.address AS address, a.postal_code AS `zip code`, a.phone AS phone, city.city AS city, country.country AS country, IF(cu.active, _utf8'active',_utf8'') AS notes, cu.store_id AS SID FROM customer AS cu JOIN address AS a ON cu.address_id = a.address_id JOIN city ON a.city_id = city.city_id JOIN country ON city.country_id = country.country_id</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> <value type="object" struct-name="db.mysql.View" id="{8C0B113C-EE8C-4938-87ED-ACB21D63A730}" struct-checksum="0x774b4a09"> <value _ptr_="026B3800" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3728" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">film_list</value> <value type="string" key="oldName">film_list</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `film_list` -- CREATE VIEW film_list AS SELECT film.film_id AS FID, film.title AS title, film.description AS description, category.name AS category, film.rental_rate AS price, film.length AS length, film.rating AS rating, GROUP_CONCAT(CONCAT(actor.first_name, _utf8' ', actor.last_name) SEPARATOR ', ') AS actors FROM category LEFT JOIN film_category ON category.category_id = film_category.category_id LEFT JOIN film ON film_category.film_id = film.film_id JOIN film_actor ON film.film_id = film_actor.film_id JOIN actor ON film_actor.actor_id = actor.actor_id GROUP BY film.film_id</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> <value type="object" struct-name="db.mysql.View" id="{D169E281-BCB4-447D-8078-8DCE76318D28}" struct-checksum="0x774b4a09"> <value _ptr_="026B39C8" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3AD0" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">nicer_but_slower_film_list</value> <value type="string" key="oldName">nicer_but_slower_film_list</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `nicer_but_slower_film_list` -- CREATE VIEW nicer_but_slower_film_list AS SELECT film.film_id AS FID, film.title AS title, film.description AS description, category.name AS category, film.rental_rate AS price, film.length AS length, film.rating AS rating, GROUP_CONCAT(CONCAT(CONCAT(UCASE(SUBSTR(actor.first_name,1,1)), LCASE(SUBSTR(actor.first_name,2,LENGTH(actor.first_name))),_utf8' ',CONCAT(UCASE(SUBSTR(actor.last_name,1,1)), LCASE(SUBSTR(actor.last_name,2,LENGTH(actor.last_name)))))) SEPARATOR ', ') AS actors FROM category LEFT JOIN film_category ON category.category_id = film_category.category_id LEFT JOIN film ON film_category.film_id = film.film_id JOIN film_actor ON film.film_id = film_actor.film_id JOIN actor ON film_actor.actor_id = actor.actor_id GROUP BY film.film_id</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> <value type="object" struct-name="db.mysql.View" id="{883AEBFF-4234-4E28-8252-4A6735A1EC7F}" struct-checksum="0x774b4a09"> <value _ptr_="026B3AB8" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3938" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">staff_list</value> <value type="string" key="oldName">staff_list</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `staff_list` -- CREATE VIEW staff_list AS SELECT s.staff_id AS ID, CONCAT(s.first_name, _utf8' ', s.last_name) AS name, a.address AS address, a.postal_code AS `zip code`, a.phone AS phone, city.city AS city, country.country AS country, s.store_id AS SID FROM staff AS s JOIN address AS a ON s.address_id = a.address_id JOIN city ON a.city_id = city.city_id JOIN country ON city.country_id = country.country_id</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> <value type="object" struct-name="db.mysql.View" id="{D1BDE36B-D0A5-4085-A7A3-FEFD06D3703E}" struct-checksum="0x774b4a09"> <value _ptr_="026B3920" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3A28" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">sales_by_store</value> <value type="string" key="oldName">sales_by_store</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `sales_by_store` -- CREATE VIEW sales_by_store AS SELECT CONCAT(c.city, _utf8',', cy.country) AS store , CONCAT(m.first_name, _utf8' ', m.last_name) AS manager , SUM(p.amount) AS total_sales FROM payment AS p INNER JOIN rental AS r ON p.rental_id = r.rental_id INNER JOIN inventory AS i ON r.inventory_id = i.inventory_id INNER JOIN store AS s ON i.store_id = s.store_id INNER JOIN address AS a ON s.address_id = a.address_id INNER JOIN city AS c ON a.city_id = c.city_id INNER JOIN country AS cy ON c.country_id = cy.country_id INNER JOIN staff AS m ON s.manager_staff_id = m.staff_id GROUP BY s.store_id ORDER BY cy.country, c.city</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> <value type="object" struct-name="db.mysql.View" id="{E7E4AE86-01E5-47FB-8B31-8328AD5ADFAD}" struct-checksum="0x774b4a09"> <value _ptr_="026B3BC0" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B38A8" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">sales_by_film_category</value> <value type="string" key="oldName">sales_by_film_category</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `sales_by_film_category` -- -- Note that total sales will add up to &gt;100% because -- some titles belong to more than 1 category -- CREATE VIEW sales_by_film_category AS SELECT c.name AS category , SUM(p.amount) AS total_sales FROM payment AS p INNER JOIN rental AS r ON p.rental_id = r.rental_id INNER JOIN inventory AS i ON r.inventory_id = i.inventory_id INNER JOIN film AS f ON i.film_id = f.film_id INNER JOIN film_category AS fc ON f.film_id = fc.film_id INNER JOIN category AS c ON fc.category_id = c.category_id GROUP BY c.name ORDER BY total_sales DESC</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> <value type="object" struct-name="db.mysql.View" id="{91B77F24-D8F4-489B-92F1-04E344EFEC5E}" struct-checksum="0x774b4a09"> <value _ptr_="026B3B78" type="list" content-type="string" key="columns"/> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value _ptr_="026B3C08" type="dict" key="customData"/> <value type="int" key="isReadOnly">0</value> <value type="string" key="name">actor_info</value> <value type="string" key="oldName">actor_info</value> <link type="object" struct-name="db.mysql.Schema" key="owner">{4A38DC36-0DAA-43C5-8203-F4F43D4690A7}</link> <value type="string" key="sqlDefinition"> -- -- View structure for view `actor_info` -- CREATE DEFINER=CURRENT_USER SQL SECURITY INVOKER VIEW actor_info AS SELECT a.actor_id, a.first_name, a.last_name, GROUP_CONCAT(DISTINCT CONCAT(c.name, ': ', (SELECT GROUP_CONCAT(f.title ORDER BY f.title SEPARATOR ', ') FROM sakila.film f INNER JOIN sakila.film_category fc ON f.film_id = fc.film_id INNER JOIN sakila.film_actor fa ON f.film_id = fa.film_id WHERE fc.category_id = c.category_id AND fa.actor_id = a.actor_id ) ) ORDER BY c.name SEPARATOR '; ') AS film_info FROM sakila.actor a LEFT JOIN sakila.film_actor fa ON a.actor_id = fa.actor_id LEFT JOIN sakila.film_category fc ON fa.film_id = fc.film_id LEFT JOIN sakila.category c ON fc.category_id = c.category_id GROUP BY a.actor_id, a.first_name, a.last_name</value> <value type="string" key="temp_sql"></value> <value type="int" key="withCheckCondition">0</value> </value> </value> </value> </value> <value _ptr_="02694E60" type="list" content-type="object" content-struct-name="db.mysql.ServerLink" key="serverLinks"/> <value _ptr_="02697480" type="list" content-type="object" content-struct-name="db.SimpleDatatype" key="simpleDatatypes"> <link type="object">com.mysql.rdbms.mysql.datatype.tinyint</link> <link type="object">com.mysql.rdbms.mysql.datatype.smallint</link> <link type="object">com.mysql.rdbms.mysql.datatype.mediumint</link> <link type="object">com.mysql.rdbms.mysql.datatype.int</link> <link type="object">com.mysql.rdbms.mysql.datatype.bigint</link> <link type="object">com.mysql.rdbms.mysql.datatype.float</link> <link type="object">com.mysql.rdbms.mysql.datatype.double</link> <link type="object">com.mysql.rdbms.mysql.datatype.decimal</link> <link type="object">com.mysql.rdbms.mysql.datatype.char</link> <link type="object">com.mysql.rdbms.mysql.datatype.varchar</link> <link type="object">com.mysql.rdbms.mysql.datatype.binary</link> <link type="object">com.mysql.rdbms.mysql.datatype.varbinary</link> <link type="object">com.mysql.rdbms.mysql.datatype.tinytext</link> <link type="object">com.mysql.rdbms.mysql.datatype.text</link> <link type="object">com.mysql.rdbms.mysql.datatype.mediumtext</link> <link type="object">com.mysql.rdbms.mysql.datatype.longtext</link> <link type="object">com.mysql.rdbms.mysql.datatype.tinyblob</link> <link type="object">com.mysql.rdbms.mysql.datatype.blob</link> <link type="object">com.mysql.rdbms.mysql.datatype.mediumblob</link> <link type="object">com.mysql.rdbms.mysql.datatype.longblob</link> <link type="object">com.mysql.rdbms.mysql.datatype.datetime</link> <link type="object">com.mysql.rdbms.mysql.datatype.date</link> <link type="object">com.mysql.rdbms.mysql.datatype.time</link> <link type="object">com.mysql.rdbms.mysql.datatype.year</link> <link type="object">com.mysql.rdbms.mysql.datatype.timestamp</link> <link type="object">com.mysql.rdbms.mysql.datatype.geometry</link> <link type="object">com.mysql.rdbms.mysql.datatype.linestring</link> <link type="object">com.mysql.rdbms.mysql.datatype.polygon</link> <link type="object">com.mysql.rdbms.mysql.datatype.multipoint</link> <link type="object">com.mysql.rdbms.mysql.datatype.multilinestring</link> <link type="object">com.mysql.rdbms.mysql.datatype.multipolygon</link> <link type="object">com.mysql.rdbms.mysql.datatype.geometrycollection</link> <link type="object">com.mysql.rdbms.mysql.datatype.bit</link> <link type="object">com.mysql.rdbms.mysql.datatype.boolean</link> <link type="object">com.mysql.rdbms.mysql.datatype.enum</link> <link type="object">com.mysql.rdbms.mysql.datatype.set</link> </value> <value _ptr_="02694B18" type="list" content-type="object" content-struct-name="db.mysql.Tablespace" key="tablespaces"/> <value _ptr_="02697DF8" type="list" content-type="object" content-struct-name="db.SimpleDatatype" key="userDatatypes"/> <value _ptr_="02694E90" type="list" content-type="object" content-struct-name="db.User" key="users"/> </value> </data>