-- GENERATOR

DROP TABLE IF EXISTS GENERATOR;

CREATE TABLE GENERATOR (
	GENERATOR_KEY VARCHAR(50) NOT NULL,
	GENERATOR_VALUE INT NOT NULL DEFAULT 0,
	PRIMARY KEY (GENERATOR_KEY)
);

INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('APPLICATION');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('ATTACHMENT');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('AUTHOR');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('COMMUNITY');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('COMMUNITY_INFORMATION');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('FEED');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('INFORMATION');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('INFORMATION_TAG');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('INFORMATION_TYPE');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('LOG');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('PARTICIPATION');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('PERSON');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('PERSON_COMMUNITY');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('PERSON_INFORMATION');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('PERSON_USER_GROUP');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('TAG');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('USER_GROUP');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('USER_GROUP_COMMUNITY');
INSERT INTO GENERATOR (GENERATOR_KEY) VALUES ('USER_GROUP_INFORMATION');


-- MIME_TYPE

DROP TABLE IF EXISTS MIME_TYPE;

CREATE TABLE MIME_TYPE (
	MIME_TYPE_NAME VARCHAR(50) NOT NULL,
	ICON VARCHAR(50),
	PRIMARY KEY (MIME_TYPE_NAME)
);

INSERT INTO MIME_TYPE VALUES ('text/plain', 'text.png');


-- EXTENSION

DROP TABLE IF EXISTS EXTENSION;

CREATE TABLE EXTENSION (
	EXTENSION VARCHAR(50) NOT NULL,
	MIME_TYPE_NAME VARCHAR(50) NOT NULL,
	PRIMARY KEY (EXTENSION),
	FOREIGN KEY (MIME_TYPE_NAME) REFERENCES MIME_TYPE (MIME_TYPE_NAME)
);

INSERT INTO EXTENSION VALUES ('txt', 'text/plain');


-- COUNTRY

DROP TABLE IF EXISTS COUNTRY;

CREATE TABLE COUNTRY (
	COUNTRY_CODE CHAR(2) NOT NULL,
	NAME VARCHAR(50) NOT NULL,
	FLAGFILE VARCHAR(255),
	PRIMARY KEY (COUNTRY_CODE)
);

-- PERSON

DROP TABLE IF EXISTS PERSON;

CREATE TABLE PERSON (
	PERSON_ID INT NOT NULL,
	PERSON_KEY VARCHAR(100),
	E_MAIL VARCHAR(100),
	SURNAME VARCHAR(50),
	GIVEN_NAME VARCHAR(50),
	SCREEN_NAME VARCHAR(50),
	PICTURE_URL VARCHAR(100),
	HOMEPAGE VARCHAR(100),
	COUNTRY_CODE CHAR(2),
	CQ DOUBLE,
	PQ DOUBLE,
	PEQ DOUBLE,
	CREATED_ON DATETIME NOT NULL,
	UPDATED_ON DATETIME NOT NULL,
	PRIMARY KEY (PERSON_ID),
	FOREIGN KEY (COUNTRY_CODE) REFERENCES COUNTRY (COUNTRY_CODE)
);

CREATE INDEX I_PERSON_1 ON PERSON (PERSON_KEY);
CREATE INDEX I_PERSON_2 ON PERSON (E_MAIL);

DROP TABLE IF EXISTS INFORMATION_TYPE;
CREATE TABLE INFORMATION_TYPE(
    ID          INT NOT NULL,
    DESCRIPTION VARCHAR(255) NOT NULL,
    PRIMARY KEY (ID)
);

CREATE INDEX I_INFORMATION_TYPE ON INFORMATION_TYPE(ID);



-- APPLICATION

DROP TABLE IF EXISTS APPLICATION;
CREATE TABLE APPLICATION(
	APPLICATION_NAME VARCHAR(50) NOT NULL,
	INFORMATION_TYPE_ID INT NOT NULL,
	PRIMARY KEY (APPLICATION_NAME),
	FOREIGN KEY (INFORMATION_TYPE_ID) REFERENCES INFORMATION_TYPE (ID)
);

-- INFORMATION

DROP TABLE IF EXISTS INFORMATION;

CREATE TABLE INFORMATION (
	INFORMATION_ID INT NOT NULL,
	INFORMATION_KEY VARCHAR(255),
	ARCHIVED BIT NOT NULL DEFAULT 0,
	TITLE VARCHAR(255),
	URL VARCHAR(255),
	DESCRIPTION VARCHAR(255),
	APPLICATION_NAME VARCHAR(50),
	PARENT_INFORMATION_ID INT,
	MAIN_AUTHOR_ID INT,
	RATING DOUBLE,
	RATING_COUNT INT,
	VIEW_COUNT INT NOT NULL DEFAULT 0,
	DOWNLOAD_COUNT INT NOT NULL DEFAULT 0,
	CREATED_ON DATETIME NOT NULL,
	UPDATED_ON DATETIME,
	UPDATED_BY INT,
	PRIMARY KEY (INFORMATION_ID),
	FOREIGN KEY (APPLICATION_NAME) REFERENCES APPLICATION (APPLICATION_NAME),
	FOREIGN KEY (PARENT_INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID),
	FOREIGN KEY (MAIN_AUTHOR_ID) REFERENCES PERSON (PERSON_ID),
	FOREIGN KEY (UPDATED_BY) REFERENCES PERSON (PERSON_ID)
);

CREATE INDEX I_INFORMATION_1 ON INFORMATION (INFORMATION_KEY);

-- Reference to deleted information
-- insert into information(information_id,created_on) values(0,now());

-- ATTACHMENT

DROP TABLE IF EXISTS ATTACHMENT;

CREATE TABLE ATTACHMENT (
	ATTACHMENT_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	VERSION VARCHAR(50) NOT NULL,
	FILE_NAME VARCHAR(100),
	FILE_SIZE BIGINT,
	MIME_TYPE_NAME VARCHAR(100),
	PATH VARCHAR(200),
	MAIN BIT NOT NULL DEFAULT 0,
	PRIMARY KEY (ATTACHMENT_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID),
	FOREIGN KEY (MIME_TYPE_NAME) REFERENCES MIME_TYPE (MIME_TYPE_NAME)
);

CREATE UNIQUE INDEX I_ATTACHMENT_1 ON ATTACHMENT (INFORMATION_ID, VERSION);


-- PARTICIPATION

DROP TABLE IF EXISTS PARTICIPATION;

CREATE TABLE PARTICIPATION (
	PARTICIPATION_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	PERSON_ID INT NOT NULL,
	RATING INT,
	COMMENT VARCHAR(200),
	PRIMARY KEY (PARTICIPATION_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID),
	FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID)
);

