jjeff/rotomail/rotomail.mysql

-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 13, 2005 at 06:35 PM
-- Server version: 4.0.23
-- PHP Version: 4.3.11
-- 
-- Database: `fearless`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `rotomail_contacts`
-- 

CREATE TABLE rotomail_contacts (
  cid int(10) NOT NULL default '0',
  mailoruid varchar(100) NOT NULL default '',
  lid int(10) NOT NULL default '0',
  weight int(3) NOT NULL default '0'
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `rotomail_lists`
-- 

CREATE TABLE rotomail_lists (
  lid int(10) NOT NULL default '0',
  name varchar(100) NOT NULL default '',
  prefix varchar(100) NOT NULL default '',
  description varchar(200) NOT NULL default ''
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `rotomail_log`
-- 

CREATE TABLE rotomail_log (
  mid int(10) NOT NULL default '0',
  lid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
  stamp int(20) NOT NULL default '0',
  mailfrom varchar(100) NOT NULL default '',
  subject varchar(255) NOT NULL default '',
  glop text NOT NULL
) TYPE=MyISAM;
        
1	-- phpMyAdmin SQL Dump
2	-- version 2.6.2-pl1
3	-- http://www.phpmyadmin.net
4	--
5	-- Host: localhost
6	-- Generation Time: Aug 13, 2005 at 06:35 PM
7	-- Server version: 4.0.23
8	-- PHP Version: 4.3.11
9	--
10	-- Database: `fearless`
11	--
12
13	-- --------------------------------------------------------
14
15	--
16	-- Table structure for table `rotomail_contacts`
17	--
18
19	CREATE TABLE rotomail_contacts (
20	cid int(10) NOT NULL default '0',
21	mailoruid varchar(100) NOT NULL default '',
22	lid int(10) NOT NULL default '0',
23	weight int(3) NOT NULL default '0'
24	) TYPE=MyISAM;
25
26	-- --------------------------------------------------------
27
28	--
29	-- Table structure for table `rotomail_lists`
30	--
31
32	CREATE TABLE rotomail_lists (
33	lid int(10) NOT NULL default '0',
34	name varchar(100) NOT NULL default '',
35	prefix varchar(100) NOT NULL default '',
36	description varchar(200) NOT NULL default ''
37	) TYPE=MyISAM;
38
39	-- --------------------------------------------------------
40
41	--
42	-- Table structure for table `rotomail_log`
43	--
44
45	CREATE TABLE rotomail_log (
46	mid int(10) NOT NULL default '0',
47	lid int(10) NOT NULL default '0',
48	cid int(10) NOT NULL default '0',
49	stamp int(20) NOT NULL default '0',
50	mailfrom varchar(100) NOT NULL default '',
51	subject varchar(255) NOT NULL default '',
52	glop text NOT NULL
53	) TYPE=MyISAM;
54