資料庫 Schema API

function MNAME_schema() {
    $schema[''] = array( // table name
        'description' => '', //資料表敘述
        'fields' => array( // 欄位集合
            'nid' => array( //欄位名稱
                'description' => '',
                'type' => 'serial', //int, varchar, float, text, datetime, numeric
                'not null' => TRUE,
                //'size' => ,
                'unsigned' => TRUE,
                'default' => 0,
            ),
        ),
        'primary key' => array(''), // array(欄位集)
        'indexes' => array( '' => array(''), ), // 名稱 => array(欄位集)
        'unique keys' => array( '' => array('', ''), ), // 名稱 => array(欄位集)
        'foreign keys' => array(
            '' => array( // 名稱
                'table' => '', //參照 table name
                'columns' => array('' => ''), // 本地欄位 => 參照欄位
            ),
        ),        
    );
    return $schema;
}

function NNAME_update_7002() {
  db_rename_table('原名稱', '新名稱');
}

function NNAME_schema_alter(&$schema) {
  // Add field to existing schema.
  $schema['node']['fields']['marked'] = array(
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => TRUE,
    'default' => 0,
    'description' => t('Whether the node has been marked by the markednode module.'),
  );
}

$field['fieldname'] = array(
   'type' => 'varchar', // Required.
   'length' => 255, // Required.
   'not null' => TRUE, // Defaults to FALSE.
   'default' => 'chocolate', // See below.
   'description' => t('Always state the purpose of your field.'),
); 

$field['fieldname'] = array(
  'type' => 'char',           // Required.
  'length' => 64,             // Required.
  'not null' => TRUE,         // Defaults to FALSE.
  'default' => 'strawberry',  // See below.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'text',   // Required.
  'size' => 'small',  // tiny | small | normal | medium | big
  'not null' => TRUE, // Defaults to FALSE.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'int',    // Required.
  'unsigned' => TRUE, // Defaults to FALSE.
  'size' => 'small',  // tiny | small | medium | normal | big
  'not null' => TRUE, // Defaults to FALSE.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'serial',  // Required.
  'unsigned' => TRUE,  // Defaults to FALSE. Serial numbers are usually positive.
  'size' => 'small',   // tiny | small | medium | normal | big
  'not null' => TRUE,  // Defaults to FALSE. Typically TRUE for serial fields.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'float',  // Required.
  'unsigned' => TRUE,  // Defaults to FALSE.
  'size' => 'normal',   // tiny | small | medium | normal | big
  'not null' => TRUE, // Defaults to FALSE.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'numeric', // Required.
  'unsigned' => TRUE,  // Defaults to FALSE.
  'precision' => 5,    // Significant digits.
  'scale' => 2,        // Digits to the right of the decimal.
  'not null' => TRUE,  // Defaults to FALSE.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'datetime', // Required.
  'not null' => TRUE,   // Defaults to FALSE.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'type' => 'blob',   // Required.
  'size' => 'normal'  // normal | big
  'not null' => TRUE, // Defaults to FALSE.
  'description' => t('Always state the purpose of your field.'),
);

$field['fieldname'] = array(
  'mysql_type' > 'TINYBLOB',  // MySQL will use this.
  'type' => 'blob',           // Other databases will use this.
  'size' => 'normal',         // Other databases will use this.
  'not null' => TRUE,
  'description' => t('Wee little blobs.')
);