Estructura BD
Versión 1 (Guillermo Zdanowicz, 18/03/2016 00:56)
| 1 | 1 | Guillermo Zdanowicz | h1. Estructura BD |
|---|---|---|---|
| 2 | 1 | Guillermo Zdanowicz | |
| 3 | 1 | Guillermo Zdanowicz | |
| 4 | 1 | Guillermo Zdanowicz | <pre> |
| 5 | 1 | Guillermo Zdanowicz | -- Create syntax for TABLE 'tbl_user_usercookies' |
| 6 | 1 | Guillermo Zdanowicz | CREATE TABLE `tbl_user_usercookies` ( |
| 7 | 1 | Guillermo Zdanowicz | `id` int(11) NOT NULL AUTO_INCREMENT, |
| 8 | 1 | Guillermo Zdanowicz | `user_id` int(11) DEFAULT NULL, |
| 9 | 1 | Guillermo Zdanowicz | `cookie_id` varchar(50) DEFAULT NULL, |
| 10 | 1 | Guillermo Zdanowicz | `status` varchar(1) DEFAULT NULL, |
| 11 | 1 | Guillermo Zdanowicz | PRIMARY KEY (`id`) |
| 12 | 1 | Guillermo Zdanowicz | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 13 | 1 | Guillermo Zdanowicz | |
| 14 | 1 | Guillermo Zdanowicz | -- Create syntax for TABLE 'tbl_user_userdetails' |
| 15 | 1 | Guillermo Zdanowicz | CREATE TABLE `tbl_user_userdetails` ( |
| 16 | 1 | Guillermo Zdanowicz | `id` int(11) NOT NULL AUTO_INCREMENT, |
| 17 | 1 | Guillermo Zdanowicz | `user_id` int(11) DEFAULT NULL, |
| 18 | 1 | Guillermo Zdanowicz | `name_first` varchar(100) DEFAULT NULL COMMENT 'Keresztnév', |
| 19 | 1 | Guillermo Zdanowicz | `name_last` varchar(100) DEFAULT NULL COMMENT 'Vezetéknév', |
| 20 | 1 | Guillermo Zdanowicz | `sex` varchar(20) DEFAULT NULL COMMENT 'Nem', |
| 21 | 1 | Guillermo Zdanowicz | `country` varchar(100) DEFAULT NULL COMMENT 'Ország', |
| 22 | 1 | Guillermo Zdanowicz | `county` varchar(100) DEFAULT NULL COMMENT 'Megye', |
| 23 | 1 | Guillermo Zdanowicz | `postal_code` varchar(10) DEFAULT NULL COMMENT 'Irsz', |
| 24 | 1 | Guillermo Zdanowicz | `city` varchar(100) DEFAULT NULL COMMENT 'Város', |
| 25 | 1 | Guillermo Zdanowicz | `email` varchar(100) DEFAULT NULL COMMENT 'E-mail', |
| 26 | 1 | Guillermo Zdanowicz | `phone_1` varchar(30) DEFAULT NULL COMMENT 'Telefonszám/FAX', |
| 27 | 1 | Guillermo Zdanowicz | `phone_2` varchar(30) DEFAULT NULL COMMENT 'Mobil', |
| 28 | 1 | Guillermo Zdanowicz | `website` varchar(255) DEFAULT NULL COMMENT 'weboldal', |
| 29 | 1 | Guillermo Zdanowicz | `comment_private` mediumtext COMMENT 'Privát megjegyzés', |
| 30 | 1 | Guillermo Zdanowicz | `google_profile` varchar(255) DEFAULT NULL COMMENT 'Google+ profil', |
| 31 | 1 | Guillermo Zdanowicz | `facebook_profile` varchar(255) DEFAULT NULL COMMENT 'Facebook profil', |
| 32 | 1 | Guillermo Zdanowicz | `status` varchar(1) DEFAULT NULL COMMENT 'Státusz', |
| 33 | 1 | Guillermo Zdanowicz | PRIMARY KEY (`id`) |
| 34 | 1 | Guillermo Zdanowicz | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 35 | 1 | Guillermo Zdanowicz | |
| 36 | 1 | Guillermo Zdanowicz | -- Create syntax for TABLE 'tbl_user_users' |
| 37 | 1 | Guillermo Zdanowicz | CREATE TABLE `tbl_user_users` ( |
| 38 | 1 | Guillermo Zdanowicz | `id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| 39 | 1 | Guillermo Zdanowicz | `email` varchar(255) DEFAULT NULL COMMENT 'E-mail cím', |
| 40 | 1 | Guillermo Zdanowicz | `password_hash` varchar(255) DEFAULT NULL COMMENT 'Jelszó', |
| 41 | 1 | Guillermo Zdanowicz | `auth_key` varchar(255) DEFAULT NULL COMMENT 'Authentikációs kulcs', |
| 42 | 1 | Guillermo Zdanowicz | `password_reset_token` varchar(255) DEFAULT NULL COMMENT 'Jelszóemlékeztető kulcs', |
| 43 | 1 | Guillermo Zdanowicz | `username` varchar(50) DEFAULT NULL COMMENT 'Felhasználónév', |
| 44 | 1 | Guillermo Zdanowicz | `created_at` datetime DEFAULT NULL COMMENT 'Regisztráció ideje', |
| 45 | 1 | Guillermo Zdanowicz | `activated_at` datetime DEFAULT NULL COMMENT 'Aktiválás ideje', |
| 46 | 1 | Guillermo Zdanowicz | `updated_at` datetime DEFAULT NULL COMMENT 'Módosítás ideje', |
| 47 | 1 | Guillermo Zdanowicz | `status` varchar(1) DEFAULT NULL COMMENT 'Státusz', |
| 48 | 1 | Guillermo Zdanowicz | PRIMARY KEY (`id`) |
| 49 | 1 | Guillermo Zdanowicz | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 50 | 1 | Guillermo Zdanowicz | |
| 51 | 1 | Guillermo Zdanowicz | -- Create syntax for TABLE 'tbl_user_usersessions' |
| 52 | 1 | Guillermo Zdanowicz | CREATE TABLE `tbl_user_usersessions` ( |
| 53 | 1 | Guillermo Zdanowicz | `id` int(11) NOT NULL AUTO_INCREMENT, |
| 54 | 1 | Guillermo Zdanowicz | `user_id` int(11) DEFAULT NULL, |
| 55 | 1 | Guillermo Zdanowicz | `session_id` varchar(50) DEFAULT NULL, |
| 56 | 1 | Guillermo Zdanowicz | `status` varchar(1) DEFAULT NULL, |
| 57 | 1 | Guillermo Zdanowicz | PRIMARY KEY (`id`) |
| 58 | 1 | Guillermo Zdanowicz | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 59 | 1 | Guillermo Zdanowicz | </pre> |