data.sql

jsp程序开发系统

DELETE FROM admin_help_cat;
DELETE FROM admin_help_entry;
DELETE FROM tech_internal_help_cat;
DELETE FROM tech_internal_help_entry;
DELETE FROM user_help;
DELETE FROM user_help_cats;
DELETE FROM user_help_entries;
DELETE FROM user_help_cats_entries;
DELETE FROM template_words_cat;
DELETE FROM template_cat;
INSERT INTO template_cat VALUES (1,'Header and Footer','Header and Footer templates');
INSERT INTO template_cat VALUES (2,'View Ticket','Templates that generate the View Ticket pages');
INSERT INTO template_cat VALUES (4,'Register','Templates that generate user registration pages');
INSERT INTO template_cat VALUES (5,'Front Page','Templates used for general user area pages');
INSERT INTO template_cat VALUES (7,'Redirect Notifications','Templates that generate redirects');
INSERT INTO template_cat VALUES (8,'Error Messages','Error message templates');
INSERT INTO template_cat VALUES (9,'HTML bits','Individual HTML components used by other templates');
INSERT INTO template_cat VALUES (10,'The FAQ','Knowledgebase/FAQ templates');
INSERT INTO template_cat VALUES (11,'New Ticket','Templates that generate the new ticket pages');
INSERT INTO template_cat VALUES (13,'Ticket Listing','Templates that generate ticket lists');
INSERT INTO template_cat VALUES (17,'Profile','Templates that generate the user profile pages');
INSERT INTO template_cat VALUES (18,'Help','Help page templates');
INSERT INTO template_cat VALUES (19,'Tech Emails','E-mails sent to technicians');
INSERT INTO template_words_cat VALUES (1,'Header and Footer',0);
INSERT INTO template_words_cat VALUES (2,'FAQ',0);
INSERT INTO template_words_cat VALUES (3,'Ask a Question',0);
INSERT INTO template_words_cat VALUES (4,'Settings',0);
INSERT INTO template_words_cat VALUES (5,'Register',0);
INSERT INTO template_words_cat VALUES (6,'ticketlist',0);
INSERT INTO template_words_cat VALUES (7,'View Question',0);
INSERT INTO template_words_cat VALUES (8,'Front Page',0);
INSERT INTO template_words_cat VALUES (9,'Redirects',0);
INSERT INTO template_words_cat VALUES (10,'Error Messages',0);
INSERT INTO admin_help_cat VALUES (4,'Introduction',0);
INSERT INTO admin_help_cat VALUES (5,'General Help',0);
INSERT INTO admin_help_cat VALUES (6,'Tickets',0);
INSERT INTO admin_help_cat VALUES (7,'Calendar',0);
INSERT INTO admin_help_cat VALUES (8,'Teamwork',0);
INSERT INTO admin_help_cat VALUES (9,'Settings',0);
INSERT INTO admin_help_cat VALUES (10,'The FAQ',0);
INSERT INTO admin_help_cat VALUES (11,'Resources',0);