[lms] lms.pgsql - blad

Mały błąd w skrypcie tworzenia tabel PG (dzisiejszy CVS)

Jest:

CREATE TABLE cash ( id integer DEFAULT nextval('cash_id_seq'::text) NOT NULL, time integer DEFAULT 0 NOT NULL, adminid integer DEFAULT 0 NOT NULL, type smallint DEFAULT 0 NOT NULL, value float4 DEFAULT 0 NOT NULL, userid integer DEFAULT 0 NOT NULL, comment varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (id); );

Powinno być

CREATE TABLE cash ( id integer DEFAULT nextval('cash_id_seq'::text) NOT NULL, time integer DEFAULT 0 NOT NULL, adminid integer DEFAULT 0 NOT NULL, type smallint DEFAULT 0 NOT NULL, value float4 DEFAULT 0 NOT NULL, userid integer DEFAULT 0 NOT NULL, comment varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (id) );

- brak średnika za PRIMARY KEY (id)

Pozdrawiam Maurycy