On Tue, Aug 01, 2006 at 08:26:49AM +0300, Andrius Armonas wrote:
> Hi,
>
> here we go with full CREATE statement for the table:
Hi Andrius,
I'm not a mysql freak, but it seems you're using weird quotes. I would
suggest removing those quotes:
mysql> create table WMSWarehouses (
-> WarehouseID int(10) unsigned NOT NULL auto_increment,
-> PRIMARY KEY (WarehouseID));
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+------------------------+
| Tables_in_test |
+------------------------+
| WMSWarehouses |
+------------------------+
mysql> describe WMSWarehouses;
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| WarehouseID | int(10) unsigned | | PRI | NULL | auto_increment |
+-------------+------------------+------+-----+---------+----------------+
1 row in set (0.00 sec)
Case is preserved even without `quotes`. I wonder what this command
(describe WMSWarehouses) will do on your database.
Good luck,
Kai
> CREATE TABLE `WMSWarehouses` (
> `WarehouseID` int(10) unsigned NOT NULL auto_increment,
> `WarehouseCode` varchar(25) collate utf8_lithuanian_ci NOT NULL
> default '',
> `WarehouseName` varchar(200) collate utf8_lithuanian_ci NOT NULL
> default '',
> `WarehouseLocation` text collate utf8_lithuanian_ci,
> `WebServicesURL` varchar(200) collate utf8_lithuanian_ci NOT NULL
> default '',
> `WarehouseType` enum('CENTRAL','PERIPHERAL') collate
> utf8_lithuanian_ci NOT NULL default 'CENTRAL',
> `IsIndependentDistr` tinyint(1) NOT NULL default '0',
> `InvoiceSeries` varchar(3) collate utf8_lithuanian_ci NOT NULL default '',
> `PackingListSeries` varchar(3) collate utf8_lithuanian_ci NOT NULL
> default '',
> `PreliminaryInvoiceSeries` varchar(3) collate utf8_lithuanian_ci NOT
> NULL default '',
> `ExcDiscount` double(12,2) NOT NULL default '0.00',
> `EcoDiscount` double(12,2) NOT NULL default '0.00',
> `RecomPriceDiscount` double(12,2) NOT NULL default '0.00',
> `OwnerGroup` varchar(100) collate utf8_lithuanian_ci NOT NULL default '',
> `Details` text collate utf8_lithuanian_ci NOT NULL,
> `PresentWarehouseID` int(10) unsigned default NULL,
> PRIMARY KEY (`WarehouseID`),
> UNIQUE KEY `WarehouseCode` (`WarehouseCode`),
> KEY `WarehouseType` (`WarehouseType`),
> KEY `InvoiceSeries` (`InvoiceSeries`),
> KEY `PackingListSeries` (`PackingListSeries`),
> KEY `PreliminaryInvoiceSeries` (`PreliminaryInvoiceSeries`),
> KEY `IsIndependentDistr` (`IsIndependentDistr`),
> KEY `PresentWarehouseID` (`PresentWarehouseID`),
> CONSTRAINT `WMSWarehouses_ibfk_1` FOREIGN KEY (`PresentWarehouseID`)
> REFERENCES `WMSWarehouses` (`WarehouseID`) ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci
>
> Thanks,
> --
> Andrius
>
> Michael Bayer wrote:
> > need to show us the full CREATE statement for the table,as theres
> > something about it which is not supported; autoloading with MySQL
> > works in the general case.
> >
--
begin 600 .signature
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
