I am looking at adding a multiple devices to this script. I was able to decifer everything except the "installed varchar(255) DEFAULT '' NOT NULL". Can someone please help explain this to me, where I can find this on my devices or
#
# Table structure for table 'licenseinfo'
#
DROP TABLE IF EXISTS licenseinfo;
CREATE TABLE licenseinfo (
id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
skey varchar(255) DEFAULT '' NOT NULL,
installed varchar(255) DEFAULT '' NOT NULL,
expires varchar(255) DEFAULT '' NOT NULL,
complete varchar(4) DEFAULT '' NOT NULL,
enabled varchar(4) DEFAULT '' NOT NULL,
icount varchar(4) DEFAULT '' NOT NULL,
inactive varchar(4) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'licenseinfo'
#
LOCK TABLES licenseinfo WRITE;
UNLOCK TABLES;
#
# Table structure for table 'licenseinfo_new'
#
DROP TABLE IF EXISTS licenseinfo_new;
CREATE TABLE licenseinfo_new (
id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
skey varchar(255) DEFAULT '' NOT NULL,
installed varchar(255) DEFAULT '' NOT NULL,
expires varchar(255) DEFAULT '' NOT NULL,
complete varchar(4) DEFAULT '' NOT NULL,
enabled varchar(4) DEFAULT '' NOT NULL,
icount varchar(4) DEFAULT '' NOT NULL,
inactive varchar(4) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'licenseinfo_new'
#
LOCK TABLES licenseinfo_new WRITE;
INSERT INTO licenseinfo_new VALUES (1,'licensekey',''Unknown'','','0','1','1','0'),