+- CemesiK (https://cemesik.7m.pl)
+-- Dział: Jak stworzyć własny Portal Społecznościowy (https://cemesik.7m.pl/forumdisplay.php?fid=15)
+--- Dział: Tworzenie bazy danych (https://cemesik.7m.pl/forumdisplay.php?fid=25)
+---- Dział: Użytkowniku , gdzie są twoje dane (https://cemesik.7m.pl/forumdisplay.php?fid=46)
+---- Wątek: Użytkowniku , gdzie są twoje dane (/showthread.php?tid=24)
Użytkowniku , gdzie są twoje dane - Admin - 05-08-2025
Tabela z użytkownikami , czyli miejsce , w którym jest składana większość informacji , jakie się podaje podczas rejestracji oraz wypełnienia profilu . Nosi nazwę fb_user i jest jedną z najważniejszych w systemie . Będzie do niej najwięcej zapytań . Pola tabeli : identyfikator użytkownika , jego język , pierwsze imię , nazwisko , płeć , dzień urodzin , miesiąc urodzin , rok urodzin , adres e-mail , hasło , informacja , czy użytkownik jest aktywny , kod aktywacyjny , specjalny kod , data rejestracji , główny obraz , informacje o osobie , znane języki , ulubiona muzyka , książki , filmy , programy telewizyjne , gry , status osobowy , religia , politycy , osoby , które ją inspirują , cytaty , drużyny sportowe , sportowcy , dodatkowe adresy e-mail , komunikatory internetowe , telefony , ulica , miasto , kod pocztowy , strona WWW , informacje o szkołach , informacje o pracy , zainteresowania , czy użytkownik jest firmą , ustawienia prywatności , nazwa firmy oraz informacja , czy użytkownik jest zbanowany .
Tabela z danymi użytkownika
Kod PHP:
create table `fb_user` (
`user_id` int(11) not null auto_increment,
`user_lang` char(2) collate utf8_unicode_ci not null,
`user_firstname` varchar(255) collate utf8_unicode_ci not null,
`user_lastname` varchar(255) collate utf8_unicode_ci not null,
`user_gender` char(1) collate utf8_unicode_ci not null,
`user_birth_day` int(2) not null,
`user_birth_month` int(2) not null,
`user_birth_year` int(4) not null,
`user_email` varchar(255) collate utf8_unicode_ci not null,
`user_pswd` varchar(255) collate utf8_unicode_ci not null,
`user_active` char(1) collate utf8_unicode_ci not null,
`user_code` varchar(25) collate utf8_unicode_ci not null,
`user_special_code` varchar(25) collate utf8_unicode_ci not null,
`user_reg` varchar(10) collate utf8_unicode_ci not null,
`user_picture` char(1) collate utf8_unicode_ci not null,
`user_about` text collate utf8_unicode_ci not null,
`user_lang_1` varchar(55) collate utf8_unicode_ci not null,
`user_lang_2` varchar(55) collate utf8_unicode_ci not null,
`user_lang_3` varchar(55) collate utf8_unicode_ci not null,
`user_lang_4` varchar(55) collate utf8_unicode_ci not null,
`user_lang_5` varchar(55) collate utf8_unicode_ci not null,
`user_lang_6` varchar(55) collate utf8_unicode_ci not null,
`user_lang_7` varchar(55) collate utf8_unicode_ci not null,
`user_lang_8` varchar(55) collate utf8_unicode_ci not null,
`user_lang_9` varchar(55) collate utf8_unicode_ci not null,
`user_lang_10` varchar(55) collate utf8_unicode_ci not null,
`user_lang_1_know` tinyint(1) not null,
`user_lang_2_know` tinyint(1) not null,
`user_lang_3_know` tinyint(1) not null,
`user_lang_4_know` tinyint(1) not null,
`user_lang_5_know` tinyint(1) not null,
`user_lang_6_know` tinyint(1) not null,
`user_lang_7_know` tinyint(1) not null,
`user_lang_8_know` tinyint(1) not null,
`user_lang_9_know` tinyint(1) not null,
`user_lang_10_know` tinyint(1) not null,
`user_ent_music` varchar(255) collate utf8_unicode_ci not null,
`user_ent_books` varchar(255) collate utf8_unicode_ci not null,
`user_ent_films` varchar(255) collate utf8_unicode_ci not null,
`user_ent_tv` varchar(255) collate utf8_unicode_ci not null,
`user_ent_game` varchar(255) collate utf8_unicode_ci not null,
`user_maritalstatus` char(1) collate utf8_unicode_ci not null,
`user_religion` varchar(255) collate utf8_unicode_ci not null,
`user_religion_brief` tinytext collate utf8_unicode_ci not null,
`user_politics` varchar(255) collate utf8_unicode_ci not null,
`user_politics_brief` tinytext collate utf8_unicode_ci not null,
`user_people_inspirated` varchar(255) collate utf8_unicode_ci not null,
`user_people_inspirated_brief` tinytext collate utf8_unicode_ci not null,
`user_citates_brief` tinytext collate utf8_unicode_ci not null,
`user_sport` varchar(255) collate utf8_unicode_ci not null,
`user_sport_team_1` varchar(255) collate utf8_unicode_ci not null,
`user_sport_team_2` varchar(255) collate utf8_unicode_ci not null,
`user_sport_team_3` varchar(255) collate utf8_unicode_ci not null,
`user_sport_team_4` varchar(255) collate utf8_unicode_ci not null,
`user_sport_team_5` varchar(255) collate utf8_unicode_ci not null,
`user_sport_pearson_1` varchar(255) collate utf8_unicode_ci not null,
`user_sport_pearson_2` varchar(255) collate utf8_unicode_ci not null,
`user_sport_pearson_3` varchar(255) collate utf8_unicode_ci not null,
`user_sport_pearson_4` varchar(255) collate utf8_unicode_ci not null,
`user_sport_pearson_5` varchar(255) collate utf8_unicode_ci not null,
`user_email2` varchar(55) collate utf8_unicode_ci not null,
`user_email3` varchar(55) collate utf8_unicode_ci not null,
`user_email4` varchar(55) collate utf8_unicode_ci not null,
`user_email5` varchar(55) collate utf8_unicode_ci not null,
`user_skype` varchar(30) collate utf8_unicode_ci not null,
`user_gg` varchar(20) collate utf8_unicode_ci not null,
`user_aqq` varchar(50) collate utf8_unicode_ci not null,
`user_tlen` varchar(50) collate utf8_unicode_ci not null,
`user_windowsmsg` varchar(60) collate utf8_unicode_ci not null,
`user_telephone` varchar(30) collate utf8_unicode_ci not null,
`user_telephone2` varchar(30) collate utf8_unicode_ci not null,
`user_telephone3` varchar(30) collate utf8_unicode_ci not null,
`user_telephone4` varchar(30) collate utf8_unicode_ci not null,
`user_telephone5` varchar(30) collate utf8_unicode_ci not null,
`user_street` varchar(150) collate utf8_unicode_ci not null,
`user_city` varchar(150) collate utf8_unicode_ci not null,
`user_post_code` varchar(20) collate utf8_unicode_ci not null,
`user_www` varchar(140) collate utf8_unicode_ci not null,
`user_school_prim` varchar(65) collate utf8_unicode_ci not null,
`user_school_prim2` varchar(65) collate utf8_unicode_ci not null,
`user_school_prim3` varchar(65) collate utf8_unicode_ci not null,
`user_school_gim` varchar(65) collate utf8_unicode_ci not null,
`user_school_gim2` varchar(65) collate utf8_unicode_ci not null,
`user_school_gim3` varchar(65) collate utf8_unicode_ci not null,
`user_school_middle` varchar(65) collate utf8_unicode_ci not null,
`user_school_middle2` varchar(65) collate utf8_unicode_ci not null,
`user_school_middle3` varchar(65) collate utf8_unicode_ci not null,
`user_school_high` varchar(65) collate utf8_unicode_ci not null,
`user_school_high2` varchar(65) collate utf8_unicode_ci not null,
`user_school_high3` varchar(65) collate utf8_unicode_ci not null,
`user_work` varchar(65) collate utf8_unicode_ci not null,
`user_work2` varchar(65) collate utf8_unicode_ci not null,
`user_work3` varchar(65) collate utf8_unicode_ci not null,
`user_work4` varchar(65) collate utf8_unicode_ci not null,
`user_work5` varchar(65) collate utf8_unicode_ci not null,
`user_work6` varchar(65) collate utf8_unicode_ci not null,
`user_work7` varchar(65) collate utf8_unicode_ci not null,
`user_work8` varchar(65) collate utf8_unicode_ci not null,
`user_work9` varchar(65) collate utf8_unicode_ci not null,
`user_work10` varchar(65) collate utf8_unicode_ci not null,
`user_interests` varchar(255) collate utf8_unicode_ci not null,
`user_interests2` varchar(255) collate utf8_unicode_ci not null,
`user_is_firm` char(1) collate utf8_unicode_ci not null,
`user_priv_1` char(1) collate utf8_unicode_ci not null,
`user_priv_2` char(1) collate utf8_unicode_ci not null,
`user_priv_3` char(1) collate utf8_unicode_ci not null,
`user_priv_4` char(1) collate utf8_unicode_ci not null,
`user_priv_5` char(1) collate utf8_unicode_ci not null,
`user_priv_6` char(1) collate utf8_unicode_ci not null,
`user_priv_7` char(1) collate utf8_unicode_ci not null,
`user_priv_8` char(1) collate utf8_unicode_ci not null,
`user_priv_9` char(1) collate utf8_unicode_ci not null,
`user_priv_10` char(1) collate utf8_unicode_ci not null,
`user_priv_11` char(1) collate utf8_unicode_ci not null,
`user_firstlastname` varchar(255) collate utf8_unicode_ci not null,
`user_firm_name` int(11) not null,
`user_ban` char(1) collate utf8_unicode_ci not null,
primary key (`user_id`)
) engine=myisam auto_increment=35 default charset=utf8 collate=utf8_unicode_ci auto_increment=35 ;