patch_0_3_2.sql

来自「一个页面界面的邮件程序」· SQL 代码 · 共 38 行

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jan 20, 2006 at 04:01 PM
-- Server version: 4.1.15
-- PHP Version: 5.0.5-3
-- 
-- Database: `contact`
-- 

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

-- 
-- Table structure for table `mailing_list`
-- 

CREATE TABLE `mailing_list` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `iduser` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `dest` char(3) NOT NULL default 'to',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `mailing_list_contact`
-- 

CREATE TABLE `mailing_list_contact` (
  `idmailinglist` int(11) unsigned NOT NULL default '0',
  `idcontact` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`idmailinglist`,`idcontact`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;