2005.01-data.sql

cnForums是功能强大的论坛。开发语言c#,三层结构。模块设计很值得学习

SET IDENTITY_INSERT forums_Forums OFF

/*=========================================================
Ranks (default list)
=========================================================*/
INSERT INTO forums_Ranks VALUES ('新手上路',	0,	99,	'')
INSERT INTO forums_Ranks VALUES ('一般站友',	100,	499,	'')
INSERT INTO forums_Ranks VALUES ('中级站友',	450,	849,	'')
INSERT INTO forums_Ranks VALUES ('高级站友',	850,	1499,	'')
INSERT INTO forums_Ranks VALUES ('老站友',	1500,	2499,	'')
INSERT INTO forums_Ranks VALUES ('长老级',	2500,	4999,	'')
INSERT INTO forums_Ranks VALUES ('本站元老',	5000,	99999,	'')
GO

/*=========================================================
WORD CENSORS (default list)
=========================================================*/
print 'Creating a default list of censored words...'
INSERT INTO forums_Censorship VALUES ('dyke', '***')
INSERT INTO forums_Censorship VALUES ('shit', '***')
INSERT INTO forums_Censorship VALUES ('amcik', '***')
INSERT INTO forums_Censorship VALUES ('arse', '***')
INSERT INTO forums_Censorship VALUES ('asshole', '***')
INSERT INTO forums_Censorship VALUES ('assramer', '***')
INSERT INTO forums_Censorship VALUES ('atouche', '***')
INSERT INTO forums_Censorship VALUES ('ayir', '***')
INSERT INTO forums_Censorship VALUES ('b17ch', '***')
INSERT INTO forums_Censorship VALUES ('b1tch', '***')
INSERT INTO forums_Censorship VALUES ('bastard', '***')
INSERT INTO forums_Censorship VALUES ('bi7ch', '***')
INSERT INTO forums_Censorship VALUES ('bitch', '***')
INSERT INTO forums_Censorship VALUES ('boiolas', '***')
INSERT INTO forums_Censorship VALUES ('bollock', '***')
INSERT INTO forums_Censorship VALUES ('breast', '***')
INSERT INTO forums_Censorship VALUES ('c0ck', '***')
INSERT INTO forums_Censorship VALUES ('cabron', '***')
INSERT INTO forums_Censorship VALUES ('cawk', '***')
INSERT INTO forums_Censorship VALUES ('cazzo', '***')
INSERT INTO forums_Censorship VALUES ('chink', '***')
INSERT INTO forums_Censorship VALUES ('chraa', '***')
INSERT INTO forums_Censorship VALUES ('chuj', '***')
INSERT INTO forums_Censorship VALUES ('cipa', '***')
INSERT INTO forums_Censorship VALUES ('clit', '***')
INSERT INTO forums_Censorship VALUES ('clits', '***')
INSERT INTO forums_Censorship VALUES ('cock', '***')
INSERT INTO forums_Censorship VALUES ('cum', '***')
INSERT INTO forums_Censorship VALUES ('cunt', '***')
INSERT INTO forums_Censorship VALUES ('d4mn', '***')
INSERT INTO forums_Censorship VALUES ('dago', '***')
INSERT INTO forums_Censorship VALUES ('daygo', '***')
INSERT INTO forums_Censorship VALUES ('dego', '***')
INSERT INTO forums_Censorship VALUES ('dick', '***')
INSERT INTO forums_Censorship VALUES ('dildo', '***')
INSERT INTO forums_Censorship VALUES ('dirsa', '***')
INSERT INTO forums_Censorship VALUES ('dupa', '***')
INSERT INTO forums_Censorship VALUES ('dziwka', '***')
INSERT INTO forums_Censorship VALUES ('ekrem', '***')
INSERT INTO forums_Censorship VALUES ('ekto', '***')
INSERT INTO forums_Censorship VALUES ('enculer', '***')
INSERT INTO forums_Censorship VALUES ('faen', '***')
INSERT INTO forums_Censorship VALUES ('fag', '***')
INSERT INTO forums_Censorship VALUES ('fancul', '***')
INSERT INTO forums_Censorship VALUES ('fatass', '***')
INSERT INTO forums_Censorship VALUES ('fcuk', '***')
INSERT INTO forums_Censorship VALUES ('feces', '***')
INSERT INTO forums_Censorship VALUES ('ficken', '***')
INSERT INTO forums_Censorship VALUES ('fitta', '***')
INSERT INTO forums_Censorship VALUES ('fitte', '***')
INSERT INTO forums_Censorship VALUES ('flikker', '***')
INSERT INTO forums_Censorship VALUES ('fotze', '***')
INSERT INTO forums_Censorship VALUES ('fuk', '***')
INSERT INTO forums_Censorship VALUES ('fuck', '***')
INSERT INTO forums_Censorship VALUES ('futkretzn', '***')
INSERT INTO forums_Censorship VALUES ('fux0r', '***')
INSERT INTO forums_Censorship VALUES ('guiena', '***')
INSERT INTO forums_Censorship VALUES ('h0r', '***')
INSERT INTO forums_Censorship VALUES ('h4x0r', '***')
INSERT INTO forums_Censorship VALUES ('helvete', '***')
INSERT INTO forums_Censorship VALUES ('hoer', '***')
INSERT INTO forums_Censorship VALUES ('honkey', '***')
INSERT INTO forums_Censorship VALUES ('Huevon', '***')
INSERT INTO forums_Censorship VALUES ('hui', '***')
INSERT INTO forums_Censorship VALUES ('injun', '***')
INSERT INTO forums_Censorship VALUES ('kawk', '***')
INSERT INTO forums_Censorship VALUES ('kike', '***')
INSERT INTO forums_Censorship VALUES ('ootzak', '***')
INSERT INTO forums_Censorship VALUES ('knulle', '***')
INSERT INTO forums_Censorship VALUES ('kraut', '***')
INSERT INTO forums_Censorship VALUES ('kuk', '***')
INSERT INTO forums_Censorship VALUES ('kuksuger', '***')
INSERT INTO forums_Censorship VALUES ('Kurac', '***')
INSERT INTO forums_Censorship VALUES ('kurwa', '***')
INSERT INTO forums_Censorship VALUES ('kusi', '***')
INSERT INTO forums_Censorship VALUES ('kyrp', '***')
INSERT INTO forums_Censorship VALUES ('lesbo', '***')
INSERT INTO forums_Censorship VALUES ('mamhoon', '***')
INSERT INTO forums_Censorship VALUES ('merd', '***')
INSERT INTO forums_Censorship VALUES ('merde', '***')
INSERT INTO forums_Censorship VALUES ('mibun', '***')
INSERT INTO forums_Censorship VALUES ('monkleigh', '***')
INSERT INTO forums_Censorship VALUES ('motherfucker', '***')
INSERT INTO forums_Censorship VALUES ('mouliewop', '***')
INSERT INTO forums_Censorship VALUES ('muie', '***')
INSERT INTO forums_Censorship VALUES ('mulkku', '***')
INSERT INTO forums_Censorship VALUES ('muschi', '***')
INSERT INTO forums_Censorship VALUES ('nazis', '***')
INSERT INTO forums_Censorship VALUES ('nepesaurio', '***')
INSERT INTO forums_Censorship VALUES ('nigga', '***')
INSERT INTO forums_Censorship VALUES ('nigger', '***')
INSERT INTO forums_Censorship VALUES ('nutsack', '***')
INSERT INTO forums_Censorship VALUES ('orospu', '***')
INSERT INTO forums_Censorship VALUES ('paska', '***')
INSERT INTO forums_Censorship VALUES ('pendejo', '***')
INSERT INTO forums_Censorship VALUES ('penisperse', '***')
INSERT INTO forums_Censorship VALUES ('phuck', '***')
INSERT INTO forums_Censorship VALUES ('picka', '***')
INSERT INTO forums_Censorship VALUES ('pierdol', '***')
INSERT INTO forums_Censorship VALUES ('pillu', '***')
INSERT INTO forums_Censorship VALUES ('pimmel', '***')
INSERT INTO forums_Censorship VALUES ('pimpis', '***')
INSERT INTO forums_Censorship VALUES ('pizdapoontsee', '***')
INSERT INTO forums_Censorship VALUES ('pr0n', '***')
INSERT INTO forums_Censorship VALUES ('preteen', '***')
INSERT INTO forums_Censorship VALUES ('preud', '***')
INSERT INTO forums_Censorship VALUES ('prick', '***')
INSERT INTO forums_Censorship VALUES ('pula', '***')
INSERT INTO forums_Censorship VALUES ('pule', '***')
INSERT INTO forums_Censorship VALUES ('pusse', '***')
INSERT INTO forums_Censorship VALUES ('pussy', '***')
INSERT INTO forums_Censorship VALUES ('puta', '***')
INSERT INTO forums_Censorship VALUES ('puto', '***')
INSERT INTO forums_Censorship VALUES ('qaHbeh', '***')
INSERT INTO forums_Censorship VALUES ('queef', '***')
INSERT INTO forums_Censorship VALUES ('queer', '***')
INSERT INTO forums_Censorship VALUES ('qweef', '***')
INSERT INTO forums_Censorship VALUES ('rautenbergschaffer', '***')
INSERT INTO forums_Censorship VALUES ('scheiss', '***')
INSERT INTO forums_Censorship VALUES ('scheisse', '***')
INSERT INTO forums_Censorship VALUES ('schlampe', '***')
INSERT INTO forums_Censorship VALUES ('schmuck', '***')
INSERT INTO forums_Censorship VALUES ('scrotum', '***')
INSERT INTO forums_Censorship VALUES ('sharmuta', '***')
INSERT INTO forums_Censorship VALUES ('sharmute', '***')
INSERT INTO forums_Censorship VALUES ('shemale', '***')
INSERT INTO forums_Censorship VALUES ('shipal', '***')
INSERT INTO forums_Censorship VALUES ('shiz', '***')
INSERT INTO forums_Censorship VALUES ('shiat', '***')
INSERT INTO forums_Censorship VALUES ('Skribz', '***')
INSERT INTO forums_Censorship VALUES ('skurwysyn', '***')
INSERT INTO forums_Censorship VALUES ('slut', '***')
INSERT INTO forums_Censorship VALUES ('sphencter', '***')
INSERT INTO forums_Censorship VALUES ('spic', '***')
INSERT INTO forums_Censorship VALUES ('spierdalaj', '***')
INSERT INTO forums_Censorship VALUES ('splooge', '***')
INSERT INTO forums_Censorship VALUES ('suka', '***')
INSERT INTO forums_Censorship VALUES ('tits', '***')
INSERT INTO forums_Censorship VALUES ('twatty', '***')
--INSERT INTO forums_Censorship VALUES ('javascript\:', 'BLOCKED SCRIPT')
--INSERT INTO forums_Censorship VALUES ('jscript\:', 'BLOCKED SCRIPT')
--INSERT INTO forums_Censorship VALUES ('vbscript\:', 'BLOCKED SCRIPT')
--INSERT INTO forums_Censorship VALUES ('expression\(*.\)', 'BLOCKED EXPRESSION')

