<commit_before>-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 31, 2016 at 03:58 PM
-- Server version: 5.5.45-cll-lve
-- PHP Version: 5.4.31

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 utf8 */;

--
-- Database: `iauction`
--

-- --------------------------------------------------------

--
-- Table structure for table `auctionitem`
--

CREATE TABLE IF NOT EXISTS `auctionitem` (
  `auctionid` bigint(20) NOT NULL,
  `itemid` bigint(20) NOT NULL,
  `currbid` decimal(10,0) NOT NULL,
  KEY `auctionid` (`auctionid`),
  KEY `itemid` (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `auctionitembid`
--

CREATE TABLE IF NOT EXISTS `auctionitembid` (
  `auctionid` bigint(20) NOT NULL,
  `itemid` bigint(20) NOT NULL,
  `biduser` varchar(255) DEFAULT NULL,
  `bidamount` decimal(10,0) DEFAULT NULL,
  `biddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auctionitembid`
--

-- --------------------------------------------------------

--
-- Table structure for table `auctions`
--

CREATE TABLE IF NOT EXISTS `auctions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) DEFAULT NULL,
  `startdate` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

--
-- Table structure for table `item`
--

CREATE TABLE IF NOT EXISTS `item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `startbid` decimal(10,0) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` char(128) NOT NULL,
  `salt` char(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `users`
-- Default user: administrator password: <PASSWORD>

INSERT INTO `users` (`id`, `username`, `email`, `password`, `salt`) VALUES
(1, 'administrator', '<EMAIL>', '<PASSWORD>', '<PASSWORD>134c9ff7e605e90006cdb9379a3fc4dd17810d0e53f');

/*!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 */;<commit_msg>add drop tables sql<commit_after>-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 31, 2016 at 03:58 PM
-- Server version: 5.5.45-cll-lve
-- PHP Version: 5.4.31

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 utf8 */;

--
-- Database: `iauction`
--

-- --------------------------------------------------------

--
-- Table structure for table `auctionitem`
--
DROP TABLE `auctionitem`;

CREATE TABLE IF NOT EXISTS `auctionitem` (
  `auctionid` bigint(20) NOT NULL,
  `itemid` bigint(20) NOT NULL,
  `currbid` decimal(10,0) NOT NULL,
  KEY `auctionid` (`auctionid`),
  KEY `itemid` (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `auctionitembid`
--
DROP TABLE `auctionitembid`;

CREATE TABLE IF NOT EXISTS `auctionitembid` (
  `auctionid` bigint(20) NOT NULL,
  `itemid` bigint(20) NOT NULL,
  `biduser` varchar(255) DEFAULT NULL,
  `bidamount` decimal(10,0) DEFAULT NULL,
  `biddate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auctionitembid`
--

-- --------------------------------------------------------

--
-- Table structure for table `auctions`
--
DROP TABLE `auctions`;

CREATE TABLE IF NOT EXISTS `auctions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) DEFAULT NULL,
  `startdate` datetime DEFAULT NULL,
  `enddate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

--
-- Table structure for table `item`
--
DROP TABLE `item`;

CREATE TABLE IF NOT EXISTS `item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(225) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL,
  `startbid` decimal(10,0) DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--
DROP TABLE `users`;

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` char(128) NOT NULL,
  `salt` char(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `users`
-- Default user: administrator password: <PASSWORD>

INSERT INTO `users` (`id`, `username`, `email`, `password`, `salt`) VALUES
(1, 'administrator', '<EMAIL>', '<PASSWORD>36c8e53395ab608bade22a1bbec056cc128e85a069141e15912cf5c623d7c4953303d10a6', '<KEY>');

/*!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 */;
{'fraction_non_alphanumeric': 0.19263408010862185, 'fraction_numerical': 0.054480651731160894, 'mean_word_length': 3.3814126394052044, 'pattern_counts': {'":': 0, '<': 11, '<?xml version=': 0, '>': 11, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 2, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5483169', 'n_tokens_mistral': 2351, 'n_tokens_neox': 2094, 'n_words': 540}