php mysql 投票系统开发实例教程(1/4)

drop database if exists vote;
create database vote;
use vote;

CREATE TABLE  title  (                                                                                                                                                                                                                                                                
           id  int(6) NOT NULL auto_increment,
    username  varchar(20) NOT NULL,
    email  varchar(50) NOT NULL,
           title  varchar(250) NOT NULL default '',                                                                                                                                                                                                                                           
           types  tinyint(2) NOT NULL default '1',
    choice text,
           times  datetime NOT NULL default '0000-00-00 00:00:00',                                                                                                                                                                                                                            
          primary KEY ( id )     
        );

CREATE TABLE  vote  (                                                                                                                                                                                                                                                
           id  int(6) NOT NULL auto_increment,                                                                                                                                                                                                                         
           titleid  int(6) NOT NULL default '0',                                                                                                                                                                                                                           
           info  text NOT NULL,                                                                                                                                                                                                                                              
           vcount  int(4) NOT NULL default '0',                                                                                                                                                                                                                        
          primary KEY ( id )                                                                                                                                                                                                                                             
        );
create table email (
    id int(6) not null,
    email varchar(50) not null,
    primary key ( id, email)
 );

$conn=mysql_connect("localhost","phpdb","phpdb")
        or die("不能连接数据库服务器： ".mysql_error());
mysql_select_db("vote",$conn) or die ("不能选择数据库: ".mysql_error());

?>