-- -- Table structure for table 'admins' -- CREATE TABLE `admins` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(45) NOT NULL default '', `password` varchar(45) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'admins' -- INSERT INTO `admins` VALUES (1,'brendonrice','M0rgan1'); INSERT INTO `admins` VALUES (2,'martincoe','Captain1'); -- -- Table structure for table 'cll_bookings' -- CREATE TABLE `cll_bookings` ( `id` int(10) unsigned NOT NULL auto_increment, `dateno` int(10) unsigned NOT NULL default '0', `date` varchar(45) NOT NULL default '', `booked` varchar(45) NOT NULL default '', `customer` varchar(45) NOT NULL default '', `paid` varchar(45) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'cll_bookings' -- -- -- Table structure for table 'cll_dates' -- CREATE TABLE `cll_dates` ( `id` int(10) unsigned NOT NULL auto_increment, `weekno` int(10) unsigned NOT NULL default '0', `commencing` varchar(45) NOT NULL default '', `price` int(10) unsigned NOT NULL default '0', `booked` varchar(45) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'cll_dates' -- INSERT INTO `cll_dates` VALUES (1,1,'Fri 04-Jan',505,'no'); INSERT INTO `cll_dates` VALUES (2,2,'Fri 11-Jan',505,'no'); -- -- Table structure for table 'competitions' -- CREATE TABLE `competitions` ( `id` int(10) unsigned NOT NULL auto_increment, `competition` varchar(45) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'competitions' -- INSERT INTO `competitions` VALUES (1,'DW1N'); INSERT INTO `competitions` VALUES (2,'DW3N'); INSERT INTO `competitions` VALUES (3,'EDF Snr Vase'); INSERT INTO `competitions` VALUES (4,'Stroud Snr Cup'); INSERT INTO `competitions` VALUES (5,'Stroud Jnr Cup'); INSERT INTO `competitions` VALUES (6,'DW Snr Cup'); INSERT INTO `competitions` VALUES (7,'DW Jnr Cup'); -- -- Table structure for table 'fixtures' -- CREATE TABLE `fixtures` ( `id` int(10) unsigned NOT NULL auto_increment, `seasonid` int(10) unsigned NOT NULL default '0', `team` varchar(45) NOT NULL default '', `type` varchar(45) NOT NULL default '', `competition` varchar(45) NOT NULL default '', `day` varchar(45) default NULL, `ko` varchar(45) NOT NULL default '', `opposition` varchar(45) NOT NULL default '', `result` varchar(45) default NULL, `homescore` varchar(45) default NULL, `oppositionscore` varchar(45) default NULL, `reportlink` varchar(45) default NULL, `venue` varchar(45) default NULL, `level` varchar(45) default NULL, PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'fixtures' -- INSERT INTO `fixtures` VALUES (1,10,'1stXV','League','D and W North 1','Sat','15:00','Bradford Upon Avon 1st XV','Drawn','10','10',NULL,'Home','Senior'); INSERT INTO `fixtures` VALUES (2,11,'1stXV','League','D and W North 1','Sat','14:30','Supermarine','Won','48','3',NULL,'Home','Senior'); INSERT INTO `fixtures` VALUES (3,1,'1stXV','Cup','D and W North 1','Sat','15:00','St Bernadettes OB','Lost','0','15',NULL,'Home','Senior'); INSERT INTO `fixtures` VALUES (4,3,'1stXV','League','D and W North 1','Sat','15:00','Swindon 2','Won','46','0',NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (5,12,'1stXV','Leage','D and W North 1','Sat','14:30','Cooper Avon Tyres','Won','24','11',NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (6,11,'2ndXV','Leage','D and W North 3','Sat','14:30','Wootton Bassett 3rd XV','Won','22','5',NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (7,12,'2ndXV','League','D and W North 3','Sat','14:30','Calne 2ndXV','Drawn','0','0',NULL,'Home','Senior'); INSERT INTO `fixtures` VALUES (8,13,'1stXV','Cup','Dorset and Wilts 1st XV Snr Cup','Sat','14:00','Westbury','Won','36','15',NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (9,13,'2ndXV','Leage','Dorset and Wilts 2nd XV Shield','Sat','14:00','Bridport 2nd XV','Lost','0','52',NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (10,14,'1stXV','League','D and W North 1','Sat','14:30','Calne','-',NULL,NULL,NULL,'Home','Senior'); INSERT INTO `fixtures` VALUES (11,14,'2ndXV','League','D and W North 3','Sat','14:30','Malborough 2','-',NULL,NULL,NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (12,15,'1stXV','Leage','D and W North 1','Sat','14:30','Cricklade','Won','26','14',NULL,'Away','Senior'); INSERT INTO `fixtures` VALUES (13,15,'2ndXV','Leage','D and W North 3','Sat','14:30','Supermarine 2nds','Won','19','5',NULL,'Home','Senior'); -- -- Table structure for table 'matchreports' -- CREATE TABLE `matchreports` ( `id` int(10) unsigned NOT NULL auto_increment, `fid` int(10) unsigned default NULL, `title` varchar(100) default NULL, `shortreport` varchar(200) default NULL, `report` text, PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'matchreports' -- INSERT INTO `matchreports` VALUES (1,2,'Supermarine are dire extreme','This is the title','rtertertr\r\ntert\r\nert\r\nertertertertertert\r\n\r\nertertertertegsdsfherhhd\r\nytjtyj\r\nryjryujfyujfnjtdyjrfyujty\r\nujry\r\njry\r\nujryujryujeyujryujtr\r\nyujry\r\njry\r\nju'); INSERT INTO `matchreports` VALUES (2,6,'Bassett Beaten','Once again we win...','rfgedg\r\nergergergerg\r\nerger\r\ngger\r\ngerg\r\nergerg\r\n\r\n\r\nregergregrgrgr\r\negreg\r\nerge\r\nrgre\r\ngre\r\ng\r\n\r\nergergregrgregegergregrg\r\nger\r\ngergerg\r\nregre\r\ngreg\r\nrg'); INSERT INTO `matchreports` VALUES (3,5,'Minety move clear','Minety ran four tries past Cooper Avon Tyres to secure a convincing away win and consolidate their position at the top of the table.','Minety’s hard-working pack laid the foundation for the win, wresting control of the scrums and providing a secure supply of ball. They also created both Minety’s first-half tries. The first was scored in the left corner by number 8 Jack Ward from a catch-and-drive following a lineout. The move that led to the second also started with a driving maul, although this time the ball was flicked out to skipper Martin Coe on the blindside wing. He was held up short of the line but supporting flanker Charlie Gawthropp was able to grab the ball and bundle over for the try in the right-hand corner.\r\n\r\nNeither try was converted and Minety also missed a penalty goal attempt. Their hosts had better luck with the boot, kicking two penalty goals to make it 6-10 in Minety’s favour at half time.\r\n\r\nHaving lost flyhalf Will Dyer with a dead leg, Minety brought on Oli Bown at flanker after the break while Ward moved to standoff.\r\n\r\nCooper Avon Tyres took the lead 15 minutes into the second half thanks to a lineout catch-and-drive of their own which was capped by a forward breaking away and diving over for a try in the corner.\r\n\r\nBehind by a single point, Minety hit back, first with a try from Ward who took scrum ball and chipped it over his opposite number. Having gathered his own kick, he chipped again, regathered and then sidestepped the fullback before touching down under the posts. He then completed his personal tour de force by kicking the conversion.\r\n\r\nThe visitors capitalised on turnover ball to seal their win. Prop Craig Smith wrenched possession from his opponents after a lineout inside Minety’s 22 and smuggled the ball back to scrumhalf Max Sparrow. He sprinted round the melee of forwards before putting away his captain, who had moved to inside centre to accommodate replacement Robin Greenway on the wing. Coe stepped inside one would-be tackler and then outside another before charging threequarters the length of the pitch for a try under the posts at the other end.\r\n\r\nWard slotted the conversion to make it 11-24 at the death.\r\n\r\nMinety are away again this Saturday, this time playing Westbury in the Dorset & Wilts Senior Cup.\r\n'); INSERT INTO `matchreports` VALUES (4,7,'Nil-All Nail-Biter','On a cold and windy November afternoon, the Minety and Calne second teams battered each other to a standstill in a bruising league encounter that saw no points scored but lacked nothing in tension or','Calne’s large pack dominated the set pieces and won the lion’s share of possession throughout the game. Their failure to turn this superiority into points came from a combination of their own poor decision-making at critical moments and their opponents’ never-say-die commitment to defence. Some of Minety’s first-up tackling could have been better but the depth and spirit of their defensive line were peerless and ensured that no one broke through all afternoon.\r\n\r\nCalne came close to scoring several times, though, especially in the first half when they even drove over the Minety line and touched down. That try was disallowed for a prior infringement, however, and Minety were able to clear their lines.\r\n\r\nThe visitors scuffed a couple of drop goal attempts but the home side’s tactical kicking was excellent. They also looked dangerous on the break, but most of their attacks were launched from deep in their own half, making it hard for them to score.\r\n\r\nPlay ebbed and flowed in the final 15 minutes but neither side could make the breakthrough and, with the light all but gone, the game ended in an honourable draw.\r\n\r\nThis Saturday, Minety seconds make a pilgrimage to the south coast to take on old friends and rivals Bridport in the Dorset & Wilts Second XV Shield.\r\n'); INSERT INTO `matchreports` VALUES (5,8,'Two for Tom (and three more for Martin!)','A solid team performance was capped with a brace of tries by scrumhalf Tom Fitzcharles and a hat-trick by skipper Martin Coe.','The game opened with Minety continuing in their recent bad habit of giving away kickable penalties in the first five minutes. Westbury were quick to seize the opportunity and having slotted the goal extended their lead to eight points thanks to a try from their inside centre who waltzed up the left flank through a series of ineptly attempted tackles.\r\n\r\nAt this point, the visitors finally got themselves sorted out and took control of the game. Forcing their way to the try line, the forwards recycled ruck ball which Fitzcharles snapped out to Ryan Dowling with an impressively long pass. Dowling fed it on to Coe at outside centre and he finished the move with a try by the corner flag.\r\n\r\nDowling was soon in action again, chipping over the defence and chasing the ball as it bobbled its way under the posts. He was unable to gather it, but Fitzcharles was following up and managed to ground the ball for the try.\r\n\r\nA successful conversion made it 8-12 but Fitzcharles still found time for another try before the break. Taking ball from the base of a scrum on Westbury’s 22, he weaved through the home defence for a try under the posts which was once more converted, making it 8-19 at the turn around.\r\n\r\nMinety started the second half with a bang. The forwards gathered the restart kick and the ball was expedited, via Tim Vaughan and Dave Church, out to captain Coe. He stepped between Westbury\'s outside centre and winger and no one could catch him as he plunged on upfield for a try.\r\n\r\nHaving slotted the conversion, Dowling chipped in later in the half with a penalty goal before Coe completed his hat-trick by running in Minety’s fifth try of the afternoon. Fed quick lineout ball, Vaughan rounded two men before putting his skipper away. Dowling’s successful conversion brought the visitors’ tally to 36 points.\r\n\r\nAs their opponents made the mistake of easing off, Westbury took the opportunity to score a consolation try but it was too late to affect the result of the tie.\r\n\r\nMinety made Tom Fitzcharles their man of match and now face Southern Counties South side Dorchester in the second round on 8 December. This Saturday, though, they return to league action with a home game against Calne.'); INSERT INTO `matchreports` VALUES (6,9,'Mismatch','Match abandoner after 25 minutes','An understrength Minety second team found themselves considerably overmatched by a fit young Bridport side in the first round of the Dorset and Wiltshire 2nd XV Shield. The game was abandoned after only 25 minutes, by which time Minety had been reduced to 12 men by injury while Bridport had already scored 52 points.\r\n\r\nThe 15 Minety players who made the 140 mile journey to Bridport were mostly forwards, earnest scrummagers to a man but somewhat inexperienced in the subtler arts of the three-quarter line. Their opponents soon discovered their weakness and lost little time in running round them on their way to a series of early tries.\r\n\r\nThe visitors’ cause was further undermined by the loss of skipper Pete Hazell with a shoulder injury and the departure of Steve Murray in an ambulance with what looked like (but, thankfully, proved subsequently not to be) a serious spinal injury.\r\n\r\nActing skipper Andy Brown warned the referee that if they lost any more players, they would have to concede the game, little realising that he would be the next to go, having badly broken his nose in a clash of heads with one of his team-mates.\r\n\r\nBridport were duly awarded the tie and consoled their visitors with the best catering and the warmest post-match hospitality they have encountered for several seasons.\r\n\r\nMinety seconds hope to return to full strength and better form as they travel away to take on Marlborough seconds in the league this Saturday.'); -- -- Table structure for table 'mrfc_players' -- CREATE TABLE `mrfc_players` ( `id` int(10) unsigned NOT NULL auto_increment, `firstname` varchar(45) default NULL, `lastname` varchar(45) default NULL, `type` varchar(45) default 'Player', `status` varchar(45) default 'Active', `telephone` varchar(45) default NULL, `mobile` varchar(45) default NULL, `email` varchar(45) default NULL, `address` text, `contactable` varchar(45) default 'Yes', `DOB` date default NULL, `displaydetails` varchar(45) default 'Yes', `username` varchar(45) default NULL, `password` varchar(45) default NULL, `details` text, `test` text, PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'mrfc_players' -- INSERT INTO `mrfc_players` VALUES (1,'Brendon','Rice','Player','Active','01666825078','07825172500','brice@netsuite.com','19 Ron Golding Close\r\nReeds Farm\r\nMalmesbury\r\nWiltshire\r\nSN16 9XR','Yes','1974-09-30','Yes','brice123','m0rgan1','ghjghj',NULL); INSERT INTO `mrfc_players` VALUES (2,'Rueben','Saunders','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'No',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (3,'Dave','Church','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'No',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (4,'Martin','Coe','Player','Active','Fat Cunt','Fat Cunt','Fat Cunt','Fat Cunt','Yes',NULL,'Yes','Fat Cunt','Fatcunt','Fat Cunt Fat Cunt Fat Cunt Fat Cunt Fat Cunt Fat Cunt Fat Cunt Fat Cunt Fat Cunt',NULL); INSERT INTO `mrfc_players` VALUES (5,'David','Hazell','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (6,'Chris','Hazell','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (7,'James','Hazell','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (8,'Peter','Hazell','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (9,'Tim','Vaughan','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'No',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (10,'Andy','Brown','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (11,'Andy','Ward','Player','Active','1234567890','123456789','andy@wardandco.co.uk','The gutter\r\nThis street\r\nPurton\r\nSwindon\r\nWilts','Yes','1952-09-30','Yes','tosser','toss3r','fgdfg\r\ndfgd\r\nfg',NULL); INSERT INTO `mrfc_players` VALUES (12,'Andy','Somers','Player','Active','01666826006','07810546341','asomers@netsuite.com','8 St Marys St\r\nMalmesbury\r\nWilts\r\nSN16 0BJ','Yes',NULL,'Yes','shifty','Sh1fty','not ann arsehole really',NULL); INSERT INTO `mrfc_players` VALUES (13,'Dominc','Rice','Player','Active','123456789','7654321','dominicr@dmrmortgages.co.uk','dfg\r\ndfgdfg\r\ndfg','Yes','2001-03-20','Yes','dom','stuff','dfgdfg\r\nfg\r\nfgfg',NULL); INSERT INTO `mrfc_players` VALUES (14,'Peter','Gifford','Player','Active','234567','3456789','TEST','jhvkjh\r\nbdfb\r\nf\r\ngbfgb\r\n','Yes','0000-00-00','Yes','giff','giff','dfgfg\r\n','Club Officer'); INSERT INTO `mrfc_players` VALUES (15,'Max','Sparrow','Player','Active','45766757','567567567','max@sparrow.com',NULL,'Yes',NULL,'Yes','sparrow123','test',NULL,'Administrator'); INSERT INTO `mrfc_players` VALUES (16,'Charlie','Gawthropp','Player','Active','1345678','75675677','charlie@somerfordheating.co.uk',NULL,'Yes',NULL,'Yes','clubber','clubb3r',NULL,NULL); INSERT INTO `mrfc_players` VALUES (17,'Mark','Holdsworth','Player','Active','567567567','5675677','markholdsworth@motorola.com',NULL,'Yes',NULL,'Yes','markymark','tosspot',NULL,NULL); INSERT INTO `mrfc_players` VALUES (18,'Jack','Ward','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (19,'Andy','Hurley','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (20,'Andy','Moran','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (21,'Craig','Smith','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (22,'Oli','Bown','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (23,'Ryan','Dowling','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (24,'Andrew','Hibbard','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (25,'Richard','Hibbard','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (26,'Sean','Richards','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (27,'Robin','Greenway','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (28,'Max','Smith','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (29,'Richard','Haines','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (30,'Will','Dyer','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (31,'Tom','Fitzcharles','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (32,'James','Bastable','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (33,'Pete','Roberts','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (34,'Aaron','Lightbody','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (35,'Ian','Illingworth','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (36,'Dave','Hicks','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (37,'Kai','Engiel','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (38,'Marco','Zuliani','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (39,'Andy','Edwards','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (40,'Miles','Murphy','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (41,'Andy','Cook','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (42,'Jason','Cole','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (43,'Kevin','Holdway','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (44,'James','Tweedale','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (45,'Steve','Murray','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (46,'Lee','Paterson','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (47,'Chris','Young','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (48,'Phil','Cooke','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (49,'James','Stuart','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (50,'Matt','Oliver','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (51,'Will','Howse','Player','Active',NULL,NULL,NULL,NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); INSERT INTO `mrfc_players` VALUES (52,'Albert','Weasel','Player','Active','01666 666666',NULL,'weasel@weaselnet.co.uk',NULL,'Yes',NULL,'Yes',NULL,NULL,NULL,NULL); -- -- Table structure for table 'officerroles' -- CREATE TABLE `officerroles` ( `id` int(10) unsigned NOT NULL auto_increment, `role` varchar(100) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'officerroles' -- INSERT INTO `officerroles` VALUES (1,'President'); INSERT INTO `officerroles` VALUES (2,'Chairman'); INSERT INTO `officerroles` VALUES (3,'Club Coach'); INSERT INTO `officerroles` VALUES (4,'Club Captain'); INSERT INTO `officerroles` VALUES (5,'1st Team Vice Captain'); INSERT INTO `officerroles` VALUES (6,'2nd Team Captain'); INSERT INTO `officerroles` VALUES (7,'2nd Team Vice Captain'); INSERT INTO `officerroles` VALUES (8,'Junior Section Rep'); INSERT INTO `officerroles` VALUES (9,'Fixture Secretary'); INSERT INTO `officerroles` VALUES (10,'Secretary'); INSERT INTO `officerroles` VALUES (11,'Social Secretary'); INSERT INTO `officerroles` VALUES (12,'MPFA Rep'); INSERT INTO `officerroles` VALUES (13,'Treasurer'); INSERT INTO `officerroles` VALUES (14,'Stroud and District Rep'); INSERT INTO `officerroles` VALUES (15,'Publicity Officer'); INSERT INTO `officerroles` VALUES (16,'Fundraising Officer'); INSERT INTO `officerroles` VALUES (17,'Subscription Officer'); INSERT INTO `officerroles` VALUES (18,'Vets Captain'); INSERT INTO `officerroles` VALUES (19,'Vets Vice Captain'); INSERT INTO `officerroles` VALUES (20,'Tour Organiser'); INSERT INTO `officerroles` VALUES (21,'Groundsman'); -- -- Table structure for table 'officers' -- CREATE TABLE `officers` ( `id` int(10) unsigned NOT NULL auto_increment, `season` varchar(45) NOT NULL default '0', `position` varchar(100) NOT NULL default '', `firstname` varchar(45) NOT NULL default '', `lastname` varchar(45) NOT NULL default '', `contact` varchar(45) NOT NULL default '', `email` varchar(45) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'officers' -- INSERT INTO `officers` VALUES (1,'2007-2008','President','Richard','Pickford','-','-'); INSERT INTO `officers` VALUES (2,'2007-2008','Chairman','Sean','Richards','-','-'); INSERT INTO `officers` VALUES (3,'2007-2008','Club Coach','Andy','Ward','-','-'); INSERT INTO `officers` VALUES (4,'2007-2008','Club Captain','Martin','Coe','-','-'); INSERT INTO `officers` VALUES (5,'2007-2008','1st Team Vice Captain','David','Hazell','-','-'); INSERT INTO `officers` VALUES (6,'2006-2007','President','Richard','Pickford','-','-'); INSERT INTO `officers` VALUES (7,'2006-2007','Chairman','Sean','Richards','-','-'); INSERT INTO `officers` VALUES (8,'2006-2007','Club Coach','Andy','Ward','-','-'); INSERT INTO `officers` VALUES (9,'2006-2007','Club Captain','Martin','Coe','-','-'); INSERT INTO `officers` VALUES (10,'2005-2006','Club Captain','Charlie','Gawthropp','-','-'); INSERT INTO `officers` VALUES (11,'2007-2008','Publicity Officer','Jack','Dog','01666 666666','dog@bone.net'); -- -- Table structure for table 'positions' -- CREATE TABLE `positions` ( `id` int(10) unsigned NOT NULL auto_increment, `posnum` int(10) unsigned default NULL, `pos` varchar(45) default NULL, PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'positions' -- INSERT INTO `positions` VALUES (1,1,'Loose Head Prop'); INSERT INTO `positions` VALUES (2,2,'Hooker'); INSERT INTO `positions` VALUES (3,3,'Tight Head Prop'); INSERT INTO `positions` VALUES (4,4,'Second Row'); INSERT INTO `positions` VALUES (5,5,'Second Row'); INSERT INTO `positions` VALUES (6,6,'Open Side Flanker'); INSERT INTO `positions` VALUES (7,7,'Blind Side Flanker'); INSERT INTO `positions` VALUES (8,8,'Number 8'); INSERT INTO `positions` VALUES (9,9,'Scrum Half'); INSERT INTO `positions` VALUES (10,10,'Fly Half'); INSERT INTO `positions` VALUES (11,11,'Left Wing'); INSERT INTO `positions` VALUES (12,12,'Inside Centre'); INSERT INTO `positions` VALUES (13,13,'Outside Centre'); INSERT INTO `positions` VALUES (14,14,'Right Wing'); INSERT INTO `positions` VALUES (15,15,'Full Back'); INSERT INTO `positions` VALUES (16,16,'Sub 1'); INSERT INTO `positions` VALUES (17,17,'Sub 2'); INSERT INTO `positions` VALUES (18,18,'Sub 3'); INSERT INTO `positions` VALUES (19,19,'Sub 4'); INSERT INTO `positions` VALUES (20,20,'Sub 5'); INSERT INTO `positions` VALUES (21,21,'Sub 6'); INSERT INTO `positions` VALUES (22,22,'Sub 7'); INSERT INTO `positions` VALUES (23,23,'Sub 8'); INSERT INTO `positions` VALUES (24,24,'Sub 9'); INSERT INTO `positions` VALUES (25,25,'Sub 10'); -- -- Table structure for table 'season' -- CREATE TABLE `season` ( `id` int(10) unsigned NOT NULL auto_increment, `month` varchar(45) default NULL, `monthnum` int(10) unsigned default NULL, `date` int(10) unsigned default NULL, `season` varchar(45) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'season' -- INSERT INTO `season` VALUES (1,'Sep',1,1,'2007-2008'); INSERT INTO `season` VALUES (2,'Sep',1,8,'2007-2008'); INSERT INTO `season` VALUES (3,'Sep',1,15,'2007-2008'); INSERT INTO `season` VALUES (4,'Sep',1,16,'2007-2008'); INSERT INTO `season` VALUES (5,'Sep',1,22,'2007-2008'); INSERT INTO `season` VALUES (6,'Sep',1,29,'2007-2008'); INSERT INTO `season` VALUES (7,'Oct',2,6,'2007-2008'); INSERT INTO `season` VALUES (8,'Oct',2,13,'2007-2008'); INSERT INTO `season` VALUES (9,'Oct',2,20,'2007-2008'); INSERT INTO `season` VALUES (10,'Oct',2,27,'2007-2008'); INSERT INTO `season` VALUES (11,'Nov',3,3,'2007-2008'); INSERT INTO `season` VALUES (12,'Nov',3,10,'2007-2008'); INSERT INTO `season` VALUES (13,'Nov',3,17,'2007-2008'); INSERT INTO `season` VALUES (14,'Nov',3,24,'2007-2008'); INSERT INTO `season` VALUES (15,'Dec',4,1,'2007-2008'); INSERT INTO `season` VALUES (16,'Dec',4,8,'2007-2008'); INSERT INTO `season` VALUES (17,'Dec',4,15,'2007-2008'); INSERT INTO `season` VALUES (18,'Dec',4,22,'2007-2008'); INSERT INTO `season` VALUES (19,'Dec',4,29,'2007-2008'); INSERT INTO `season` VALUES (20,'Jan',5,5,'2007-2008'); INSERT INTO `season` VALUES (21,'Jan',5,12,'2007-2008'); INSERT INTO `season` VALUES (22,'Jan',5,19,'2007-2008'); INSERT INTO `season` VALUES (23,'Jan',5,26,'2007-2008'); INSERT INTO `season` VALUES (24,'Feb',6,2,'2007-2008'); INSERT INTO `season` VALUES (25,'Feb',6,9,'2007-2008'); INSERT INTO `season` VALUES (26,'Feb',6,17,'2007-2008'); INSERT INTO `season` VALUES (27,'Feb',6,23,'2007-2008'); INSERT INTO `season` VALUES (28,'Mar',7,1,'2007-2008'); INSERT INTO `season` VALUES (29,'Mar',7,8,'2007-2008'); INSERT INTO `season` VALUES (30,'Mar',7,9,'2007-2008'); INSERT INTO `season` VALUES (31,'Mar',7,15,'2007-2008'); INSERT INTO `season` VALUES (32,'Mar',7,22,'2007-2008'); INSERT INTO `season` VALUES (33,'Mar',7,29,'2007-2008'); INSERT INTO `season` VALUES (34,'Apr',8,5,'2007-2008'); INSERT INTO `season` VALUES (35,'Apr',8,12,'2007-2008'); INSERT INTO `season` VALUES (36,'Apr',8,19,'2007-2008'); INSERT INTO `season` VALUES (37,'Apr',8,26,'2007-2008'); INSERT INTO `season` VALUES (38,'May',9,4,'2007-2008'); INSERT INTO `season` VALUES (39,'May',9,5,'2007-2008'); INSERT INTO `season` VALUES (40,'Sep',1,1,'2006-2007'); INSERT INTO `season` VALUES (41,'Sep',1,1,'2005-2006'); INSERT INTO `season` VALUES (42,'Sep',1,1,'2004-2005'); INSERT INTO `season` VALUES (43,'Sep',1,1,'2003-2004'); INSERT INTO `season` VALUES (44,'Sep',1,1,'2002-2003'); INSERT INTO `season` VALUES (45,'Sep',1,1,'2001-2002'); INSERT INTO `season` VALUES (46,'Sep',1,1,'2000-2001'); INSERT INTO `season` VALUES (47,'Sep',1,1,'1999-2000'); INSERT INTO `season` VALUES (48,'Sep',1,1,'1998-1999'); INSERT INTO `season` VALUES (49,'Sep',1,1,'1997-1998'); INSERT INTO `season` VALUES (50,'Sep',1,1,'1996-1997'); INSERT INTO `season` VALUES (51,'Sep',1,1,'1995-1996'); INSERT INTO `season` VALUES (52,'Sep',1,1,'1994-1995'); INSERT INTO `season` VALUES (53,'Sep',1,1,'1993-1994'); INSERT INTO `season` VALUES (54,'Sep',1,1,'1992-1993'); INSERT INTO `season` VALUES (55,'Sep',1,1,'1991-1992'); INSERT INTO `season` VALUES (56,'Sep',1,1,'1990-1991'); INSERT INTO `season` VALUES (57,'Sep',1,1,'1989-1990'); INSERT INTO `season` VALUES (58,'Sep',1,1,'1988-1989'); INSERT INTO `season` VALUES (59,'Sep',1,1,'1987-1988'); INSERT INTO `season` VALUES (60,'Sep',1,1,'1986-1987'); INSERT INTO `season` VALUES (61,'Sep',1,1,'1985-1986'); INSERT INTO `season` VALUES (62,'Sep',1,1,'1984-1985'); INSERT INTO `season` VALUES (63,'Sep',1,1,'1983-1984'); INSERT INTO `season` VALUES (64,'Sep',1,1,'1982-1983'); INSERT INTO `season` VALUES (65,'Sep',1,1,'1981-1982'); INSERT INTO `season` VALUES (66,'Sep',1,1,'1980-1981'); INSERT INTO `season` VALUES (67,'Sep',1,1,'1979-1980'); INSERT INTO `season` VALUES (68,'Sep',1,1,'1978-1979'); INSERT INTO `season` VALUES (69,'Sep',1,1,'1977-1978'); INSERT INTO `season` VALUES (70,'Sep',1,1,'1976-1977'); INSERT INTO `season` VALUES (71,'Sep',1,1,'1975-1976'); INSERT INTO `season` VALUES (72,'Sep',1,1,'1974-1975'); INSERT INTO `season` VALUES (73,'March',3,24,'2007-08'); INSERT INTO `season` VALUES (74,'Sep',1,30,'2008-2009'); -- -- Table structure for table 'teams' -- CREATE TABLE `teams` ( `id` int(10) unsigned NOT NULL auto_increment, `fixtureid` int(10) unsigned NOT NULL default '0', `playerid` int(10) unsigned NOT NULL default '0', `position` int(10) unsigned NOT NULL default '0', `tries` int(11) default '0', `penalties` int(11) default '0', `dropgoals` int(11) default '0', `conversions` int(11) default '0', `totalpoints` int(11) default '0', `commants` text, `yellowcards` int(10) unsigned default '0', `redcards` int(10) unsigned default '0', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- -- Dumping data for table 'teams' -- INSERT INTO `teams` VALUES (1,2,1,2,0,0,0,0,0,NULL,0,5); INSERT INTO `teams` VALUES (2,2,2,15,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (4,2,4,11,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (5,2,5,4,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (6,2,6,5,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (7,2,13,1,0,0,0,0,0,NULL,0,5); INSERT INTO `teams` VALUES (8,2,10,3,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (9,2,16,6,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (10,2,8,7,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (11,2,17,8,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (12,2,15,9,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (13,2,12,10,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (14,2,11,12,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (15,2,14,13,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (16,2,9,14,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (17,2,3,16,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (18,6,1,2,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (19,4,1,9,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (20,5,19,1,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (21,5,20,2,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (22,5,32,3,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (23,5,5,4,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (24,5,16,6,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (25,5,18,8,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (26,5,15,9,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (27,5,21,5,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (28,5,28,7,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (29,5,30,10,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (30,5,2,15,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (31,5,4,11,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (32,5,23,14,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (33,5,3,12,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (34,5,22,16,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (35,5,27,17,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (36,7,1,2,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (37,5,49,18,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (38,7,19,1,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (39,7,34,3,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (40,8,19,1,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (41,8,20,2,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (42,8,32,3,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (43,8,17,4,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (44,8,29,5,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (45,8,16,6,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (46,8,22,7,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (47,8,18,8,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (48,8,9,10,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (49,8,23,11,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (50,8,3,12,1,0,0,2,9,NULL,1,0); INSERT INTO `teams` VALUES (51,8,2,15,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (52,8,4,14,3,0,0,0,15,NULL,0,0); INSERT INTO `teams` VALUES (53,8,31,9,3,0,0,0,15,NULL,1,1); INSERT INTO `teams` VALUES (54,9,39,4,2,0,0,0,10,NULL,1,0); INSERT INTO `teams` VALUES (55,8,35,16,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (56,13,1,7,2,0,0,0,10,NULL,1,0); INSERT INTO `teams` VALUES (57,13,1,6,3,2,1,2,28,NULL,0,1); INSERT INTO `teams` VALUES (58,12,19,1,2,0,1,0,13,NULL,1,0); INSERT INTO `teams` VALUES (59,12,20,2,0,0,0,0,0,NULL,0,0); INSERT INTO `teams` VALUES (60,3,19,2,2,0,1,1,15,NULL,1,0);