Created
April 20, 2015 07:51
-
-
Save nijssen/d999e23aa570dea09eaf to your computer and use it in GitHub Desktop.
Installing Everything: SQL patch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff -crB eee/everything/Everything/NodeBase.pm everything/Everything/NodeBase.pm | |
*** eee/everything/Everything/NodeBase.pm 2001-02-18 16:15:40.000000000 -0800 | |
--- everything/Everything/NodeBase.pm 2015-04-19 18:44:34.785225611 -0700 | |
*************** | |
*** 1314,1320 **** | |
return -1 if($this->tableExists($table)); | |
$result = $this->{dbh}->do("create table $table ($tableid int(11)" . | |
! " DEFAULT '0' NOT NULL, PRIMARY KEY($tableid))"); | |
return $result; | |
} | |
--- 1314,1320 ---- | |
return -1 if($this->tableExists($table)); | |
$result = $this->{dbh}->do("create table $table ($tableid int(11)" . | |
! " NOT NULL, PRIMARY KEY($tableid))"); | |
return $result; | |
} | |
*************** | |
*** 1342,1351 **** | |
my $sql; | |
$sql = <<SQLEND; | |
create table $table ( | |
! $tableid int(11) DEFAULT '0' NOT NULL auto_increment, | |
! rank int(11) DEFAULT '0' NOT NULL, | |
! node_id int(11) DEFAULT '0' NOT NULL, | |
! orderby int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY($tableid,rank) | |
) | |
SQLEND | |
--- 1342,1351 ---- | |
my $sql; | |
$sql = <<SQLEND; | |
create table $table ( | |
! $tableid int(11) NOT NULL auto_increment, | |
! rank int(11) NOT NULL, | |
! node_id int(11) NOT NULL, | |
! orderby int(11) NOT NULL, | |
PRIMARY KEY($tableid,rank) | |
) | |
SQLEND | |
diff -crB eee/everything/Everything/NodeCache.pm everything/Everything/NodeCache.pm | |
*** eee/everything/Everything/NodeCache.pm 2001-01-31 12:07:30.000000000 -0800 | |
--- everything/Everything/NodeCache.pm 2015-04-19 18:44:34.783225840 -0700 | |
*************** | |
*** 129,135 **** | |
my $dbh = $this->{nodeBase}->getDatabaseHandle(); | |
$createTable = "create table version ("; | |
! $createTable .= "version_id int(11) default '0' not null, "; | |
$createTable .= "version int(11) default '1' not null, "; | |
$createTable .= "primary key (version_id))"; | |
--- 129,135 ---- | |
my $dbh = $this->{nodeBase}->getDatabaseHandle(); | |
$createTable = "create table version ("; | |
! $createTable .= "version_id int(11) not null, "; | |
$createTable .= "version int(11) default '1' not null, "; | |
$createTable .= "primary key (version_id))"; | |
diff -crB eee/everything/nodeballs/ecore/tables/container.sql everything/nodeballs/ecore/tables/container.sql | |
*** eee/everything/nodeballs/ecore/tables/container.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/container.sql 2015-04-19 18:44:34.789225154 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'container' | |
# | |
CREATE TABLE container ( | |
! container_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
context text, | |
parent_container int(11), | |
PRIMARY KEY (container_id) | |
--- 8,14 ---- | |
# Table structure for table 'container' | |
# | |
CREATE TABLE container ( | |
! container_id int(11) NOT NULL auto_increment, | |
context text, | |
parent_container int(11), | |
PRIMARY KEY (container_id) | |
diff -crB eee/everything/nodeballs/ecore/tables/document.sql everything/nodeballs/ecore/tables/document.sql | |
*** eee/everything/nodeballs/ecore/tables/document.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/document.sql 2015-04-19 18:44:34.786225497 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'document' | |
# | |
CREATE TABLE document ( | |
! document_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
doctext text, | |
PRIMARY KEY (document_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'document' | |
# | |
CREATE TABLE document ( | |
! document_id int(11) NOT NULL auto_increment, | |
doctext text, | |
PRIMARY KEY (document_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/htmlcode.sql everything/nodeballs/ecore/tables/htmlcode.sql | |
*** eee/everything/nodeballs/ecore/tables/htmlcode.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/htmlcode.sql 2015-04-19 18:44:34.788225269 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'htmlcode' | |
# | |
CREATE TABLE htmlcode ( | |
! htmlcode_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
code text, | |
PRIMARY KEY (htmlcode_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'htmlcode' | |
# | |
CREATE TABLE htmlcode ( | |
! htmlcode_id int(11) NOT NULL auto_increment, | |
code text, | |
PRIMARY KEY (htmlcode_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/htmlpage.sql everything/nodeballs/ecore/tables/htmlpage.sql | |
*** eee/everything/nodeballs/ecore/tables/htmlpage.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/htmlpage.sql 2015-04-19 18:44:34.789225154 -0700 | |
*************** | |
*** 8,19 **** | |
# Table structure for table 'htmlpage' | |
# | |
CREATE TABLE htmlpage ( | |
! htmlpage_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
pagetype_nodetype int(11), | |
displaytype varchar(20), | |
page text, | |
parent_container int(11), | |
! ownedby_theme int(11) DEFAULT '0' NOT NULL, | |
permissionneeded char(1) DEFAULT 'r' NOT NULL, | |
MIMEtype varchar(255) DEFAULT 'text/html' NOT NULL, | |
PRIMARY KEY (htmlpage_id) | |
--- 8,19 ---- | |
# Table structure for table 'htmlpage' | |
# | |
CREATE TABLE htmlpage ( | |
! htmlpage_id int(11) NOT NULL auto_increment, | |
pagetype_nodetype int(11), | |
displaytype varchar(20), | |
page text, | |
parent_container int(11), | |
! ownedby_theme int(11) NOT NULL, | |
permissionneeded char(1) DEFAULT 'r' NOT NULL, | |
MIMEtype varchar(255) DEFAULT 'text/html' NOT NULL, | |
PRIMARY KEY (htmlpage_id) | |
diff -crB eee/everything/nodeballs/ecore/tables/image.sql everything/nodeballs/ecore/tables/image.sql | |
*** eee/everything/nodeballs/ecore/tables/image.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/image.sql 2015-04-19 18:44:34.786225497 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'image' | |
# | |
CREATE TABLE image ( | |
! image_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
src varchar(255), | |
alt varchar(255), | |
thumbsrc varchar(255), | |
--- 8,14 ---- | |
# Table structure for table 'image' | |
# | |
CREATE TABLE image ( | |
! image_id int(11) NOT NULL auto_increment, | |
src varchar(255), | |
alt varchar(255), | |
thumbsrc varchar(255), | |
diff -crB eee/everything/nodeballs/ecore/tables/javascript.sql everything/nodeballs/ecore/tables/javascript.sql | |
*** eee/everything/nodeballs/ecore/tables/javascript.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/javascript.sql 2015-04-19 18:44:34.787225383 -0700 | |
*************** | |
*** 8,16 **** | |
# Table structure for table 'javascript' | |
# | |
CREATE TABLE javascript ( | |
! javascript_id int(11) DEFAULT '0' NOT NULL, | |
code text NOT NULL, | |
comment text NOT NULL, | |
! dynamic int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (javascript_id) | |
); | |
--- 8,16 ---- | |
# Table structure for table 'javascript' | |
# | |
CREATE TABLE javascript ( | |
! javascript_id int(11) NOT NULL, | |
code text NOT NULL, | |
comment text NOT NULL, | |
! dynamic int(11) NOT NULL, | |
PRIMARY KEY (javascript_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/links.sql everything/nodeballs/ecore/tables/links.sql | |
*** eee/everything/nodeballs/ecore/tables/links.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/links.sql 2015-04-19 18:44:34.788225269 -0700 | |
*************** | |
*** 8,17 **** | |
# Table structure for table 'links' | |
# | |
CREATE TABLE links ( | |
! from_node int(11) DEFAULT '0' NOT NULL, | |
! to_node int(11) DEFAULT '0' NOT NULL, | |
! linktype int(11) DEFAULT '0' NOT NULL, | |
! hits int(11) DEFAULT '0', | |
! food int(11) DEFAULT '0', | |
PRIMARY KEY (from_node,to_node,linktype) | |
); | |
--- 8,17 ---- | |
# Table structure for table 'links' | |
# | |
CREATE TABLE links ( | |
! from_node int(11) NOT NULL, | |
! to_node int(11) NOT NULL, | |
! linktype int(11) NOT NULL, | |
! hits int(11) , | |
! food int(11) , | |
PRIMARY KEY (from_node,to_node,linktype) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/mail.sql everything/nodeballs/ecore/tables/mail.sql | |
*** eee/everything/nodeballs/ecore/tables/mail.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/mail.sql 2015-04-19 18:44:34.789225154 -0700 | |
*************** | |
*** 8,15 **** | |
# Table structure for table 'mail' | |
# | |
CREATE TABLE mail ( | |
! mail_id int(11) DEFAULT '0' NOT NULL, | |
from_address char(80) DEFAULT '' NOT NULL, | |
! attachment_file int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (mail_id) | |
); | |
--- 8,15 ---- | |
# Table structure for table 'mail' | |
# | |
CREATE TABLE mail ( | |
! mail_id int(11) NOT NULL, | |
from_address char(80) DEFAULT '' NOT NULL, | |
! attachment_file int(11) NOT NULL, | |
PRIMARY KEY (mail_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/nodegroup.sql everything/nodeballs/ecore/tables/nodegroup.sql | |
*** eee/everything/nodeballs/ecore/tables/nodegroup.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/nodegroup.sql 2015-04-19 18:44:34.789225154 -0700 | |
*************** | |
*** 8,16 **** | |
# Table structure for table 'nodegroup' | |
# | |
CREATE TABLE nodegroup ( | |
! nodegroup_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
! rank int(11) DEFAULT '0' NOT NULL, | |
! node_id int(11) DEFAULT '0' NOT NULL, | |
orderby int(11), | |
PRIMARY KEY (nodegroup_id,rank) | |
); | |
--- 8,16 ---- | |
# Table structure for table 'nodegroup' | |
# | |
CREATE TABLE nodegroup ( | |
! nodegroup_id int(11) NOT NULL auto_increment, | |
! rank int(11) NOT NULL, | |
! node_id int(11) NOT NULL, | |
orderby int(11), | |
PRIMARY KEY (nodegroup_id,rank) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/nodelet.sql everything/nodeballs/ecore/tables/nodelet.sql | |
*** eee/everything/nodeballs/ecore/tables/nodelet.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/nodelet.sql 2015-04-19 18:44:34.786225497 -0700 | |
*************** | |
*** 8,20 **** | |
# Table structure for table 'nodelet' | |
# | |
CREATE TABLE nodelet ( | |
! nodelet_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
nltext text, | |
nlcode text, | |
nlgoto int(11), | |
parent_container int(11), | |
! lastupdate int(11) DEFAULT '0' NOT NULL, | |
! updateinterval int(11) DEFAULT '0' NOT NULL, | |
! mini_nodelet int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (nodelet_id) | |
); | |
--- 8,20 ---- | |
# Table structure for table 'nodelet' | |
# | |
CREATE TABLE nodelet ( | |
! nodelet_id int(11) NOT NULL auto_increment, | |
nltext text, | |
nlcode text, | |
nlgoto int(11), | |
parent_container int(11), | |
! lastupdate int(11) NOT NULL, | |
! updateinterval int(11) NOT NULL, | |
! mini_nodelet int(11) NOT NULL, | |
PRIMARY KEY (nodelet_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/nodemethod.sql everything/nodeballs/ecore/tables/nodemethod.sql | |
*** eee/everything/nodeballs/ecore/tables/nodemethod.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/nodemethod.sql 2015-04-19 18:44:34.786225497 -0700 | |
*************** | |
*** 8,15 **** | |
# Table structure for table 'nodemethod' | |
# | |
CREATE TABLE nodemethod ( | |
! nodemethod_id int(11) DEFAULT '0' NOT NULL, | |
! supports_nodetype int(11) DEFAULT '0' NOT NULL, | |
code text NOT NULL, | |
PRIMARY KEY (nodemethod_id) | |
); | |
--- 8,15 ---- | |
# Table structure for table 'nodemethod' | |
# | |
CREATE TABLE nodemethod ( | |
! nodemethod_id int(11) NOT NULL, | |
! supports_nodetype int(11) NOT NULL, | |
code text NOT NULL, | |
PRIMARY KEY (nodemethod_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/node.sql everything/nodeballs/ecore/tables/node.sql | |
*** eee/everything/nodeballs/ecore/tables/node.sql 2001-02-09 00:29:20.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/node.sql 2015-04-19 18:44:34.788225269 -0700 | |
*************** | |
*** 10,24 **** | |
CREATE TABLE node ( | |
node_id int(11) NOT NULL auto_increment, | |
! type_nodetype int(11) DEFAULT '0' NOT NULL, | |
title char(240) DEFAULT '' NOT NULL, | |
! author_user int(11) DEFAULT '0' NOT NULL, | |
createtime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
! hits int(11) DEFAULT '0', | |
! loc_location int(11) DEFAULT '0', | |
! reputation int(11) DEFAULT '0' NOT NULL, | |
! lockedby_user int(11) DEFAULT '0' NOT NULL, | |
locktime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
authoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
groupaccess char(5) DEFAULT 'iiiii' NOT NULL, | |
--- 10,24 ---- | |
CREATE TABLE node ( | |
node_id int(11) NOT NULL auto_increment, | |
! type_nodetype int(11) NOT NULL, | |
title char(240) DEFAULT '' NOT NULL, | |
! author_user int(11) NOT NULL, | |
createtime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
! hits int(11) , | |
! loc_location int(11) , | |
! reputation int(11) NOT NULL, | |
! lockedby_user int(11) NOT NULL, | |
locktime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
authoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
groupaccess char(5) DEFAULT 'iiiii' NOT NULL, | |
diff -crB eee/everything/nodeballs/ecore/tables/nodetype.sql everything/nodeballs/ecore/tables/nodetype.sql | |
*** eee/everything/nodeballs/ecore/tables/nodetype.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/nodetype.sql 2015-04-19 18:44:34.786225497 -0700 | |
*************** | |
*** 8,17 **** | |
# Table structure for table 'nodetype' | |
# | |
CREATE TABLE nodetype ( | |
! nodetype_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
! restrict_nodetype int(11) DEFAULT '0', | |
! extends_nodetype int(11) DEFAULT '0', | |
! restrictdupes int(11) DEFAULT '0', | |
sqltable char(255), | |
grouptable char(40) DEFAULT '', | |
defaultauthoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
--- 8,17 ---- | |
# Table structure for table 'nodetype' | |
# | |
CREATE TABLE nodetype ( | |
! nodetype_id int(11) NOT NULL auto_increment, | |
! restrict_nodetype int(11) , | |
! extends_nodetype int(11) , | |
! restrictdupes int(11) , | |
sqltable char(255), | |
grouptable char(40) DEFAULT '', | |
defaultauthoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
diff -crB eee/everything/nodeballs/ecore/tables/revision.sql everything/nodeballs/ecore/tables/revision.sql | |
*** eee/everything/nodeballs/ecore/tables/revision.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/revision.sql 2015-04-19 19:03:58.397188432 -0700 | |
*************** | |
*** 8,17 **** | |
# Table structure for table 'revision' | |
# | |
CREATE TABLE revision ( | |
! node_id int(11) DEFAULT '0' NOT NULL, | |
! inside_workspace int(11) DEFAULT '0' NOT NULL, | |
! revision_id int(11) DEFAULT '0' NOT NULL, | |
xml text NOT NULL, | |
! tstamp timestamp(14), | |
PRIMARY KEY (node_id,inside_workspace,revision_id) | |
); | |
--- 8,17 ---- | |
# Table structure for table 'revision' | |
# | |
CREATE TABLE revision ( | |
! node_id int(11) NOT NULL, | |
! inside_workspace int(11) NOT NULL, | |
! revision_id int(11) NOT NULL, | |
xml text NOT NULL, | |
! tstamp timestamp, | |
PRIMARY KEY (node_id,inside_workspace,revision_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/setting.sql everything/nodeballs/ecore/tables/setting.sql | |
*** eee/everything/nodeballs/ecore/tables/setting.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/setting.sql 2015-04-19 18:44:34.787225383 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'setting' | |
# | |
CREATE TABLE setting ( | |
! setting_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
vars text NOT NULL, | |
PRIMARY KEY (setting_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'setting' | |
# | |
CREATE TABLE setting ( | |
! setting_id int(11) NOT NULL auto_increment, | |
vars text NOT NULL, | |
PRIMARY KEY (setting_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/symlink.sql everything/nodeballs/ecore/tables/symlink.sql | |
*** eee/everything/nodeballs/ecore/tables/symlink.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/symlink.sql 2015-04-19 18:44:34.787225383 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'symlink' | |
# | |
CREATE TABLE symlink ( | |
! symlink_id int(11) DEFAULT '0' NOT NULL, | |
! symlink_node int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (symlink_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'symlink' | |
# | |
CREATE TABLE symlink ( | |
! symlink_id int(11) NOT NULL, | |
! symlink_node int(11) NOT NULL, | |
PRIMARY KEY (symlink_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/themesetting.sql everything/nodeballs/ecore/tables/themesetting.sql | |
*** eee/everything/nodeballs/ecore/tables/themesetting.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/themesetting.sql 2015-04-19 18:44:34.788225269 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'themesetting' | |
# | |
CREATE TABLE themesetting ( | |
! themesetting_id int(11) DEFAULT '0' NOT NULL, | |
! parent_theme int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (themesetting_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'themesetting' | |
# | |
CREATE TABLE themesetting ( | |
! themesetting_id int(11) NOT NULL, | |
! parent_theme int(11) NOT NULL, | |
PRIMARY KEY (themesetting_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/typeversion.sql everything/nodeballs/ecore/tables/typeversion.sql | |
*** eee/everything/nodeballs/ecore/tables/typeversion.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/typeversion.sql 2015-04-19 18:44:34.789225154 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'typeversion' | |
# | |
CREATE TABLE typeversion ( | |
! typeversion_id int(11) DEFAULT '0' NOT NULL, | |
! version int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (typeversion_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'typeversion' | |
# | |
CREATE TABLE typeversion ( | |
! typeversion_id int(11) NOT NULL, | |
! version int(11) NOT NULL, | |
PRIMARY KEY (typeversion_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/user.sql everything/nodeballs/ecore/tables/user.sql | |
*** eee/everything/nodeballs/ecore/tables/user.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/user.sql 2015-04-19 18:44:34.788225269 -0700 | |
*************** | |
*** 8,20 **** | |
# Table structure for table 'user' | |
# | |
CREATE TABLE user ( | |
! user_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
nick varchar(20), | |
passwd varchar(10), | |
realname varchar(40), | |
email varchar(40), | |
lasttime datetime, | |
! karma int(11) DEFAULT '0', | |
! inside_workspace int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (user_id) | |
); | |
--- 8,20 ---- | |
# Table structure for table 'user' | |
# | |
CREATE TABLE user ( | |
! user_id int(11) NOT NULL auto_increment, | |
nick varchar(20), | |
passwd varchar(10), | |
realname varchar(40), | |
email varchar(40), | |
lasttime datetime, | |
! karma int(11) , | |
! inside_workspace int(11) NOT NULL, | |
PRIMARY KEY (user_id) | |
); | |
diff -crB eee/everything/nodeballs/ecore/tables/workspace.sql everything/nodeballs/ecore/tables/workspace.sql | |
*** eee/everything/nodeballs/ecore/tables/workspace.sql 2001-02-01 03:19:35.000000000 -0800 | |
--- everything/nodeballs/ecore/tables/workspace.sql 2015-04-19 18:44:34.787225383 -0700 | |
*************** | |
*** 8,13 **** | |
# Table structure for table 'workspace' | |
# | |
CREATE TABLE workspace ( | |
! workspace_id int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (workspace_id) | |
); | |
--- 8,13 ---- | |
# Table structure for table 'workspace' | |
# | |
CREATE TABLE workspace ( | |
! workspace_id int(11) NOT NULL, | |
PRIMARY KEY (workspace_id) | |
); | |
diff -crB eee/everything/nodeballs/emessage/tables/message.sql everything/nodeballs/emessage/tables/message.sql | |
*** eee/everything/nodeballs/emessage/tables/message.sql 2002-02-17 20:27:18.000000000 -0800 | |
--- everything/nodeballs/emessage/tables/message.sql 2015-04-19 19:04:36.785794456 -0700 | |
*************** | |
*** 11,18 **** | |
CREATE TABLE message ( | |
message_id int(11) NOT NULL auto_increment, | |
msgtext char(255) DEFAULT '' NOT NULL, | |
! author_user int(11) DEFAULT '0' NOT NULL, | |
! tstamp timestamp(14), | |
! for_user int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (message_id) | |
); | |
--- 11,18 ---- | |
CREATE TABLE message ( | |
message_id int(11) NOT NULL auto_increment, | |
msgtext char(255) DEFAULT '' NOT NULL, | |
! author_user int(11) NOT NULL, | |
! tstamp timestamp, | |
! for_user int(11) NOT NULL, | |
PRIMARY KEY (message_id) | |
); | |
diff -crB eee/everything/nodeballs/stock/tables/stock.sql everything/nodeballs/stock/tables/stock.sql | |
*** eee/everything/nodeballs/stock/tables/stock.sql 2002-02-17 20:27:19.000000000 -0800 | |
--- everything/nodeballs/stock/tables/stock.sql 2015-04-19 18:44:34.785225611 -0700 | |
*************** | |
*** 9,15 **** | |
# | |
CREATE TABLE stock ( | |
! stock_id int(11) DEFAULT '0' NOT NULL, | |
market char(64) DEFAULT 'nyse' NOT NULL, | |
PRIMARY KEY (stock_id) | |
); | |
--- 9,15 ---- | |
# | |
CREATE TABLE stock ( | |
! stock_id int(11) NOT NULL, | |
market char(64) DEFAULT 'nyse' NOT NULL, | |
PRIMARY KEY (stock_id) | |
); | |
diff -crB eee/everything/nodeballs/task/tables/task.sql everything/nodeballs/task/tables/task.sql | |
*** eee/everything/nodeballs/task/tables/task.sql 2002-02-17 20:27:19.000000000 -0800 | |
--- everything/nodeballs/task/tables/task.sql 2015-04-19 18:44:34.785225611 -0700 | |
*************** | |
*** 8,17 **** | |
# Table structure for table 'task' | |
# | |
CREATE TABLE task ( | |
! task_id int(11) DEFAULT '0' NOT NULL, | |
category char(40) DEFAULT 'none' NOT NULL, | |
rating char(40) DEFAULT 'normal' NOT NULL, | |
! owner int(11) DEFAULT '0' NOT NULL, | |
due_date date DEFAULT '0000-00-00' NOT NULL, | |
status char(40) DEFAULT 'open' NOT NULL, | |
PRIMARY KEY (task_id) | |
--- 8,17 ---- | |
# Table structure for table 'task' | |
# | |
CREATE TABLE task ( | |
! task_id int(11) NOT NULL, | |
category char(40) DEFAULT 'none' NOT NULL, | |
rating char(40) DEFAULT 'normal' NOT NULL, | |
! owner int(11) NOT NULL, | |
due_date date DEFAULT '0000-00-00' NOT NULL, | |
status char(40) DEFAULT 'open' NOT NULL, | |
PRIMARY KEY (task_id) | |
diff -crB eee/everything/nodeballs/task/tables/task_update.sql everything/nodeballs/task/tables/task_update.sql | |
*** eee/everything/nodeballs/task/tables/task_update.sql 2002-02-17 20:27:19.000000000 -0800 | |
--- everything/nodeballs/task/tables/task_update.sql 2015-04-19 18:44:34.785225611 -0700 | |
*************** | |
*** 8,16 **** | |
# Table structure for table 'task_update' | |
# | |
CREATE TABLE task_update ( | |
! task_update_id int(11) DEFAULT '0' NOT NULL, | |
updatetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
update_type char(40) DEFAULT '' NOT NULL, | |
! parent_task int(11) DEFAULT '0' NOT NULL, | |
PRIMARY KEY (task_update_id) | |
); | |
--- 8,16 ---- | |
# Table structure for table 'task_update' | |
# | |
CREATE TABLE task_update ( | |
! task_update_id int(11) NOT NULL, | |
updatetime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
update_type char(40) DEFAULT '' NOT NULL, | |
! parent_task int(11) NOT NULL, | |
PRIMARY KEY (task_update_id) | |
); | |
diff -crB eee/everything/tables/node.sql everything/tables/node.sql | |
*** eee/everything/tables/node.sql 2001-02-09 00:28:40.000000000 -0800 | |
--- everything/tables/node.sql 2015-04-19 18:44:34.790225040 -0700 | |
*************** | |
*** 10,24 **** | |
CREATE TABLE node ( | |
node_id int(11) NOT NULL auto_increment, | |
! type_nodetype int(11) DEFAULT '0' NOT NULL, | |
title char(240) DEFAULT '' NOT NULL, | |
! author_user int(11) DEFAULT '0' NOT NULL, | |
createtime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
! hits int(11) DEFAULT '0', | |
! loc_location int(11) DEFAULT '0', | |
! reputation int(11) DEFAULT '0' NOT NULL, | |
! lockedby_user int(11) DEFAULT '0' NOT NULL, | |
locktime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
authoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
groupaccess char(5) DEFAULT 'iiiii' NOT NULL, | |
--- 10,24 ---- | |
CREATE TABLE node ( | |
node_id int(11) NOT NULL auto_increment, | |
! type_nodetype int(11) NOT NULL, | |
title char(240) DEFAULT '' NOT NULL, | |
! author_user int(11) NOT NULL, | |
createtime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
modified datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
! hits int(11) , | |
! loc_location int(11) , | |
! reputation int(11) NOT NULL, | |
! lockedby_user int(11) NOT NULL, | |
locktime datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
authoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
groupaccess char(5) DEFAULT 'iiiii' NOT NULL, | |
diff -crB eee/everything/tables/nodetype.sql everything/tables/nodetype.sql | |
*** eee/everything/tables/nodetype.sql 2001-01-22 16:45:40.000000000 -0800 | |
--- everything/tables/nodetype.sql 2015-04-19 18:44:34.789225154 -0700 | |
*************** | |
*** 8,17 **** | |
# Table structure for table 'nodetype' | |
# | |
CREATE TABLE nodetype ( | |
! nodetype_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
! restrict_nodetype int(11) DEFAULT '0', | |
! extends_nodetype int(11) DEFAULT '0', | |
! restrictdupes int(11) DEFAULT '0', | |
sqltable char(255), | |
grouptable char(40) DEFAULT '', | |
defaultauthoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
--- 8,17 ---- | |
# Table structure for table 'nodetype' | |
# | |
CREATE TABLE nodetype ( | |
! nodetype_id int(11) NOT NULL auto_increment, | |
! restrict_nodetype int(11) , | |
! extends_nodetype int(11) , | |
! restrictdupes int(11) , | |
sqltable char(255), | |
grouptable char(40) DEFAULT '', | |
defaultauthoraccess char(4) DEFAULT 'iiii' NOT NULL, | |
diff -crB eee/everything/tables/setting.sql everything/tables/setting.sql | |
*** eee/everything/tables/setting.sql 2000-03-14 23:55:10.000000000 -0800 | |
--- everything/tables/setting.sql 2015-04-19 18:44:34.790225040 -0700 | |
*************** | |
*** 8,14 **** | |
# Table structure for table 'setting' | |
# | |
CREATE TABLE setting ( | |
! setting_id int(11) DEFAULT '0' NOT NULL auto_increment, | |
vars text NOT NULL, | |
PRIMARY KEY (setting_id) | |
); | |
--- 8,14 ---- | |
# Table structure for table 'setting' | |
# | |
CREATE TABLE setting ( | |
! setting_id int(11) NOT NULL auto_increment, | |
vars text NOT NULL, | |
PRIMARY KEY (setting_id) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment