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 @@ -1,60 +1,60 @@ <?php /* This SQL query will create the table to store your object. 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 * @copyright Free for personal & commercial use. (Offered under the BSD license) * @link http://www.phpobjectgenerator.com/?language=php5.1&wrapper=pdo&pdoDriver=mysql&objectName=record&attributeList=array+%28%0A++0+%3D%3E+%27user%27%2C%0A++1+%3D%3E+%27recordversion%27%2C%0A++2+%3D%3E+%27reference%27%2C%0A++3+%3D%3E+%27data%27%2C%0A++4+%3D%3E+%27version%27%2C%0A++5+%3D%3E+%27creation_date%27%2C%0A++6+%3D%3E+%27update_date%27%2C%0A++7+%3D%3E+%27access_date%27%2C%0A%29&typeList=array%2B%2528%250A%2B%2B0%2B%253D%253E%2B%2527BELONGSTO%2527%252C%250A%2B%2B1%2B%253D%253E%2B%2527HASMANY%2527%252C%250A%2B%2B2%2B%253D%253E%2B%2527VARCHAR%2528255%2529%2527%252C%250A%2B%2B3%2B%253D%253E%2B%2527LONGTEXT%2527%252C%250A%2B%2B4%2B%253D%253E%2B%2527VARCHAR%2528255%2529%2527%252C%250A%2B%2B5%2B%253D%253E%2B%2527TIMESTAMP%2527%252C%250A%2B%2B6%2B%253D%253E%2B%2527TIMESTAMP%2527%252C%250A%2B%2B7%2B%253D%253E%2B%2527TIMESTAMP%2527%252C%250A%2529 */ include_once('class.pog_base.php'); class record extends POG_Base { public $recordId = ''; /** * @var INT(11) */ public $userId; /** * @var private array of recordversion objects */ private $_recordversionList = array(); /** * @var VARCHAR(255) */ public $reference; /** * @var LONGTEXT */ public $data; /** * @var VARCHAR(255) */ public $version; /** * @var TIMESTAMP */ public $creation_date; /** * @var TIMESTAMP |