diff options
| author | Thibaut Horel <thibaut.horel@gmail.com> | 2011-10-19 00:33:45 +0200 |
|---|---|---|
| committer | Thibaut Horel <thibaut.horel@gmail.com> | 2011-10-19 00:33:45 +0200 |
| commit | 7939dbfe46dd3711f53bbc8398da8092f239ccd7 (patch) | |
| tree | f00669a3b07e8f7345d39942f177655e7b44c8e9 /database.sql | |
| parent | 83b41368bbc072bead2b6311c7a019b40164bba4 (diff) | |
| download | bandit-7939dbfe46dd3711f53bbc8398da8092f239ccd7.tar.gz | |
Update database schema
Add fields for yahoo ticker and company name.
Diffstat (limited to 'database.sql')
| -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) ); |