Project

General

Profile

Download (832 Bytes) Statistics
| Branch: | Revision:

extplorer / sql / install.mysql.utf8.sql @ 89ef31e5

1
CREATE TABLE IF NOT EXISTS `#__extwebdav_locks` (
2
                                `token` varchar(255) NOT NULL default '',
3
                                `path` varchar(200) NOT NULL default '',
4
                                `expires` int(11) NOT NULL default '0',
5
                                `owner` varchar(200) default NULL,
6
                                `recursive` int(11) default '0',
7
                                `writelock` int(11) default '0',
8
                                `exclusivelock` int(11) NOT NULL default 0,
9
                                                  PRIMARY KEY  (`token`),
10
                                                  UNIQUE KEY token (`token`),
11
                                                  KEY `path` (`path`),
12
                                                  KEY `expires` (`expires`)
13
                                                ) ENGINE=MyISAM;
14
CREATE TABLE IF NOT EXISTS `#__extwebdav_properties` (
15
                                `path` varchar(255) NOT NULL default '',
16
                                `name` varchar(120) NOT NULL default '',
17
                                `ns` varchar(120) NOT NULL default 'DAV:',
18
                                `value` text,
19
                                                  PRIMARY KEY ( `ns` ( 100 ) , `path` ( 100 ) , `name` ( 50 ) ),
20
                                                  KEY `path` (`path`)
21
                                                ) ENGINE=MyISAM;