Reply To: empty field in database not handled as expected

[ppmt]

Here are some printout. I could not put them in the main post as it was telling me it looks like spam!

describe si_customers;
+--------------------------+------------------+------+-----+---------+----------------+
| Field                    | Type             | Null | Key | Default | Extra          |
+--------------------------+------------------+------+-----+---------+----------------+
| id                       | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
| domain_id                | int(11) unsigned | NO   | PRI | NULL    |                |
| attention                | varchar(255)     | YES  |     | NULL    |                |
| name                     | varchar(255)     | YES  |     | NULL    |                |
| department               | varchar(255)     | YES  |     | NULL    |                |
| street_address           | varchar(255)     | YES  |     | NULL    |                |
| street_address2          | varchar(255)     | YES  |     | NULL    |                |
| city                     | varchar(255)     | YES  |     | NULL    |                |
| state                    | varchar(255)     | YES  |     | NULL    |                |
| zip_code                 | varchar(20)      | YES  |     | NULL    |                |
| country                  | varchar(255)     | YES  |     | NULL    |                |
| phone                    | varchar(255)     | YES  |     | NULL    |                |
| mobile_phone             | varchar(255)     | YES  |     | NULL    |                |
| fax                      | varchar(255)     | YES  |     | NULL    |                |
| email                    | varchar(255)     | YES  |     | NULL    |                |
| credit_card_holder_name  | varchar(255)     | YES  |     | NULL    |                |
| credit_card_number       | varchar(20)      | YES  |     | NULL    |                |
| credit_card_expiry_month | varchar(2)       | YES  |     | NULL    |                |
| credit_card_expiry_year  | varchar(4)       | YES  |     | NULL    |                |
| notes                    | text             | YES  |     | NULL    |                |
| parent_customer_id       | int(11)          | YES  |     | NULL    |                |
| default_invoice          | int(10) unsigned | NO   |     | 0       |                |
| custom_field1            | varchar(255)     | YES  |     | NULL    |                |
| custom_field2            | varchar(255)     | YES  |     | NULL    |                |
| custom_field3            | varchar(255)     | YES  |     | NULL    |                |
| custom_field4            | varchar(255)     | YES  |     | NULL    |                |
| enabled                  | tinyint(1)       | NO   |     | 1       |                |
+--------------------------+------------------+------+-----+---------+----------------+
27 rows in set (0.002 sec)

• This reply was modified 3 years, 8 months ago by ppmt.