MySQL verbeteren [tips & tricks]

--
-- Tabel structuur voor tabel `users`
--


CREATE TABLE `users` (
  `id` int(7) unsigned NOT NULL auto_increment,
  `username` varchar(255) character set latin1 NOT NULL,
  `password` char(128) character set latin1 NOT NULL,
  PRIMARY KEY  (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;


-- --------------------------------------------------------


--
-- Tabel structuur voor tabel `user_weapons`
--


CREATE TABLE `user_weapons` (
  `user_id` int(7) unsigned NOT NULL,
  `weapon_id` int(7) unsigned NOT NULL,
  `amount` int(7) unsigned NOT NULL,
  PRIMARY KEY  (`user_id`,`weapon_id`),
  KEY `weapon_id` (`weapon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


-- --------------------------------------------------------


--
-- Tabel structuur voor tabel `weapons`
--


CREATE TABLE `weapons` (
  `id` int(7) unsigned NOT NULL auto_increment,
  `attack` int(7) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;


--
-- Beperkingen voor gedumpte tabellen
--


--
-- Beperkingen voor tabel `user_weapons`
--
ALTER TABLE `user_weapons`
  ADD CONSTRAINT `user_weapons_ibfk_2` FOREIGN KEY (`weapon_id`) REFERENCES `weapons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `user_weapons_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;