Difference between revisions of "SELECT"

From SQLZOO
Jump to: navigation, search
(Blanked the page)
 
Line 1: Line 1:
CREATE TABLE ejb_queue_data (
 
  queue_id int(4) unsigned NOT NULL AUTO_INCREMENT,
 
  item_pk varchar(20) NOT NULL,
 
  of_counsel_id int(3) unsigned NOT NULL,
 
  in_process_user int(6) unsigned DEFAULT NULL,
 
  in_process_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  in_process_datetime datetime DEFAULT NULL,
 
  creation_datetime datetime NOT NULL,
 
  PRIMARY KEY (queue_id,item_pk,of_counsel_id),
 
  KEY Index_2 (creation_datetime)
 
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;
 
  
 
 
CREATE TABLE ejb_queue_data_trigger (
 
  queue_id int(4) unsigned NOT NULL AUTO_INCREMENT,
 
  item_pk varchar(20) NOT NULL,
 
  of_counsel_id int(3) unsigned NOT NULL,
 
  in_process_user int(6) unsigned DEFAULT NULL,
 
  in_process_flag tinyint(1) unsigned NOT NULL DEFAULT '0',
 
  in_process_datetime datetime DEFAULT NULL,
 
  creation_datetime datetime NOT NULL,
 
  PRIMARY KEY (queue_id,item_pk,of_counsel_id),
 
  KEY Index_2 (creation_datetime)
 
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;
 

Latest revision as of 05:00, 17 April 2014

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense