Database

Trouble with installing the databse please try following:

it-drugs

First step:

Execute these command:

-- Check for the drug_plants table
DROP TABLE IF EXISTS drug_plants;
-- Check for the drug
DROP TABLE IF EXISTS drug_processing;

Second Step:

Execute these commands:

CREATE TABLE IF NOT EXISTS drug_plants (
    id VARCHAR(11) NOT NULL, PRIMARY KEY(id),
    owner LONGTEXT DEFAULT NULL,
    coords LONGTEXT NOT NULL,
    time INT(255) NOT NULL,
    type VARCHAR(100) NOT NULL,
    water DOUBLE NOT NULL DEFAULT 0,
    growtime INT(11) NOT NULL,
    health DOUBLE NOT NULL DEFAULT 100,
    fertilizer DOUBLE NOT NULL DEFAULT 0
    );

CREATE TABLE IF NOT EXISTS drug_processing (
    id VARCHAR(11) NOT NULL, PRIMARY KEY(id),
    owner LONGTEXT NOT NULL,
    coords LONGTEXT NOT NULL,
    rotation DOUBLE NOT NULL,
    type VARCHAR(100) NOT NULL
    );