-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Generated: 26 Mar 2008, 17:28
-- Server: 5.0.45
-- PHP: 5.2.5
--
-- MySQL structure for GPW parse class
--
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Baza danych: `gpw`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `actual`
--
DROP TABLE IF EXISTS `actual`;
CREATE TABLE IF NOT EXISTS `actual` (
`id` int(255) NOT NULL,
`0` varchar(255) NOT NULL,
`1` varchar(255) NOT NULL,
`2` varchar(255) NOT NULL,
`3` varchar(255) NOT NULL,
`4` varchar(255) NOT NULL,
`5` varchar(255) NOT NULL,
`6` varchar(255) NOT NULL,
`7` varchar(255) NOT NULL,
`8` varchar(255) NOT NULL,
`9` varchar(255) NOT NULL,
`10` varchar(255) NOT NULL,
`11` varchar(255) NOT NULL,
`12` varchar(255) NOT NULL,
`13` varchar(255) NOT NULL,
`14` varchar(255) NOT NULL,
`15` varchar(255) NOT NULL,
`16` varchar(255) NOT NULL,
`17` varchar(255) NOT NULL,
`18` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Aktualne dane z GPW';
-- --------------------------------------------------------
--
-- Struktura tabeli dla `actual_date`
--
DROP TABLE IF EXISTS `actual_date`;
CREATE TABLE IF NOT EXISTS `actual_date` (
`year` varchar(255) NOT NULL,
`month` varchar(255) NOT NULL,
`day` varchar(255) NOT NULL,
`server_year` varchar(255) NOT NULL,
`server_month` varchar(255) NOT NULL,
`server_day` varchar(255) NOT NULL,
`server_hour` varchar(255) NOT NULL,
`highest_hour` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Data aktualnych danych z GPW';
-- --------------------------------------------------------
--
-- Struktura tabeli dla `history`
--
DROP TABLE IF EXISTS `history`;
CREATE TABLE IF NOT EXISTS `history` (
`id` int(255) NOT NULL,
`0` int(255) NOT NULL,
`1` varchar(255) NOT NULL,
`2` varchar(255) NOT NULL,
`3` varchar(255) NOT NULL,
`4` varchar(255) NOT NULL,
`5` varchar(255) NOT NULL,
`6` varchar(255) NOT NULL,
`7` varchar(255) NOT NULL,
`8` varchar(255) NOT NULL,
`9` varchar(255) NOT NULL,
`10` varchar(255) NOT NULL,
`11` varchar(255) NOT NULL,
`12` varchar(255) NOT NULL,
`13` varchar(255) NOT NULL,
`14` varchar(255) NOT NULL,
`15` varchar(255) NOT NULL,
`16` varchar(255) NOT NULL,
`17` varchar(255) NOT NULL,
`18` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Historyczne dane z GPW';
-- --------------------------------------------------------
--
-- Struktura tabeli dla `history_date`
--
DROP TABLE IF EXISTS `history_date`;
CREATE TABLE IF NOT EXISTS `history_date` (
`id` int(255) NOT NULL auto_increment,
`year` varchar(255) NOT NULL,
`month` varchar(255) NOT NULL,
`day` varchar(255) NOT NULL,
`server_year` varchar(255) NOT NULL,
`server_month` varchar(255) NOT NULL,
`server_day` varchar(255) NOT NULL,
`server_hour` varchar(255) NOT NULL,
`highest_hour` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Data historycznych danych z GPW' AUTO_INCREMENT=1 ;
|