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...
  • Quote Reply
    Re: [webmaster33] Links table duplication? In reply to
    I think that the biggest problem with adding custom tables is getting the search to work - have you considered this?
    Quote Reply
    Re: [afinlr] Links table duplication? In reply to
    Yes, IMO, I can create plugin to handle the different searches.
    Unfortunately GT hardcoded a lot table names thoughout the LSQL application, so the this makes the solution very difficult Frown


    How you see my proposal in previous post?
    Only these foreign keys seems to be related to the Links table, through the ID key, right?

    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...
    Quote Reply
    Re: [webmaster33] Links table duplication? In reply to
    I think there are also foreign key relations between the Links table and the Users table, aren't there? You should be able to see them all if you look in the Links.def file.
    Quote Reply
    Re: [afinlr] Links table duplication? In reply to
    Yes, but IMO the dependency is different.
    The Users table can live without Links table.

    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...
    Quote Reply
    Re: [webmaster33] Links table duplication? In reply to
    Yes - you're right - the dependency is the other way round. I think you have all the default ones in your list.
    The UK High Street
    Quote Reply
    Re: [afinlr] Links table duplication? In reply to
    Great!
    Thanks for confirming my proposal!

    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...
    Quote Reply
    Re: [webmaster33] Links table duplication? In reply to
    Just noted, that used wrong word.
    I meant "my guess" or "my presumption" or "my suspicion", instead of "my proposal".

    Eh, I should improve my English knowledge Blush

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

    Last edited by:

    webmaster33: Dec 9, 2005, 3:57 PM