From 7939dbfe46dd3711f53bbc8398da8092f239ccd7 Mon Sep 17 00:00:00 2001 From: Thibaut Horel Date: Wed, 19 Oct 2011 00:33:45 +0200 Subject: Update database schema Add fields for yahoo ticker and company name. --- database.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 8081b4f..f7d5053 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,8 @@ CREATE TABLE stock ( stockId serial PRIMARY KEY, - ticker varchar(10) + ticker varchar(10), + yahooTicker varchar (10), + name varchar(50) ); CREATE TABLE history ( @@ -14,6 +16,6 @@ CREATE TABLE history ( volume double precision DEFAULT NULL, div real DEFAULT NULL, adjDiv real DEFAULT NULL, - split real DEFAULT NULL, + split real DEFAULT NULL, PRIMARY KEY (date, stockid) ); -- cgit v1.2.3-70-g09d2