Improve trigger 'scope' attribute support (RT#119997)
[dbsrgits/SQL-Translator.git] / t / data / xml / schema.xml
index 685ceff..048d857 100644 (file)
@@ -54,6 +54,7 @@ Created on Fri Aug 15 15:08:18 2003
               <extra foo="bar" hello="world" bar="baz" />
           </constraint>
           <constraint name="emailuniqueindex" type="UNIQUE" fields="email" />
+          <constraint name="very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms" type="UNIQUE" fields="title" />
           <constraint name="" type="FOREIGN KEY" fields="another_id"
               reference_table="Another" options="" deferrable="1" match_type=""
               expression="" on_update="" on_delete="">
@@ -98,12 +99,12 @@ Created on Fri Aug 15 15:08:18 2003
 
   <triggers>
       <trigger name="foo_trigger" database_event="insert" on_table="Basic"
-          perform_action_when="after" order="1">
+          perform_action_when="after" order="1" scope="row">
           <action>update modified=timestamp();</action>
           <extra foo="bar" hello="world" bar="baz" />
       </trigger>
       <trigger name="bar_trigger" database_events="insert , update" on_table="Basic"
-          perform_action_when="before" order="1">
+          perform_action_when="before" order="1" scope="row">
           <action>update modified2=timestamp();</action>
           <extra hello="aliens" />
       </trigger>