CREATE INDEX I_PARTICIPATION_1 ON PARTICIPATION (INFORMATION_ID);

CREATE INDEX I_PARTICIPATION_2 ON PARTICIPATION (PERSON_ID);


-- TAG

DROP TABLE IF EXISTS TAG;

CREATE TABLE TAG (
	TAG_ID INT NOT NULL,
	TAG_KEY VARCHAR(100),
	NAME VARCHAR(100),
	TAG_KIND ENUM ('TAXONOMY', 'FOLKSONOMY'),
	TQ DOUBLE,
	CREATED_ON DATETIME NOT NULL,
	UPDATED_ON DATETIME NOT NULL,
	PRIMARY KEY (TAG_ID)
);

CREATE INDEX I_TAG_1 ON TAG (TAG_KEY);


-- COMMUNITY

DROP TABLE IF EXISTS COMMUNITY;

CREATE TABLE COMMUNITY (
	COMMUNITY_ID INT NOT NULL,
	COMMUNITY_KEY VARCHAR(100),
	NAME VARCHAR(100),
	APPLICATION VARCHAR(50),
	MQ DOUBLE,
	CREATED_ON DATETIME NOT NULL,
	UPDATED_ON DATETIME NOT NULL,
	PRIMARY KEY (COMMUNITY_ID)
);

CREATE INDEX I_COMMUNITY_1 ON COMMUNITY (COMMUNITY_KEY);


-- USER_GROUP

DROP TABLE IF EXISTS USER_GROUP;

CREATE TABLE USER_GROUP (
	USER_GROUP_ID INT NOT NULL,
	USER_GROUP_KEY VARCHAR(100),
	NAME VARCHAR(100),
	APPLICATION VARCHAR(50),
	CREATED_ON DATETIME NOT NULL,
	UPDATED_ON DATETIME NOT NULL,
	PRIMARY KEY (USER_GROUP_ID)
);

CREATE INDEX I_USER_GROUP_1 ON USER_GROUP (USER_GROUP_KEY);


-- PERSON_USER_GROUP

DROP TABLE IF EXISTS PERSON_USER_GROUP;

CREATE TABLE PERSON_USER_GROUP (
	PERSON_USER_GROUP_ID INT NOT NULL,
	PERSON_ID INT NOT NULL,
	USER_GROUP_ID INT NOT NULL,
	ACR ENUM('NONE', 'READ', 'WRITE', 'ADMIN'),
	PRIMARY KEY (PERSON_USER_GROUP_ID),
	FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID),
	FOREIGN KEY (USER_GROUP_ID) REFERENCES USER_GROUP (USER_GROUP_ID)
);

CREATE INDEX I_PERSON_USER_GROUP_1 ON PERSON_USER_GROUP (PERSON_ID);

CREATE INDEX I_PERSON_USER_GROUP_2 ON PERSON_USER_GROUP (USER_GROUP_ID);


-- PERSON_COMMUNITY

DROP TABLE IF EXISTS PERSON_COMMUNITY;

CREATE TABLE PERSON_COMMUNITY (
	PERSON_COMMUNITY_ID INT NOT NULL,
	PERSON_ID INT NOT NULL,
	COMMUNITY_ID INT NOT NULL,
	ACR ENUM('NONE', 'READ', 'WRITE', 'ADMIN') NOT NULL,
	PRIMARY KEY (PERSON_COMMUNITY_ID),
	FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID),
	FOREIGN KEY (COMMUNITY_ID) REFERENCES COMMUNITY (COMMUNITY_ID)
);

CREATE INDEX I_PERSON_COMMUNITY_1 ON PERSON_COMMUNITY (PERSON_ID);

CREATE INDEX I_PERSON_COMMUNITY_2 ON PERSON_COMMUNITY (COMMUNITY_ID);


-- PERSON_INFORMATION

DROP TABLE IF EXISTS PERSON_INFORMATION;

CREATE TABLE PERSON_INFORMATION (
	PERSON_INFORMATION_ID INT NOT NULL,
	PERSON_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	ACR ENUM('NONE', 'READ', 'WRITE', 'ADMIN') NOT NULL,
	PRIMARY KEY (PERSON_INFORMATION_ID),
	FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID)
);

CREATE INDEX I_PERSON_INFORMATION_1 ON PERSON_INFORMATION (PERSON_ID);

CREATE INDEX I_PERSON_INFORMATION_2 ON PERSON_INFORMATION (INFORMATION_ID);


-- USER_GROUP_COMMUNITY

DROP TABLE IF EXISTS USER_GROUP_COMMUNITY;

CREATE TABLE USER_GROUP_COMMUNITY (
	USER_GROUP_COMMUNITY_ID INT NOT NULL,
	USER_GROUP_ID INT NOT NULL,
	COMMUNITY_ID INT NOT NULL,
	ACR ENUM('NONE', 'READ', 'WRITE', 'ADMIN') NOT NULL,
	PRIMARY KEY (USER_GROUP_COMMUNITY_ID),
	FOREIGN KEY (USER_GROUP_ID) REFERENCES USER_GROUP (USER_GROUP_ID),
	FOREIGN KEY (COMMUNITY_ID) REFERENCES COMMUNITY (COMMUNITY_ID)
);

CREATE INDEX I_USER_GROUP_COMMUNITY_1 ON USER_GROUP_COMMUNITY (USER_GROUP_ID);

CREATE INDEX I_USER_GROUP_COMMUNITY_2 ON USER_GROUP_COMMUNITY (COMMUNITY_ID);


-- USER_GROUP_INFORMATION

DROP TABLE IF EXISTS USER_GROUP_INFORMATION;

CREATE TABLE USER_GROUP_INFORMATION (
	USER_GROUP_INFORMATION_ID INT NOT NULL,
	USER_GROUP_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	ACR ENUM('NONE', 'READ', 'WRITE', 'ADMIN') NOT NULL,
	PRIMARY KEY (USER_GROUP_INFORMATION_ID),
	FOREIGN KEY (USER_GROUP_ID) REFERENCES USER_GROUP (USER_GROUP_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID)
);

CREATE INDEX I_USER_GROUP_INFORMATION_1 ON USER_GROUP_INFORMATION (USER_GROUP_ID);

CREATE INDEX I_USER_GROUP_INFORMATION_2 ON USER_GROUP_INFORMATION (INFORMATION_ID);


-- COMMUNITY_INFORMATION

DROP TABLE IF EXISTS COMMUNITY_INFORMATION;

CREATE TABLE COMMUNITY_INFORMATION (
	COMMUNITY_INFORMATION_ID INT NOT NULL,
	COMMUNITY_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	ACR ENUM('NONE', 'READ', 'WRITE', 'ADMIN') NOT NULL,
	PRIMARY KEY (COMMUNITY_INFORMATION_ID),
	FOREIGN KEY (COMMUNITY_ID) REFERENCES COMMUNITY (COMMUNITY_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID)
);

CREATE INDEX I_COMMUNITY_INFORMATION_1 ON COMMUNITY_INFORMATION (COMMUNITY_ID);

CREATE INDEX I_COMMUNITY_INFORMATION_2 ON COMMUNITY_INFORMATION (INFORMATION_ID);


-- AUTHOR

DROP TABLE IF EXISTS AUTHOR;

CREATE TABLE AUTHOR (
	AUTHOR_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	PERSON_ID INT NOT NULL,
	PRIMARY KEY (AUTHOR_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID),
	FOREIGN KEY (PERSON_ID) REFERENCES PERSON (PERSON_ID)
);

CREATE INDEX I_AUTHOR_1 ON AUTHOR (INFORMATION_ID);

CREATE INDEX I_AUTHOR_2 ON AUTHOR (PERSON_ID);


-- INFORMATION_TAG

DROP TABLE IF EXISTS INFORMATION_TAG;

CREATE TABLE INFORMATION_TAG (
	INFORMATION_TAG_ID INT NOT NULL,
	INFORMATION_ID INT NOT NULL,
	TAG_ID INT NOT NULL,
	TAG_SOURCE ENUM ('SYSTEM', 'AUTHOR', 'COMMUNITY'),
	PRIMARY KEY (INFORMATION_TAG_ID),
	FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID),
	FOREIGN KEY (TAG_ID) REFERENCES TAG (TAG_ID)
);

CREATE INDEX I_INFORMATION_TAG_1 ON INFORMATION_TAG (INFORMATION_ID);

CREATE INDEX I_INFORMATION_TAG_2 ON INFORMATION_TAG (TAG_ID);



-- FEED

DROP TABLE IF EXISTS FEED;

CREATE TABLE FEED (
	FEED_ID INT NOT NULL,
	FEED_URL VARCHAR(100) NOT NULL,
	ENABLED BIT NOT NULL DEFAULT 1,
	TITLE VARCHAR(100),
	UPDATE_INTERVAL INT NOT NULL DEFAULT 1800,
	APPLICATION_NAME VARCHAR(50) NOT NULL,
	DEFAULT_AUTHOR_E_MAIL VARCHAR(100),
	LAST_UPDATED DATETIME,
	CREATED_ON DATETIME NOT NULL,
	UPDATED_ON DATETIME NOT NULL,
	PRIMARY KEY (FEED_ID),
	FOREIGN KEY (APPLICATION_NAME) REFERENCES APPLICATION (APPLICATION_NAME)
);

CREATE UNIQUE INDEX I_FEED_1 ON FEED (FEED_URL);


-- Logging

DROP TABLE IF EXISTS ACTION_TYPE;
CREATE TABLE ACTION_TYPE(
    ACTION_TYPE_ID    INT NOT NULL,
    ACTION_TYPE_TITLE VARCHAR(100) NOT NULL,
    PRIMARY KEY (ACTION_TYPE_ID)
);

CREATE INDEX I_ACTION_TYPE ON ACTION_TYPE(ACTION_TYPE_ID);

DROP TABLE IF EXISTS LOG;
CREATE TABLE LOG (
    LOG_ID             INT NOT NULL,
    LOG_DATE           DATETIME NOT NULL,
    LOG_ACTION_TYPE_ID INT NOT NULL,
    LOG_PERSON_ID      INT,
    LOG_OBJECT_ID      INT,
    PRIMARY KEY (LOG_ID),
    FOREIGN KEY (LOG_ACTION_TYPE_ID) REFERENCES ACTION_TYPE(ACTION_TYPE_ID),
    FOREIGN KEY (LOG_PERSON_ID) REFERENCES PERSON(PERSON_ID)
);
CREATE INDEX I_LOG_ID ON LOG (LOG_ID);

-- CEQ MATH

DROP TABLE IF EXISTS ACTION_TYPE_CEQ;
CREATE TABLE ACTION_TYPE_CEQ(
    ID                  INT NOT NULL,
    ACTION_TYPE_ID      INT NOT NULL,
    INFORMATION_TYPE_ID INT NOT NULL,
    POINTS_IQ           INT NOT NULL DEFAULT 0,
    AGING_IQ            INT NOT NULL DEFAULT 0,
    K_IQ                INT NOT NULL DEFAULT 0,
    POINTS_PQ           INT NOT NULL DEFAULT 0,
    AGING_PQ            INT NOT NULL DEFAULT 0,
    K_PQ                INT NOT NULL DEFAULT 0,
    PRIMARY KEY (ID),
    FOREIGN KEY (ACTION_TYPE_ID) REFERENCES ACTION_TYPE(ACTION_TYPE_ID),
    FOREIGN KEY (INFORMATION_TYPE_ID) REFERENCES INFORMATION_TYPE(ID)
);

CREATE INDEX I_ACTION_TYPE_CEQ ON ACTION_TYPE_CEQ(ACTION_TYPE_ID);

DROP TABLE IF EXISTS CEQACTION;
CREATE TABLE CEQACTION (
    CONTROLLED_ACTION INT NOT NULL,
    INFORMATION_ID    INT NOT NULL,
    PERSON_ID         INT NOT NULL,
    LOG_ID            INT NOT NULL,
    FOREIGN KEY (INFORMATION_ID) REFERENCES INFORMATION (INFORMATION_ID),
    FOREIGN KEY (PERSON_ID)      REFERENCES PERSON (PERSON_ID),
    FOREIGN KEY (LOG_ID)         REFERENCES LOG (LOG_ID)
);

CREATE INDEX I_ACTION_1 ON CEQACTION (CONTROLLED_ACTION,INFORMATION_ID,PERSON_ID);
CREATE INDEX I_ACTION_2 ON CEQACTION (CONTROLLED_ACTION,INFORMATION_ID);

