[Openupload-svn-update] SF.net SVN: openupload:[16] trunk/sql/mysql/openupload.sql

[<ts...@us...>]

Revision: 16
          http://openupload.svn.sourceforge.net/openupload/?rev=16&view=rev
Author:   tsdogs
Date:     2008-10-15 14:10:22 +0000 (Wed, 15 Oct 2008)

Log Message:
-----------
First svn commit

Added Paths:
-----------
    trunk/sql/mysql/openupload.sql

Added: trunk/sql/mysql/openupload.sql
===================================================================
--- trunk/sql/mysql/openupload.sql	                        (rev 0)
+++ trunk/sql/mysql/openupload.sql	2008-10-15 14:10:22 UTC (rev 16)
@@ -0,0 +1,267 @@
+-- MySQL dump 10.11
+--
+-- Host: localhost    Database: openupload_empty
+-- ------------------------------------------------------
+-- Server version	5.0.51a-3ubuntu5.3
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Table structure for table `acl`
+--
+
+DROP TABLE IF EXISTS `acl`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `acl` (
+  `module` varchar(100) NOT NULL,
+  `action` varchar(100) NOT NULL,
+  `group_id` varchar(50) NOT NULL,
+  `access` varchar(10) NOT NULL,
+  PRIMARY KEY  (`module`,`action`,`group_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `acl`
+--
+
+LOCK TABLES `acl` WRITE;
+/*!40000 ALTER TABLE `acl` DISABLE KEYS */;
+INSERT INTO `acl` VALUES ('*','*','admins','allow'),('admin','*','unregisterd','deny'),('admin','*','registered','deny'),('files','*','unregistered','allow'),('files','*','registered','allow'),('auth','*','registered','allow'),('auth','*','unregistered','allow'),('auth','register','*','deny'),('auth','register','unregistered','deny'),('auth','login','*','deny'),('auth','login','unregistered','allow'),('auth','logout','unregistered','deny'),('auth','logout','*','allow');
+/*!40000 ALTER TABLE `acl` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `banned`
+--
+
+DROP TABLE IF EXISTS `banned`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `banned` (
+  `id` int(11) NOT NULL auto_increment,
+  `ip` varchar(50) NOT NULL,
+  `access` varchar(50) NOT NULL,
+  `priority` int(11) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `banned`
+--
+
+LOCK TABLES `banned` WRITE;
+/*!40000 ALTER TABLE `banned` DISABLE KEYS */;
+INSERT INTO `banned` VALUES (2,'0.0.0.0/0','allow',9999999),(1,'127.0.0.1','allow',1);
+/*!40000 ALTER TABLE `banned` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `file_options`
+--
+
+DROP TABLE IF EXISTS `file_options`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `file_options` (
+  `id` bigint(20) NOT NULL auto_increment,
+  `file_id` varchar(100) NOT NULL,
+  `module` varchar(50) NOT NULL,
+  `name` varchar(50) NOT NULL,
+  `value` varchar(200) NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `file_id` (`file_id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `file_options`
+--
+
+LOCK TABLES `file_options` WRITE;
+/*!40000 ALTER TABLE `file_options` DISABLE KEYS */;
+/*!40000 ALTER TABLE `file_options` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `files`
+--
+
+DROP TABLE IF EXISTS `files`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `files` (
+  `id` varchar(100) NOT NULL,
+  `name` varchar(200) NOT NULL,
+  `mime` varchar(200) NOT NULL,
+  `description` tinytext NOT NULL,
+  `size` int(12) NOT NULL,
+  `remove` varchar(100) NOT NULL,
+  `user_id` int(11) NOT NULL,
+  `upload_date` datetime NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `files`
+--
+
+LOCK TABLES `files` WRITE;
+/*!40000 ALTER TABLE `files` DISABLE KEYS */;
+/*!40000 ALTER TABLE `files` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `groups`
+--
+
+DROP TABLE IF EXISTS `groups`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `groups` (
+  `name` varchar(50) NOT NULL,
+  `description` varchar(250) default NULL,
+  PRIMARY KEY  (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `groups`
+--
+
+LOCK TABLES `groups` WRITE;
+/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
+INSERT INTO `groups` VALUES ('admins','Administrators group'),('registered','Registered Users'),('unregistered','Unregistered users');
+/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `langs`
+--
+
+DROP TABLE IF EXISTS `langs`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `langs` (
+  `id` varchar(10) NOT NULL,
+  `name` varchar(100) NOT NULL,
+  `locale` varchar(10) NOT NULL,
+  `browser` varchar(200) default NULL,
+  `charset` varchar(50) NOT NULL,
+  `active` tinyint(1) NOT NULL default '1',
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `langs`
+--
+
+LOCK TABLES `langs` WRITE;
+/*!40000 ALTER TABLE `langs` DISABLE KEYS */;
+INSERT INTO `langs` VALUES ('en','English','en_EN','[en];[en_EN]','iso-8559-1',1),('it','Italiano','it_IT.utf8','[it];[it_IT]','iso-8559-1',1);
+/*!40000 ALTER TABLE `langs` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `plugin_acl`
+--
+
+DROP TABLE IF EXISTS `plugin_acl`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `plugin_acl` (
+  `group_id` varchar(50) NOT NULL,
+  `plugin` varchar(100) NOT NULL,
+  `access` varchar(10) NOT NULL,
+  PRIMARY KEY  (`group_id`,`plugin`,`access`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `plugin_acl`
+--
+
+LOCK TABLES `plugin_acl` WRITE;
+/*!40000 ALTER TABLE `plugin_acl` DISABLE KEYS */;
+INSERT INTO `plugin_acl` VALUES ('admins','captcha','enable'),('admins','email','enable'),('admins','password','enable'),('registered','captcha','enable'),('registered','email','enable'),('registered','password','enable'),('unregistered','captcha','enable'),('unregistered','mimetypes','enable'),('unregistered','password','disable');
+/*!40000 ALTER TABLE `plugin_acl` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `plugin_oprions`
+--
+
+DROP TABLE IF EXISTS `plugin_oprions`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `plugin_oprions` (
+  `plugin` varchar(100) NOT NULL,
+  `group_id` varchar(100) NOT NULL,
+  `option` varchar(100) NOT NULL,
+  `value` varchar(100) NOT NULL,
+  PRIMARY KEY  (`plugin`,`group_id`,`option`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `plugin_oprions`
+--
+
+LOCK TABLES `plugin_oprions` WRITE;
+/*!40000 ALTER TABLE `plugin_oprions` DISABLE KEYS */;
+/*!40000 ALTER TABLE `plugin_oprions` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
+-- Table structure for table `users`
+--
+
+DROP TABLE IF EXISTS `users`;
+SET @saved_cs_client     = @@character_set_client;
+SET character_set_client = utf8;
+CREATE TABLE `users` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `login` varchar(100) NOT NULL,
+  `password` varchar(100) NOT NULL,
+  `name` varchar(200) NOT NULL,
+  `group_id` varchar(50) NOT NULL default 'unregistered',
+  `email` varchar(250) NOT NULL,
+  `active` tinyint(3) unsigned NOT NULL default '1',
+  PRIMARY KEY  (`id`),
+  KEY `login` (`login`)
+) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='MyShare Users';
+SET character_set_client = @saved_cs_client;
+
+--
+-- Dumping data for table `users`
+--
+
+LOCK TABLES `users` WRITE;
+/*!40000 ALTER TABLE `users` DISABLE KEYS */;
+INSERT INTO `users` VALUES (1,'admin','$1$IGgMd3Qo$f06LS1O.VmX57A18CkSuD1','Administrator','admins','ad...@yo...',1);
+/*!40000 ALTER TABLE `users` ENABLE KEYS */;
+UNLOCK TABLES;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+
+-- Dump completed on 2008-10-15 13:13:57


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.