forked from lochmueller/staticfilecache
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
executable file
·24 lines (23 loc) · 739 Bytes
/
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
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
tx_staticfilecache_cache tinyint(1) DEFAULT '1',
tx_staticfilecache_cache_force tinyint(1) DEFAULT '0',
tx_staticfilecache_cache_offline tinyint(1) DEFAULT '0',
tx_staticfilecache_cache_priority int(11) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_staticfilecache_queue'
#
CREATE TABLE tx_staticfilecache_queue (
uid int(11) NOT NULL auto_increment,
cache_url varchar(500) NOT NULL,
cache_priority int(11) DEFAULT '0' NOT NULL,
page_uid int(11) DEFAULT '0' NOT NULL,
invalid_date int(11) DEFAULT '0' NOT NULL,
call_date int(11) DEFAULT '0' NOT NULL,
call_result varchar(255) NOT NULL,
PRIMARY KEY (uid),
INDEX call_date (call_date, cache_url(100))
);