Skip to content

Instantly share code, notes, and snippets.

@rileyrg
Created June 9, 2017 18:49
Show Gist options
  • Save rileyrg/89c00fd9ee13035f8d407c15d77915db to your computer and use it in GitHub Desktop.
Save rileyrg/89c00fd9ee13035f8d407c15d77915db to your computer and use it in GitHub Desktop.
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nickname` varchar(50) DEFAULT NULL,
`first_name` varchar(255) DEFAULT NULL,
`last_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`sha1_password` varchar(40) DEFAULT NULL,
`salt` varchar(32) DEFAULT NULL,
`activation_code` varchar(64) DEFAULT NULL,
`activated` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`login_hash` varchar(64) DEFAULT NULL,
`current_login` datetime DEFAULT NULL,
`last_login` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`full_member` int(11) DEFAULT NULL,
`canceled` tinyint(1) DEFAULT NULL,
`adress_data_id` int(11) DEFAULT NULL,
`finished_first_login` int(11) DEFAULT NULL,
`contact` int(11) DEFAULT NULL,
`contact_mail` int(11) DEFAULT NULL,
`contact_mobile` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`agency_approved` int(11) DEFAULT NULL,
`bank_name` varchar(255) DEFAULT NULL,
`bank_account` varchar(255) DEFAULT NULL,
`bank_account_holder` varchar(255) DEFAULT NULL,
`bank_code` varchar(255) DEFAULT NULL,
`full_member_since` datetime DEFAULT NULL,
`paid` datetime DEFAULT NULL,
`may_do_casting` int(11) DEFAULT NULL,
`may_see_all_videos` tinyint(1) DEFAULT NULL,
`no_bill` tinyint(1) DEFAULT NULL,
`cancel_casting_message` mediumtext,
`ibac` varchar(45) DEFAULT NULL,
`bic` varchar(45) DEFAULT NULL,
`mandate_ref` varchar(45) DEFAULT NULL,
`creditor_id` varchar(45) DEFAULT NULL,
`may_see_all_pictures` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_nickname_index` (`nickname`),
KEY `user_FI_1` (`person_id`),
KEY `user_FI_2` (`adress_data_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7235 DEFAULT CHARSET=utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment