Here's a replacement that works:

BEGIN;
CREATE TABLE smileys (
  id            serial PRIMARY KEY,
  acronyms      varchar(255) DEFAULT '' NOT NULL,
  image         varchar(255) DEFAULT '' NOT NULL,
  description   varchar(64) DEFAULT '' NOT NULL,
  standalone    INT2 NOT NULL DEFAULT '0'
);
COMMIT;

Comments

Gurpartap Singh’s picture

Status: Needs review » Closed (fixed)