advanced code snippet search

Posted By

robksawyer on 02/06/09


Tagged


Versions (?)

users_table

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. CREATE TABLE `users` (
  2.   `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.   `username` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  4.   `password` VARCHAR(60) COLLATE utf8_bin NOT NULL DEFAULT '',
  5.   `firstname` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  6.   `lastname` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  7.   `email` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  8.   `bio` TEXT COLLATE utf8_bin NOT NULL,
  9.   `location` VARCHAR(250) COLLATE utf8_bin NOT NULL,
  10.   `cookie` VARCHAR(200) COLLATE utf8_bin NOT NULL,
  11.   `admin` TINYINT(1) NOT NULL,
  12.   `created` DATETIME NOT NULL,
  13.   `modified` DATETIME NOT NULL,
  14.   PRIMARY KEY  (`id`),
  15.   UNIQUE KEY `username` (`username`)
  16. )

Report this snippet  

You need to login to post a comment.