окей, спасибо вам
а вот такая вот
Результаты запроса
Ошибка SQL:
ERROR: sequence "pcat_catn_seq" does not exist
В операторе:
CREATE TABLE balance (
rasxod BOOL,
prihod BOOL,
slrsumm DECIMAL (7,2),
trnid INT
);
CREATE TABLE counter (
slrnum INT,
today INT,
alldays INT,
currdate DATE,
reserv INT
);
CREATE TABLE seller (
slrnum int,
wmid VARCHAR(12),
wmz VARCHAR(13),
orgname VARCHAR(20),
url VARCHAR(30),
email VARCHAR(30),
expiry date,
slrpassw VARCHAR(12),
slrsumm DECIMAL (7,2),
attestated BOOL,
blocked BOOL,
status vARCHAR(1),
sells INT,
rating INT,
master VARCHAR(12),
mailnot BOOL,
slrorag BOOL,
res TEXT
);
CREATE TABLE blobinfo (
bprodnum INT,
bfileoid INT,
bdeleted BOOL,
bselled BOOL,
bfilesize INT,
bfilename TEXT,
bdeldate DATE,
bselldate DATE,
res TEXT
);
CREATE TABLE shops (
shopnum INT,
buyerwmid VARCHAR(12),
prodnum INT,
oplachen INT,
date DATE,
wmtinvnum INT,
sid INT,
selled BOOL,
spassw VARCHAR(12),
res TEXT,
master INT,
mastersumm DECIMAL(7,2),
prodprice DECIMAL(7,2),
response BOOL
);
CREATE TABLE products (
slrnum INT,
prodcat INT,
prodname TEXT,
once BOOL,
price DECIMAL (7,2),
url TEXT,
prdsells INT,
selled BOOL,
comment TEXT,
reserved INT,
prodnum INT,
ptype BOOL,
deleted BOOL,
pdate DATE,
deldate DATE,
res TEXT,
recommend BOOL,
vip BOOL,
zalog DECIMAL (7,2),
stavka DECIMAL (7,2)[],
startdate DATE,
enddate DATE,
shows INT,
clicks INT
);
CREATE TABLE responses (
slrnum int,
resp TEXT,
date DATE,
wmz VARCHAR (13),
shopnum INT,
posneg BOOL
);
CREATE TABLE stat (
slrnum INT,
prodname TEXT,
prodprice DECIMAL(7,2),
shopnum INT,
status BOOL,
res TEXT
);
CREATE TABLE trnhist (
slrnum INT,
trnum INT,
date DATE,
summ DECIMAL(7,2),
refsumm DECIMAL(7,2)
);
DROP SEQUENCE pcat_catn_seq;
DROP TABLE pcat;
CREATE TABLE pcat (
node BOOL,
name TEXT,
catn serial
);
INSERT INTO pcat (node,name) VALUES (TRUE,\'CAPT\');