PHP Classes

File: gpw.sql

Recommend this page to a friend!
  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: 16 years ago
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 ;