TJnXvbPV

1SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
2
3--
4-- DB: `openpayz`
5--
6
7-- --------------------------------------------------------
8
9--
10--  virtual customers abstraction layer
11--
12
13CREATE TABLE IF NOT EXISTS `op_customers` (
14  `id` int(11) NOT NULL auto_increment,
15  `realid` varchar(255) NOT NULL,
16  `virtualid` varchar(255) NOT NULL,
17  PRIMARY KEY  (`id`),
18  UNIQUE KEY `realid` (`realid`,`virtualid`)
19) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
20
21-- --------------------------------------------------------
22
23--
24-- log transactions table
25--
26
27CREATE TABLE IF NOT EXISTS `op_transactions` (
28  `id` int(11) NOT NULL auto_increment,
29  `date` datetime NOT NULL,
30  `summ` int(11) NOT NULL,
31  `customerid` varchar(255) NOT NULL,
32  `paysys` varchar(255) NOT NULL,
33  `processed` tinyint(1) NOT NULL,
34  `note` text NOT NULL,
35  PRIMARY KEY  (`id`)
36) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;