DROP TABLE
IF EXISTS niceppl;
CREATE
TABLE `niceppl` (
`id` bigint(11) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(100) NOT NULL,
`country` varchar(100) NOT NULL,
`state` varchar(255) NOT NULL,
`city` varchar(100) NOT NULL,
`birth_1` date NOT NULL,
`birth_2` date NOT NULL,
`gender` varchar(255) NOT NULL,
`MaritalStatus` varchar(100) NOT NULL,
`Relocate` varchar(10) NOT NULL,
`Height_1` varchar(100) NOT NULL,
`Height_2` varchar(100) NOT NULL,
`BodyType_1` varchar(100) NOT NULL,
`BodyType_2` varchar(100) NOT NULL,
`Smoking_1` varchar(100) NOT NULL,
`Smoking_2` varchar(100) NOT NULL,
`Drinking_1` varchar(100) NOT NULL,
`Drinking_2` varchar(100) NOT NULL,
`Education_1` varchar(100) NOT NULL,
`Education_2` varchar(100) NOT NULL,
`Occupation_1` varchar(100) NOT NULL,
`Occupation_2` varchar(100) NOT NULL,
`Race_1` varchar(100) NOT NULL,
`Race_2` varchar(100) NOT NULL,
`Religion_1` varchar(100) NOT NULL,
`Religion_2` varchar(100) NOT NULL,
`SexualOrientation_1` varchar(100) NOT NULL,
`SexualOrientation_2` varchar(100) NOT NULL,
`MaleEndowment_1` varchar(100) NOT NULL,
`MaleEndowment_2` varchar(100) NOT NULL,
`Circumcised_1` varchar(100) NOT NULL,
`Circumcised_2` varchar(100) NOT NULL,
`BraSize_1` varchar(10) NOT NULL,
`BraSize_2` varchar(100) NOT NULL,
`Description` text NOT NULL,
`IdealPerson` text NOT NULL,
`seek` text NOT NULL,
`photos` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
KEY `birth_1` (`birth_1`),
KEY `birth_2` (`birth_2`),
KEY `MaritalStatus` (`MaritalStatus`),
KEY `Relocate` (`Relocate`),
KEY `type` (`gender`),
KEY `Race_1` (`Race_1`)
) ENGINE=MyISAM
/*!40101 DEFAULT CHARSET=latin1 */;
Hat jemand ne Idee wie ich die Daten importiert bekomme, da es weit über 300.000 Daten und Bilder sind möchte ich da keine 10 Versuche machen .-)
Wenn mir jemand helfen kann bitte hier oder per PM
Gruß
Axel
