Updated How to Contribute (markdown) authored by SG's avatar SG
...@@ -40,7 +40,7 @@ Naming Convention: `Vxx__some-keywords.sql` ...@@ -40,7 +40,7 @@ Naming Convention: `Vxx__some-keywords.sql`
A [pull request](https://github.com/FAForever/db/issues?q=is%3Apr+is%3Aclosed) typically contains one migration. The maintainer may change your filename, mostly the version. A [pull request](https://github.com/FAForever/db/issues?q=is%3Apr+is%3Aclosed) typically contains one migration. The maintainer may change your filename, mostly the version.
### Tipps to get your PR approved ### Tipps to get your PR approved
* Nearly every table should have a `create_time` and `update_time` columns. * Nearly every table should have a `create_time` and `update_time` column.
```sql ```sql
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
... ...
......