Jump to content
Sign in to follow this  
CrazY#MAN

Eroare in sintaxa RSQL linga Type=MyISAM!?

Recommended Posts

Interogare SQL:

CREATE TABLE tickets_tickets (
  tickets_id smallint(5) unsigned NOT NULL auto_increment,
  tickets_username varchar(16) NOT NULL default '',
  tickets_subject varchar(50) NOT NULL default '',
  tickets_timestamp int(10) unsigned NOT NULL default '0',
  tickets_status varchar(10) NOT NULL default '',
  tickets_name varchar(50) NOT NULL default '',
  tickets_email varchar(50) NOT NULL default '',
  tickets_urgency enum('Low','Medium','High','Very High') NOT NULL default 'Low',
  tickets_admin varchar(20) NOT NULL default '',
  tickets_child smallint(5) unsigned NOT NULL default '0',
  tickets_question text NOT NULL,
  PRIMARY KEY  (tickets_id),
  KEY tickets_username (tickets_username)
) TYPE=MyISAM

MySQL zice:
#1064 - Aveti o eroare in sintaxa RSQL linga 'TYPE=MyISAM' pe linia 15 

Vroiam sa fac un  fel System Suport Client etc.. dar nu merge sa pun asta. 

P.S am baza de date de la Krond dar nu pot pune sql ca imi apare asta.

Asta e tot ce are in SQL:

## Table structure for table `tickets_tickets`#CREATE TABLE tickets_tickets (  tickets_id smallint(5) unsigned NOT NULL auto_increment,  tickets_username varchar(16) NOT NULL default '',  tickets_subject varchar(50) NOT NULL default '',  tickets_timestamp int(10) unsigned NOT NULL default '0',  tickets_status varchar(10) NOT NULL default '',  tickets_name varchar(50) NOT NULL default '',  tickets_email varchar(50) NOT NULL default '',  tickets_urgency enum('Low','Medium','High','Very High') NOT NULL default 'Low',  tickets_admin varchar(20) NOT NULL default '',  tickets_child smallint(5) unsigned NOT NULL default '0',  tickets_question text NOT NULL,  PRIMARY KEY  (tickets_id),  KEY tickets_username (tickets_username)) TYPE=MyISAM;# --------------------------------------------------------## Table structure for table `tickets_users`#CREATE TABLE tickets_users (  tickets_users_id tinyint(3) unsigned NOT NULL auto_increment,  tickets_users_name varchar(50) NOT NULL default '',  tickets_users_username varchar(16) NOT NULL default '',  tickets_users_password varchar(16) NOT NULL default '',  tickets_users_email varchar(100) NOT NULL default '',  tickets_users_status tinyint(1) unsigned NOT NULL default '1',  PRIMARY KEY  (tickets_users_id),  KEY tickets_users_username (tickets_users_username)) TYPE=MyISAM;

Putin ajutor va rog?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...