definitions_and_groups.txt

mysql> select * from definitions;
+----+-----------------+-------------------+---------------------------------------------------------+---------------------+---------------------+
| id | name            | uri               | launch_fields                                           | created_at          | updated_at          |
+----+-----------------+-------------------+---------------------------------------------------------+---------------------+---------------------+
|  1 | simple sequence | sequence1.rb      | NULL                                                    | 2009-01-21 05:53:01 | 2009-01-21 05:53:01 | 
|  2 | leave request   | leave_request1.rb | {"employee":"","from_date":"","to_date":"","reason":""} | 2009-01-21 05:53:01 | 2009-01-21 05:53:01 | 
+----+-----------------+-------------------+---------------------------------------------------------+---------------------+---------------------+
2 rows in set (0.02 sec)


mysql> select * from group_definitions; 
+----+----------+---------------+---------------------+---------------------+
| id | group_id | definition_id | created_at          | updated_at          |
+----+----------+---------------+---------------------+---------------------+
|  1 |        1 |             1 | 2009-01-21 05:53:01 | 2009-01-21 05:53:01 | 
|  2 |        2 |             2 | 2009-01-21 05:53:01 | 2009-01-21 05:53:01 | 
+----+----------+---------------+---------------------+---------------------+
2 rows in set (0.00 sec)


mysql> select * from groups;
+----+--------+---------------------+---------------------+
| id | name   | created_at          | updated_at          |
+----+--------+---------------------+---------------------+
|  1 | admins | 2009-01-21 05:53:01 | 2009-01-21 05:53:01 | 
|  2 | team a | 2009-01-21 05:53:01 | 2009-01-21 05:53:01 | 
+----+--------+---------------------+---------------------+
2 rows in set (0.00 sec)


mysql> select * from user_groups;
+----+---------+----------+
| id | user_id | group_id |
+----+---------+----------+
|  1 |       1 |        1 | 
|  2 |       4 |        2 | 
+----+---------+----------+
2 rows in set (0.00 sec)


mysql> select id, login, name, email from users;
+----+--------+---------------------+--------------------+
| id | login  | name                | email              |
+----+--------+---------------------+--------------------+
|  1 | admin  | The Admin           | admin@example.com  | 
|  2 | alice  | Alice Foonderbar    | alice@example.com  | 
|  3 | bob    | Bob Morane          | bob@example.com    | 
|  4 | charly | Papa 'Tango' Charly | charly@example.com | 
+----+--------+---------------------+--------------------+
4 rows in set (0.00 sec)