[X] My Assistant

[kean023]

hello guys???/can u pls help me tables structure 4 microsoft acces????example tables???cause i want to create table for name.age,locatin,gender etc..please sir




i hv example of mysql tables

CODE

--
-- Table structure for table `ibwf_users`
--

CREATE TABLE IF NOT EXISTS `ibwf_users` (
  `id` int(100) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `pass` varchar(60) NOT NULL default '',
  `birthday` varchar(50) NOT NULL default '',
  `sex` char(1) NOT NULL default '',
  `location` varchar(100) NOT NULL default '',
  `posts` int(100) NOT NULL default '0',
  `plusses` int(100) NOT NULL default '0',
  `signature` varchar(100) NOT NULL default '',
  `avatar` varchar(100) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `site` varchar(50) NOT NULL default '',
  `browserm` varchar(50) NOT NULL default '',
  `ipadd` varchar(30) NOT NULL default '',
  `regdate` int(100) NOT NULL default '0',
  `chmsgs` int(100) NOT NULL default '0',
  `chmood` int(100) NOT NULL default '0',
  `shield` char(1) NOT NULL default '0',
  `gplus` int(100) NOT NULL default '0',
  `budmsg` varchar(100) NOT NULL default '',
  `lastpnreas` varchar(100) NOT NULL default '',
  `lastplreas` varchar(100) NOT NULL default '',
  `shouts` int(100) NOT NULL default '0',
  `pollid` int(100) NOT NULL default '0',
  `rbcid` varchar(255) NOT NULL default '',
  `hvia` char(1) NOT NULL default '1',
  `battlep` int(100) NOT NULL default '0',
  `fmsg` varchar(50) NOT NULL default '',
  `reputation` int(100) NOT NULL default '0',
  `ficon` varchar(50) NOT NULL default '',
  `ruse` int(100) NOT NULL default '0',
  `bwins` int(20) NOT NULL default '0',
  `bloss` int(20) NOT NULL default '0',
  `bcrew` varchar(50) NOT NULL default '',
  `shopssid` varchar(100) NOT NULL default '',
  `profileview` int(100) NOT NULL default '1',
  `theme` varchar(100) NOT NULL default 'style.css',
  `lastact` varchar(255) NOT NULL default '',
  `lastvst` varchar(255) NOT NULL default '',
  `perm` char(1) NOT NULL default '0',
  `subno` varchar(30) NOT NULL default '',
  `bank` int(100) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `ibwf_users`
--

i know that is only example 4 sql in php ...please i need sample tables for microsoft access thanks