31,016
edits
| Line 130: | Line 130: | ||
Those files must be stored into directory '''install/mysql/tables''' for all standard files or '''mymodule/tables''' for tables provided by an external module. | Those files must be stored into directory '''install/mysql/tables''' for all standard files or '''mymodule/tables''' for tables provided by an external module. | ||
Example '''file of table llx_mytable.sql''': | |||
<source lang="sql"> | <source lang="sql"> | ||
| Line 149: | Line 147: | ||
-- | -- | ||
-- You should have received a copy of the GNU General Public License | -- You should have received a copy of the GNU General Public License | ||
-- along with this program | -- along with this program. If not, see <http://www.gnu.org/licenses/>. | ||
-- =========================================================================== | -- =========================================================================== | ||
| Line 166: | Line 161: | ||
</source> | </source> | ||
Example '''file for keys/indexs on llx_mytable.key.sql''': | |||
<source lang="sql"> | <source lang="sql"> | ||
| Line 183: | Line 178: | ||
-- | -- | ||
-- You should have received a copy of the GNU General Public License | -- You should have received a copy of the GNU General Public License | ||
-- along with this program | -- along with this program. If not, see <http://www.gnu.org/licenses/>. | ||
-- =========================================================================== | -- =========================================================================== | ||
ALTER TABLE llx_matable ADD UNIQUE uk_matable_field(field_one, field_two); | ALTER TABLE llx_matable ADD UNIQUE uk_matable_field(field_one, field_two); | ||