View Single Post
Old 02-16-2008, 04:29 AM   #10 (permalink)
DJMaze
Senior Contributor
 
DJMaze's Avatar
 
Join Date: Mar 2005
Posts: 664
DJMaze is on a distinguished road
Wow you definably need to learn it.

Code:
CREATE TABLE managers (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL ,
  password VARCHAR(32) NOT NULL ,
  webmaster TINYINT NOT NULL DEFAULT 0,
  PRIMARY KEY (id)
) TYPE = MYISAM;

CREATE UNIQUE INDEX i_m_name ON managers (name);
Never use backticks, it is only supported by MySQL and allows you to create bad field names.
With bad fieldnames you can create fields with reserved words like: delete, create, default, key, etc.
__________________

UT: Ultra-kill... God like!
DJMaze is offline   Reply With Quote