summaryrefslogtreecommitdiff
path: root/www/lighttpd/files/mysql_auth.sql
diff options
context:
space:
mode:
Diffstat (limited to 'www/lighttpd/files/mysql_auth.sql')
-rw-r--r--www/lighttpd/files/mysql_auth.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/www/lighttpd/files/mysql_auth.sql b/www/lighttpd/files/mysql_auth.sql
new file mode 100644
index 000000000000..5b1a25572225
--- /dev/null
+++ b/www/lighttpd/files/mysql_auth.sql
@@ -0,0 +1,10 @@
+CREATE TABLE `vhosts_secure`(
+ vhost_secure_id bigint(20) NOT NULL AUTO_INCREMENT,
+ vhost_secure_username varchar(255) NOT NULL,
+ vhost_secure_password varchar(255) NOT NULL,
+ vhost_secure_realm varchar(255) NOT NULL
+ PRIMARY KEY (vhost_secure_id),
+ INDEX i_username (vhost_secure_username),
+ INDEX i_password (vhost_secure_password),
+ INDEX i_realm (vhost_secure_realm)
+);