?? sakila.mwb
字號:
<?xml version="1.0"?><data> <value type="dict" struct-name="db.workbench.Workbench"> <value type="string" key="_id">{70617D73-9A39-4400-858B-49B746C2F499}</value> <value type="dict" struct-name="db.mysql.Catalog" key="catalog"> <value type="string" key="_id">{D7673905-D87A-4798-8144-87FF2D5ACA49}</value> <value type="list" content-type="string" content-struct-name="db.CharacterSet" key="characterSets" option="ref"> <value type="string">{43903B6E-F2D0-4529-9B67-E0717BF4EF9F}</value> <value type="string">{3AC6FA9A-82A4-4F7A-98B9-1F12CFB202BF}</value> <value type="string">{9D4131DD-68A4-40BC-9D3F-82B4F7FA17B1}</value> <value type="string">{6ABFE754-D874-49FF-AC49-386F49B841AC}</value> <value type="string">{E2E563B6-7240-4D2B-A665-CE22EBD29E9F}</value> <value type="string">{AEFED982-F313-40D4-ABA9-11583190507F}</value> <value type="string">{A4E5546A-E0F8-4601-9DC3-D39C7DE1FD72}</value> <value type="string">{2F780E59-D0CF-4175-8473-C86D73B33ED6}</value> <value type="string">{E986FF81-4A4E-4A5D-B792-8D70F05A1BDE}</value> <value type="string">{41103BE4-2115-4129-A4F3-0EC70E1A7CA6}</value> <value type="string">{9069C68C-56AA-40EA-9C14-1542D5226355}</value> <value type="string">{A9BCA02E-A707-4832-A9A2-61F0A56F25C2}</value> <value type="string">{091F9B2C-FC20-47D4-B7EC-E31EF07828FF}</value> <value type="string">{FECE8C4D-B95C-4D06-B5E5-7C685B512607}</value> <value type="string">{52DEA621-FBB4-4FC5-88C6-936CC3F53579}</value> <value type="string">{FD0CE66F-4075-48FB-AF79-C75453274791}</value> <value type="string">{AF1906F2-20B5-491C-8450-14F730DBECD8}</value> <value type="string">{2BA9756D-C757-4770-B795-B1A4943359EC}</value> <value type="string">{B5603A47-2936-4144-BA74-5D4B6959F47F}</value> <value type="string">{A50D3C42-2BE0-49C7-A751-59ADDC334F01}</value> <value type="string">{38416973-B84F-48DF-A766-01022A48B7CB}</value> <value type="string">{FEDC8872-11CC-47CA-810A-6CCC2FAC6624}</value> <value type="string">{B37E43B5-C83C-49A6-81FD-21424E22A0CC}</value> <value type="string">{69774387-87EB-4929-95F7-666E7081C341}</value> <value type="string">{EFA25F7E-F252-4083-A7E7-0E0B51D2C7A6}</value> <value type="string">{82133B64-E91A-4EAB-96E7-5211E354E818}</value> <value type="string">{3006DAE4-DDE9-4979-B982-8284D885ED2A}</value> <value type="string">{6C8C05CC-8859-4974-B756-497697DB875F}</value> <value type="string">{99441A25-E2A8-4B71-A311-AA46C216D6A9}</value> <value type="string">{B670A3DE-8FD2-4508-A437-4EE82D3F184A}</value> <value type="string">{EF353851-0BAE-450A-8751-D96E58402C08}</value> <value type="string">{25D735B3-3DBA-4EF7-95C9-B94E5A480D40}</value> <value type="string">{F312E41B-8ECF-4B2D-B084-B22186F114AE}</value> <value type="string">{7A92AB4C-BB3F-47B9-BC98-4F55CF8690A3}</value> <value type="string">{3EE67D94-4290-4A37-A0A3-73E2602C2971}</value> <value type="string">{EF2A81A5-CB47-46E3-9FC5-203D7DA8EA10}</value> </value> <value type="string" key="comment"></value> <value type="string" key="defaultCharacterSetName"></value> <value type="string" key="defaultCollationName"></value> <value type="string" key="name">default</value> <value type="string" key="oldName"></value> <value type="string" key="owner" option="ref">{70617D73-9A39-4400-858B-49B746C2F499}</value> <value type="list" content-type="dict" content-struct-name="db.mysql.Schema" key="schemata"> <value type="dict" struct-name="db.mysql.Schema"> <value type="string" key="_id">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="defaultCharacterSetName">latin1</value> <value type="string" key="defaultCollationName"></value> <value type="string" key="name">sakila</value> <value type="string" key="oldName">sakila</value> <value type="string" key="owner" option="ref">{D7673905-D87A-4798-8144-87FF2D5ACA49}</value> <value type="list" content-type="dict" content-struct-name="db.mysql.RoutineGroup" key="routineGroups"> <value type="dict" struct-name="db.RoutineGroup"> <value type="string" key="_id">{59589C0D-3C98-46D7-BAD1-BE66907973B7}</value> <value type="string" key="comment"></value> <value type="int" key="commentedOut">0</value> <value type="string" key="name">Routine Group</value> <value type="string" key="oldName"></value> <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value> <value type="int" key="routineExpandedHeights">0</value> <value type="int" key="routineExpandedStates">0</value> <value type="list" content-type="string" content-struct-name="db.Routine" key="routines" option="ref"> <value type="string">{2B319C02-BC4F-45B3-94EB-2A45576BE08C}</value> <value type="string">{750F286F-1BFA-4EF8-B2AC-B81D3AEFC111}</value> <value type="string">{38560B24-E570-484B-870D-C10448F8A5FF}</value> <value type="string">{AE483912-B4FC-42CF-A4C3-45F5503A3998}</value> <value type="string">{3C905D33-0C1A-40B9-8BEC-EA4105405D2A}</value> <value type="string">{EBD980E7-D97C-43C4-9EB4-41C8CAF95316}</value> </value> <value type="string" key="sql"></value> </value> </value> <value type="list" content-type="dict" content-struct-name="db.mysql.Routine" key="routines"> <value type="dict" struct-name="db.mysql.Routine"> <value type="string" key="_id">{2B319C02-BC4F-45B3-94EB-2A45576BE08C}</value> <value type="string" key="comment"></value> <value type="string" key="name">film_in_stock</value> <value type="string" key="oldName">film_in_stock</value> <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value> <value type="list" content-type="dict" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{BEEE2369-A692-4BE3-864B-BCF441E50115}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">p_film_id</value> <value type="string" key="owner" option="ref">{2B319C02-BC4F-45B3-94EB-2A45576BE08C}</value> <value type="string" key="paramType">IN</value> </value> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{C514E964-7D34-46C4-8082-EABEA8FD0F4D}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">p_store_id</value> <value type="string" key="owner" option="ref">{2B319C02-BC4F-45B3-94EB-2A45576BE08C}</value> <value type="string" key="paramType">IN</value> </value> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{D6B20E1E-C683-47D1-BFE1-B4AFC6016532}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">p_film_count</value> <value type="string" key="owner" option="ref">{2B319C02-BC4F-45B3-94EB-2A45576BE08C}</value> <value type="string" key="paramType">OUT</value> </value> </value> <value type="string" key="routineCode">CREATE PROCEDURE `film_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)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="routineType">PROCEDURE</value> <value type="string" key="security">DEFINER</value> </value> <value type="dict" struct-name="db.mysql.Routine"> <value type="string" key="_id">{750F286F-1BFA-4EF8-B2AC-B81D3AEFC111}</value> <value type="string" key="comment"></value> <value type="string" key="name">film_not_in_stock</value> <value type="string" key="oldName">film_not_in_stock</value> <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value> <value type="list" content-type="dict" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{E364A01D-768B-4BCC-B558-67A311F4E8AB}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">p_film_id</value> <value type="string" key="owner" option="ref">{750F286F-1BFA-4EF8-B2AC-B81D3AEFC111}</value> <value type="string" key="paramType">IN</value> </value> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{C3C250C7-A810-4D80-99C5-48634B31963A}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">p_store_id</value> <value type="string" key="owner" option="ref">{750F286F-1BFA-4EF8-B2AC-B81D3AEFC111}</value> <value type="string" key="paramType">IN</value> </value> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{D30E3D5C-3175-48DA-8AB8-67A6B1F1F810}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">p_film_count</value> <value type="string" key="owner" option="ref">{750F286F-1BFA-4EF8-B2AC-B81D3AEFC111}</value> <value type="string" key="paramType">OUT</value> </value> </value> <value type="string" key="routineCode">CREATE PROCEDURE `film_not_in_stock`(IN p_film_id INT, IN p_store_id INT, OUT p_film_count INT)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="routineType">PROCEDURE</value> <value type="string" key="security">DEFINER</value> </value> <value type="dict" struct-name="db.mysql.Routine"> <value type="string" key="_id">{38560B24-E570-484B-870D-C10448F8A5FF}</value> <value type="string" key="comment">Provides a customizable report on best customers</value> <value type="string" key="name">rewards_report</value> <value type="string" key="oldName">rewards_report</value> <value type="string" key="owner" option="ref">{0D24FE2A-C389-4E95-BB0F-257921515C3F}</value> <value type="list" content-type="dict" content-struct-name="db.mysql.RoutineParam" key="params"> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{996B14DC-D082-47E2-B58A-90785568E3A7}</value> <value type="string" key="datatype">UNSIGNED</value> <value type="string" key="name">TINYINT</value> <value type="string" key="owner" option="ref">{38560B24-E570-484B-870D-C10448F8A5FF}</value> <value type="string" key="paramType">IN</value> </value> <value type="dict" struct-name="db.mysql.RoutineParam"> <value type="string" key="_id">{95DB57C0-B23A-48EF-8F0D-D54ADE88952A}</value> <value type="string" key="datatype">INT</value> <value type="string" key="name">count_rewardees</value> <value type="string" key="owner" option="ref">{38560B24-E570-484B-870D-C10448F8A5FF}</value> <value type="string" key="paramType">OUT</value> </value> </value> <value type="string" key="routineCode">CREATE PROCEDURE `rewards_report`( IN min_monthly_purchases TINYINT UNSIGNED , IN min_dollar_amount_purchased DECIMAL(10,2) UNSIGNED , OUT count_rewardees INT ) READS SQL DATA COMMENT 'Provides a customizable report on best customers'proc: BEGIN DECLARE last_month_start DATE; DECLARE last_month_end DATE; ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -