Feedback for “it-scripts Documentation”

[Johnlow151]

The SQL code does not properly build the entry in the database, the entries for the drug_plants and drug_processing tables are there but they are empty, even after clearing everything out and starting over, when running the query the tables are made with no entries. I am using HeidiSQL and am running "-- Install the drug_plants table
CREATE TABLE IF NOT EXISTS drug_plants (
id VARCHAR(11) NOT NULL, PRIMARY KEY(id),
owner LONGTEXT DEFAULT NULL,
coords LONGTEXT NOT NULL,
dimension INT(11) NOT NULL,
time INT(255) NOT NULL,
type VARCHAR(100) NOT NULL,
health DOUBLE NOT NULL DEFAULT 100,
fertilizer DOUBLE NOT NULL DEFAULT 0,
water DOUBLE NOT NULL DEFAULT 0,
growtime INT(11) NOT NULL
);

-- Install the drug_processing table
CREATE TABLE IF NOT EXISTS drug_processing (
id VARCHAR(11) NOT NULL, PRIMARY KEY(id),
coords LONGTEXT NOT NULL,
rotation DOUBLE NOT NULL,
dimension INT(11) NOT NULL,
owner LONGTEXT NOT NULL,
type VARCHAR(100) NOT NULL
);"
as the query which is what you have provided in the current release.