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
