George Notaras avatar George Notaras committed 3499563

Added custom MySQL statements that are impossible to execute using the Django API.

Comments (0)

Files changed (6)

src/powerdns_manager/sql/cryptokey.mysql.sql

+-- Set engine to INNODB.
+-- Alse see: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
+ALTER TABLE cryptokeys ENGINE=INNODB;

src/powerdns_manager/sql/domain.mysql.sql

+-- Set engine to INNODB.
+-- Alse see: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
+ALTER TABLE domains ENGINE=INNODB;

src/powerdns_manager/sql/domainmetadata.mysql.sql

+-- Set engine to INNODB.
+-- Alse see: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
+ALTER TABLE domainmetadata ENGINE=INNODB;

src/powerdns_manager/sql/record.mysql.sql

+-- Set engine to INNODB.
+-- Alse see: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
+ALTER TABLE records ENGINE=INNODB;
+
+-- Create index that is impossible to create otherwise
+-- See: http://stackoverflow.com/questions/1578195/django-create-index-non-unique-multiple-column
+CREATE INDEX nametype_index ON records(name,type);

src/powerdns_manager/sql/supermaster.mysql.sql

+-- Set engine to INNODB.
+-- Alse see: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
+ALTER TABLE supermasters ENGINE=INNODB;

src/powerdns_manager/sql/tsigkey.mysql.sql

+-- Set engine to INNODB.
+-- Alse see: https://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables
+ALTER TABLE tsigkeys ENGINE=INNODB;
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.