mods_wedding.sql 432 B

1234567891011
  1. CREATE TABLE IF NOT EXISTS `mods_wedding` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `player1Id` int(11) NOT NULL DEFAULT '0',
  4. `player2Id` int(11) NOT NULL DEFAULT '0',
  5. `married` varchar(5) DEFAULT NULL,
  6. `affianceDate` decimal(20,0) DEFAULT '0',
  7. `weddingDate` decimal(20,0) DEFAULT '0',
  8. PRIMARY KEY (`id`),
  9. KEY `player1Id` (`player1Id`),
  10. KEY `player2Id` (`player2Id`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;