Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `users_data` (
- `id` int(11) unsigned NOT NULL auto_increment,
- `index_id` int(11) unsigned default NULL,
- `username` varchar(64) character set latin1 NOT NULL,
- `email` varchar(192) collate utf8_unicode_ci NOT NULL,
- `password` char(32) character set ascii NOT NULL,
- `salt` int(10) NOT NULL,
- `canLogin` enum('Y','N') character set ascii collate ascii_bin NOT NULL,
- `memberStatus` int(11) unsigned NOT NULL,
- `familyHead` int(11) unsigned NOT NULL,
- `address` int(11) unsigned default NULL,
- `address2` int(11) unsigned default NULL,
- `firstname` varchar(50) collate utf8_unicode_ci NOT NULL,
- `indep_prefix` varchar(15) collate utf8_unicode_ci NOT NULL COMMENT 'Tussenvoegsels',
- `lastname` varchar(50) collate utf8_unicode_ci NOT NULL,
- `christianName` varchar(127) collate utf8_unicode_ci NOT NULL,
- `initials` varchar(10) collate utf8_unicode_ci NOT NULL,
- `gender` enum('M','F') character set ascii collate ascii_bin NOT NULL,
- `phone` varchar(20) character set latin1 collate latin1_bin default NULL,
- `phoneWork` varchar(20) character set latin1 collate latin1_bin NOT NULL,
- `fax` varchar(20) character set ascii collate ascii_bin NOT NULL,
- `SSN` varchar(40) character set ascii collate ascii_bin NOT NULL,
- `birthday` date NOT NULL,
- `baptisedAsAdult` enum('Y','N','Unknown') collate utf8_unicode_ci NOT NULL default 'Unknown',
- `dateBaptism` date NOT NULL,
- `dateDeceased` date NOT NULL,
- `bankAcct` varchar(20) character set ascii collate ascii_bin NOT NULL,
- `bank` int(11) unsigned default NULL,
- `date_last_passwordchange` timestamp NOT NULL default '0000-00-00 00:00:00',
- `date_updated` timestamp NOT NULL default CURRENT_TIMESTAMP,
- `updated_by` int(11) unsigned default NULL,
- `deleted` tinyint(1) NOT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `username` (`username`),
- KEY `address` (`address`),
- KEY `uid_updated_by` (`updated_by`),
- KEY `index_id` (`index_id`),
- KEY `deleted` (`deleted`),
- KEY `address2` (`address2`),
- KEY `memberStatus` (`memberStatus`),
- KEY `bank` (`bank`),
- KEY `familyHead` (`familyHead`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;
- --
- -- Dumping data for table `users_data`
- --
- INSERT INTO `users_data` (`id`, `index_id`, `username`, `email`, `password`, `salt`, `canLogin`, `memberStatus`, `familyHead`, `address`, `address2`, `firstname`, `indep_prefix`, `lastname`, `christianName`, `initials`, `gender`, `phone`, `phoneWork`, `fax`, `SSN`, `birthday`, `baptisedAsAdult`, `dateBaptism`, `dateDeceased`, `bankAcct`, `bank`, `date_last_passwordchange`, `date_updated`, `updated_by`, `deleted`) VALUES
- (0, 0, '__GAST', '', 'GuestDontLogin', 5175117, 'Y', 1, 0, NULL, NULL, '', '', '', '', '', 'M', NULL, '', '', '', '0000-00-00', 'Y', '0000-00-00', '0000-00-00', '', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0);
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `users_data`
- --
- ALTER TABLE `users_data`
- ADD CONSTRAINT `users_data_ibfk_13` FOREIGN KEY (`memberStatus`) REFERENCES `membership_statuses` (`id`),
- ADD CONSTRAINT `users_data_ibfk_10` FOREIGN KEY (`address`) REFERENCES `users_addresses_data` (`id`),
- ADD CONSTRAINT `users_data_ibfk_11` FOREIGN KEY (`bank`) REFERENCES `banks` (`id`),
- ADD CONSTRAINT `users_data_ibfk_12` FOREIGN KEY (`familyHead`) REFERENCES `users_index` (`id`),
- ADD CONSTRAINT `users_data_ibfk_6` FOREIGN KEY (`address`) REFERENCES `users_addresses_index` (`id`),
- ADD CONSTRAINT `users_data_ibfk_7` FOREIGN KEY (`index_id`) REFERENCES `users_index` (`id`),
- ADD CONSTRAINT `users_data_ibfk_8` FOREIGN KEY (`updated_by`) REFERENCES `users_index` (`id`),
- ADD CONSTRAINT `users_data_ibfk_9` FOREIGN KEY (`address2`) REFERENCES `users_addresses_data` (`id`);
- mysql> mysql> describe prefs_memberadministration_cols;
- +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
- | Field | Type | Null | Key | Default | Extra |
- +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
- | id | int(11) unsigned | NO | PRI | NULL | |
- | uid | int(11) unsigned | NO | MUL | NULL | |
- | colName | enum('username','email','password','salt','canLogin','memberStatus','familyHead','address','address2','firstname','lastname','christianName','initials','gender','phone','phoneWork','fax','SSN','birthday','baptisedAsAdult','dateBaptism','dateDeceased','bankAcct','bank','date_last_passwordchange') | NO | | NULL | |
- | order | smallint(6) | NO | | NULL | |
- +---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
- 4 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment