-- de l'install et tous les sigles '--' sont supprims.
--
insert into llx_cond_reglement(rowid, code, sortorder, actif, libelle, libelle_facture, fdm, nbjour) values (1,'RECEP',    ...  
insert into llx_cond_reglement(rowid, code, sortorder, actif, libelle, libelle_facture, fdm, nbjour) values (2,'30D',      ...  
insert into llx_cond_reglement(rowid, code, sortorder, actif, libelle, libelle_facture, fdm, nbjour) values (3,'30DENDMONTH...  

INSERT INTO llx_c_methode_commande_fournisseur (rowid, code, libelle, active) VALUES (4, 'OrderByPhone', 'Tlphone', 1);
INSERT INTO llx_c_methode_commande_fournisseur (rowid, code, libelle, active) VALUES (5, 'OrderByWWW',   'En ligne',  1);
insert into llx_cond_reglement(rowid, code, sortorder, active, libelle, libelle_facture, fdm, nbjour) values (1,'RECEP',   ...  
insert into llx_cond_reglement(rowid, code, sortorder, active, libelle, libelle_facture, fdm, nbjour) values (2,'30D',     ...  
insert into llx_cond_reglement(rowid, code, sortorder, active, libelle, libelle_facture, fdm, nbjour) values (3,'30DENDMONT...  

INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  

INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  

INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  

     linktitle text,
     image character varying,
     sortorder integer
);
ALTER TABLE ONLY menulinks

   "lu_option_val" varchar(10) NOT NULL,
   "lu_option_note" text,
   "lu_sortorder" integer NOT NULL,
   CONSTRAINT "lu_pk" PRIMARY KEY ("lu_id")
);

# ANSWERS TABLE
#
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('172', 'R1', 'Red', 'N', '00000');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('172', 'R2', 'Green', 'N', '00001');
INSERT INTO answers (`qid`, `code`, `answer`, `default_value`, `sortorder`) VALUES ('172', 'R3', 'Blue', 'N', '00002');

ALTER TABLE `notes` ADD COLUMN `repeating` SMALLINT UNSIGNED NOT NULL DEFAULT 0, ADD COLUMN `repeattype` ENUM('Daily','Week...  
UPDATE `menu` SET `link`='javascript:menu.showHelp()' WHERE `link`='javascript:showHelp()';
UPDATE tabledefs SET defaultwhereclause = 'notes.type=\'EV\' AND notes.createdby = {{$_SESSION[\'userinfo\'][\'id\']}} AND ...  
DELETE FROM tablecolumns WHERE tabledefid=9 or tabledefid=10 or tabledefid = 11 or tabledefid = 12 OR tabledefid = 16 OR ta...  
INSERT INTO `tablecolumns` (`tabledefid`, `name`, `column`, `align`, `footerquery`, `displayorder`, `sortorder`, `wrap`, `s...  

     @ContainerID as int = null,
     @PortletID as int = null,
     @SortOrder as int
)
as

 * Section
 */
insert into [Section] (ParentSectionID, CommunityID, [Name], SortOrder, ModuleID)
     values (0, 1, 'Home', 0, '8B61FD65-C060-46f2-AC29-5A4669D010AC')
insert into [Section] (ParentSectionID, CommunityID, [Name], Description, SortOrder, ModuleID)

CREATE VIEW assignment_question_view
(pq_partid, pq_questionid, pq_sortorder, pq_points, pq_label, pq_createdby, pq_createddate,
pq_lastmodifiedby, pq_lastmodifieddate, q_questionid, q_text, q_description, q_rationale,
q_typeid, q_audionumtrys, q_audioduration, q_createdby, q_createddate, q_lastmodifiedby,

CREATE VIEW "assignment_part_view" (AP_ASSIGNMENTID, AP_PARTID, AP_SORTORDER, AP_LABEL, AP_CREATEDBY, AP_CREATEDDATE, AP_LA...  
assignment_part.partid,
assignment_part.sortorder,

   SurveyQuestion varchar(255),
   QuestionGroupID int,
   SortOrder int,
   _ModDate datetime not null,
   _ModBy int unsigned not null default 0,

   DirectionTitle varchar(128),
   Direction text,
   SortOrder int,
   _ModDate datetime not null,
   _ModBy int unsigned not null default 0,

   JobTaskID int unsigned auto_increment not null,
   JobAnalysisID int,
   SortOrder int,
   TaskID int,
   _ModDate datetime not null,

   CodeID int not null,
   CodeTypeID int not null,
   SortOrder int,
   Value varchar(25),
   Description varchar(128),

   DisplayRows int,
   PageColumn int,
   SortOrder int,
   _ModDate datetime not null,
   _ModBy int unsigned not null default 0,

   DashboardItemID int unsigned not null,
   Name varchar(30),
   SortOrder int,
   _ModDate datetime not null,
   _ModBy int unsigned not null default 0,

   SurveyID int not null,
   Name varchar(50),
   SortOrder int,
   _ModDate datetime not null,
   _ModBy int unsigned not null default 0,

   DashboardItemID int unsigned not null,
   Name varchar(30),
   SortOrder int,
   _ModDate datetime not null,
   _ModBy int unsigned not null default 0,

   ModuleID varchar(5) not null,
   ChartName varchar(10) not null,
   SortOrder int,
   ConditionPhrases text,
   _ModDate datetime not null,

[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProgId] [int] NULL,
[SortOrder] [int] NULL
)
GO

      ,[Type]
      ,[Title]
      ,[SortOrder]
      ,[Created]
      ,[Updated]

#     description varchar(4000),
#     url varchar(256) NOT NULL,
#     sortorder NUMERIC,
#     status numeric(2) NOT NULL,
#     createdby NUMERIC NOT NULL,