#summary iShudan.sql contents
#labels Phase-Implementation,code

= Introduction =

What follows is a verbatim dump of the contents of the file iShudan.sql


= Details =
{{{
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 24, 2007 at 10:41 PM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
--
-- Database: 'iShudan'
--

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

--
-- Table structure for table 'chat'
--

CREATE TABLE chat (
  c_id int(11) NOT NULL auto_increment,
  c_game_id int(11) NOT NULL,
  c_player_id int(11) NOT NULL,
  c_message text collate latin1_general_ci NOT NULL,
  c_postdate datetime NOT NULL,
  c_private enum('Yes','No') collate latin1_general_ci NOT NULL default 'No',
  PRIMARY KEY  (c_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table 'game'
--

CREATE TABLE game (
  g_id int(11) NOT NULL auto_increment,
  g_black_player_id int(11) NOT NULL,
  g_white_player_id int(11) NOT NULL,
  g_handicap tinyint(1) NOT NULL,
  g_board_size tinyint(2) NOT NULL,
  g_moves text collate latin1_general_ci NOT NULL,
  g_num_moves int(11) NOT NULL,
  g_status enum('Black','White','Game Over','Black Resigned','White Resigned') c
ollate latin1_general_ci NOT NULL default 'Black',
  g_last_move datetime default NULL,
  g_private_chat_box int(11) NOT NULL default '0',
  g_create_date datetime NOT NULL,
  PRIMARY KEY  (g_id),
  KEY g_black_player_id (g_black_player_id,g_white_player_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table 'player'
--

CREATE TABLE player (
  p_id int(11) NOT NULL auto_increment,
  p_username varchar(50) collate latin1_general_ci NOT NULL,
  p_password char(32) collate latin1_general_ci NOT NULL,
  p_email varchar(100) collate latin1_general_ci default NULL,
  p_last_login datetime default NULL,
  p_create_date datetime NOT NULL,
  p_ident char(32) collate latin1_general_ci default NULL,
  p_token char(32) collate latin1_general_ci default NULL,
  PRIMARY KEY  (p_id),
  UNIQUE KEY p_name (p_username)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

}}}