526 lines
22 KiB
SQL
526 lines
22 KiB
SQL
-- --------------------------------------------------------
|
|
|
|
-- #snivystuff : Banners
|
|
CREATE TABLE `PREFIX_banners` (
|
|
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
|
|
`link` varchar(255) NOT NULL DEFAULT '',
|
|
`path` varchar(127) NOT NULL DEFAULT '',
|
|
`custom` tinyint(1) NOT NULL DEFAULT '0',
|
|
`version` smallint(6) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET COLLATE=KU_COLLATION;
|
|
|
|
-- #snivystuff : Custom styles
|
|
CREATE TABLE `PREFIX_customstyles` (
|
|
`id` smallint(6) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL DEFAULT '',
|
|
`owner` varchar(255) NOT NULL DEFAULT '',
|
|
`version` smallint(11) NOT NULL DEFAULT '0',
|
|
`temporary` tinyint(1) NOT NULL DEFAULT '1',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `id` (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET COLLATE=KU_COLLATION;
|
|
|
|
|
|
--
|
|
-- Table structure for table `ads`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_ads` (
|
|
`id` smallint(1) unsigned NOT NULL DEFAULT '0',
|
|
`position` varchar(3) NOT NULL DEFAULT '0',
|
|
`disp` tinyint(1) NOT NULL DEFAULT '0',
|
|
`boards` varchar(255) NOT NULL DEFAULT '',
|
|
`code` text NOT NULL
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `announcements`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_announcements` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`parentid` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`subject` varchar(255) NOT NULL DEFAULT '',
|
|
`postedat` int(20) NOT NULL DEFAULT '0',
|
|
`postedby` varchar(75) NOT NULL DEFAULT '',
|
|
`message` text NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `banlist`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_banlist` (
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
`type` tinyint(1) NOT NULL DEFAULT '0',
|
|
`expired` tinyint(1) NOT NULL DEFAULT '0',
|
|
`allowread` tinyint(1) NOT NULL DEFAULT '1',
|
|
`ip` varchar(88) NOT NULL DEFAULT '',
|
|
`ipmd5` char(32) NOT NULL DEFAULT '',
|
|
`globalban` tinyint(1) NOT NULL DEFAULT '0',
|
|
`boards` varchar(255) NOT NULL DEFAULT '',
|
|
`by` varchar(75) NOT NULL DEFAULT '',
|
|
`at` int(20) NOT NULL DEFAULT '0',
|
|
`until` int(20) NOT NULL DEFAULT '0',
|
|
`reason` text,
|
|
`staffnote` text,
|
|
`appeal` text,
|
|
`appealat` int(20) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `bannedhashes`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_bannedhashes` (
|
|
`id` int(10) NOT NULL AUTO_INCREMENT,
|
|
`md5` varchar(255) NOT NULL DEFAULT '',
|
|
`bantime` int(10) NOT NULL DEFAULT '0',
|
|
`description` text,
|
|
UNIQUE KEY `id` (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `blotter`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_blotter` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`important` tinyint(1) NOT NULL DEFAULT '0',
|
|
`at` int(20) NOT NULL DEFAULT '0',
|
|
`message` text NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `boards`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_boards` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`order` tinyint(5) NOT NULL DEFAULT '0',
|
|
`name` varchar(75) NOT NULL DEFAULT '',
|
|
`start` int(10) unsigned NOT NULL DEFAULT '1',
|
|
`maxfiles` TINYINT(3) UNSIGNED NOT NULL DEFAULT '4',
|
|
`desc` varchar(75) NOT NULL DEFAULT '',
|
|
`image` varchar(255) NOT NULL DEFAULT '',
|
|
`section` tinyint(2) NOT NULL DEFAULT '0',
|
|
`maximagesize` int(20) NOT NULL DEFAULT '4096000',
|
|
`maxpages` int(20) NOT NULL DEFAULT '11',
|
|
`maxage` int(20) NOT NULL DEFAULT '0',
|
|
`markpage` tinyint(4) NOT NULL DEFAULT '0',
|
|
`maxreplies` int(5) NOT NULL DEFAULT '500',
|
|
`messagelength` int(10) NOT NULL DEFAULT '8192',
|
|
`createdon` int(20) NOT NULL DEFAULT '0',
|
|
`locked` tinyint(1) NOT NULL DEFAULT '0',
|
|
`includeheader` text,
|
|
`redirecttothread` tinyint(1) NOT NULL DEFAULT '0',
|
|
`anonymous` varchar(255) NOT NULL DEFAULT 'Аноним',
|
|
`forcedanon` tinyint(1) NOT NULL DEFAULT '0',
|
|
`embeds_allowed` varchar(255) NOT NULL DEFAULT 'you,vim,cob',
|
|
`trial` tinyint(1) NOT NULL DEFAULT '0',
|
|
`popular` tinyint(1) NOT NULL DEFAULT '0',
|
|
`defaultstyle` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
|
|
`locale` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT 'ru',
|
|
`showid` tinyint(1) NOT NULL DEFAULT '0',
|
|
`compactlist` tinyint(1) NOT NULL DEFAULT '0',
|
|
`enablereporting` tinyint(1) NOT NULL DEFAULT '1',
|
|
`enablecaptcha` tinyint(1) NOT NULL DEFAULT '1',
|
|
`enablenofile` tinyint(1) NOT NULL DEFAULT '0',
|
|
`enablearchiving` tinyint(1) NOT NULL DEFAULT '0',
|
|
`enablecatalog` tinyint(1) NOT NULL DEFAULT '1',
|
|
`loadbalanceurl` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
|
|
`loadbalancepassword` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
|
|
`balls` tinyint(1) NOT NULL DEFAULT '0',
|
|
`dice` tinyint(1) NOT NULL DEFAULT '0',
|
|
`useragent` tinyint(1) NOT NULL DEFAULT '0',
|
|
`duplication` tinyint(1) NOT NULL DEFAULT '0',
|
|
`opmod` tinyint(1) NOT NULL DEFAULT '0',
|
|
`hidden` tinyint(1) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET COLLATE=KU_COLLATION;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `board_filetypes`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_board_filetypes` (
|
|
`boardid` tinyint(5) NOT NULL DEFAULT '0',
|
|
`typeid` mediumint(5) NOT NULL DEFAULT '0'
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `embeds`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_embeds` (
|
|
`id` tinyint(5) unsigned NOT NULL auto_increment,
|
|
`filetype` varchar(3) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`videourl` varchar(510) NOT NULL,
|
|
`timeprefix` varchar(10) NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET COLLATE=KU_COLLATION;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `events`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_events` (
|
|
`name` varchar(255) NOT NULL DEFAULT '',
|
|
`at` int(20) NOT NULL DEFAULT '0'
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `filetypes`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_filetypes` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`filetype` varchar(255) NOT NULL DEFAULT '',
|
|
`mime` varchar(255) NOT NULL DEFAULT '',
|
|
`image` varchar(255) NOT NULL DEFAULT '',
|
|
`image_w` int(7) NOT NULL DEFAULT '0',
|
|
`image_h` int(7) NOT NULL DEFAULT '0',
|
|
`force_thumb` int(1) NOT NULL DEFAULT '1',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `front`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_front` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`page` smallint(1) unsigned NOT NULL DEFAULT '0',
|
|
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`subject` varchar(255) NOT NULL DEFAULT '',
|
|
`message` text,
|
|
`timestamp` int(20) NOT NULL DEFAULT '0',
|
|
`poster` varchar(75) NOT NULL DEFAULT '',
|
|
`email` varchar(255) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `loginattempts`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_loginattempts` (
|
|
`username` varchar(255) NOT NULL DEFAULT '',
|
|
`ip` varchar(45) NOT NULL DEFAULT '',
|
|
`timestamp` int(20) NOT NULL DEFAULT '0'
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `modlog`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_modlog` (
|
|
`entry` text NOT NULL,
|
|
`user` varchar(255) NOT NULL DEFAULT '',
|
|
`category` tinyint(2) NOT NULL DEFAULT '0',
|
|
`timestamp` int(20) NOT NULL DEFAULT '0',
|
|
`boards` VARCHAR(50) NULL DEFAULT NULL,
|
|
`id` VARCHAR(50) NULL DEFAULT NULL
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `module_settings`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_module_settings` (
|
|
`module` varchar(255) NOT NULL DEFAULT '',
|
|
`key` varchar(255) NOT NULL DEFAULT '',
|
|
`value` text character set KU_DBCHARSET collate KU_COLLATION NOT NULL,
|
|
`type` varchar(255) NOT NULL DEFAULT 'string'
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `posts`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_posts` (
|
|
`id` int(10) unsigned NOT NULL,
|
|
`boardid` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`parentid` int(10) unsigned NOT NULL DEFAULT '0',
|
|
`name` varchar(255) NOT NULL DEFAULT '',
|
|
`tripcode` varchar(30) NOT NULL DEFAULT '',
|
|
`email` varchar(255) NOT NULL DEFAULT '',
|
|
`subject` varchar(255) NOT NULL DEFAULT '',
|
|
`message` text,
|
|
`password` varchar(255) NOT NULL DEFAULT '',
|
|
`ip` varchar(88) NOT NULL DEFAULT '',
|
|
`ipmd5` char(32) NOT NULL DEFAULT '',
|
|
`tag` varchar(5) NOT NULL DEFAULT '',
|
|
`timestamp` int(20) unsigned NOT NULL DEFAULT '0',
|
|
`stickied` tinyint(1) NOT NULL DEFAULT '0',
|
|
`locked` tinyint(1) NOT NULL DEFAULT '0',
|
|
`posterauthority` tinyint(1) NOT NULL DEFAULT '0',
|
|
`reviewed` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
|
`deleted_timestamp` int(20) NOT NULL DEFAULT '0',
|
|
`IS_DELETED` tinyint(1) NOT NULL DEFAULT '0',
|
|
`bumped` int(20) unsigned NOT NULL DEFAULT '0',
|
|
`country` varchar(10) NOT NULL DEFAULT 'xx',
|
|
`by_new_user` TINYINT(1) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`boardid`,`id`),
|
|
KEY `parentid` (`parentid`),
|
|
KEY `bumped` (`bumped`),
|
|
KEY `stickied` (`stickied`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET COLLATE=KU_COLLATION;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `files`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_files` (
|
|
`file_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`post_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
|
|
`boardid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
|
|
`file` varchar(50) NOT NULL DEFAULT '',
|
|
`file_md5` char(32) NOT NULL DEFAULT '',
|
|
`file_type` varchar(20) NOT NULL DEFAULT '',
|
|
`file_original` varchar(255) NOT NULL DEFAULT '',
|
|
`file_size` int(20) NOT NULL DEFAULT '0',
|
|
`file_size_formatted` varchar(75) NOT NULL DEFAULT '',
|
|
`image_w` smallint(5) NOT NULL DEFAULT '0',
|
|
`image_h` smallint(5) NOT NULL DEFAULT '0',
|
|
`thumb_w` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
|
|
`thumb_h` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
|
|
`spoiler` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`file_id`),
|
|
INDEX `file_md5` (`file_md5`),
|
|
INDEX `file_id` (`file_id`),
|
|
INDEX `post_id` (`post_id`)
|
|
)
|
|
DEFAULT CHARSET=KU_DBCHARSET COLLATE=KU_COLLATION AUTO_INCREMENT=1;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- View `postembeds`
|
|
--
|
|
|
|
CREATE OR REPLACE VIEW `PREFIX_postembeds`
|
|
AS SELECT
|
|
`PREFIX_posts`.`id` AS `id`,
|
|
`PREFIX_posts`.`boardid` AS `boardid`,
|
|
`PREFIX_posts`.`parentid` AS `parentid`,
|
|
`PREFIX_posts`.`name` AS `name`,
|
|
`PREFIX_posts`.`tripcode` AS `tripcode`,
|
|
`PREFIX_posts`.`email` AS `email`,
|
|
`PREFIX_posts`.`subject` AS `subject`,
|
|
`PREFIX_posts`.`message` AS `message`,
|
|
`PREFIX_posts`.`password` AS `password`,
|
|
`PREFIX_posts`.`ip` AS `ip`,
|
|
`PREFIX_posts`.`ipmd5` AS `ipmd5`,
|
|
`PREFIX_posts`.`tag` AS `tag`,
|
|
`PREFIX_posts`.`timestamp` AS `timestamp`,
|
|
`PREFIX_posts`.`stickied` AS `stickied`,
|
|
`PREFIX_posts`.`locked` AS `locked`,
|
|
`PREFIX_posts`.`posterauthority` AS `posterauthority`,
|
|
`PREFIX_posts`.`reviewed` AS `reviewed`,
|
|
`PREFIX_posts`.`deleted_timestamp` AS `deleted_timestamp`,
|
|
`PREFIX_posts`.`IS_DELETED` AS `IS_DELETED`,
|
|
`PREFIX_posts`.`bumped` AS `bumped`,
|
|
`PREFIX_posts`.`country` AS `country`,
|
|
`PREFIX_files`.`file` AS `file`,
|
|
`PREFIX_files`.`file_id` AS `file_id`,
|
|
`PREFIX_files`.`file_md5` AS `file_md5`,
|
|
`PREFIX_files`.`file_type` AS `file_type`,
|
|
`PREFIX_files`.`file_original` AS `file_original`,
|
|
`PREFIX_files`.`file_size` AS `file_size`,
|
|
`PREFIX_files`.`file_size_formatted` AS `file_size_formatted`,
|
|
`PREFIX_files`.`image_w` AS `image_w`,
|
|
`PREFIX_files`.`image_h` AS `image_h`,
|
|
`PREFIX_files`.`thumb_w` AS `thumb_w`,
|
|
`PREFIX_files`.`thumb_h` AS `thumb_h`,
|
|
`PREFIX_files`.`spoiler` AS `spoiler`
|
|
FROM (
|
|
`PREFIX_posts` LEFT JOIN `PREFIX_files` ON (
|
|
(
|
|
(`PREFIX_files`.`post_id` = `PREFIX_posts`.`id`)
|
|
and
|
|
(`PREFIX_files`.`boardid` = `PREFIX_posts`.`boardid`)
|
|
)
|
|
)
|
|
);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `reports`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_reports` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`cleared` tinyint(1) NOT NULL DEFAULT '0',
|
|
`board` varchar(255) NOT NULL DEFAULT '',
|
|
`postid` int(20) NOT NULL DEFAULT '0',
|
|
`when` int(20) NOT NULL DEFAULT '0',
|
|
`ip` varchar(88) NOT NULL DEFAULT '',
|
|
`reason` varchar(255) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `sections`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_sections` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`order` tinyint(3) NOT NULL DEFAULT '0',
|
|
`hidden` tinyint(1) NOT NULL DEFAULT '0',
|
|
`name` varchar(255) NOT NULL DEFAULT '',
|
|
`abbreviation` varchar(10) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `staff`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_staff` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`username` varchar(255) NOT NULL DEFAULT '',
|
|
`password` varchar(255) NOT NULL DEFAULT '',
|
|
`salt` varchar(3) NOT NULL DEFAULT '',
|
|
`type` tinyint(1) NOT NULL DEFAULT '0',
|
|
`boards` text,
|
|
`addedon` int(20) NOT NULL DEFAULT '0',
|
|
`lastactive` int(20) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `wordfilter`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_wordfilter` (
|
|
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
|
|
`word` varchar(75) NOT NULL DEFAULT '',
|
|
`replacedby` varchar(75) NOT NULL DEFAULT '',
|
|
`boards` text,
|
|
`time` int(20) NOT NULL DEFAULT '0',
|
|
`regex` tinyint(1) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `user_activity`
|
|
--
|
|
|
|
CREATE TABLE `PREFIX_user_activity` (
|
|
`idmd5` VARCHAR(50) NOT NULL,
|
|
`latest_post` INT UNSIGNED NULL DEFAULT '0',
|
|
`latest_thread` INT UNSIGNED NULL DEFAULT '0',
|
|
`post_count` INT UNSIGNED NULL DEFAULT '0',
|
|
PRIMARY KEY (`idmd5`)
|
|
) DEFAULT CHARSET=KU_DBCHARSET;
|
|
|
|
INSERT INTO `PREFIX_sections` (`id`, `order`, `hidden`, `name`, `abbreviation`) VALUES
|
|
(1, 1, 0, 'all', 'all'),
|
|
(2, 2, 0, 'geek', 'geek'),
|
|
(3, 3, 0, 'other', 'other'),
|
|
(4, 4, 0, 'adult', 'adult'),
|
|
(5, 0, 1, '2.0', '20');
|
|
|
|
INSERT INTO `PREFIX_ads` (`id`, `position`, `disp`, `boards`, `code`) VALUES (1, 'top', 0, '', 'Right Frame Top'), (2, 'bot', 0, '', 'Right Frame Bottom');
|
|
|
|
INSERT INTO `PREFIX_filetypes`
|
|
(`filetype`, `mime`, `image`, `image_w`, `image_h`, `force_thumb`) VALUES
|
|
( '*', '', '', 0, 0, 1),
|
|
( 'jpg', '', '', 0, 0, 0),
|
|
( 'gif', '', '', 0, 0, 0),
|
|
( 'png', '', '', 0, 0, 0),
|
|
( 'mp3', '', 'mp3.png', 36, 48, 1),
|
|
( 'ogg', '', 'ogg.png', 36, 48, 1),
|
|
( 'webm', 'video/webm', '', 0, 0, 0),
|
|
( 'mp4', 'video/mp4', '', 0, 0, 0),
|
|
( 'css', '', 'css.png', 36, 48, 1),
|
|
( 'swf', 'application/x-shockwave-flash', 'flash.png', 36, 48, 1);
|
|
|
|
INSERT INTO `PREFIX_events` (`name`, `at`) VALUES ('pingback', 0), ('sitemap', 0);
|
|
|
|
INSERT INTO `PREFIX_embeds` (`id`, `filetype`, `name`, `videourl`) VALUES
|
|
(1, 'you', 'Youtube', 'https://www.youtube.com/watch?v='),
|
|
(2, 'vim', 'Vimeo', 'https://vimeo.com/'),
|
|
(3, 'cob', 'Coub', 'https://coub.com/view/'),
|
|
(4, 'scl', 'Soundcloud', 'https://soundcloud.com/');
|
|
|
|
INSERT INTO `PREFIX_boards`
|
|
(`section`, `order`, `name`, `desc`, `maximagesize`, `maxpages`, `createdon`, `anonymous`, `forcedanon`, `enablenofile`, `dice`, `useragent` ) VALUES
|
|
('1', '1', 'b', 'Бред', '10240000', '11', UNIX_TIMESTAMP(NOW()), '', '1', '0', '0', '0' ),
|
|
('1', '2', 'd', 'Рисунки', '10240000', '5', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('1', '3', 'r', 'Реквесты', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '1', '0', '0' ),
|
|
('1', '4', '0', 'Øчан', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '1', '0', '1' ),
|
|
('2', '1', 'e', 'Радиоэлектроника', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('2', '2', 't', 'Технологии', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('2', '3', 'hw', 'Железо', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('2', '4', 's', 'Софт', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '1' ),
|
|
('2', '5', 'c', 'Быдлокодинг', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('2', '6', 'vg', 'Видеоигры', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('2', '7', '8', '8-bit и pixel art', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('2', '8', 'bg', 'Настольные игры', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '1', '0' ),
|
|
('2', '9', 'wh', 'Warhammer', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '1', '0' ),
|
|
('3', '1', 'a', 'Аниме', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '2', 'au', 'Автомобили', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '3', 'bo', 'Книги', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '4', 'co', 'Комиксы', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '5', 'cook', 'Лепка супов', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '6', 'f', 'Flash', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '7', 'fa', 'Мода и стиль', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '8', 'fl', 'Иностранные языки', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '9', 'm', 'Музыка', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '10', 'med', 'Медицина', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '11', 'ph', 'Фотографии', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '12', 'tv', 'Кино и сериалы', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '13', 'war', 'Вооружение', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('3', '14', 'wp', 'Обои', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('4', '1', 'h', 'Хентай', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('4', '2', 'g', 'Девушки', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('4', '3', 'fur', 'Фурри', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('', '1', 'nhk', 'Nullchan Hikikomori Kyokai', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('', '1', 'test', 'Тестирования движка', '10240000', '1', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '0', '0', '0' ),
|
|
('', '1', 'i', 'Invasion', '10240000', '11', UNIX_TIMESTAMP(NOW()), 'Аноним', '0', '1', '1', '1' ); |