GO

/*=========================================================
SMILIES (default list)
=========================================================*/
print 'Creating the default smilies...'
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':)', 'emoticons/emotion-1.gif', 'Smile', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':D', 'emoticons/emotion-2.gif', 'Big Smile', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':O', 'emoticons/emotion-3.gif', 'Surprise', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':P', 'emoticons/emotion-4.gif', 'Stick out tongue', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (';)', 'emoticons/emotion-5.gif', 'Wink', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':(', 'emoticons/emotion-6.gif', 'Sad', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':S', 'emoticons/emotion-7.gif', 'Tongue Tied', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':|', 'emoticons/emotion-8.gif', 'Indifferent', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':''(', 'emoticons/emotion-9.gif', 'Crying', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':$', 'emoticons/emotion-10.gif', 'Embarrassed', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('H', 'emoticons/emotion-11.gif', 'Cool', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':@', 'emoticons/emotion-12.gif', 'Angry', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('A', 'emoticons/emotion-13.gif', 'Angel', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('6', 'emoticons/emotion-14.gif', 'Devil', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('8-|', 'emoticons/emotion-15.gif', '[8-|]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':#', 'emoticons/emotion-16.gif', '[:#]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':-*', 'emoticons/emotion-17.gif', '[:-*]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES (':^)', 'emoticons/emotion-18.gif', '[:^)]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('<:o)', 'emoticons/emotion-19.gif', '[<:o)]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('|-)', 'emoticons/emotion-20.gif', '[|-)]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('Y', 'emoticons/emotion-21.gif', 'Yes', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('B', 'emoticons/emotion-22.gif', 'Beer', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('{', 'emoticons/emotion-24.gif', 'Left Hug', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('8', 'emoticons/emotion-29.gif', 'Music', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('*', 'emoticons/emotion-30.gif', 'Star', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('O', 'emoticons/emotion-31.gif', 'Time', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('sn', 'emoticons/emotion-32.gif', 'Snail', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('pi', 'emoticons/emotion-33.gif', 'Pizza', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('au', 'emoticons/emotion-34.gif', 'Automobile', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('um', 'emoticons/emotion-35.gif', 'Umbrella', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('co', 'emoticons/emotion-36.gif', 'Computer', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('st', 'emoticons/emotion-37.gif', 'Storm', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('mo', 'emoticons/emotion-38.gif', '[mo]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('8o|', 'emoticons/emotion-39.gif', '[8o|]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('^o)', 'emoticons/emotion-40.gif', '[^o)]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('+o(', 'emoticons/emotion-41.gif', '[+o(]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('*-)', 'emoticons/emotion-42.gif', '[*-)]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('8-)', 'emoticons/emotion-43.gif', '[8-)]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('C', 'emoticons/emotion-44.gif', 'Coffee', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('N', 'emoticons/emotion-45.gif', 'No', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('D', 'emoticons/emotion-46.gif', 'Drinks', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('Z', 'emoticons/emotion-47.gif', '[Z]', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('}', 'emoticons/emotion-48.gif', 'Right Hug', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('^', 'emoticons/emotion-49.gif', 'Cake', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('U', 'emoticons/emotion-50.gif', 'Broken Heart', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('G', 'emoticons/emotion-51.gif', 'Gift', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('W', 'emoticons/emotion-52.gif', 'Wilted Flower', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('~', 'emoticons/emotion-53.gif', 'Movie', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('&', 'emoticons/emotion-54.gif', 'Dog', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('I', 'emoticons/emotion-55.gif', 'Idea', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('S', 'emoticons/emotion-56.gif', 'Sleep', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('E', 'emoticons/emotion-57.gif', 'Email', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('ap', 'emoticons/emotion-58.gif', 'Travel', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('ip', 'emoticons/emotion-59.gif', 'Paradise', 0)
INSERT INTO forums_Smilies (SmileyCode, SmileyUrl, SmileyText, BracketSafe) VALUES ('li', 'emoticons/emotion-60.gif', 'Lightning', 0)


GO