· 8 years ago · May 17, 2018, 03:08 PM
1DROP TABLE IF EXISTS `buffitems`;
2CREATE TABLE `buffitems` (`ability` VARCHAR(10) NOT NULL, `name` VARCHAR(150) NOT NULL, `lowid` int(11) NOT NULL, `highid` int(11) NOT NULL, `buffed` int(11) NOT NULL, `minql` int(11) NOT NULL, `info` VARCHAR(255) NOT NULL;
3INSERT INTO buffitems (ability, name, lowid, highid, minql, info) VALUES ('Agility', 'Master G-Staff', 264202, 264203, 200, 'QL 200 Only');
4
5CREATE TABLE `buffamount` (`ability` VARCHAR(10) NOT NULL, `name` VARCHAR(150) NOT NULL, `buffed` int(11) NOT NULL;
6INSERT INTO buffamount (ability, name, buffed) VALUES ('Agility', 'Master G-Staff', 60);