Paste Code
Paste Blends
Paste Images
--
-- Table structure for table `tbl_users`
--

CREATE TABLE IF NOT EXISTS `tbl_users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(25) COLLATE latin1_general_ci NOT NULL,
`user_email` varchar(60) COLLATE latin1_general_ci NOT NULL,
`user_password` varchar(255) COLLATE latin1_general_ci NOT NULL,
`joining_date` datetime NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_name` (`user_name`),
UNIQUE KEY `user_email` (`user_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
  1. --
  2. -- Table structure for table `tbl_users`
  3. --
  4.  
  5. CREATE TABLE IF NOT EXISTS `tbl_users` (
  6.   `user_id` int(11) NOT NULL AUTO_INCREMENT,
  7.   `user_name` varchar(25) COLLATE latin1_general_ci NOT NULL,
  8.   `user_email` varchar(60) COLLATE latin1_general_ci NOT NULL,
  9.   `user_password` varchar(255) COLLATE latin1_general_ci NOT NULL,
  10.   `joining_date` datetime NOT NULL,
  11.   PRIMARY KEY (`user_id`),
  12.   UNIQUE KEY `user_name` (`user_name`),
  13.   UNIQUE KEY `user_email` (`user_email`)
  14. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=13 ;
  15.  
go to heaven