· 9 years ago · Nov 02, 2016, 07:52 AM
1CREATE TABLE IF NOT EXISTS `configurations` (
2 `ad_place_hashtag` text NOT NULL,
3 `ad_place_home` text NOT NULL,
4 `ad_place_messages` text NOT NULL,
5 `ad_place_search` text NOT NULL,
6 `ad_place_timeline` text NOT NULL,
7 `admin_password` varchar(255) NOT NULL DEFAULT 'xxxx',
8 `admin_username` varchar(255) NOT NULL DEFAULT 'xxxx',
9 `captcha` int(1) NOT NULL DEFAULT '0',
10 `censored_words` varchar(255) NOT NULL DEFAULT 'racist,retard',
11 `chat` int(1) NOT NULL DEFAULT '0',
12 `comment_character_limit` int(10) NOT NULL DEFAULT '0',
13 `email` varchar(150) NOT NULL DEFAULT 'no-reply@website.com',
14 `email_verification` int(1) NOT NULL DEFAULT '0',
15 `friends` int(1) NOT NULL DEFAULT '0',
16 `language` varchar(50) NOT NULL DEFAULT 'english',
17 `message_character_limit` int(10) NOT NULL DEFAULT '0',
18 `reg_req_about` int(1) NOT NULL DEFAULT '0',
19 `reg_req_birthday` int(1) NOT NULL DEFAULT '0',
20 `reg_req_currentcity` int(1) NOT NULL DEFAULT '0',
21 `reg_req_hometown` int(1) NOT NULL DEFAULT '0',
22 `reset_time` int(12) NOT NULL,
23 `site_name` varchar(150) NOT NULL DEFAULT 'Site Name',
24 `site_title` varchar(150) NOT NULL DEFAULT 'Site Title',
25 `smooth_links` int(1) NOT NULL DEFAULT '0',
26 `story_character_limit` int(10) NOT NULL DEFAULT '0',
27 `theme` varchar(100) NOT NULL DEFAULT ''
28) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30INSERT INTO `configurations` (`ad_place_hashtag`, `ad_place_home`, `ad_place_messages`, `ad_place_search`, `ad_place_timeline`, `admin_password`, `admin_username`, `captcha`, `censored_words`, `chat`, `comment_character_limit`, `email`, `email_verification`, `friends`, `language`, `message_character_limit`, `reg_req_about`, `reg_req_birthday`, `reg_req_currentcity`, `reg_req_hometown`, `reset_time`, `site_name`, `site_title`, `smooth_links`, `story_character_limit`, `theme`) VALUES
31('', '', '', '', '', 'xxxx', 'xxxx', 1, 'racist,retard', 0, 0, 'no-reply@website.com', 0, 0, 'english', 0, 0, 0, 0, 0, 0, 'Site Name', 'Site Title', 0, 0, 'lemon');