File: update_db_from_5.23_to_5.24.sql.in

package info (click to toggle)
tango 10.1.0%2Bdfsg1-1~exp1
  • links: PTS, VCS
  • area: main
  • in suites: experimental
  • size: 88,780 kB
  • sloc: cpp: 213,413; sh: 1,641; python: 1,264; javascript: 472; perl: 467; xml: 407; makefile: 294; java: 260; sql: 72
file content (11 lines) | stat: -rw-r--r-- 899 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
 
# vim: filetype=mysql:

USE @TANGO_DB_NAME@;

ALTER TABLE property_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE property_device_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE property_class_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE property_attribute_class_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE property_attribute_device_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE property_pipe_class_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
ALTER TABLE property_pipe_device_hist MODIFY date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;