On Wed, 29 Nov 2000 22:56:01 -0500, scott (AT) catchmaker .D.OT com (Scott Lawton) wrote:-
>
> >CREATE TABLE pr_scheinwerfer (
> > id int(5) DEFAULT '0' NOT NULL auto_increment,
> > pr_id int(5) DEFAULT '0' NOT NULL,
> > gewicht varchar(8),
> > breite varchar(8),
> > hoehe varchar(8),
> > tiefe varchar(8),
> > leistung varchar(10),
> > abstrahlwinkel_in_grad varchar(10),
> > farbtemperatur_in_kelvin varchar(40),
> > PRIMARY KEY (id),
> > UNIQUE id (id)
> >);
>
> David Bayly wrote a very cool script in Frontier that takes the
>following format as input:
>
> Customers
> Customer
> Name, string(30)
> Address, string(50)
> Photo, blob
> Invoice
> CustomerPTR, objectPtr(customer), deletionControl(delete_many)
> Date, date
> Total, float
>
> It might not be too much work to do a series of find/replace to
>convert from one to the other. There's a free version of Frontier
>5, and you don't need to learn much of Frontier to be able to run
>David's script.
>
It would be easy enough to change the parser to read the mySQL
format, but as Ruslan pointed out, the problem is how you map mySQL
data types to Valentina data types. For example what is an id type in
mySQL?
And to make good use of objectPtr which have no analog in mySQL is a
very big project.
--
- David Bayly. Programmer and digest reader. mailto:dbayly@udena.ch
Digest Readers do it once a day.
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2000 dbayly /at/ udena .DOT ch |
