| author | Josh <jokajak@gmail.com> | 2011-10-07 13:10:14 (UTC) |
|---|---|---|
| committer | Josh <jokajak@gmail.com> | 2011-10-07 13:10:14 (UTC) |
| commit | 2cab48422287390c36429d3a7ae96e9b5a444c81 (patch) (side-by-side diff) | |
| tree | c7b411357990cef1d4938d2d4b06a54f7863ec13 | |
| parent | 647a8a53917dd15dc81caaeb36c658e18e579ab0 (diff) | |
| download | clipperz-2cab48422287390c36429d3a7ae96e9b5a444c81.zip clipperz-2cab48422287390c36429d3a7ae96e9b5a444c81.tar.gz clipperz-2cab48422287390c36429d3a7ae96e9b5a444c81.tar.bz2 | |
make is so that the records table can be created. drop the default/on update clauses
| -rw-r--r-- | backend/php/src/objects/class.record.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/backend/php/src/objects/class.record.php b/backend/php/src/objects/class.record.php index 37a9702..2ab5c4a 100644 --- a/backend/php/src/objects/class.record.php +++ b/backend/php/src/objects/class.record.php @@ -4,17 +4,17 @@ CREATE TABLE `record` ( `recordid` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL, `reference` VARCHAR(255) NOT NULL, `data` LONGTEXT NOT NULL, `version` VARCHAR(255) NOT NULL, `creation_date` TIMESTAMP NOT NULL, - `update_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `update_date` TIMESTAMP NOT NULL, `access_date` TIMESTAMP NOT NULL, INDEX(`userid`), PRIMARY KEY (`recordid`)) ENGINE=MyISAM; */ /** * <b>record</b> class with integrated CRUD methods. * @author Php Object Generator * @version POG 3.0e / PHP5.1 MYSQL * @see http://www.phpobjectgenerator.com/plog/tutorials/45/pdo-mysql |