Module Table Schema [#979490]

i was studying userpoints databaseschema and found some uncalrity.

The above shows a snippet out of the userpoints.install
Both, pid and uid are 'description' => 'User ID'. I checked my tables and pid != uid. uid is the user id and pid is numers 1,2,3,4,5,6....x (primary key).

Do i get something wrong?

function userpoints_schema() {
  $schema = array();
  $schema['userpoints'] = array(
    'description' => 'Holds the user points',
    'fields' => array(
      'pid' => array(
        'description' => 'User ID',
        'type' => 'serial',
        'not null' => TRUE,
      ),
      'uid' => array(
        'description' => 'User ID',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ),

Comments

Comment #1

berdir

German

Switzerland

commented 23 November 2010 at 15:47

The description is wrong, pid is the primary key.

Comment #2

Anonymous (not verified) commented 27 August 2011 at 15:37

Component:

Code: userpoints_basic

» Code: userpoints

I examined the function userpoints_schema() and found towards the botton of the function the line
'primary key' => array('pid'). I hope this helps that the pid is infact the primary key