View file lets_friends/s_g_sql.sql

CREATE TABLE IF NOT EXISTS `lets_friends_chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(200) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `lets_friends_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `ptime` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `lets_friends_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(32) NOT NULL,
  `bucks` int(32) NOT NULL DEFAULT '0',
  `point` int(11) NOT NULL DEFAULT '0',
  `pol` int(1) NOT NULL DEFAULT '0',
  `time_lifting` int(11) DEFAULT NULL,
  `time_bonus` int(32) NOT NULL,
  `time_hour` int(11) NOT NULL,
  `lift_num` int(11) NOT NULL DEFAULT '5',
  `lift_num_user` int(11) NOT NULL DEFAULT '0',
  `lift_nagrada_user` int(11) NOT NULL DEFAULT '33',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;