Сообщение Root » 2012-04-07 21:48:54
Код: Выделить всё
CREATE TABLE `HostingOrders` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`OrderID` int(11) NOT NULL,
`SchemeID` int(11) NOT NULL,
`OldSchemeID` int(11) DEFAULT NULL,
`Domain` char(255) DEFAULT '',
`Parked` text,
`ServerID` int(11) NOT NULL,
`Login` char(20) DEFAULT '',
`Password` char(64) NOT NULL,
`DaysRemainded` int(11) DEFAULT '0',
`ConsiderDay` int(11) DEFAULT '0',
`StatusID` char(30) DEFAULT 'UnSeted',
`StatusDate` int(11) DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `HostingOrdersOrderID` (`OrderID`),
KEY `HostingOrdersSchemeID` (`SchemeID`),
KEY `HostingOrdersServerID` (`ServerID`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8
[code]CREATE TABLE `HostingOrders` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`OrderID` int(11) NOT NULL,
`SchemeID` int(11) NOT NULL,
`OldSchemeID` int(11) DEFAULT NULL,
`Domain` char(255) DEFAULT '',
`Parked` text,
`ServerID` int(11) NOT NULL,
`Login` char(20) DEFAULT '',
`Password` char(64) NOT NULL,
`DaysRemainded` int(11) DEFAULT '0',
`ConsiderDay` int(11) DEFAULT '0',
`StatusID` char(30) DEFAULT 'UnSeted',
`StatusDate` int(11) DEFAULT '0',
PRIMARY KEY (`ID`),
KEY `HostingOrdersOrderID` (`OrderID`),
KEY `HostingOrdersSchemeID` (`SchemeID`),
KEY `HostingOrdersServerID` (`ServerID`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8[/code]