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