-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-13
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 16. Januar 2018 um 12:37
-- Server Version: 5.0.32
-- PHP-Version: 5.2.0-8+etch16
--
-- Datenbank: `usr_web0_2`
--

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

--
-- Tabellenstruktur für Tabelle `_stocks`
--

CREATE TABLE `_stocks` (
  `id` int(10) NOT NULL auto_increment,
  `status` int(2) NOT NULL default '1',
  `name` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  `currentPrice` float NOT NULL,
  `currentPriceSum` float NOT NULL,
  `purchasePrice` float NOT NULL,
  `purchasePriceSum` float NOT NULL,
  `sellPrice` float NOT NULL,
  `sellPriceSum` float NOT NULL,
  `quantity` float NOT NULL,
  `purchaseDate` datetime NOT NULL,
  `sellDate` datetime NOT NULL,
  `fees` float NOT NULL,
  `profit` float NOT NULL,
  `annualReturn` float NOT NULL,
  `days` int(6) NOT NULL,
  `lastRequest` datetime NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `_stocks_fees`
--

CREATE TABLE `_stocks_fees` (
  `id` int(11) NOT NULL auto_increment,
  `stock_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `uniqueFees` float NOT NULL,
  `FeesPerShares` float NOT NULL,
  `date` datetime NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `files`
--

CREATE TABLE `files` (
  `id` int(8) NOT NULL auto_increment,
  `filename` varchar(128) NOT NULL,
  `filesize` varchar(128) NOT NULL,
  `web_path` varchar(256) NOT NULL,
  `system_path` varchar(256) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `users_files`
--

CREATE TABLE `users_files` (
  `id` int(8) NOT NULL auto_increment,
  `user_id` varchar(128) NOT NULL,
  `file_id` varchar(128) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;