I'm running phpWebsite, and the sql statement is for a single sign on hack. This is the original statement, that does work on MySQL running on Linux.
This same statement in MySQL running on Windows returns an error 1017 can't find file.
Adding Engine=MyISAM creates the table, but does not populate it with data.
I want the fin_mod tables to be populated by the mod_ tables, creating a virtual table.
Like i said this works on MySQL running on Linux.
-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
--
http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 01, 2005 at 07:29 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.10
--
-- Code to merge branch user tables into a hub for phpWebSite 0.10.1
-- Andrew Patterson
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_notes`
--
DROP TABLE IF EXISTS `fin_mod_notes`;
CREATE TABLE `fin_mod_notes` (
`id` int(11) NOT NULL default '0',
`toUser` varchar(20) default NULL,
`toUserHide` smallint(6) NOT NULL default '0',
`toGroup` varchar(30) default NULL,
`fromUser` varchar(20) NOT NULL default '',
`fromUserHide` smallint(6) NOT NULL default '0',
`message` text NOT NULL,
`dateSent` datetime NOT NULL default '0000-00-00 00:00:00',
`dateRead` datetime NOT NULL default '0000-00-00 00:00:00',
`userRead` varchar(20) default NULL,
`subject` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_notes);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_notes_seq`
--
DROP TABLE IF EXISTS `fin_mod_notes_seq`;
CREATE TABLE `fin_mod_notes_seq` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_notes_seq);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_groups`
--
DROP TABLE IF EXISTS `fin_mod_user_groups`;
CREATE TABLE `fin_mod_user_groups` (
`group_id` int(10) unsigned NOT NULL default '0',
`group_name` varchar(30) default NULL,
`description` text,
`members` text,
PRIMARY KEY (`group_id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_groups);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_groups_seq`
--
DROP TABLE IF EXISTS `fin_mod_user_groups_seq`;
CREATE TABLE `fin_mod_user_groups_seq` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_groups_seq);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_groupvar`
--
DROP TABLE IF EXISTS `fin_mod_user_groupvar`;
CREATE TABLE `fin_mod_user_groupvar` (
`group_id` int(10) unsigned NOT NULL default '0',
`module_title` varchar(20) NOT NULL default '',
`varName` varchar(30) NOT NULL default '',
`varValue` text,
KEY `user_id` (`group_id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_groupvar);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_menu`
--
DROP TABLE IF EXISTS `fin_mod_user_menu`;
CREATE TABLE `fin_mod_user_menu` (
`menu` varchar(30) NOT NULL default '',
`mod_title` varchar(30) NOT NULL default '',
`type` varchar(5) NOT NULL default '',
`submenu` varchar(30) NOT NULL default '',
`menuOrder` smallint(6) NOT NULL default '0'
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_menu);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_sessions`
--
DROP TABLE IF EXISTS `fin_mod_user_sessions`;
CREATE TABLE `fin_mod_user_sessions` (
`session_hash` varchar(32) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
`timeout` int(10) unsigned NOT NULL default '0',
KEY `session_hash` (`session_hash`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_sessions);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_settings`
--
DROP TABLE IF EXISTS `fin_mod_user_settings`;
CREATE TABLE `fin_mod_user_settings` (
`allow_cookies` smallint(6) NOT NULL default '0',
`timelimit` int(11) NOT NULL default '30',
`secure` smallint(6) NOT NULL default '0',
`user_signup` varchar(6) default NULL,
`max_log_attempts` int(11) NOT NULL default '10',
`nu_subj` varchar(255) default NULL,
`greeting` text,
`user_contact` varchar(255) default NULL,
`user_authentication` text,
`external_auth_file` text,
`show_login` smallint(6) NOT NULL default '1',
`show_remember_me` smallint(6) default NULL,
`welcomeURL` text
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_settings);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_user_uservar`
--
DROP TABLE IF EXISTS `fin_mod_user_uservar`;
CREATE TABLE `fin_mod_user_uservar` (
`user_id` int(10) unsigned NOT NULL default '0',
`module_title` varchar(20) NOT NULL default '',
`varName` varchar(30) NOT NULL default '',
`varValue` text,
KEY `user_id` (`user_id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_uservar);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_users`
--
DROP TABLE IF EXISTS `fin_mod_users`;
CREATE TABLE `fin_mod_users` (
`user_id` int(10) unsigned NOT NULL default '0',
`username` varchar(20) binary NOT NULL default '',
`password` varchar(32) binary NOT NULL default '',
`email` varchar(50) default NULL,
`admin_switch` smallint(6) NOT NULL default '0',
`groups` text,
`deity` smallint(6) NOT NULL default '0',
`log_sess` int(10) unsigned NOT NULL default '0',
`last_on` int(10) unsigned NOT NULL default '0',
`cookie` varchar(32) default NULL,
PRIMARY KEY (`user_id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_users);
-- --------------------------------------------------------
--
-- Table structure for table `fin_mod_users_seq`
--
DROP TABLE IF EXISTS `fin_mod_users_seq`;
CREATE TABLE `fin_mod_users_seq` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MERGE INSERT_METHOD=LAST UNION=(mod_user_seq);