I would like to discuss with an LSQL & Database expert, about the problem of duplicating the Links table.
It's not really duplication, but instead having the same Links table structure, but with changed content, changed name (i.e.: Links_other).
Can it cause any problem?
As I suppose only the foreign keys may cause problems, those which are pointing from another table to a Links table key.
The affected tables seems to be:
Changes Table: LinkID => 'ID'
Reviews Table: Review_LinkID => 'ID'
CatLinks Table: LinkID => 'ID'
Verify History Table: LinkID => 'ID'
Payments Table: payments_linkid => 'ID'
These tables are also needed to be duplicated, similarly like Links table name is changed to Links_other:
Changes_other
Reviews_other
CatLinks_other
Verify_other
Payments_other
Basically the tables listed above are needed to be duplicated, and I suppose nothing else.
Only these seems to be related to the Links table, through the ID key, right?
Did I miss anything?
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
It's not really duplication, but instead having the same Links table structure, but with changed content, changed name (i.e.: Links_other).
Can it cause any problem?
As I suppose only the foreign keys may cause problems, those which are pointing from another table to a Links table key.
The affected tables seems to be:
These tables are also needed to be duplicated, similarly like Links table name is changed to Links_other:
Changes_other
Reviews_other
CatLinks_other
Verify_other
Payments_other
Basically the tables listed above are needed to be duplicated, and I suppose nothing else.
Only these seems to be related to the Links table, through the ID key, right?
Did I miss anything?
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...