9
3

raw_commands.sql 921 B

1234567891011121314
  1. CREATE TABLE `raw_commands` (
  2. `id` int(10) unsigned NOT NULL auto_increment,
  3. `type` tinyint(3) unsigned default '1',
  4. `command` varchar(64) collate latin1_general_ci NOT NULL,
  5. `subcommand` varchar(64) collate latin1_general_ci NOT NULL,
  6. `handler` int(10) unsigned NOT NULL default '0',
  7. `required_status` smallint(5) NOT NULL default '0',
  8. `data_version` smallint(5) unsigned NOT NULL default '0',
  9. `log_file` varchar(250) collate latin1_general_ci NOT NULL default '',
  10. PRIMARY KEY (`id`),
  11. UNIQUE KEY `CommandIDX` (`command`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  13. ALTER TABLE `parser_stats` ADD COLUMN `total_commands` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `new_recipes_list`, ADD COLUMN `unique_commands` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `total_commands`, ADD COLUMN `new_commands` SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AFTER `unique_commands`;