PostgreSQL schema for mx_modsdb 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_modsdb
View previous topic :: View next topic  
Author Message
markus
[Administrator]
[Administrator]


Joined: 28 Jul 2003
Posts: 1124

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

Before installing the module, please apply the following changes:

OPEN: modules/mx_modsdb/db_install.php

FIND:
Code:
"DROP TABLE IF EXISTS ".MODSDB_ITEMS_TABLE,
"CREATE TABLE ".MODSDB_ITEMS_TABLE." (
   mod_id         SMALLINT(5)      UNSIGNED      NOT NULL auto_increment,
   mod_title      VARCHAR(50)      NOT NULL,
   mod_version      VARCHAR(10)      NOT NULL,
   mod_description   text,
   mod_url         VARCHAR(100),
   mod_author      VARCHAR(50),
   mod_download   VARCHAR(255),
   PRIMARY KEY (mod_id)
)"


REPLACE WITH:
Code:
"DROP TABLE ".MODSDB_ITEMS_TABLE,
"CREATE TABLE ".MODSDB_ITEMS_TABLE." (
   mod_id         SERIAL,
   mod_title      VARCHAR(50)      NOT NULL,
   mod_version      VARCHAR(10)      NOT NULL,
   mod_description   text,
   mod_url         VARCHAR(100),
   mod_author      VARCHAR(50),
   mod_download   VARCHAR(255),
   CONSTRAINT ".MODSDB_ITEMS_TABLE."_pkey PRIMARY KEY (mod_id)
)"

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