summaryrefslogtreecommitdiff
path: root/openerp/addons/base/base.sql
AgeCommit message (Collapse)Author
2016-09-02[REF] openerp: move `openerp` to `odoo`Raphael Collet
2016-08-03[FIX] base: force a symbol on a currencyMartin Trigaux
To avoid scenario as in 11346 where the report expects a currency symbol.
2015-11-27[ADD] ir_model: add boolean field `store` on model `ir.model.fields`Raphael Collet
Make the field reflect the field property `store` in registry.
2015-08-25[FIX] Several fixed due to some of the demo data removalYannick Tivisse
NB : Some tests have been modified. One assert statement in orderpoint_calendar.yml has been modified, but the change is legit has no python method has been modified at all
2015-08-24[IMP] ir_model_fields: replace selection field `select_level` by boolean ↵Raphael Collet
field `indexed`
2015-08-18[ADD] ir_model: add fields `copy` and `related` on `ir.model.fields`Raphael Collet
Also add a constraint on the value of field `related`, and corresponding onchange methods.
2015-08-14[IMP] ir_model: add table and columns fields for many2many fieldsThomas Groutars
The fields are properly reflected for base many2many fields. Moreover, the code has been improved to remove a custom many2many field whose table is still used by another field. Onchange methods have been added: - When name, model and comodel are chosen, propose table and column names. - When table is modified, propose column names if the table is already used by another many2many field.
2015-07-06[IMP] models: improve reflection of fields into `ir.model.fields`Raphael Collet
* add missing columns in base.sql * add missing fields 'help', 'readonly', 'required', 'selectable' in reflection * add field 'help' in `ir.model.fields` views * do not patch registry with translated field string and help upon `ir.model.fields` update
2015-06-15[IMP] ir_model: enable the creation of transient custom modelsThomas Groutars
Rename the field 'osv_memory' on 'ir.model' into 'transient', and make it a regular field instead of a computed one. When instantiating a custom model, use its value to make transient models. This commit alone will make your server crash on an existing database. A small database migration is needed: simply add a boolean column `transient` (with default value false) in table `ir_model`.
2014-09-16[FIX] base: do not drop sql constraints during updateMartin Trigaux
When a module is updated, the sql constraints were checked against postgres pg_get_constraintdef() to see if they have diverged from the one defined in python code. However this check was failing as the syntax returned by pg_get_constraintdef() (e.g. "CHECK ((credit * debit) = 0::numeric)") differs from the one returned by `unify_cons_text` method (e.g. "check(debit*credit = 0")) so the constraints were always dropped and recomputed. This adds a definition column on ir.model.constraint (storing original defintion) to detect changes. The pg_constraint is still inspected to make sure we detect constraint without ir_model_constraint but with postgres constraint defined (e.g. name_uniq defined in base.sql). This changes also the date_update field when the definition changes.
2014-09-04[FIX] Size for icon field of ir_module_module table in base.sqlPedro M. Baeza
2014-04-25[IMP] remove useless table/column creations in base.sql. Let the ORM do it job.Christophe Simonis
[FIX] force creation of workflow used columns. bzr revid: chs@openerp.com-20140425162828-e85aut02ua8c53nv
2013-12-02[MERGE] sync with trunkChristophe Matthieu
bzr revid: chm@openerp.com-20131202150856-fzrfcoa8pmsjutau
2013-11-08[FIX]base: remove unnecessary field sizes from all relateds of ir_model. ↵Denis Ledoux
Size limits prevented some database models customization (like selection fields with selection options longer than 128 chars) bzr revid: dle@openerp.com-20131108130208-srt5gzlxbk890htf
2013-06-25[MERGE] trunkAntony Lesuisse
bzr revid: al@openerp.com-20130625162755-d6552p98m5jiw941
2013-06-19[REF] fields: removed deprecated view_load attribute and removed useless ↵Quentin (OpenERP)
first argument in property fields definition bzr revid: qdp-launchpad@openerp.com-20130619091332-29pisdnyfemn1u3d
2013-04-26[IMP] remove SQL definition of ir.ui.view, schema alterationsXavier Morel
* Formally make model not required * Remove idiotic default values on type and arch * Make type not required (it's a function field!) bzr revid: xmo@openerp.com-20130426145113-cf0t0xx24lk9mtgs
2012-12-17[FIX] orm,registry: properly check m2o FKs during model update + fix some ↵Olivier Dony
models `auto_init`ed multiple times The case where no constraint existed at all was not working, and after fixing it, the ORM started to re-create the same constraints multiple times for some modules. This was for models that are split within a module (such as res.users in base, which is made of several small classes): all the partial models were going through _auto_init instead of only the final one - doing useless extra work. Unfortunately establishing the FK happens before the XML data files are loaded, so a number of FK and NOT NULL constraints failed to apply due to missing tables/records. base.sql had to be extended a bit to cover these cases in a minimalist fashion bzr revid: odo@openerp.com-20121217214645-av9n003yzterhujw
2012-11-22[FIX] lang on res.users is still usedFabien Meghazi
bzr revid: fme@openerp.com-20121122152159-a9lxb4fwn8qkvsvt
2012-11-22[REM] Removed unused fields from base.sqlFabien Meghazi
bzr revid: fme@openerp.com-20121122151425-fr8o1v587vgmnf5f
2012-09-26[IMP] no certificateFabien Pinckaers
bzr revid: fp@tinyerp.com-20120926121536-9836j42ulu8wcir8
2012-08-13[IMP] base.sql: no need to have a 'name' column on res.users I think.Thibault Delavallée
bzr revid: tde@openerp.com-20120813093656-ywab7wjdpc5gwl02
2012-08-10[FIX] base.sql: added a partner_id integer field on res.users, to avoid the ↵Thibault Delavallée
ORM being unable to set a not null constraint on it. bzr revid: tde@openerp.com-20120810140549-w70l7nzwn4kt1oav
2012-08-10[REF] base.sql, web_services: propagated changes in res.users model (lang, ↵Thibault Delavallée
not context_lang anymore; tz, not context_tz. bzr revid: tde@openerp.com-20120810081836-y4f2nsft9g7p4hl6
2012-07-17[Add] Add module summary on db installJigar Amin - OpenERP
bzr revid: jam@tinyerp.com-20120717085028-2jkbf9ymrftkui45
2012-06-20[IMP] uninstall: typosVo Minh Thu
bzr revid: vmt@openerp.com-20120620100705-p9o5kktmj8zkbshm
2012-06-01[IMP] uninstall: use a dedicated table for many2many relationships instead ↵Vo Minh Thu
of overlaoding ir.model.data. bzr revid: vmt@openerp.com-20120601153449-uj2sl7qjzz3s7xnj
2012-05-31[IMP] uninstall: started test module, added new ir_model_constraint table.Vo Minh Thu
bzr revid: vmt@openerp.com-20120531160140-tutjw76tp0u5hipo
2012-04-20[REM] idiotic default value for type field in ir_actions tableXavier Morel
bzr revid: xmo@openerp.com-20120420152220-1yo0rykkj45jfee0
2012-01-30[IMP] manifest: `auto_installable` renamed to `auto_install`.Vo Minh Thu
bzr revid: vmt@openerp.com-20120130095238-x2by4y11joeytipr
2012-01-26[IMP] ir.module.module: change `active` flag toVo Minh Thu
`auto_installable`. An auto-installable module is a module automatically installed by the OpenERP server as soon as its dependencies are satisfied, without explicit user action. bzr revid: vmt@openerp.com-20120126164049-smrcvrojy0b1z6f8
2012-01-07[FIX] base: module sequence number removed from XML data, moved to ↵Olivier Dony
individual module manifests Having the sequence number living outside the module itself causes various problems at initialization when modules are missing (e.g. if creating a database with `base` only). It is also cleaner to have the module sequence in the module manifest, like other module metadata. A corresponding commit in the addons project adds the `sequence` field in the manifest of all modules who have a non-default sequence (the main apps). bzr revid: odo@openerp.com-20120107041745-tik3iu1b2qs4ym85
2011-12-23[MERGE] translations: import using lower-level sql (translations load about ↵Raphael Collet
6 times faster) bzr revid: rco@openerp.com-20111223104824-fup1cjbjni1fsty1
2011-12-22[MERGE] sync with trunkOlivier Dony
bzr revid: odo@openerp.com-20111222102555-bydsozbdu6urkj31
2011-12-08[IMP] ir.module.module: rename is_application to applicationAntony Lesuisse
bzr revid: al@openerp.com-20111208222241-n9raoe1jec4llh26
2011-12-08[IMP] ir.module.module: rename 'core' to 'is_application'Christophe Simonis
bzr revid: chs@openerp.com-20111208145101-oth2k8xuymze7y2l
2011-12-06[IMP] Core features on modules, better views for modulesFabien Pinckaers
bzr revid: fp@tinyerp.com-20111206111531-qdkajwatqzb0dz45
2011-12-01[MERGE] merged trunk.Vo Minh Thu
bzr revid: vmt@openerp.com-20111201153214-0iintvpp7crnr2jc
2011-11-16[MERGE] Implementation of sparse field (to review), by Sebastien Beau, AkretionOlivier Dony
bzr revid: odo@openerp.com-20111116172525-rmri79n9hpf2plwg
2011-09-30[FIX] store the complexity field from the manifest during the database creationStephane Wirtel
bzr revid: stw@openerp.com-20110930095814-4o01upd0krmysbid
2011-09-20[REF] ir_model_field replace the serialisation_field by serialization_field_idsebastien beau
change request in base.sql as a new field is created in ir_model_fields bzr revid: sebastien.beau@akretion.com.br-20110920170707-2wmfs1sg37hgvbl1
2011-06-30[ADD] client actionXavier Morel
bzr revid: xmo@openerp.com-20110630115134-m5tppqs9whmqtqow
2011-06-08ir.translation: select restriction must be an SQL constraintP. Christeas
select fields validate themselves in ORM, through _check_selection_field_value(), which /retrieves/ the .selection list and checks if value to be written is among possible ones. This, however, is very expensive for models that have variable selection lists (eg. ones that require an SQL query). In fact, for ir.translation, the query would be repeat for every single write() to ir.translation. The 'lang' field is actually a reference for res.lang.code (not the .id, sadly), so let SQL implement the constraint for us. bzr revid: xrg@linux.gr-20110608093254-ua66p5co6dc203zs
2011-05-23[FIX] orm: correctly store in db the translate flag:Vo Minh Thu
- added the "translate" column to ir_model_fields in base.sql - modified orm.py to correctly set that column - this is based on a patch by xrg. lp bug: https://launchpad.net/bugs/780584 fixed bzr revid: vmt@openerp.com-20110523132153-njovr5ynt66k8d81
2011-02-07[IMP] openerp python module.Vo Minh Thu
- Some logging code moved from netsvc.py to loglevels.py - Changed imports to use the new openerp module - config and netsvc initialization calls move to openerp-server.py - Moved openerp-server.py outside the old bin directory - Some imports in tools moved inside the methods to break mutual-dependencies bzr revid: vmt@openerp.com-20110207125723-ooee7d7ng5elmkso