Skip to content

Instantly share code, notes, and snippets.

View cammygames's full-sized avatar

Cameron Chilton cammygames

View GitHub Profile

Keybase proof

I hereby claim:

  • I am cammygames on github.
  • I am maurice_moss (https://keybase.io/maurice_moss) on keybase.
  • I have a public key whose fingerprint is 018A 4610 F32B C38C 73CD 650A F26C 417A ED75 B809

To claim this, I am signing this object:

ALTER TABLE `users` ADD `user_profile` TEXT NOT NULL ;
UPDATE `users` SET `user_profile`='assets/img/ui-dave.jpg'
@cammygames
cammygames / Life Control SQL
Last active August 29, 2015 14:17
Life Control SQL
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL COMMENT 'auto incrementing user_id of each user, unique index',
`user_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s name, unique',
`user_password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s password in salted and hashed format',
`user_email` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s email, unique',
`playerid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`user_level` enum('1','2','3') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
`user_profile` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user data';