folding-poetry/folding_poetry.sql at master · paulbotwid/folding-poetry

History

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

159

160

161

162

163

-- phpMyAdmin SQL Dump

-- version 4.4.10

-- http://www.phpmyadmin.net

-- Host: localhost:8889

-- Generation Time: Aug 22, 2017 at 02:39 PM

-- Server version: 5.5.42

-- PHP Version: 7.0.0

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 utf8mb4 */;

-- Database: `folding_poetry`

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

-- Table structure for table `emails`

CREATE TABLE `emails` (

`id` int(11) NOT NULL,

`email` text NOT NULL,

`poem_id` int(11) NOT NULL,

`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- Table structure for table `poems`

CREATE TABLE `poems` (

`id` int(11) NOT NULL,

`poem` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`line_count` int(11) NOT NULL,

`bg_color` text COLLATE utf8mb4_bin NOT NULL,

`styles` text CHARACTER SET latin1 NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table `poems`

INSERT INTO `poems` (`id`, `poem`, `last_update`, `line_count`, `bg_color`, `styles`) VALUES

(154, ' Okay let''s see what we''ve got It''s so exciting right now I can hardly contain it Let''s go, right to bed my dear I''m exhausted from the heat Leave me be, I''m begging you? Weird thing to ask if I may say so mayself For myself I''ve always fancied tea in the parking lot, as if that would help the children sing Please let it be done with', '2017-07-03 11:28:04', 10, '#f9f9f9', 'text-transform: lowercase;font-style: normal;color: #202020;font-weight: 800;font-family: Shrikhand;'),

(155, ' How do I want it to look in the end Would it be ever changing? Maybe that''s too busy Let me think about it for a minute God it''s gettin hot today, bring in the ice tea', '2017-07-03 11:33:17', 5, '#0bffbd', 'text-transform: uppercase;font-style: normal;color: #202020;font-weight: 800;font-family: Rakkas;'),

(156, ' I''m not sure how to put it It just comes to me, and I roll with it don''t take it too personally dear It''s only loce', '2017-07-03 13:25:50', 3, '#fffc00', 'text-transform: default;font-style: normal;color: #202020;font-weight: 800;font-family: Shrikhand;'),

(157, ' If ever we should build a house Let''s have chickens Please, don''t laugh, it makes me feel old I''m too old', '2017-07-03 13:28:53', 3, '#00fffb', 'text-transform: lowercase;font-style: italic;color: #fffc00;font-weight: 300;font-family: Rakkas;'),

(158, ' You and I should go away some day, just the two of us could start a war a war on everything that god forgot I''m sure there''s something', '2017-07-03 13:55:58', 3, '#202020', 'text-transform: default;font-style: normal;color: #ff2f67;font-weight: 100;font-family: Shrikhand;'),

(159, ' I''m not at all bored by this really, is that what you think? Well bloody hell then I''m going to find another drinking buddy', '2017-07-03 14:00:15', 3, '#9eff3d', 'text-transform: default;font-style: normal;color: #202020;font-weight: 300;font-family: Shrikhand;'),

(160, ' You can''t say I didn''t try I promise I won''t give in too easily this time, it''s more than a promise It''s not just about love', '2017-07-03 18:28:08', 3, '#202020', 'text-transform: uppercase;font-style: normal;color: #ff2f67;font-weight: 800;font-family: Ubuntu;'),

(161, ' you can''t be serious what about the other day? What about it? I don''t know yet, I''m figuring myself out Thanks for listening', '2017-07-03 20:13:33', 4, '#0bffbd', 'text-transform: lowercase;font-style: normal;color: #00fffb;font-weight: 100;font-family: Arbutus Slab;'),

(162, ' I''m talking to myself again I''m longing for every breath away from pain It''s not that I''m not breathing it''s just pain finds its way into many', '2017-07-03 20:45:49', 3, '#F932FC', 'text-transform: default;font-style: italic;color: #fffc00;font-weight: 400;font-family: Shrikhand;'),

(163, ' OK go go go go you go ashole leave me alone well you leave me alone now seriously go go what the actuall fuck is wrong with you, GO!!! AWAY!!!! i dont want to talk to i want to write poetry. okay bye ', '2017-07-03 21:01:02', 5, '#9eff3d', 'text-transform: default;font-style: italic;color: #fffc00;font-weight: 500;font-family: Shrikhand;'),

(164, ' NOW THEN Please WFT what happend to you to make you like this?? well what make you a bag of shit as fuck. any way. I LOVE YOU', '2017-07-03 21:05:57', 3, '#0043ef', 'text-transform: default;font-style: normal;color: #F932FC;font-weight: 100;font-family: Arbutus Slab;'),

(165, ' I''m not as excited anymore Could you please let me go I''m telling you to stop and go, stop and go - stop to see It''s sunny outside', '2017-07-05 13:13:46', 4, '#202020', 'text-transform: default;font-style: normal;color: #f9f9f9;font-weight: 400;font-family: Arbutus Slab;'),

(166, ' I''m not talking about the horses anymore I''m over it, and don''t go thinking I''m not Because I am not afraid to tell you how I feel to tired and fuzzy in my head Let go', '2017-07-05 13:23:24', 4, '#f9f9f9', 'text-transform: default;font-style: italic;color: #202020;font-weight: 300;font-family: Ubuntu;'),

(167, ' Hello again omg its again again and again om', '2017-07-05 13:46:25', 3, '#202020', 'text-transform: default;font-style: italic;color: #fffc00;font-weight: 800;font-family: Arbutus Slab;'),

(168, ' Don''t let me say it too many times I''m telling you it''s not my fault, it never is So come on, let me have it I''m not the one to bother the dead with troubles', '2017-07-05 14:03:45', 4, '#0043ef', 'text-transform: lowercase;font-style: italic;color: #f9f9f9;font-weight: 800;font-family: Ubuntu;'),

(169, ' I''m saying the same things over and over Again, and again, again and again We''re here now, so let''s talk I''m seriously mad right now I''m talking about you', '2017-07-05 14:13:29', 5, '#0043ef', 'text-transform: default;font-style: normal;color: #f9f9f9;font-weight: 400;font-family: Rakkas;'),

(170, ' It''s only love and that is all So why should I feel the way I do Oh that sorrow I feel in this Room s are talking to me all night, let me go', '2017-07-05 14:13:51', 4, '#202020', 'text-transform: lowercase;font-style: italic;color: #ff2f67;font-weight: 400;font-family: Rakkas;'),

(171, ' Come on now where did you g o now I''m not talking about you any more than you know that is good hey', '2017-07-05 14:19:08', 5, '#f9f9f9', 'text-transform: lowercase;font-style: italic;color: #202020;font-weight: 800;font-family: Rakkas;'),

(172, ' come on what''s the matter Fine I get it, and I''m not mad about it going to hell with all your conventions This is my only way of saying it if I don''t', '2017-07-05 14:22:42', 5, '#f9f9f9', 'text-transform: default;font-style: italic;color: #fffc00;font-weight: 500;font-family: Ubuntu;'),

(173, ' now then I''m not your choice to make But let''s not say things too often', '2017-07-05 14:23:26', 3, '#F932FC', 'text-transform: default;font-style: normal;color: #202020;font-weight: 400;font-family: Shrikhand;'),

(174, ' You have got me going on again and again Don''t you know I''ve been trying to tell you to come again tell you to go away slowly, I''m not happy so I''ll let you go again I guess I''ll let you go again', '2017-07-05 20:37:54', 5, '#ff2f67', 'text-transform: uppercase;font-style: normal;color: #F932FC;font-weight: 300;font-family: Rakkas;'),

(175, ' Now then What''s up with all the hanging around I''m troubled No, not really', '2017-07-06 07:37:44', 3, '#f9f9f9', 'text-transform: lowercase;font-style: normal;color: #ff2f67;font-weight: 800;font-family: Shrikhand;'),

(176, ' Hello mister postman, let me see you I''m not coming home tonight ma You never treat me as well as you said you would let me be hopeless and helpless again I''d rather not lose hope', '2017-07-06 07:45:33', 4, '#0043ef', 'text-transform: lowercase;font-style: normal;color: #ff2f67;font-weight: 500;font-family: Ubuntu;'),

(177, ' Hello all of you Sitting in my own space Sitting on my hey go', '2017-07-06 07:55:57', 3, '#f9f9f9', 'text-transform: uppercase;font-style: normal;color: #202020;font-weight: 100;font-family: Rakkas;'),

(178, ' Okay last one before coffee Im a longing for belonging. I wanna hope but not too much to hear you say hey, grow up', '2017-07-06 08:26:30', 4, '#D800FF', 'text-transform: uppercase;font-style: italic;color: #fffc00;font-weight: 400;font-family: Anton;'),

(179, ' I have another thought about the fall of man and dog, you don''t see much these days don''t come running fast enough these dogs are nuthin but cheap cats longing for the woods', '2017-07-16 21:40:49', 4, '#f9f9f9', 'text-transform: lowercase;font-style: italic;color: #0043ef;font-weight: 400;font-family: Shrikhand;'),

(180, ' I''m talking about the good times, The lookyloos have all gone to sleep All the help in the world could never use me til it over', '2017-07-17 20:27:27', 4, '#D800FF', 'text-transform: uppercase;font-style: normal;color: #202020;font-weight: 800;font-family: Shrikhand;'),

(181, ' omg i here again and again and again It goes like boom boom And then I''m like ', '2017-08-22 12:39:24', 3, '#202020', 'text-transform: lowercase;font-style: italic;color: #fffc00;font-weight: 400;font-family: Questrial;'),

(182, ' it''s never as bad as it seems sometimes it''s not as easy as it seems but you should go again Right?', '2017-07-20 21:13:38', 3, '#f9f9f9', 'text-transform: default;font-style: normal;color: #0043ef;font-weight: 500;font-family: Rakkas;'),

(185, ' This is my last goodbye let it sing it to see the 🔥 i need to get going it never happen to an angel are you an 😇 ? I''m just asking, the 🥑 is on its way', '2017-07-21 20:11:23', 5, '#ff2f67', 'text-transform: uppercase;font-style: normal;color: #202020;font-weight: 500;font-family: Anton;'),

(187, ' Hello I''m testing it again, hopefully it is not too long til honesty takes over me once more', '2017-08-14 16:28:48', 3, '#0bffbd', 'text-transform: lowercase;font-style: italic;color: #ffe700;font-weight: 100;font-family: Rakkas;');

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

-- Table structure for table `working_poems`

CREATE TABLE `working_poems` (

`id` int(11) NOT NULL,

`working_poem` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`last_line` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,

`curr_line_count` int(11) NOT NULL DEFAULT '0',

`target_line_count` int(11) NOT NULL DEFAULT '0',

`in_use` tinyint(1) NOT NULL DEFAULT '0',

`color` text CHARACTER SET latin1 NOT NULL,

`styles` text CHARACTER SET latin1 NOT NULL,

`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- Dumping data for table `working_poems`

INSERT INTO `working_poems` (`id`, `working_poem`, `last_line`, `curr_line_count`, `target_line_count`, `in_use`, `color`, `styles`, `last_update`) VALUES

(130, '%l1s%does it not go away?%l1e%%l2s%say%l2e%%l1s%it again%l1e%%l2s%hey%l2e%', 'hey', 2, 3, 1, '#202020', '', '2017-08-22 12:39:26'),

(131, '', '', 0, 0, 0, '', '', '2017-08-14 16:34:56'),

(132, '', '', 0, 0, 0, '', '', '2017-07-21 18:59:10'),

(133, '', '', 0, 0, 0, '', '', '2017-07-21 18:59:04'),

(134, '', '', 0, 0, 0, '', '', '2017-07-20 23:42:17'),

(135, '', '', 0, 0, 0, '', '', '2017-07-21 18:57:56'),

(136, '', '', 0, 0, 0, '', '', '2017-08-14 16:28:08'),

(137, '', '', 0, 0, 0, '', '', '2017-08-14 16:28:48');

-- Indexes for dumped tables

-- Indexes for table `emails`

ALTER TABLE `emails`

ADD PRIMARY KEY (`id`);

-- Indexes for table `poems`

ALTER TABLE `poems`

ADD PRIMARY KEY (`id`);

-- Indexes for table `working_poems`

ALTER TABLE `working_poems`

ADD PRIMARY KEY (`id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `emails`

ALTER TABLE `emails`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

-- AUTO_INCREMENT for table `poems`

ALTER TABLE `poems`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=188;

-- AUTO_INCREMENT for table `working_poems`

ALTER TABLE `working_poems`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=138;

/*!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 */;

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

folding_poetry.sql

folding_poetry.sql

Files

folding_poetry.sql

Latest commit

History

folding_poetry.sql

File metadata and controls