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 /database/database_schema.sql | |
| parent | 60f0af05d68caf1dedf03bdb18cbd3c79294b137 (diff) | |
added database create statements
Diffstat (limited to 'database/database_schema.sql')
| -rw-r--r-- | database/database_schema.sql | 15 |
1 files changed, 15 insertions, 0 deletions
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; + |