Ver Mensaje Individual
  #2 (permalink)  
Antiguo 23/03/2002, 19:39
asound
Invitado
 
Mensajes: n/a
Puntos:
Re: SQL-query Error al crear una tabla ayudaaa

a ver usa este

CREATE TABLE webon_admin (
aid int(11) NOT NULL auto_increment,
adminid varchar(100) NOT NULL default '',
password varchar(16) NOT NULL default '',
email varchar(100) NOT NULL default '',
admin_options char(1) NOT NULL default '',
admin_news char(1) NOT NULL default '',
admin_newsedit char(1) NOT NULL default '',
admin_newsdelete char(1) NOT NULL default '',
admin_newsnotapproved char(1) NOT NULL default '',
admin_comments char(1) NOT NULL default '',
admin_addnews char(1) NOT NULL default '',
admin_addadmins char(1) NOT NULL default '',
PRIMARY KEY (aid),
UNIQUE KEY userid (adminid)
);

INSERT INTO webon_admin VALUES (1, 'admin', 'admin', '[email protected]', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');