This repository has been archived by the owner on Jun 3, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
exp_channels.sql
107 lines (97 loc) · 7.76 KB
/
exp_channels.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
-- phpMyAdmin SQL Dump
-- version 3.4.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 03, 2013 at 12:07 AM
-- Server version: 5.5.34
-- PHP Version: 5.2.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `otaltcne_ExpressionEngine`
--
-- --------------------------------------------------------
--
-- Table structure for table `exp_channels`
--
DROP TABLE IF EXISTS `exp_channels`;
CREATE TABLE IF NOT EXISTS `exp_channels` (
`channel_id` int(6) unsigned NOT NULL AUTO_INCREMENT,
`site_id` int(4) unsigned NOT NULL DEFAULT '1',
`channel_name` varchar(40) NOT NULL,
`channel_title` varchar(100) NOT NULL,
`channel_url` varchar(100) NOT NULL,
`channel_description` varchar(255) DEFAULT NULL,
`channel_lang` varchar(12) NOT NULL,
`total_entries` mediumint(8) NOT NULL DEFAULT '0',
`total_comments` mediumint(8) NOT NULL DEFAULT '0',
`last_entry_date` int(10) unsigned NOT NULL DEFAULT '0',
`last_comment_date` int(10) unsigned NOT NULL DEFAULT '0',
`cat_group` varchar(255) DEFAULT NULL,
`status_group` int(4) unsigned DEFAULT NULL,
`deft_status` varchar(50) NOT NULL DEFAULT 'open',
`field_group` int(4) unsigned DEFAULT NULL,
`search_excerpt` int(4) unsigned DEFAULT NULL,
`deft_category` varchar(60) DEFAULT NULL,
`deft_comments` char(1) NOT NULL DEFAULT 'y',
`channel_require_membership` char(1) NOT NULL DEFAULT 'y',
`channel_max_chars` int(5) unsigned DEFAULT NULL,
`channel_html_formatting` char(4) NOT NULL DEFAULT 'all',
`channel_allow_img_urls` char(1) NOT NULL DEFAULT 'y',
`channel_auto_link_urls` char(1) NOT NULL DEFAULT 'n',
`channel_notify` char(1) NOT NULL DEFAULT 'n',
`channel_notify_emails` varchar(255) DEFAULT NULL,
`comment_url` varchar(80) DEFAULT NULL,
`comment_system_enabled` char(1) NOT NULL DEFAULT 'y',
`comment_require_membership` char(1) NOT NULL DEFAULT 'n',
`comment_use_captcha` char(1) NOT NULL DEFAULT 'n',
`comment_moderate` char(1) NOT NULL DEFAULT 'n',
`comment_max_chars` int(5) unsigned DEFAULT '5000',
`comment_timelock` int(5) unsigned NOT NULL DEFAULT '0',
`comment_require_email` char(1) NOT NULL DEFAULT 'y',
`comment_text_formatting` char(5) NOT NULL DEFAULT 'xhtml',
`comment_html_formatting` char(4) NOT NULL DEFAULT 'safe',
`comment_allow_img_urls` char(1) NOT NULL DEFAULT 'n',
`comment_auto_link_urls` char(1) NOT NULL DEFAULT 'y',
`comment_notify` char(1) NOT NULL DEFAULT 'n',
`comment_notify_authors` char(1) NOT NULL DEFAULT 'n',
`comment_notify_emails` varchar(255) DEFAULT NULL,
`comment_expiration` int(4) unsigned NOT NULL DEFAULT '0',
`search_results_url` varchar(80) DEFAULT NULL,
`ping_return_url` varchar(80) DEFAULT NULL,
`show_button_cluster` char(1) NOT NULL DEFAULT 'y',
`rss_url` varchar(80) DEFAULT NULL,
`enable_versioning` char(1) NOT NULL DEFAULT 'n',
`max_revisions` smallint(4) unsigned NOT NULL DEFAULT '10',
`default_entry_title` varchar(100) DEFAULT NULL,
`url_title_prefix` varchar(80) DEFAULT NULL,
`live_look_template` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`channel_id`),
KEY `cat_group` (`cat_group`),
KEY `status_group` (`status_group`),
KEY `field_group` (`field_group`),
KEY `channel_name` (`channel_name`),
KEY `site_id` (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `exp_channels`
--
INSERT INTO `exp_channels` (`channel_id`, `site_id`, `channel_name`, `channel_title`, `channel_url`, `channel_description`, `channel_lang`, `total_entries`, `total_comments`, `last_entry_date`, `last_comment_date`, `cat_group`, `status_group`, `deft_status`, `field_group`, `search_excerpt`, `deft_category`, `deft_comments`, `channel_require_membership`, `channel_max_chars`, `channel_html_formatting`, `channel_allow_img_urls`, `channel_auto_link_urls`, `channel_notify`, `channel_notify_emails`, `comment_url`, `comment_system_enabled`, `comment_require_membership`, `comment_use_captcha`, `comment_moderate`, `comment_max_chars`, `comment_timelock`, `comment_require_email`, `comment_text_formatting`, `comment_html_formatting`, `comment_allow_img_urls`, `comment_auto_link_urls`, `comment_notify`, `comment_notify_authors`, `comment_notify_emails`, `comment_expiration`, `search_results_url`, `ping_return_url`, `show_button_cluster`, `rss_url`, `enable_versioning`, `max_revisions`, `default_entry_title`, `url_title_prefix`, `live_look_template`) VALUES
(1, 1, 'your-practice-placement', 'Your Practice Placement', 'http://otaltc.net/', '', 'en', 5, 0, 1340860423, 0, '3', 1, 'open', 3, 1, '', 'y', 'y', NULL, 'all', 'y', 'n', 'n', '', '', 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', '', 0, '', '', 'y', '', 'n', 10, '', '', 0),
(2, 1, 'home', 'Home', 'http://otaltc.net/', '', 'en', 0, 0, 0, 0, '1', 1, 'open', 3, 1, '', 'y', 'y', NULL, 'all', 'y', 'n', 'n', '', '', 'n', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', '', 0, '', '', 'y', '', 'n', 10, '', '', 0),
(3, 1, 'different_practice_contexts', 'Different practice contexts', 'http://otaltc.net/', NULL, 'en', 1, 0, 1340935153, 0, '', 1, 'open', 3, NULL, NULL, 'y', 'y', NULL, 'all', 'y', 'n', 'n', NULL, NULL, 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', NULL, 0, NULL, NULL, 'y', NULL, 'n', 10, '', '', 0),
(4, 1, 'ot_practice_process', 'OT Practice Process', 'http://otaltc.net/', '', 'en', 1, 0, 1340936280, 0, '', 1, 'open', 3, 1, '', 'y', 'y', NULL, 'all', 'y', 'n', 'n', '', '', 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', '', 0, '', '', 'y', '', 'n', 10, '', '', 0),
(5, 1, 'practice_resources', 'Practice Resources', 'http://otaltc.net/', NULL, 'en', 1, 0, 1340936979, 0, '', 1, 'open', 3, NULL, NULL, 'y', 'y', NULL, 'all', 'y', 'n', 'n', NULL, NULL, 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', NULL, 0, NULL, NULL, 'y', NULL, 'n', 10, '', '', 0),
(6, 1, 'evidencing_your_practice_competencies', 'Evidencing your practice competencies', 'http://otaltc.net/', NULL, 'en', 1, 0, 1340936651, 0, '', 1, 'open', 3, NULL, NULL, 'y', 'y', NULL, 'all', 'y', 'n', 'n', NULL, NULL, 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', NULL, 0, NULL, NULL, 'y', NULL, 'n', 10, '', '', 0),
(7, 1, 'how_did_this_site_develop', 'How did this site develop?', 'http://otaltc.net/', NULL, 'en', 0, 0, 0, 0, '', 1, 'open', 3, NULL, NULL, 'y', 'y', NULL, 'all', 'y', 'n', 'n', NULL, NULL, 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', NULL, 0, NULL, NULL, 'y', NULL, 'n', 10, '', '', 0),
(8, 1, 'possible_research_projects', 'Possible research projects', 'http://otaltc.net/', NULL, 'en', 0, 0, 0, 0, '', NULL, 'open', NULL, NULL, NULL, 'y', 'y', NULL, 'all', 'y', 'n', 'n', NULL, NULL, 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', NULL, 0, NULL, NULL, 'y', NULL, 'n', 10, '', '', 0),
(9, 1, 'evidencing_matrix', 'Evidencing matrix', 'http://otca.net.au/', '', 'en', 8, 0, 1351664504, 0, '', 1, 'open', 3, 1, '', 'y', 'y', NULL, 'all', 'y', 'n', 'n', '', '', 'n', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', '', 0, '', '', 'y', '', 'n', 10, '', '', 0),
(13, 1, 'pracsot', 'PRACSOT', 'http://otaltc.net/', NULL, 'en', 0, 0, 0, 0, '', 0, 'open', 6, NULL, NULL, 'y', 'y', NULL, 'all', 'y', 'n', 'n', NULL, NULL, 'y', 'n', 'n', 'n', 5000, 0, 'y', 'xhtml', 'safe', 'n', 'y', 'n', 'n', NULL, 0, NULL, NULL, 'y', NULL, 'n', 10, '', '', 0);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;