Author: rhari
Date: Thu May 31 13:59:48 2007
New Revision: 485
URL: http://svn.gna.org/viewcvs/phplinker?rev=485&view=rev
Log:
#223
Modification du dump sql phplinker.sql
Modified:
trunk/doc/phplinker.sql
Modified: trunk/doc/phplinker.sql
URL:
http://svn.gna.org/viewcvs/phplinker/trunk/doc/phplinker.sql?rev=485&r1=484&r2=485&view=diff
==============================================================================
--- trunk/doc/phplinker.sql (original)
+++ trunk/doc/phplinker.sql Thu May 31 13:59:48 2007
@@ -111,14 +111,27 @@
`state` enum('moderated','awaiting_submission_moderation',
'awaiting_update_moderation') collate utf8_bin NOT NULL default
'awaiting_submission_moderation',
`hit` int(11) NOT NULL,
`last_update` datetime NOT NULL,
- `email` varchar(128) collate utf8_bin NOT NULL,
+ `id_webmaster` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `state` (`state`),
KEY `hit` (`hit`),
KEY `last_update` (`last_update`),
- KEY `email` (`email`),
+ KEY `id_webmaster` (`id_webmaster`),
UNIQUE KEY `url+state` (`url`,`state`),
FULLTEXT KEY `description` (`description`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `webmaster`
+--
+
+CREATE TABLE `webmaster` (
+ `id` int(11) NOT NULL auto_increment,
+ `login` varchar(32) collate utf8_bin NOT NULL,
+ `email` varchar(128) collate utf8_bin NOT NULL,
+ PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
_______________________________________________
PHPLinker-commits mailing list
[email protected]
https://mail.gna.org/listinfo/phplinker-commits
