Skip to content

Instantly share code, notes, and snippets.

@jklein
Created April 18, 2013 12:17
Show Gist options
  • Save jklein/5412302 to your computer and use it in GitHub Desktop.
Save jklein/5412302 to your computer and use it in GitHub Desktop.
Create Table: CREATE TABLE `buda_users_public_bak` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`user_name` varchar(100) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(16) DEFAULT NULL,
`first_name` varchar(100) NOT NULL DEFAULT '',
`last_name` varchar(100) NOT NULL DEFAULT '',
`edited_date` datetime DEFAULT NULL,
`edited_by` varchar(50) DEFAULT NULL,
`modification_id` varchar(50) DEFAULT NULL,
`buda_id` int(11) DEFAULT NULL,
`goes_by` varchar(100) DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`last_view` datetime DEFAULT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `unme` (`user_name`),
UNIQUE KEY `nme` (`last_name`,`first_name`,`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment