gistfile1.txt

Before creation:

mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at          | updated_at          | deleted_at | deleted | id | project_id                       | resource  | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-03-07 16:32:49 | 2013-06-18 09:33:33 | NULL       |       0 |  1 | d4e1c14691d841f6b53a24b6c4c42a0e | gigabytes |    232 |        0 |          NULL |
| 2013-03-07 16:32:50 | 2013-06-18 09:33:33 | NULL       |       0 |  2 | d4e1c14691d841f6b53a24b6c4c42a0e | volumes   |      7 |        0 |          NULL |



reservations:
*************************** 411. row ***************************
created_at: 2013-06-18 09:33:33
updated_at: 2013-06-18 09:33:33
deleted_at: 2013-06-18 09:33:33
   deleted: 1
        id: 411
      uuid: 4e75d66c-e68c-40ae-9b00-0f85098d241c
  usage_id: 1
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: gigabytes
     delta: -6
    expire: 2013-06-19 09:33:33
*************************** 412. row ***************************
created_at: 2013-06-18 09:33:33
updated_at: 2013-06-18 09:33:33
deleted_at: 2013-06-18 09:33:33
   deleted: 1
        id: 412
      uuid: 01fef455-e151-4cf2-9618-8f4589b17311
  usage_id: 2
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: volumes
     delta: -1
    expire: 2013-06-19 09:33:33
412 rows in set (0.00 sec)





After creation:

mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at          | updated_at          | deleted_at | deleted | id | project_id                       | resource  | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-03-07 16:32:49 | 2013-06-18 09:38:11 | NULL       |       0 |  1 | d4e1c14691d841f6b53a24b6c4c42a0e | gigabytes |    242 |        0 |          NULL |
| 2013-03-07 16:32:50 | 2013-06-18 09:38:11 | NULL       |       0 |  2 | d4e1c14691d841f6b53a24b6c4c42a0e | volumes   |      8 |        0 |          NULL |





reservations:
*************************** 411. row ***************************
created_at: 2013-06-18 09:33:33
updated_at: 2013-06-18 09:33:33
deleted_at: 2013-06-18 09:33:33
   deleted: 1
        id: 411
      uuid: 4e75d66c-e68c-40ae-9b00-0f85098d241c
  usage_id: 1
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: gigabytes
     delta: -6
    expire: 2013-06-19 09:33:33
*************************** 412. row ***************************
created_at: 2013-06-18 09:33:33
updated_at: 2013-06-18 09:33:33
deleted_at: 2013-06-18 09:33:33
   deleted: 1
        id: 412
      uuid: 01fef455-e151-4cf2-9618-8f4589b17311
  usage_id: 2
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: volumes
     delta: -1
    expire: 2013-06-19 09:33:33
*************************** 413. row ***************************
created_at: 2013-06-18 09:38:11
updated_at: 2013-06-18 09:38:11
deleted_at: 2013-06-18 09:38:11
   deleted: 1
        id: 413
      uuid: 970629a0-5643-442c-a341-2b45165b0a17
  usage_id: 1
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: gigabytes
     delta: 10
    expire: 2013-06-19 09:38:11
*************************** 414. row ***************************
created_at: 2013-06-18 09:38:11
updated_at: 2013-06-18 09:38:11
deleted_at: 2013-06-18 09:38:11
   deleted: 1
        id: 414
      uuid: b9872258-6560-4e0e-b013-0fcf20a87779
  usage_id: 2
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: volumes
     delta: 1
    expire: 2013-06-19 09:38:11
414 rows in set (0.00 sec)







##########################################'
deleting

mysql> select * from quota_usages;
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| created_at          | updated_at          | deleted_at | deleted | id | project_id                       | resource  | in_use | reserved | until_refresh |
+---------------------+---------------------+------------+---------+----+----------------------------------+-----------+--------+----------+---------------+
| 2013-03-07 16:32:49 | 2013-06-18 09:39:34 | NULL       |       0 |  1 | d4e1c14691d841f6b53a24b6c4c42a0e | gigabytes |    232 |        0 |          NULL |
| 2013-03-07 16:32:50 | 2013-06-18 09:39:34 | NULL       |       0 |  2 | d4e1c14691d841f6b53a24b6c4c42a0e | volumes   |      7 |        0 |          NULL |


*************************** 415. row ***************************
created_at: 2013-06-18 09:39:34
updated_at: 2013-06-18 09:39:34
deleted_at: 2013-06-18 09:39:34
   deleted: 1
        id: 415
      uuid: 1ca3a5cf-735f-4ad3-9612-699262e7e419
  usage_id: 1
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: gigabytes
     delta: -10
    expire: 2013-06-19 09:39:34
*************************** 416. row ***************************
created_at: 2013-06-18 09:39:34
updated_at: 2013-06-18 09:39:34
deleted_at: 2013-06-18 09:39:34
   deleted: 1
        id: 416
      uuid: 46a0efc4-5df8-456d-8269-3f51d129dd21
  usage_id: 2
project_id: d4e1c14691d841f6b53a24b6c4c42a0e
  resource: volumes
     delta: -1
    expire: 2013-06-19 09:39:34
416 rows in set (0.00 sec)