Сообщение crazych » 2014-12-30 17:43:38
Код: Выделить всё
mysql> show create table Users;
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------+
| Users | CREATE TABLE `Users` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`GroupID` int(11) NOT NULL,
`RegisterDate` int(11) DEFAULT '0',
`OwnerID` int(11) DEFAULT NULL,
`IsManaged` enum('no','yes') DEFAULT 'no',
`IsInheritGroup` enum('no','yes') DEFAULT 'no',
`Name` char(100) DEFAULT '',
`Watchword` char(40) DEFAULT '',
`UniqID` char(32) DEFAULT 'no',
`Email` char(255) DEFAULT '',
`EmailConfirmed` int(12) DEFAULT '0',
`ICQ` char(12) DEFAULT '',
`JabberID` char(64) DEFAULT '',
`Mobile` char(20) DEFAULT '',
`MobileConfirmed` int(12) DEFAULT '0',
`Rating` decimal(7,2) DEFAULT '0.00',
`Sign` char(255) DEFAULT '',
`EnterIP` char(20) DEFAULT '-',
`EnterDate` int(11) DEFAULT '0',
`LayPayMaxDays` int(11) DEFAULT '0',
`LayPayMaxSumm` decimal(11,2) DEFAULT '0.00',
`LayPayThreshold` decimal(11,2) DEFAULT '0.00',
`IsActive` enum('no','yes') DEFAULT 'yes',
`IsNotifies` enum('no','yes') DEFAULT 'yes',
`IsHidden` enum('no','yes') DEFAULT 'no',
`IsProtected` enum('no','yes') DEFAULT 'no',
`Params` longtext,
`AdminNotice` text,
`IsConfirmed` enum('no','yes') DEFAULT 'yes',
PRIMARY KEY (`ID`),
KEY `UsersGroupID` (`GroupID`),
KEY `UsersOwnerID` (`OwnerID`),
KEY `UsersName` (`Name`),
KEY `UsersEmail` (`Email`),
CONSTRAINT `UsersGroupID` FOREIGN KEY (`GroupID`) REFERENCES `Groups` (`ID`) O N DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `UsersOwnerID` FOREIGN KEY (`OwnerID`) REFERENCES `Users` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=308 DEFAULT CHARSET=utf8 |
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------+
1 row in set (0.00 sec)
[code]mysql> show create table Users;
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------+
| Users | CREATE TABLE `Users` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`GroupID` int(11) NOT NULL,
`RegisterDate` int(11) DEFAULT '0',
`OwnerID` int(11) DEFAULT NULL,
`IsManaged` enum('no','yes') DEFAULT 'no',
`IsInheritGroup` enum('no','yes') DEFAULT 'no',
`Name` char(100) DEFAULT '',
`Watchword` char(40) DEFAULT '',
`UniqID` char(32) DEFAULT 'no',
`Email` char(255) DEFAULT '',
`EmailConfirmed` int(12) DEFAULT '0',
`ICQ` char(12) DEFAULT '',
`JabberID` char(64) DEFAULT '',
`Mobile` char(20) DEFAULT '',
`MobileConfirmed` int(12) DEFAULT '0',
`Rating` decimal(7,2) DEFAULT '0.00',
`Sign` char(255) DEFAULT '',
`EnterIP` char(20) DEFAULT '-',
`EnterDate` int(11) DEFAULT '0',
`LayPayMaxDays` int(11) DEFAULT '0',
`LayPayMaxSumm` decimal(11,2) DEFAULT '0.00',
`LayPayThreshold` decimal(11,2) DEFAULT '0.00',
`IsActive` enum('no','yes') DEFAULT 'yes',
`IsNotifies` enum('no','yes') DEFAULT 'yes',
`IsHidden` enum('no','yes') DEFAULT 'no',
`IsProtected` enum('no','yes') DEFAULT 'no',
`Params` longtext,
`AdminNotice` text,
`IsConfirmed` enum('no','yes') DEFAULT 'yes',
PRIMARY KEY (`ID`),
KEY `UsersGroupID` (`GroupID`),
KEY `UsersOwnerID` (`OwnerID`),
KEY `UsersName` (`Name`),
KEY `UsersEmail` (`Email`),
CONSTRAINT `UsersGroupID` FOREIGN KEY (`GroupID`) REFERENCES `Groups` (`ID`) O N DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `UsersOwnerID` FOREIGN KEY (`OwnerID`) REFERENCES `Users` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=308 DEFAULT CHARSET=utf8 |
+-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------+
1 row in set (0.00 sec)
[/code]