Thread: 56000 profiles with pics

If anyone can tell me which program this mysql is for i will give them copy to play with,either original or basic Dolphin 6 version (Members show up ok but pics need putting in)

Code:

############################################################################## 	Default character set is: latin1
# 	MySQL client info: 4.1.22
# 	MySQL host info: Localhost via UNIX socket
# 	MySQL protocol version: 10
# 	MySQL server version: 4.1.22-standard


DROP TABLE IF EXISTS `Profiles`;
CREATE TABLE `Profiles` (
	`ID` bigint(8) unsigned NOT NULL auto_increment,
	`NickName` varchar(48) NOT NULL,
	`Password` varchar(48) NOT NULL,
	`ProfileType` enum('single','couple') DEFAULT 'single' NOT NULL,
	`RealName` varchar(40) NOT NULL,
	`RealName2` varchar(40) NOT NULL,
	`Country` smallint(5) unsigned DEFAULT '0' NOT NULL,
	`City` varchar(30),
	`Children` tinyint(3) unsigned DEFAULT '0' NOT NULL,
	`WhereChildren` enum('I will tell you later','living with me','not living with me','sometimes living with me') DEFAULT 'I will tell you later' NOT NULL,
	`Headline` varchar(255) NOT NULL,
	`DescriptionMe` mediumtext NOT NULL,
	`DescriptionYou` mediumtext NOT NULL,
	`Sex` enum('female','male','couple') DEFAULT 'female' NOT NULL,
	`Sex2` enum('female','male','couple') DEFAULT 'female' NOT NULL,
	`DateOfBirth` date DEFAULT '0000-00-00' NOT NULL,
	`DateOfBirth2` date DEFAULT '0000-00-00' NOT NULL,
	`Relationship` set('act','fri','mar','rel','rom','cas','tra','pen') NOT NULL,
	`Height` int(11) DEFAULT '0' NOT NULL,
	`Height2` int(11) DEFAULT '0' NOT NULL,
	`BodyType` int(11) DEFAULT '0' NOT NULL,
	`BodyType2` int(11) DEFAULT '0' NOT NULL,
	`Religion` int(11) DEFAULT '0' NOT NULL,
	`Religion2` int(11) DEFAULT '0' NOT NULL,
	`Ethnicity` int(11) DEFAULT '0' NOT NULL,
	`Ethnicity2` int(11) DEFAULT '0' NOT NULL,
	`MaritalStatus` int(11) DEFAULT '0' NOT NULL,
	`Occupation` varchar(30),
	`Occupation2` varchar(30),
	`Language1` int(11) DEFAULT '0' NOT NULL,
	`Language12` int(11) DEFAULT '0' NOT NULL,
	`Language2` int(11) DEFAULT '0' NOT NULL,
	`Language22` int(11) DEFAULT '0' NOT NULL,
	`Language3` int(11) DEFAULT '0' NOT NULL,
	`Language32` int(11) DEFAULT '0' NOT NULL,
	`Education` int(11) DEFAULT '0' NOT NULL,
	`Education2` int(11) DEFAULT '0' NOT NULL,
	`Income` int(11) DEFAULT '0' NOT NULL,
	`Income2` int(11) DEFAULT '0' NOT NULL,
	`Smoker` int(11) DEFAULT '0' NOT NULL,
	`Smoker2` int(11) DEFAULT '0' NOT NULL,
	`Drinker` int(11) DEFAULT '0' NOT NULL,
	`Drinker2` int(11) DEFAULT '0' NOT NULL,
	`WantChildren` enum('I will tell you later','No','Yes','Maybe','No matters') DEFAULT 'I will tell you later' NOT NULL,
	`MerchantPrice` float unsigned DEFAULT '3' NOT NULL,
	`Email` varchar(50) NOT NULL,
	`EmailFlag` enum('HTML','Text','Not sure') DEFAULT 'HTML' NOT NULL,
	`EmailNotify` enum('NotifyMe','NotNotifyMe') DEFAULT 'NotifyMe' NOT NULL,
	`Phone` varchar(30),
	`HomeAddress` varchar(100),
	`IM` enum('none','icq','yahoo','msn','aol') DEFAULT 'none' NOT NULL,
	`IcqUIN` varchar(15) NOT NULL,
	`Status` enum('Unconfirmed','Approval','Active','Rejected','Suspended') DEFAULT 'Unconfirmed' NOT NULL,
	`LastLoggedIn` datetime,
	`LastModified` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	`LastReg` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	`Priority` smallint(5) unsigned DEFAULT '1' NOT NULL,
	`HomePage` varchar(100),
	`LookingFor` enum('female','male','couple','both') DEFAULT 'male' NOT NULL,
	`LookingAge` varchar(7) DEFAULT '18-75' NOT NULL,
	`LookingHeight` int(11) DEFAULT '0' NOT NULL,
	`LookingBodyType` int(11) DEFAULT '0' NOT NULL,
	`Picture` enum('0','1') DEFAULT '0' NOT NULL,
	`Pic_0_addon` varchar(32) NOT NULL,
	`Pic_1_addon` varchar(32) NOT NULL,
	`Pic_2_addon` varchar(32) NOT NULL,
	`Pic_3_addon` varchar(32) NOT NULL,
	`Pic_4_addon` varchar(32) NOT NULL,
	`Pic_5_addon` varchar(32) NOT NULL,
	`Pic_6_addon` varchar(32) NOT NULL,
	`Pic_7_addon` varchar(32) NOT NULL,
	`Pic_8_addon` varchar(32) NOT NULL,
	`Pic_9_addon` varchar(32) NOT NULL,
	`Pic_10_addon` varchar(32) NOT NULL,
	`Sound` enum('0','1') DEFAULT '0' NOT NULL,
	`Sound_addon` tinyint(3) unsigned DEFAULT '0' NOT NULL,
	`Video` enum('0','1') DEFAULT '0' NOT NULL,
	`Video_addon` tinyint(3) unsigned DEFAULT '0' NOT NULL,
	`LastNavTime` datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	`LastNavPage` int(4) DEFAULT '0' NOT NULL,
	`Featured` enum('0','1') DEFAULT '0' NOT NULL,
	`aff_num` int(5) unsigned DEFAULT '0' NOT NULL,
	`priv_passwd` varchar(32) NOT NULL,
	`PPNotify` enum('NotifyMe','NotNotifyMe') DEFAULT 'NotifyMe' NOT NULL,
	`seed` int(11) DEFAULT '0' NOT NULL,
	`zip` varchar(23) NOT NULL,
	`guestbook` enum('Enable','Disable','Suspend') DEFAULT 'Enable',
	`mem_level` varchar(60) DEFAULT '1' NOT NULL,
	`mem_level_days` int(5) unsigned DEFAULT '1' NOT NULL,
   PRIMARY KEY (`ID`),
   UNIQUE NickName (`NickName`),
   KEY Country (`Country`),
   KEY Sex (`Sex`),
   KEY Status (`Status`),
   KEY LastLoggedIn (`LastLoggedIn`),
   KEY Priority (`Priority`),
   KEY LookingFor (`LookingFor`),
   KEY Picture (`Picture`),
   KEY seed (`seed`)
);

Looks like an aeDating profiles table...

Smoge