Login   Register  
PHP Classes
elePHPant
Icontem

File: gpw.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Paul  >  GPW parse  >  gpw.sql  >  Download  
File: gpw.sql
Role: Auxiliary data
Content type: text/plain
Description: MySQL structure
Class: GPW parse
Import Polish stock market data into a database
Author: By
Last change:
Date: 2008-03-26 08:30
Size: 3,260 bytes
 

Contents

Class file image Download
-- 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 ;