Home » U++ Library support » U++ SQL » Fields of the same name in diff tables
Re: Fields of the same name in diff tables [message #21722 is a reply to message #21719] |
Tue, 02 June 2009 14:27 |
jeremy_c
Messages: 175 Registered: August 2007 Location: Ohio, USA
|
Experienced Member |
|
|
I like the idea of Ultimate++ generating table structures for me, I just think it needs a little more work and a little more documentation. Now, I am a database programmer by trade, so when it comes to an enterprise application, I doubt that UPP can ever keep up with what can be accomplished using the database, for instance, all sorts of trigger functions and other server side programming. For desktop applications w/simple databases, however, it's great.
Now, about managing SQL independent. What I do is I always have a directory structure such as:
project/docs
project/src
project/sql
project/sql/0001.sql
project/sql/0001_r.sql
project/sql/0002.sql
project/sql/0002_r.sql
0001.sql is the first version of my database schema. 0002.sql is the create/alter statements necessary to bring 0001.sql (current at the time) to my new version. So, if I were starting a new project, I could psql thedb < 0001.sql ... psql thedb < 0002.sql, etc... Now, 0001_r.sql and 0002_r.sql are "Revert" scripts which will undo the changes. I don't always make those but it's a good idea.
Jeremy
|
|
|
|
|
Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Mon, 01 June 2009 08:41
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Mon, 01 June 2009 17:34
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Mon, 01 June 2009 23:09
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Mon, 01 June 2009 23:30
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Mon, 01 June 2009 23:36
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Tue, 02 June 2009 14:50
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Tue, 02 June 2009 14:52
|
|
|
Re: Fields of the same name in diff tables
By: lectus on Thu, 20 December 2012 19:20
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Sun, 23 December 2012 10:17
|
|
|
Re: Fields of the same name in diff tables
By: mirek on Tue, 02 June 2009 14:47
|
|
|
Re: Fields of the same name in diff tables
By: mr_ped on Tue, 02 June 2009 10:33
|
Goto Forum:
Current Time: Fri Sep 20 09:20:53 CEST 2024
Total time taken to generate the page: 0.03443 seconds
|