sql/create_nodes.sql

   1 -- MySQL dump 9.08
   2 --
   3 -- Host: localhost    Database: kyberia2
   4 ---------------------------------------------------------
   5 -- Server version       4.0.15a-log
   6
   7 --
   8 -- Table structure for table 'nodes'
   9 --
  10
  11 CREATE TABLE nodes (
  12   node_id int(13) NOT NULL auto_increment,
  13   node_name char(132) default NULL,
  14   node_parent int(13) NOT NULL default '0',
  15   node_thread_vector char(123) default '0',
  16   node_type int(2) default '1',
  17   node_template enum('default','own') default 'default',
  18   node_external_access enum('yes','no') default 'no',
  19   node_system_access enum('public','moderated','private','personal','crypto') default 'public',
  20   node_children_count int(11) default '0',
  21   node_creator int(13) default NULL,
  22   node_created datetime default NULL,
  23   lastchild_created timestamp(14) NOT NULL,
  24   k int(5) default 0,
  25   on_main enum('yes','no') default 'no',
  26   old_id int(11) default NULL,
  27   old_owner_id int(11) default NULL,
  28   old_id_diskuse int(11) default NULL,
  29   node_views int(8) default NULL,
  30   old_type char(20) default NULL,
  31   PRIMARY KEY  (node_id),
  32   KEY old_id (old_id),
  33   KEY node_parent (node_parent)
  34 ) TYPE=MyIsam;
  35
  36 --
  37 -- Dumping data for table 'nodes'
  38 --
  39
  40 INSERT INTO nodes VALUES (1,'main',1,';1',1,'default','no','public',0,1,NULL,20031203022433,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  41 INSERT INTO nodes VALUES (2,'nodeshell',1,';1',2,'default','no','public',0,1,NULL,20031203022443,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  42 INSERT INTO nodes VALUES (3,'forum',1,';1',3,'default','no','public',0,1,NULL,20031203022449,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  43 INSERT INTO nodes VALUES (4,'submission',1,';1',4,'default','no','public',0,1,NULL,20031203022459,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  44 INSERT INTO nodes VALUES (5,'article',1,';1',5,'default','no','public',0,1,NULL,20031203022508,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  45 INSERT INTO nodes VALUES (6,'blog',1,';1',6,'default','no','public',0,1,NULL,20031203022514,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  46 INSERT INTO nodes VALUES (7,'user',1,';1',7,'default','no','public',0,1,NULL,20031203022521,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  47 INSERT INTO nodes VALUES (8,'friend',1,';1',8,'default','no','public',0,1,NULL,20031203022532,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  48 INSERT INTO nodes VALUES (9,'threaded_forum',1,';1',9,'default','no','public',0,1,NULL,20031203022604,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  49 INSERT INTO nodes VALUES (10,'bookcat',1,';1',10,'default','no','public',0,1,NULL,20031203022612,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  50 INSERT INTO nodes VALUES (11,'poll',1,';1',11,'default','no','public',0,1,NULL,20031203022616,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  51 INSERT INTO nodes VALUES (12,'data',1,';1',12,'default','no','public',0,1,NULL,20031203022620,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  52 INSERT INTO nodes VALUES (13,'rss',1,';1',13,'default','no','public',0,1,NULL,20031203022624,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  53 INSERT INTO nodes VALUES (14,'template',1,';1',14,'default','no','public',0,1,NULL,20031203022630,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  54 INSERT INTO nodes VALUES (15,'k',1,';1',15,'default','no','public',0,1,NULL,20031203022634,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  55 INSERT INTO nodes VALUES (16,'bazar',1,';1',16,'default','no','public',0,1,NULL,20031203022650,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  56 INSERT INTO nodes VALUES (17,'chat',1,';1',17,'default','no','public',0,1,NULL,20031203022654,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  57 INSERT INTO nodes VALUES (18,'literature',1,';1',18,'default','no','public',0,1,NULL,20031203022703,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  58 INSERT INTO nodes VALUES (19,'bookmarks',1,';1',19,'default','no','public',0,1,NULL,20031203022703,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  59 INSERT INTO nodes VALUES (20,'articles',1,';1',20,'default','no','public',0,1,NULL,20031203022703,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  60 INSERT INTO nodes VALUES (21,'blogs',1,';1',21,'default','no','public',0,1,NULL,20031203022703,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  61 INSERT INTO nodes VALUES (22,'offtopic',1,';1',22,'default','no','public',0,1,NULL,20031203022703,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  62 INSERT INTO nodes VALUES (23,'last',1,';1',23,'default','no','public',0,1,NULL,20031203022703,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  63 INSERT INTO nodes VALUES (100,'tiamat',1,';1',100,'default','no','public',0,1,NULL,20031203022913,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  64 INSERT INTO nodes VALUES (101,'kyberia',1,';1',2,'default','no','public',0,1,NULL,20031203022913,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  65 INSERT INTO nodes VALUES (102,'hysteria',1,';1',2,'default','no','public',0,1,NULL,20031203022913,NULL,'no',NULL,NULL,NULL,NULL,NULL);
  66 INSERT INTO nodes VALUES (103,'camp23',1,';1',2,'default','no','public',0,1,NULL,20031203022913,NULL,'no',NULL,NULL,NULL,NULL,NULL);