upgrade_svn3273.sql 555 B

123456789101112
  1. CREATE TABLE `sc_data` (
  2. `account_id` int(11) unsigned NOT NULL,
  3. `char_id` int(11) unsigned NOT NULL,
  4. `type` smallint(11) unsigned NOT NULL,
  5. `tick` int(11) NOT NULL,
  6. `val1` int(11) NOT NULL default '0',
  7. `val2` int(11) NOT NULL default '0',
  8. `val3` int(11) NOT NULL default '0',
  9. `val4` int(11) NOT NULL default '0',
  10. CONSTRAINT `scdata_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `login` (`account_id`) ON DELETE CASCADE,
  11. CONSTRAINT `scdata_ibfk_2` FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
  12. ) TYPE=InnoDB;