Frost Diver Posted March 17, 2024 Group: Members Topic Count: 48 Topics Per Day: 0.02 Content Count: 189 Reputation: 7 Joined: 10/22/18 Last Seen: Yesterday at 02:04 PM Share Posted March 17, 2024 (edited) Hello, i run this script in sql: CREATE TABLE `bk6_talk` (`intid` int(11) unsigned NOT NULL AUTO_INCREMENT, `npcid` mediumint(8) unsigned DEFAULT '0', `talkid` int(11) unsigned NOT NULL DEFAULT '0', `lang` varchar(3) NOT NULL DEFAULT 'en', `custom` tinyint(1) unsigned NOT NULL DEFAULT '0', `dialog` varchar(255) DEFAULT NULL, PRIMARY KEY (`intid`), UNIQUE KEY `idx_unique` (`npcid`,`talkid`,`lang`,`dialog`), KEY `idx_dialog` (`npcid`,`talkid`,`lang`)) ENGINE=MyISAM AUTO_INCREMENT=1; but got error. how to adjust the script to be able to create table in my database? Edited March 19, 2024 by Frost Diver Quote Link to comment Share on other sites More sharing options...
0 Frost Diver Posted March 19, 2024 Group: Members Topic Count: 48 Topics Per Day: 0.02 Content Count: 189 Reputation: 7 Joined: 10/22/18 Last Seen: Yesterday at 02:04 PM Author Share Posted March 19, 2024 I'm still looking for answers to fix this sql script.. Quote Link to comment Share on other sites More sharing options...
Question
Frost Diver
Hello,
i run this script in sql:
CREATE TABLE `bk6_talk` (`intid` int(11) unsigned NOT NULL AUTO_INCREMENT, `npcid` mediumint(8) unsigned DEFAULT '0', `talkid` int(11) unsigned NOT NULL DEFAULT '0', `lang` varchar(3) NOT NULL DEFAULT 'en', `custom` tinyint(1) unsigned NOT NULL DEFAULT '0', `dialog` varchar(255) DEFAULT NULL, PRIMARY KEY (`intid`), UNIQUE KEY `idx_unique` (`npcid`,`talkid`,`lang`,`dialog`), KEY `idx_dialog` (`npcid`,`talkid`,`lang`)) ENGINE=MyISAM AUTO_INCREMENT=1;but got error. how to adjust the script to be able to create table in my database?
Edited by Frost DiverLink to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.