diff options
| author | Aris Feryanto <aris_feryanto@yahoo.com> | 2011-08-12 11:49:53 +0400 |
|---|---|---|
| committer | Aris Feryanto <aris_feryanto@yahoo.com> | 2011-08-12 11:49:53 +0400 |
| commit | fe7eadab72e3f318986f36e47749364b2d3077dd (patch) | |
| tree | 5dc5a4f078e6155c201d93a2f03eb6f476056786 /scripts | |
| parent | faa11abaed21b60dcaa3e6438fde7c176f1445ba (diff) | |
Add configuration for maximum tbl_uiprefs records, as suggested by Piotr
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/create_tables.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/scripts/create_tables.sql b/scripts/create_tables.sql index 5db0de4e70..b0a52201fe 100644 --- a/scripts/create_tables.sql +++ b/scripts/create_tables.sql @@ -128,6 +128,7 @@ CREATE TABLE IF NOT EXISTS `pma_table_uiprefs` ( `db_name` varchar(64) NOT NULL, `table_name` varchar(64) NOT NULL, `prefs` text NOT NULL, + `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`username`,`db_name`,`table_name`) ) ENGINE=MyISAM COMMENT='Tables'' UI preferences' |