dbicdh/_source/deploy/1/001-auto.yml
changeset 59 4f4f8a52a874
equal deleted inserted replaced
58:a3e856c4d161 59:4f4f8a52a874
       
     1 ---
       
     2 schema:
       
     3   procedures: {}
       
     4   tables:
       
     5     crash_frames:
       
     6       constraints:
       
     7         - deferrable: 1
       
     8           expression: ''
       
     9           fields:
       
    10             - id
       
    11           match_type: ''
       
    12           name: ''
       
    13           on_delete: ''
       
    14           on_update: ''
       
    15           options: []
       
    16           reference_fields: []
       
    17           reference_table: ''
       
    18           type: PRIMARY KEY
       
    19         - deferrable: 1
       
    20           expression: ''
       
    21           fields:
       
    22             - crash_thread_id
       
    23           match_type: ''
       
    24           name: crash_frames_fk_crash_thread_id
       
    25           on_delete: ''
       
    26           on_update: ''
       
    27           options: []
       
    28           reference_fields:
       
    29             - id
       
    30           reference_table: crash_threads
       
    31           type: FOREIGN KEY
       
    32         - deferrable: 1
       
    33           expression: ''
       
    34           fields:
       
    35             - module_id
       
    36           match_type: ''
       
    37           name: crash_frames_fk_module_id
       
    38           on_delete: ''
       
    39           on_update: ''
       
    40           options: []
       
    41           reference_fields:
       
    42             - id
       
    43           reference_table: modules
       
    44           type: FOREIGN KEY
       
    45       fields:
       
    46         crash_thread_id:
       
    47           data_type: int
       
    48           default_value: ~
       
    49           is_nullable: 0
       
    50           is_primary_key: 0
       
    51           is_unique: 0
       
    52           name: crash_thread_id
       
    53           order: 7
       
    54           size:
       
    55             - 0
       
    56         function:
       
    57           data_type: varchar
       
    58           default_value: ~
       
    59           is_nullable: 1
       
    60           is_primary_key: 0
       
    61           is_unique: 0
       
    62           name: function
       
    63           order: 3
       
    64           size:
       
    65             - 128
       
    66         id:
       
    67           data_type: int
       
    68           default_value: ~
       
    69           is_auto_increment: 1
       
    70           is_nullable: 0
       
    71           is_primary_key: 1
       
    72           is_unique: 0
       
    73           name: id
       
    74           order: 1
       
    75           size:
       
    76             - 0
       
    77         module_id:
       
    78           data_type: int
       
    79           default_value: ~
       
    80           is_nullable: 0
       
    81           is_primary_key: 0
       
    82           is_unique: 0
       
    83           name: module_id
       
    84           order: 8
       
    85           size:
       
    86             - 0
       
    87         number:
       
    88           data_type: int
       
    89           default_value: ~
       
    90           is_nullable: 0
       
    91           is_primary_key: 0
       
    92           is_unique: 0
       
    93           name: number
       
    94           order: 2
       
    95           size:
       
    96             - 0
       
    97         source_file:
       
    98           data_type: varchar
       
    99           default_value: ~
       
   100           is_nullable: 1
       
   101           is_primary_key: 0
       
   102           is_unique: 0
       
   103           name: source_file
       
   104           order: 4
       
   105           size:
       
   106             - 128
       
   107         source_line:
       
   108           data_type: int
       
   109           default_value: ~
       
   110           is_nullable: 1
       
   111           is_primary_key: 0
       
   112           is_unique: 0
       
   113           name: source_line
       
   114           order: 5
       
   115           size:
       
   116             - 0
       
   117         stack_walk_mode:
       
   118           data_type: varchar
       
   119           default_value: ~
       
   120           is_nullable: 1
       
   121           is_primary_key: 0
       
   122           is_unique: 0
       
   123           name: stack_walk_mode
       
   124           order: 6
       
   125           size:
       
   126             - 10
       
   127       indices:
       
   128         - fields:
       
   129             - crash_thread_id
       
   130           name: crash_frames_idx_crash_thread_id
       
   131           options: []
       
   132           type: NORMAL
       
   133         - fields:
       
   134             - module_id
       
   135           name: crash_frames_idx_module_id
       
   136           options: []
       
   137           type: NORMAL
       
   138       name: crash_frames
       
   139       options: []
       
   140       order: 6
       
   141     crash_reports:
       
   142       constraints:
       
   143         - deferrable: 1
       
   144           expression: ''
       
   145           fields:
       
   146             - id
       
   147           match_type: ''
       
   148           name: ''
       
   149           on_delete: ''
       
   150           on_update: ''
       
   151           options: []
       
   152           reference_fields: []
       
   153           reference_table: ''
       
   154           type: PRIMARY KEY
       
   155         - deferrable: 1
       
   156           expression: ''
       
   157           fields:
       
   158             - crash_user_id
       
   159           match_type: ''
       
   160           name: crash_reports_fk_crash_user_id
       
   161           on_delete: ''
       
   162           on_update: ''
       
   163           options: []
       
   164           reference_fields:
       
   165             - id
       
   166           reference_table: crash_users
       
   167           type: FOREIGN KEY
       
   168         - deferrable: 1
       
   169           expression: ''
       
   170           fields:
       
   171             - product_id
       
   172           match_type: ''
       
   173           name: crash_reports_fk_product_id
       
   174           on_delete: ''
       
   175           on_update: ''
       
   176           options: []
       
   177           reference_fields:
       
   178             - id
       
   179           reference_table: products
       
   180           type: FOREIGN KEY
       
   181       fields:
       
   182         bug_reference:
       
   183           data_type: varchar
       
   184           default_value: ~
       
   185           is_nullable: 1
       
   186           is_primary_key: 0
       
   187           is_unique: 0
       
   188           name: bug_reference
       
   189           order: 5
       
   190           size:
       
   191             - 20
       
   192         crash_time:
       
   193           data_type: timestamp
       
   194           default_value: ~
       
   195           is_nullable: 1
       
   196           is_primary_key: 0
       
   197           is_unique: 0
       
   198           name: crash_time
       
   199           order: 3
       
   200           size:
       
   201             - 0
       
   202         crash_user_id:
       
   203           data_type: int
       
   204           default_value: ~
       
   205           is_nullable: 0
       
   206           is_primary_key: 0
       
   207           is_unique: 0
       
   208           name: crash_user_id
       
   209           order: 6
       
   210           size:
       
   211             - 0
       
   212         id:
       
   213           data_type: int
       
   214           default_value: ~
       
   215           is_auto_increment: 1
       
   216           is_nullable: 0
       
   217           is_primary_key: 1
       
   218           is_unique: 0
       
   219           name: id
       
   220           order: 1
       
   221           size:
       
   222             - 0
       
   223         product_id:
       
   224           data_type: int
       
   225           default_value: ~
       
   226           is_nullable: 0
       
   227           is_primary_key: 0
       
   228           is_unique: 0
       
   229           name: product_id
       
   230           order: 7
       
   231           size:
       
   232             - 0
       
   233         start_time:
       
   234           data_type: timestamp
       
   235           default_value: ~
       
   236           is_nullable: 1
       
   237           is_primary_key: 0
       
   238           is_unique: 0
       
   239           name: start_time
       
   240           order: 2
       
   241           size:
       
   242             - 0
       
   243         uuid:
       
   244           data_type: varchar
       
   245           default_value: ~
       
   246           is_nullable: 0
       
   247           is_primary_key: 0
       
   248           is_unique: 0
       
   249           name: uuid
       
   250           order: 4
       
   251           size:
       
   252             - 36
       
   253       indices:
       
   254         - fields:
       
   255             - crash_user_id
       
   256           name: crash_reports_idx_crash_user_id
       
   257           options: []
       
   258           type: NORMAL
       
   259         - fields:
       
   260             - product_id
       
   261           name: crash_reports_idx_product_id
       
   262           options: []
       
   263           type: NORMAL
       
   264       name: crash_reports
       
   265       options: []
       
   266       order: 4
       
   267     crash_threads:
       
   268       constraints:
       
   269         - deferrable: 1
       
   270           expression: ''
       
   271           fields:
       
   272             - id
       
   273           match_type: ''
       
   274           name: ''
       
   275           on_delete: ''
       
   276           on_update: ''
       
   277           options: []
       
   278           reference_fields: []
       
   279           reference_table: ''
       
   280           type: PRIMARY KEY
       
   281         - deferrable: 1
       
   282           expression: ''
       
   283           fields:
       
   284             - crash_report_id
       
   285           match_type: ''
       
   286           name: crash_threads_fk_crash_report_id
       
   287           on_delete: ''
       
   288           on_update: ''
       
   289           options: []
       
   290           reference_fields:
       
   291             - id
       
   292           reference_table: crash_reports
       
   293           type: FOREIGN KEY
       
   294       fields:
       
   295         crash_report_id:
       
   296           data_type: int
       
   297           default_value: ~
       
   298           is_nullable: 0
       
   299           is_primary_key: 0
       
   300           is_unique: 0
       
   301           name: crash_report_id
       
   302           order: 4
       
   303           size:
       
   304             - 0
       
   305         crashed:
       
   306           data_type: bool
       
   307           default_value: ~
       
   308           is_nullable: 0
       
   309           is_primary_key: 0
       
   310           is_unique: 0
       
   311           name: crashed
       
   312           order: 3
       
   313           size:
       
   314             - 0
       
   315         id:
       
   316           data_type: int
       
   317           default_value: ~
       
   318           is_auto_increment: 1
       
   319           is_nullable: 0
       
   320           is_primary_key: 1
       
   321           is_unique: 0
       
   322           name: id
       
   323           order: 1
       
   324           size:
       
   325             - 0
       
   326         number:
       
   327           data_type: int
       
   328           default_value: ~
       
   329           is_nullable: 0
       
   330           is_primary_key: 0
       
   331           is_unique: 0
       
   332           name: number
       
   333           order: 2
       
   334           size:
       
   335             - 0
       
   336       indices:
       
   337         - fields:
       
   338             - crash_report_id
       
   339           name: crash_threads_idx_crash_report_id
       
   340           options: []
       
   341           type: NORMAL
       
   342       name: crash_threads
       
   343       options: []
       
   344       order: 5
       
   345     crash_users:
       
   346       constraints:
       
   347         - deferrable: 1
       
   348           expression: ''
       
   349           fields:
       
   350             - id
       
   351           match_type: ''
       
   352           name: ''
       
   353           on_delete: ''
       
   354           on_update: ''
       
   355           options: []
       
   356           reference_fields: []
       
   357           reference_table: ''
       
   358           type: PRIMARY KEY
       
   359       fields:
       
   360         cpu_arch:
       
   361           data_type: varchar
       
   362           default_value: ~
       
   363           is_nullable: 1
       
   364           is_primary_key: 0
       
   365           is_unique: 0
       
   366           name: cpu_arch
       
   367           order: 4
       
   368           size:
       
   369             - 10
       
   370         cpu_count:
       
   371           data_type: int
       
   372           default_value: ~
       
   373           is_nullable: 1
       
   374           is_primary_key: 0
       
   375           is_unique: 0
       
   376           name: cpu_count
       
   377           order: 5
       
   378           size:
       
   379             - 0
       
   380         extra_info:
       
   381           data_type: text
       
   382           default_value: ~
       
   383           is_nullable: 1
       
   384           is_primary_key: 0
       
   385           is_unique: 0
       
   386           name: extra_info
       
   387           order: 6
       
   388           size:
       
   389             - 0
       
   390         id:
       
   391           data_type: int
       
   392           default_value: ~
       
   393           is_auto_increment: 1
       
   394           is_nullable: 0
       
   395           is_primary_key: 1
       
   396           is_unique: 0
       
   397           name: id
       
   398           order: 1
       
   399           size:
       
   400             - 0
       
   401         os:
       
   402           data_type: varchar
       
   403           default_value: ~
       
   404           is_nullable: 1
       
   405           is_primary_key: 0
       
   406           is_unique: 0
       
   407           name: os
       
   408           order: 3
       
   409           size:
       
   410             - 40
       
   411         user_id:
       
   412           data_type: varchar
       
   413           default_value: ~
       
   414           is_nullable: 0
       
   415           is_primary_key: 0
       
   416           is_unique: 0
       
   417           name: user_id
       
   418           order: 2
       
   419           size:
       
   420             - 40
       
   421       indices: []
       
   422       name: crash_users
       
   423       options: []
       
   424       order: 1
       
   425     modules:
       
   426       constraints:
       
   427         - deferrable: 1
       
   428           expression: ''
       
   429           fields:
       
   430             - id
       
   431           match_type: ''
       
   432           name: ''
       
   433           on_delete: ''
       
   434           on_update: ''
       
   435           options: []
       
   436           reference_fields: []
       
   437           reference_table: ''
       
   438           type: PRIMARY KEY
       
   439         - deferrable: 1
       
   440           expression: ''
       
   441           fields:
       
   442             - debug_id
       
   443             - filename
       
   444           match_type: ''
       
   445           name: module_id
       
   446           on_delete: ''
       
   447           on_update: ''
       
   448           options: []
       
   449           reference_fields: []
       
   450           reference_table: ''
       
   451           type: UNIQUE
       
   452       fields:
       
   453         debug_id:
       
   454           data_type: varchar
       
   455           default_value: ~
       
   456           is_nullable: 0
       
   457           is_primary_key: 0
       
   458           is_unique: 1
       
   459           name: debug_id
       
   460           order: 2
       
   461           size:
       
   462             - 33
       
   463         filename:
       
   464           data_type: varchar
       
   465           default_value: ~
       
   466           is_nullable: 0
       
   467           is_primary_key: 0
       
   468           is_unique: 1
       
   469           name: filename
       
   470           order: 3
       
   471           size:
       
   472             - 128
       
   473         id:
       
   474           data_type: int
       
   475           default_value: ~
       
   476           is_auto_increment: 1
       
   477           is_nullable: 0
       
   478           is_primary_key: 1
       
   479           is_unique: 0
       
   480           name: id
       
   481           order: 1
       
   482           size:
       
   483             - 0
       
   484         version:
       
   485           data_type: varchar
       
   486           default_value: ~
       
   487           is_nullable: 1
       
   488           is_primary_key: 0
       
   489           is_unique: 0
       
   490           name: version
       
   491           order: 4
       
   492           size:
       
   493             - 64
       
   494       indices: []
       
   495       name: modules
       
   496       options: []
       
   497       order: 2
       
   498     products:
       
   499       constraints:
       
   500         - deferrable: 1
       
   501           expression: ''
       
   502           fields:
       
   503             - id
       
   504           match_type: ''
       
   505           name: ''
       
   506           on_delete: ''
       
   507           on_update: ''
       
   508           options: []
       
   509           reference_fields: []
       
   510           reference_table: ''
       
   511           type: PRIMARY KEY
       
   512       fields:
       
   513         distributor:
       
   514           data_type: varchar
       
   515           default_value: ~
       
   516           is_nullable: 1
       
   517           is_primary_key: 0
       
   518           is_unique: 0
       
   519           name: distributor
       
   520           order: 2
       
   521           size:
       
   522             - 40
       
   523         id:
       
   524           data_type: int
       
   525           default_value: ~
       
   526           is_auto_increment: 1
       
   527           is_nullable: 0
       
   528           is_primary_key: 1
       
   529           is_unique: 0
       
   530           name: id
       
   531           order: 1
       
   532           size:
       
   533             - 0
       
   534         name:
       
   535           data_type: varchar
       
   536           default_value: ~
       
   537           is_nullable: 1
       
   538           is_primary_key: 0
       
   539           is_unique: 0
       
   540           name: name
       
   541           order: 3
       
   542           size:
       
   543             - 40
       
   544         release_channel:
       
   545           data_type: varchar
       
   546           default_value: ~
       
   547           is_nullable: 1
       
   548           is_primary_key: 0
       
   549           is_unique: 0
       
   550           name: release_channel
       
   551           order: 5
       
   552           size:
       
   553             - 0
       
   554         version:
       
   555           data_type: varchar
       
   556           default_value: ~
       
   557           is_nullable: 1
       
   558           is_primary_key: 0
       
   559           is_unique: 0
       
   560           name: version
       
   561           order: 4
       
   562           size:
       
   563             - 16
       
   564       indices: []
       
   565       name: products
       
   566       options: []
       
   567       order: 3
       
   568   triggers: {}
       
   569   views: {}
       
   570 translator:
       
   571   add_drop_table: 0
       
   572   filename: ~
       
   573   no_comments: 0
       
   574   parser_args:
       
   575     sources:
       
   576       - CrashFrame
       
   577       - CrashReport
       
   578       - CrashThread
       
   579       - CrashUser
       
   580       - Module
       
   581       - Product
       
   582   parser_type: SQL::Translator::Parser::DBIx::Class
       
   583   producer_args: {}
       
   584   producer_type: SQL::Translator::Producer::YAML
       
   585   show_warnings: 0
       
   586   trace: 0
       
   587   version: 0.11020