DROP TABLE IF EXISTS ACTION_DATA;
CREATE TABLE ACTION_DATA(
    ACTION_LOG_ID         INT NOT NULL,
    ACTION_K_IQ           INT DEFAULT 0,    -- KIQ of the action
    ACTION_K_PQ           INT DEFAULT 0,    -- KPQ of the action
    ACTION_B_IQ           INT DEFAULT 0,    -- BIQ of the action
    ACTION_B_PQ           INT DEFAULT 0,    -- BPQ of the action
    ACTION_INFORMATION_K  INT DEFAULT NULL, -- New Info K (just for history)
    ACTION_INFORMATION_B  INT DEFAULT NULL, -- New Info B
    ACTION_PERSON_PQK     INT DEFAULT NULL, -- New PERSON PQK
    ACTION_PERSON_PQB     INT DEFAULT NULL, -- New PERSON PQB
    ACTION_PERSON_CQK     INT DEFAULT NULL, -- New PERSON CQK
    ACTION_PERSON_CQB     INT DEFAULT NULL, -- New PERSON CQB
    ACTION_AGING_IQ       DATE DEFAULT NULL, -- Date of IQ aging
    ACTION_AGING_PQ       DATE DEFAULT NULL, -- Date of PQ aging
    ACTION_EXP_INFO_K     INT DEFAULT NULL, -- Info K after action expired
    ACTION_EXP_INFO_B     INT DEFAULT NULL, -- Info B after action expired
    ACTION_EXP_PERSON_PQK INT DEFAULT NULL, -- PERSON PQK after action expired
    ACTION_EXP_PERSON_PQB INT DEFAULT NULL, -- PERSON PQB after action expired
    ACTION_EXP_PERSON_CQK INT DEFAULT NULL, -- PERSON CQK after action expired
    ACTION_EXP_PERSON_CQB INT DEFAULT NULL, -- PERSON CQB after action expired
    FOREIGN KEY(ACTION_LOG_ID) REFERENCES LOG (LOG_ID)
);

CREATE INDEX I_ACTION_DATA ON ACTION_DATA(ACTION_LOG_ID);

DROP TABLE IF EXISTS PERSON_CEQ;
CREATE TABLE PERSON_CEQ (
    PERSON_ID     INT NOT NULL,
    PERSON_PQ     DOUBLE DEFAULT 0 NOT NULL,
    PERSON_PQK    INT DEFAULT 0 NOT NULL,
    PERSON_PQB    INT DEFAULT 0 NOT NULL,
    PERSON_CQ     DOUBLE DEFAULT 0 NOT NULL,
    PERSON_CQK    INT DEFAULT 0 NOT NULL,
    PERSON_CQB    INT DEFAULT 0 NOT NULL,
    PERSON_PEQ    DOUBLE DEFAULT 0 NOT NULL,
    PERSON_STATUS TINYINT DEFAULT 0 NOT NULL,
    FOREIGN KEY(PERSON_ID) REFERENCES PERSON(PERSON_ID)
);

CREATE INDEX I_PERSON_CEQ ON PERSON_CEQ(PERSON_ID);

DROP TABLE IF EXISTS INFORMATION_CEQ;
CREATE TABLE INFORMATION_CEQ (
    INFORMATION_ID      INT NOT NULL,
    AUTHOR_ID           INT NOT NULL,
    INFORMATION_IQ      DOUBLE DEFAULT 0 NOT NULL,
    INFORMATION_IQK     INT DEFAULT 0 NOT NULL,
    INFORMATION_IQB     INT DEFAULT 0 NOT NULL,
    INFORMATION_STATUS  TINYINT DEFAULT 0 NOT NULL,
    INFORMATION_TYPE_ID INT NOT NULL,
    FOREIGN KEY(AUTHOR_ID) REFERENCES PERSON_CEQ(PERSON_ID),
    FOREIGN KEY (INFORMATION_TYPE_ID) REFERENCES INFORMATION_TYPE(ID)
);

CREATE INDEX I_INFORMATION_CEQ ON INFORMATION_CEQ(INFORMATION_ID);

DROP TABLE IF EXISTS USER_GROUP_STATUS;
CREATE TABLE USER_GROUP_STATUS (
    USER_GROUP_ID INT NOT NULL,
    USER_GROUP_STATUS TINYINT DEFAULT 0 NOT NULL,
    FOREIGN KEY(USER_GROUP_ID) REFERENCES USER_GROUP(USER_GROUP_ID)
);

CREATE INDEX I_USER_GROUP_STATUS ON USER_GROUP_STATUS(USER_GROUP_ID);

DROP TABLE IF EXISTS TAG_CEQ;
CREATE TABLE TAG_CEQ (
    ID          INT NOT NULL,
    TQ          DOUBLE DEFAULT 0 NOT NULL,
    TQK         INT DEFAULT 0 NOT NULL,
    TQB         INT DEFAULT 0 NOT NULL,
    PQ          DOUBLE DEFAULT 0 NOT NULL,
    PQK         INT DEFAULT 0 NOT NULL,
    PQB         INT DEFAULT 0 NOT NULL,
    USAGE_COUNT INT DEFAULT 0 NOT NULL,
    PRIMARY KEY(ID)
);

CREATE INDEX I_TAG_CEQ ON TAG_CEQ(ID);

DROP VIEW IF EXISTS PERSON_TAG_CEQ_VIEW;
CREATE VIEW PERSON_TAG_CEQ_VIEW AS
SELECT INFORMATION_CEQ.AUTHOR_ID           AS I_AUTHOR_ID,
       INFORMATION_TAG.TAG_ID              AS I_TAG_ID,
       sum(INFORMATION_CEQ.INFORMATION_IQ) AS TQ
  FROM INFORMATION_TAG,
       INFORMATION_CEQ
 WHERE INFORMATION_CEQ.INFORMATION_ID = INFORMATION_TAG.INFORMATION_ID
 GROUP BY I_AUTHOR_ID, I_TAG_ID;

DROP VIEW IF EXISTS COUNTRY_TAG_CEQ_VIEW;
CREATE VIEW COUNTRY_TAG_CEQ_VIEW AS
SELECT PERSON.COUNTRY_CODE                 AS I_COUNTRY_CODE,
       INFORMATION_TAG.TAG_ID              AS I_TAG_ID,
       sum(INFORMATION_CEQ.INFORMATION_IQ) AS TQ
  FROM INFORMATION_TAG,
       INFORMATION_CEQ,
       PERSON
 WHERE INFORMATION_CEQ.INFORMATION_ID = INFORMATION_TAG.INFORMATION_ID
   AND INFORMATION_CEQ.AUTHOR_ID = PERSON.PERSON_ID
 GROUP BY I_COUNTRY_CODE, I_TAG_ID;

DROP VIEW IF EXISTS COUNTRY_CEQ_VIEW;
CREATE VIEW COUNTRY_CEQ_VIEW AS
SELECT PERSON.COUNTRY_CODE                 AS I_COUNTRY_CODE,
       sum(INFORMATION_CEQ.INFORMATION_IQ) AS CQ
  FROM INFORMATION_CEQ,
       PERSON
 WHERE INFORMATION_CEQ.AUTHOR_ID = PERSON.PERSON_ID
 GROUP BY I_COUNTRY_CODE;


