Project

General

Profile

Actions

Architecture #5357

closed

Architecture #5893: Normalize our SQL definition file

Normalize our SQL definition file

Added by François ARMAND over 10 years ago. Updated over 9 years ago.

Status:
Released
Priority:
2
Category:
Architecture - Code maintenance
Target version:
Effort required:
Name check:
Fix check:
Regression:

Description

The file we are using to define our SQL tables, reportsSchema.sql, is a mess. There is no convention at all, and I'm not event speaking about naming convention, but simple indenting/casing one.

Moreover, tables are sorted by the time they where added in Rudder, which makes no sens: they have to be sorted by goal, with comments for each section, and if possible from the most important section toward the least one.

This ticket is ONLY for formating the file, no semantic nor naming change.


Subtasks 1 (0 open1 closed)

Bug #5510: The current reportsSchema.sql file lead to error and the normalisation is not completeReleasedNicolas CHARLES2014-09-11Actions

Related issues 1 (0 open1 closed)

Related to Rudder - Architecture #5515: Normalize SQL object namesRejectedFrançois ARMANDActions
Actions #1

Updated by François ARMAND over 10 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from François ARMAND to Nicolas CHARLES
  • Pull Request set to https://github.com/Normation/rudder/pull/595
Actions #2

Updated by François ARMAND over 10 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
Actions #4

Updated by Matthieu CERDA about 10 years ago

  • Target version changed from 140 to 3.0.0~beta1
Actions #5

Updated by Vincent MEMBRÉ almost 10 years ago

  • Parent task set to #5893
Actions #6

Updated by Vincent MEMBRÉ almost 10 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 3.0.0~beta1 which was release on 01/12/2014.

Actions #7

Updated by Benoît PECCATTE over 9 years ago

  • Tracker changed from Enhancement to Architecture
Actions

Also available in: Atom PDF