1  # MySQL dump 7.1
2  #
3  # Host: localhost Database: eitsdb
4  #--------------------------------------------------------
5  # Server version 3.22.32
6 
7  #
8  # Table structure for table 'MyCategories'
9  #
10  DROP TABLE IF EXISTS MyCategories;
11  CREATE TABLE MyCategories (
12    CatID bigint(21) DEFAULT '0' NOT NULL auto_increment,
13    CatName varchar(32) DEFAULT '' NOT NULL,
14    CatParent bigint(21),
15    PRIMARY KEY (CatID),
16    UNIQUE CatName (CatName)
17  );
18 
19  #
20  # Dumping data for table 'MyCategories'
21  #
22 
23  LOCK TABLES MyCategories WRITE;
24  UNLOCK TABLES;
25 
26  #
27  # Table structure for table 'MyLinks'
28  #
29  DROP TABLE IF EXISTS MyLinks;
30  CREATE TABLE MyLinks (
31    LinkID bigint(21) DEFAULT '0' NOT NULL auto_increment,
32    CatID bigint(21) DEFAULT '0' NOT NULL,
33    Url varchar(255) DEFAULT '' NOT NULL,
34    LinkName varchar(64) DEFAULT '' NOT NULL,
35    Description varchar(255) DEFAULT '' NOT NULL,
36    Approved tinyint(8) DEFAULT '0',
37    SubmitName varchar(64) DEFAULT '' NOT NULL,
38    SubmitEmail varchar(64) DEFAULT '' NOT NULL,
39    SubmitDate bigint(21) DEFAULT '0' NOT NULL,
40    PRIMARY KEY (LinkID),
41    UNIQUE Url (http://www.pccs-linux.com/spacer.gif)
42  );
43 
44  #
45  # Dumping data for table 'MyLinks'
46  #
47 
48  LOCK TABLES MyLinks WRITE;
49  UNLOCK TABLES;
50 
51  #
52  # Table structure for table 'news'
53  #
54  DROP TABLE IF EXISTS news;
55  CREATE TABLE news (
56    news_id int(11) DEFAULT '0' NOT NULL auto_increment,
57    news_story_title varchar(80) DEFAULT '' NOT NULL,
58    news_story_html text,
59    news_story_active int(11) DEFAULT '0' NOT NULL,
60    news_story_test int(11) DEFAULT '0' NOT NULL,
61    news_story_author varchar(20),
62    news_story_date datetime DEFAULT ':00:00' NOT NULL,
63    news_story_order int(11),
64    news_story_arch int(11) DEFAULT '0' NOT NULL,
65    PRIMARY KEY (news_id)
66  );
67 
68  #
69  # Dumping data for table 'news'
70  #
71 
72  LOCK TABLES news WRITE;
73  INSERT INTO news VALUES (6,'Houston News','A project to convert all network printers to IP has begun. This will permit a significant improvement in reliability and support requirements. \r\n<p>\r\n The bid for the fiber run to facilitate the relocation of Lone Star servers to the Houston Data Center has been submitted to Larry Patchell for approval. Lone Star has requested that the relocation be postponed until peak season is over - 9/2000. \r\n<P>\r\n Several improvements were made to the room housing the main communications hub. A new UPS was installed to replace an antiquated one that was failing; the roof was patched to eliminate leaks; and wiring is being upgraded to support growth. \r\n\r\n',1,1,'Webmaster',':57:25',NULL,0),(3,'Building a Strong Foundation for the 21st Century . . .','Desktop 2000 is the next generation of Rohm and Haas Desktop 1. It will provide a uniform, robust and reliable computing environment to everyone at Rohm and Haas. The new desktop will contain updated versions of our standard and optional enterprise software. It will help change the way we do business by providing the foundation tools to enable Rohm and Haas to meet our business goals of Profitable Growth, Operational Efficiency and e-Business.',1,1,'Webmaster',':50:15',NULL,0),(7,'Desktop 2000 Beta 1','Beta 1 of Desktop 2000 is now in production...\r\n\r\nPlease let us know what you think about it..',1,1,'houtca',':58:06',NULL,0),(8,'Welcome to EITS','(Providing Network Solutions Using Linux) \r\nFile/Print Server \r\nApplication Servers \r\nInternet/ Intranet Web Servers \r\nPHP Web Application Development \r\nMySQL Database Install/Support \r\nHOME Firewall/Masq server setup \r\nLinux Terminal Server Support \r\n \r\n',1,1,'houtca',':54:45',NULL,0);
74  UNLOCK TABLES;
75 
76  #
77  # Table structure for table 'rand_notes'
78  #
79  DROP TABLE IF EXISTS rand_notes;
80  CREATE TABLE rand_notes (
81    id int(11) DEFAULT '0' NOT NULL auto_increment,
82    title varchar(200),
83    notebody longtext,
84    PRIMARY KEY (id),
85    KEY notes_id (id)
86  );
87 
88  #
89  # Dumping data for table 'rand_notes'
90  #
91 
92  LOCK TABLES rand_notes WRITE;
93  UNLOCK TABLES;
94 
95  #
96  # Table structure for table 'staff'
97  #
98  DROP TABLE IF EXISTS staff;
99  CREATE TABLE staff (
100    staffid int(11) DEFAULT '0' NOT NULL auto_increment,
101    loginid varchar(10) DEFAULT '' NOT NULL,
102    lname varchar(24) DEFAULT '' NOT NULL,
103    fname varchar(24),
104    tel varchar(16),
105    pager varchar(16),
106    home varchar(16),
107    email varchar(52),
108    function varchar(32),
109    history text,
110    PRIMARY KEY (staffid),
111    KEY loginid_idx (loginid)
112  );
113 
114  #
115  # Dumping data for table 'staff'
116  #
117 
118  LOCK TABLES staff WRITE;
119  INSERT INTO staff VALUES (1,'HOUTCA','THORN','CHAUNCEY','','','','CHAUNCEY THORN','NETWORK ADMINISTATOR','NETWORK MANAGEMENT, SOME SERVER ADMINISTRATION AND APPLICATION SUPPORT.'),(2,'CHENKUN','CHEN','KUNG','','','','CHEN KUNG','NETWORK ADMINISTRATOR','MANAGES MOST NETWORK INFRASTRUCTURE TASK..');
120  UNLOCK TABLES;
121