Changeset 5 for trunk/src/bindings/scripts/sql
- Timestamp:
- 11/19/08 13:21:11 (17 years ago)
- Location:
- trunk/src/bindings/scripts/sql
- Files:
-
- 2 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/bindings/scripts/sql/create_database.sql
r2 r5 1 CREATE DATABASE ` scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;1 CREATE DATABASE `trinityscript` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 2 2 3 GRANT ALL PRIVILEGES ON `scriptdev2` . * TO 'mangos'@'localhost' WITH GRANT OPTION; 4 3 GRANT ALL PRIVILEGES ON `trinityscript` . * TO 'trinity'@'localhost' WITH GRANT OPTION; -
trunk/src/bindings/scripts/sql/scriptdev2_structure.sql
r2 r5 100 100 101 101 102 DROP TABLE IF EXISTS `s d2_db_version`;103 CREATE TABLE `s d2_db_version` (104 `version` varchar(255) NOT NULL default '' COMMENT ' Database version string'102 DROP TABLE IF EXISTS `script_db_version`; 103 CREATE TABLE `script_db_version` ( 104 `version` varchar(255) NOT NULL default '' COMMENT 'Script Database version string' 105 105 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;