Gossamer Forum
Quote Reply
Links table duplication?
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...
  • Subject Author Views Date
    Thread Links table duplication? webmaster33 2777 Dec 8, 2005, 6:24 PM
    Thread Re: [webmaster33] Links table duplication?
    afinlr 2662 Dec 9, 2005, 4:46 AM
    Thread Re: [afinlr] Links table duplication?
    webmaster33 2652 Dec 9, 2005, 7:41 AM
    Thread Re: [webmaster33] Links table duplication?
    afinlr 2632 Dec 9, 2005, 8:51 AM
    Thread Re: [afinlr] Links table duplication?
    webmaster33 2685 Dec 9, 2005, 9:01 AM
    Thread Re: [webmaster33] Links table duplication?
    afinlr 2676 Dec 9, 2005, 9:07 AM
    Thread Re: [afinlr] Links table duplication?
    webmaster33 2631 Dec 9, 2005, 9:19 AM
    Post Re: [webmaster33] Links table duplication?
    webmaster33 2659 Dec 9, 2005, 3:54 PM