Typo in createtables.sql

[pilotsnipes@…]

There is a type in the createtables.sql file which prevents the table TABLEDEFS being created correctly.

Here it is:

CREATE TABLE `tabledefs` (
  `id` int(11) NOT NULL auto_increment,
  `displayname` varchar(64) default NULL,
  `type` varchar(16) NOT NULL default 'table',
  `moduleid` int(11) NOT NULL default '0',
  `maintable` varchar(64) NOT NULL default '',
  `querytable` varchar(255) NOT NULL default '',
  `editfile` varchar(128) default NULL,
  `editroleid` int(11) NOT NULL default '0',
  `addfile` varchar(100) default '',
  `addroleid` int(11) NOT NULL default '0',
  `searchroleid` int(11) NOT NULL default '0',
  `advsearchroleid` int(11) NOT NULL default '-100',
  `viewsqlroleid` int(11) NOT NULL default '-100',
  `deletebutton` varchar(32) default '',
  `defaultwhereclause` varchar(255) default NULL,
  `defaultsortorder` varchar(255) default '',
  `defaultsearchtype` varchar(64) default '',
  `defaultcriteriafindoptions` varchar(128) default '',
  `defaultcriteriaselection` varchar(128) default '',
  `createdby` int(11) NOT NULL default '0',
  `creationdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `modifiedby` int(11) default NULL,
  `modifieddate` timestamp NOT NULL,
  PRIMARY KEY  (`id`)
) THYPE=MyISAM AUTO_INCREMENT=1000;

The LAST line should NOT have an "H" in TYPE.

[anonymous]

The first line should read:

There is a typo...

[pilotsnipes@…]

More info:

It's Line 151 in /trunk/phpbms/install/createtables.sql

[brieb]

Fixed by [247]