· 10 years ago · Sep 13, 2016, 07:36 AM
1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Sep 13, 2016 at 09:31 AM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `team_status`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `input`
21--
22
23CREATE TABLE IF NOT EXISTS `input` (
24 `input_id` int(11) NOT NULL,
25 `input_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
26 `fk_member_id` int(11) NOT NULL,
27 `fk_status_id` int(11) NOT NULL
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30-- --------------------------------------------------------
31
32--
33-- Table structure for table `members`
34--
35
36CREATE TABLE IF NOT EXISTS `members` (
37 `member_id` int(50) NOT NULL,
38 `member_name` varchar(50) NOT NULL,
39 `member_phone` int(8) NOT NULL,
40 `member_email` varchar(55) NOT NULL,
41 `member_password` varchar(65) NOT NULL,
42 `member_img` varchar(50) DEFAULT NULL
43) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
44
45--
46-- Dumping data for table `members`
47--
48
49INSERT INTO `members` (`member_id`, `member_name`, `member_phone`, `member_email`, `member_password`, `member_img`) VALUES
50(1, 'Samuel', 0, 'spbweiss@gmail.com', '1234', 'placeholder.jpg');
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `status`
56--
57
58CREATE TABLE IF NOT EXISTS `status` (
59 `status_id` int(50) NOT NULL,
60 `status_state` varchar(50) DEFAULT NULL
61) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
62
63--
64-- Dumping data for table `status`
65--
66
67INSERT INTO `status` (`status_id`, `status_state`) VALUES
68(1, 'custom'),
69(2, 'sick'),
70(3, 'delayed'),
71(4, 'prevented');
72
73--
74-- Indexes for dumped tables
75--
76
77--
78-- Indexes for table `input`
79--
80ALTER TABLE `input`
81 ADD PRIMARY KEY (`input_id`), ADD KEY `fk_member_id` (`fk_member_id`), ADD KEY `fk_status_id` (`fk_status_id`);
82
83--
84-- Indexes for table `members`
85--
86ALTER TABLE `members`
87 ADD PRIMARY KEY (`member_id`);
88
89--
90-- Indexes for table `status`
91--
92ALTER TABLE `status`
93 ADD PRIMARY KEY (`status_id`);
94
95--
96-- AUTO_INCREMENT for dumped tables
97--
98
99--
100-- AUTO_INCREMENT for table `input`
101--
102ALTER TABLE `input`
103 MODIFY `input_id` int(11) NOT NULL AUTO_INCREMENT;
104--
105-- AUTO_INCREMENT for table `members`
106--
107ALTER TABLE `members`
108 MODIFY `member_id` int(50) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
109--
110-- AUTO_INCREMENT for table `status`
111--
112ALTER TABLE `status`
113 MODIFY `status_id` int(50) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
114--
115-- Constraints for dumped tables
116--
117
118--
119-- Constraints for table `input`
120--
121ALTER TABLE `input`
122ADD CONSTRAINT `input_ibfk_1` FOREIGN KEY (`fk_member_id`) REFERENCES `members` (`member_id`),
123ADD CONSTRAINT `input_ibfk_2` FOREIGN KEY (`fk_status_id`) REFERENCES `status` (`status_id`);