· 8 years ago · Mar 25, 2018, 08:26 PM
1--
2-- Database: `prycisio_ctfadata`
3--
4-- --------------------------------------------------------
5--
6-- Table structure for table `ctf_audit`
7--
8CREATE TABLE IF NOT EXISTS `ctf_audit` (
9
10`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
11`tableused` VARCHAR( 45 ) DEFAULT NULL ,
12`idref` INT( 10 ) UNSIGNED DEFAULT NULL ,
13`entry_date` DATETIME DEFAULT NULL ,
14`entry_user` INT( 10 ) UNSIGNED DEFAULT NULL ,
15`entry_browser` TEXT,
16`entry_ip` VARCHAR( 16 ) DEFAULT NULL ,
17`entry_session` TEXT,
18`altid` INT( 10 ) UNSIGNED DEFAULT NULL ,
19`entry_data` TEXT COMMENT 'other user data',
20`checkhidden` VARCHAR( 255 ) DEFAULT NULL ,
21`entry_type` VARCHAR( 45 ) DEFAULT NULL ,
22PRIMARY KEY ( `id` )
23) ENGINE = INNODB DEFAULT CHARSET = latin1 ROW_FORMAT = DYNAMIC AUTO_INCREMENT =519;
24
25
26
27MySQL said: [​IMG]
28
29#1005 - Can't create table `prycisio_ctfadata`.`ctf_audit` (errno: 140 "Wrong create options")
30
31--
32-- Database: `prycisio_ctfadata`
33--
34
35innodb_file_format = Barracuda # For dynamic and compressed InnoDB tables