Re: [mdb-dev] Schema generation program

[Brian B. <ca...@um...>]

Cool!

You can send it directly to me...or you can get an account on
sourceforge.net I'll give you CVS write access.

BTW, those Unknown 0x01's will go away in the newest version with Georg's
patch. (they are MDB_BOOLs)

Brian

On Sat, 11 Mar 2000 kn...@gr... wrote:

> I have written a little program to generate a strawman output file for
> export of a database.  Here's the output on the "Solutions" database
> provided by Brian.  Of course, it will need customization for specific
> target databases.
> 
> -- Karl --
> 
> p.s. Brian - how do I send in the necessary changes?  It's about 11K - a
> change to a Makefile, a new .c file and a change to mdbtools.h.
> 
> DROP TABLE Animations;
> CREATE TABLE Animations
>  (
> 	AnimationValue			Long Integer (4), 
> 	AnimationDescription			Varchar (255)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE Examples;
> CREATE TABLE Examples
>  (
> 	TopicID			Long Integer (4), 
> 	ExampleID			Long Integer (4), 
> 	Description			Varchar (125), 
> 	ObjectID			Long Integer (4)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE ExampleTopics;
> CREATE TABLE ExampleTopics
>  (
> 	TopicID			Long Integer (4), 
> 	Description			Varchar (100), 
> 	SortOrder			Integer (2), 
> 	Type			Varchar (50)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE Links;
> CREATE TABLE Links
>  (
> 	recnum			Long Integer (4), 
> 	Description			Varchar (255), 
> 	HyperLink			(null)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE SalesGoals;
> CREATE TABLE SalesGoals
>  (
> 	EmployeeID			Long Integer (4), 
> 	Year			DateTime (Short) (8), 
> 	Goal			Long Integer (4)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE tbl_CommandBars;
> CREATE TABLE tbl_CommandBars
>  (
> 	CommandBarID			Long Integer (4), 
> 	CommandBarName			Varchar (255), 
> 	CommandBarType			Varchar (255)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE tbl_ControlTypes;
> CREATE TABLE tbl_ControlTypes
>  (
> 	ControlID			Long Integer (4), 
> 	Description			Varchar (50)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE tbl_MemberControls;
> CREATE TABLE tbl_MemberControls
>  (
> 	ControlID			Long Integer (4), 
> 	MemberControlID			Long Integer (4), 
> 	ControlCaption			Varchar (255), 
> 	ControlType			Varchar (255), 
> 	Visible			Unknown 0x01 (1), 
> 	ID			Long Integer (4)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE USysRegInfo;
> CREATE TABLE USysRegInfo
>  (
> 	Subkey			Varchar (255), 
> 	Type			Long Integer (4), 
> 	ValName			Varchar (255), 
> 	Value			Varchar (255)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE ExampleObjects;
> CREATE TABLE ExampleObjects
>  (
> 	ObjectID			Long Integer (4), 
> 	ObjectName			Varchar (60), 
> 	ObjectType			Varchar (10)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> DROP TABLE tbl_CommandBarMembers;
> CREATE TABLE tbl_CommandBarMembers
>  (
> 	MemberControlID			Long Integer (4), 
> 	CommandBarID			Long Integer (4), 
> 	MemberControlName			Varchar (255), 
> 	MemberControlType			Varchar (255), 
> 	Visible			Unknown 0x01 (1), 
> 	ID			Long Integer (4)
> 
> );
> -- CREATE ANY INDEXES ...
> 
> 
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> http://lists.sourceforge.net/mailman/listinfo/mdbtools-dev
>