summaryrefslogtreecommitdiff
path: root/share/install/database/database_schema.sql
diff options
context:
space:
mode:
authoryo mama <pepper@scannerjammer.com>2015-09-22 00:51:40 -0700
committeryo mama <pepper@scannerjammer.com>2015-09-22 00:51:40 -0700
commitd3e7b5708deffbed864c916de22663f48333c58b (patch)
treeef76784a7827baff88c03670bf22832a3f146b17 /share/install/database/database_schema.sql
parent86c79f4372d7b2e7640a26473c7a4d331cdf7d16 (diff)
finishing server
Diffstat (limited to 'share/install/database/database_schema.sql')
-rw-r--r--share/install/database/database_schema.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/share/install/database/database_schema.sql b/share/install/database/database_schema.sql
new file mode 100644
index 0000000..802aa49
--- /dev/null
+++ b/share/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;
+