more plugin fixups
[diogenes.git] / 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';