1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
/**
* $Id: myportfolio.sql,v 1.5 2003/03/26 08:26:28 courou Exp $
*
* Author : courou@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;
|
