NLEjngbE

1DROP TABLE IF EXISTS `settings`;
2CREATE TABLE `settings`  (
3  `id` int(11) NOT NULL,
4  `name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
5  `value` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
6  UNIQUE INDEX `id`(`id`) USING BTREE
7) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
8
9-- ----------------------------
10-- Records of settings
11-- ----------------------------
12INSERT INTO `settings` VALUES (1, 'Titlu', 'Metin2');
13INSERT INTO `settings` VALUES (2, 'Cate noutati se afiseaza pe pagina?', '5');
14INSERT INTO `settings` VALUES (3, 'Modul Serverului', 'PvP');
15INSERT INTO `settings` VALUES (4, 'Link! Descarcare Client Web', '#');
16INSERT INTO `settings` VALUES (5, 'Link! Descarcare Client Web', '#');
17INSERT INTO `settings` VALUES (8, 'Inregistrare activa?', 'da');
18
19SET FOREIGN_KEY_CHECKS = 1;
20
21DROP TABLE IF EXISTS `news`;
22CREATE TABLE `news`  (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `title` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
25  `full_content` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
26  `date_added` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
27  PRIMARY KEY (`id`) USING BTREE
28) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;