PHP Source code |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
CREATE TABLE IF NOT EXISTS `store_categories` (
`id` int(11) NOT NULL auto_increment,
`display_name` varchar(32) NOT NULL,
`description` varchar(128) default NULL,
`require_plugin` varchar(32) default NULL,
`web_description` text default NULL,
`web_color` varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;# MySQL lieferte ein leeres Resultat zurück (d.h. null Datensätze).
CREATE TABLE IF NOT EXISTS `store_items` (
`id` int(11)NOT NULL auto_increment,
`name` varchar(32) NOT NULL,
`display_name` varchar(32) NOT NULL,
`description` varchar(128) default NULL,
`web_description` text,
`type` varchar(32) NOT NULL,
`loadout_slot` varchar(32) default NULL,
`price` int(11) NOT NULL,
`category_id` int(11) NOT NULL,
`attrs` text default NULL,
`is_buyable` tinyint(1) NOT NULL DEFAULT '1',
`is_tradeable` tinyint(1) NOT NULL DEFAULT '1',
`is_refundable` tinyint(1) NOT NULL DEF[...]
|
This post has been edited 1 times, last edit by "LeXx" (Sep 28th 2013, 11:22pm)
This post has been edited 1 times, last edit by "LeXx" (Sep 29th 2013, 12:20am)
This post has been edited 2 times, last edit by "LeXx" (Sep 29th 2013, 2:54am)