[Openupload-svn-update] SF.net SVN: openupload:[34] trunk/sql/mysql
Status: Beta
Brought to you by:
tsdogs
Menu
▾
▴
[Openupload-svn-update] SF.net SVN: openupload:[34] trunk/sql/mysql
|
From: <ts...@us...> - 2008-10-18 11:03:52
|
Revision: 34
http://openupload.svn.sourceforge.net/openupload/?rev=34&view=rev
Author: tsdogs
Date: 2008-10-18 11:03:43 +0000 (Sat, 18 Oct 2008)
Log Message:
-----------
Update database structure and different preconfigured rights modes.
Added Paths:
-----------
trunk/sql/mysql/1_structure.sql
trunk/sql/mysql/2_base.sql
trunk/sql/mysql/3_mode_private.sql
trunk/sql/mysql/3_mode_public.sql
trunk/sql/mysql/3_mode_restricted.sql
trunk/sql/mysql/3_mode_service.sql
Removed Paths:
-------------
trunk/sql/mysql/openupload.sql
Added: trunk/sql/mysql/1_structure.sql
===================================================================
--- trunk/sql/mysql/1_structure.sql (rev 0)
+++ trunk/sql/mysql/1_structure.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -0,0 +1,155 @@
+-- phpMyAdmin SQL Dump
+-- version 2.11.3deb1ubuntu1.1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generato il: 18 Ott, 2008 at 11:12 AM
+-- Versione MySQL: 5.0.51
+-- Versione PHP: 5.2.4-2ubuntu5.3
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- Database: `openupload`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `acl`
+--
+
+CREATE TABLE IF NOT EXISTS `acl` (
+ `id` int(11) NOT NULL auto_increment,
+ `module` varchar(100) NOT NULL,
+ `action` varchar(100) NOT NULL,
+ `group_id` varchar(50) NOT NULL,
+ `access` varchar(10) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `banned`
+--
+
+CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `files`
+--
+
+CREATE TABLE IF NOT EXISTS `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,
+ `ip` varchar(40) NOT NULL,
+ `upload_date` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `file_options`
+--
+
+CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `groups`
+--
+
+CREATE TABLE IF NOT EXISTS `groups` (
+ `name` varchar(50) NOT NULL,
+ `description` varchar(250) default NULL,
+ PRIMARY KEY (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `langs`
+--
+
+CREATE TABLE IF NOT EXISTS `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;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `plugin_acl`
+--
+
+CREATE TABLE IF NOT EXISTS `plugin_acl` (
+ `id` int(11) NOT NULL auto_increment,
+ `group_id` varchar(50) NOT NULL,
+ `plugin` varchar(100) NOT NULL,
+ `access` varchar(10) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `group_id` (`group_id`,`plugin`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `plugin_options`
+--
+
+CREATE TABLE IF NOT EXISTS `plugin_options` (
+ `id` int(11) NOT NULL auto_increment,
+ `plugin` varchar(100) NOT NULL,
+ `group_id` varchar(100) NOT NULL,
+ `option` varchar(100) NOT NULL,
+ `value` text,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `users`
+--
+
+CREATE TABLE IF NOT EXISTS `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,
+ `lang` varchar(10) NOT NULL default 'en',
+ `active` tinyint(3) unsigned NOT NULL default '1',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `login` (`login`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;
Added: trunk/sql/mysql/2_base.sql
===================================================================
--- trunk/sql/mysql/2_base.sql (rev 0)
+++ trunk/sql/mysql/2_base.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -0,0 +1,59 @@
+-- phpMyAdmin SQL Dump
+-- version 2.11.3deb1ubuntu1.1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generato il: 18 Ott, 2008 at 11:15 AM
+-- Versione MySQL: 5.0.51
+-- Versione PHP: 5.2.4-2ubuntu5.3
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+--
+-- Database: `openupload`
+--
+
+--
+-- Dump dei dati per la tabella `banned`
+--
+
+INSERT INTO `banned` (`id`, `ip`, `access`, `priority`) VALUES(1, '127.0.0.1', 'allow', 1);
+INSERT INTO `banned` (`id`, `ip`, `access`, `priority`) VALUES(2, '0.0.0.0/0', 'allow', 9999999);
+
+--
+-- Dump dei dati per la tabella `groups`
+--
+
+INSERT INTO `groups` (`name`, `description`) VALUES('admins', 'Administrators group');
+INSERT INTO `groups` (`name`, `description`) VALUES('registered', 'Registered Users');
+INSERT INTO `groups` (`name`, `description`) VALUES('unregistered', 'Unregistered users');
+
+--
+-- Dump dei dati per la tabella `langs`
+--
+
+INSERT INTO `langs` (`id`, `name`, `locale`, `browser`, `charset`, `active`) VALUES('en', 'English', 'en_EN', '[en];[en-EN]', 'iso-8559-1', 1);
+INSERT INTO `langs` (`id`, `name`, `locale`, `browser`, `charset`, `active`) VALUES('it', 'Italiano', 'it_IT.utf8', '[it];[it-IT]', 'utf8', 1);
+
+--
+-- Dump dei dati per la tabella `users`
+--
+
+INSERT INTO `users` (`id`, `login`, `password`, `name`, `group_id`, `email`, `lang`, `active`) VALUES(1, 'admin', '$1$sLCQ3aFR$rCIb4Owhgi3mIHgYnbA351', 'Administrator', 'admins', 'ope...@yo...', 'en', 1);
+
+--
+-- Dump dei dati per la tabella `acl`
+--
+
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(1, '*', '*', 'admins', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(2, 'admin', '*', 'admins', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(3, 'admin', '*', '*', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(4, 'auth', 'login', 'unregistered', 'allow');
+
+--
+-- Dump dei dati per la tabella `plugin_acl`
+--
+
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(1, 'admins', 'password', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(2, 'admins', 'captcha', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(3, 'admins', 'email', 'enable');
Added: trunk/sql/mysql/3_mode_private.sql
===================================================================
--- trunk/sql/mysql/3_mode_private.sql (rev 0)
+++ trunk/sql/mysql/3_mode_private.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -0,0 +1,16 @@
+--
+-- Dump dei dati per la tabella `acl`
+--
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(5, 'auth', 'register', '*', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(6, 'auth', '*', 'unregistered', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(7, 'auth', '*', '*', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(8, 'files', '*', 'unregistered', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(9, 'files', '*', '*', 'allow');
+
+--
+-- Dump dei dati per la tabella `plugin_acl`
+--
+
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(4, 'registered', 'password', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(5, 'registered', 'captcha', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(6, 'registered', 'email', 'enable');
\ No newline at end of file
Added: trunk/sql/mysql/3_mode_public.sql
===================================================================
--- trunk/sql/mysql/3_mode_public.sql (rev 0)
+++ trunk/sql/mysql/3_mode_public.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -0,0 +1,14 @@
+--
+-- Dump dei dati per la tabella `acl`
+--
+
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(5, 'auth', '*', '*', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(6, 'files', '*', '*', 'allow');
+
+--
+-- Dump dei dati per la tabella `plugin_acl`
+--
+
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(4, 'unregistered', 'password', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(5, 'unregistered', 'captcha', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(6, 'unregistered', 'email', 'enable');
Added: trunk/sql/mysql/3_mode_restricted.sql
===================================================================
--- trunk/sql/mysql/3_mode_restricted.sql (rev 0)
+++ trunk/sql/mysql/3_mode_restricted.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -0,0 +1,18 @@
+--
+-- Dump dei dati per la tabella `acl`
+--
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(5, 'auth', 'register', '*', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(6, 'auth', '*', 'unregistered', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(7, 'auth', '*', '*', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(8, 'files', 'd', 'unregistered', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(9, 'files', 'g', 'unregistered', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(10, 'files', '*', 'unregistered', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(11, 'files', '*', '*', 'allow');
+
+--
+-- Dump dei dati per la tabella `plugin_acl`
+--
+
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(4, 'registered', 'password', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(5, 'registered', 'captcha', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(6, 'registered', 'email', 'enable');
Added: trunk/sql/mysql/3_mode_service.sql
===================================================================
--- trunk/sql/mysql/3_mode_service.sql (rev 0)
+++ trunk/sql/mysql/3_mode_service.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -0,0 +1,19 @@
+--
+-- Dump dei dati per la tabella `acl`
+--
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(5, 'auth', 'register', 'unregistered', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(6, 'auth', '*', 'unregistered', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(7, 'auth', 'register', '*', 'deny');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(8, 'auth', '*', '*', 'allow');
+INSERT INTO `acl` (`id`, `module`, `action`, `group_id`, `access`) VALUES(9, 'files', '*', '*', 'allow');
+
+--
+-- Dump dei dati per la tabella `plugin_acl`
+--
+
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(4, 'registered', 'password', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(5, 'registered', 'captcha', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(6, 'registered', 'email', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(7, 'unregistered', 'mimetypes', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(8, 'unregistered', 'captcha', 'enable');
+INSERT INTO `plugin_acl` (`id`, `group_id`, `plugin`, `access`) VALUES(9, 'unregistered', 'password', 'enable');
Deleted: trunk/sql/mysql/openupload.sql
===================================================================
--- trunk/sql/mysql/openupload.sql 2008-10-18 11:02:31 UTC (rev 33)
+++ trunk/sql/mysql/openupload.sql 2008-10-18 11:03:43 UTC (rev 34)
@@ -1,267 +0,0 @@
--- 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.
|
