Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.6.5.2
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1:3307
- -- Generation Time: Feb 17, 2017 at 09:35 PM
- -- Server version: 10.1.21-MariaDB
- -- PHP Version: 7.1.1
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `agiledevtools`
- --
- DELIMITER $$
- --
- -- Procedures
- --
- CREATE DEFINER=`root`@`localhost` PROCEDURE `saveSprintBurndownDetails` (`SPRINT_ID_INPUT` DECIMAL(6,2), `BACKLOG_ID_INPUT` INT, `STORY_POINTS_INPUT` INT) BEGIN
- DECLARE rowCount INTEGER;
- SET rowCount = (select count(*) from sprintBurndownDetails where SPRINT_ID=SPRINT_ID_INPUT AND BACKLOG_ID=BACKLOG_ID_INPUT AND DATE(SPRINT_DATE)=CURDATE());
- IF (rowCount > 0)
- THEN
- UPDATE sprintBurndownDetails SET SPRINT_ID=SPRINT_ID_INPUT, BACKLOG_ID=BACKLOG_ID_INPUT, SPRINT_DATE=NOW(), STORY_POINT=STORY_POINTS_INPUT where SPRINT_ID=SPRINT_ID_INPUT AND BACKLOG_ID=BACKLOG_ID_INPUT AND DATE(SPRINT_DATE)=CURDATE();
- ELSE
- INSERT INTO sprintBurndownDetails SET SPRINT_ID=SPRINT_ID_INPUT, BACKLOG_ID=BACKLOG_ID_INPUT, SPRINT_DATE=NOW(), STORY_POINT=STORY_POINTS_INPUT;
- END IF;
- END$$
- DELIMITER ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `accountactivationlinks`
- --
- CREATE TABLE `accountactivationlinks` (
- `ID` char(13) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `accountactivationlinks`
- --
- INSERT INTO `accountactivationlinks` (`ID`) VALUES
- ('58a74e443f458'),
- ('58a74fa89135e');
- -- --------------------------------------------------------
- --
- -- Table structure for table `adminuserslicense`
- --
- CREATE TABLE `adminuserslicense` (
- `ACTIVATION_KEY` char(30) NOT NULL,
- `USER_ID` int(11) NOT NULL,
- `USER_NUMBER` int(11) NOT NULL,
- `DURATION` int(11) NOT NULL,
- `ACTIVATION_DATE` datetime DEFAULT NULL,
- `ACCOUNT_ACTIVATION` tinyint(1) NOT NULL,
- `ACTIVE_USERS` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `adminuserslicense`
- --
- INSERT INTO `adminuserslicense` (`ACTIVATION_KEY`, `USER_ID`, `USER_NUMBER`, `DURATION`, `ACTIVATION_DATE`, `ACCOUNT_ACTIVATION`, `ACTIVE_USERS`) VALUES
- ('2K-OQFK72-R7QRRN-WJGQP1-TC7G1W', 1, 10, 12, '2017-02-17 19:25:05', 1, 2),
- ('77-P369PD-T3YFFF-MJBHKQ-41NQHS', 2, 50, 6, NULL, 0, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `backlog`
- --
- CREATE TABLE `backlog` (
- `BACKLOG_ID` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `backlog`
- --
- INSERT INTO `backlog` (`BACKLOG_ID`) VALUES
- (1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `chatconnection`
- --
- CREATE TABLE `chatconnection` (
- `CHANNEL` int(11) NOT NULL,
- `USER_ID` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `epic_issue`
- --
- CREATE TABLE `epic_issue` (
- `EPIC_ID` varchar(20) NOT NULL,
- `ISSUE_ID` varchar(20) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `epic_issue`
- --
- INSERT INTO `epic_issue` (`EPIC_ID`, `ISSUE_ID`) VALUES
- ('ADT-P-61967', 'ADT-P-13529');
- -- --------------------------------------------------------
- --
- -- Table structure for table `issue`
- --
- CREATE TABLE `issue` (
- `ISSUE_ID` varchar(20) NOT NULL,
- `BACKLOG_ID` int(11) NOT NULL,
- `ISSUE_TYPE` int(11) NOT NULL,
- `summary` varchar(50) NOT NULL,
- `type` varchar(20) NOT NULL,
- `status` int(11) NOT NULL,
- `priority` varchar(10) DEFAULT NULL,
- `sprint_number` decimal(6,2) DEFAULT NULL,
- `reporter` int(11) DEFAULT NULL,
- `assignee` int(11) DEFAULT NULL,
- `logHours` int(11) DEFAULT NULL,
- `description` varchar(10000) NOT NULL,
- `dateCreated` datetime NOT NULL,
- `dateUpdated` datetime NOT NULL,
- `story_points` int(11) DEFAULT NULL,
- `backlogPriority` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `issue`
- --
- INSERT INTO `issue` (`ISSUE_ID`, `BACKLOG_ID`, `ISSUE_TYPE`, `summary`, `type`, `status`, `priority`, `sprint_number`, `reporter`, `assignee`, `logHours`, `description`, `dateCreated`, `dateUpdated`, `story_points`, `backlogPriority`) VALUES
- ('ADT-P-13529', 1, 0, 'New Summary Test', 'Bug', 0, 'Major', NULL, 3, 1, NULL, '<p>New Description</p>', '2017-02-17 19:40:27', '2017-02-17 19:47:26', 10, 0),
- ('ADT-P-23141', 1, 0, 'Issue Summary', 'Improvement', 0, 'Minor', NULL, 1, NULL, NULL, 'Issue Description', '2017-02-17 19:39:34', '2017-02-17 19:39:34', 5, 1),
- ('ADT-P-61967', 1, 1, 'Epic Summary', 'Epic', 0, 'Critical', NULL, 1, NULL, NULL, 'Epic Description', '2017-02-17 19:40:00', '2017-02-17 19:40:00', 30, 2);
- --
- -- Triggers `issue`
- --
- DELIMITER $$
- CREATE TRIGGER `updateSprintBurndownDetails` AFTER UPDATE ON `issue` FOR EACH ROW BEGIN
- DECLARE storyPointCount INTEGER;
- DECLARE rowCount INTEGER;
- IF (new.status != old.status)
- THEN
- IF (new.sprint_number IS NOT NULL)
- THEN
- SET storyPointCount = (select sum(story_points) from issue where sprint_number=new.sprint_number AND BACKLOG_ID=new.BACKLOG_ID AND status=3);
- IF(storyPointCount IS NULL)
- THEN
- SET storyPointCount = 0;
- END IF;
- SET rowCount = (select count(*) from sprintBurndownDetails where SPRINT_ID=new.sprint_number AND BACKLOG_ID=new.BACKLOG_ID AND DATE(SPRINT_DATE)=CURDATE());
- IF (rowCount > 0)
- THEN
- UPDATE sprintBurndownDetails SET SPRINT_ID=new.sprint_number, BACKLOG_ID=new.BACKLOG_ID, SPRINT_DATE=NOW(), STORY_POINT=storyPointCount where SPRINT_ID=new.sprint_number AND BACKLOG_ID=new.BACKLOG_ID AND DATE(SPRINT_DATE)=CURDATE();
- ELSE
- INSERT INTO sprintBurndownDetails SET SPRINT_ID=new.sprint_number, BACKLOG_ID=new.BACKLOG_ID, SPRINT_DATE=NOW(), STORY_POINT=storyPointCount;
- END IF;
- END IF;
- END IF;
- END
- $$
- DELIMITER ;
- -- --------------------------------------------------------
- --
- -- Table structure for table `issueattachments`
- --
- CREATE TABLE `issueattachments` (
- `attachment_id` varchar(50) NOT NULL,
- `ISSUE_ID` varchar(20) NOT NULL,
- `author` int(11) NOT NULL,
- `description` varchar(200) NOT NULL,
- `dateCreated` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `issuecomments`
- --
- CREATE TABLE `issuecomments` (
- `COMMENT_ID` int(11) NOT NULL,
- `ISSUE_ID` varchar(20) NOT NULL,
- `author` int(11) NOT NULL,
- `description` varchar(3000) NOT NULL,
- `dateCreated` datetime NOT NULL,
- `dateUpdated` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `issue_type`
- --
- CREATE TABLE `issue_type` (
- `ISSUE_TYPE_ID` int(11) NOT NULL,
- `NAME` varchar(30) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `issue_type`
- --
- INSERT INTO `issue_type` (`ISSUE_TYPE_ID`, `NAME`) VALUES
- (0, 'ISSUE'),
- (1, 'EPIC');
- -- --------------------------------------------------------
- --
- -- Table structure for table `profile_number_table`
- --
- CREATE TABLE `profile_number_table` (
- `PROFILE_ID` int(11) NOT NULL,
- `NAME` varchar(30) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `profile_number_table`
- --
- INSERT INTO `profile_number_table` (`PROFILE_ID`, `NAME`) VALUES
- (0, 'Developer'),
- (1, 'Admin');
- -- --------------------------------------------------------
- --
- -- Table structure for table `project`
- --
- CREATE TABLE `project` (
- `PROJ_ID` int(11) NOT NULL,
- `USER_ID` int(11) NOT NULL,
- `BACKLOG_ID` int(11) NOT NULL,
- `name` varchar(50) NOT NULL,
- `issueName` varchar(20) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `project`
- --
- INSERT INTO `project` (`PROJ_ID`, `USER_ID`, `BACKLOG_ID`, `name`, `issueName`) VALUES
- (1, 1, 1, 'AgileDevTools', 'ADT-P');
- -- --------------------------------------------------------
- --
- -- Table structure for table `sprint`
- --
- CREATE TABLE `sprint` (
- `SPRINT_ID` decimal(6,2) DEFAULT NULL,
- `BACKLOG_ID` int(11) DEFAULT NULL,
- `startDate` datetime NOT NULL,
- `endDate` datetime NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `sprint`
- --
- INSERT INTO `sprint` (`SPRINT_ID`, `BACKLOG_ID`, `startDate`, `endDate`) VALUES
- ('1.11', 1, '2017-02-17 00:00:00', '2017-02-24 00:00:00');
- -- --------------------------------------------------------
- --
- -- Table structure for table `sprintburndowndetails`
- --
- CREATE TABLE `sprintburndowndetails` (
- `SPRINT_ID` decimal(6,2) NOT NULL,
- `BACKLOG_ID` int(11) NOT NULL,
- `SPRINT_DATE` datetime NOT NULL,
- `STORY_POINT` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `sprintburndowndetails`
- --
- INSERT INTO `sprintburndowndetails` (`SPRINT_ID`, `BACKLOG_ID`, `SPRINT_DATE`, `STORY_POINT`) VALUES
- ('1.11', 1, '2017-02-17 19:48:28', 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `sprintdemo`
- --
- CREATE TABLE `sprintdemo` (
- `SPRINT_ID` decimal(6,2) DEFAULT NULL,
- `BACKLOG_ID` int(11) DEFAULT NULL,
- `data` mediumtext
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `sprintlogworkdetails`
- --
- CREATE TABLE `sprintlogworkdetails` (
- `SPRINT_ID` decimal(6,2) NOT NULL,
- `BACKLOG_ID` int(11) NOT NULL,
- `SPRINT_DATE` datetime NOT NULL,
- `logHours` int(11) DEFAULT NULL,
- `assignee` int(11) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- --------------------------------------------------------
- --
- -- Table structure for table `status`
- --
- CREATE TABLE `status` (
- `STATUS_ID` int(11) NOT NULL,
- `NAME` varchar(30) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `status`
- --
- INSERT INTO `status` (`STATUS_ID`, `NAME`) VALUES
- (0, 'TO DO'),
- (1, 'IN PROGRESS'),
- (2, 'IN REVIEW'),
- (3, 'DONE');
- -- --------------------------------------------------------
- --
- -- Table structure for table `usersaccount`
- --
- CREATE TABLE `usersaccount` (
- `USER_ID` int(11) NOT NULL,
- `ACTIVATION_KEY` char(30) NOT NULL,
- `VERIFY_ACCOUNT` tinyint(1) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `usersaccount`
- --
- INSERT INTO `usersaccount` (`USER_ID`, `ACTIVATION_KEY`, `VERIFY_ACCOUNT`) VALUES
- (3, '2K-OQFK72-R7QRRN-WJGQP1-TC7G1W', 1),
- (4, '2K-OQFK72-R7QRRN-WJGQP1-TC7G1W', 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `usersaddress`
- --
- CREATE TABLE `usersaddress` (
- `USER_ID` int(11) NOT NULL,
- `ADDRESS1` varchar(15) NOT NULL,
- `ADDRESS2` varchar(15) NOT NULL,
- `CITY` varchar(15) NOT NULL,
- `STATE` varchar(15) NOT NULL,
- `ZIP_CODE` varchar(10) NOT NULL,
- `COUNTRY` varchar(30) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `usersaddress`
- --
- INSERT INTO `usersaddress` (`USER_ID`, `ADDRESS1`, `ADDRESS2`, `CITY`, `STATE`, `ZIP_CODE`, `COUNTRY`) VALUES
- (1, 'Address1...', 'Address2...', 'city...', 'state...', 'zip...', 'Iceland'),
- (2, 'Fohenagh', 'Caltra', 'Galway', 'Connacht', '0000', 'Ireland'),
- (3, 'Fohenagh', 'Caltra', 'Ballinasloe', 'Connacht', '0000', 'Ireland'),
- (4, 'Rathad Naomh Bh', 'Castlebay', 'Isle of Barra', 'N/A', 'HS9 5XH', 'United Kingdom');
- -- --------------------------------------------------------
- --
- -- Table structure for table `userscompany`
- --
- CREATE TABLE `userscompany` (
- `USER_ID` int(11) NOT NULL,
- `NAME` varchar(20) NOT NULL,
- `COUNTRY` varchar(30) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `userscompany`
- --
- INSERT INTO `userscompany` (`USER_ID`, `NAME`, `COUNTRY`) VALUES
- (1, 'Accenture', 'Ireland'),
- (2, 'Ericsson', 'Ireland'),
- (3, 'Ericsson', 'Ireland'),
- (4, 'Google', 'Ireland');
- -- --------------------------------------------------------
- --
- -- Table structure for table `usersprofile`
- --
- CREATE TABLE `usersprofile` (
- `USER_ID` int(11) NOT NULL,
- `FULL_NAME` varchar(20) NOT NULL,
- `DOB` date NOT NULL,
- `EMAIL` varchar(30) NOT NULL,
- `CONTACT_NUMBER` varchar(15) NOT NULL,
- `USER_NAME` varchar(20) NOT NULL,
- `PASSWORD` varchar(15) NOT NULL,
- `PROFILE_PICTURE` varchar(20) NOT NULL,
- `PROFILE_NUMBER` int(11) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `usersprofile`
- --
- INSERT INTO `usersprofile` (`USER_ID`, `FULL_NAME`, `DOB`, `EMAIL`, `CONTACT_NUMBER`, `USER_NAME`, `PASSWORD`, `PROFILE_PICTURE`, `PROFILE_NUMBER`) VALUES
- (1, 'John Doe', '1994-10-01', 'darraghmulryan@hotmail.com', '087-751-9012', 'johndoeAdmin', 'adminUser123', '58a74d9aa0e8d.jpg', 1),
- (2, 'Darragh Mulryan', '1994-10-01', 'A00210876@student.ait.ie', '087-752-9647', 'dmandarragh', 'Thankyou009', '58a74e3d1ec36.gif', 1),
- (3, 'Jessica Doe', '1991-08-02', 'jessicaDoe141@gmail.com', '087-752-9647', 'jessicaDoe', 'jessicaDoe', '58a74ee7a599d.jpg', 0),
- (4, 'Jane Doe', '1989-12-01', 'darraghmulryan@gmail.com', '087-752-9642', 'janedoeAdmin', 'janeDoe123', '58a74fa891154.jpg', 0);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `adminuserslicense`
- --
- ALTER TABLE `adminuserslicense`
- ADD PRIMARY KEY (`ACTIVATION_KEY`),
- ADD KEY `USER_ID` (`USER_ID`);
- --
- -- Indexes for table `backlog`
- --
- ALTER TABLE `backlog`
- ADD PRIMARY KEY (`BACKLOG_ID`);
- --
- -- Indexes for table `chatconnection`
- --
- ALTER TABLE `chatconnection`
- ADD PRIMARY KEY (`CHANNEL`),
- ADD KEY `USER_ID` (`USER_ID`);
- --
- -- Indexes for table `epic_issue`
- --
- ALTER TABLE `epic_issue`
- ADD KEY `EPIC_ID` (`EPIC_ID`),
- ADD KEY `ISSUE_ID` (`ISSUE_ID`);
- --
- -- Indexes for table `issue`
- --
- ALTER TABLE `issue`
- ADD PRIMARY KEY (`ISSUE_ID`),
- ADD KEY `ISSUE_TYPE` (`ISSUE_TYPE`),
- ADD KEY `BACKLOG_ID` (`BACKLOG_ID`),
- ADD KEY `assignee` (`assignee`),
- ADD KEY `reporter` (`reporter`),
- ADD KEY `status` (`status`);
- --
- -- Indexes for table `issueattachments`
- --
- ALTER TABLE `issueattachments`
- ADD PRIMARY KEY (`attachment_id`),
- ADD KEY `ISSUE_ID` (`ISSUE_ID`),
- ADD KEY `author` (`author`);
- --
- -- Indexes for table `issuecomments`
- --
- ALTER TABLE `issuecomments`
- ADD PRIMARY KEY (`COMMENT_ID`),
- ADD KEY `ISSUE_ID` (`ISSUE_ID`),
- ADD KEY `author` (`author`);
- --
- -- Indexes for table `issue_type`
- --
- ALTER TABLE `issue_type`
- ADD PRIMARY KEY (`ISSUE_TYPE_ID`);
- --
- -- Indexes for table `profile_number_table`
- --
- ALTER TABLE `profile_number_table`
- ADD PRIMARY KEY (`PROFILE_ID`);
- --
- -- Indexes for table `project`
- --
- ALTER TABLE `project`
- ADD PRIMARY KEY (`PROJ_ID`),
- ADD KEY `BACKLOG_ID` (`BACKLOG_ID`),
- ADD KEY `USER_ID` (`USER_ID`);
- --
- -- Indexes for table `sprint`
- --
- ALTER TABLE `sprint`
- ADD KEY `BACKLOG_ID` (`BACKLOG_ID`);
- --
- -- Indexes for table `sprintburndowndetails`
- --
- ALTER TABLE `sprintburndowndetails`
- ADD KEY `BACKLOG_ID` (`BACKLOG_ID`);
- --
- -- Indexes for table `sprintdemo`
- --
- ALTER TABLE `sprintdemo`
- ADD KEY `BACKLOG_ID` (`BACKLOG_ID`);
- --
- -- Indexes for table `sprintlogworkdetails`
- --
- ALTER TABLE `sprintlogworkdetails`
- ADD KEY `BACKLOG_ID` (`BACKLOG_ID`),
- ADD KEY `assignee` (`assignee`);
- --
- -- Indexes for table `status`
- --
- ALTER TABLE `status`
- ADD PRIMARY KEY (`STATUS_ID`);
- --
- -- Indexes for table `usersaccount`
- --
- ALTER TABLE `usersaccount`
- ADD KEY `USER_ID` (`USER_ID`),
- ADD KEY `ACTIVATION_KEY` (`ACTIVATION_KEY`);
- --
- -- Indexes for table `usersaddress`
- --
- ALTER TABLE `usersaddress`
- ADD KEY `USER_ID` (`USER_ID`);
- --
- -- Indexes for table `userscompany`
- --
- ALTER TABLE `userscompany`
- ADD KEY `USER_ID` (`USER_ID`);
- --
- -- Indexes for table `usersprofile`
- --
- ALTER TABLE `usersprofile`
- ADD PRIMARY KEY (`USER_ID`),
- ADD KEY `PROFILE_NUMBER` (`PROFILE_NUMBER`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `backlog`
- --
- ALTER TABLE `backlog`
- MODIFY `BACKLOG_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `issuecomments`
- --
- ALTER TABLE `issuecomments`
- MODIFY `COMMENT_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `project`
- --
- ALTER TABLE `project`
- MODIFY `PROJ_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
- --
- -- AUTO_INCREMENT for table `usersprofile`
- --
- ALTER TABLE `usersprofile`
- MODIFY `USER_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `adminuserslicense`
- --
- ALTER TABLE `adminuserslicense`
- ADD CONSTRAINT `adminuserslicense_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `chatconnection`
- --
- ALTER TABLE `chatconnection`
- ADD CONSTRAINT `chatconnection_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `epic_issue`
- --
- ALTER TABLE `epic_issue`
- ADD CONSTRAINT `epic_issue_ibfk_1` FOREIGN KEY (`EPIC_ID`) REFERENCES `issue` (`ISSUE_ID`),
- ADD CONSTRAINT `epic_issue_ibfk_2` FOREIGN KEY (`ISSUE_ID`) REFERENCES `issue` (`ISSUE_ID`);
- --
- -- Constraints for table `issue`
- --
- ALTER TABLE `issue`
- ADD CONSTRAINT `issue_ibfk_1` FOREIGN KEY (`ISSUE_TYPE`) REFERENCES `issue_type` (`ISSUE_TYPE_ID`),
- ADD CONSTRAINT `issue_ibfk_2` FOREIGN KEY (`BACKLOG_ID`) REFERENCES `backlog` (`BACKLOG_ID`),
- ADD CONSTRAINT `issue_ibfk_3` FOREIGN KEY (`assignee`) REFERENCES `usersprofile` (`USER_ID`),
- ADD CONSTRAINT `issue_ibfk_4` FOREIGN KEY (`reporter`) REFERENCES `usersprofile` (`USER_ID`),
- ADD CONSTRAINT `issue_ibfk_5` FOREIGN KEY (`status`) REFERENCES `status` (`STATUS_ID`);
- --
- -- Constraints for table `issueattachments`
- --
- ALTER TABLE `issueattachments`
- ADD CONSTRAINT `issueattachments_ibfk_1` FOREIGN KEY (`ISSUE_ID`) REFERENCES `issue` (`ISSUE_ID`),
- ADD CONSTRAINT `issueattachments_ibfk_2` FOREIGN KEY (`author`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `issuecomments`
- --
- ALTER TABLE `issuecomments`
- ADD CONSTRAINT `issuecomments_ibfk_1` FOREIGN KEY (`ISSUE_ID`) REFERENCES `issue` (`ISSUE_ID`),
- ADD CONSTRAINT `issuecomments_ibfk_2` FOREIGN KEY (`author`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `project`
- --
- ALTER TABLE `project`
- ADD CONSTRAINT `project_ibfk_1` FOREIGN KEY (`BACKLOG_ID`) REFERENCES `backlog` (`BACKLOG_ID`),
- ADD CONSTRAINT `project_ibfk_2` FOREIGN KEY (`USER_ID`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `sprint`
- --
- ALTER TABLE `sprint`
- ADD CONSTRAINT `sprint_ibfk_1` FOREIGN KEY (`BACKLOG_ID`) REFERENCES `project` (`BACKLOG_ID`);
- --
- -- Constraints for table `sprintburndowndetails`
- --
- ALTER TABLE `sprintburndowndetails`
- ADD CONSTRAINT `sprintburndowndetails_ibfk_1` FOREIGN KEY (`BACKLOG_ID`) REFERENCES `project` (`BACKLOG_ID`);
- --
- -- Constraints for table `sprintdemo`
- --
- ALTER TABLE `sprintdemo`
- ADD CONSTRAINT `sprintdemo_ibfk_1` FOREIGN KEY (`BACKLOG_ID`) REFERENCES `project` (`BACKLOG_ID`);
- --
- -- Constraints for table `sprintlogworkdetails`
- --
- ALTER TABLE `sprintlogworkdetails`
- ADD CONSTRAINT `sprintlogworkdetails_ibfk_1` FOREIGN KEY (`BACKLOG_ID`) REFERENCES `project` (`BACKLOG_ID`),
- ADD CONSTRAINT `sprintlogworkdetails_ibfk_2` FOREIGN KEY (`assignee`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `usersaccount`
- --
- ALTER TABLE `usersaccount`
- ADD CONSTRAINT `usersaccount_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `usersprofile` (`USER_ID`),
- ADD CONSTRAINT `usersaccount_ibfk_2` FOREIGN KEY (`ACTIVATION_KEY`) REFERENCES `adminuserslicense` (`ACTIVATION_KEY`);
- --
- -- Constraints for table `usersaddress`
- --
- ALTER TABLE `usersaddress`
- ADD CONSTRAINT `usersaddress_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `userscompany`
- --
- ALTER TABLE `userscompany`
- ADD CONSTRAINT `userscompany_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `usersprofile` (`USER_ID`);
- --
- -- Constraints for table `usersprofile`
- --
- ALTER TABLE `usersprofile`
- ADD CONSTRAINT `usersprofile_ibfk_1` FOREIGN KEY (`PROFILE_NUMBER`) REFERENCES `profile_number_table` (`PROFILE_ID`);
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement