db-schema

Commit Graph

Author	SHA1	Message	Date
Michael Prokop	dfde6222d5	Use '0' instead of now() for timestamps If --no-data is not used in the mysqldump command line of trunk deployments then we get stuff like that into our svn repository committed: \| > -INSERT INTO `subscriber` VALUES \| (1,'no_such_number','voip.sipwise.local','499187eef57cdee845f8e98bf81c04b4','','1cece14d3af643f05273228e790ce1b7','90d1398 \| 204f968fc9bca32689d933b90',NULL,'9bcb88b6-541a-43da-8fdc-816f5557ff93','','2012-09-03 \| 16:02:41'),(2,'nagios','voip.sipwise.local','nagios4Sipwise!','','e5290263a1b27f90c5630eecc7319715','aba8e5f08f6fc0dd1e18e \| 9e27550b8f0',NULL,'ac1697cf-6933-45ef-9abf-b1278054ded0','','2012-09-03 16:02:41'); \| > +INSERT INTO `subscriber` VALUES \| (1,'no_such_number','voip.sipwise.local','3ce39530696080435b2625be8de48786','','d2635d573e32f8e49bea5b8244d6f54f','457794a \| 1beffd43c1cbe04e3cb5c0229',NULL,'9bcb88b6-541a-43da-8fdc-816f5557ff93','','2012-09-03 \| 16:24:36'),(2,'nagios','voip.sipwise.local','nagios4Sipwise!','','e5290263a1b27f90c5630eecc7319715','aba8e5f08f6fc0dd1e18e \| 9e27550b8f0',NULL,'ac1697cf-6933-45ef-9abf-b1278054ded0','','2012-09-03 16:24:36'); \| [...] To avoid those moving timestamp changes hit our svn repos we replace all function calls to "now()" with just '0'. Also see discussion on development@sipwise.com with thread subject "[VCS/DEV] r10942 - ngcp/db-schema/trunk/schema" Acked-by: Daniel Tiefnig Acked-by: Jon Bonilla From: Michael Prokop <mprokop@sipwise.com>	14 years ago
Richard Fuchs	f57d33b1c2	add timestamp column to prepaid_costs table	14 years ago

Author

SHA1

Message

Date

Michael Prokop

dfde6222d5

Use '0' instead of now() for timestamps

If --no-data is *not* used in the mysqldump command line of
trunk deployments then we get stuff like that into our svn
repository committed:

| > -INSERT INTO `subscriber` VALUES
| (1,'no_such_number','voip.sipwise.local','499187eef57cdee845f8e98bf81c04b4','','1cece14d3af643f05273228e790ce1b7','90d1398
| 204f968fc9bca32689d933b90',NULL,'9bcb88b6-541a-43da-8fdc-816f5557ff93','','2012-09-03
| 16:02:41'),(2,'nagios','voip.sipwise.local','nagios4Sipwise!','','e5290263a1b27f90c5630eecc7319715','aba8e5f08f6fc0dd1e18e
| 9e27550b8f0',NULL,'ac1697cf-6933-45ef-9abf-b1278054ded0','','2012-09-03 16:02:41');
| > +INSERT INTO `subscriber` VALUES
| (1,'no_such_number','voip.sipwise.local','3ce39530696080435b2625be8de48786','','d2635d573e32f8e49bea5b8244d6f54f','457794a
| 1beffd43c1cbe04e3cb5c0229',NULL,'9bcb88b6-541a-43da-8fdc-816f5557ff93','','2012-09-03
| 16:24:36'),(2,'nagios','voip.sipwise.local','nagios4Sipwise!','','e5290263a1b27f90c5630eecc7319715','aba8e5f08f6fc0dd1e18e
| 9e27550b8f0',NULL,'ac1697cf-6933-45ef-9abf-b1278054ded0','','2012-09-03 16:24:36');
| [...]

To avoid those moving timestamp changes hit our svn repos
we replace all function calls to "now()" with just '0'.

Also see discussion on development@sipwise.com with thread
subject "[VCS/DEV] r10942 - ngcp/db-schema/trunk/schema"

Acked-by: Daniel Tiefnig
Acked-by: Jon Bonilla

From: Michael Prokop <mprokop@sipwise.com>

Richard Fuchs

f57d33b1c2

add timestamp column to prepaid_costs table

2 Commits (mr10.2.1)