table creation problems

[anders thoresson]

Hi,

I've three tables that my local MySQL server accepts, but when I try to 
create the same three tables on my ISP's server, it doesn't work.

These are the three tables:

CREATE TABLE un_user
(
        u_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
        u_uname VARCHAR(20) NOT NULL UNIQUE,
        u_pwd CHAR(20) NOT NULL,
        u_fname VARCHAR(20) NOT NULL,
        u_lname VARCHAR(35) NOT NULL,
        u_email VARCHAR(50) NOT NULL,
        u_phone VARCHAR(25) NOT NULL,
        u_cellphone VARCHAR(25) NOT NULL,
        u_editor ENUM("Y","N") DEFAULT "N" NOT NULL,
        u_admin ENUM("Y","N") DEFAULT "N" NOT NULL
);
CREATE TABLE un_section
(
        s_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
        s_name VARCHAR(40) NOT NULL UNIQUE,
        s_desc TEXT NOT NULL
);
CREATE TABLE un_issue
(
        i_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
        i_date DATE NOT NULL UNIQUE,
        i_number INT NOT NULL,
        i_editor INT,
        UNIQUE (i_date, i_number)
);
For local development I'm using MySQL 3.23.55-NT on a Windows 2000 server. 
My ISP uses 3.22.25 on a SunOS 5.7 server.

Any suggestions?

--
anders thoresson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]