[development] Install Schema

[Bushidodeep]

Hi,

"Table" is a reserved world in MySQL


C





On Aug 6, 2009, at 12:29 PM, Damian Adriel Perez Valdes wrote:

> Hi:
>
> How can i install a table in mysql.
>
> I tried with this script but don't work.
>
> function tags_schema() {
> $schema['table'] = array(
>     'description' => t('The base table for nodes.'),
>     'fields' => array(
>       'nid' => array(
>         'description' => t('The primary identifier for a node.'),
>         'type' => 'serial',
>         'unsigned' => TRUE,
>         'not null' => TRUE),
>       'vid' => array(
>         'description' => t('The current {node_revisions}.vid version  
> identifier.'),
>         'type' => 'int',
>         'unsigned' => TRUE,
>         'not null' => TRUE,
>         'default' => 0),
>       'type' => array(
>         'description' => t('The {node_type} of this node.'),
>         'type' => 'varchar',
>         'length' => 32,
>         'not null' => TRUE,
>         'default' => ''),
>       'title' => array(
>         'description' => t('The title of this node, always treated a  
> non-markup plain text.'),
>         'type' => 'varchar',
>         'length' => 255,
>         'not null' => TRUE,
>         'default' => ''),
>       ),
>     'indexes' => array(
>       'node_changed'        => array('changed'),
>       'node_created'        => array('created'),
>       ),
>     'unique keys' => array(
>       'nid_vid' => array('nid', 'vid'),
>       'vid'     => array('vid')
>       ),
>     'primary key' => array('nid'),
>     );
> }
>
> function tags_install() {
> // Crea mi tabla
> drupal_install_schema('tags');
> }
>
> function tags_uninstall() {
> // Borra mi tabla
> drupal_uninstall_schema('tags');
> }
> ?>