· 8 years ago · Aug 22, 2018, 05:44 PM
1CREATE TABLE IF NOT EXISTS `sell` (
2 `itemid` varchar(100) NOT NULL,
3 `amount` varchar(100) NOT NULL,
4 `price` varchar(100) NOT NULL,
5 `sold` varchar(100) NOT NULL,
6 `username` varchar(100) NOT NULL
7 PRIMARY KEY (`index`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
9
10CREATE TABLE IF NOT EXISTS `buy` (
11 `itemid` varchar(100) NOT NULL,
12 `amount` varchar(100) NOT NULL,
13 `price` varchar(100) NOT NULL,
14 `bought` varchar(100) NOT NULL,
15 `username` varchar(100) NOT NULL
16 PRIMARY KEY (`index`)
17) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
18
19
20CREATE TABLE IF NOT EXISTS `collections` (
21 `itemid` varchar(100) NOT NULL,
22 `amount` varchar(100) NOT NULL,
23 `collected` varchar(100) NOT NULL,
24 `username` varchar(100) NOT NULL
25 PRIMARY KEY (`index`)
26) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;