Fork me on GitHub

How to define a Multi-Field Primary Key in ADOdb  Bottom

  • I am trying to create a "link" table with two fields. Each links to a record in different table. I would like to make the primary key for this table a multi-field key being both keys. How is this done?

    For example,

    Quote


    $pntable['tablename_column_def'] = array (
    "oneid" => "I8 PRIMARY",
    "twoid" => "I8 PRIMARY"
    );

  • To answer my own question,

    Yes that is exactly how to do it!!!

    I had an error further up my code that was causing this to appear to fail!!!

This list is based on users active over the last 60 minutes.