upgrades/dbpatches/1.6/mysql/patch/scripts.sql


1
2
3
4
5
6
7
8
9
10

CREATE TABLE scripts (
        scriptid                bigint unsigned         DEFAULT '0'     NOT NULL,
        name            varchar(255)            DEFAULT ''      NOT NULL,
        command         varchar(255)            DEFAULT ''      NOT NULL,
        host_access             integer         DEFAULT '0'     NOT NULL,
	usrgrpid                bigint unsigned         DEFAULT '0'     NOT NULL,
	groupid         bigint unsigned         DEFAULT '0'     NOT NULL,

        PRIMARY KEY (scriptid)
) type=InnoDB;