1 files changed, 4 insertions, 2 deletions
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)
 );