gcontact.sql

一个页面界面的邮件程序

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 11, 2006 at 08:46 PM
-- Server version: 4.1.15
-- PHP Version: 5.0.5-3
-- 
-- Database: `gcontact`
-- 

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

-- 
-- Table structure for table `address`
-- 

CREATE TABLE `address` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idperson` int(10) unsigned NOT NULL default '0',
  `title` varchar(45) NOT NULL default '',
  `street` varchar(100) NOT NULL default '',
  `street_next` varchar(100) NOT NULL default '',
  `zipcode` varchar(10) NOT NULL default '',
  `town` varchar(45) NOT NULL default '',
  `country` varchar(45) NOT NULL default 'FRANCE',
  `map` blob,
  `note` text,
  PRIMARY KEY  (`id`),
  KEY `indexPerson` (`idperson`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `closed_frame`
-- 

CREATE TABLE `closed_frame` (
  `iduser` int(10) unsigned NOT NULL default '0',
  `key` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`iduser`,`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `contact`
-- 

CREATE TABLE `contact` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idperson` int(10) unsigned NOT NULL default '0',
  `type` varchar(45) NOT NULL default '',
  `value` varchar(100) NOT NULL default '',
  `file` blob,
  `note` text,
  PRIMARY KEY  (`id`),
  KEY `indexPerson` (`idperson`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `group`
-- 

CREATE TABLE `group` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `iduser` int(11) NOT NULL default '0',
  `name` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- 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;

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

-- 
-- Table structure for table `person`
-- 

CREATE TABLE `person` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `idgroup` int(10) unsigned NOT NULL default '0',
  `firstname` varchar(45) NOT NULL default '',
  `lastname` varchar(45) NOT NULL default '',
  `birthdate` date NOT NULL default '0000-00-00',
  `title` varchar(10) NOT NULL default '',
  `pic` blob,
  `note` text,
  PRIMARY KEY  (`id`),
  KEY `indexFirstname` (`firstname`),
  KEY `indexLastname` (`lastname`),
  KEY `indexGroup` (`idgroup`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `user`
-- 

CREATE TABLE `user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `email` varchar(45) NOT NULL default '',
  `password` varchar(45) NOT NULL default '',
  `language` varchar(4) NOT NULL default 'FR',
  `notifybirthday` tinyint(3) unsigned NOT NULL default '0',
  `lastmailsent` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `emailunique` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `user_person`
-- 

CREATE TABLE `user_person` (
  `idperson` int(10) unsigned NOT NULL default '0',
  `iduser` int(10) unsigned NOT NULL default '0',
  `role` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`idperson`,`iduser`,`role`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


ALTER TABLE `person` 
ADD FULLTEXT `search` (
`lastname` ,
`firstname` ,
`note`
);

ALTER TABLE `contact` 
ADD FULLTEXT `search` (
`value` ,
`note`
);

ALTER TABLE `contact` ADD INDEX ( `value` );

ALTER TABLE `address` 
ADD FULLTEXT `search` (
`street` ,
`street_next` ,
`zipcode` ,
`town` ,
`country` ,
`note`
);