update_logs.sql 552 B

12345678910111213
  1. #ZenyLog types (M)onsters,(T)rade,(V)ending Sell/Buy,(S)hop Sell/Buy,(N)PC Change amount,(A)dministrators
  2. #Database: log
  3. #Table: zenylog
  4. CREATE TABLE `zenylog` (
  5. `id` int(11) NOT NULL auto_increment,
  6. `time` datetime NOT NULL default '0000-00-00 00:00:00',
  7. `char_id` int(11) NOT NULL default '0',
  8. `src_id` int(11) NOT NULL default '0',
  9. `type` set('M','T','V','S','N','A') NOT NULL default 'S',
  10. `amount` int(11) NOT NULL default '0',
  11. `map` varchar(20) NOT NULL default 'prontera.gat',
  12. PRIMARY KEY (`id`)
  13. ) TYPE=MyISAM AUTO_INCREMENT=1 ;