[ros-diffs] [cfinck] 36565: Add an SQL Dump to make it possible to test the Paste Service locally

Author: cfinck
Date: Sun Sep 28 05:03:43 2008
New Revision: 36565

URL: http://svn.reactos.org/svn/reactos?rev=36565&view=rev
Log:
Add an SQL Dump to make it possible to test the Paste Service locally

Added:
    trunk/web/reactos.org/resources/paste/
    trunk/web/reactos.org/resources/paste/paste.sql   (with props)

Added: trunk/web/reactos.org/resources/paste/paste.sql
URL:
http://svn.reactos.org/svn/reactos/trunk/web/reactos.org/resources/paste/pa…
==============================================================================
--- trunk/web/reactos.org/resources/paste/paste.sql (added)
+++ trunk/web/reactos.org/resources/paste/paste.sql [iso-8859-1] Sun Sep 28 05:03:43 2008
@@ -1,0 +1,18 @@
+CREATE TABLE `paste_service` (
+  `paste_id` bigint(20) NOT NULL auto_increment,
+  `paste_date` date NOT NULL default '0000-00-00',
+  `paste_days` int(11) NOT NULL default '7',
+  `paste_usrid` bigint(20) NOT NULL default '0',
+  `paste_nick` varchar(20) collate utf8_unicode_ci NOT NULL default '',
+  `paste_desc` varchar(50) collate utf8_unicode_ci NOT NULL default '',
+  `paste_lines` int(11) NOT NULL default '0',
+  `paste_tabs` int(11) NOT NULL default '0',
+  `paste_public` char(1) collate utf8_unicode_ci NOT NULL default '1',
+  `paste_lang` varchar(10) collate utf8_unicode_ci NOT NULL default 'C',
+  `paste_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
+  `paste_size` int(11) NOT NULL default '0',
+  `paste_ip` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+  `paste_proxy` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+  `paste_host` varchar(255) collate utf8_unicode_ci NOT NULL default '',
+  PRIMARY KEY  (`paste_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='ReactOS Copy
& Paste - paste service';

Propchange: trunk/web/reactos.org/resources/paste/paste.sql
------------------------------------------------------------------------------
    svn:eol-style = native