PostgreSQL schema for mx_chatbox v1.2.2
 
 
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_chatbox
View previous topic :: View next topic  
Author Message
markus
[Administrator]
[Administrator]


Joined: 28 Jul 2003
Posts: 1124

PostPosted: Sat Apr 02, 2005 3:34 pm    Post subject: PostgreSQL schema for mx_chatbox v1.2.2 Reply with quote

Before installing the module, please apply the following changes:

OPEN: modules/mx_chatbox/db_install.php

FIND:
Code:
"DROP TABLE ".CHATBOX_TABLE,
"CREATE TABLE ".CHATBOX_TABLE." (
   id int(11) NOT NULL auto_increment,
   name varchar(99) NOT NULL,
   msg varchar(255) NOT NULL,
   timestamp int(10) unsigned NOT NULL,
   PRIMARY KEY (id)
)",
"DROP TABLE ".CHATBOX_SESSION_TABLE,
"CREATE TABLE ".CHATBOX_SESSION_TABLE." (
   username varchar(99) NOT NULL,
   lastactive int(10) DEFAULT '0' NOT NULL,
   laststatus varchar(8) NOT NULL,
   user_id mediumint(1) DEFAULT '-1' NOT NULL,
   UNIQUE username (username)
)",
//
// Added in mx_chatbox v.1.1.0
//
"CREATE TABLE ".CHATBOX_CONFIG_TABLE." (
   config_name varchar(255) NOT NULL default '',
   config_value varchar(255) NOT NULL default '',
   PRIMARY KEY  (config_name)
)",


REPLACE WITH:
Code:
"DROP TABLE ".CHATBOX_TABLE,
"CREATE TABLE ".CHATBOX_TABLE." (
   id SERIAL,
   name varchar(99) NOT NULL,
   msg varchar(255) NOT NULL,
   timestamp int NOT NULL,
   CONSTRAINT ".CHATBOX_TABLE."_pkey PRIMARY KEY (id)
)",
"DROP TABLE ".CHATBOX_SESSION_TABLE,
"CREATE TABLE ".CHATBOX_SESSION_TABLE." (
   username varchar(99) NOT NULL,
   lastactive int DEFAULT '0' NOT NULL,
   laststatus varchar(8) NOT NULL,
   user_id smallint DEFAULT '-1' NOT NULL
)",
"CREATE UNIQUE INDEX ".CHATBOX_SESSION_TABLE."_username_idx ON ".CHATBOX_SESSION_TABLE." (username)",
//
// Added in mx_chatbox v.1.1.0
//
"CREATE TABLE ".CHATBOX_CONFIG_TABLE." (
   config_name varchar(255) NOT NULL default '',
   config_value varchar(255) NOT NULL default '',
   CONSTRAINT ".CHATBOX_CONFIG_TABLE."_pkey PRIMARY KEY  (config_name)
)",

 
 
_________________
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_chatbox 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