/**
 * $Id: myportfolio.sql,v 1.5 2003/03/26 08:26:28 courou Exp $
 *
 * Author     : courou&#64;users.sourceforge.net
 * Website    : http://allreponse.ath.cx
 *
 * Support    : http://sourceforge.net/projects/myphpmoney/
 * CVS        : http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/myphpmoney/
 */

/*---------------------------------------------------------------------*/
/* Table : MPM_portfolio                                               */
/*---------------------------------------------------------------------*/
CREATE TABLE IF NOT EXISTS MPM_portfolio 
(
  QUOTENAME 			CHAR(10) 			 	NOT NULL default '',
  USERID 			BIGINT(20)		 	 	NOT NULL default '0'
)type = MyISAM;

/*---------------------------------------------------------------------*/
/* Table : MPM_quotes                                                  */
/*---------------------------------------------------------------------*/
CREATE TABLE IF NOT EXISTS MPM_quotes 
(
  QUOTENAME 			VARCHAR(10) 			 	NOT NULL default '',
  TIME 				BIGINT(10)			 	NOT NULL default '0',
  CACHE 			TEXT 				 	NOT NULL
)type = MyISAM;
