All pastes #981461 Raw Edit

Mine

public text v1 · immutable
·published 2008-04-11 20:12 UTC
rendered paste body
mysql> desc npanxx;
+---------+--------------+------+-----+---------+----------------+
| Field   | Type         | Null | Key | Default | Extra          |
+---------+--------------+------+-----+---------+----------------+
| seq     | int(20)      | NO   | PRI | NULL    | auto_increment | 
| rc      | varchar(32)  | NO   |     |         |                | 
| region  | varchar(10)  | NO   |     |         |                | 
| switch  | varchar(24)  | NO   |     |         |                | 
| ocn     | varchar(6)   | NO   |     |         |                | 
| ocndesc | varchar(128) | NO   |     |         |                | 
| lata    | varchar(6)   | NO   |     |         |                | 
| npanxx  | varchar(10)  | NO   | MUL |         |                | 
+---------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

mysql> desc cdr;
+-------------+--------------+------+-----+---------------------+-------+
| Field       | Type         | Null | Key | Default             | Extra |
+-------------+--------------+------+-----+---------------------+-------+
| calldate    | datetime     | NO   |     | 0000-00-00 00:00:00 |       | 
| clid        | varchar(80)  | NO   |     |                     |       | 
| src         | varchar(80)  | NO   |     |                     |       | 
| dst         | varchar(80)  | NO   | MUL |                     |       | 
| dcontext    | varchar(80)  | NO   |     |                     |       | 
| channel     | varchar(80)  | NO   |     |                     |       | 
| dstchannel  | varchar(80)  | NO   |     |                     |       | 
| lastapp     | varchar(80)  | NO   |     |                     |       | 
| lastdata    | varchar(80)  | NO   |     |                     |       | 
| duration    | int(11)      | NO   |     | 0                   |       | 
| billsec     | int(11)      | NO   |     | 0                   |       | 
| disposition | varchar(45)  | NO   |     |                     |       | 
| amaflags    | int(11)      | NO   |     | 0                   |       | 
| accountcode | varchar(20)  | NO   |     |                     |       | 
| uniqueid    | varchar(32)  | NO   |     |                     |       | 
| userfield   | varchar(255) | NO   |     |                     |       | 
| start       | datetime     | NO   |     |                     |       | 
| answer      | datetime     | NO   |     |                     |       | 
| end         | datetime     | NO   |     |                     |       | 
+-------------+--------------+------+-----+---------------------+-------+
19 rows in set (0.00 sec)