0 Replies Latest reply on Nov 18, 2003 1:50 PM by pawelec_p

    error in setup.ddl for HSQL

    pawelec_p Newbie

      Like in subject.
      I think CREATE TABLE nuke_users should looks like this or maybe there should be something more.
      This one works good.

      CREATE TABLE nuke_users (
      pn_uid INTEGER NOT NULL IDENTITY,
      pn_uname VARCHAR(25) NOT NULL,
      pn_user_regdate TIMESTAMP,
      pn_user_viewemail BIT,
      pn_name VARCHAR(60) DEFAULT '' NOT NULL,
      pn_email VARCHAR(60) DEFAULT '' NOT NULL,
      pn_femail VARCHAR(60) DEFAULT '' NOT NULL,
      pn_url VARCHAR(254) DEFAULT '' NOT NULL,
      pn_timezone_offset INTEGER DEFAULT '0' NOT NULL,
      pn_user_avatar VARCHAR(30) DEFAULT 'blank.gif' NOT NULL,
      pn_user_icq VARCHAR(15) DEFAULT '' NOT NULL,
      pn_user_aim VARCHAR(18) DEFAULT '' NOT NULL,
      pn_user_yim VARCHAR(25) DEFAULT '' NOT NULL,
      pn_user_msnm VARCHAR(25) DEFAULT '' NOT NULL,
      pn_user_from VARCHAR(100) DEFAULT '' NOT NULL,
      pn_user_lang INTEGER DEFAULT '0' NOT NULL,
      pn_user_occ VARCHAR(100) DEFAULT '' NOT NULL,
      pn_user_intrest VARCHAR(150) DEFAULT '' NOT NULL,
      pn_user_sig VARCHAR(255) DEFAULT '' NOT NULL,
      pn_bio VARCHAR DEFAULT '' NOT NULL,
      pn_pass VARCHAR(40) DEFAULT '' NOT NULL,
      pn_theme VARCHAR(255) DEFAULT '' NOT NULL,
      pn_storynum INTEGER DEFAULT '10' NOT NULL,
      pn_ublockon BIT,
      pn_ublock VARCHAR DEFAULT '' NOT NULL,
      pn_umode VARCHAR(10) DEFAULT '' NOT NULL,
      pn_uorder INTEGER DEFAULT '0' NOT NULL,
      pn_thold INTEGER DEFAULT '0' NOT NULL,
      pn_noscore BIT,
      pn_prev_last_visit TIMESTAMP ,
      pn_last_visit TIMESTAMP ,
      pn_commentmax INTEGER DEFAULT '4096' NOT NULL
      );