MySQL-Workbench-Parser

 view release on metacpan or  search on metacpan

lib/MySQL/Workbench/Parser/MySQLParser.pm  view on Meta::CPAN

514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
    { $item[2] }
 
on_update :
    /on update/i CURRENT_TIMESTAMP
    { $item[2] }
    |
    /on update/i reference_option
    { $item[2] }
 
reference_option: /restrict/i |
    /cascade/i   |
    /set null/i  |
    /no action/i |
    /set default/i
    { $item[1] }
 
index : normal_index
    | fulltext_index
    | spatial_index
    | <error>

t/04_actions.t  view on Meta::CPAN

139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
    length: '-1'
    name: group_id
    not_null: '1'
    precision: '-1'
foreign_keys:
  groups:
    -
      foreign: group_id
      me: group_id
      on_delete: restrict
      on_update: cascade
  users:
    -
      foreign: idusers
      me: user_id
      on_delete: cascade
      on_update: 'no action'
indexes:
  -
    columns:
      - user_id
      - group_id
    name: PRIMARY
    type: PRIMARY
  -
    columns:



( run in 0.394 second using v1.01-cache-2.11-cpan-ec4f86ec37b )