1   # MySQL dump 8.10
2    #
3    # Host: localhost Database: avengers
4    #--------------------------------------------------------
5    # Server version 3.23.27-beta
6    
7    #
8    # Table structure for table 'MyCategories'
9    #
10    
11    DROP TABLE IF EXISTS MyCategories;
12    CREATE TABLE MyCategories (
13      CatID bigint(21) NOT NULL auto_increment,
14      CatName varchar(32) DEFAULT '' NOT NULL,
15      CatParent bigint(21),
16      PRIMARY KEY (CatID),
17      UNIQUE CatName (CatName)
18    )/*! type=MyISAM */;
19    
20    #
21    # Dumping data for table 'MyCategories'
22    #
23    
24    LOCK TABLES MyCategories WRITE;
25    INSERT INTO MyCategories VALUES (1,'Linux',NULL),(2,'Projects',1),(3,'Applications',1),(4,'PHP Projects',NULL),(5,'LUGs',NULL),(6,'Sites Using PHP',NULL),(7,'ISP\'s supporting PHP',NULL),(8,'Gamers Network',0),(9,'Gamers Child',8),(10,'TEstingParent',0),(11,'TEstingParent1',0),(12,'TEstingParent2',0),(13,'TEstingParent23',0),(14,'webmasting',NULL),(15,'Gammers Net',14);
26    UNLOCK TABLES;
27    
28    #
29    # Table structure for table 'MyLinks'
30    #
31    
32    DROP TABLE IF EXISTS MyLinks;
33    CREATE TABLE MyLinks (
34      LinkID bigint(21) NOT NULL auto_increment,
35      CatID bigint(21) DEFAULT '0' NOT NULL,
36      Url varchar(255) DEFAULT '' NOT NULL,
37      LinkName varchar(64) DEFAULT '' NOT NULL,
38      Description varchar(255) DEFAULT '' NOT NULL,
39      Approved tinyint(8) DEFAULT '0',
40      SubmitName varchar(64) DEFAULT '' NOT NULL,
41      SubmitEmail varchar(64) DEFAULT '' NOT NULL,
42      SubmitDate bigint(21) DEFAULT '0' NOT NULL,
43      PRIMARY KEY (LinkID),
44      UNIQUE Url (http://www.pccs-linux.com/spacer.gif)
45    )/*! type=MyISAM */;
46    
47    #
48    # Dumping data for table 'MyLinks'
49    #
50    
51    LOCK TABLES MyLinks WRITE;
52    INSERT INTO MyLinks VALUES (1,0,'http://www.hp.com','HP','Printer Drivers',1,'Ch\nauncey THorn','cthorn@localhost',944454477),(2,0,'http://www.linux.com','Linux.com','Linux Relate\nd',1,'Chauncey Thorn','cthorn@localhost',944454559),(3,1,'http://pccs-linux.com','PCCS-Linux','Linux Intr\nanet Networking Consultant',1,'Chauncey Thorn','cthorn',945568790),(4,4,'http://www.pccs-linux.com','PCCS-NRM','A Networ\nk Resource Manager written using \r\nphp',1,'Chauncey Thorn','cthorn\nnet',945569273),(5,5,'http://www.hlug.org','Hardcore Linux User Group\n','Another Linux User Group based in Houston\r\nTx',1,'Chauncey Thorn','cthorn@w\nt.net',945569386),(6,7,'http://pccslinux.com','PCCS-Linux.COM','Testing ',0,'Chauncey Thorn','cthorn@mylaptop',976386859),(7,7,'http://pccslinuxs.com','PCCS-Linux.COM','Testing ',0,'Chauncey Thorn','cthorn@mylaptop',976387071);
53    UNLOCK TABLES;
54    
55    #
56    # Table structure for table 'rand_notes'
57    #
58    
59    DROP TABLE IF EXISTS rand_notes;
60    CREATE TABLE rand_notes (
61      id int(11) NOT NULL auto_increment,
62      title varchar(200),
63      notebody longtext,
64      PRIMARY KEY (id),
65      KEY notes_id (id)
66    )/*! type=MyISAM */;
67    
68    #
69    # Dumping data for table 'rand_notes'
70    #
71    
72    LOCK TABLES rand_notes WRITE;
73    UNLOCK TABLES;
74    
75