#!/usr/bin/env python
# -*- coding: utf-8 -*-

# CREATE TABLE fund_total (
#     id INT NOT NULL AUTO_INCREMENT,
#     fund_id VARCHAR(16) NULL,
#     fund_name VARCHAR(32) NULL,
#     net_asset_value FLOAT NULL,
#     up_down FLOAT NULL,
#     growth_rate FLOAT NULL,
#     acc_net_value FLOAT NULL,
#     fund_date DATE NULL,
#     apply VARCHAR(8) NULL,
#     redeem VARCHAR(8) NULL,
#     manager VARCHAR(16) NULL,
#     PRIMARY KEY( id )
# ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


# CREATE TABLE fund_portfolio (
#     id INT NOT NULL AUTO_INCREMENT,
#     fund_id VARCHAR(16) NULL,
#     fund_name VARCHAR(32) NULL,
#     fund_type VARCHAR(8) NULL,
#     date DATE NULL,
#     stock_rank INT NULL,
#     stock_id VARCHAR(16) NULL,
#     stock_name VARCHAR(16) NULL,
#     stock_value FLOAT NULL,
#     stock_num INT NULL,
#     stock_rate FLOAT NULL,
#     stock_url VARCHAR(16) NULL,
#     PRIMARY KEY( id )
# ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
