db-schema

Commit Graph

Author	SHA1	Message	Date
Rene Krenn	df0b55cde7	TT#108500 move 15660 to /diff folder Change-Id: I2f82df4889fa9d8161e53fa6813e6622eff95cbe	4 years ago
Rene Krenn	6d172cda7a	TT#108500 support larger cdr_period_costs amounts Change-Id: I620985780b02c6edb6b9ab605df788dc00877908	4 years ago
Kirill Solomko	c45677bb05	TT#105405 remove column REFERENCES syntax * with MariaDB 10.5 REFERENCES syntax in the CREATE TABLE column definition now creates automatic foreign keys. That causes duplicate foreign keys, one manually defined in the CREATE TABLE/ALTER TABLE statements and one that is automatically created with _ibfk_<int> suffix. Therefore, the REFERENCE syntax in the column definition is removed, as all of those REFERENCEs are covered by the FOREIGN KEY ones. Change-Id: I969a8d3d31d680c0e7f15c1cfb31e8c2abe6eb74	4 years ago
Alexander Lutay	48514d8750	MT#11123 Fix MySQL 5.5.41 error 'No database selected' Change-Id: I50da93909f2bc190bfb98115a03b53a9ee84cf35	10 years ago
Andreas Granig	3d1ddd88b7	Split multi-delete into two separate statements.	12 years ago
Andreas Granig	2a4da063be	Fix wrong alias usage to make mysql 5.5 happy.	12 years ago
Kirill Solomko	73ac403c63	fixed a typo	13 years ago
Kirill Solomko	e47f7b8a67	removed "IDENTIFIED BY" from grants_*.up db_scripts	13 years ago
Michael Prokop	a69511bd1a	drop grants for sipwise user in 0080_grants_dbs.up otherwise installer fails with: \| [...] \| Applying revision script /usr/share/ngcp-db-schema/db_scripts/base/0080_grants_dbs.up: done \| ERROR 1045 (28000): Access denied for user 'sipwise'@'localhost' (using pssword: YES) \| [...] Related to previous fix, addressing https://bugtracker.sipwise.com/view.php?id=2463 Needs review before release! From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Kirill Solomko	eddf40f7d8	renamed .template to .up	13 years ago
Kirill Solomko	849a714d66	fixed INSERT INTO xmlgroups to use predefined id values instead of relying on autoincrement ones	13 years ago
Richard Fuchs	65a6c2c90f	fix modify timestamp	13 years ago
Richard Fuchs	987dbc6c0e	properly fix the typo this time	13 years ago
Richard Fuchs	b7d6773943	fix typo	13 years ago
Richard Fuchs	1d99fd5f53	more fixing of timestamps	13 years ago
Richard Fuchs	30201c3b38	more fixing of timestamps	13 years ago
Richard Fuchs	a638ebf4cb	change the up script, not the down script	13 years ago
Richard Fuchs	f22ddf47ee	fix modify_timestamp to 1970 for voip_preferences in various places - WIP	13 years ago
Richard Fuchs	7221d4fa5b	fix up/down scripts	13 years ago
Richard Fuchs	b839aa8460	fix the fix	13 years ago
Richard Fuchs	85a4741444	fix up/down scripts	13 years ago
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>	13 years ago
Andrew Pogrebennyk	322fe4d5ba	do not use "create table .. like" statement due to the order of operations in the installer the database is already updated to the latest state at the point we run ngcp-update-db-schema this is not what we want, because then not_replicated statements fail: Applying revision script /usr/share/ngcp-db-schema/db_scripts/base/6435_not_replicated.up: ERROR 1060 (42S21) at line 3: Duplicate column name 'time_hires' failed. :(	13 years ago
Michael Prokop	c5b2224ed1	Remove deprecated language_strings.txt Credits to Andrew From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Andrew Pogrebennyk	6edc68ade1	separate replicated and not replicated db rev scripts	13 years ago
Michael Prokop	905dde658f	Renames for not-replicated stuff We settled on the _not_replicated.{up,down} suffix: Acked-by: Daniel Tiefnig Acked-by: Andreas Granig Signed-off-by: Andrew Pogrebennyk	13 years ago
Michael Prokop	6b1c36c2ab	Provide 5670.up as 5670_grants_dbs.template Grant management-- From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Andrew Pogrebennyk	eaf9567013	get rid of legacy file grants_proxies_kamailio - we don't need it, see https://bugtracker.sipwise.com/view.php?id=1071#c5435	13 years ago
Andrew Pogrebennyk	977fa4b377	oops.. fix syntax error	13 years ago
Andrew Pogrebennyk	29f8cede79	add grants for sems_prepaid to base schema files - i really meant to commit all changes in one batch but part of them went to r8162, apparently with wrong commit message; - our grant management really sucks, i just hope that grants have been put into proper shape now without breaking anything.	13 years ago
Andrew Pogrebennyk	177e54e699	add missing grant on billing.billing_zones_history	13 years ago
Andrew Pogrebennyk	cb2463927a	fix default billing profile creation	13 years ago
Andrew Pogrebennyk	0d0b6812d4	rollback r8111	13 years ago
Andrew Pogrebennyk	9e47e08d9d	sync grant scripts with trunk ossbss version - as discussed there is not point in keeping obsolete grants there	13 years ago
Michael Prokop	438572f505	Adjust base script file names Hopefully for the last time.. From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Michael Prokop	32dc161d25	Update 0030_create_kamailio_301.up + 0050_create_accounting.up + provide 5000_fix_billing.up This should bring our fresh installation into sync with upgraded systems. Hopefully. Finally. From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Michael Prokop	376764379b	Sync to svn r3955 to get fresh installation working From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Michael Prokop	5aa0a76c33	Rename 0100_grants_dbs.up + 0110_grants_proxies_kamailio.up to .template We've to deal the PW_ stuff inside the installer (nothing better available yet). TODO: 5670.up From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Michael Prokop	5b4e312741	Drop db_scripts/language_strings and instead provide it as db_scripts/base/language_strings.txt Thanks for the hint, Andrew From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Michael Prokop	ac80f9de59	Drop tmp scripts, not relevant anymore From: Michael Prokop <mprokop@sipwise.com>	13 years ago
Michael Prokop	30ceca8ca7	Initial db-schema package This is broken as hell. You've been warned. From: Michael Prokop <mprokop@sipwise.com>	13 years ago

41 Commits (mr9.5.7)