hui (owner)

Revisions

gist: 178818 Download_button fork
public
Public Clone URL: git://gist.github.com/178818.git
Embed All Files: show embed
Text only #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

CREATE TABLE `newsletters` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(255) NOT NULL,
  `tag` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  `emails_total` int(11) unsigned NOT NULL default '0',
  `emails_sent` int(11) unsigned NOT NULL default '0',
  `sql` varchar(255) NOT NULL,
  `template` text NOT NULL,
  `template_out` text NOT NULL,
  `template_online` text NOT NULL,
  `template_online_out` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
 
CREATE TABLE `newsletters_images` (
  `id` int(11) NOT NULL auto_increment,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `path` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `fspath` varchar(255) default NULL,
  `type` varchar(255) NOT NULL default '',
  `size` int(11) NOT NULL default '0',
  `deleted` tinyint(4) NOT NULL default '0',
  `comment` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8