bdvFsCYC

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u3
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Aug 08, 2018 at 06:25 PM
7-- Server version: 5.5.60-0+deb8u1
8-- PHP Version: 7.0.27-0+deb9u1~bpo8+1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `pichrono`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `participant`
27--
28
29CREATE TABLE IF NOT EXISTS `participant` (
30`ID_PARTICIPANT` int(100) NOT NULL,
31  `NAME_PARTICIPANT` varchar(150) NOT NULL,
32  `AGE_PARTICIPANT` int(100) NOT NULL,
33  `CITY_PARTICIPANT` varchar(100) NOT NULL,
34  `NATIONALITY_PARTICIPANT` varchar(100) NOT NULL,
35  `TEAM_PARTICIPANT` varchar(200) NOT NULL
36) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
37
38--
39-- Dumping data for table `participant`
40--
41
42INSERT INTO `participant` (`ID_PARTICIPANT`, `NAME_PARTICIPANT`, `AGE_PARTICIPANT`, `CITY_PARTICIPANT`, `NATIONALITY_PARTICIPANT`, `TEAM_PARTICIPANT`) VALUES
43(1, 'asd', 123, 'asd', 'asd', 'asd'),
44(2, 'dsad', 23, 'asddsads', 'asdad', 'asdsdasdads');
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `race`
50--
51
52CREATE TABLE IF NOT EXISTS `race` (
53`ID_RACE` int(100) NOT NULL,
54  `ID_PARTICIPANT` int(100) NOT NULL,
55  `START_TIME_RACE` datetime NOT NULL,
56  `END_TIME_RACE` datetime NOT NULL,
57  `FINAL_TIME_RACE` varchar(255) NOT NULL,
58  `CC_RACE` int(50) NOT NULL,
59  `TYPE_RACE` int(50) NOT NULL
60) ENGINE=InnoDB DEFAULT CHARSET=utf8;
61
62-- --------------------------------------------------------
63
64--
65-- Table structure for table `user`
66--
67
68CREATE TABLE IF NOT EXISTS `user` (
69`id` int(100) NOT NULL,
70  `username` varchar(100) DEFAULT NULL,
71  `password` varchar(100) DEFAULT NULL
72) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
73
74--
75-- Dumping data for table `user`
76--
77
78INSERT INTO `user` (`id`, `username`, `password`) VALUES
79(1, 'Jorge', '123');
80
81--
82-- Indexes for dumped tables
83--
84
85--
86-- Indexes for table `participant`
87--
88ALTER TABLE `participant`
89 ADD PRIMARY KEY (`ID_PARTICIPANT`);
90
91--
92-- Indexes for table `race`
93--
94ALTER TABLE `race`
95 ADD PRIMARY KEY (`ID_RACE`), ADD KEY `race_ibfk_1` (`ID_PARTICIPANT`);
96
97--
98-- Indexes for table `user`
99--
100ALTER TABLE `user`
101 ADD PRIMARY KEY (`id`);
102
103--
104-- AUTO_INCREMENT for dumped tables
105--
106
107--
108-- AUTO_INCREMENT for table `participant`
109--
110ALTER TABLE `participant`
111MODIFY `ID_PARTICIPANT` int(100) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
112--
113-- AUTO_INCREMENT for table `race`
114--
115ALTER TABLE `race`
116MODIFY `ID_RACE` int(100) NOT NULL AUTO_INCREMENT;
117--
118-- AUTO_INCREMENT for table `user`
119--
120ALTER TABLE `user`
121MODIFY `id` int(100) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
122--
123-- Constraints for dumped tables
124--
125
126--
127-- Constraints for table `race`
128--
129ALTER TABLE `race`
130ADD CONSTRAINT `race_ibfk_1` FOREIGN KEY (`ID_PARTICIPANT`) REFERENCES `participant` (`ID_PARTICIPANT`) ON DELETE CASCADE ON UPDATE CASCADE;
131
132/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
133/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
134/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;