diff options
| author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-15 19:18:26 -0600 |
|---|---|---|
| committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-15 19:18:26 -0600 |
| commit | f47e51d6dea9d59a36a6babf1f4033104c93a53d (patch) | |
| tree | 8987bce353d678fcf3bd1d57cef27fe4d2a2ce87 /phpBB/develop/create_schema_files.php | |
| parent | c6f138ff12f015543f92d07fb5c93c083a246bab (diff) | |
| download | forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.gz forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.bz2 forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.xz forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.zip | |
[ticket/11103] Move is_enabled to a separate table for better performance
PHPBB3-11103
Diffstat (limited to 'phpBB/develop/create_schema_files.php')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index 87204f9e26..10306c9124 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -1295,6 +1295,14 @@ function get_schema_struct() ), ); + $schema_data['phpbb_notification_types'] = array( + 'COLUMNS' => array( + 'notification_type' => array('VCHAR:255', ''), + 'notification_type_enabled' => array('BOOL', 1), + ), + 'PRIMARY_KEY' => array('notification_type', 'notification_type_enabled'), + ); + $schema_data['phpbb_notifications'] = array( 'COLUMNS' => array( 'notification_id' => array('UINT', NULL, 'auto_increment'), @@ -1303,7 +1311,6 @@ function get_schema_struct() 'item_parent_id' => array('UINT', 0), 'user_id' => array('UINT', 0), 'unread' => array('BOOL', 1), - 'is_enabled' => array('BOOL', 1), 'time' => array('TIMESTAMP', 1), 'data' => array('TEXT_UNI', ''), ), |