diff options
| author | yo mama <pepper@scannerjammer.com> | 2015-06-17 22:06:15 -0700 |
|---|---|---|
| committer | yo mama <pepper@scannerjammer.com> | 2015-06-17 22:06:15 -0700 |
| commit | c89619f1b1f908d0f330c468866cea669ce8bf6c (patch) | |
| tree | 885cbd2f7d71ac19d64e9ee5e54bfa53d02e2ce6 | |
| parent | 60f0af05d68caf1dedf03bdb18cbd3c79294b137 (diff) | |
added database create statements
| -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; + |