Create mySQL database structure from Rev

[stephen barncard]

If one just needs the schema try this command:

*show create table*

after opening the database

this will return data like this

2004_INV CREATE TABLE `2004_INV` (

  `ID` int(11) NOT NULL,

  `DATE_CREATE` date NOT NULL,

  `DATE_CHANGE` date NOT NULL,

  `BRIEF_DESC` varchar(255) NOT NULL,

  `DESCRIPTION` varchar(255) NOT NULL,

  `CATEGORY` varchar(255) NOT NULL,

  `CURRENT_LOC` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1



remove the tablename ( in this case "2004_INV" ) and you have ready to run
'table creator' code for the table