· 8 years ago · Dec 26, 2017, 08:16 AM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : this
5Source Server Version : 50515
6Source Host : localhost:3306
7Source Database : server
8
9Target Server Type : MYSQL
10Target Server Version : 50515
11File Encoding : 65001
12
13Date: 2011-10-02 17:43:55
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `plimus`
20-- ----------------------------
21DROP TABLE IF EXISTS `plimus`;
22CREATE TABLE `plimus` (
23 `id` int(10) NOT NULL AUTO_INCREMENT,
24 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
25 `username` varchar(15) DEFAULT NULL,
26 `item` smallint(5) DEFAULT NULL,
27 `quantity` smallint(5) DEFAULT NULL,
28 `given` tinyint(1) NOT NULL DEFAULT '0',
29 PRIMARY KEY (`id`)
30) ENGINE=InnoDB AUTO_INCREMENT=333394 DEFAULT CHARSET=latin1;
31
32-- ----------------------------
33-- Records of plimus
34-- ----------------------------
35INSERT INTO `plimus` VALUES ('333393', '2011-10-02 17:40:01', 'Jack', '32767', '100', '0');