Index: seven_signs_status.sql
===================================================================
--- seven_signs_status.sql (revision 1432)
+++ seven_signs_status.sql (working copy)
@@ -1,29 +1,30 @@
-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'
+CREATE TABLE IF NOT EXISTS `seven_signs_status` (
+ `id` int(11) NOT NULL default '0',
+ `current_cycle` int(10) NOT NULL default '1',
+ `festival_cycle` int(10) NOT NULL default '1',
+ `active_period` int(10) NOT NULL default '1',
+ `date` 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',
+ `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',
+ PRIMARY KEY (`id`)
);
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);
\ No newline at end of file
+(0,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
\ No newline at end of file