Missing tables after migration
Posted by: Matthew Isleb
Date: January 05, 2006 07:26PM
Date: January 05, 2006 07:26PM
Hi,
I'm migrating an Access database to MySQL 4.1. The database has 180 tables. I want to migrate them all, but after the dust settles, I am missing 2 tables. There were no errors that I could find. But I did see something strange in the "Creating Objects" log. It says it is creating one of the tables, but it is missing the actual SQL:
-----
Creating table PERSONAL INFORMATION TABLE ...
DROP TABLE IF EXISTS `ace`.`PERSONAL INFORMATION TABLE`
Creating table RANGE OF MILES PICK LIST ...
DROP TABLE IF EXISTS `ace`.`RANGE OF MILES PICK LIST`
Creating table RANGE OF MILES PICK LIST ...
CREATE TABLE `ace`.`RANGE OF MILES PICK LIST` (
`RANGE OF MILES` SMALLINT(5) NULL
)
ENGINE = MyISAM
-----
The missing table is PERSONAL INFORMATION TABLE. According to GUI, object creation was "successfully completed."
I grabbed the SQL code for that table which was generated in a previous step and manually ran it against the database. It created the table without any errors. So why does it "fail" when MT tries to do it? I can't find errors anywhere.
The only thing "strange" about this table is that it has a lot of fields. Here is the SQL for that table:
-----
CREATE TABLE `ace`.`PERSONAL INFORMATION TABLE` (
`ACADEMIC ADVISOR` VARCHAR(5) NULL,
`ACT COMP (S/R)` SMALLINT(5) NULL,
`Registration` VARCHAR(30) NULL,
`Scholarship` VARCHAR(30) NULL,
`ACTIVITY3` VARCHAR(30) NULL,
`ADMISSIONS COUNSELOR` VARCHAR(30) NULL,
`ADMISSIONS OFFICE RATING` INT(10) NULL,
`ADMIT LETTER` VARCHAR(65) NULL,
`ADMIT LETTER SENT DATE` DATETIME NULL,
`AGE` SMALLINT(5) NULL,
`ALIEN NUMBER` VARCHAR(15) NULL,
`AOP ID` INT(10) NOT NULL,
`APPLY AS` VARCHAR(20) NULL,
`CAMPUS` VARCHAR(35) NULL,
`CAREER PLAN1` VARCHAR(25) NULL,
`CAREER PLAN2` VARCHAR(25) NULL,
`CAREER PLAN3` VARCHAR(25) NULL,
`CH ID` INT(10) NULL,
`CHURCH NAME` VARCHAR(50) NULL,
`CITIZENSHIP` VARCHAR(26) NULL,
`CITY OF BIRTH` VARCHAR(50) NULL,
`Interest Level` VARCHAR(50) NULL,
`Choice` VARCHAR(40) NULL,
`Fin Aid` VARCHAR(40) NULL,
`COST OF EDUCATION` DECIMAL(19, 4) NULL,
`COURSE LOAD STATUS` VARCHAR(35) NULL,
`DATE CHANGED` DATETIME NULL,
`DATE EARLY FINANCIAL AID ESTIMATE AWARDED` DATETIME NULL,
`DATE ENTERED` DATETIME NULL,
`DATE OF BIRTH` DATETIME NULL,
`Deferal Term` VARCHAR(50) NULL,
`DEGREE1` VARCHAR(50) NULL,
`DEGREE2` VARCHAR(50) NULL,
`DEGREE3` VARCHAR(50) NULL,
`DEPENDENCY STATUS` VARCHAR(50) NULL,
`DEPOSIT AMOUNT` DECIMAL(19, 4) NULL,
`DISABILITY CODE` VARCHAR(20) NULL,
`EARLY FINANCIAL AID ESTIMATE (Y=YES)` VARCHAR(1) NULL,
`EARLY FINANCIAL AID ESTIMATE APPLY RECVD DATE` DATETIME NULL,
`E-MAIL ADDRESS` VARCHAR(50) NULL,
`ENROLLMENTTERM` INT(10) NULL,
`EPS CODE` VARCHAR(6) NULL,
`ETHNIC ORIGIN` VARCHAR(50) NULL,
`EXPECTED DEPOSIT DATE` DATETIME NULL,
`EXPECTED FAMILY CONTRIBUTION` DECIMAL(19, 4) NULL,
`FAX NUMBER` VARCHAR(14) NULL,
`FILE LABEL` TINYINT(1) NOT NULL,
`FILE COMPLETE DATE` DATETIME NULL,
`FINANCIAL AID COMMENTS` LONGTEXT NULL,
`PORT REVIEW DECISION` VARCHAR(45) NULL,
`PORT REVIEW DATE` DATETIME NULL,
`FIRST NAME` VARCHAR(25) NULL,
`FOREIGN FINANCIAL STATEMENT RECVD` DATETIME NULL,
`FORMER LAST NAME` VARCHAR(35) NULL,
`FORMER STUDENT (Y=YES)` VARCHAR(1) NULL,
`GENDER` VARCHAR(10) NULL,
`HIGH SCHOOL` VARCHAR(75) NULL,
`HIGH SCHOOL CLASS RANK` SMALLINT(5) NULL,
`HIGH SCHOOL CLASS SIZE` SMALLINT(5) NULL,
`HIGH SCHOOL CLASS STANDING %` DOUBLE(15, 5) NULL,
`HIGH SCHOOL CODE` VARCHAR(8) NULL,
`HIGH SCHOOL GPA` DOUBLE(7, 2) NULL,
`HIGH SCHOOL GRAD YEAR` SMALLINT(5) NULL,
`HIGH SCHOOL GRADE SCALE` VARCHAR(5) NULL,
`HIGH SCHOOL RATING` VARCHAR(20) NULL,
`HIGH SCHOOL TRANS RECVD DATE` DATETIME NULL,
`HIGH SCHOOL TRANSCRIPT STATUS` VARCHAR(1) NULL,
`HIGH SCHOOL TYPE` VARCHAR(13) NULL,
`HONOR1` VARCHAR(30) NULL,
`HONOR2` VARCHAR(30) NULL,
`HONOR3` VARCHAR(30) NULL,
`HOUSING APPLY DATE` DATETIME NULL,
`HOUSING DEP RECVD DATE` DATETIME NULL,
`HOUSING TYPE` VARCHAR(15) NULL,
`INQ1 SOURCE CODE` VARCHAR(60) NULL,
`INQ2 SOURCE CODE` VARCHAR(60) NULL,
`How Hear` VARCHAR(60) NULL,
`INQ2 Source Description` VARCHAR(60) NULL,
`INSTITUTION FINANCIAL AID APPLY RECVD DATE` DATETIME NULL,
`ISAR RECVD DATE` DATETIME NULL,
`LAST NAME` VARCHAR(35) NULL,
`LETTER TRACK` VARCHAR(50) NULL,
`MAILING ADDRESS1` VARCHAR(35) NULL,
`MAILING ADDRESS2` VARCHAR(35) NULL,
`MAILING ADDRESS3` VARCHAR(35) NULL,
`MAILING ADDRESS EXP DATE` DATETIME NULL,
`MAILING CITY` VARCHAR(35) NULL,
`MAILING COUNTY` VARCHAR(35) NULL,
`MAILING COUNTRY` VARCHAR(50) NULL,
`MAILING PHONE` VARCHAR(14) NULL,
`MAILING STATE/REGION` VARCHAR(20) NULL,
`MAILING ZIP` VARCHAR(15) NULL,
`MAILING ZIP4` VARCHAR(5) NULL,
`MAJOR1` VARCHAR(40) NULL,
`MAJOR2` VARCHAR(40) NULL,
`MAJOR3` VARCHAR(40) NULL,
`MARITAL STATUS` VARCHAR(10) NULL,
`MERIT SCHOLARSHIP (Y=YES)` VARCHAR(1) NULL,
`MERIT SCHOLARSHIP APPLY RECVD DATE` DATETIME NULL,
`MIDDLE INITIAL` VARCHAR(2) NULL,
`MIDDLE NAME` VARCHAR(25) NULL,
`MILES FROM CAMPUS` SMALLINT(5) NULL,
`Missing App Docs Hold Ltr Dt` DATETIME NULL,
`Missing App Docs Ltr #` INT(10) NULL,
`NAME PREFIX` VARCHAR(15) NULL,
`NAME SUFFIX` VARCHAR(15) NULL,
`Need` DECIMAL(19, 4) NULL,
`NEED BASED FINANCIAL AID (Y=YES)` VARCHAR(1) NULL,
`NICKNAME` VARCHAR(25) NULL,
`NUMBER IN COLLEGE` TINYINT(3) UNSIGNED NULL,
`NUMBER OF FAMILY MEMBERS` TINYINT(3) UNSIGNED NULL,
`OUR CHURCH (Y=YES)` VARCHAR(1) NULL,
`PARENTS AGI` DECIMAL(19, 4) NULL,
`PARENT'S MARITAL STATUS` VARCHAR(10) NULL,
`PARENTS NET WORTH` DECIMAL(19, 4) NULL,
`PERMANENT ADDRESS1` VARCHAR(35) NULL,
`PERMANENT ADDRESS2` VARCHAR(35) NULL,
`PERMANENT ADDRESS3` VARCHAR(35) NULL,
`PERMANENT CITY` VARCHAR(35) NULL,
`PERMANENT COUNTY` VARCHAR(35) NULL,
`PERMANENT COUNTRY` VARCHAR(50) NULL,
`PERMANENT PHONE` VARCHAR(14) NULL,
`PERMANENT RESIDENT (Y=YES)` VARCHAR(1) NULL,
`PERMANENT STATE/REGION` VARCHAR(20) NULL,
`PERMANENT ZIP` VARCHAR(15) NULL,
`PERMANENT ZIP4` VARCHAR(5) NULL,
`PRIMARY LANGUAGE SPOKEN` VARCHAR(50) NULL,
`REASON` VARCHAR(50) NULL,
`RELIGIOUS PREFERENCE` VARCHAR(50) NULL,
`RESUME RECVD DATE` DATETIME NULL,
`SAR RECVD DATE` DATETIME NULL,
`SAT COMP (S/R)` SMALLINT(5) NULL,
`SELF-REPORTED HIGH SCHOOL CLASS RANK` VARCHAR(10) NULL,
`SOCIAL SECURITY #` VARCHAR(9) NULL,
`STATE OF BIRTH` VARCHAR(30) NULL,
`STATE OF RESIDENCE` VARCHAR(30) NULL,
`STUDENT + SPOUSE AGI` DECIMAL(19, 4) NULL,
`STUDENT + SPOUSE NET WORTH` DECIMAL(19, 4) NULL,
`STUDENT TYPE` VARCHAR(35) NULL,
`TERRITORY` VARCHAR(20) NULL,
`TIME OF ATTENDANCE` VARCHAR(14) NULL,
`UPDATED BY` VARCHAR(50) NULL,
`PNCA Grad` VARCHAR(20) NULL,
`VARSITY SPORT2` VARCHAR(20) NULL,
`VARSITY SPORT3` VARCHAR(20) NULL,
`VETERAN (Y=YES)` VARCHAR(1) NULL,
`VISA DATE` DATETIME NULL,
`VISA TYPE` VARCHAR(25) NULL,
`VOL REC AFFILIATION` VARCHAR(10) NULL,
`VOL REC RECRUITER` VARCHAR(50) NULL,
`VR ID` INT(10) NULL,
`WEB PAGE` LONGTEXT NULL,
`WHO ENTERED` VARCHAR(50) NULL,
`WORK PHONE` VARCHAR(14) NULL,
`WORK PHONE EXT` VARCHAR(10) NULL,
`DUPLICATE STATUS` VARCHAR(50) NULL,
`DUPLICATE DATE` DATETIME NULL,
`ARCHIVE` TINYINT(1) NOT NULL,
`FILE CHECKED OUT BY` VARCHAR(50) NULL,
`FILE CHECKED OUT DATE` DATETIME NULL,
`FILE RETURNED DATE` DATETIME NULL,
`Hometown Newspaper` VARCHAR(70) NULL,
`Portfolio Date In` DATETIME NULL,
`Portfolio Date Out` DATETIME NULL,
`Portfolio Reviewer` VARCHAR(50) NULL,
`Portfolio Type` VARCHAR(50) NULL,
`Essay Rating` DOUBLE(7, 2) NULL,
`Portfolio Rating` DOUBLE(7, 2) NULL,
`Grade Level` SMALLINT(5) NULL,
`Essay Date Received` DATETIME NULL,
`GED Score` INT(10) NULL,
`GED Date` DATETIME NULL,
`Documents Hyperlink` LONGTEXT NULL,
`Inquiry Label` TINYINT(1) NOT NULL,
`Foundation Status` VARCHAR(50) NULL,
`Old AOP ID` INT(10) NULL,
PRIMARY KEY (`LAST NAME`, `FIRST NAME`, `MAILING CITY`, `MAILING ADDRESS1`),
UNIQUE INDEX `AOP ID` (`AOP ID`),
UNIQUE INDEX `SOCIAL SECURITY #` (`SOCIAL SECURITY #`),
INDEX `CH ID` (`CH ID`),
INDEX `DISABILITY CODE` (`DISABILITY CODE`),
INDEX `EPS CODE` (`EPS CODE`),
INDEX `HIGH SCHOOL CODE` (`HIGH SCHOOL CODE`),
INDEX `INQ1 SOURCE CODE` (`INQ1 SOURCE CODE`),
INDEX `INQ2 SOURCE CODE` (`INQ2 SOURCE CODE`),
INDEX `NUMBER IN COLLEGE` (`NUMBER IN COLLEGE`),
INDEX `NUMBER OF FAMILY MEMBERS` (`NUMBER OF FAMILY MEMBERS`),
INDEX `Old AOP ID` (`Old AOP ID`),
INDEX `Portfolio Reviewer` (`Portfolio Reviewer`),
INDEX `VR ID` (`VR ID`)
)
ENGINE = MyISAM;
-----
Ideas?
-matthew
I'm migrating an Access database to MySQL 4.1. The database has 180 tables. I want to migrate them all, but after the dust settles, I am missing 2 tables. There were no errors that I could find. But I did see something strange in the "Creating Objects" log. It says it is creating one of the tables, but it is missing the actual SQL:
-----
Creating table PERSONAL INFORMATION TABLE ...
DROP TABLE IF EXISTS `ace`.`PERSONAL INFORMATION TABLE`
Creating table RANGE OF MILES PICK LIST ...
DROP TABLE IF EXISTS `ace`.`RANGE OF MILES PICK LIST`
Creating table RANGE OF MILES PICK LIST ...
CREATE TABLE `ace`.`RANGE OF MILES PICK LIST` (
`RANGE OF MILES` SMALLINT(5) NULL
)
ENGINE = MyISAM
-----
The missing table is PERSONAL INFORMATION TABLE. According to GUI, object creation was "successfully completed."
I grabbed the SQL code for that table which was generated in a previous step and manually ran it against the database. It created the table without any errors. So why does it "fail" when MT tries to do it? I can't find errors anywhere.
The only thing "strange" about this table is that it has a lot of fields. Here is the SQL for that table:
-----
CREATE TABLE `ace`.`PERSONAL INFORMATION TABLE` (
`ACADEMIC ADVISOR` VARCHAR(5) NULL,
`ACT COMP (S/R)` SMALLINT(5) NULL,
`Registration` VARCHAR(30) NULL,
`Scholarship` VARCHAR(30) NULL,
`ACTIVITY3` VARCHAR(30) NULL,
`ADMISSIONS COUNSELOR` VARCHAR(30) NULL,
`ADMISSIONS OFFICE RATING` INT(10) NULL,
`ADMIT LETTER` VARCHAR(65) NULL,
`ADMIT LETTER SENT DATE` DATETIME NULL,
`AGE` SMALLINT(5) NULL,
`ALIEN NUMBER` VARCHAR(15) NULL,
`AOP ID` INT(10) NOT NULL,
`APPLY AS` VARCHAR(20) NULL,
`CAMPUS` VARCHAR(35) NULL,
`CAREER PLAN1` VARCHAR(25) NULL,
`CAREER PLAN2` VARCHAR(25) NULL,
`CAREER PLAN3` VARCHAR(25) NULL,
`CH ID` INT(10) NULL,
`CHURCH NAME` VARCHAR(50) NULL,
`CITIZENSHIP` VARCHAR(26) NULL,
`CITY OF BIRTH` VARCHAR(50) NULL,
`Interest Level` VARCHAR(50) NULL,
`Choice` VARCHAR(40) NULL,
`Fin Aid` VARCHAR(40) NULL,
`COST OF EDUCATION` DECIMAL(19, 4) NULL,
`COURSE LOAD STATUS` VARCHAR(35) NULL,
`DATE CHANGED` DATETIME NULL,
`DATE EARLY FINANCIAL AID ESTIMATE AWARDED` DATETIME NULL,
`DATE ENTERED` DATETIME NULL,
`DATE OF BIRTH` DATETIME NULL,
`Deferal Term` VARCHAR(50) NULL,
`DEGREE1` VARCHAR(50) NULL,
`DEGREE2` VARCHAR(50) NULL,
`DEGREE3` VARCHAR(50) NULL,
`DEPENDENCY STATUS` VARCHAR(50) NULL,
`DEPOSIT AMOUNT` DECIMAL(19, 4) NULL,
`DISABILITY CODE` VARCHAR(20) NULL,
`EARLY FINANCIAL AID ESTIMATE (Y=YES)` VARCHAR(1) NULL,
`EARLY FINANCIAL AID ESTIMATE APPLY RECVD DATE` DATETIME NULL,
`E-MAIL ADDRESS` VARCHAR(50) NULL,
`ENROLLMENTTERM` INT(10) NULL,
`EPS CODE` VARCHAR(6) NULL,
`ETHNIC ORIGIN` VARCHAR(50) NULL,
`EXPECTED DEPOSIT DATE` DATETIME NULL,
`EXPECTED FAMILY CONTRIBUTION` DECIMAL(19, 4) NULL,
`FAX NUMBER` VARCHAR(14) NULL,
`FILE LABEL` TINYINT(1) NOT NULL,
`FILE COMPLETE DATE` DATETIME NULL,
`FINANCIAL AID COMMENTS` LONGTEXT NULL,
`PORT REVIEW DECISION` VARCHAR(45) NULL,
`PORT REVIEW DATE` DATETIME NULL,
`FIRST NAME` VARCHAR(25) NULL,
`FOREIGN FINANCIAL STATEMENT RECVD` DATETIME NULL,
`FORMER LAST NAME` VARCHAR(35) NULL,
`FORMER STUDENT (Y=YES)` VARCHAR(1) NULL,
`GENDER` VARCHAR(10) NULL,
`HIGH SCHOOL` VARCHAR(75) NULL,
`HIGH SCHOOL CLASS RANK` SMALLINT(5) NULL,
`HIGH SCHOOL CLASS SIZE` SMALLINT(5) NULL,
`HIGH SCHOOL CLASS STANDING %` DOUBLE(15, 5) NULL,
`HIGH SCHOOL CODE` VARCHAR(8) NULL,
`HIGH SCHOOL GPA` DOUBLE(7, 2) NULL,
`HIGH SCHOOL GRAD YEAR` SMALLINT(5) NULL,
`HIGH SCHOOL GRADE SCALE` VARCHAR(5) NULL,
`HIGH SCHOOL RATING` VARCHAR(20) NULL,
`HIGH SCHOOL TRANS RECVD DATE` DATETIME NULL,
`HIGH SCHOOL TRANSCRIPT STATUS` VARCHAR(1) NULL,
`HIGH SCHOOL TYPE` VARCHAR(13) NULL,
`HONOR1` VARCHAR(30) NULL,
`HONOR2` VARCHAR(30) NULL,
`HONOR3` VARCHAR(30) NULL,
`HOUSING APPLY DATE` DATETIME NULL,
`HOUSING DEP RECVD DATE` DATETIME NULL,
`HOUSING TYPE` VARCHAR(15) NULL,
`INQ1 SOURCE CODE` VARCHAR(60) NULL,
`INQ2 SOURCE CODE` VARCHAR(60) NULL,
`How Hear` VARCHAR(60) NULL,
`INQ2 Source Description` VARCHAR(60) NULL,
`INSTITUTION FINANCIAL AID APPLY RECVD DATE` DATETIME NULL,
`ISAR RECVD DATE` DATETIME NULL,
`LAST NAME` VARCHAR(35) NULL,
`LETTER TRACK` VARCHAR(50) NULL,
`MAILING ADDRESS1` VARCHAR(35) NULL,
`MAILING ADDRESS2` VARCHAR(35) NULL,
`MAILING ADDRESS3` VARCHAR(35) NULL,
`MAILING ADDRESS EXP DATE` DATETIME NULL,
`MAILING CITY` VARCHAR(35) NULL,
`MAILING COUNTY` VARCHAR(35) NULL,
`MAILING COUNTRY` VARCHAR(50) NULL,
`MAILING PHONE` VARCHAR(14) NULL,
`MAILING STATE/REGION` VARCHAR(20) NULL,
`MAILING ZIP` VARCHAR(15) NULL,
`MAILING ZIP4` VARCHAR(5) NULL,
`MAJOR1` VARCHAR(40) NULL,
`MAJOR2` VARCHAR(40) NULL,
`MAJOR3` VARCHAR(40) NULL,
`MARITAL STATUS` VARCHAR(10) NULL,
`MERIT SCHOLARSHIP (Y=YES)` VARCHAR(1) NULL,
`MERIT SCHOLARSHIP APPLY RECVD DATE` DATETIME NULL,
`MIDDLE INITIAL` VARCHAR(2) NULL,
`MIDDLE NAME` VARCHAR(25) NULL,
`MILES FROM CAMPUS` SMALLINT(5) NULL,
`Missing App Docs Hold Ltr Dt` DATETIME NULL,
`Missing App Docs Ltr #` INT(10) NULL,
`NAME PREFIX` VARCHAR(15) NULL,
`NAME SUFFIX` VARCHAR(15) NULL,
`Need` DECIMAL(19, 4) NULL,
`NEED BASED FINANCIAL AID (Y=YES)` VARCHAR(1) NULL,
`NICKNAME` VARCHAR(25) NULL,
`NUMBER IN COLLEGE` TINYINT(3) UNSIGNED NULL,
`NUMBER OF FAMILY MEMBERS` TINYINT(3) UNSIGNED NULL,
`OUR CHURCH (Y=YES)` VARCHAR(1) NULL,
`PARENTS AGI` DECIMAL(19, 4) NULL,
`PARENT'S MARITAL STATUS` VARCHAR(10) NULL,
`PARENTS NET WORTH` DECIMAL(19, 4) NULL,
`PERMANENT ADDRESS1` VARCHAR(35) NULL,
`PERMANENT ADDRESS2` VARCHAR(35) NULL,
`PERMANENT ADDRESS3` VARCHAR(35) NULL,
`PERMANENT CITY` VARCHAR(35) NULL,
`PERMANENT COUNTY` VARCHAR(35) NULL,
`PERMANENT COUNTRY` VARCHAR(50) NULL,
`PERMANENT PHONE` VARCHAR(14) NULL,
`PERMANENT RESIDENT (Y=YES)` VARCHAR(1) NULL,
`PERMANENT STATE/REGION` VARCHAR(20) NULL,
`PERMANENT ZIP` VARCHAR(15) NULL,
`PERMANENT ZIP4` VARCHAR(5) NULL,
`PRIMARY LANGUAGE SPOKEN` VARCHAR(50) NULL,
`REASON` VARCHAR(50) NULL,
`RELIGIOUS PREFERENCE` VARCHAR(50) NULL,
`RESUME RECVD DATE` DATETIME NULL,
`SAR RECVD DATE` DATETIME NULL,
`SAT COMP (S/R)` SMALLINT(5) NULL,
`SELF-REPORTED HIGH SCHOOL CLASS RANK` VARCHAR(10) NULL,
`SOCIAL SECURITY #` VARCHAR(9) NULL,
`STATE OF BIRTH` VARCHAR(30) NULL,
`STATE OF RESIDENCE` VARCHAR(30) NULL,
`STUDENT + SPOUSE AGI` DECIMAL(19, 4) NULL,
`STUDENT + SPOUSE NET WORTH` DECIMAL(19, 4) NULL,
`STUDENT TYPE` VARCHAR(35) NULL,
`TERRITORY` VARCHAR(20) NULL,
`TIME OF ATTENDANCE` VARCHAR(14) NULL,
`UPDATED BY` VARCHAR(50) NULL,
`PNCA Grad` VARCHAR(20) NULL,
`VARSITY SPORT2` VARCHAR(20) NULL,
`VARSITY SPORT3` VARCHAR(20) NULL,
`VETERAN (Y=YES)` VARCHAR(1) NULL,
`VISA DATE` DATETIME NULL,
`VISA TYPE` VARCHAR(25) NULL,
`VOL REC AFFILIATION` VARCHAR(10) NULL,
`VOL REC RECRUITER` VARCHAR(50) NULL,
`VR ID` INT(10) NULL,
`WEB PAGE` LONGTEXT NULL,
`WHO ENTERED` VARCHAR(50) NULL,
`WORK PHONE` VARCHAR(14) NULL,
`WORK PHONE EXT` VARCHAR(10) NULL,
`DUPLICATE STATUS` VARCHAR(50) NULL,
`DUPLICATE DATE` DATETIME NULL,
`ARCHIVE` TINYINT(1) NOT NULL,
`FILE CHECKED OUT BY` VARCHAR(50) NULL,
`FILE CHECKED OUT DATE` DATETIME NULL,
`FILE RETURNED DATE` DATETIME NULL,
`Hometown Newspaper` VARCHAR(70) NULL,
`Portfolio Date In` DATETIME NULL,
`Portfolio Date Out` DATETIME NULL,
`Portfolio Reviewer` VARCHAR(50) NULL,
`Portfolio Type` VARCHAR(50) NULL,
`Essay Rating` DOUBLE(7, 2) NULL,
`Portfolio Rating` DOUBLE(7, 2) NULL,
`Grade Level` SMALLINT(5) NULL,
`Essay Date Received` DATETIME NULL,
`GED Score` INT(10) NULL,
`GED Date` DATETIME NULL,
`Documents Hyperlink` LONGTEXT NULL,
`Inquiry Label` TINYINT(1) NOT NULL,
`Foundation Status` VARCHAR(50) NULL,
`Old AOP ID` INT(10) NULL,
PRIMARY KEY (`LAST NAME`, `FIRST NAME`, `MAILING CITY`, `MAILING ADDRESS1`),
UNIQUE INDEX `AOP ID` (`AOP ID`),
UNIQUE INDEX `SOCIAL SECURITY #` (`SOCIAL SECURITY #`),
INDEX `CH ID` (`CH ID`),
INDEX `DISABILITY CODE` (`DISABILITY CODE`),
INDEX `EPS CODE` (`EPS CODE`),
INDEX `HIGH SCHOOL CODE` (`HIGH SCHOOL CODE`),
INDEX `INQ1 SOURCE CODE` (`INQ1 SOURCE CODE`),
INDEX `INQ2 SOURCE CODE` (`INQ2 SOURCE CODE`),
INDEX `NUMBER IN COLLEGE` (`NUMBER IN COLLEGE`),
INDEX `NUMBER OF FAMILY MEMBERS` (`NUMBER OF FAMILY MEMBERS`),
INDEX `Old AOP ID` (`Old AOP ID`),
INDEX `Portfolio Reviewer` (`Portfolio Reviewer`),
INDEX `VR ID` (`VR ID`)
)
ENGINE = MyISAM;
-----
Ideas?
-matthew
Subject
Written By
Posted
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.