Background:
I had been hoping to run a PhP Mysql Apache Linux for a distance learning app (called Moodle)
I now have to run it on a PhP Access (IIS?) Win2k system
How do I port a piece of code for setting up a Mysql db to one that sets up an equivalent Access db ?
A sample of the code I need to port is given below
phpMyAdmin MySQL-Dump
version 2.3.0-dev
#
Host: localhost
Generation Time: Jun 25, 2002 at 05:04 PM
Server version: 3.23.49
PHP Version: 4.1.2
Database : moodle
--------------------------------------------------------
#
Table structure for table config
#
CREATE TABLE config (
id int(10) unsigned NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
value varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY name (name)
) TYPE=MyISAM COMMENT='Moodle configuration variables';
--------------------------------------------------------
#
Table structure for table course
#
CREATE TABLE course (
id int(10) unsigned NOT NULL auto_increment,
category int(10) unsigned NOT NULL default '0',
password varchar(50) NOT NULL default '',
fullname varchar(254) NOT NULL default '',
shortname varchar(15) NOT NULL default '',
summary text NOT NULL,
format enum('weeks','social','topics') NOT NULL default 'weeks',
newsitems smallint(5) unsigned NOT NULL default '1',
teacher varchar(100) NOT NULL default 'Teacher',
student varchar(100) NOT NULL default 'Student',
guest tinyint(2) unsigned NOT NULL default '0',
startdate int(10) unsigned NOT NULL default '0',
numsections smallint(5) unsigned NOT NULL default '1',
marker int(10) unsigned NOT NULL default '0',
timecreated int(10) unsigned NOT NULL default '0',
timemodified int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
--------------------------------------------------------
The rest of the code is similar - lots of tables....
I have been told if I can port this code, the app will work with the Access db
You ideas very gratefully received!!!
Pi
