1 -- --------------------------------------------------------
\r
4 -- Table structure for table `members`
\r
7 CREATE TABLE IF NOT EXISTS `members` (
\r
8 `member_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,
\r
9 `login` varchar(20) NOT NULL,
\r
10 `password` varchar(40) NOT NULL,
\r
11 `name` varchar(255) NOT NULL,
\r
12 `email` varchar(100) NOT NULL,
\r
13 `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
\r
14 PRIMARY KEY (`member_id`)
\r
15 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
\r
17 -- --------------------------------------------------------
\r
20 -- Table structure for table `projects`
\r
23 CREATE TABLE IF NOT EXISTS `projects` (
\r
24 `project_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
\r
25 `member_id` mediumint(8) unsigned NOT NULL,
\r
26 `name` varchar(255) NOT NULL,
\r
27 `video_file` varchar(255) NOT NULL,
\r
28 `layout_preset` tinyint(3) unsigned NOT NULL,
\r
29 `last_accessed` datetime NOT NULL,
\r
30 PRIMARY KEY (`project_id`)
\r
31 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
\r