Jump to content

Recommended Posts

Posted

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?

  • 4 weeks later...

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.