[mdb-dev] Schema generation program

[<kn...@gr...>]

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 ...