diff options
| author | friendica <info@friendica.com> | 2012-08-26 23:05:00 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-08-26 23:05:00 -0700 |
| commit | 5ff6e9348b41bc87b03bafc4d9df73b383af074e (patch) | |
| tree | c26b1b26cd38f7ec78e83905266053618a3e1db4 /convert_innodb.sql | |
| parent | f0e299a97a8c46fd66bbc47e5b84d4b76d763154 (diff) | |
| download | volse-hubzilla-5ff6e9348b41bc87b03bafc4d9df73b383af074e.tar.gz volse-hubzilla-5ff6e9348b41bc87b03bafc4d9df73b383af074e.tar.bz2 volse-hubzilla-5ff6e9348b41bc87b03bafc4d9df73b383af074e.zip | |
a few minor changes
Diffstat (limited to 'convert_innodb.sql')
| -rw-r--r-- | convert_innodb.sql | 19 |
1 files changed, 0 insertions, 19 deletions
diff --git a/convert_innodb.sql b/convert_innodb.sql deleted file mode 100644 index 9eeb67fe8..000000000 --- a/convert_innodb.sql +++ /dev/null @@ -1,19 +0,0 @@ - - -ALTER TABLE `profile` DROP INDEX `pub_keywords` ; -ALTER TABLE `profile` DROP INDEX `prv_keywords` ; - -ALTER TABLE `item` DROP INDEX `title` ; -ALTER TABLE `item` DROP INDEX `body` ; -ALTER TABLE `item` DROP INDEX `allow_cid` ; -ALTER TABLE `item` DROP INDEX `allow_gid` ; -ALTER TABLE `item` DROP INDEX `deny_cid` ; -ALTER TABLE `item` DROP INDEX `deny_gid` ; -ALTER TABLE `item` DROP INDEX `tag` ; -ALTER TABLE `item` DROP INDEX `file` ; - - -SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=InnoDB;') -FROM information_schema.tables -WHERE engine = 'MyISAM'; - |