From c89619f1b1f908d0f330c468866cea669ce8bf6c Mon Sep 17 00:00:00 2001 From: yo mama Date: Wed, 17 Jun 2015 22:06:15 -0700 Subject: added database create statements --- database/database_schema.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 database/database_schema.sql (limited to 'database/database_schema.sql') diff --git a/database/database_schema.sql b/database/database_schema.sql new file mode 100644 index 0000000..802aa49 --- /dev/null +++ b/database/database_schema.sql @@ -0,0 +1,15 @@ +CREATE TABLE if not exists `im_cmd` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `date` int(11) DEFAULT NULL, + `remote_addr` varchar(16) DEFAULT NULL, + `name` varchar(16) DEFAULT NULL, + `url` varchar(256) DEFAULT NULL, + `dir` varchar(2) DEFAULT NULL, + `oldfile` varchar(256) DEFAULT NULL, + `newfile` varchar(256) DEFAULT NULL, + `cmd` blob, + `dataobj` blob, + `tag` varchar(50) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=386739 DEFAULT CHARSET=utf8; + -- cgit v1.2.3-70-g09d2