Context Navigation

← Previous Changeset
Next Changeset →

Changeset 157

Timestamp:

08/25/07 02:27:36 (17 months ago)

Author:

jonas

Message:

CpVES version 0.04

Location:

trunk

Files:

: 2 modified

ChangeLog (modified) (1 diff)
mail_system.sql (modified) (19 diffs)

Legend:

: Unmodified
: Added
: Removed

trunk/ChangeLog

r156	r157
1		CpVES 0.04 ~~YYYY-MM-DD~~ - Jonas Genannt - <jonas.genannt@brachium-system.net>
	1	CpVES 0.04 2007-08-25 - Jonas Genannt - <jonas.genannt@brachium-system.net>
2	2	o Added: Webmail to config.inc.php and navigation for direct webmail link
3	3	o Added: initial language split

trunk/mail_system.sql

r95	r157
	1	-- phpMyAdmin SQL Dump
	2	-- version 2.6.2-Debian-3sarge3
	3	-- http://www.phpmyadmin.net
	4	--
	5	-- Host: localhost
	6	-- Generation Time: Aug 25, 2007 at 02:18 AM
	7	-- Server version: 4.1.11
	8	-- PHP Version: 4.3.10-22
1	9	--
2	10	-- Database: `mail_system`
…	…
13	21	`username` varchar(200) collate utf8_unicode_ci NOT NULL default '',
14	22	`passwd` varchar(200) collate utf8_unicode_ci NOT NULL default '',
15		`access` ~~enum('y','n') collate utf8_unicode_ci NOT NULL default 'y~~',
16		`manager` ~~enum('n','y') collate utf8_unicode_ci NOT NULL default 'n~~',
	23	`access` tinyint(1) NOT NULL default '1',
	24	`manager` tinyint(1) NOT NULL default '0',
17	25	`full_name` varchar(255) collate utf8_unicode_ci default NULL,
18	26	`cpasswd` varchar(255) character set utf8 NOT NULL default '',
19	27	PRIMARY KEY (`id`),
20	28	UNIQUE KEY `id` (`id`)
21		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	29	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	30
	31	--
	32	-- Dumping data for table `adm_users`
	33	--
	34
	35	INSERT INTO `adm_users` VALUES (1, 'admin', '', 1, 1, 'Superadmin', '$1$Ekjbn5PV$lTKL1k2IkDKzpneppf6Wx0');
22	36
23	37	-- --------------------------------------------------------
…	…
32	46	`domain` int(11) NOT NULL default '0',
33	47	PRIMARY KEY (`id`)
34		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	48	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	49
	50	--
	51	-- Dumping data for table `admin_access`
	52	--
	53
35	54
36	55	-- --------------------------------------------------------
…	…
46	65	`active` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
47	66	`email` int(11) NOT NULL default '0',
	67	`times` char(1) collate utf8_unicode_ci NOT NULL default '1',
48	68	PRIMARY KEY (`id`),
49	69	KEY `email` (`email`)
50	70	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	71
	72	--
	73	-- Dumping data for table `autoresponder`
	74	--
	75
51	76
52	77	-- --------------------------------------------------------
…	…
65	90	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
66	91
	92	--
	93	-- Dumping data for table `autoresponder_disable`
	94	--
	95
	96
67	97	-- --------------------------------------------------------
68	98
…	…
78	108	KEY `email` (`email`)
79	109	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	110
	111	--
	112	-- Dumping data for table `autoresponder_recipient`
	113	--
	114
80	115
81	116	-- --------------------------------------------------------
…	…
94	129	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
95	130
	131	--
	132	-- Dumping data for table `autoresponder_send`
	133	--
	134
	135
96	136	-- --------------------------------------------------------
97	137
…	…
103	143	`id` int(11) NOT NULL auto_increment,
104	144	`dnsname` varchar(255) collate utf8_unicode_ci NOT NULL default '',
105		`access` ~~enum('y','n') collate utf8_unicode_ci NOT NULL default 'y~~',
	145	`access` tinyint(1) NOT NULL default '0',
106	146	`p_imap` tinyint(1) default '1',
107	147	`p_pop3` tinyint(1) default '1',
…	…
114	154	`p_bogofilter` tinyint(1) NOT NULL default '0',
115	155	`p_sa_wb_listing` tinyint(1) NOT NULL default '0',
	156	`p_mailfilter` tinyint(1) NOT NULL default '0',
	157	`p_spam_del` tinyint(1) NOT NULL default '0',
	158	`enew` tinyint(1) NOT NULL default '1',
	159	`p_sa_learn` tinyint(1) NOT NULL default '0',
	160	`p_fetchmail` tinyint(1) NOT NULL default '0',
	161	`p_webinterface` tinyint(1) NOT NULL default '1',
116	162	PRIMARY KEY (`id`),
117	163	UNIQUE KEY `dnsname_2` (`dnsname`)
118		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	164	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	165
	166	--
	167	-- Dumping data for table `domains`
	168	--
	169
