← Back to branch summary

~dshrews/drizzle/bug686781

« back to all changes in this revision

Viewing changes to plugin/information_schema_dictionary/tests/r/key_column_usage.result

  • Committer: David Shrewsbury
  • Date: 2011-01-11 20:37:44 UTC
  • mfrom: (2069.2.4 drizzle)
  • Revision ID: shrewsbury.dave@gmail.com-20110111203744-v68giog560ejzyw7
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/information_schema_dictionary/tests/r/key_column_usage.result
336
336
) ;
337
337
select * from information_schema.key_column_usage WHERE table_schema="everything" ORDER BY TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME;
338
338
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION
339
 
        everything      PRIMARY         everything      branch  branch_id       1
340
 
        everything      PRIMARY         everything      container       container_id    1
341
 
        everything      PRIMARY         everything      document        document_id     1
342
 
        everything      PRIMARY         everything      genstats_attributes     genstats_attributes_id  1
343
 
        everything      PRIMARY         everything      htmlcode        htmlcode_id     1
344
 
        everything      PRIMARY         everything      htmlpage        htmlpage_id     1
345
 
        everything      PRIMARY         everything      image   image_id        1
346
 
        everything      PRIMARY         everything      javascript      javascript_id   1
347
 
        everything      PRIMARY         everything      knowledge_item  knowledge_item_id       1
348
 
        everything      PRIMARY         everything      links   from_node       1
349
 
        everything      PRIMARY         everything      links   linktype        3
350
 
        everything      PRIMARY         everything      links   to_node 2
351
 
        everything      PRIMARY         everything      mail    mail_id 1
352
 
        everything      PRIMARY         everything      node    node_id 1
353
 
        everything      PRIMARY         everything      nodegroup       nodegroup_id    1
354
 
        everything      PRIMARY         everything      nodegroup       rank    2
355
 
        everything      PRIMARY         everything      nodelet nodelet_id      1
356
 
        everything      PRIMARY         everything      nodemethod      nodemethod_id   1
357
 
        everything      PRIMARY         everything      nodetype        nodetype_id     1
358
 
        everything      PRIMARY         everything      project project_id      1
359
 
        everything      PRIMARY         everything      project_document        project_document_id     1
360
 
        everything      PRIMARY         everything      question        question_id     1
361
 
        everything      PRIMARY         everything      question        rank    2
362
 
        everything      PRIMARY         everything      redirects       redirects_id    1
363
 
        everything      PRIMARY         everything      releases        releases_id     1
364
 
        everything      PRIMARY         everything      revision        inside_workspace        2
365
 
        everything      PRIMARY         everything      revision        node_id 1
366
 
        everything      PRIMARY         everything      revision        revision_id     3
367
 
        everything      PRIMARY         everything      setting setting_id      1
368
 
        everything      PRIMARY         everything      symlink symlink_id      1
369
 
        everything      PRIMARY         everything      themesetting    themesetting_id 1
370
 
        everything      PRIMARY         everything      typeversion     typeversion_id  1
371
 
        everything      PRIMARY         everything      user    user_id 1
372
 
        everything      PRIMARY         everything      version version_id      1
373
 
        everything      PRIMARY         everything      weblog  entry_id        1
374
 
        everything      PRIMARY         everything      workspace       workspace_id    1
 
339
LOCAL   everything      PRIMARY LOCAL   everything      branch  branch_id       1
 
340
LOCAL   everything      PRIMARY LOCAL   everything      container       container_id    1
 
341
LOCAL   everything      PRIMARY LOCAL   everything      document        document_id     1
 
342
LOCAL   everything      PRIMARY LOCAL   everything      genstats_attributes     genstats_attributes_id  1
 
343
LOCAL   everything      PRIMARY LOCAL   everything      htmlcode        htmlcode_id     1
 
344
LOCAL   everything      PRIMARY LOCAL   everything      htmlpage        htmlpage_id     1
 
345
LOCAL   everything      PRIMARY LOCAL   everything      image   image_id        1
 
346
LOCAL   everything      PRIMARY LOCAL   everything      javascript      javascript_id   1
 
347
LOCAL   everything      PRIMARY LOCAL   everything      knowledge_item  knowledge_item_id       1
 
348
LOCAL   everything      PRIMARY LOCAL   everything      links   from_node       1
 
349
LOCAL   everything      PRIMARY LOCAL   everything      links   linktype        3
 
350
LOCAL   everything      PRIMARY LOCAL   everything      links   to_node 2
 
351
LOCAL   everything      PRIMARY LOCAL   everything      mail    mail_id 1
 
352
LOCAL   everything      PRIMARY LOCAL   everything      node    node_id 1
 
353
LOCAL   everything      PRIMARY LOCAL   everything      nodegroup       nodegroup_id    1
 
354
LOCAL   everything      PRIMARY LOCAL   everything      nodegroup       rank    2
 
355
LOCAL   everything      PRIMARY LOCAL   everything      nodelet nodelet_id      1
 
356
LOCAL   everything      PRIMARY LOCAL   everything      nodemethod      nodemethod_id   1
 
357
LOCAL   everything      PRIMARY LOCAL   everything      nodetype        nodetype_id     1
 
358
LOCAL   everything      PRIMARY LOCAL   everything      project project_id      1
 
359
LOCAL   everything      PRIMARY LOCAL   everything      project_document        project_document_id     1
 
360
LOCAL   everything      PRIMARY LOCAL   everything      question        question_id     1
 
361
LOCAL   everything      PRIMARY LOCAL   everything      question        rank    2
 
362
LOCAL   everything      PRIMARY LOCAL   everything      redirects       redirects_id    1
 
363
LOCAL   everything      PRIMARY LOCAL   everything      releases        releases_id     1
 
364
LOCAL   everything      PRIMARY LOCAL   everything      revision        inside_workspace        2
 
365
LOCAL   everything      PRIMARY LOCAL   everything      revision        node_id 1
 
366
LOCAL   everything      PRIMARY LOCAL   everything      revision        revision_id     3
 
367
LOCAL   everything      PRIMARY LOCAL   everything      setting setting_id      1
 
368
LOCAL   everything      PRIMARY LOCAL   everything      symlink symlink_id      1
 
369
LOCAL   everything      PRIMARY LOCAL   everything      themesetting    themesetting_id 1
 
370
LOCAL   everything      PRIMARY LOCAL   everything      typeversion     typeversion_id  1
 
371
LOCAL   everything      PRIMARY LOCAL   everything      user    user_id 1
 
372
LOCAL   everything      PRIMARY LOCAL   everything      version version_id      1
 
373
LOCAL   everything      PRIMARY LOCAL   everything      weblog  entry_id        1
 
374
LOCAL   everything      PRIMARY LOCAL   everything      workspace       workspace_id    1
375
375
drop schema everything;