forked from pixelant/pxa_social_feed
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
82 lines (65 loc) · 2.43 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
#
# Table structure for table 'tx_pxasocialfeed_domain_model_feed'
#
CREATE TABLE tx_pxasocialfeed_domain_model_feed (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
post_date int(11) DEFAULT '0' NOT NULL,
post_url varchar(255) DEFAULT '' NOT NULL,
message text NOT NULL,
image text NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
likes int(11) unsigned DEFAULT '0',
external_identifier varchar(255) DEFAULT '' NOT NULL,
update_date int(11) unsigned DEFAULT '0' NOT NULL,
configuration int(11) unsigned DEFAULT '0',
type varchar(100) NOT NULL DEFAULT '0',
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_pxasocialfeed_domain_model_token'
#
CREATE TABLE tx_pxasocialfeed_domain_model_token (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
serialized_credentials blob,
social_type int(11) DEFAULT '1' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_pxasocialfeed_domain_model_config'
#
CREATE TABLE tx_pxasocialfeed_domain_model_configuration (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
social_id varchar(255) DEFAULT '' NOT NULL,
token int(11) unsigned DEFAULT '0',
feeds_limit int(11) unsigned DEFAULT '0',
feed_storage int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);