From 0a90d5fb89bb5baa0bc34fb0dcea134d6bc8e220 Mon Sep 17 00:00:00 2001 From: yo mama Date: Wed, 12 Aug 2015 16:08:28 -0700 Subject: cleanup successful, still testing --- install/database/database_create_statements | 3 +++ install/database/database_schema.sql | 15 +++++++++++++++ 2 files changed, 18 insertions(+) create mode 100644 install/database/database_create_statements create mode 100644 install/database/database_schema.sql (limited to 'install/database') diff --git a/install/database/database_create_statements b/install/database/database_create_statements new file mode 100644 index 0000000..9fa9e39 --- /dev/null +++ b/install/database/database_create_statements @@ -0,0 +1,3 @@ +create database if not exists asdfus; +grant all privileges on asdfus.* to asdfus@localhost identified by 'gTYgT&M6q'; +flush privileges; diff --git a/install/database/database_schema.sql b/install/database/database_schema.sql new file mode 100644 index 0000000..802aa49 --- /dev/null +++ b/install/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