- Integrate www/lighttpd-mysqlauth into www/lighttpd (optional)

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)
+);