-
Notifications
You must be signed in to change notification settings - Fork 5
Expand file tree
/
Copy pathblog_db
More file actions
39 lines (31 loc) · 744 Bytes
/
Copy pathblog_db
File metadata and controls
39 lines (31 loc) · 744 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
===Database blog_bd
== Table structure for table categories
|------
|Column|Type|Null|Default
|------
|//**id_cat**//|int(3)|No|
|**name**|varchar(30)|No|
== Dumping data for table categories
== Table structure for table posts
|------
|Column|Type|Null|Default
|------
|//**id_post**//|int(6)|No|
|cat_id|int(3)|No|
|user_id|int(11)|No|
|**title**|varchar(255)|No|
|content|text|No|
|date_posted|datetime|No|
== Dumping data for table posts
== Table structure for table users
|------
|Column|Type|Null|Default
|------
|//**id_user**//|int(11)|No|
|**username**|varchar(32)|No|
|password|varchar(32)|No|
|first_name|varchar(50)|No|
|last_name|varchar(50)|No|
|email|varchar(1024)|No|
|active|int(11)|No|0
== Dumping data for table users