Code-Bin #42

untitled Text Code
Posted by: dfdf | September 7, 2007 @ 3:51pm

Text Code

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `first_name` varchar(30) collate latin1_general_ci NOT NULL default '',
  `last_name` varchar(30) collate latin1_general_ci NOT NULL default '',
  `email` varchar(75) collate latin1_general_ci NOT NULL default '',
  `password` varchar(15) collate latin1_general_ci NOT NULL default '',
  `address1` varchar(100) collate latin1_general_ci NOT NULL default '',
  `address2` varchar(100) collate latin1_general_ci NOT NULL default '',
  `city` varchar(30) collate latin1_general_ci NOT NULL default '',
  `state` varchar(30) collate latin1_general_ci NOT NULL default '',
  `country` varchar(50) collate latin1_general_ci NOT NULL default '',
  `postal_code` varchar(10) collate latin1_general_ci NOT NULL default '',
  `type` int(1) NOT NULL default '0',
  `date_joined` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `status` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

Syntax Highlighting

[Open in new window]

Author Comments

none

Rating

4.54 / 8
480 Votes