Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.4.10
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost:3306
- -- Generation Time: Mar 29, 2017 at 03:16 PM
- -- Server version: 5.5.42
- -- PHP Version: 5.6.10
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `eaa`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `eaa_bieding`
- --
- CREATE TABLE `eaa_bieding` (
- `bid_id` int(255) NOT NULL,
- `product_id` int(255) NOT NULL,
- `price` decimal(65,0) NOT NULL,
- `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Dumping data for table `eaa_bieding`
- --
- INSERT INTO `eaa_bieding` (`bid_id`, `product_id`, `price`, `username`) VALUES
- (1, 1, '250', 'PROSIEB'),
- (2, 1, '293030', 'jens'),
- (3, 2, '2637', 'jean'),
- (4, 3, '289383', 'hallo'),
- (5, 4, '10', 'janee'),
- (8, 1, '2039', 'siebert'),
- (9, 1, '2039', 'siebert'),
- (10, 1, '20', 'l,mzdmkd'),
- (11, 1, '99999', 'jensbert'),
- (12, 1, '99999', 'jensbert'),
- (13, 1, '0', 'jens'),
- (14, 1, '0', 'jens'),
- (15, 1, '0', 'jens'),
- (16, 1, '0', 'jens'),
- (17, 1, '0', 'jens'),
- (18, 1, '20', 'oens'),
- (19, 1, '0', 'jean'),
- (20, 1, '20292093092393', 'jensaezazea'),
- (21, 1, '20292093092393', 'jensaezazea'),
- (22, 2, '2099', 'jens'),
- (23, 2, '20933', 'jari'),
- (24, 2, '20933', 'jari'),
- (25, 2, '20933', 'jari'),
- (26, 3, '203', 'jaja'),
- (27, 4, '200', 'janice'),
- (28, 4, '2', 'joens'),
- (29, 4, '20', 'mathijs'),
- (30, 4, '2', 'jensss'),
- (31, 3, '2', 'zddqz'),
- (32, 2, '20', 'jens'),
- (33, 2, '277', 'jens'),
- (34, 1, '20909290', 'jahallo'),
- (35, 1, '2908', 'jsajsisa'),
- (36, 1, '2908', 'jsajsisa'),
- (37, 1, '822839280982332820', 'jjizjddizoq'),
- (38, 1, '822839280982332820', 'jjizjddizoq'),
- (39, 4, '2390803', 'zdkqjdzq'),
- (40, 3, '20339302', 'jens'),
- (41, 5, '20', 'jens'),
- (42, 5, '20', 'jens'),
- (43, 2, '209398303', 'jarie '),
- (44, 2, '82908307837', 'jens'),
- (45, 5, '2389738739', 'siebart'),
- (46, 5, '2389738739', 'siebart'),
- (47, 3, '200092803832', ' '),
- (48, 3, '28938230238232', ' '),
- (49, 3, '28938230238232', ' '),
- (50, 3, '28938230238232', ' ');
- -- --------------------------------------------------------
- --
- -- Table structure for table `eaa_product`
- --
- CREATE TABLE `eaa_product` (
- `product_id` int(255) NOT NULL,
- `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
- --
- -- Dumping data for table `eaa_product`
- --
- INSERT INTO `eaa_product` (`product_id`, `name`) VALUES
- (1, 'SABOTAGE KIT'),
- (2, 'TRUST ISSUES KIT'),
- (3, 'BURGLAR KIT'),
- (4, 'SPY ON YOUR NEIGHBORS KIT'),
- (5, 'INVISIBLE TO THE WORLD KIT');
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `eaa_bieding`
- --
- ALTER TABLE `eaa_bieding`
- ADD PRIMARY KEY (`bid_id`),
- ADD KEY `product_id` (`product_id`);
- --
- -- Indexes for table `eaa_product`
- --
- ALTER TABLE `eaa_product`
- ADD PRIMARY KEY (`product_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `eaa_bieding`
- --
- ALTER TABLE `eaa_bieding`
- MODIFY `bid_id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=51;
- --
- -- AUTO_INCREMENT for table `eaa_product`
- --
- ALTER TABLE `eaa_product`
- MODIFY `product_id` int(255) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `eaa_bieding`
- --
- ALTER TABLE `eaa_bieding`
- ADD CONSTRAINT `eaa_bieding_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `eaa_product` (`product_id`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement