· 8 years ago · Apr 20, 2018, 07:48 AM
1--
2-- Database: `in1010gp30`
3--
4CREATE DATABASE `in1010gp30` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
5USE `in1010gp30`;
6
7-- --------------------------------------------------------
8
9--
10-- Table structure for table `SCCategories`
11--
12
13CREATE TABLE IF NOT EXISTS `SCCategories` (
14 `catId` int(11) NOT NULL AUTO_INCREMENT,
15 `catName` varchar(50) NOT NULL,
16 `catDesc` varchar(255) NOT NULL,
17 PRIMARY KEY (`catId`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
19
20--
21-- Dumping data for table `SCCategories`
22--
23
24INSERT INTO `SCCategories` (`catId`, `catName`, `catDesc`) VALUES
25(1, 'General', 'Welcome to the general forum, here you can discuss anything you like! Though our site is intended for users of many different ages and backgrounds, so keep your posts clean.'),
26(2, 'Housing', 'Any comments, complaints, suggestions or praise about housing provided by Saltway Council belongs here!'),
27(3, 'Council tax & benefits', 'You can talk about tax rates, benefits and also enquire about further information on these topics here.'),
28(4, 'Leisure and Culture', 'Here you can discuss your favourite places to go, things to do, or ask about opening times for facilities and events in your area.'),
29(5, 'Planning', 'Here you can enquire about planning permission or for more information about construction or demelition of buildings in your area.');
30
31-- --------------------------------------------------------
32
33--
34-- Table structure for table `SCNews`
35--
36
37CREATE TABLE IF NOT EXISTS `SCNews` (
38 `serviceID` smallint(6) NOT NULL AUTO_INCREMENT,
39 `serviceName` varchar(30) NOT NULL,
40 `email` varchar(255) NOT NULL,
41 PRIMARY KEY (`serviceID`)
42) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
43
44--
45-- Dumping data for table `SCNews`
46--
47
48INSERT INTO `SCNews` (`serviceID`, `serviceName`, `email`) VALUES
49(50, 'atherton', 'manos@constantinides.me'),
50(49, 'atherton', 'manos@constantinides.me'),
51(48, 'freedom', 'manos@constantinides.me'),
52(47, 'freedom', 'manos@constantinides.me'),
53(46, 'freedom', 'manos@constantinides.me');
54
55-- --------------------------------------------------------
56
57--
58-- Table structure for table `SCReply`
59--
60
61CREATE TABLE IF NOT EXISTS `SCReply` (
62 `idNumber` smallint(6) NOT NULL AUTO_INCREMENT,
63 `content` text,
64 `userID` int(10) DEFAULT NULL,
65 `threadNumber` smallint(6) DEFAULT NULL,
66 PRIMARY KEY (`idNumber`)
67) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
68
69--
70-- Dumping data for table `SCReply`
71--
72
73INSERT INTO `SCReply` (`idNumber`, `content`, `userID`, `threadNumber`) VALUES
74(1, 'This is another test.', 2, 3),
75(2, 'Transport Secretary Justine Greening will announce a delay in the final decision on the project next week in order to consider whether about £500m could be used for a 1.5 mile tunnel.\r\n\r\nOpponents say the planned route crosses an area of outstanding natural beauty.\r\n\r\nThe Campaign to Protect Rural England has welcomed plans for more tunnelling.', 2, 5),
76(3, 'roject next week in order to consider whether about �500m could be used for a 1.5 mile tunnel. Opponents say the planned route crosses an area of outstanding natural beauty. The Campaign to Protect Rural England', 3, 5),
77(4, 'roject next week in order to consider whether about �500m could be used for a 1.5 mile tunnel. Opponents say the planned route crosses an area of outstanding natural beauty. The Campaign to Protect Rural England', 3, 5),
78(5, '\r\ntandard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s ', 3, 5),
79(6, 'loremipsum-it!', 3, 6),
80(7, 'test it test it test it test it test it test it ', 3, 4);
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `SCThread`
86--
87
88CREATE TABLE IF NOT EXISTS `SCThread` (
89 `idNumber` smallint(6) NOT NULL AUTO_INCREMENT,
90 `title` varchar(50) DEFAULT NULL,
91 `content` text,
92 `catId` int(11) DEFAULT NULL,
93 `userId` int(10) DEFAULT NULL,
94 PRIMARY KEY (`idNumber`)
95) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
96
97--
98-- Dumping data for table `SCThread`
99--
100
101INSERT INTO `SCThread` (`idNumber`, `title`, `content`, `catId`, `userId`) VALUES
102(4, 'Emmanuel Test', 'This is my test', 1, 1),
103(3, 'Test Thread', 'This is a test.', 2, 2),
104(5, 'Meeting Library', 'industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMak', 3, 3),
105(6, 'Another Test', 'Lorem ipsum test!', 4, 1),
106(7, 'Aris', 'Aris Super3', 5, 3),
107(19, 'Meeting 2', 'weeewrw', 3, 3),
108(18, 'sadsad', 'sadasd', 1, 3);
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `SCUsers`
114--
115
116CREATE TABLE IF NOT EXISTS `SCUsers` (
117 `userId` int(10) NOT NULL AUTO_INCREMENT,
118 `fName` varchar(20) DEFAULT NULL,
119 `sName` varchar(20) DEFAULT NULL,
120 `houseNumber` varchar(20) DEFAULT NULL,
121 `street` varchar(50) DEFAULT NULL,
122 `county` varchar(50) DEFAULT NULL,
123 `country` varchar(50) DEFAULT NULL,
124 `postCode` varchar(15) DEFAULT NULL,
125 `phone` varchar(15) DEFAULT NULL,
126 `mobile` varchar(15) DEFAULT NULL,
127 `email` varchar(255) NOT NULL,
128 `password` varchar(30) DEFAULT NULL,
129 PRIMARY KEY (`userId`)
130) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
131
132--
133-- Dumping data for table `SCUsers`
134--
135
136INSERT INTO `SCUsers` (`userId`, `fName`, `sName`, `houseNumber`, `street`, `county`, `country`, `postCode`, `phone`, `mobile`, `email`, `password`) VALUES
137(1, 'Emmanouil', 'Konstantinidis', '12', 'Belitha Villas', 'Angel', 'United Kingdom', 'N1 1PD', '03213211230', '23402384123', 'manolisc@gmail.com', 'in1010'),
138(2, 'Anthony', 'Hall', '29', 'Graham Street', 'London', 'UK', 'N1 8LA', '901984281871', '746723627361', 'anthonyhall1992@hotmail.co.uk', 'reading1'),
139(3, 'Manos', 'Constantinides', '', '', '', '', '', '', '', 'manos@constantinides.me', 'in1010');
140
141-- --------------------------------------------------------
142
143--
144-- Table structure for table `SCWaste`
145--
146
147CREATE TABLE IF NOT EXISTS `SCWaste` (
148 `wasteID` smallint(6) NOT NULL AUTO_INCREMENT,
149 `postCode` varchar(15) DEFAULT NULL,
150 `collectionDate` text,
151 PRIMARY KEY (`wasteID`)
152) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
153
154--
155-- Dumping data for table `SCWaste`
156--
157
158INSERT INTO `SCWaste` (`wasteID`, `postCode`, `collectionDate`) VALUES
159(1, 'RN03', 'Mondays.<br />Every second Monday beginning from 3rd October 2011.'),
160(2, 'CS22', 'Tuesdays.<br />Every second Tuesday beginning from 4rd October 2011.'),
161(3, 'RP16', 'Wednesdays.<br />Every second Wednesday beginning from 5rd October 2011.'),
162(4, 'PQ12', 'Thursdays.<br />Every second Thursday beginning from 6rd October 2011.'),
163(5, 'LX09', 'Fridays.<br />Every second Friday beginning from 7rd October 2011.');