Bureaucrats, emailconfirmed, Administrators
825
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
→DDL file format
| Line 144: | Line 144: | ||
<source lang="sql"> | <source lang="sql"> | ||
-- =========================================================================== | -- =========================================================================== | ||
-- Copyright (C) | -- Copyright (C) 2013 Author <email@author.com> | ||
-- | -- | ||
-- This program is free software; you can redistribute it and/or modify | -- This program is free software; you can redistribute it and/or modify | ||
-- it under the terms of the GNU General Public License as published by | -- it under the terms of the GNU General Public License as published by | ||
-- the Free Software Foundation; either version | -- the Free Software Foundation; either version 3 of the License, or | ||
-- (at your option) any later version. | -- (at your option) any later version. | ||
-- | -- | ||
| Line 162: | Line 162: | ||
create table llx_mytable | create table llx_mytable | ||
( | ( | ||
rowid integer AUTO_INCREMENT PRIMARY KEY, | rowid integer NOT NULL AUTO_INCREMENT PRIMARY KEY, | ||
ref varchar(30) NOT NULL, -- object reference number | |||
entity integer DEFAULT 1 NOT NULL, -- multi company id | |||
ref_ext varchar(255),-- reference into an external system (not used by dolibarr) | |||
ref_int varchar(255),-- reference into an internal system (used by dolibarr) | |||
field_one integer, | field_one integer, | ||
field_two integer NOT NULL, | field_two integer NOT NULL, | ||
fk_field integer, | fk_field integer, | ||
field_date datetime, | field_date datetime, | ||
tms | datec datetime NOT NULL default CURRENT_TIMESTAMP, -- creation datetime | ||
tms timestamp NOT NULL default CURRENT_TIMESTAMP, -- update time stamp | |||
fk_user_author integer NOT NULL, -- Author foreign key of llx_user | |||
fk_user_mod integer NOT NULL -- Last updater foreign key of llx_user | |||
)type=innodb; | )type=innodb; | ||
</source> | </source> | ||