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...