developer.jelix.org is not used any more and exists only for history. Post new tickets on the Github account.
developer.jelix.org n'est plus utilisée, et existe uniquement pour son historique. Postez les nouveaux tickets sur le compte github.

Opened 7 years ago

Closed 7 years ago

#1279 closed bug (fixed)

install_jacl2.schema.sqlite.sql - création incomplète et prefix incorrect

Reported by: reluc Owned by: laurentj
Priority: normal Milestone: Jelix 1.2.2
Component: module:jacl2db Version: 1.2.1
Severity: normal Keywords: sqlite, jacl2db
Cc: Blocked By:
Blocking: Documentation needed: no
Hosting Provider: Php version:

Description

Suite au #1259 le prefix des tables est devenu :

%%PREFIX%%%

Il y a un % en trop, le bon prefix devrait être :

%%PREFIX%%

De plus une il manque la création de la table jacl2_group qui pourrait être du genre :

CREATE TABLE %%PREFIX%%jacl2_group (
    id_aclgrp int(11) NOT NULL DEFAULT '0',
    name varchar(150) NOT NULL DEFAULT '',
    code varchar(30),
    grouptype int NOT NULL,
    ownerlogin varchar(50),
    PRIMARY KEY (id_aclgrp)
);

Attachments (1)

install_jacl2.schema.sqlite.sql (758 bytes) - added by reluc 7 years ago.
schema sqlite testé et validé

Download all attachments as: .zip

Change History (4)

Changed 7 years ago by reluc

schema sqlite testé et validé

comment:1 Changed 7 years ago by laurentj

  • Resolution set to fixed
  • review set to review+
  • Status changed from new to closed

comment:2 Changed 7 years ago by reluc

  • Resolution fixed deleted
  • Status changed from closed to reopened

Après utilisation, le fichier de correction est légèrement faux.

Il manque le type INTEGER devant AUTOINCRMENt de la colonne id de la table jacl2_group.

comment:3 Changed 7 years ago by laurentj

  • Resolution set to fixed
  • Status changed from reopened to closed
Note: See TracTickets for help on using tickets.