mysql> select * from security_groups where id = 21;
+---------------------+------------+---------------------+---------+----+------+-------------------------+----------------------------------+----------------------------------+
| created_at | updated_at | deleted_at | deleted | id | name | description | user_id | project_id |
+---------------------+------------+---------------------+---------+----+------+-------------------------+----------------------------------+----------------------------------+
| 2012-09-25 18:10:46 | NULL | 2012-09-25 18:11:25 | 1 | 21 | bb | my-default-server-group | 007b0d5dc4a64d3c96a638cb4ef6a390 | 2268d5f5e7a44b49945cbeec32d2cc47 |
+---------------------+------------+---------------------+---------+----+------+-------------------------+----------------------------------+----------------------------------+
mysql> select * from security_group_rules where parent_group_id=21;
+---------------------+------------+------------+---------+----+-----------------+----------+-----------+---------+---------------+----------+
| created_at | updated_at | deleted_at | deleted | id | parent_group_id | protocol | from_port | to_port | cidr | group_id |
+---------------------+------------+------------+---------+----+-----------------+----------+-----------+---------+---------------+----------+
| 2012-09-25 18:10:51 | NULL | NULL | 0 | 4 | 21 | tcp | 22 | 22 | 192.168.1.1/0 | NULL |
+---------------------+------------+------------+---------+----+-----------------+----------+-----------+---------+---------------+----------+