config/db/diogenes.sql

   1 -- phpMyAdmin SQL Dump
   2 -- version 2.6.1-pl3
   3 -- http://www.phpmyadmin.net
   4 --
   5 -- Host: localhost
   6 -- Generation Time: Apr 09, 2005 at 01:25 AM
   7 -- Server version: 4.0.24
   8 -- PHP Version: 4.3.10-10
   9 --
  10 -- Database: `diogenes`
  11 --
  12
  13 -- --------------------------------------------------------
  14
  15 --
  16 -- Table structure for table `diogenes_auth`
  17 --
  18
  19 CREATE TABLE `diogenes_auth` (
  20   `user_id` int(10) unsigned NOT NULL auto_increment,
  21   `username` varchar(32) NOT NULL default '',
  22   `firstname` varchar(127) NOT NULL default '',
  23   `lastname` varchar(127) NOT NULL default '',
  24   `password` varchar(32) NOT NULL default '',
  25   `perms` enum('user','admin') NOT NULL default 'user',
  26   `email` varchar(255) NOT NULL default '',
  27   PRIMARY KEY  (`user_id`),
  28   UNIQUE KEY `username` (`username`)
  29 ) TYPE=MyISAM;
  30
  31 -- --------------------------------------------------------
  32
  33 --
  34 -- Table structure for table `diogenes_logactions`
  35 --
  36
  37 CREATE TABLE `diogenes_logactions` (
  38   `id` int(2) NOT NULL auto_increment,
  39   `text` varchar(32) NOT NULL default '',
  40   `description` varchar(255) NOT NULL default '',
  41   PRIMARY KEY  (`id`)
  42 ) TYPE=MyISAM;
  43
  44 -- --------------------------------------------------------
  45
  46 --
  47 -- Table structure for table `diogenes_logevents`
  48 --
  49
  50 CREATE TABLE `diogenes_logevents` (
  51   `stamp` timestamp(14) NOT NULL,
  52   `session` int(6) NOT NULL default '0',
  53   `action` int(2) NOT NULL default '0',
  54   `data` varchar(255) NOT NULL default '',
  55   KEY `session` (`session`)
  56 ) TYPE=MyISAM;
  57
  58 -- --------------------------------------------------------
  59
  60 --
  61 -- Table structure for table `diogenes_logsessions`
  62 --
  63
  64 CREATE TABLE `diogenes_logsessions` (
  65   `id` int(10) unsigned NOT NULL auto_increment,
  66   `auth` enum('native','external') NOT NULL default 'native',
  67   `uid` int(10) unsigned NOT NULL default '0',
  68   `start` timestamp(14) NOT NULL,
  69   `ip` varchar(64) NOT NULL default '',
  70   `host` varchar(128) NOT NULL default '',
  71   `sauth` enum('native','external') NOT NULL default 'native',
  72   `suid` int(10) unsigned NOT NULL default '0',
  73   `browser` varchar(255) NOT NULL default '',
  74   PRIMARY KEY  (`id`),
  75   KEY `uid` (`uid`),
  76   KEY `start` (`start`)
  77 ) TYPE=MyISAM;
  78
  79 -- --------------------------------------------------------
  80
  81 --
  82 -- Table structure for table `diogenes_option`
  83 --
  84
  85 CREATE TABLE `diogenes_option` (
  86   `barrel` VARCHAR( 16 ) NOT NULL default '',
  87   `name` varchar(32) NOT NULL default '',
  88   `value` text NOT NULL,
  89   PRIMARY KEY  (`barrel`, `name`)
  90 ) TYPE=MyISAM;
  91
  92 -- --------------------------------------------------------
  93
  94 --
  95 -- Table structure for table `diogenes_perm`
  96 --
  97
  98 CREATE TABLE `diogenes_perm` (
  99   `alias` varchar(16) NOT NULL default '',
 100   `auth` enum('native','external') NOT NULL default 'native',
 101   `uid` int(10) unsigned NOT NULL default '0',
 102   `perms` enum('admin','user') NOT NULL default 'user',
 103   PRIMARY KEY  (`alias`,`auth`,`uid`)
 104 ) TYPE=MyISAM;
 105
 106 -- --------------------------------------------------------
 107
 108 --
 109 -- Table structure for table `diogenes_plugin`
 110 --
 111
 112 CREATE TABLE `diogenes_plugin` (
 113   `plugin` varchar(32) NOT NULL default '',
 114   `barrel` varchar(16) NOT NULL default '',
 115   `page` int(10) unsigned NOT NULL default '0',
 116   `pos` int(10) unsigned NOT NULL default '0',
 117   `params` text NOT NULL,
 118   `status` int(1) unsigned NOT NULL default '0',
 119   PRIMARY KEY  (`plugin`,`barrel`,`page`),
 120   KEY `pos` (`pos`)
 121 ) TYPE=MyISAM;
 122
 123 -- --------------------------------------------------------
 124
 125 --
 126 -- Table structure for table `diogenes_site`
 127 --
 128
 129 CREATE TABLE `diogenes_site` (
 130   `alias` varchar(16) NOT NULL default '',
 131   `vhost` varchar(255) NOT NULL default '',
 132   `flags` varchar(255) NOT NULL default '',
 133   PRIMARY KEY  (`alias`)
 134 ) TYPE=MyISAM;
 135
 136 -- --------------------------------------------------------
 137
 138 --
 139 -- Set the database format version
 140 --
 141
 142 INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.16+0.9.17pre21';