MySQL Forums
Forum List  »  MyISAM

Re: help with MERGE
Posted by: Tommy de Jesus
Date: April 22, 2005 07:24AM

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);

Options: ReplyQuote


Subject
Views
Written By
Posted
3638
April 21, 2005 01:10PM
2572
April 22, 2005 04:51AM
Re: help with MERGE
3270
April 22, 2005 07:24AM
2581
April 22, 2005 12:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.