Forum Replies Created

Viewing 1 replies (of 1 total)
  • Thread Starter cavila

    (@cavila)

    I created the table manually my entering the following
    CREATE TABLE COMMAND at Postgresql client:

    CREATE TABLE wp321_comments (
      comment_ID serial NOT NULL
     , comment_post_ID bigint NOT NULL default '0'
     , comment_author varchar NOT NULL, comment_author_email varchar(100) NOT NULL default ''
     , comment_author_url varchar(200) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default ''
     , comment_date timestamp NOT NULL default now(), comment_date_gmt timestamp NOT NULL default now()
     , comment_content text NOT NULL, comment_karma int NOT NULL default '0', comment_approved varchar(20) NOT NULL default '1'
     , comment_agent varchar(255) NOT NULL default '', comment_type varchar(20) NOT NULL default '', comment_parent bigint NOT NULL default '0'
     , user_id bigint NOT NULL default '0'
     , CONSTRAINT wp321_comments_pk PRIMARY KEY (comment_ID)
     --, KEY comment_approved (comment_approved), KEY comment_post_ID (comment_post_ID)
     --, KEY comment_approved_date_gmt (comment_approved,comment_date_gmt)
    -- , KEY comment_date_gmt (comment_date_gmt), KEY comment_parent (comment_parent)
     )
Viewing 1 replies (of 1 total)