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> |