Beste:
Hartelijk dank voor uw goed hulp en tijd en uitleg
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `u_configuration`
-- ----------------------------
DROP TABLE IF EXISTS `u_configuration`;
CREATE TABLE `u_configuration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`config_key` varchar(100) NOT NULL,
`config_label` varchar(255) NOT NULL,
`config_value` varchar(255) DEFAULT NULL,
`config_type` varchar(20) NOT NULL,
`default_type_values` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of u_configuration
-- ----------------------------
INSERT INTO u_configuration VALUES ('1', 'logout_redirect_url', 'Logout Redirect Url (leave this blank to return to the login page. If set, include the
http://)', '', 'input', null);
INSERT INTO u_configuration VALUES ('2', 'send_email_from', 'System Email Address (all emails are sent from this email)', 'donotreply@user_management.com', 'input', null);
INSERT INTO u_configuration VALUES ('3', 'default_theme', 'Default Theme', 'black_rose', 'select', '{\"apple_pie\":\"Apple Pie\",\"black_rose\":\"Black Rose\",\"blueberry\":\"Blueberry\",\"gray_lightness\":\"Gray Lightness\",\"gray_standard\":\"Gray Standard\"}');
INSERT INTO u_configuration VALUES ('4', 'authentication_type', 'Authentication Type', 'file', 'select', '{\"file\":\"Simple File Based\", \"integrated\":\"Advanced PHP Integrated\"}');
-- ----------------------------
-- Table structure for `u_file_permission`
-- ----------------------------
DROP TABLE IF EXISTS `u_file_permission`;
CREATE TABLE `u_file_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file_path` varchar(255) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `file_path` (`file_path`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of u_file_permission
-- ----------------------------
INSERT INTO u_file_permission VALUES ('11', 'demo_admin_only_image.png', '1');
INSERT INTO u_file_permission VALUES ('10', 'demo_admin_only.php', '1');
INSERT INTO u_file_permission VALUES ('12', 'demo_logged_in_only.pdf', '9');
INSERT INTO u_file_permission VALUES ('13', 'demo_logged_in_only.php', '9');
-- ----------------------------
-- Table structure for `u_permission`
-- ----------------------------
DROP TABLE IF EXISTS `u_permission`;
CREATE TABLE `u_permission` (
`id` int(11) NOT NULL,
`label` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of u_permission
-- ----------------------------
INSERT INTO u_permission VALUES ('1', 'admin');
INSERT INTO u_permission VALUES ('9', 'standard user');
-- ----------------------------
-- Table structure for `u_user`
-- ----------------------------
DROP TABLE IF EXISTS `u_user`;
CREATE TABLE `u_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(32) NOT NULL,
`forename` varchar(100) DEFAULT NULL,
`surname` varchar(100) DEFAULT NULL,
`email_address` varchar(255) DEFAULT NULL,
`permission_level` int(11) NOT NULL,
`status` int(1) NOT NULL,
`active_date` datetime DEFAULT NULL,
`expiry_date` datetime DEFAULT NULL,
`last_login_date` datetime DEFAULT NULL,
`last_login_ip` varchar(39) DEFAULT NULL,
`notes` text,
`password_reset_hash` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of u_user
-- ----------------------------
INSERT INTO u_user VALUES ('1', 'admin_user', '5f4dcc3b5aa765d61d8327deb882cf99', 'Admin', 'User', 'admin_user@domain.com', '1', '1', '2011-08-05 14:34:33', '0000-00-00 00:00:00', '2011-08-18 17:00:32', '', 'Sample admin user account.', null);
INSERT INTO u_user VALUES ('11', 'standard_user', '5f4dcc3b5aa765d61d8327deb882cf99', 'Standard', 'User', 'standard_user@domain.com', '9', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2011-08-18 16:55:25', '', 'Sample standard user account.', '');
-- ----------------------------
-- Table structure for `u_user_status`
-- ----------------------------
DROP TABLE IF EXISTS `u_user_status`;
CREATE TABLE `u_user_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`label` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of u_user_status
-- ----------------------------
INSERT INTO u_user_status VALUES ('1', 'active');
INSERT INTO u_user_status VALUES ('2', 'pending');
INSERT INTO u_user_status VALUES ('3', 'expired');
INSERT INTO u_user_status VALUES ('4', 'suspended');
Dit is wat ik nu heb in mijn user database
dus ik dus ik moet 2 tabellen maken in deze database en dan communiceert het ??
