diff options
| -rw-r--r-- | database.sql | 6 |
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) ); |