search

Karthor / Hexclone

This is an attempt at making an clone of a browser game called HackerExperience.
6 stars 1 forks source link

SQL Error When i insert the sql on MYSQL 5.6 #2

Open wumix opened 6 years ago

wumix commented 6 years ago

CREATE TABLE active_virus ( ID int(11) NOT NULL, virusID int(11) NOT NULL COMMENT 'softwareID', started timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'DATE', collected timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'DATE', serverID int(11) NOT NULL, ownerID int(11) NOT NULL, version float NOT NULL, type text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I make this and now its working:

CREATE TABLE active_virus ( ID int(11) NOT NULL, virusID int(11) NOT NULL COMMENT 'softwareID', started timestamp NOT NULL, collected timestamp NOT NULL, serverID int(11) NOT NULL, ownerID int(11) NOT NULL, version float NOT NULL, type text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;