diff options
| author | Drahy <none@none> | 2009-02-04 17:11:58 +0100 |
|---|---|---|
| committer | Drahy <none@none> | 2009-02-04 17:11:58 +0100 |
| commit | 2552fe2dc19ad34a25147b528ecf4436d8eb1904 (patch) | |
| tree | 915c014276bf5df18b7a8d2156d6795ce71952a9 /sql/world_scripts_structure.sql | |
| parent | b4514aaf55f7a4d39da3c0f21bd4886c7b60fcb3 (diff) | |
* Updated script structure according to newest ACID 0.0.6 for trinity
* Updated some of world sql files - not all of them yet
* Cleaned up full script sql
--HG--
branch : trunk
Diffstat (limited to 'sql/world_scripts_structure.sql')
| -rw-r--r-- | sql/world_scripts_structure.sql | 30 |
1 files changed, 17 insertions, 13 deletions
diff --git a/sql/world_scripts_structure.sql b/sql/world_scripts_structure.sql index dff8a54a806..3d4ae9911cb 100644 --- a/sql/world_scripts_structure.sql +++ b/sql/world_scripts_structure.sql @@ -1,5 +1,5 @@ DROP TABLE IF EXISTS `custom_texts`; -CREATE TABLE `custom_texts` ( +CREATE TABLE IF NOT EXISTS `custom_texts` ( `entry` mediumint(8) NOT NULL, `content_default` text NOT NULL, `content_loc1` text, @@ -10,9 +10,10 @@ CREATE TABLE `custom_texts` ( `content_loc6` text, `content_loc7` text, `content_loc8` text, - `sound` mediumint(8) unsigned NOT NULL default '0', - `type` tinyint unsigned NOT NULL default '0', - `language` tinyint unsigned NOT NULL default '0', + `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `language` tinyint(3) unsigned NOT NULL DEFAULT '0', + `emote` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts'; @@ -69,15 +70,16 @@ CREATE TABLE `eventai_texts` ( `content_loc6` text, `content_loc7` text, `content_loc8` text, - `sound` mediumint(8) unsigned NOT NULL default '0', - `type` tinyint unsigned NOT NULL default '0', - `language` tinyint unsigned NOT NULL default '0', + `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `language` tinyint(3) unsigned NOT NULL DEFAULT '0', + `emote` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; DROP TABLE IF EXISTS `script_texts`; -CREATE TABLE `script_texts` ( +CREATE TABLE IF NOT EXISTS `script_texts` ( `entry` mediumint(8) NOT NULL, `content_default` text NOT NULL, `content_loc1` text, @@ -88,14 +90,16 @@ CREATE TABLE `script_texts` ( `content_loc6` text, `content_loc7` text, `content_loc8` text, - `sound` mediumint(8) unsigned NOT NULL default '0', - `type` tinyint unsigned NOT NULL default '0', - `language` tinyint unsigned NOT NULL default '0', + `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `language` tinyint(3) unsigned NOT NULL DEFAULT '0', + `emote` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'; +DROP TABLE IF EXISTS `sd2_db_version`; DROP TABLE IF EXISTS `script_db_version`; CREATE TABLE `script_db_version` ( - `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string' -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +`version` varchar(255) NOT NULL default '' COMMENT 'Database version string' +) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file |