Paul,
What is the "source" column used for? Can I use it
to hold a temporary value?
Bill
mysql> describe customer;
+--------------------------+------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+--------------------------+------------------+------+-----+------------+----------------+
*| source | varchar(100) | YES | | NULL *|
|
| signup_date | date | NO | | 0000-00-00 |
|
| name | varchar(255) | NO | | |
|
| company | varchar(255) | YES | | NULL |
|
| street | varchar(255) | NO | | |
|
| city | varchar(255) | NO | | |
|
| state | char(3) | NO | | |
|
| country | varchar(255) | NO | | USA |
|
| zip | varchar(20) | NO | | |
|
| phone | varchar(20) | NO | | |
|
| alt_phone | varchar(20) | YES | | NULL |
|
| fax | varchar(20) | YES | | NULL |
|
| contact_email | varchar(255) | YES | | NULL |
|
| account_number | int(11) | NO | PRI | NULL |
auto_increment |
| secret_question | varchar(254) | YES | | NULL |
|
| secret_answer | varchar(100) | YES | | NULL |
|
| cancel_date | date | YES | | NULL |
|
| removal_date | date | YES | | NULL |
|
| default_billing_id | int(10) unsigned | NO | | 0 |
|
| account_manager_password | varchar(60) | YES | | NULL |
|
| cancel_reason | int(11) | YES | | NULL |
|
| notes | text | YES | | NULL |
|
+--------------------------+------------------+------+-----+------------+----------------+
22 rows in set (0.00 sec)
On 1/23/2012 7:53 AM, Paul Yasi wrote:
> I don't think it would break anything.
>
> Paul
>
> On Mon, Jan 23, 2012 at 8:29 AM, Bill Harris <bhar...@texoma.net> wrote:
>> Paul,
>>
>> Our current "homegrown" Access-based system stores the account
>> name as the account number (legacy from dial-up days)..
>>
>> I want to import the customers today, but wondered if I could add
>> a varchar column to store the login id into (just temporarily) until
>> I build the services up. I was tempted to just store it in the comment
>> field, but I have a field of those to import as well.
>>
>> Will adding a field at the end of the customer table break anything,
>> functionally?
>>
>> Bill
>> ------------------------------------------------------------------------------
>> Try before you buy = See our experts in action!
>> The most comprehensive online learning library for Microsoft developers
>> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
>> Metro Style Apps, more. Free future releases when you subscribe now!
>> http://p.sf.net/sfu/learndevnow-dev2
>> _______________________________________________
>> Citrusdb-users mailing list
>> Citrusdb-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
>
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
