I created the dump file from my current DB to make adjustments and also migrate to
Innodb tables. In the process I have tried to add some ENUM types in select table.
Obviously, I am doing something wrong as each one give me a syntax error 1064 when I
try to source in the text file. I've read the manual and do not see where my error is.
Can someone point out what is wrong on the below table?
Thanks in advance
Bob
-- MySQL dump 9.10
--
-- Host: bartis-1 Database: stingertrdb4
-- ------------------------------------------------------
-- Server version 4.0.18-max-debug
--
-- Table structure for table `feature_list`
--
DROP TABLE IF EXISTS feature_list;
CREATE TABLE feature_list (
Feature varchar(50) default NOT NULL,
New ENUM('Y','N') NOT NULL,
Owner varchar(50) default NOT NULL,
NewFeatureDescription varchar(255) default NOT NULL,
DateMod datetime NOT NULL default 'YYYY-MM-DD HH:MM:SS',
PRIMARY KEY Feature (Feature),
INDEX Owner (Owner),
FOREIGN KEY (Owner) REFERENCES tester_list(Tester) ON UPDATE CASCADE ON DELETE
RESTRICT
) TYPE=InnoDB;
Robert M. Bartis
Lucent Technologies ¢
Room HO 1C-413A (HO) / 1B-304 (WH)
( 732.949.4565 (HO) / 973.386.7426 (WH)
* [EMAIL PROTECTED]
