mirror of
https://github.com/islehorse/HISP.git
synced 2025-04-05 21:55:42 +13:00
32 lines
1.6 KiB
SQL
Executable file
32 lines
1.6 KiB
SQL
Executable file
## Written by SilicaAndPina,
|
|
## This Script is entered into the Public Domain!
|
|
## HISP v1.0 to v1.1 migration script...
|
|
|
|
# To use this script you must find/replace
|
|
# 'master' to your master db name
|
|
# and 'game1' to your game db name
|
|
CREATE DATABASE IF NOT EXISTS master;
|
|
CREATE TABLE IF NOT EXISTS master.Users(Id INT, Username TEXT(16),Email TEXT(128),Country TEXT(128),SecurityQuestion Text(128),SecurityAnswerHash TEXT(128),Age INT,PassHash TEXT(128), Salt TEXT(128),Gender TEXT(16), Admin TEXT(3), Moderator TEXT(3));
|
|
# Transfer user table to master db
|
|
USE game1;
|
|
INSERT INTO master.Users(SELECT Id,Username,Email,Country,SecurityQuestion,SecurityAnswerHash,Age,PassHash,Salt,Gender,Admin,Moderator FROM Users);
|
|
ALTER TABLE Users DROP COLUMN Email;
|
|
ALTER TABLE Users DROP COLUMN Country;
|
|
ALTER TABLE Users DROP COLUMN SecurityQuestion;
|
|
ALTER TABLE Users DROP COLUMN SecurityAnswerHash;
|
|
ALTER TABLE Users DROP COLUMN Age;
|
|
|
|
# Add new colums
|
|
ALTER TABLE UserExt ADD COLUMN TotalLogins INT;
|
|
UPDATE UserExt SET TotalLogins=0;
|
|
DROP TABLE OnlineUsers; # Server will re-generate the table when next started
|
|
|
|
# Change table sizes
|
|
ALTER TABLE UserExt CHANGE COLUMN ProfilePage ProfilePage TEXT(4000);
|
|
ALTER TABLE UserExt CHANGE COLUMN PrivateNotes PrivateNotes TEXT(65535);
|
|
ALTER TABLE MailBox CHANGE COLUMN Subject Subject TEXT(100);
|
|
ALTER TABLE MailBox CHANGE COLUMN Message Message TEXT(65535);
|
|
ALTER TABLE Horses CHANGE COLUMN description description TEXT(4000);
|
|
ALTER TABLE WildHorse CHANGE COLUMN description description TEXT(4000);
|
|
ALTER TABLE Ranches CHANGE COLUMN title title TEXT(50);
|
|
ALTER TABLE Ranches CHANGE COLUMN description description TEXT(250);
|