This repository was archived by the owner on Feb 28, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathu946015410_test.sql
More file actions
158 lines (124 loc) · 7.71 KB
/
u946015410_test.sql
File metadata and controls
158 lines (124 loc) · 7.71 KB
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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 13, 2013 at 06:39 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `u946015410_test`
--
-- --------------------------------------------------------
--
-- Table structure for table `articles`
--
CREATE TABLE IF NOT EXISTS `articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`language` enum('english','italia','czech') COLLATE latin1_general_ci NOT NULL,
`title` varchar(80) CHARACTER SET cp1250 COLLATE cp1250_czech_cs NOT NULL,
`text` text CHARACTER SET cp1250 COLLATE cp1250_czech_cs NOT NULL,
`authorid` int(11) NOT NULL,
`date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=15 ;
--
-- Dumping data for table `articles`
--
INSERT INTO `articles` (`id`, `language`, `title`, `text`, `authorid`, `date`) VALUES
(11, 'english', 'Article Title 1', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel arcu velit. Cras nec tempus metus. Suspendisse ut diam ut metus lobortis fermentum id in risus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Phasellus viverra nibh a velit iaculis egestas. Proin in dapibus lacus. Donec id vulputate nibh. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut non justo eu quam pellentesque dignissim ac vitae nulla. In dui justo, vulputate id sagittis ut, sollicitudin nec risus. Sed tincidunt gravida lorem in ullamcorper. Donec laoreet tincidunt arcu, eu accumsan sapien condimentum nec. Cras vel nisi ut libero aliquet tincidunt id nec diam.\r\n\r\nPellentesque elit orci, egestas quis tempus ac, auctor in risus. Vestibulum non ipsum a risus malesuada ullamcorper. Cras sollicitudin ultricies justo vulputate tempor. In id sem odio, pellentesque facilisis elit. Pellentesque id nisi neque. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Ut vel nibh quam, eu imperdiet felis. Sed odio erat, luctus a varius sit amet, vehicula a dolor. Sed id dui purus, id fringilla quam. Duis at tortor eget eros consectetur vestibulum non ac magna. ', 1, '2013-01-12'),
(12, 'english', 'English Article 1', ' Lorem ipsum dolor sit amet, consectetur adipiscing elit. Fusce vel arcu velit. Cras nec tempus metus. Suspendisse ut diam ut metus lobortis fermentum id in risus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Phasellus viverra nibh a velit iaculis egestas. Proin in dapibus lacus. Donec id vulputate nibh. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut non justo eu quam pellentesque dignissim ac vitae nulla. In dui justo, vulputate id sagittis ut, sollicitudin nec risus. Sed tincidunt gravida lorem in ullamcorper. Donec laoreet tincidunt arcu, eu accumsan sapien condimentum nec. Cras vel nisi ut libero aliquet tincidunt id nec diam.\r\n\r\nPellentesque elit orci, egestas quis tempus ac, auctor in risus. Vestibulum non ipsum a risus malesuada ullamcorper. Cras sollicitudin ultricies justo vulputate tempor. In id sem odio, pellentesque facilisis elit. Pellentesque id nisi neque. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Ut vel nibh quam, eu imperdiet felis. Sed odio erat, luctus a varius sit amet, vehicula a dolor. Sed id dui purus, id fringilla quam. Duis at tortor eget eros consectetur vestibulum non ac magna. ', 1, '2013-01-13'),
(14, 'italia', 'Italia Article ', 'fasdf asdf asdf asdf asdf asdf asdf asdf asdf asdf asdf ', 1, '2013-01-13');
-- --------------------------------------------------------
--
-- Table structure for table `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) CHARACTER SET cp1250 COLLATE cp1250_czech_cs NOT NULL,
`link` varchar(255) COLLATE latin1_general_ci NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `menu`
--
-- --------------------------------------------------------
--
-- Table structure for table `pages`
--
CREATE TABLE IF NOT EXISTS `pages` (
`page_id` int(11) NOT NULL AUTO_INCREMENT,
`language` enum('english','italia','czech') NOT NULL,
`title` varchar(100) NOT NULL,
`content` text NOT NULL,
`authorid` int(11) NOT NULL,
`created_at` date NOT NULL,
`updated_at` date NOT NULL,
PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `pages`
--
INSERT INTO `pages` (`page_id`, `language`, `title`, `content`, `authorid`, `created_at`, `updated_at`) VALUES
(1, 'english', 'About Me tea', 'Hi, this page will descript about me ', 1, '2012-12-22', '2012-12-22'),
(2, 'italia', 'Informazioni su di mi', ' fadsf asdfasdf asdf asdf asdfasdf ', 1, '2013-01-11', '2013-01-11');
-- --------------------------------------------------------
--
-- Table structure for table `pollanswers`
--
CREATE TABLE IF NOT EXISTS `pollanswers` (
`poll_answer_id` int(11) NOT NULL AUTO_INCREMENT,
`poll_id` int(11) NOT NULL,
`answer` varchar(25) NOT NULL,
PRIMARY KEY (`poll_answer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `pollanswers`
--
INSERT INTO `pollanswers` (`poll_answer_id`, `poll_id`, `answer`) VALUES
(1, 1, 'Nasi goreng');
-- --------------------------------------------------------
--
-- Table structure for table `polls`
--
CREATE TABLE IF NOT EXISTS `polls` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`language` enum('english','italia','czech') COLLATE latin1_general_ci NOT NULL,
`question` varchar(40) COLLATE latin1_general_ci NOT NULL,
`answer1` varchar(25) COLLATE latin1_general_ci NOT NULL,
`answer2` varchar(25) COLLATE latin1_general_ci NOT NULL,
`answer3` varchar(25) COLLATE latin1_general_ci NOT NULL,
`active` enum('No','Yes') COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;
--
-- Dumping data for table `polls`
--
INSERT INTO `polls` (`id`, `language`, `question`, `answer1`, `answer2`, `answer3`, `active`) VALUES
(1, 'english', 'Makan apa ya enaknya malam ini ?', 'Nasi goreng', 'Ikan Bakar', 'Warteg X', 'Yes'),
(2, 'english', 'Bahasa Pemograman Apa yang Kamu Suka', 'PHP', 'Javascript', 'Java', 'No'),
(3, 'italia', 'italian question', 'aaa', 'bbb', 'ccc', 'No'),
(4, 'italia', 'italian question 2', 'fasdfad', 'fasdfasdf', 'afsdfasd fadf', 'Yes');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`authorid` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(30) COLLATE latin1_general_ci NOT NULL,
`password` varchar(100) COLLATE latin1_general_ci NOT NULL,
`email` varchar(50) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`authorid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`authorid`, `username`, `password`, `email`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'admin@admin.com'),
(3, 'testing', '96c892a3d2d171c2c7477cb0aebeb0c4', 'atang@gmail.com');