1
wishcraft
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 [size=x-large]XOOPS Forum - XOOPS Documenting Team[/size] 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/RegaltyFamily
github.com/Chronolabs-Cooperative
facebook.com/DrAntonyRoberts

Login

Who's Online

226 user(s) are online (112 user(s) are browsing Support Forums)


Members: 0


Guests: 226


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits