test/sql/README.fixtures

   1 Here's a quick (incomplete!) overview of what winds up in your tables.
   2
   3
   4 1. agendav_test
   5
   6 +----------------------------+
   7 |             prefs          |
   8 +------------------+---------+
   9 |  username        | options |
  10 +------------------+---------+
  11 | adam@example.net | herp    |
  12 +------------------+---------+
  13
  14
  15 +------------------------------------------------------+
  16 |                        shared                        |
  17 +-----+------------------+----------+------------------+
  18 | sid |    user_from     | calendar |    user_which    |
  19 +-----+------------------+----------+------------------+
  20 |   1 | adam@example.net | derp     | beth@example.net |
  21 +-----+------------------+----------+------------------+
  22
  23
  24 2. davical_test
  25
  26 +-------------------------------------------------------+
  27 |                        usr                            |
  28 +---------+--------+----------------+-------------------+
  29 | user_no | active |    joined      |     username      |
  30 +---------+--------+----------------+-------------------+
  31 |      17 | t      | 2014-01-04 ... | alice@example.com |
  32 +---------+--------+----------------+-------------------+
  33
  34 +-----------------------------------------+
  35 |                usr_setting              |
  36 +---------+--------------+----------------+
  37 | user_no | setting_name | setting_value  |
  38 +---------+--------------+----------------+
  39 |      17 | dumb setting | its dumb value |
  40 +---------+--------------+----------------+
  41
  42
  43 3. postfixadmin_test
  44
  45 +-------------+
  46 |   domain    |
  47 +-------------+
  48 |   domain    |
  49 +-------------+
  50 | ALL         |
  51 +-------------+
  52 | example.com |
  53 +-------------+
  54 | example.net |
  55 +-------------+
  56
  57
  58 +----------------------------------------------+
  59 |                    mailbox                   |
  60 +-------------------+-------------+------------+
  61 |     username      |   domain    | local_part |
  62 +-------------------+-------------+------------+
  63 | alice@example.com | example.com | alice      |
  64 +-------------------+-------------+------------+
  65 | bob@example.com   | example.com | bob        |
  66 +-------------------+-------------+------------+
  67 | adam@example.net  | example.net | adam       |
  68 +-------------------+-------------+------------+
  69 | beth@example.net  | example.net | beth       |
  70 +-------------------+-------------+------------+
  71 | carol@example.net | example.net | carol      |
  72 +-------------------+-------------+------------+
  73
  74
  75 +------------------------------------------------------+
  76 |                          alias                       |
  77 +-------------------+-------------------+--------------+
  78 |     address       |       goto        |   domain     |
  79 +-------------------+-------------------+--------------+
  80 | alice@example.com | alice@example.com | example.com  |
  81 +-------------------+-------------------+--------------+
  82 | bob@example.com   | bob@example.com   | example.com  |
  83 +-------------------+-------------------+--------------+
  84 | adam@example.net  | adam@example.net  | example.net  |
  85 +-------------------+-------------------+--------------+
  86 | beth@example.net  | beth@example.net  | example.net  |
  87 +-------------------+-------------------+--------------+
  88 | carol@example.net | carol@example.net | example.net  |
  89 +-------------------+-------------------+--------------+
  90
  91
  92 +---------------------------------+
  93 |          domain_admins          |
  94 +-------------------+-------------+
  95 |     username      |   domain    |
  96 +-------------------+-------------+
  97 | admin@example.com | example.com |
  98 +-------------------+-------------+
  99 | admin@example.com | example.net |
 100 +-------------------+-------------+
 101
 102
 103
 104 4. roundcube_test
 105
 106
 107 +---------+-------------------+
 108 | user_id |     username      |
 109 +---------+-------------------+
 110 |       1 | alice@example.com |
 111 +---------+-------------------+
 112 |       2 | adam@example.net  |
 113 +---------+-------------------+