80O / PlusEMU

39 stars 26 forks source link

Move users settings from users table to user_settings table. #74

Open 80O opened 2 years ago

Diddyy commented 1 year ago

Current user table structure is

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(125) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
  `auth_ticket` varchar(60) NOT NULL,
  `rank` int(1) unsigned DEFAULT '1',
  `rank_vip` int(1) DEFAULT '1',
  `credits` int(11) DEFAULT '50000',
  `vip_points` int(11) DEFAULT '0',
  `activity_points` int(11) DEFAULT '5000',
  `look` char(255) DEFAULT NULL,
  `gender` enum('M','F') DEFAULT 'M',
  `motto` char(50) DEFAULT NULL,
  `account_created` char(12) DEFAULT '0',
  `last_online` int(11) DEFAULT '0',
  `online` enum('0','1') DEFAULT '0',
  `ip_last` varchar(45) DEFAULT '',
  `ip_reg` varchar(45) DEFAULT NULL,
  `home_room` int(10) DEFAULT '0',
  `is_muted` enum('0','1') DEFAULT '0',
  `block_newfriends` enum('0','1') DEFAULT '0',
  `hide_online` enum('0','1') DEFAULT '0',
  `hide_inroom` enum('0','1') DEFAULT '0',
  `vip` enum('0','1') DEFAULT '1',
  `volume` varchar(15) DEFAULT '100,100,100',
  `last_change` int(20) DEFAULT '0',
  `machine_id` varchar(125) DEFAULT '',
  `focus_preference` enum('0','1') DEFAULT '0',
  `chat_preference` enum('0','1') DEFAULT '0',
  `pets_muted` enum('0','1') DEFAULT '0',
  `bots_muted` enum('0','1') DEFAULT '0',
  `advertising_report_blocked` enum('0','1') DEFAULT '0',
  `gotw_points` int(11) DEFAULT '0',
  `ignore_invites` enum('0','1') DEFAULT '0',
  `time_muted` double DEFAULT '0',
  `allow_gifts` enum('0','1') DEFAULT '1',
  `trading_locked` double DEFAULT '0',
  `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
  `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
  `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',

Should these be moved to users_settings?

  `home_room` int(10) DEFAULT '0',
  `is_muted` enum('0','1') DEFAULT '0',
  `block_newfriends` enum('0','1') DEFAULT '0',
  `hide_online` enum('0','1') DEFAULT '0',
  `hide_inroom` enum('0','1') DEFAULT '0',
  `volume` varchar(15) DEFAULT '100,100,100',
  `focus_preference` enum('0','1') DEFAULT '0',
  `chat_preference` enum('0','1') DEFAULT '0',
  `pets_muted` enum('0','1') DEFAULT '0',
  `bots_muted` enum('0','1') DEFAULT '0',
  `advertising_report_blocked` enum('0','1') DEFAULT '0',
  `ignore_invites` enum('0','1') DEFAULT '0',
  `allow_gifts` enum('0','1') DEFAULT '1',
  `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
  `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
  `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',