Hello
I would like to make an array to create following SQL sting.
CREATE TABLE `bookings` (
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`text` text DEFAULT NULL,
`room` int(11) DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`id` int(11) NOT NULL,
`is_paid` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Can someone please show me how I can create:
Text, int(11) and tinyint(1).
`text` text DEFAULT NULL,
`is_paid` tinyint(1) DEFAULT NULL
`status` int(11) DEFAULT NULL,
local aStru := { ;
{ "start_date", "D", 8, 0 }, ;
{ "end_date", "D", 8, 0 }, ;
{ "text", "C", 30, 0,"latin1" }, ;
{ "room", "N", 4, 0 }, ;
{ "status", "N", 5, 0 }, ;
{ "idPrimary", "+", 3, 0 }, ; // '+' : AutoInc Primary Key
{ "is_paid", "N", 6, 0 } }
Thank you in advance
Otto