mysql> show tables;
+--------------------+
| Tables_in_smsstore |
+--------------------+
| inbox              |
| outbox             |
| dbschema           |
+--------------------+
3 rows in set (0.00 sec)

mysql> describe inbox;
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| id        | int(10) unsigned |      | PRI | NULL    | auto_increment |
| stored    | timestamp(14)    | YES  |     | NULL    |                |
| device    | varchar(10)      | YES  |     | NULL    |                |
| fromgsm   | varchar(80)      | YES  |     | NULL    |                |
| msgdate   | varchar(9)       | YES  |     | NULL    |                |
| msgtime   | varchar(10)      | YES  |     | NULL    |                |
| msgtext   | text             | YES  |     | NULL    |                |
| processed | enum('y','n')    |      |     | n       |                |
+-----------+------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

mysql> describe outbox;
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| id       | int(10) unsigned |      | PRI | NULL    | auto_increment |
| stored   | timestamp(14)    | YES  |     | NULL    |                |
| smsc     | varchar(80)      |      |     | default |                |
| togsm    | varchar(80)      |      |     |         |                |
| userid   | varchar(12)      |      |     |         |                |
| mode     | char(3)          |      |     | -1      |                |
| flash    | char(1)          | YES  |     | NULL    |                |
| status   | int(10) unsigned |      |     | 0       |                |
| qruns    | int(10) unsigned |      |     | 0       |                |
| priority | int(10) unsigned |      |     | 3       |                |
| sent     | datetime         | YES  |     | NULL    |                |
| msgtext  | text             | YES  |     | NULL    |                |
| pdu      | text             | YES  |     | NULL    |                |
+----------+------------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

mysql> describe dbschema;
+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| client_app     | varchar(20)      |      | PRI |         |       |
| schema_version | int(10) unsigned | YES  |     | NULL    |       |
+----------------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql>