GO
਍ഀഀ
CREATE TABLE [dbo].[tblCaseTypes] (
਍ऀ嬀䌀愀猀攀吀礀瀀攀倀䬀崀 嬀椀渀琀崀 䤀䐀䔀一吀䤀吀夀 ⠀㄀Ⰰ ㄀⤀ 一伀吀 一唀䰀䰀 Ⰰഀഀ
     [CaseTypeName] [nvarchar] (32) ,

*/
INSERT INTO tblPermissions (PermByte, PermLabel, PermDesc)
     VALUES (32, 'PERM_CREATE_OWN', 'Create Rights for Own Cases')
GO
INSERT INTO tblPermissions (PermByte, PermLabel, PermDesc)

-- 
DROP TABLE IF EXISTS `ast_conf_rooms`;
CREATE TABLE IF NOT EXISTS `ast_conf_rooms` (
  `confId` int(8) NOT NULL auto_increment,
  `confNumber` varchar(10) NOT NULL default '',

drop database usenet;
create database usenet;
connect usenet;
create table subjects

-- jforum_banlist
--
CREATE SEQUENCE jforum_banlist_seq
     INCREMENT BY 1
    START WITH 1 MAXVALUE 2.0E9 MINVALUE 1 NOCYCLE

 * adapted to Jwma 0.9.7 by Leonard Sitongia
 */
/* Drop and create the jwma user
 * Note that the password _SHOULD_ be reset here,
 * and that the user will be granted all rights

-- Product
--
insert into llx_const(name,value,type,visible,note) values('PRODUCT_SHOW_WHEN_CREATE','0','yesno',1,'Add products list in f...  
--
-- Descriptif des plans comptables FR PCG99-ABREGE

CREATE UNIQUE INDEX I1_Counters ON Counters(name) ;

create sequence seq_email_id;
create table email
(

create sequence seq_email_id;
create table email
(

create sequence seq_email_type_id;
create table email_type
(

create sequence seq_address_id;
create table address
(

-- $CVSHeader$
CREATE DATABASE /*! IF NOT EXISTS */ adodb_sessions;
USE adodb_sessions;
DROP TABLE /*! IF EXISTS */ sessions;

Create table SHKUserTable
(
userid  NVARCHAR (100)  NOT NULL     ,

Create table SHKCounters
(
name  NVARCHAR (100)  NOT NULL     ,

Create table SHKXPDLParticipantPackage
(
PACKAGE_ID  NVARCHAR (90)  NOT NULL     ,

-- Table structure for table 'jforum_banlist'
--
CREATE SEQUENCE jforum_banlist_seq;
CREATE TABLE jforum_banlist (
  banlist_id INTEGER NOT NULL DEFAULT NEXTVAL('jforum_banlist_seq'),

Create table SHKXPDLS
(
XPDLId  NVARCHAR (90)  NOT NULL     ,

 * version: 1.1 (03/11/2002)
 */
/* Drop and create the jwma user
 * Note that the password _SHOULD_ be reset here,
 * and that the user will be granted all rights

Create table SHKProcessDefinitions
(
Name  VARCHAR (200)  NOT NULL     ,

Create table SHKProcessStateEventAudits
(
KeyValue  NVARCHAR (30)  NOT NULL     ,

-- $Source: /cvsroot/dolibarr/dolibarr/pgsql/tables/llx_paiement_facture.sql,v $
-- ===================================================================
create table llx_paiement_facture
(
  rowid SERIAL PRIMARY KEY,

--
-- ============================================================================
create table llx_user_alert
(
  rowid SERIAL PRIMARY KEY,

--
-- =============================================================================
create table llx_bank_account
(
  rowid SERIAL PRIMARY KEY,

INSERT INTO jforum_roles (role_id, group_id, name) VALUES (2, 1, 'perm_karma_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (3, 1, 'perm_anonymous_post');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (4, 1, 'perm_create_poll');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (5, 1, 'perm_bookmarks_enabled');
INSERT INTO jforum_roles (role_id, group_id, name) VALUES (6, 1, 'perm_attachments_download');