<?php
$schema['ff_acl'] = array(
'description' => 'Table storing association codes tied to a user id.',
'fields' => array(
'aid' => array(
'type' => 'serial',
'unsigned' => TRUE,
'not null' => TRUE
),
'uid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE
),
'nid' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE
),
'sku' => array(
'type' => 'varchar',
'length' => 64,
'not null' => FALSE,
'description'=> 'The products sku/model number.'
),
'order_id' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE
),
'expires' => array(
'type' => 'int',
'unsigned' => TRUE,
'not null' => FALSE,
'description'=> 'Access expiration time.'
),
),
'primary key' => array('aid')
);
print_r($schema);
preferences:
57.94 ms | 402 KiB | 5 Q