Subversion Repositories php_guestbook

Rev

Blame | Last modification | View Log | RSS feed

  1. -- Achtung, nicht kompatibel mit 1.x Daten
  2.  
  3. -- DROP TABLE `gaestebuch_entries`;
  4.  
  5. CREATE TABLE `gaestebuch_entries` (
  6.   `id` BIGINT(21) NOT NULL AUTO_INCREMENT,
  7.   `name` VARCHAR(80) NOT NULL DEFAULT '',
  8.   `ort` VARCHAR(80) DEFAULT NULL,
  9.   `email` VARCHAR(80) DEFAULT NULL,
  10.   `homepage` VARCHAR(80) DEFAULT NULL,
  11.   `icq` VARCHAR(80) DEFAULT NULL,
  12.   `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  13.   `ip` VARCHAR(39),
  14.   `nachricht` text NOT NULL,
  15.   `kommentar` text,
  16.   `show` enum('0','1') NOT NULL DEFAULT '0',
  17.   PRIMARY KEY  (`id`)
  18. ) ;
  19.  
  20. -- DROP TABLE `gaestebuch_smileys`;
  21.  
  22. CREATE TABLE `gaestebuch_smileys` (
  23.   `id` BIGINT(21) NOT NULL AUTO_INCREMENT,
  24.   `zeichen` VARCHAR(20) BINARY NOT NULL DEFAULT '',
  25.   `image` VARCHAR(80) NOT NULL DEFAULT '',
  26.   `beschreibung` VARCHAR(255) NOT NULL DEFAULT '',
  27.   `show_in_editor` enum('1','0') NOT NULL DEFAULT '1',
  28.   `enabled` enum('1','0') NOT NULL DEFAULT '1',
  29.   PRIMARY KEY  (`id`),
  30.   UNIQUE ( `zeichen` )
  31. ) ;
  32.  
  33. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':?:', 'frage.gif', 'Fragezeichen', '1');
  34. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':!:', 'ausrufez.gif', 'Ausrufezeichen', '1');
  35. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':alien:', 'alien.gif', 'Alien', '1');
  36. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':confused:', 'confused.gif', 'verwirrt', '1');
  37. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':cool:', 'cool.gif', 'cool', '1');
  38. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':hehe:', 'hehe.gif', 'hehe', '1');
  39. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':lol:', 'lol.gif', 'lachen', '1');
  40. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':pissed:', 'pissed.gif', 'Zähne fletschen', '1');
  41. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':eek:', 'eek.gif', 'boah', '1');
  42. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':cry:', 'cry.gif', 'weinen', '0');
  43. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':king:', 'king.gif', 'König', '1');
  44. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':mad:', 'mad.gif', 'wütend', '0');
  45. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':blah:', 'blah.gif', 'blöd', '1');
  46. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':tot:', 'death.gif', 'tot', '1');
  47. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':angry:', 'angry.gif', 'böse', '1');
  48. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':roll:', 'rolleyes.gif', 'Augen verdrehen', '1');
  49. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':ass:', 'ass.gif', 'Arsch', '1');
  50. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES ('::)', 'rolleyes.gif', 'Augen verdrehen', '0');
  51. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':)', 'smile.gif', 'fröhlich', '0');
  52. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':(', 'frown.gif', 'traurig', '0');
  53. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':D', 'biggrin.gif', 'breites Grinsen', '0');
  54. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (';D', 'biggrin.gif', 'breites Grinsen', '0');
  55. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (';)', 'wink.gif', 'zwinker', '0');
  56. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':p', 'tongue.gif', 'bäää', '0');
  57. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-o', 'redface.gif', 'verlegen', '0');
  58. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES ('???', 'confused.gif', 'verwirrt', '0');
  59. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES ('8)', 'cool.gif', 'cool', '0');
  60. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':\'-(', 'cry.gif', 'weinen', '1');
  61. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':[', 'frown.gif', 'traurig', '0');
  62. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-[', 'frown.gif', 'traurig', '0');
  63. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-X', '005.gif', 'schweigen', '1');
  64. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':X', '005.gif', 'schweigen', '0');
  65. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-*', '007.gif', 'kuss', '1');
  66. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':*', '007.gif', 'kuss', '0');
  67. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES ('>:(', 'mad.gif', 'wütend', '1');
  68. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-/', '004.gif', 'gnumpf', '1');
  69. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-)', 'smile.gif', 'fröhlich', '1');
  70. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-(', 'frown.gif', 'traurig', '1');
  71. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':-D', 'biggrin.gif', 'breites Grinsen', '1');
  72. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (';-)', 'wink.gif', 'zwinker', '1');
  73. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':P', 'tongue.gif', 'bäää', '1');
  74. INSERT INTO `gaestebuch_smileys` (`zeichen`, `image`, `beschreibung`, `show_in_editor`) VALUES (':o', 'redface.gif', 'verlegen', '1');
  75.