| 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 | PRIMARY KEY (`plugin`,`barrel`,`page`), |
| 119 | KEY `pos` (`pos`) |
| 120 | ) TYPE=MyISAM; |
| 121 | |
| 122 | -- -------------------------------------------------------- |
| 123 | |
| 124 | -- |
| 125 | -- Table structure for table `diogenes_site` |
| 126 | -- |
| 127 | |
| 128 | CREATE TABLE `diogenes_site` ( |
| 129 | `alias` varchar(16) NOT NULL default '', |
| 130 | `vhost` varchar(255) NOT NULL default '', |
| 131 | `flags` varchar(255) NOT NULL default '', |
| 132 | PRIMARY KEY (`alias`) |
| 133 | ) TYPE=MyISAM; |
| 134 | |
| 135 | -- -------------------------------------------------------- |
| 136 | |
| 137 | -- |
| 138 | -- Set the database format version |
| 139 | -- |
| 140 | |
| 141 | INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.16+0.9.17pre21'; |