forum.lissyara.su

Код: Выделить всё

CREATE TABLE session (    
    session    CHAR(32)     NOT NULL,    
    user_to     INT(11)       NOT NULL,    
    time       INT(11)      NOT NULL,      
  host       VARCHAR(100) NOT NULL,       
 ip         VARCHAR(100) NOT NULL,   
   forwarded  VARCHAR(100) NOT NULL,
PRIMARY KEY (session)
);

Код: Выделить всё

dbmail=> CREATE TABLE session (    
dbmail(>     session    CHAR(32)     NOT NULL,    
dbmail(>     user_to       INT(11)       NOT NULL,    
dbmail(>     time       INT(11)      NOT NULL,      
dbmail(>   host       VARCHAR(100) NOT NULL,       
dbmail(>  ip         VARCHAR(100) NOT NULL,   
dbmail(>    forwarded  VARCHAR(100) NOT NULL,
dbmail(> PRIMARY KEY (session)
dbmail(> );
ERROR:  syntax error at or near "("
LINE 3:     user_to       INT(11)       NOT NULL,  

Код: Выделить всё

CREATE TABLE session (    
    session    char(32)     NOT NULL,    
    user_to     bigint       NOT NULL,    
    time       int      NOT NULL,      
  host      varchar(100) NOT NULL,       
 ip         varchar(100) NOT NULL,   
   forwarded  varchar(100) NOT NULL,
CONSTRAINT session_pkey PRIMARY KEY (session)
);