-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathext_tables.sql
111 lines (91 loc) · 3.21 KB
/
ext_tables.sql
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
CREATE TABLE tx_community_domain_model_relation (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
initiating_user int(11) unsigned DEFAULT '0',
requested_user int(11) unsigned DEFAULT '0',
initiation_time int(11) unsigned DEFAULT '0' NOT NULL,
status int(11) unsigned DEFAULT '1',
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_community_domain_model_message (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
sender int(11) unsigned DEFAULT '0',
recipient int(11) unsigned DEFAULT '0',
tx_community_read tinyint(4) unsigned DEFAULT '0',
sent tinyint(4) unsigned DEFAULT '0',
sent_date int(11) unsigned DEFAULT '0' NOT NULL,
read_date int(11) unsigned DEFAULT '0' NOT NULL,
subject tinytext,
message text,
sender_deleted tinyint(4) unsigned DEFAULT '0',
recipient_deleted tinyint(4) unsigned DEFAULT '0',
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE fe_users (
political_view tinytext,
religious_view tinytext,
activities tinytext,
interests tinytext,
music tinytext,
movies tinytext,
books tinytext,
quotes tinytext,
date_of_birth int(11),
about_me tinytext,
cellphone varchar(255) DEFAULT '' NOT NULL,
gender int(11) unsigned DEFAULT '0' NOT NULL,
profile_image varchar(255) DEFAULT '' NOT NULL
);
CREATE TABLE tx_community_domain_model_wallpost (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
sender int(11) unsigned DEFAULT '0',
recipient int(11) unsigned DEFAULT '0',
subject varchar(255) DEFAULT '',
message text,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_community_domain_model_album (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
user int(11) unsigned DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
private tinyint(4) DEFAULT '0' NOT NULL,
album_type tinyint(4) DEFAULT '0' NOT NULL,
photos int(11) unsigned DEFAULT '0' NOT NULL,
main_photo int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_community_domain_model_photo (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
album int(11) unsigned DEFAULT '0' NOT NULL,
image text NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);