forked from insider42/scriptdev2
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathr227_scriptdev2.sql
More file actions
28 lines (22 loc) · 1.18 KB
/
r227_scriptdev2.sql
File metadata and controls
28 lines (22 loc) · 1.18 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
ALTER TABLE `eventai_scripts`
DROP PRIMARY KEY,
DROP `id`,
ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST,
MODIFY `event_param1` int(11) signed NOT NULL default '0',
MODIFY `event_param2` int(11) signed NOT NULL default '0',
MODIFY `event_param3` int(11) signed NOT NULL default '0',
MODIFY `action1_param1` int(11) signed NOT NULL default '0',
MODIFY `action1_param2` int(11) signed NOT NULL default '0',
MODIFY `action1_param3` int(11) signed NOT NULL default '0',
MODIFY `action2_param1` int(11) signed NOT NULL default '0',
MODIFY `action2_param2` int(11) signed NOT NULL default '0',
MODIFY `action2_param3` int(11) signed NOT NULL default '0',
MODIFY `action3_param1` int(11) signed NOT NULL default '0',
MODIFY `action3_param2` int(11) signed NOT NULL default '0',
MODIFY `action3_param3` int(11) signed NOT NULL default '0',
ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment';
ALTER TABLE `localized_texts`
DROP PRIMARY KEY,
DROP `id`,
ADD `id` int(11) unsigned NOT NULL COMMENT 'Identifier' PRIMARY KEY AUTO_INCREMENT FIRST,
ADD `comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment';