simplecm/database.sql at master · bhodgins/simplecm · GitHub

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
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--

-- --------------------------------------------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `version` text NOT NULL,
  `admin` text NOT NULL,
  `modinstall` text NOT NULL,
  `layout` text NOT NULL,
  `updateserver` text NOT NULL,
  `title` text NOT NULL
);

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES ('0.2.0', 'yes', 'yes', 'none', ' ', 'SimpleCM');

-- --------------------------------------------------------

--
-- Table structure for table `admin_log`
--

CREATE TABLE `admin_log` (
  `scm` text NOT NULL,
  `user` text NOT NULL,
  `useragent` text NOT NULL,
  `date` text NOT NULL,
  `ip` text NOT NULL
);

-- --------------------------------------------------------

--
-- Table structure for table `admin_mod`
--

CREATE TABLE `admin_mod` (
  `modname` text NOT NULL,
  `modver` text NOT NULL,
  `installdate` text NOT NULL,
  `updateurl` text NOT NULL,
  `ai` text NOT NULL,
  `optionfile` text NOT NULL
);

-- --------------------------------------------------------

--
-- Table structure for table `admin_motd`
--

CREATE TABLE `admin_motd` (
  `motd` text NOT NULL,
  `id` text NOT NULL
);

--
-- Dumping data for table `admin_motd`
--


INSERT INTO `admin_motd` VALUES ('There are always updates coming soon, so dont worry too much if you discover a bug!!!', '3');
INSERT INTO `admin_motd` VALUES ('Check simplecm.org for the newest updates', '4');
INSERT INTO `admin_motd` VALUES ('visit simplecm.org for the latest news', '5');
INSERT INTO `admin_motd` VALUES ('send suggestions to georgemoody@gmail.com', '6');

-- --------------------------------------------------------

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `name` text NOT NULL,
  `email` text NOT NULL,
  `message` text NOT NULL,
  `subject` text NOT NULL,
  `contact_id` text NOT NULL
);


-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `Title` text NOT NULL,
  `Author` text NOT NULL,
  `Content` text NOT NULL,
  `DateAdded` text NOT NULL,
  `news_id` text NOT NULL
);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `username` text NOT NULL,
  `passwd` text NOT NULL,
  `id` text NOT NULL,
  `permissions` text NOT NULL,
  `first` text NOT NULL,
  `last` text NOT NULL,
  `location` text NOT NULL,
  `timezone` text NOT NULL,
  `email` text NOT NULL
);
INSERT INTO `users` (`username`, `passwd`, `id`, `permissions`, `first`, `last`, `location`, `timezone`, `email`) VALUES
('user', '1a1dc91c907325c69271ddf0c944bc72', '0', 'admin', 'first', 'last', 'n', 'n', 'user@localhost');