l2j-server-datapack/datapack_development/sql/seven_signs_status.sql

DROP TABLE IF EXISTS `seven_signs_status`;
CREATE TABLE `seven_signs_status` (
  `current_cycle` INT NOT NULL default '1',
  `festival_cycle` INT NOT NULL default '1',
  `active_period` INT NOT NULL default '1',
  `date` INT NOT NULL default '1',
  `previous_winner` INT NOT NULL default '0',
  `dawn_stone_score` INT NOT NULL default '0',
  `dawn_festival_score` INT NOT NULL default '0',
  `dusk_stone_score` INT NOT NULL default '0',
  `dusk_festival_score` INT NOT NULL default '0',
  `avarice_owner` INT NOT NULL default '0',
  `gnosis_owner` INT NOT NULL default '0',
  `strife_owner` INT NOT NULL default '0',
  `avarice_dawn_score` INT NOT NULL default '0',
  `gnosis_dawn_score` INT NOT NULL default '0',
  `strife_dawn_score` INT NOT NULL default '0',
  `avarice_dusk_score` INT NOT NULL default '0',
  `gnosis_dusk_score` INT NOT NULL default '0',
  `strife_dusk_score` INT NOT NULL default '0',
  `accumulated_bonus0` INT NOT NULL default '0',
  `accumulated_bonus1` INT NOT NULL default '0',
  `accumulated_bonus2` INT NOT NULL default '0',
  `accumulated_bonus3` INT NOT NULL default '0',
  `accumulated_bonus4` INT NOT NULL default '0'
);

INSERT INTO `seven_signs_status` VALUES
(1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);