Release diogenes-0.9.22
[diogenes.git] / 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 `params` text NOT NULL,
117 `status` int(1) unsigned NOT NULL default '0',
118 PRIMARY KEY (`plugin`,`barrel`,`page`)
119 ) TYPE=MyISAM;
120
121 -- --------------------------------------------------------
122
123 --
124 -- Table structure for table `diogenes_site`
125 --
126
127 CREATE TABLE `diogenes_site` (
128 `alias` varchar(16) NOT NULL default '',
129 `vhost` varchar(255) NOT NULL default '',
130 `flags` varchar(255) NOT NULL default '',
131 PRIMARY KEY (`alias`)
132 ) TYPE=MyISAM;
133
134 -- --------------------------------------------------------
135
136 --
137 -- Set the database format version
138 --
139
140 INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.20';