+++ /dev/null
--- --------------------------------------------------------\r
-\r
---\r
--- Table structure for table `members`\r
---\r
-\r
-CREATE TABLE IF NOT EXISTS `members` (\r
- `member_id` mediumint(9) unsigned NOT NULL AUTO_INCREMENT,\r
- `login` varchar(20) NOT NULL,\r
- `password` varchar(40) NOT NULL,\r
- `name` varchar(255) NOT NULL,\r
- `email` varchar(100) NOT NULL,\r
- `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r
- PRIMARY KEY (`member_id`)\r
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;\r
-\r
--- --------------------------------------------------------\r
-\r
---\r
--- Table structure for table `projects`\r
---\r
-\r
-CREATE TABLE IF NOT EXISTS `projects` (\r
- `project_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,\r
- `member_id` mediumint(8) unsigned NOT NULL,\r
- `name` varchar(255) NOT NULL,\r
- `video_file` varchar(255) NOT NULL,\r
- `layout_preset` tinyint(3) unsigned NOT NULL,\r
- `last_accessed` datetime NOT NULL,\r
- PRIMARY KEY (`project_id`)\r
-) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;\r