All pastes #297177 Raw Edit

Something

public text v1 · immutable
#297177 ·published 2006-12-30 22:16 UTC
rendered paste body
mysql> describe clients;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| id           | int(10) unsigned    |      | PRI | NULL    | auto_increment |
| cr_date      | date                | YES  |     | NULL    |                |
| cname        | varchar(255)        | YES  |     | NULL    |                |
| pname        | varchar(255)        |      | UNI |         |                |
| login        | varchar(20)         |      | UNI |         |                |
| account_id   | int(10) unsigned    | YES  |     | NULL    |                |
| status       | bigint(20) unsigned |      |     | 0       |                |
| phone        | varchar(255)        | YES  |     | NULL    |                |
| fax          | varchar(255)        | YES  |     | NULL    |                |
| email        | varchar(255)        | YES  |     | NULL    |                |
| address      | varchar(255)        | YES  |     | NULL    |                |
| city         | varchar(255)        | YES  |     | NULL    |                |
| state        | varchar(255)        | YES  |     | NULL    |                |
| pcode        | varchar(10)         | YES  |     | NULL    |                |
| country      | char(2)             | YES  |     | NULL    |                |
| locale       | varchar(17)         |      |     | en-US   |                |
| limits_id    | int(10) unsigned    |      |     | 0       |                |
| params_id    | int(10) unsigned    |      |     | 0       |                |
| perm_id      | int(10) unsigned    |      |     | 0       |                |
| pool_id      | int(10) unsigned    |      |     | 0       |                |
| logo_id      | int(10) unsigned    |      |     | 0       |                |
| tmpl_id      | int(10) unsigned    |      |     | 0       |                |
| sapp_pool_id | int(10) unsigned    |      | MUL | 0       |                |
+--------------+---------------------+------+-----+---------+----------------+
23 rows in set (0.00 sec)

then i must type alter clients set limits_id=NO;  or something