Location: PHPKode > projects > Matterdaddy Market > market/sql.txt
CREATE TABLE `md_categories` (
  `cat_id` int(10) unsigned NOT NULL auto_increment,
  `cat_name` varchar(64) collate latin1_german2_ci NOT NULL default '',
  `cat_order` int(2) unsigned NOT NULL default '0',
  `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=4 ;

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

-- 
-- Table structure for table `md_postings`
-- 

CREATE TABLE `md_postings` (
  `postId` int(10) unsigned NOT NULL auto_increment,
  `isAvailable` int(1) NOT NULL default '1',
  `isConfirmed` int(1) NOT NULL default '0',
  `category` varchar(30) collate latin1_german2_ci NOT NULL default 'general',
  `title` varchar(128) collate latin1_german2_ci NOT NULL default '',
  `description` longtext collate latin1_german2_ci NOT NULL,
  `email` varchar(128) collate latin1_german2_ci NOT NULL default '',
  `city` varchar(32) collate latin1_german2_ci default NULL,
  `zip` int(11) NOT NULL,
  `name` varchar(30) collate latin1_german2_ci default NULL,
  `price` int(10) NOT NULL default '0',
  `ip` varchar(18) collate latin1_german2_ci NOT NULL default '',
  `timeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `confirmPassword` varchar(7) collate latin1_german2_ci NOT NULL default '',
  `imgURL` varchar(128) collate latin1_german2_ci default '(none)',
  `imgURLThumb` varchar(128) collate latin1_german2_ci default '(none)',
  PRIMARY KEY  (`postId`),
  KEY `city` (`city`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=9 ;
Return current item: Matterdaddy Market