From 7939dbfe46dd3711f53bbc8398da8092f239ccd7 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
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

