[Bio] / ToolBox / WebApplicationBackend.sql Repository:
ViewVC logotype

View of /ToolBox/WebApplicationBackend.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (download) (annotate)
Thu Jan 10 03:42:55 2008 UTC (11 years, 9 months ago) by wilke
Branch: MAIN
CVS Tags: HEAD
*** empty log message ***

-- MySQL dump 10.9
--
-- Host: bioseed    Database: WebAppBackend
-- ------------------------------------------------------
-- Server version	5.0.18-log

/*!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 */;
/*!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 `Backend`
--

DROP TABLE IF EXISTS `Backend`;
CREATE TABLE `Backend` (
  `_id` int(11) NOT NULL auto_increment,
  `name` varchar(64) default NULL,
  PRIMARY KEY  (`_id`),
  UNIQUE KEY `Backend_unique_0` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `Preferences`
--

DROP TABLE IF EXISTS `Preferences`;
CREATE TABLE `Preferences` (
  `_id` int(11) NOT NULL auto_increment,
  `value` varchar(255) default NULL,
  `user` int(11) default NULL,
  `_user_db` int(11) default NULL,
  `application` int(11) default NULL,
  `_application_db` int(11) default NULL,
  `name` varchar(255) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `Rights`
--

DROP TABLE IF EXISTS `Rights`;
CREATE TABLE `Rights` (
  `_id` int(11) NOT NULL auto_increment,
  `granted` tinyint(1) default NULL,
  `delegated` tinyint(1) default NULL,
  `data_id` varchar(255) default NULL,
  `data_type` varchar(255) default NULL,
  `application` int(11) default NULL,
  `_application_db` int(11) default NULL,
  `name` varchar(255) default NULL,
  `scope` int(11) default NULL,
  `_scope_db` int(11) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `Scope`
--

DROP TABLE IF EXISTS `Scope`;
CREATE TABLE `Scope` (
  `_id` int(11) NOT NULL auto_increment,
  `application` int(11) default NULL,
  `_application_db` int(11) default NULL,
  `name` varchar(255) default NULL,
  `description` text,
  PRIMARY KEY  (`_id`),
  UNIQUE KEY `Scope_unique_0` (`name`,`application`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `Session`
--

DROP TABLE IF EXISTS `Session`;
CREATE TABLE `Session` (
  `_id` int(11) NOT NULL auto_increment,
  `session_id` varchar(32) default NULL,
  `user` int(11) default NULL,
  `_user_db` int(11) default NULL,
  `creation` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`_id`),
  UNIQUE KEY `Session_unique_0` (`session_id`,`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `SessionItem`
--

DROP TABLE IF EXISTS `SessionItem`;
CREATE TABLE `SessionItem` (
  `_id` int(11) NOT NULL auto_increment,
  `parameters` text,
  `page` varchar(255) default NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `Session_entries`
--

DROP TABLE IF EXISTS `Session_entries`;
CREATE TABLE `Session_entries` (
  `_id` int(11) NOT NULL auto_increment,
  `_array_index` int(11) default NULL,
  `_target_id` int(11) default NULL,
  `_source_id` int(11) default NULL,
  `_target_db` int(11) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `User`
--

DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `_id` int(11) NOT NULL auto_increment,
  `firstname` varchar(64) default NULL,
  `email` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `comment` text,
  `entry_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `active` tinyint(1) default NULL,
  `lastname` varchar(64) default NULL,
  `login` varchar(25) default NULL,
  PRIMARY KEY  (`_id`),
  UNIQUE KEY `User_unique_0` (`login`),
  UNIQUE KEY `User_unique_1` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `UserHasScope`
--

DROP TABLE IF EXISTS `UserHasScope`;
CREATE TABLE `UserHasScope` (
  `_id` int(11) NOT NULL auto_increment,
  `user` int(11) default NULL,
  `_user_db` int(11) default NULL,
  `scope` int(11) default NULL,
  `_scope_db` int(11) default NULL,
  `granted` tinyint(1) default NULL,
  PRIMARY KEY  (`_id`),
  UNIQUE KEY `UserHasScope_unique_0` (`user`,`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `_metainfo`
--

DROP TABLE IF EXISTS `_metainfo`;
CREATE TABLE `_metainfo` (
  `_id` int(11) NOT NULL auto_increment,
  `info_name` varchar(255) default NULL,
  `info_value` varchar(255) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `_objects`
--

DROP TABLE IF EXISTS `_objects`;
CREATE TABLE `_objects` (
  `_id` int(11) NOT NULL auto_increment,
  `object` varchar(255) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `_references`
--

DROP TABLE IF EXISTS `_references`;
CREATE TABLE `_references` (
  `_id` int(11) NOT NULL auto_increment,
  `_database` varchar(512) default NULL,
  `_backend_type` varchar(255) default NULL,
  `_backend_data` varchar(1024) default NULL,
  PRIMARY KEY  (`_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!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 */;


MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3