ALTER TABLE `characters` ADD COLUMN `clan_privs` decimal(4,0) default '0';
DROP TABLE IF EXISTS seven_signs_status;
CREATE TABLE seven_signs_status (
  id int(1) NOT NULL default 1,
  current_cycle int(10) NOT NULL default 1,
  active_period int(10) NOT NULL default 1,
  previous_winner int(10) NOT NULL default 0,
  dawn_stone_score int(10) NOT NULL default 0,
  dawn_festival_score int(10) NOT NULL default 0,
  dusk_stone_score int(10) NOT NULL default 0,
  dusk_festival_score int(10) NOT NULL default 0,
  avarice_owner int(10) NOT NULL default 0,
  gnosis_owner int(10) NOT NULL default 0,
  strife_owner int(10) NOT NULL default 0,
  avarice_dawn_score int(10) NOT NULL default 0,
  gnosis_dawn_score int(10) NOT NULL default 0,
  strife_dawn_score int(10) NOT NULL default 0,
  avarice_dusk_score int(10) NOT NULL default 0,
  gnosis_dusk_score int(10) NOT NULL default 0,
  strife_dusk_score int(10) NOT NULL default 0,
  festival_cycle int(10) NOT NULL default 1,
  accumulated_bonus0 int(10) NOT NULL default 0,
  accumulated_bonus1 int(10) NOT NULL default 0,
  accumulated_bonus2 int(10) NOT NULL default 0,
  accumulated_bonus3 int(10) NOT NULL default 0,
  accumulated_bonus4 int(10) NOT NULL default 0,
  date int(10) NOT NULL default 1,
  PRIMARY KEY (`id`)
);

INSERT INTO `seven_signs_status` ( `id` , `current_cycle` , `active_period` , `previous_winner` , `dawn_stone_score` , `dawn_festival_score` , `dusk_stone_score` , `dusk_festival_score` , `avarice_owner` , `gnosis_owner` , `strife_owner` , `avarice_dawn_score` , `gnosis_dawn_score` , `strife_dawn_score` , `avarice_dusk_score` , `gnosis_dusk_score` , `strife_dusk_score` , `festival_cycle` , `accumulated_bonus0` , `accumulated_bonus1` , `accumulated_bonus2` , `accumulated_bonus3` , `accumulated_bonus4` ) 
VALUES (
'1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0'
);