9
3

RawDialogs.sql 1.2 KB

1234567891011121314151617181920212223242526272829
  1. drop table if exists raw_dialogs;
  2. CREATE TABLE `raw_dialogs` (
  3. `id` int(10) unsigned NOT NULL auto_increment,
  4. `spawn_id` int(10) unsigned NOT NULL default '0',
  5. `conversation_id` int(10) unsigned NOT NULL default '0',
  6. `npc_text` text NOT NULL,
  7. `voice_file` varchar(255) NOT NULL,
  8. `key1` int(10) unsigned NOT NULL default '0',
  9. `key2` int(10) unsigned NOT NULL default '0',
  10. `unknown` smallint(5) unsigned NOT NULL default '0',
  11. `unknown2` tinyint(3) unsigned NOT NULL default '0',
  12. `unknown3` tinyint(3) unsigned NOT NULL default '0',
  13. `sequence` smallint(5) unsigned NOT NULL default '0',
  14. `index` smallint(5) NOT NULL default '0',
  15. `language_type` tinyint(3) unsigned NOT NULL default '0',
  16. PRIMARY KEY (`id`),
  17. UNIQUE KEY `NewIndex` (`conversation_id`,`spawn_id`,`sequence`,`index`)
  18. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
  19. drop table if exists raw_dialog_choices;
  20. CREATE TABLE `raw_dialog_choices` (
  21. `id` int(10) unsigned NOT NULL auto_increment,
  22. `dialog_conversation_id` int(10) unsigned NOT NULL default '0',
  23. `index` smallint(3) unsigned NOT NULL default '0',
  24. `choice` text NOT NULL,
  25. PRIMARY KEY (`id`)
  26. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;