Re: CREATE TABLE ignores DATA DIRECTORY option
DROP TABLE analyse.Testtable;
CREATE TABLE analyse.Testtable (
`DATUM_ID` int(11) DEFAULT NULL,
`AGB_DECL_ID` smallint(6) DEFAULT NULL,
`AGB_APOTHEEK_ID` smallint(6) DEFAULT NULL,
`AGB_APOTHEKER_ID` smallint(6) DEFAULT NULL,
`AGB_VERWIJZER_ID` smallint(6) DEFAULT NULL,
`BTW_TARIEF_ID` tinyint(4) DEFAULT NULL,
`CODE_ZRGEL_ID` smallint(6) DEFAULT NULL,
`FARMA_PRODUCT_ID` mediumint(6) DEFAULT NULL,
`ATC_ID` mediumint(9) DEFAULT NULL,
`NR_RECEPT_ID` int(11) DEFAULT NULL,
`POSTCODE_ID` mediumint(6) DEFAULT NULL,
`SOORT_VERZEKERING_ID` tinyint(4) DEFAULT NULL,
`TYPE_DECLARANT_ID` tinyint(4) DEFAULT NULL,
`VERZEKERDE_ID` mediumint(9) DEFAULT NULL,
`WMG_TARIEF_ID` smallint(4) DEFAULT NULL,
`BRONBESTAND_ID` mediumint(9) DEFAULT NULL,
`WERKSTROOM_ID` tinyint(4) DEFAULT NULL,
`KENM_AFL_EENH` varchar(10) DEFAULT NULL,
`AANT_EENH_AFL` decimal(10,0) DEFAULT NULL,
`BEDR_GEDECL` decimal(10,0) DEFAULT NULL,
`BEDR_DECL_FARM_EXCL` decimal(10,0) DEFAULT NULL,
`IND_WTG` varchar(1) DEFAULT NULL,
`IND_DEBET_CREDIT` varchar(1) DEFAULT NULL,
`CODE_GESL` varchar(1) DEFAULT NULL,
`S_BEDR_JOURNAALPOST` decimal(10,0) DEFAULT NULL,
`DECL_EXCL_BTW` decimal(10,0) DEFAULT NULL,
`laad_dt_bronbestand` timestamp NULL DEFAULT NULL,
`DDD_REGEL` decimal(20,10) DEFAULT NULL,
`LEEFTIJD` tinyint(4) DEFAULT NULL,
`ID_STG` bigint(20) NOT NULL DEFAULT '0',
`S_AANTAL_VERZEKERINGEN` tinyint(4) DEFAULT NULL,
`NR_SCHNOT` varchar(10) DEFAULT NULL,
`VNR_SCHRGL` varchar(10) DEFAULT NULL,
PRIMARY KEY (`ID_STG`),
KEY `IX_APO_DECL_DATUM` (`DATUM_ID`),
KEY `IX_APO_DECL_AGB_APO` (`AGB_APOTHEEK_ID`),
KEY `IX_APO_DECL_AGB_MDW` (`AGB_APOTHEKER_ID`),
KEY `IX_APO_DECL_AGB_DECL` (`AGB_DECL_ID`),
KEY `IX_APO_DECL_AGB_VERW` (`AGB_VERWIJZER_ID`),
KEY `IX_APO_DECL_BTW_TAR` (`BTW_TARIEF_ID`),
KEY `IX_APO_DECL_ZRGEL` (`CODE_ZRGEL_ID`),
KEY `IX_APO_DECL_FA_PRD` (`FARMA_PRODUCT_ID`),
KEY `IX_APO_DECL_ATC` (`ATC_ID`),
KEY `IX_APO_DECL_POSTCD` (`POSTCODE_ID`),
KEY `IX_APO_DECL_SOORT_VERZ` (`SOORT_VERZEKERING_ID`),
KEY `IX_APO_DECL_TYPE_DECL` (`TYPE_DECLARANT_ID`),
KEY `IX_APO_DECL_VERZ` (`VERZEKERDE_ID`),
KEY `IX_APO_DECL_WMG_TAR` (`WMG_TARIEF_ID`),
KEY `IX_APO_DECL_WERKSTR` (`WERKSTROOM_ID`),
KEY `IX_APO_DECL_BRONBESTAND` (`BRONBESTAND_ID`),
KEY `IX_APO_DECL_LEEFTIJD` (`LEEFTIJD`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
DATA DIRECTORY ='n:/Sophia/Data/Analyse'
INDEX DIRECTORY ='c:/Sophia/Data/Analyse';
Rudolf van der Heide
Data Warehouse Specialist
still new on MySQL