#
# Структура таблицы `invest_ask`
#

CREATE TABLE invest_ask (
  id int(11) NOT NULL auto_increment,
  data datetime NOT NULL default '0000-00-00 00:00:00',
  user_id int(11) NOT NULL default '0',
  summ decimal(10,2) NOT NULL default '0.00',
  status int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;


#
# Структура таблицы `invest_invest`
#

CREATE TABLE invest_invest (
  id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  data datetime NOT NULL default '0000-00-00 00:00:00',
  summ decimal(10,2) NOT NULL default '0.00',
  reinvest int(11) NOT NULL default '0',
  time_ int(11) NOT NULL default '0',
  status int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;


#
# Структура таблицы `invest_invoice`
#

CREATE TABLE invest_invoice (
  id int(11) NOT NULL auto_increment,
  data datetime NOT NULL default '0000-00-00 00:00:00',
  user_id int(11) NOT NULL default '0',
  sum decimal(10,2) default '0.00',
  result char(1) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Счета на оплату';


#
# Структура таблицы `invest_news`
#

CREATE TABLE invest_news (
  id int(11) NOT NULL auto_increment,
  data datetime NOT NULL default '0000-00-00 00:00:00',
  text text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;


#
# Структура таблицы `invest_percents`
#

CREATE TABLE invest_percents (
  id int(11) NOT NULL auto_increment,
  min_s decimal(10,2) NOT NULL default '0.00',
  max_s decimal(10,2) NOT NULL default '0.00',
  min_period int(11) NOT NULL default '0',
  max_period int(11) NOT NULL default '0',
  per_month decimal(10,2) NOT NULL default '0.00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Дамп данных таблицы `invest_percents`
#

INSERT INTO invest_percents VALUES (1, '1.00', '50.00', 30, 90, '8.10');
INSERT INTO invest_percents VALUES (2, '51.00', '100.00', 30, 90, '9.00');
INSERT INTO invest_percents VALUES (3, '101.00', '500.00', 30, 90, '10.00');
INSERT INTO invest_percents VALUES (4, '501.00', '1000.00', 30, 90, '11.00');
INSERT INTO invest_percents VALUES (5, '1001.00', '9999.00', 30, 90, '12.00');
INSERT INTO invest_percents VALUES (6, '1.00', '50.00', 90, 180, '10.00');
INSERT INTO invest_percents VALUES (7, '51.00', '100.00', 90, 180, '11.00');
INSERT INTO invest_percents VALUES (8, '101.00', '500.00', 90, 180, '12.00');
INSERT INTO invest_percents VALUES (9, '501.00', '1000.00', 90, 180, '13.00');
INSERT INTO invest_percents VALUES (10, '1001.00', '9999.00', 90, 180, '14.00');
INSERT INTO invest_percents VALUES (11, '1.00', '50.00', 180, 99999, '12.00');
INSERT INTO invest_percents VALUES (12, '51.00', '100.00', 180, 99999, '13.00');
INSERT INTO invest_percents VALUES (13, '101.00', '500.00', 180, 99999, '14.00');
INSERT INTO invest_percents VALUES (14, '501.00', '1000.00', 180, 99999, '15.00');
INSERT INTO invest_percents VALUES (15, '1001.00', '9999.00', 180, 99999, '16.00');
# --------------------------------------------------------

#
# Структура таблицы `invest_users`
#

CREATE TABLE invest_users (
  id int(11) NOT NULL auto_increment,
  data datetime NOT NULL default '0000-00-00 00:00:00',
  login text NOT NULL,
  pass text NOT NULL,
  wmid text NOT NULL,
  purse text NOT NULL,
  email text NOT NULL,
  balance decimal(10,2) NOT NULL default '0.00',
  ref_id int(11) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM COMMENT='Список пользователей.';


