text: -- phpMyAdmin SQL Dump
  
  SET FOREIGN_KEY_CHECKS=0;
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE IF NOT EXISTS `users` (
    `id` int(10) unsigned NOT NULL,
    `profile_id` varchar(50) NOT NULL,
    `profile_identifier` varchar(255) NOT NULL,
    `uname` varchar(255) NOT NULL,
    `pword` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_cache_settings`
  --
  
  CREATE TABLE IF NOT EXISTS `user_cache_settings` (
    `user_id` varchar(255) NOT NULL,
    `data` mediumblob NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_native_preferences`
  --
  
  CREATE TABLE IF NOT EXISTS `user_native_preferences` (
    `user_id` varchar(255) NOT NULL,
    `data` mediumblob NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_preferences`
  --
  
  CREATE TABLE IF NOT EXISTS `user_preferences` (
    `fk_id_users` int(10) unsigned NOT NULL,
    `data` mediumblob
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user_settings`
  --
  
  CREATE TABLE IF NOT EXISTS `user_settings` (
    `fk_id_users` int(10) unsigned NOT NULL,
    `data` mediumblob NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD KEY `profile_id` (`profile_id`);
  
  --
  -- Indexes for table `user_cache_settings`
  --
  ALTER TABLE `user_cache_settings`
    ADD PRIMARY KEY (`user_id`);
  
  --
  -- Indexes for table `user_native_preferences`
  --
  ALTER TABLE `user_native_preferences`
    ADD PRIMARY KEY (`user_id`);
  
  --
  -- Indexes for table `user_preferences`
  --
  ALTER TABLE `user_preferences`
    ADD PRIMARY KEY (`fk_id_users`);
  
  --
  -- Indexes for table `user_settings`
  --
  ALTER TABLE `user_settings`
    ADD KEY `fk_id_users` (`fk_id_users`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `user_preferences`
  --
  ALTER TABLE `user_preferences`
    ADD CONSTRAINT `user_preferences_ibfk_1` FOREIGN KEY (`fk_id_users`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `user_settings`
  --
  ALTER TABLE `user_settings`
    ADD CONSTRAINT `user_settings_ibfk_1` FOREIGN KEY (`fk_id_users`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
  SET FOREIGN_KEY_CHECKS=1;
  