gistfile1.txt

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