All pastes #46516 Raw Edit

Mine

public text v1 · immutable
#46516 ·published 2006-03-21 18:29 UTC
rendered paste body
DROP TABLE IF EXISTS `seven_signs_status`;
CREATE TABLE IF NOT EXISTS `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` VALUES
(1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);