-- Database: `nikahsearch`

-- Table structure for table `profile_reference`


CREATE TABLE `profile_reference` (
  `sno` int(11) NOT NULL,
  `OldProfileID` varchar(10) CHARACTER SET latin1 NOT NULL,
  `NewProfileID` varchar(10) CHARACTER SET latin1 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Indexes for table `profile_reference`

ALTER TABLE `profile_reference`
  ADD PRIMARY KEY (`sno`),
  ADD UNIQUE KEY `OldProfileID` (`OldProfileID`),
  ADD UNIQUE KEY `NewProfileID` (`NewProfileID`),
  ADD KEY `OldProfileID_2` (`OldProfileID`),
  ADD KEY `NewProfileID_2` (`NewProfileID`);

-- AUTO_INCREMENT for table `profile_reference`

ALTER TABLE `profile_reference`
  MODIFY `sno` int(11) NOT NULL AUTO_INCREMENT;