119	170
120	171	-- --------------------------------------------------------
…	…
134	185	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
135	186
	187	--
	188	-- Dumping data for table `email_options`
	189	--
	190
	191
	192	-- --------------------------------------------------------
	193
	194	--
	195	-- Table structure for table `fetchmail`
	196	--
	197
	198	CREATE TABLE `fetchmail` (
	199	`id` int(11) NOT NULL auto_increment,
	200	`email` int(11) NOT NULL default '0',
	201	`server` varchar(255) NOT NULL default '',
	202	`proto` tinyint(1) NOT NULL default '0',
	203	`conn_type` tinyint(1) NOT NULL default '0',
	204	`username` varchar(255) NOT NULL default '',
	205	`password` varchar(255) NOT NULL default '',
	206	`keep_mails` tinyint(1) NOT NULL default '0',
	207	`active` tinyint(1) NOT NULL default '1',
	208	PRIMARY KEY (`id`),
	209	KEY `email` (`email`),
	210	KEY `active` (`active`)
	211	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	212
	213	--
	214	-- Dumping data for table `fetchmail`
	215	--
	216
	217
136	218	-- --------------------------------------------------------
137	219
…	…
145	227	`efrom` varchar(255) collate utf8_unicode_ci NOT NULL default '',
146	228	`eto` text collate utf8_unicode_ci NOT NULL,
147		`access` ~~enum('y','n') collate utf8_unicode_ci NOT NULL default 'y~~',
	229	`access` tinyint(1) NOT NULL default '1',
148	230	PRIMARY KEY (`id`),
149	231	UNIQUE KEY `efrom` (`efrom`)
150		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	232	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	233
	234	--
	235	-- Dumping data for table `forwardings`
	236	--
	237
151	238
152	239	-- --------------------------------------------------------
…	…
161	248	KEY `listID` (`id`)
162	249	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	250
	251	--
	252	-- Dumping data for table `list_recp`
	253	--
	254
163	255
164	256	-- --------------------------------------------------------
…	…
178	270	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
179	271
	272	--
	273	-- Dumping data for table `lists`
	274	--
	275
	276
	277	-- --------------------------------------------------------
	278
	279	--
	280	-- Table structure for table `mailarchive`
	281	--
	282
	283	CREATE TABLE `mailarchive` (
	284	`id` int(11) NOT NULL auto_increment,
	285	`email` int(11) NOT NULL default '0',
	286	`folder` varchar(250) NOT NULL default '',
	287	`adays` int(11) NOT NULL default '0',
	288	`fname_month` tinyint(1) NOT NULL default '0',
	289	`fname_year` tinyint(1) NOT NULL default '0',
	290	`active` tinyint(1) NOT NULL default '0',
	291	`mailsread` tinyint(1) NOT NULL default '0',
	292	PRIMARY KEY (`id`),
	293	KEY `email` (`email`,`active`)
	294	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	295
	296	--
	297	-- Dumping data for table `mailarchive`
	298	--
	299
	300
180	301	-- --------------------------------------------------------
181	302
…	…
195	316	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
196	317
	318	--
	319	-- Dumping data for table `mailfilter`
	320	--
	321
	322
197	323	-- --------------------------------------------------------
198	324
…	…
210	336	KEY `domainid` (`domainid`),
211	337	KEY `type` (`type`)
212		) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	338	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	339
	340	--
	341	-- Dumping data for table `sa_wb_listing`
	342	--
	343
213	344
214	345	-- --------------------------------------------------------
…	…
219	350
220	351	CREATE TABLE `spamassassin` (
	352	`email` int(11) NOT NULL default '0',
221	353	`username` varchar(100) NOT NULL default '',
222	354	`preference` varchar(30) NOT NULL default '',
…	…
228	360	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
229	361
	362	--
	363	-- Dumping data for table `spamassassin`
	364	--
	365
	366
	367	-- --------------------------------------------------------
	368
	369	--
	370	-- Table structure for table `spamassassin_learn`
	371	--
	372
	373	CREATE TABLE `spamassassin_learn` (
	374	`id` int(11) NOT NULL auto_increment,
	375	`email` int(11) NOT NULL default '0',
	376	`folder` varchar(255) NOT NULL default '',
	377	`active` tinyint(1) NOT NULL default '0',
	378	`type` enum('spam','ham') NOT NULL default 'spam',
	379	PRIMARY KEY (`id`)
	380	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	381
	382	--
	383	-- Dumping data for table `spamassassin_learn`
	384	--
	385
	386
230	387	-- --------------------------------------------------------
231	388
…	…
240	397	`passwd` varchar(200) collate utf8_unicode_ci NOT NULL default '',
241	398	`full_name` text collate utf8_unicode_ci NOT NULL,
242		`access` ~~enum('y','n') collate utf8_unicode_ci NOT NULL default 'y~~',
	399	`access` tinyint(1) NOT NULL default '0',
243	400	`enew` tinyint(4) NOT NULL default '1',
244		~~`admin` enum('n','y') collate utf8_unicode_ci NOT NULL default 'n',~~
245	401	`p_imap` tinyint(1) default '1',
246	402	`p_pop3` tinyint(1) default '1',
…	…
252	408	`p_mailarchive` tinyint(1) default '0',
253	409	`p_bogofilter` tinyint(1) NOT NULL default '0',
	410	`p_spam_del` tinyint(1) NOT NULL default '0',
	411	`p_sa_learn` tinyint(1) NOT NULL default '0',
	412	`p_fetchmail` tinyint(1) NOT NULL default '0',
	413	`p_webinterface` tinyint(1) NOT NULL default '1',
254	414	PRIMARY KEY (`id`),
255	415	UNIQUE KEY `email` (`email`)
256		) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
257
258		INSERT INTO `adm_users` VALUES (1, 'admin', '', 'y', 'y', 'Superadmin', '$1$Ekjbn5PV$lTKL1k2IkDKzpneppf6Wx0');
	416	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
	417
	418	--
	419	-- Dumping data for table `users`
	420	--
	421
	422

Context Navigation

Changeset 157

Legend:

trunk/ChangeLog

trunk/mail_system.sql

Download in other formats: