Просмотр архива Рабочий скрипт LazyPay

CREATE TABLE IF NOT EXISTS `ci_sessions` (
  `session_id` varchar(40) NOT
NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
 
`user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) unsigned NOT
NULL DEFAULT '0',
  `user_data` text NOT NULL,
  PRIMARY KEY
(`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `config_data` (
  `key`
varchar(255) NOT NULL,
  `value` varchar(4096) NOT NULL,
  PRIMARY KEY
(`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `config_data`
(`key`, `value`) VALUES
('metadescr', 'Онлайн магазин
продажи аккаунтов'),
('sitedescription', 'Добро
пожаловать на тестовую страницу
скрипта!'),
('site_name', 'Online-acc'),
('wmid', ''),
('wmk_file',
'\n'),
('WMR', ''),
('WMZ', ''),
('wm_key_date', ''),
('wm_pass',
'');

CREATE TABLE IF NOT EXISTS `goods` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `rank` int(11) NOT NULL,
  `name` varchar(256) NOT NULL,

 `descr` text NOT NULL,
  `iconurl` varchar(255) NOT NULL,
  `price_rub`
varchar(256) NOT NULL,
  `price_dlr` varchar(256) NOT NULL,
  `min_order`
int(10) NOT NULL,
  `sell_method` tinyint(1) NOT NULL,
  `goods` text NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=13 ;

CREATE TABLE IF NOT EXISTS `login_attempts` (
 
`ip_address` varchar(255) NOT NULL,
  `attempts` int(1) NOT NULL,
 
`lastLogin` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `bill` varchar(255) NOT NULL,
  `name` varchar(255)
NOT NULL,
  `email` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,

 `item_id` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `price`
varchar(11) NOT NULL,
  `session_key` varchar(255) NOT NULL,
  `ip_address`
varchar(255) NOT NULL,
  `fund` varchar(255) NOT NULL,
  `paid` tinyint(1)
NOT NULL,
  `redeemed` int(12) NOT NULL,
  `goods` text NOT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=80
;

CREATE TABLE IF NOT EXISTS `pages` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET cp1251 NOT NULL,
 
`slug` varchar(100) CHARACTER SET cp1251 NOT NULL,
  `order` int(11) NOT
NULL,
  `body` text CHARACTER SET cp1251 NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

CREATE TABLE IF NOT
EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `email`
varchar(100) NOT NULL,
  `password` varchar(128) NOT NULL,
  `name`
varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT
CHARSET=utf8 AUTO_INCREMENT=5 ;