KbV3SCfK

1//BudaBot/modules/SHOP_MODULE/SHOP_MODULE.php
2DB::loadSQLFile($MODULE_NAME, 'shop_module');
3
4
5//BudaBot/modules/SHOP_MODULE/shop_module.sql
6CREATE TABLE IF NOT EXISTS `sm_shops` (`ID` int(11) NOT NULL, `MAID` int(11) NOT NULL);
7CREATE TABLE IF NOT EXISTS `sm_alts` (`UID` int(11) NOT NULL, `SID` int(11) NOT NULL, `NAME` tinytext NOT NULL);
8CREATE TABLE IF NOT EXISTS `sm_items` (`ITEMREF` tinytext NOT NULL, `CATEGORY` int(11) NOT NULL);
9CREATE TABLE IF NOT EXISTS `sm_entries` (`ID` int(11) NOT NULL, `SID` int(11) NOT NULL, `CAT` int(11) NOT NULL, `ITEMREF` tinytext(11) NOT NULL, `QL` int(11) NOT NULL, `NAME` tinytext NOT NULL, `PRICE` tinytext NOT NULL);