diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-09-02 21:07:24 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-09-02 21:07:24 -0700 |
| commit | 669e1111187d1d1888358d833c62b5445a2b360b (patch) | |
| tree | 993089b1e473d74a8e4bf0154a8f278988052b0d /install/schema_mysql.sql | |
| parent | 360fda15e9be17cb9ae0638fc0c76a5642b03223 (diff) | |
| download | volse-hubzilla-669e1111187d1d1888358d833c62b5445a2b360b.tar.gz volse-hubzilla-669e1111187d1d1888358d833c62b5445a2b360b.tar.bz2 volse-hubzilla-669e1111187d1d1888358d833c62b5445a2b360b.zip | |
add timestamps for syncing apps
Diffstat (limited to 'install/schema_mysql.sql')
| -rw-r--r-- | install/schema_mysql.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index d7d44a0a6..1793f89c2 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -108,6 +108,8 @@ CREATE TABLE IF NOT EXISTS `app` ( `app_price` char(255) NOT NULL DEFAULT '', `app_page` char(255) NOT NULL DEFAULT '', `app_requires` char(255) NOT NULL DEFAULT '', + `app_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `app_edited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `app_id` (`app_id`), KEY `app_name` (`app_name`), @@ -115,7 +117,9 @@ CREATE TABLE IF NOT EXISTS `app` ( KEY `app_photo` (`app_photo`), KEY `app_version` (`app_version`), KEY `app_channel` (`app_channel`), - KEY `app_price` (`app_price`) + KEY `app_price` (`app_price`), + KEY `app_created` (`app_created`), + KEY `app_edited` (`app_edited`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `attach` ( |