xoops forums

wishcraft

Module Developer
Posted on: 10/30 20:44
wishcraft
wishcraft (Show more)
Module Developer
Posts: 3711
Since: 2007/5/18
#1

XOOPS 2.6 - Modules Directory Table MySQL...

Hey Geekwright, since I last tried the XOOPS 2.6 install on my ubuntu desktop box which is what the code install examples and video should be in, IT WORKED!! so I will play with it later today when the sun goes down, this is only sun up threading... so what I think needs to be changed is the prefix_modules folder to the following as you still haven't yet addressed the planning documents in the XOOPS Forum - XOOPS Documenting Team which was released before you where even in the show Richard!!

Currently this is the prefix_modules table

CREATE TABLE `xxx__modules` (
  `
midsmallint(5unsigned NOT NULL AUTO_INCREMENT,
  `
namevarchar(150NOT NULL DEFAULT '',
  `
versionsmallint(5unsigned NOT NULL DEFAULT '100',
  `
last_updateint(10unsigned NOT NULL DEFAULT '0',
  `
weightsmallint(3unsigned NOT NULL DEFAULT '0',
  `
isactivetinyint(1unsigned NOT NULL DEFAULT '0',
  `
dirnamevarchar(25NOT NULL DEFAULT '',
  `
hasmaintinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasadmintinyint(1unsigned NOT NULL DEFAULT '0',
  `
hassearchtinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasconfigtinyint(1unsigned NOT NULL DEFAULT '0',
  `
hascommentstinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasnotificationtinyint(1unsigned NOT NULL DEFAULT '0',
  
PRIMARY KEY (`mid`),
  
KEY `hasmain` (`hasmain`),
  
KEY `hasadmin` (`hasadmin`),
  
KEY `hassearch` (`hassearch`),
  
KEY `hasnotification` (`hasnotification`),
  
KEY `dirname` (`dirname`),
  
KEY `name` (`name`(15)),
  
KEY `isactive` (`isactive`),
  
KEY `weight` (`weight`),
  
KEY `hascomments` (`hascomments`)
ENGINE=MyISAM AUTO_INCREMENT=DEFAULT CHARSET=utf8;


I think we need to update it too the followng at least:

[code]
CREATE TABLE `xxx__modules` (
  `
midsmallint(5unsigned NOT NULL AUTO_INCREMENT,
  `
typalenum('api','apps','modules','themes'NOT NULL DEFAULT 'modules',
  `
namevarchar(150NOT NULL DEFAULT '',
  `
versionsmallint(5unsigned NOT NULL DEFAULT '100',
  `
last_updateint(10unsigned NOT NULL DEFAULT '0',
  `
weightsmallint(3unsigned NOT NULL DEFAULT '0',
  `
isactivetinyint(1unsigned NOT NULL DEFAULT '0',
  `
dirnamevarchar(25NOT NULL DEFAULT '',
  `
hasmaintinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasadmintinyint(1unsigned NOT NULL DEFAULT '0',
  `
hassearchtinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasconfigtinyint(1unsigned NOT NULL DEFAULT '0',
  `
hascommentstinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasnotificationtinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasfeedtinyint(1unsigned NOT NULL DEFAULT '0',
  `
hasrewritetinyint(1unsigned NOT NULL DEFAULT '0',
  `
categoriesint(22unsigned NOT NULL DEFAULT '0',
  `
topicsint(22unsigned NOT NULL DEFAULT '0',
  `
itemsint(22unsigned NOT NULL DEFAULT '0',
  `
deletedint(22unsigned NOT NULL DEFAULT '0',
  `
editsint(22unsigned NOT NULL DEFAULT '0',
  `
commentsint(22unsigned NOT NULL DEFAULT '0',
  
PRIMARY KEY (`mid`),
  
KEY `hasmain` (`hasmain`),
  
KEY `hasadmin` (`hasadmin`),
  
KEY `hassearch` (`hassearch`),
  
KEY `hasnotification` (`hasnotification`),
  
KEY `dirname` (`dirname`),
  
KEY `name` (`name`(15)),
  
KEY `isactive` (`isactive`),
  
KEY `weight` (`weight`),
  
KEY `hascomments` (`hascomments`)
ENGINE=MyISAM AUTO_INCREMENT=DEFAULT CHARSET=utf8;
Resized Image
www.ohloh.net/accounts/226400

Follow, Like & Read:-

twitter.com/SimonXaies
github.com/Chronolabs-Cooperative
facebook.com/SimonSXaies