kK7xD9gA

1
2--
3-- Tabellenstruktur für Tabelle `pp_orders`
4--
5
6CREATE TABLE IF NOT EXISTS `pp_orders` (
7  `order_id` int(11) NOT NULL AUTO_INCREMENT,
8  `member_id` mediumint(8) NOT NULL,
9  `purchased` datetime NOT NULL,
10  `paid` datetime DEFAULT NULL,
11  PRIMARY KEY (`order_id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ;
13
14-- --------------------------------------------------------
15
16--
17-- Tabellenstruktur für Tabelle `pp_orders_perks`
18--
19
20CREATE TABLE IF NOT EXISTS `pp_orders_perks` (
21  `order_perk_id` int(11) NOT NULL AUTO_INCREMENT,
22  `order_id` int(11) NOT NULL,
23  `perk_id` int(11) NOT NULL,
24  `perk_name` varchar(128) NOT NULL,
25  `perk_desc` text NOT NULL,
26  `perk_price` int(11) NOT NULL,
27  `perk_expiry_length` int(11) NOT NULL,
28  `perk_require_online` tinyint(1) NOT NULL,
29  `activated` tinyint(1) NOT NULL DEFAULT '0',
30  `expired` tinyint(1) NOT NULL DEFAULT '0',
31  `expire_date` datetime DEFAULT NULL,
32  `has_options` tinyint(1) NOT NULL DEFAULT '0',
33  PRIMARY KEY (`order_perk_id`)
34) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;
35
36-- --------------------------------------------------------
37
38--
39-- Tabellenstruktur für Tabelle `pp_orders_perks_commands`
40--
41
42CREATE TABLE IF NOT EXISTS `pp_orders_perks_commands` (
43  `orders_perks_commands_id` int(11) NOT NULL AUTO_INCREMENT,
44  `orders_perks_id` int(11) NOT NULL,
45  `command` varchar(128) NOT NULL,
46  PRIMARY KEY (`orders_perks_commands_id`)
47) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=172 ;
48
49-- --------------------------------------------------------
50
51--
52-- Tabellenstruktur für Tabelle `pp_orders_perks_expiry_commands`
53--
54
55CREATE TABLE IF NOT EXISTS `pp_orders_perks_expiry_commands` (
56  `orders_perks_expiry_commands_id` int(11) NOT NULL AUTO_INCREMENT,
57  `orders_perks_id` int(11) NOT NULL,
58  `expiry_command` varchar(128) NOT NULL,
59  PRIMARY KEY (`orders_perks_expiry_commands_id`)
60) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=142 ;