Quotes module installer fails to create the 'quotes' table

The curly brackets are supposed to tell the database layer to insert the Drupal database name and prefix. Was there some other error message? Also, please select the correct release number so I look at the correct branch of the code.

The SQL for building the quotes table is invalid because the keyword "UNSIGNED" is in the wrong place.

The included code is:

db_query('CREATE TABLE {quotes} (
          nid INTEGER NOT NULL UNSIGNED,
          vid INTEGER NOT NULL PRIMARY KEY UNSIGNED,
          author VARCHAR(255) NOT NULL,
          citation VARCHAR(255),
          promote INTEGER UNSIGNED NOT NULL DEFAULT 0
        ) /*!40100 DEFAULT CHARACTER SET utf8 */');

It should be:

db_query('CREATE TABLE {quotes} (
          nid INTEGER UNSIGNED NOT NULL,
          vid INTEGER UNSIGNED NOT NULL PRIMARY KEY,
          author VARCHAR(255) NOT NULL,
          citation VARCHAR(255),
          promote INTEGER UNSIGNED NOT NULL DEFAULT 0
        ) /*!40100 DEFAULT CHARACTER SET utf8 */');

Thanks for the module!

Nick

Fix committed to -dev version.

Thank you for explanation! I had made even more changes: in quotes.install file the SQL-command looks
db_query('CREATE TABLE quotes (
nid INTEGER UNSIGNED NOT NULL,
vid INTEGER UNSIGNED NOT NULL PRIMARY KEY,
author VARCHAR(255) NOT NULL,
citation VARCHAR(255),
promote INTEGER UNSIGNED NOT NULL DEFAULT 0
)
(i.e. simply word quotes without {})

Now it works!

That doesn't make sense. The curly brackets tells Drupal to add the DB prefix if there is one. Removing them should NOT work.