[ic] Database Definition Discrepancies

Paul Jordan jordan at gishnetwork.com
Thu Mar 6 17:59:44 EST 2008

Hello people

In doing some prep work for a new project today I wanted to match up the
changes between my databases (various original IC installs from 4.8 and up
with mods) with the current nightly build. I'd like to first say that the
tables seem to be going in a good direction.

However in doing this syncing I discovered some discrepancies, some which
could bite under certain circumstances. The following can cause unexpected
truncating (varchar lengths shown):

	userdb: 64
	transactions: 32
	orderline: 32

	userdb: present
	transactions: not present

	userdb: 20
	transactions: 10
company: (b_ also)
	userdb: 64
	transactions: 30

	userdb: 30
	transactions: 20

Also, I noticed that some fields (and tables) are now gone. I am keeping
track of these as I go, but since I was sending the above, I thought I'd
mention a couple I was unsure of.

In Userdb, there used to be columns 'email_copy' and 'fax_order' which are
not present in the current standard. However when I grep Vend I see for

/ic/lib/Vend/UserDB.pm:@P_FIELDS = qw ( p_nickname email fax email_copy
phone_night mail_list fax_order );

/ic/lib/UI/pages/admin/order_status_alt.html: my $wants_copy =
$udb->field($user, 'email_copy');

Along with slew of references to the [value] of email_copy.

Is this going to be a problem? Is there any place to see the changes made to
the tables over the years? I subscribe to the cvs-announce and I do glance
at all of them, but to tell you the truth I don't remember seeing table
related changes. WhatsNew does not mention these things directly either. Any

I'd like to keep the tables standard friendly so there are no upgrade



More information about the interchange-users mailing list