Jump to content

Need Help, Big Time. PHP


skippa

Recommended Posts

Whats wrong with this?

 

CREATE TABLE `poker` (

  `id` int(11) NOT NULL auto_increment,

  `player1` varchar(40) NOT NULL default '',

  `player2` varchar(40) default NULL,

  `player3` varchar(40) default NULL,

  `player4` varchar(40) default NULL,

  `cards1` varchar(250) default NULL,

  `cards2` varchar(250) default NULL,

  `cards3` varchar(250) default NULL,

  `cards4` varchar(250) default NULL,

  `money1` int(11) default '0',

  `money2` int(11) default '0',

  `money3` int(11) default '0',

  `money4` int(11) default '0',

  `status` varchar(250) NOT NULL default '',

  `ante` int(16) NOT NULL default '0',

  `pot` int(16) NOT NULL default '0',

  `stage` int(1) default '0',

  `swapstart` int(1) NOT NULL default '0',

  `currentraise` int(1) NOT NULL default '0',

  `allin` binary(1) NOT NULL default '0',

  `lastmove` int(11) default NULL,',

  `created` int(11) NOT NULL default '0',

  `p1` varchar(100) NOT NULL default '',

  `p2` varchar(100) NOT NULL default '',

  `p3` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',

  `p4` varchar(100) character set latin1 collate latin1_spanish_ci NOT NULL default '',

  `entry` varchar(100) NOT NULL default '',

  PRIMARY KEY  (`id`),

  UNIQUE KEY `player1` (`player1`,`player2`,`player3`,`player4`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Link to comment
https://forums.phpfreaks.com/topic/156545-need-help-big-time-php/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.