123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- CREATE DATABASE `db_ifractions` ;
- USE `db_ifractions`;
- DROP TABLE IF EXISTS `ifractions`;
- ;
- ;
- CREATE TABLE `ifractions` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `line_hostip` varchar(255) DEFAULT NULL,
- `line_playername` varchar(256) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_datetime` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_lang` varchar(6) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_game` varchar(10) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_mode` varchar(1) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_operator` varchar(5) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_level` int(5) NOT NULL,
- `line_mappos` int(5) NOT NULL,
- `line_result` varchar(6) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_time` varchar(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- `line_details` varchar(120) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
- ;
|