INSERT INTO INFORMATION_TYPE( ID, DESCRIPTION ) VALUES ( 0, 'Attachment' );
INSERT INTO INFORMATION_TYPE( ID, DESCRIPTION ) VALUES ( 1, 'Wiki' );
INSERT INTO INFORMATION_TYPE( ID, DESCRIPTION ) VALUES ( 2, 'Blog' );
INSERT INTO INFORMATION_TYPE( ID, DESCRIPTION ) VALUES ( 3, 'Microblogging' );
INSERT INTO INFORMATION_TYPE( ID, DESCRIPTION ) VALUES ( 4, 'Forum' );

INSERT INTO APPLICATION VALUES ('Test Wiki', 1);

INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 0, 'Created' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 1, 'Rated 1' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 2, 'Rated 2' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 3, 'Rated 3' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 4, 'Rated 4' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 5, 'Rated 5' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 6, 'Commented' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 7, 'Content updated' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 8, 'Meta updated' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 9, 'Tagged' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 10, 'Viewed' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 11, 'Main Author changed' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 12, 'Cloned' );
INSERT INTO ACTION_TYPE( ACTION_TYPE_ID, ACTION_TYPE_TITLE ) VALUES ( 13, 'Deleted' );

-- Attachments
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 0, 0, 0, 10, 360, 0, 0 );-- created
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 1, 1, 0, -10, 90, 5, 90 );-- rated1
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 2, 2, 0, -6, 90, 5, 90 );-- rated2
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 3, 3, 0, 1, 90, 5, 90 );-- rated3
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 4, 4, 0, 6, 90, 5, 90 );-- rated4
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 5, 5, 0, 10, 90, 5, 90 );-- rated5
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 6, 6, 0, 5, 90, 5, 90 );-- commented
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 7, 7, 0, 5, 270, 0, 0 );-- content update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 8, 8, 0, 2, 60, 0, 0 );-- meta update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 9, 9, 0, 0, 0, 5, 90 );-- tagged
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 10, 10, 0, 3, 180, 3, 90 );-- viewed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 11, 11, 0, 0, 0, 0, 0 );-- Main author changed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 12, 12, 0, 5, 180, 10, 180 );-- cloned
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 13, 13, 0, 0, 0, 0, 0 );-- deleted

-- Wiki
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 14, 0, 1, 5, 360, 0, 0 );-- created
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 15, 1, 1, -10, 90, 5, 90 );-- rated1
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 16, 2, 1, -6, 90, 5, 90 );-- rated2
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 17, 3, 1, 1, 90, 5, 90 );-- rated3
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 18, 4, 1, 6, 90, 5, 90 );-- rated4
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 19, 5, 1, 10, 90, 5, 90 );-- rated5
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 20, 6, 1, 5, 90, 5, 90 );-- commented
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 21, 7, 1, 1, 180, 0, 0 );-- content update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 22, 8, 1, 1, 60, 0, 0 );-- meta update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 23, 9, 1, 0, 0, 5, 90 );-- tagged
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 24, 10, 1, 1, 30, 1, 30 );-- viewed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 25, 11, 0, 0, 0, 0, 0 );-- Main author changed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 26, 12, 1, 5, 180, 5, 180 );-- cloned
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 27, 13, 1, 0, 0, 0, 0 );-- deleted

-- Blog
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 28, 0, 2, 5, 360, 0, 0 );-- created
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 29, 1, 2, -10, 90, 5, 90 );-- rated1
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 30, 2, 2, -6, 90, 5, 90 );-- rated2
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 31, 3, 2, 1, 90, 5, 90 );-- rated3
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 32, 4, 2, 6, 90, 5, 90 );-- rated4
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 33, 5, 2, 10, 90, 5, 90 );-- rated5
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 34, 6, 2, 5, 90, 5, 90 );-- commented
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 35, 7, 2, 1, 180, 0, 0 );-- content update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 36, 8, 2, 1, 60, 0, 0 );-- meta update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 37, 9, 2, 0, 0, 5, 90 );-- tagged
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 38, 10, 2, 1, 30, 1, 30 );-- viewed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 39, 11, 0, 0, 0, 0, 0 );-- Main author changed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 40, 12, 2, 5, 180, 5, 180 );-- cloned
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 41, 13, 2, 0, 0, 0, 0 );-- deleted

-- Microblogging
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 42, 0, 3, 1, 30, 0, 0 );-- created
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 43, 1, 3, -10, 30, 5, 30 );-- rated1
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 44, 2, 3, -6, 30, 5, 30 );-- rated2
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 45, 3, 3, 1, 30, 5, 30 );-- rated3
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 46, 4, 3, 6, 30, 5, 30 );-- rated4
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 47, 5, 3, 10, 30, 5, 30 );-- rated5
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 48, 6, 3, 5, 30, 5, 30 );-- commented
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 49, 7, 3, 0, 0, 0, 0 );-- content update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 50, 8, 3, 0, 0, 0, 0 );-- meta update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 51, 9, 3, 0, 0, 1, 30 );-- tagged
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 52, 10, 3, 1, 30, 1, 30 );-- viewed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 53, 11, 0, 0, 0, 0, 0 );-- Main author changed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 54, 12, 3, 2, 60, 2, 30 );-- cloned = RT
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 55, 13, 3, 0, 0, 0, 0 );-- deleted

-- Forum
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 56, 0, 4, 5, 360, 0, 0 );-- created
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 57, 1, 4, -10, 90, 5, 90 );-- rated1
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 58, 2, 4, -6, 90, 5, 90 );-- rated2
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 59, 3, 4, 1, 90, 5, 90 );-- rated3
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 60, 4, 4, 6, 90, 5, 90 );-- rated4
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 61, 5, 4, 10, 90, 5, 90 );-- rated5
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 62, 6, 4, 5, 90, 5, 90 );-- commented
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 63, 7, 4, 1, 180, 0, 0 );-- content update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 64, 8, 4, 1, 60, 0, 0 );-- meta update
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 65, 9, 4, 0, 0, 5, 90 );-- tagged
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 66, 10, 4, 1, 30, 1, 30 );-- viewed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 67, 11, 0, 0, 0, 0, 0 );-- Main author changed
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 68, 12, 4, 5, 180, 5, 180 );-- cloned
INSERT INTO ACTION_TYPE_CEQ( ID, ACTION_TYPE_ID, INFORMATION_TYPE_ID, POINTS_IQ, AGING_IQ, POINTS_PQ, AGING_PQ ) VALUES ( 69, 13, 4, 0, 0, 0, 0 );-- deleted

UPDATE ACTION_TYPE_CEQ
   SET K_IQ = POINTS_IQ * ( 1080 / AGING_IQ )
 WHERE AGING_IQ > 0;

