Ad Widget

Collapse

1.3.3 mysql schema not working

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fmal
    Junior Member
    • Mar 2007
    • 1

    #1

    1.3.3 mysql schema not working

    mysqld Ver 4.0.13-standard for ibm-aix5.1.0.0 on powerpc

    in create/mysql/schema.sql at line 98:
    CREATE TABLE history_str_sync (
    id serial ,
    nodeid bigint unsigned DEFAULT '0' NOT NULL,
    itemid bigint unsigned DEFAULT '0' NOT NULL,
    clock integer DEFAULT '0' NOT NULL,
    value varchar(255) DEFAULT '' NOT NULL,
    PRIMARY KEY (id)
    );

    The "serial" work is not known to mysql. Maybe it is a postgresql schema?
Working...