tables/data fields before and after V5

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
TonyMcManus
Posts: 12
Joined: Thu Jul 10, 2008 10:17 am
Contact:

tables/data fields before and after V5

Post by TonyMcManus » Tue Sep 16, 2008 3:39 pm

Hi All,

Have a question that someone may be able to help me with

In the old Open-Dental (pre ver. 5), the ProcedureLog and ProcedureCode tables had ADACode column names.
In the new Open-Dental (ver. 5), the ProcedureLog and ProcedureCode tables now have CodeNum column names.

What other tables/data fields if any were changed?

Many thanks,

Tony
Tony McManus
Dental Senders, CEO
www.dentalsenders.com

User avatar
jordansparks
Site Admin
Posts: 5742
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: tables/data fields before and after V5

Post by jordansparks » Wed Sep 17, 2008 8:19 am

That was a pretty big change. It is unusual to have such a big change. Almost all changes are, instead addition of new fields and tables. As for what the changes are, see
https://70.90.133.65:23793/svn/opendent ... atabase.cs
and
https://70.90.133.65:23793/svn/opendent ... tabase2.cs
Both of those files are very similar. There's just two because the first one was getting too long. Both of those files are a series of methods grouped by version. For example,

Code: Select all

///<summary></summary>
private void To5_0_0() {
is the starting point for the conversion to 5.0.0. That starts on line 5377. Unfortunately Internet Explorer doesn't display line numbers. But you could save those two files to disk and then open them in a better text editor. So lines 5377 through 7784 in the first file, and lines 1 through 450 in the second file will show you all the changes. So nearly 3000 lines worth of changes. I can't possibly list all those changes here. It's true that many of those lines are irrelevant, but there are still a lot of changes. We add features very rapidly. I will try to get this page updated:
http://www.open-dent.com/manual/programmers.html
to show the new version.
Jordan Sparks, DMD
http://www.opendental.com

TonyMcManus
Posts: 12
Joined: Thu Jul 10, 2008 10:17 am
Contact:

Re: tables/data fields before and after V5

Post by TonyMcManus » Wed Sep 17, 2008 4:10 pm

This is great - thank you.
Tony McManus
Dental Senders, CEO
www.dentalsenders.com

Post Reply