PostgreSQL schema for mx_errordocs v1.0.0
 
 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    phpMiX.org Forum Index -> mxBB Modules -> mxBB Module: mx_errordocs
View previous topic :: View next topic  
Author Message
markus
[Administrator]
[Administrator]


Joined: 28 Jul 2003
Posts: 1124

PostPosted: Sat Apr 02, 2005 3:13 pm    Post subject: PostgreSQL schema for mx_errordocs v1.0.0 Reply with quote

Before installing the module, please apply the following changes:

OPEN: modules/mx_errordocs/db_install.php

FIND:
Code:
"CREATE TABLE ".ERRORDOCS_LOG_TABLE." (
   id            INT(11)         DEFAULT '0'      NOT NULL,
   tstamp         INT(11)         DEFAULT '0'      NOT NULL,
   errno         SMALLINT(5)      DEFAULT '0'      NOT NULL,
   user_id         MEDIUMINT(8)   DEFAULT '0'      NOT NULL,
   user_ip         CHAR(8)         DEFAULT '',
   request_uri      VARCHAR(255)   DEFAULT '',
   http_referer   VARCHAR(255)   DEFAULT '',
   PRIMARY KEY (tstamp)
)"


REPLACE WITH:
Code:
"CREATE TABLE ".ERRORDOCS_LOG_TABLE." (
   id            int         DEFAULT '0'      NOT NULL,
   tstamp         int         DEFAULT '0'      NOT NULL,
   errno         smallint      DEFAULT '0'      NOT NULL,
   user_id         int   DEFAULT '0'      NOT NULL,
   user_ip         CHAR(8)         DEFAULT '',
   request_uri      VARCHAR(255)   DEFAULT '',
   http_referer   VARCHAR(255)   DEFAULT '',
  CONSTRAINT ".ERRORDOCS_LOG_TABLE."_pkey PRIMARY KEY (tstamp)
)"

 
 
_________________
http://www.phpmix.org
 
Back to top
View user's profile Send private message
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.   printer-friendly view    phpMiX.org Forum Index -> mxBB Modules -> mxBB Module: mx_errordocs All times are GMT + 1 Hour
 
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum