project name : library management System dbpage3

INSERT INTO `purchase` VALUES ('',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

#
# Table structure for table subcategory
#

DROP TABLE IF EXISTS `subcategory`;
CREATE TABLE `subcategory` (
  `CategoryId` varchar(11) default NULL,
  `SubcategoryId` varchar(11) NOT NULL default '',
  `SubcategoryName` varchar(50) default NULL,
  PRIMARY KEY  (`SubcategoryId`),
  UNIQUE KEY `Categoryid` (`CategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table subcategory
#


#
# Table structure for table topics
#

DROP TABLE IF EXISTS `topics`;
CREATE TABLE `topics` (
  `SubcategoryId` varchar(11) default NULL,
  `BookId` varchar(11) NOT NULL default '0',
  `TopicName` varchar(50) default NULL,
  `Rack` int(11) default NULL,
  `PurchaseId` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`BookId`),
  UNIQUE KEY `SubcategoryId` (`SubcategoryId`),
  KEY `PurchaseId` (`PurchaseId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table topics
#


#
# Table structure for table userregister
#

DROP TABLE IF EXISTS `userregister`;
CREATE TABLE `userregister` (
  `UserId` varchar(11) NOT NULL default '',
  `GroupId` varchar(11) default NULL,
  `UserUserName` varchar(100) default NULL,
  `UserPassword` varchar(30) default NULL,
  `UserDeptName` varchar(50) default NULL,
  `Batch` varchar(11) default NULL,
  `NoOfBookAllowed` int(11) default NULL,
  `CardOne` varchar(11) default NULL,
  `CardTwo` varchar(11) default NULL,
  `CardThree` varchar(11) default NULL,
  `UserRenewal` varchar(50) default NULL,
  `ModeratorId` varchar(11) default NULL,
  PRIMARY KEY  (`UserId`),
  UNIQUE KEY `Moderator` (`ModeratorId`),
  UNIQUE KEY `group` (`GroupId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED;

#
# Dumping data for table userregister
#


#
#  Foreign keys for table bookissue
#

ALTER TABLE `bookissue`
  ADD FOREIGN KEY (`BookId`) REFERENCES `topics` (`BookId`),
  ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
#  Foreign keys for table bookorder
#

ALTER TABLE `bookorder`
  ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
#  Foreign keys for table category
#

ALTER TABLE `category`
  ADD FOREIGN KEY (`DepartmentId`) REFERENCES `librarydepartment` (`DepartmentId`);

#
#  Foreign keys for table finedetails
#

ALTER TABLE `finedetails`
  ADD FOREIGN KEY (`BookIssueId`) REFERENCES `bookissue` (`BookIssueId`),
  ADD FOREIGN KEY (`GropId`) REFERENCES `groups` (`GroupId`),
  ADD FOREIGN KEY (`UserId`) REFERENCES `bookissue` (`UserId`);

#
#  Foreign keys for table groups
#

ALTER TABLE `groups`
  ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
#  Foreign keys for table librarydepartment
#

ALTER TABLE `librarydepartment`
  ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);

#
#  Foreign keys for table moderator
#

ALTER TABLE `moderator`
  ADD FOREIGN KEY (`AdminId`) REFERENCES `login` (`AdminId`);

#
#  Foreign keys for table purchase
#

ALTER TABLE `purchase`
  ADD FOREIGN KEY (`AdminId`) REFERENCES `login` (`AdminId`),
  ADD FOREIGN KEY (`OrderNo`) REFERENCES `bookorder` (`OrderNo`);

#
#  Foreign keys for table subcategory
#

ALTER TABLE `subcategory`
  ADD FOREIGN KEY (`CategoryId`) REFERENCES `category` (`CategoryId`);

#
#  Foreign keys for table topics
#

ALTER TABLE `topics`
  ADD FOREIGN KEY (`PurchaseId`) REFERENCES `purchase` (`PurchaseId`),
  ADD FOREIGN KEY (`SubcategoryId`) REFERENCES `subcategory` (`SubcategoryId`);

#
#  Foreign keys for table userregister
#

ALTER TABLE `userregister`
  ADD FOREIGN KEY (`GroupId`) REFERENCES `groups` (`GroupId`),
  ADD FOREIGN KEY (`ModeratorId`) REFERENCES `moderator` (`ModeratorId`);


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

THE COMPLETE DATABASE OF LIB DOWNLOAD HERE

Posted in: