DROP TABLE IF EXISTS c_config;
CREATE TABLE c_config (
 ID tinyint(1) NOT NULL default '0',
 MSG_DEL smallint(5) UNSIGNED NOT NULL default '96',
 USR_DEL tinyint(1) NOT NULL default '10',
 REG_DEL tinyint(1) NOT NULL default '0',
 LANGUAGE varchar(40) NOT NULL default 'english',
 MULTI_LANG enum('0','1') NOT NULL default '1',
 REQUIRE_REGISTER enum('0','1') NOT NULL default '0',
 REQUIRE_NAMES enum('0','1') NOT NULL default '0',
 EMAIL_PASWD enum('0','1') NOT NULL default '0',
 PASS_LENGTH tinyint(1) NOT NULL default '6',
 ADMIN_NOTIFY enum('0','1') NOT NULL default '1',
 ADMIN_NAME varchar(35) NOT NULL default 'Your name/chat name here',
 ADMIN_EMAIL varchar(35) NOT NULL default 'Your email address here',
 CHAT_URL varchar(100) NOT NULL default 'Your server/chat URL here',
 SHOW_ADMIN enum('0','1') NOT NULL default '1',
 SHOW_DEL_PROF enum('0','1') NOT NULL default '1',
 VERSION enum('0','1','2') NOT NULL default '2',
 BANISH tinyint(1) NOT NULL default '1',
 NO_SWEAR enum('0','1') NOT NULL default '0',
 SWEAR_EXPR varchar(5) NOT NULL default '@#$*!',
 SAVE varchar(5) NOT NULL default '*',
 USE_SMILIES enum('0','1') NOT NULL default '1',
 HTML_TAGS_KEEP enum('none','simple') NOT NULL default 'simple',
 HTML_TAGS_SHOW enum('0','1') NOT NULL default '0',
 TMZ_OFFSET tinyint(1) NOT NULL default '0',
 MSG_ORDER enum('0','1') NOT NULL default '1',
 MSG_NB tinyint(1) NOT NULL default '10',
 MSG_REFRESH tinyint(1) NOT NULL default '20',
 SHOW_TIMESTAMP enum('0','1') NOT NULL default '1',
 NOTIFY enum('0','1') NOT NULL default '1',
 WELCOME enum('0','1') NOT NULL default '1',
 SMILEY_COLS tinyint(1) NOT NULL default '10',
 SMILEY_COLS_POP tinyint(1) NOT NULL default '5',
 ALLOW_ENTRANCE_SOUND enum('0','1','2','3') NOT NULL default '1',
 ENTRANCE_SOUND varchar(255) NOT NULL default 'sounds/chimeup.wav',
 ALLOW_BUZZ_SOUND enum('0','1') NOT NULL default '1',
 BUZZ_SOUND varchar(255) NOT NULL default 'sounds/chimedwn.wav',
 TOPIC_DIFF enum('0','1') NOT NULL default '1',
 SHOW_TUT enum('0','1') NOT NULL default '1',
 SHOW_INFO enum('0','1') NOT NULL default '0',
 SET_CMDS enum('0','1') NOT NULL default '1',
 CMDS varchar(255) NOT NULL default '/away /buzz /demote /dice /dice2 /dice3 /high /img /math /mr<br />/room /size /sort /topic /utube /video /wisp',
 SET_MODS enum('0','1') NOT NULL default '1',
 MODS varchar(255) NOT NULL default 'Advanced Admin, (GR)Avatars, Smilies Popup, Color Drop Box, Private Popup,<br />Quick Menu, Logs Archive, Lurking, Color names, WorldTime, UTF-8, Birthdays, MathJax, TV/Radio, Emoji',
 SET_BOT enum('0','1') NOT NULL default '1',
 ROOM_SAYS varchar(255) NOT NULL default 'Attention Room:',
 DEMOTE_MOD enum('0','1') NOT NULL default '0',
 PRIV_POPUP enum('0','1') NOT NULL default '1',
 SHOW_ETIQ_IN_HELP enum('0','1') NOT NULL default '1',
 SHOW_LOGO enum('0','1') NOT NULL default '1',
 LOGO_IMG varchar(255) NOT NULL default 'images/icon.gif',
 LOGO_OPEN varchar(255) NOT NULL default './',
 LOGO_ALT varchar(255) NOT NULL default 'My Chat based on phpMyChat-Plus',
 SHOW_OWNER enum('0','1') NOT NULL default '1',
 SHOW_PRIV enum('0','1') NOT NULL default '1',
 SHOW_PRIV_MOD enum('0','1') NOT NULL default '1',
 SHOW_PRIV_USR enum('0','1') NOT NULL default '1',
 SHOW_COUNTER enum('0','1') NOT NULL default '1',
 INSTALL_DATE date NOT NULL default (DATE(CURRENT_TIMESTAMP)),
 USE_SKIN enum('0','1') NOT NULL default '1',
 ROOM1 varchar(25) NOT NULL default 'Public Room 1',
 ROOM2 varchar(25) NOT NULL default 'Public Room 2',
 ROOM3 varchar(25) NOT NULL default 'Public Room 3',
 ROOM4 varchar(25) NOT NULL default 'Public Room 4',
 ROOM5 varchar(25) NOT NULL default 'Public Room 5',
 ROOM6 varchar(25) NOT NULL default 'Private Room 1',
 ROOM7 varchar(25) NOT NULL default 'Private Room 2',
 ROOM8 varchar(25) NOT NULL default 'Staff Only',
 ROOM9 varchar(25) NOT NULL default 'Support Room',
 SWEAR1 varchar(25) NOT NULL default 'Public Room 5',
 SWEAR2 varchar(25) NOT NULL default 'Staff Only',
 SWEAR3 varchar(25) NOT NULL default 'Support Room',
 SWEAR4 varchar(25) NOT NULL default '',
 COLOR_FILTERS enum('0','1') NOT NULL default '1',
 COLOR_ALLOW_GUESTS enum('0','1') NOT NULL default '1',
 ROOM_SKIN1 tinyint(1) NOT NULL default '1',
 ROOM_SKIN2 tinyint(1) NOT NULL default '2',
 ROOM_SKIN3 tinyint(1) NOT NULL default '3',
 ROOM_SKIN4 tinyint(1) NOT NULL default '4',
 ROOM_SKIN5 tinyint(1) NOT NULL default '5',
 ROOM_SKIN6 tinyint(1) NOT NULL default '6',
 ROOM_SKIN7 tinyint(1) NOT NULL default '7',
 ROOM_SKIN8 tinyint(1) NOT NULL default '8',
 ROOM_SKIN9 tinyint(1) NOT NULL default '9',
 COLOR_CA varchar(25) NOT NULL default 'red',
 COLOR_CA1 varchar(25) NOT NULL default 'crimson',
 COLOR_CA2 varchar(25) NOT NULL default 'orangered',
 COLOR_CM varchar(25) NOT NULL default 'blue',
 COLOR_CM1 varchar(25) NOT NULL default 'mediumblue',
 COLOR_CM2 varchar(25) NOT NULL default 'royalblue',
 QUICKA longtext NOT NULL,
 QUICKM longtext NOT NULL,
 QUICKU longtext NOT NULL,
 COLOR_NAMES enum('0','1') NOT NULL default '1',
 USE_AVATARS enum('0','1') NOT NULL default '1',
 NUM_AVATARS smallint(1) NOT NULL default '80',
 AVA_RELPATH varchar(255) NOT NULL default 'images/avatars/',
 DEF_AVATAR varchar(255) NOT NULL default 'def_avatar.gif',
 AVA_WIDTH tinyint(1) NOT NULL default '30',
 AVA_HEIGHT tinyint(1) NOT NULL default '30',
 AVA_PROFBUTTON enum('0','1') NOT NULL default '1',
 MAX_DICES tinyint(1) NOT NULL default '99',
 MAX_ROLLS tinyint(1) NOT NULL default '6',
 BOT_CONTROL enum('0','1') NOT NULL default '1',
 MAX_PIC_SIZE smallint(1) NOT NULL default '350',
 USERS_SORT_ORD enum('0','1') NOT NULL default '0',
 CHAT_LOGS enum('0','1') NOT NULL default '1',
 LOG_DIR varchar(25) NOT NULL default 'logsadmin',
 SHOW_LOGS_USR enum('0','1') NOT NULL default '1',
 CHAT_LURKING enum('0','1') NOT NULL default '1',
 SHOW_LURK_USR enum('0','1') NOT NULL default '1',
 BAN_IP enum('0','1') NOT NULL default '0',
 REG_CHARS_ALLOWED varchar(50) NOT NULL default 'a-zA-Z0-9_.-@#$%^&*()=<>?~{}|`:',
 EXIT_LINK_TYPE enum('0','1') NOT NULL default '1',
 CHAT_EXTRAS enum('0','1') NOT NULL default '1',
 EMAIL_USER enum('0','1') NOT NULL default '1',
 BOT_HELLO varchar(100) NOT NULL default 'Hello People!!! Have you been missing me?',
 BOT_BYE varchar(100) NOT NULL default 'Bye Bye everyone! See you when I see you...',
 BOT_PUBLIC enum('0','1') NOT NULL default '1',
 ENABLE_PM enum('0','1') NOT NULL default '1',
 EN_ROOM1 enum('0','1','2') NOT NULL default '1',
 EN_ROOM2 enum('0','1','2') NOT NULL default '1',
 EN_ROOM3 enum('0','1','2') NOT NULL default '1',
 EN_ROOM4 enum('0','1','2') NOT NULL default '1',
 EN_ROOM5 enum('0','1','2') NOT NULL default '1',
 EN_ROOM6 enum('0','1','2') NOT NULL default '1',
 EN_ROOM7 enum('0','1','2') NOT NULL default '1',
 EN_ROOM8 enum('0','1','2') NOT NULL default '1',
 EN_ROOM9 enum('0','1','2') NOT NULL default '1',
 CHAT_BOOT enum('0','1') NOT NULL default '1',
 WELCOME_SOUND varchar(255) NOT NULL default 'sounds/hello.wav',
 WORLDTIME enum('0','1','2') NOT NULL default '2',
 UPD_CHECK enum('0','1') NOT NULL default '1',
 QUOTE enum('0','1') NOT NULL default '1',
 QUOTE_TIME tinyint(1) NOT NULL default '5',
 QUOTE_COLOR varchar(25) NOT NULL default 'brown',
 QUOTE_PATH varchar(255) NOT NULL default 'files/quotes/quotes_all.txt',
 HIDE_ADMINS enum('0','1') NOT NULL default '0',
 HIDE_MODERS enum('0','1') NOT NULL default '0',
 LAST_SAVED_ON datetime NOT NULL default CURRENT_TIMESTAMP,
 LAST_SAVED_BY varchar(30) NOT NULL default 'installer (upgrade)',
 CHAT_SYSTEM enum('standalone','phpnuke','phpbb') NOT NULL default 'standalone',
 NUKE_BB_PATH varchar(255) NOT NULL default '',
 CHAT_NAME varchar(255) NOT NULL default 'My WonderfulWorldWide Chat',
 ENGLISH_FORMAT enum('UK','US') NOT NULL default 'UK',
 FLAGS_3D enum('0','1') NOT NULL default '1',
 ALLOW_REGISTER enum('0','1') NOT NULL default '1',
 DISP_GENDER enum('0','1') NOT NULL default '0',
 SPECIAL_GHOSTS varchar(255) NOT NULL default '',
 FILLED_LOGIN enum('0','1') NOT NULL default '0',
 BACKGR_IMG enum('0','1') NOT NULL default '0',
 BACKGR_IMG_PATH varchar(255) NOT NULL default '',
 POPUP_LINKS enum('0','1') NOT NULL default '0',
 ITALICIZE_POWERS enum('0','1') NOT NULL default '1',
 MAIL_GREETING varchar(255) NOT NULL default 'Best regards,',
 PM_KEEP_DAYS tinyint(1) NOT NULL default '30',
 ALLOW_PM_DEL enum('0','1') NOT NULL default '1',
 LOGIN_COUNTER enum('0','1','60','1440','10080') NOT NULL default '60',
 ALLOW_GRAVATARS enum('0','1','2') NOT NULL default '1',
 GRAVATARS_CACHE enum('0','1') NOT NULL default '1',
 GRAVATARS_CACHE_EXPIRE tinyint(1) NOT NULL default '7',
 GRAVATARS_RATING enum('G','PG','R','X','ANY') NOT NULL default 'G',
 GRAVATARS_DYNAMIC_DEF enum('mm','identicon','monsterid','wavatar','retro') default 'monsterid',
 GRAVATARS_DYNAMIC_DEF_FORCE enum('0','1') NOT NULL default '0',
 ALLOW_UPLOADS enum('0','1') NOT NULL default '0',
 RES_ROOM1 enum('0','1') NOT NULL default '0',
 RES_ROOM2 enum('0','1') NOT NULL default '0',
 RES_ROOM3 enum('0','1') NOT NULL default '0',
 RES_ROOM4 enum('0','1') NOT NULL default '0',
 RES_ROOM5 enum('0','1') NOT NULL default '0',
 EN_STATS enum('0','1') NOT NULL default '0',
 ALLOW_VIDEO enum('0','1','2') NOT NULL default '1',
 VIDEO_WIDTH smallint(1) NOT NULL default '425',
 VIDEO_HEIGHT smallint(1) NOT NULL default '344',
 REQUIRE_BDAY enum('0','1') NOT NULL default '0',
 SEND_BDAY_EMAIL enum('0','1') NOT NULL default '0',
 SEND_BDAY_TIME tinyint(1) NOT NULL default '0',
 SEND_BDAY_INTVAL tinyint(1) NOT NULL default '7',
 SEND_BDAY_PATH varchar(255) NOT NULL default 'files/birthday/bday_greetings.txt',
 EN_WMPLAYER enum('0','1','2') NOT NULL default '0',
 WMP_STREAM varchar(255) default NULL,
 OPEN_ALL_BEG time NOT NULL default '00:00:00',
 OPEN_ALL_END time NOT NULL default '00:00:00',
 OPEN_SUN_BEG time NOT NULL default '00:00:00',
 OPEN_SUN_END time NOT NULL default '00:00:00',
 OPEN_MON_BEG time NOT NULL default '00:00:00',
 OPEN_MON_END time NOT NULL default '00:00:00',
 OPEN_TUE_BEG time NOT NULL default '00:00:00',
 OPEN_TUE_END time NOT NULL default '00:00:00',
 OPEN_WED_BEG time NOT NULL default '00:00:00',
 OPEN_WED_END time NOT NULL default '00:00:00',
 OPEN_THU_BEG time NOT NULL default '00:00:00',
 OPEN_THU_END time NOT NULL default '00:00:00',
 OPEN_FRI_BEG time NOT NULL default '00:00:00',
 OPEN_FRI_END time NOT NULL default '00:00:00',
 OPEN_SAT_BEG time NOT NULL default '00:00:00',
 OPEN_SAT_END time NOT NULL default '00:00:00',
 ALLOW_TEXT_COLORS enum('0','1') NOT NULL default '1',
 TAGS_POWERS set('b','i','u') default NULL,
 ALLOW_MATH enum('0','1') NOT NULL default '0',
 SRC_MATH varchar(255) NOT NULL default 'https://cdn.mathjax.org/mathjax/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML',
 USE_FLAGS enum('0','1') NOT NULL default '1',
 SHOW_FLAGS enum('0','1') NOT NULL default '1',
 NOTIFY_SOUND varchar(255) NOT NULL default 'sounds/notify.wav',
 PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO c_config (id, MODS, INSTALL_DATE, QUICKA, QUICKM, QUICKU, LAST_SAVED_ON, CHAT_SYSTEM, ALLOW_TEXT_COLORS) VALUES ('0', 'Advanced Admin, (GR)Avatars, Smilies Popup, Color Drop Box, Private Popup,<br />Quick Menu, Logs Archive, Lurking, Color names, WorldTime, UTF-8, Birthdays, MathJax, TV/Radio, Emoji', NOW(), 'Greetings|\r\nWelcome|\r\nThanks for coming by|\r\nLoL|\r\n:rofl|\r\n/announce I have to go now!|\r\n/away be right back...|\r\n/away ...I\'m back!|\r\n/bot start|\r\n/bot stop|\r\n/buzz|\r\n/buzz ~chimeup|\r\n/me is busy right now!|\r\n/mr is watching TV|\r\n/bye See you around!|\r\n/high user|\r\n/join 0 #%s|\r\n/join 1 #%s|\r\n/invite %s|\r\n/img http://www.path_to_image|\r\n/promote %s|\r\n/demote %s|\r\n/demote * %s|\r\n/room Please follow the topic|\r\n/size 12|\r\n/size|\r\n/sort|\r\n/topic |\r\n/topic reset|\r\n/video url_to_video|\r\n/wisp %s Hey, in which room ru?|\r\n/whois %s', 'Greetings|\r\nWelcome|\r\nThanks for coming by|\r\nLoL|\r\n:rofl|\r\n/away be right back...|\r\n/away ...I\'m back!|\r\n/buzz|\r\n/buzz ~chimeup|\r\n/me is busy right now!|\r\n/mr is reading|\r\n/bye cyall!|\r\n/high %s|\r\n/join 0 #%s|\r\n/join 1 #%s|\r\n/invite %s|\r\n/img http://www.path_to_image|\r\n/promote %s|\r\n/room Please follow the topic|\r\n/size 12|\r\n/size|\r\n/sort|\r\n/topic |\r\n/topic reset|\r\n/video url_to_video|\r\n/wisp %s Hey, in which room ru?|\r\n/whois %s', 'Hello everyone|\r\nlol|\r\n:rofl|\r\n/away brb...|\r\n/away ...back!|\r\n/me is busy!|\r\n/mr is lurking|\r\n/bye ttyl!|\r\n/high %s|\r\n/join 0 #%s|\r\n/join 1 #%s|\r\n/invite %s|\r\n/img http://www.path_to_image|\r\n/size 12|\r\n/size|\r\n/sort|\r\n/wisp %s Hey, in which room ru?|\r\n/whois %s', NOW(), 'standalone', '1');
