Leginon

Here is the sql script to update the previous "LaunchedApplicationData" table schema.

alter table LaunchedApplicationData modify `DEF_timestamp` timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP;

I will write a script to do the update.

Thanks.

Eric

To test:
Don't use the newest leginonDBSchema.xml, (use the one does not have "null="NOT NULL" " on line 611) to create the default database.

From mysql command, type "show create table leginondb.LaunchedApplicationData"
you show see as follow:

LaunchedApplicationData | CREATE TABLE `LaunchedApplicationData` (
`DEF_id` int(16) NOT NULL AUTO_INCREMENT,
`DEF_timestamp` timestamp NULL DEFAULT NULL,
`REF|ApplicationData|application` int(20) DEFAULT NULL,
`SEQ|launchers` text,
`REF|SessionData|session` int(20) DEFAULT NULL,
PRIMARY KEY (`DEF_id`),
KEY `REF|SessionData|session` (`REF|SessionData|session`),
KEY `REF|ApplicationData|application` (`REF|ApplicationData|application`),
KEY `DEF_timestamp` (`DEF_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

after run this python script you should see as follow:

LaunchedApplicationData | CREATE TABLE `LaunchedApplicationData` (
`DEF_id` int(16) NOT NULL AUTO_INCREMENT,
`DEF_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`REF|ApplicationData|application` int(20) DEFAULT NULL,
`SEQ|launchers` text,
`REF|SessionData|session` int(20) DEFAULT NULL,
PRIMARY KEY (`DEF_id`),
KEY `REF|SessionData|session` (`REF|SessionData|session`),
KEY `REF|ApplicationData|application` (`REF|ApplicationData|application`),
KEY `DEF_timestamp` (`DEF_timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1

merge to branch 2.1 in r14911

Rename dbschema/leginonDBupdate-14897.py to schema-r14891,py to be consistent with other schema update scripts so that we can search them easily. r15106 did this but noticed that r14897 is not where the xml file was committed. r15096 corrected that.