diff options
| -rw-r--r-- | database/database_create_statements | 3 | ||||
| -rw-r--r-- | database/database_schema.sql | 15 |
2 files changed, 18 insertions, 0 deletions
diff --git a/database/database_create_statements b/database/database_create_statements new file mode 100644 index 0000000..9fa9e39 --- /dev/null +++ b/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/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; + |