|
|
Posted by J.O. Aho on 06/19/06 17:37
Frankly wrote:
> "J.O. Aho" <user@example.net> wrote in message
> what i was thinking with that new table
> was that it could very well be that i had to delete some of the relations
> and create new ones using that new table. I felt like anything thing i did
> was a total guess. yes i did think of just making creations from those
> fields.
Okey, like a temp table? That could be useful. The reason I was so against the
table was that there was no image id anywhere else and you had it already
building and apartment relations in the apartment table.
I do regret that I did tell my opinion in such strong words and I understand
it was a hard blow for you.
> basically what i did was research my choices, see who says what is easiest
> and who thinks what are the best. my main concern was money. i didnt want
> to start a path only to find out that at the end i would need a program that
> cost a few grand.
*nods*
Thats always a risk that comes, as long as you don't have the option of making
it yourself and have the time to spend.
> I finished up enough work so that I can now put these tables
> in my admin. I am going to be adding a few new fields that I use to post
> adds to online realestate pages. see you soon :). after that i will try to
> create the relations.
I would suggest when you have created your tables, make a "backup" of the
database, this way you can experiment with filling test data and see that
everything works, and if they do, you can easily recreate an empty database
with all the tables empty and IDs starting from 1 again.
I hope it will go well for you and don't forget ALTER TABLE if you notice that
your table is missing something after you have created it and filled it with
test data, instead of dropping it and make a new one and then fill it again
with data, you can make the changes directly.
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html (works the same way in
older versions too).
//Aho
Navigation:
[Reply to this message]
|