SELECT

From SQLZOO
Revision as of 08:59, 14 April 2014 by 203.99.208.5 (Talk)

Jump to: navigation, search

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;

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense