General developer forum

Hi all,

I'm developing a plugin, which for I need some tables. One of those doesn't need an id column, in my data model, so I didn't add it to the DDL. But now, if I try to insert a record using:

$DB->insert_record()

<TABLE NAME="mytable">
      <FIELDS>
        <FIELD NAME="userid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
        <FIELD NAME="courseid" TYPE="int" LENGTH="10" NOTNULL="true" SEQUENCE="false"/>
        <FIELD NAME="year" TYPE="int" LENGTH="4" NOTNULL="true" SEQUENCE="false"/>
      </FIELDS>
      <KEYS>
        <KEY NAME="primary" TYPE="primary" FIELDS="userid, courseid"/>
        <KEY NAME="userid_fk" TYPE="foreign" FIELDS="userid" REFTABLE="user" REFFIELDS="id"/>
        <KEY NAME="courseid_fk" TYPE="foreign" FIELDS="courseid" REFTABLE="course" REFFIELDS="id"/>
      </KEYS>
    </TABLE>

And I try the insertion with the following code, following the DML API for inserting records:

$record = new stdClass();

$record->userid = $userid;
$record->courseid = $courseid;
$record->year = $year;

$DB->insert_record('mytable', $record);

And I get the error I mentioned above.

I didn't see anything about this in the DDL API.

So, is it completely necessary to have an 'id' column?

Thanks in advice,

Julen