[Web-meetme-devel] Re-structuring the WMM database

[Dan A. <Dan...@Ph...>]

I've started looking at merging the functionality
of app_cbmysql into app_meetme.  One of the results
is that I am not completely happy with the current
table layout.

I'm thinking to split booking into two tables, one
for the actual conference settings, and one for the
ownership/description details.  This would allow me
to reduce the overall DB size and allow app_meetme
to only retrieve information it needs.

The major drawback to this is I think I will need to
write an upgrade script to migrate data from the current
layout to the new one.  Which is something I am sure
to screw up.

Before investing too much time on this I thought I would
ask for comments on the new layout I am proposing, and see
if anyone would like to help with the upgrade script.

CREATE TABLE `booking` (
  `bookId` int(10) unsigned NOT NULL auto_increment,
  `confno` varchar(30) default '0',
  `userpin` varchar(30) NOT NULL default '0',
  `modpin` varchar(30) NOT NULL default '0',
  `uFlags` varchar(10) NOT NULL default '',
  `mFlags` varchar(10) NOT NULL default '',
  `maxUser` varchar(30) NOT NULL default '10',
  `startTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `endTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `dateReq` datetime NOT NULL default '0000-00-00 00:00:00',
  `dateMod` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` varchar(30) NOT NULL default 'A',
  `sequenceNo` int(10) unsigned default '0',
  `bdId` int(10) NOT NULL default '0',
  PRIMARY KEY  (`bookId`)
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1 AUTO_INCREMENT=3D145 ;

CREATE TABLE `bookingDetails` (
  `bookId` int(10) unsigned NOT NULL auto_increment,
  `clientId` int(10) unsigned default '0',
  `status` varchar(30) NOT NULL default 'A',
  `confOwner` varchar(30) NOT NULL default '',
  `confDesc` varchar(100) NOT NULL default '',
  `recurInterval` int(10) unsigned default '0',
  PRIMARY KEY  (`bookId`)
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1 AUTO_INCREMENT=3D145 ;

CREATE TABLE 'wmm_Version'(
	'ver' int (10) NOT NULL default '5',
	PRIMARY KEY ('ver')
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1 AUTO_INCREMENT=3D145 ;

The last table is intended to make future upgrades
easier by being able to check what version of the table
layout is in use.

Thanks,
Dan