SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › empty field in database not handled as expected › Reply To: empty field in database not handled as expected
April 23, 2021 at 7:55 am
#1544
Participant
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, 4 months ago by
ppmt.
Recent Comments