refresh translations (French is up to date)
[diogenes.git] / config / db / diogenes.sql
CommitLineData
6855525e
JL
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
19CREATE 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
37CREATE 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
50CREATE 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
64CREATE 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
85CREATE 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
98CREATE 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
112CREATE 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
128CREATE 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
141INSERT INTO `diogenes_option` SET name='dbversion', value='0.9.16+0.9.17pre21';