 --
 CREATE DATABASE IF NOT EXISTS `strategy_game` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
 USE `strategy_game`;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `army_purchase_log`
+--
+
+CREATE TABLE IF NOT EXISTS `army_purchase_log` (
+  `army_purchase_log` int(11) NOT NULL,
+  `user_id` int(11) NOT NULL,
+  `move_number` int(11) NOT NULL,
+  `army_wanted` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attack_log`

CREATE TABLE IF NOT EXISTS `trade_log` (
  `trade_log_id` int(11) NOT NULL,
  `move_number` int(5) NOT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `army_offered` int(5) NOT NULL,