UPDATE ACTION_TYPE_CEQ
   SET K_PQ = POINTS_PQ * ( 1080 / AGING_PQ )
 WHERE AGING_PQ > 0;

INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('AALAND ISLANDS','AX','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('AFGHANISTAN','AF','afghanistan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ALBANIA','AL','albania.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ALGERIA','DZ','algeria.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('AMERICAN SAMOA','AS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ANDORRA','AD','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ANGOLA','AO','angola.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ANGUILLA','AI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ANTARCTICA','AQ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ANTIGUA AND BARBUDA','AG','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ARGENTINA','AR','argentina.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ARMENIA','AM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ARUBA','AW','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('AUSTRALIA','AU','australia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('AUSTRIA','AT','austria.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('AZERBAIJAN','AZ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BAHAMAS','BS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BAHRAIN','BH','bahrain.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BANGLADESH','BD','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BARBADOS','BB','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BELARUS','BY','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BELGIUM','BE','belgium.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BELIZE','BZ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BENIN','BJ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BERMUDA','BM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BHUTAN','BT','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BOLIVIA','BO','bolivia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BOSNIA AND HERZEGOWINA','BA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BOTSWANA','BW','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BOUVET ISLAND','BV','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BRAZIL','BR','brazil.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BRITISH INDIAN OCEAN TERRITORY','IO','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BRUNEI DARUSSALAM','BN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BULGARIA','BG','bulgaria.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BURKINA FASO','BF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('BURUNDI','BI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CAMBODIA','KH','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CAMEROON','CM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CANADA','CA','canada.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CAPE VERDE','CV','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CAYMAN ISLANDS','KY','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CENTRAL AFRICAN REPUBLIC','CF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CHAD','TD','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CHILE','CL','chile.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CHINA','CN','prc.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CHRISTMAS ISLAND','CX','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('COCOS (KEELING) ISLANDS','CC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('COLOMBIA','CO','columbia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('COMOROS','KM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CONGO, Democratic Republic of (was Zaire)','CD','zaire.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CONGO, Republic of','CG','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('COOK ISLANDS','CK','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('COSTA RICA','CR','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('COTE D''IVOIRE','CI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CROATIA (local name: Hrvatska)','HR','croatia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CUBA','CU','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CYPRUS','CY','cyprus.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('CZECH REPUBLIC','CZ','czech.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('DENMARK','DK','denmark.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('DJIBOUTI','DJ','djibouti.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('DOMINICA','DM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('DOMINICAN REPUBLIC','DO','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ECUADOR','EC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('EGYPT','EG','egypt.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('EL SALVADOR','SV','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('EQUATORIAL GUINEA','GQ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ERITREA','ER','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ESTONIA','EE','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ETHIOPIA','ET','ethiopia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FALKLAND ISLANDS (MALVINAS)','FK','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FAROE ISLANDS','FO','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FIJI','FJ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FINLAND','FI','finland.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FRANCE','FR','france.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FRENCH GUIANA','GF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FRENCH POLYNESIA','PF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('FRENCH SOUTHERN TERRITORIES','TF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GABON','GA','gabon.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GAMBIA','GM','gambia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GEORGIA','GE','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GERMANY','DE','germany.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GHANA','GH','ghana.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GIBRALTAR','GI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GREECE','GR','greece.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GREENLAND','GL','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GRENADA','GD','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GUADELOUPE','GP','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GUAM','GU','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GUATEMALA','GT','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GUINEA','GN','guinea.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GUINEA-BISSAU','GW','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('GUYANA','GY','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('HAITI','HT','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('HEARD AND MC DONALD ISLANDS','HM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('HONDURAS','HN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('HONG KONG','HK','hongkong.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('HUNGARY','HU','hungary.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ICELAND','IS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('INDIA','IN','india.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('INDONESIA','ID','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('IRAN (ISLAMIC REPUBLIC OF)','IR','iran.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('IRAQ','IQ','iraq.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('IRELAND','IE','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ISRAEL','IL','israel.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ITALY','IT','italy.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('JAMAICA','JM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('JAPAN','JP','japan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('JORDAN','JO','jordan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KAZAKHSTAN','KZ','kazakhstan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KENYA','KE','kenya.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KIRIBATI','KI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF','KP','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KOREA, REPUBLIC OF','KR','korea.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KUWAIT','KW','kuwait.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('KYRGYZSTAN','KG','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LAO PEOPLE''S DEMOCRATIC REPUBLIC','LA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LATVIA','LV','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LEBANON','LB','lebanon.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LESOTHO','LS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LIBERIA','LR','liberia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LIBYAN ARAB JAMAHIRIYA','LY','libya.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LIECHTENSTEIN','LI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LITHUANIA','LT','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('LUXEMBOURG','LU','luxembourg.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MACAU','MO','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','MK','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MADAGASCAR','MG','madagascar.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MALAWI','MW','malawi.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MALAYSIA','MY','malaysia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MALDIVES','MV','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MALI','ML','mali.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MALTA','MT','malta.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MARSHALL ISLANDS','MH','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MARTINIQUE','MQ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MAURITANIA','MR','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MAURITIUS','MU','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MAYOTTE','YT','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MEXICO','MX','mexico.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MICRONESIA, FEDERATED STATES OF','FM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MOLDOVA, REPUBLIC OF','MD','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MONACO','MC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MONGOLIA','MN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MONTSERRAT','MS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MOROCCO','MA','morocco.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MOZAMBIQUE','MZ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('MYANMAR','MM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NAMIBIA','NA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NAURU','NR','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NEPAL','NP','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NETHERLANDS','NL','holland.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NETHERLANDS ANTILLES','AN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NEW CALEDONIA','NC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NEW ZEALAND','NZ','newzealand.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NICARAGUA','NI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NIGER','NE','niger.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NIGERIA','NG','nigeria.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NIUE','NU','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NORFOLK ISLAND','NF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NORTHERN MARIANA ISLANDS','MP','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('NORWAY','NO','norway.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('OMAN','OM','oman.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PAKISTAN','PK','pakistan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PALAU','PW','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PALESTINIAN TERRITORY, Occupied','PS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PANAMA','PA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PAPUA NEW GUINEA','PG','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PARAGUAY','PY','paraguay.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PERU','PE','peru.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PHILIPPINES','PH','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PITCAIRN','PN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('POLAND','PL','poland.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PORTUGAL','PT','portugal.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('PUERTO RICO','PR','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('QATAR','QA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('REUNION','RE','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ROMANIA','RO','romania.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('RUSSIAN FEDERATION','RU','russia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('RWANDA','RW','rwanda.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAINT HELENA','SH','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAINT KITTS AND NEVIS','KN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAINT LUCIA','LC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAINT PIERRE AND MIQUELON','PM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAINT VINCENT AND THE GRENADINES','VC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAMOA','WS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAN MARINO','SM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAO TOME AND PRINCIPE','ST','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SAUDI ARABIA','SA','saudiArabic.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SENEGAL','SN','senegal.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SERBIA AND MONTENEGRO','CS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SEYCHELLES','SC','seychelles.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SIERRA LEONE','SL','sierraLeone.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SINGAPORE','SG','singapore.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SLOVAKIA','SK','slovakia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SLOVENIA','SI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SOLOMON ISLANDS','SB','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SOMALIA','SO','somalia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SOUTH AFRICA','ZA','southAfrica.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GS','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SPAIN','ES','spain.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SRI LANKA','LK','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SUDAN','SD','sudan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SURINAME','SR','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SVALBARD AND JAN MAYEN ISLANDS','SJ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SWAZILAND','SZ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SWEDEN','SE','sweden.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SWITZERLAND','CH','switzerland.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('SYRIAN ARAB REPUBLIC','SY','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TAIWAN','TW','taiwan.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TAJIKISTAN','TJ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TANZANIA, UNITED REPUBLIC OF','TZ','tanzania.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('THAILAND','TH','thailand.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TIMOR-LESTE','TL','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TOGO','TG','togo.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TOKELAU','TK','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TONGA','TO','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TRINIDAD AND TOBAGO','TT','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TUNISIA','TN','tunisisa.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TURKEY','TR','turkey.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TURKMENISTAN','TM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TURKS AND CAICOS ISLANDS','TC','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('TUVALU','TV','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UGANDA','UG','uganda.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UKRAINE','UA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UNITED ARAB EMIRATES','AE','emirates.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UNITED KINGDOM','GB','uk.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UNITED STATES','US','usa.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UNITED STATES MINOR OUTLYING ISLANDS','UM','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('URUGUAY','UY','uruguay.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('UZBEKISTAN','UZ','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('VANUATU','VU','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('VATICAN CITY STATE (HOLY SEE)','VA','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('VENEZUELA','VE','venezuela.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('VIET NAM','VN','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('VIRGIN ISLANDS (BRITISH)','VG','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('VIRGIN ISLANDS (U.S.)','VI','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('WALLIS AND FUTUNA ISLANDS','WF','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('WESTERN SAHARA','EH','');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('YEMEN','YE','yemen.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ZAMBIA','ZM','zambia.gif');
INSERT INTO COUNTRY( NAME, COUNTRY_CODE, FLAGFILE ) VALUES ('ZIMBABWE','ZW','zimbabwe.gif');

-- create initial users (Anonymous / Administrator / Bob)
INSERT INTO PERSON (PERSON_ID, CQ, PQ, SURNAME, PEQ, SCREEN_NAME, CREATED_ON, PICTURE_URL, UPDATED_ON, PERSON_KEY, HOMEPAGE, E_MAIL, GIVEN_NAME, COUNTRY_CODE)
VALUES (3, 0.0, 0.0, 'Anonymous', 0.0, 'Anonymous', now(), null, now(), 'anonymous', null, 'no-reply@nowhere', 'User', null);
INSERT INTO PERSON (PERSON_ID, CQ, PQ, SURNAME, PEQ, SCREEN_NAME, CREATED_ON, PICTURE_URL, UPDATED_ON, PERSON_KEY, HOMEPAGE, E_MAIL, GIVEN_NAME, COUNTRY_CODE)
VALUES (1, 0.0, 0.0, 'Administrator', 0.0, 'Administrator', now(), null, now(), 'admin', null, 'administrator@nowhere', 'User', null);
INSERT INTO PERSON (PERSON_ID, CQ, PQ, SURNAME, PEQ, SCREEN_NAME, CREATED_ON, PICTURE_URL, UPDATED_ON, PERSON_KEY, HOMEPAGE, E_MAIL, GIVEN_NAME, COUNTRY_CODE)
VALUES (2, 0.0, 0.0, 'Bob', 0.0, 'Bob', now(), null, now(), 'bob', null, 'bob@nowhere', 'Blogs', 'CH');
-- create intial user groups
INSERT INTO USER_GROUP (USER_GROUP_ID, CREATED_ON, UPDATED_ON, NAME, USER_GROUP_KEY, APPLICATION)
VALUES (1, now(), now(), 'All Users', 'allusers', null);
INSERT INTO USER_GROUP (USER_GROUP_ID, CREATED_ON, UPDATED_ON, NAME, USER_GROUP_KEY, APPLICATION)
VALUES (2, now(), now(), 'Administrators', 'admins', null);
INSERT INTO PERSON_USER_GROUP (PERSON_USER_GROUP_ID, ACR, PERSON_ID, USER_GROUP_ID) VALUES (1, 'ADMIN', 1, 1);
INSERT INTO PERSON_USER_GROUP (PERSON_USER_GROUP_ID, ACR, PERSON_ID, USER_GROUP_ID) VALUES (2, 'ADMIN', 1, 2);
INSERT INTO PERSON_USER_GROUP (PERSON_USER_GROUP_ID, ACR, PERSON_ID, USER_GROUP_ID) VALUES (3, 'READ', 2, 1);
-- create initial informations
INSERT INTO INFORMATION (INFORMATION_ID, DESCRIPTION, RATING, INFORMATION_KEY, RATING_COUNT, TITLE, VIEW_COUNT, DOWNLOAD_COUNT, URL, CREATED_ON, ARCHIVED, UPDATED_ON, PARENT_INFORMATION_ID, UPDATED_BY, APPLICATION_NAME, MAIN_AUTHOR_ID)
VALUES (3, 'A web services based architecture to build a social value system for communities', 0.0, 'http://blogs.sun.com/peterreiser/category/Community+Equity', 0, 'Community Equity Blog (Blog@Sun)', 0, 0, 'http://blogs.sun.com/peterreiser/category/Community+Equity', now(), 0, now(), null, null, 'Test Wiki', 2);
INSERT INTO INFORMATION (INFORMATION_ID, DESCRIPTION, RATING, INFORMATION_KEY, RATING_COUNT, TITLE, VIEW_COUNT, DOWNLOAD_COUNT, URL, CREATED_ON, ARCHIVED, UPDATED_ON, PARENT_INFORMATION_ID, UPDATED_BY, APPLICATION_NAME, MAIN_AUTHOR_ID)
VALUES (2, 'A web services based architecture to build a social value system for communities', 0.0, 'http://kenai.com/projects/community-equity', 0, 'Community Equity (Project@Kenai)', 0, 0, 'http://kenai.com/projects/community-equity', now(), 0, now(), null, null, 'Test Wiki', 2);
INSERT INTO INFORMATION (INFORMATION_ID, DESCRIPTION, RATING, INFORMATION_KEY, RATING_COUNT, TITLE, VIEW_COUNT, DOWNLOAD_COUNT, URL, CREATED_ON, ARCHIVED, UPDATED_ON, PARENT_INFORMATION_ID, UPDATED_BY, APPLICATION_NAME, MAIN_AUTHOR_ID)
VALUES (1, 'A web services based architecture to build a social value system for communities', 0.0, 'http://wikis.sun.com/display/ceqdoc', 0, 'Community Equity Open Source Documentation (Wiki@Sun)', 0, 0, 'http://wikis.sun.com/display/ceqdoc', now(), 0, now(), null, null, 'Test Wiki', 2);
INSERT INTO USER_GROUP_INFORMATION (USER_GROUP_INFORMATION_ID, ACR, INFORMATION_ID, USER_GROUP_ID) VALUES (1, 'READ', 1, 1);
INSERT INTO USER_GROUP_INFORMATION (USER_GROUP_INFORMATION_ID, ACR, INFORMATION_ID, USER_GROUP_ID) VALUES (2, 'READ', 2, 1);
INSERT INTO USER_GROUP_INFORMATION (USER_GROUP_INFORMATION_ID, ACR, INFORMATION_ID, USER_GROUP_ID) VALUES (3, 'READ', 3, 1);
INSERT INTO TAG (TAG_ID, TAG_KIND, TQ, TAG_KEY, CREATED_ON, UPDATED_ON, NAME) VALUES (1, "TAXONOMY", 0.0, 'CEQ', now(), now(), "CEQ");
INSERT INTO TAG (TAG_ID, TAG_KIND, TQ, TAG_KEY, CREATED_ON, UPDATED_ON, NAME) VALUES (2, "FOLKSONOMY", 0.0, 'Wiki', now(), now(), "Wiki");
INSERT INTO TAG (TAG_ID, TAG_KIND, TQ, TAG_KEY, CREATED_ON, UPDATED_ON, NAME) VALUES (3, "FOLKSONOMY", 0.0, 'Project', now(), now(), "Project");
INSERT INTO TAG (TAG_ID, TAG_KIND, TQ, TAG_KEY, CREATED_ON, UPDATED_ON, NAME) VALUES (4, "FOLKSONOMY", 0.0, 'Blog', now(), now(), "Blog");
INSERT INTO TAG (TAG_ID, TAG_KIND, TQ, TAG_KEY, CREATED_ON, UPDATED_ON, NAME) VALUES (5, "FOLKSONOMY", 0.0, 'demo', now(), now(), "demo");
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (1, 'AUTHOR', 1, 1);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (2, 'AUTHOR', 2, 1);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (3, 'AUTHOR', 3, 1);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (4, 'AUTHOR', 1, 2);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (5, 'AUTHOR', 2, 3);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (6, 'AUTHOR', 3, 4);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (7, 'SYSTEM', 1, 5);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (8, 'SYSTEM', 2, 5);
INSERT INTO INFORMATION_TAG (INFORMATION_TAG_ID, TAG_SOURCE, INFORMATION_ID, TAG_ID) VALUES (9, 'SYSTEM', 3, 5);
INSERT INTO AUTHOR (AUTHOR_ID, INFORMATION_ID, PERSON_ID) VALUES (1, 1, 2);
INSERT INTO AUTHOR (AUTHOR_ID, INFORMATION_ID, PERSON_ID) VALUES (2, 2, 2);
INSERT INTO AUTHOR (AUTHOR_ID, INFORMATION_ID, PERSON_ID) VALUES (3, 3, 2);
INSERT INTO PERSON_CEQ (PERSON_ID, PERSON_PQB, PERSON_CQ, PERSON_PQ, PERSON_CQK, PERSON_CQB, PERSON_PQK, PERSON_STATUS) VALUES (1, 0, 0.0, 0.0, 0, 0, 0, 0);
INSERT INTO PERSON_CEQ (PERSON_ID, PERSON_PQB, PERSON_CQ, PERSON_PQ, PERSON_CQK, PERSON_CQB, PERSON_PQK, PERSON_STATUS) VALUES (2, 0, 0.0, 0.0, 0, 0, 0, 0);
INSERT INTO PERSON_CEQ (PERSON_ID, PERSON_PQB, PERSON_CQ, PERSON_PQ, PERSON_CQK, PERSON_CQB, PERSON_PQK, PERSON_STATUS) VALUES (3, 0, 0.0, 0.0, 0, 0, 0, 0);
INSERT INTO INFORMATION_CEQ (INFORMATION_ID, INFORMATION_IQK, INFORMATION_IQB, INFORMATION_IQ, INFORMATION_STATUS, AUTHOR_ID, INFORMATION_TYPE_ID) VALUES (1, 0, 0, 0.0, 0, 2, 1);
INSERT INTO INFORMATION_CEQ (INFORMATION_ID, INFORMATION_IQK, INFORMATION_IQB, INFORMATION_IQ, INFORMATION_STATUS, AUTHOR_ID, INFORMATION_TYPE_ID) VALUES (2, 0, 0, 0.0, 0, 2, 1);
INSERT INTO INFORMATION_CEQ (INFORMATION_ID, INFORMATION_IQK, INFORMATION_IQB, INFORMATION_IQ, INFORMATION_STATUS, AUTHOR_ID, INFORMATION_TYPE_ID) VALUES (3, 0, 0, 0.0, 0, 2, 1);
UPDATE GENERATOR SET GENERATOR_VALUE = 3 WHERE GENERATOR_KEY = 'PERSON';
UPDATE GENERATOR SET GENERATOR_VALUE = 2 WHERE GENERATOR_KEY = 'USER_GROUP';
UPDATE GENERATOR SET GENERATOR_VALUE = 3 WHERE GENERATOR_KEY = 'PERSON_USER_GROUP';
UPDATE GENERATOR SET GENERATOR_VALUE = 3 WHERE GENERATOR_KEY = 'INFORMATION';
UPDATE GENERATOR SET GENERATOR_VALUE = 3 WHERE GENERATOR_KEY = 'USER_GROUP_INFORMATION';
UPDATE GENERATOR SET GENERATOR_VALUE = 5 WHERE GENERATOR_KEY = 'TAG';
UPDATE GENERATOR SET GENERATOR_VALUE = 9 WHERE GENERATOR_KEY = 'INFORMATION_TAG';
UPDATE GENERATOR SET GENERATOR_VALUE = 3 WHERE GENERATOR_KEY = 'AUTHOR';