Undefined tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:DB <pre> mysql> describe tblUndefined Shipment; +---------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | K…')
Line 10: Line 10:
+---------------------+---------+------+-----+---------+----------------+
+---------------------+---------+------+-----+---------+----------------+
2 rows in set
2 rows in set
 +
 +
 +
-- ----------------------------
 +
 +
-- Table structure for tblUndefinedShipment
 +
 +
-- ----------------------------
 +
 +
DROP TABLE IF EXISTS `tblUndefinedShipment`;
 +
 +
CREATE TABLE `tblUndefinedShipment` (
 +
  `UndefinedShipmentId` int(10) NOT NULL auto_increment,
 +
  `GenericShipmentId` int(10) NOT NULL,
 +
  PRIMARY KEY  (`UndefinedShipmentId`),
 +
  KEY `UndefinedShipment_GenericShipmentId` (`GenericShipmentId`),
 +
  CONSTRAINT `tblUndefinedShipment_ibfk_11` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblGenericShipment` (`Id`) ON DELETE CASCADE
 +
) ENGINE=InnoDB AUTO_INCREMENT=997 DEFAULT CHARSET=latin1;
 +
 +
 +
</pre>
</pre>

Revision as of 16:15, 26 January 2010


mysql> describe tblUndefined Shipment;
+---------------------+---------+------+-----+---------+----------------+
| Field               | Type    | Null | Key | Default | Extra          |
+---------------------+---------+------+-----+---------+----------------+
| UndefinedShipmentId | int(10) | NO   | PRI | NULL    | auto_increment |
| GenericShipmentId   | int(10) | NO   | MUL | NULL    |                |
+---------------------+---------+------+-----+---------+----------------+
2 rows in set


-- ----------------------------

-- Table structure for tblUndefinedShipment

-- ----------------------------

DROP TABLE IF EXISTS `tblUndefinedShipment`;

CREATE TABLE `tblUndefinedShipment` (
  `UndefinedShipmentId` int(10) NOT NULL auto_increment,
  `GenericShipmentId` int(10) NOT NULL,
  PRIMARY KEY  (`UndefinedShipmentId`),
  KEY `UndefinedShipment_GenericShipmentId` (`GenericShipmentId`),
  CONSTRAINT `tblUndefinedShipment_ibfk_11` FOREIGN KEY (`GenericShipmentId`) REFERENCES `tblGenericShipment` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=997 DEFAULT CHARSET=latin1;



Personal tools